| 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. |
