Penn Computing

University of Pennsylvania
Penn Computing << go backback
IFFS_POSITION_V Table    Tables and Data Elements   Faculty Home   Data Warehouse Home

IFFS_POSITION_V Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.




Data element Definition

APPLICANT_SELECTED

Format VARCHAR2(20)

Indexed? No

May be Null? Yes

Indicates whether (Y) or not (N) an applicant has been selected to fill the position.

APPLICANT_SELECTION_NOTES

Format CLOB

Indexed? No

May be Null? Yes

Full text notes related to the selection of the applicant.

APPLICATION_COUNT

Format NUMBER

Indexed? No

May be Null? Yes

The number of applicants for the position.

APPROVAL_STATUS

Format VARCHAR2(100)

Indexed? No

May be Null? Yes

The detailed approval status (e.g., Approved; Not Submitted; Waiting for Approval) of the position.

CLOSE_DATE

Format DATE

Indexed? No

May be Null? Yes

The date on which the position was or will be closed.

DISCIPLINE

Format VARCHAR2(400)

Indexed? No

May be Null? Yes

The academic discipline, if any was noted, pertaining to the position.

FUNDING_SOURCE

Format VARCHAR2(800)

Indexed? No

May be Null? Yes

The funding sources, if any was noted, for the position.

HIRING_PLAN

Format CLOB

Indexed? No

May be Null? Yes

The hiring plan, if any was noted, for the position.

INSTRUCTIONS

Format CLOB

Indexed? No

May be Null? Yes

The full text of instructions noted for applicants to the position. This text may include HTML markup syntax.

JOB_POSTING_URL

Format VARCHAR2(276)

Indexed? No

May be Null? Yes

The application URL for the posting in the Interfolio Faculty Search system.

JOB_REQUISITION_NUMBER

Format VARCHAR2(400)

Indexed? No

May be Null? Yes

Related job requisition information, if any, for the position.

LOCATION

Format VARCHAR2(800)

Indexed? No

May be Null? Yes

The general geographic work location of the position.

OPEN_DATE

Format DATE

Indexed? No

May be Null? Yes

The date on which the position was or will be opened to accept applications.

PENN_DW_CREATION_DATE

Format DATE

Indexed? No

May be Null? No

The date on which the position record was created in the Data Warehouse.

PENN_DW_LAST_UPDATE_DATE

Format DATE

Indexed? No

May be Null? No

The date on which the position record was last updated in the Data Warehouse.

POSITION_APPROVED

Format VARCHAR2(4)

Indexed? No

May be Null? Yes

Indicates whether (Y) or not (N) the position was approved.

POSITION_CATEGORY

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The high-level categorization (e.g., Faculty; Fellowship) of the position.

POSITION_CLOSED

Format VARCHAR2(4)

Indexed? No

May be Null? Yes

Indicates whether (Y) or not (N) the position has been closed.

POSITION_CREATION_DATE

Format DATE

Indexed? No

May be Null? Yes

The date on which the position was created in the Interfolio system.

POSITION_DESCRIPTION

Format CLOB

Indexed? No

May be Null? Yes

The full text description of the position. This text may include HTML markup syntax.

POSITION_ID

Format NUMBER

Indexed? Yes

May be Null? No

The system ID of a position posting in the Interfolio system.

POSITION_NOTES

Format CLOB

Indexed? No

May be Null? Yes

Additional descriptive notes related to the processing of the position.

POSITION_START_DATE

Format DATE

Indexed? No

May be Null? Yes

The date on which employment in the position is expected to start.

POSITION_STATUS

Format VARCHAR2(800)

Indexed? No

May be Null? Yes

The status indicating where a position is within the search process (e.g., Accepting Applications; Position Filled).

POSITION_TERM_NAME

Format VARCHAR2(100)

Indexed? No

May be Null? Yes

The work period term, if noted, for the position.

POSITION_TITLE

Format VARCHAR2(800)

Indexed? No

May be Null? Yes

The working title for the position.

POSITION_TYPE

Format VARCHAR2(800)

Indexed? No

May be Null? Yes

The type of position (e.g., Academic Support Staff; Associated Faculty; Fellowship; Search Waiver Requests; Standing Faculty; Standing Faculty - Clinician Educator).

POSITION_UPDATE_DATE

Format DATE

Indexed? No

May be Null? Yes

The date on which the position was updated in the Interfolio system.

QUALIFICATIONS

Format CLOB

Indexed? No

May be Null? Yes

The full text of required or desired qualifications for the position. This text may include HTML markup syntax.

RANK

Format VARCHAR2(400)

Indexed? No

May be Null? Yes

The academic rank of the position.

SALARY_RANGE

Format VARCHAR2(400)

Indexed? No

May be Null? Yes

The compensation salary range, if noted, expected for the position.

UNIT_ID

Format NUMBER

Indexed? No

May be Null? Yes

The system ID in the Interfolio system of the organizational unit associated with the position.

UNIT_NAME

Format VARCHAR2(400)

Indexed? No

May be Null? Yes

The name of the organizational unit associated with the position.

 
IFFS_POSITION_V Table    Tables and Data Elements   Faculty Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania