| Data element |
Definition |
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 Faculty Pending record was created in Interfolio. |
CREATED_BY
Format NUMBER
Indexed? No
May be Null? Yes |
The unique Interfolio system identifier for the person who created the Faculty Pending record. |
CREATED_BY_FIRST_NAME
Format VARCHAR2(400)
Indexed? No
May be Null? Yes |
The first name of the person who created the Faculty Pending voting record. |
CREATED_BY_LAST_NAME
Format VARCHAR2(400)
Indexed? No
May be Null? Yes |
The last name of the person who created the Faculty Pending record. |
CREATED_BY_PENN_KEY
Format VARCHAR2(96)
Indexed? No
May be Null? Yes |
The PennKey of the person who created the Faculty Pending record |
DELAY_REASON
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
Indicates the reason for the delay in case processing. |
EXPECTED_REVIEW_DT
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The date of expected PSC/PSCS review of the case. |
EXPECTED_START_DT
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The expected start date of the faculty member's appointment, once approved. |
RANK_PROPOSED
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The rank associated with the case. |
SCHOOL
Format VARCHAR2(4000)
Indexed? No
May be Null? Yes |
The school associated with the case. |
UPDATED_AT
Format DATE
Indexed? No
May be Null? Yes |
The date on which the Faculty Pending record 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 Faculty Pending record. |
