| Data element |
Definition |
APPLICANT_PENN_KEY
Format VARCHAR2(24)
Indexed? No
May be Null? Yes |
The PennKey of the candidate (i.e. the person being reviewed). This field will be null for appointment cases (PACKET_TYPE_NAME = "Appointment") since the candidate is not yet a Penn employee. |
APPLICANT_PID
Format NUMBER
Indexed? No
May be Null? Yes |
A unique identifier for the individuals in the Interfolio system. For cases generated from Faculty Search applicants, this can be used to link back to the related application. |
ARCHIVABLE
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
Indicates whether the case may be archived in Interfolio. |
ARCHIVE_DATE
Format DATE
Indexed? No
May be Null? Yes |
For cases which have been archived in Interfolio, the date on which the case was archived. |
ARCHIVED
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
Indicates whether the case has been archived in Interfolio. |
CANDIDATE_EMAIL
Format VARCHAR2(50)
Indexed? No
May be Null? No |
The candidate's email address. |
CANDIDATE_FIRST_NAME
Format VARCHAR2(50)
Indexed? No
May be Null? No |
The first name of the candidate. |
CANDIDATE_INVOLVEMENT
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
Indicates whether the candidate is involved in the processing of the case. |
CANDIDATE_LAST_NAME
Format VARCHAR2(50)
Indexed? No
May be Null? No |
The last name of the candidate. |
CASE_CREATION_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which the case was created in Interfolio. |
CREATION_DATE
Format DATE
Indexed? No
May be Null? No |
The date on which the case record was created in the Data Warehouse. |
CURRENT_COMMITTEE_NAME
Format VARCHAR2(250)
Indexed? No
May be Null? Yes |
The committee associated with the current processing step for the case (as of the last update to the Warehouse). |
CURRENT_STEP_ENTERED_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which the case entered the latest known processing step in Interfolio. |
CURRENT_STEP_NAME
Format VARCHAR2(250)
Indexed? No
May be Null? Yes |
The latest processing step for the case in Interfolio, as of the most recent update to the Data Warehouse. |
DELETED
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
Indicates whether the case has been deleted in Interfolio. |
ID
Format NUMBER
Indexed? Yes
May be Null? No |
The system ID of the case in the Interfolio system. |
LAST_UPDATE_DATE
Format DATE
Indexed? No
May be Null? No |
The date on which the case record was last updated in the Data Warehouse. |
PACKET_TEMPLATE_NAME
Format VARCHAR2(100)
Indexed? No
May be Null? Yes |
The template used to create the case; generally indicates the type of action and the faculty rank or track. |
PACKET_TYPE_NAME
Format VARCHAR2(100)
Indexed? No
May be Null? Yes |
The type of action (e.g. Appointment, Promotion, Reappointment, Review, Other). |
STATUS
Format VARCHAR2(100)
Indexed? No
May be Null? Yes |
The status indicating where a case is within the RPT process. |
UNIT_ID
Format NUMBER
Indexed? No
May be Null? No |
The system ID in the Interfolio system of the organizational unit associated with the position. |
UNIT_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The name of the organizational unit associated with the case. |
