| Data element |
Definition |
ACADEMIC_REVIEW_DT
Format DATE
Indexed? No
May be Null? Yes |
The academic review date for the appointment - this is required for appoitnments to tracks subject to mandatory review. |
APPT_END_DT
Format DATE
Indexed? No
May be Null? Yes |
The end date of the requested appointment. |
APPT_START_DT
Format DATE
Indexed? No
May be Null? Yes |
The start date of the requested appointment. |
CASE_ID
Format NUMBER
Indexed? Yes
May be Null? No |
The system ID of the related case in the Interfolio system. |
CREATED_AT
Format DATE
Indexed? No
May be Null? Yes |
The date on which the Request form was completed in Interfolio. |
CREATED_BY
Format NUMBER
Indexed? No
May be Null? Yes |
The unique Interfolio system identifier for the person who completed the Request form. |
CREATED_BY_FIRST_NAME
Format VARCHAR2(400)
Indexed? No
May be Null? Yes |
The first name of the person who completed the Request form. |
CREATED_BY_LAST_NAME
Format VARCHAR2(400)
Indexed? No
May be Null? Yes |
The last name of the person who completed the Request form. |
CREATED_BY_PENN_KEY
Format VARCHAR2(96)
Indexed? No
May be Null? Yes |
The PennKey of the person who completed the Request form. |
HOSPITAL
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
For Clinician-Educator appointments, the name of the affiliated hospital for the requested appointment. |
JOINT_SEC_DEPT
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
For Joint or Secondary appoinmtents, the name of the Joint or Secondary department for the requested appointment. |
JOINT_SEC_SCHOOL
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
For Joint or Secondary appoinmtents, the name of the Joint or Secondary school for the requested appointment. |
MAND_REV_YR
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The mandatory review year of the requested appointment. |
NOTES
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
Notes associated with the Request form for the case. |
PROBATION_END_DT
Format DATE
Indexed? No
May be Null? Yes |
The Tenure probation end date of the requested appointment. |
PROBATION_START_DT
Format DATE
Indexed? No
May be Null? Yes |
The Tenure probation start date of the requested appointment. |
RANK_CURRENT
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The current rank of the appointment (for existing appointments). |
RANK_PROPOSED
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The proposed rank of the requested appointment. |
SALARY_LEVEL
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The salary level of the requested appointment. |
SCHOOL
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The school of the requested appointment. |
TENURE_STATUS
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The Tenure status of the requested appointment. |
UPDATED_AT
Format DATE
Indexed? No
May be Null? Yes |
The date on which the Request form was updated in Interfolio. |
UPDATED_BY
Format NUMBER
Indexed? No
May be Null? Yes |
The unique Interfolio system identifier for the person who updated the Request form. |
