| Data element |
Definition |
ADDRESS
Format VARCHAR2(100)
Indexed? No
May be Null? Yes |
The first line of the applicant's address. |
ADDRESS2
Format VARCHAR2(100)
Indexed? No
May be Null? Yes |
The second line of the applicant's address. |
APPLICATION_ID
Format NUMBER
Indexed? Yes
May be Null? No |
The system ID of the position application in the Interfolio system. |
APPLICATION_STATUS
Format VARCHAR2(150)
Indexed? No
May be Null? Yes |
The status values applied to individual applicants to indicate where their application is within the search process. |
ARCHIVED
Format VARCHAR2(10)
Indexed? No
May be Null? Yes |
Indicates whether the application has been archived in Interfolio. |
AVERAGE_RATING
Format VARCHAR2(10)
Indexed? No
May be Null? Yes |
Indicates the average evaluation rating of the application. |
CITY
Format VARCHAR2(50)
Indexed? No
May be Null? Yes |
The city or post office of the applicant's address. |
COMPLETENESS_LEVEL
Format VARCHAR2(100)
Indexed? No
May be Null? Yes |
Indicates the level of completeness of the application. |
COUNTRY
Format VARCHAR2(50)
Indexed? No
May be Null? Yes |
The country of the person's address. |
DOCUMENT_REQUIREMENTS_MET
Format VARCHAR2(10)
Indexed? No
May be Null? Yes |
Indicates whether the document requirements for the application have been satisfied. |
EDITABLE
Format VARCHAR2(10)
Indexed? No
May be Null? Yes |
Indicates whether the application may be edited in Interfolio. |
EMAIL
Format VARCHAR2(150)
Indexed? No
May be Null? No |
The person's email address. |
FIRST_DATE_SENT
Format DATE
Indexed? No
May be Null? Yes |
The date on which the application was first submitted. |
FIRST_NAME
Format VARCHAR2(50)
Indexed? No
May be Null? No |
The first name of the applicant. |
GENERAL_NOTES
Format CLOB
Indexed? No
May be Null? Yes |
Displays any general notes related to the application. |
HIGHEST_DEGREE
Format VARCHAR2(50)
Indexed? No
May be Null? Yes |
The highest educational degree granted to the applicant. |
HIGHEST_DEGREE_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which the highest educational degree was granted to the applicant. |
HIGHEST_DEGREE_SCHOOL
Format VARCHAR2(100)
Indexed? No
May be Null? Yes |
The name of the institution where the applicant pursued his/her highest educational degree. |
HIRING_NOTES
Format CLOB
Indexed? No
May be Null? Yes |
Displays any notes related to hiring the applicant. |
LAST_DATE_SENT
Format DATE
Indexed? No
May be Null? Yes |
The latest date on which the application was submitted. |
LAST_NAME
Format VARCHAR2(50)
Indexed? No
May be Null? No |
The last name of the applicant. |
MATERIALS_COMPLETE
Format VARCHAR2(10)
Indexed? No
May be Null? Yes |
Indicates whether all the required materials for the application have been submitted. |
OFFER_MADE
Format VARCHAR2(100)
Indexed? No
May be Null? Yes |
Indicates whether an offer of acceptance has been extended to the applicant. |
PENN_DW_CREATION_DATE
Format DATE
Indexed? No
May be Null? No |
The date on which the application 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 application record was last updated in the Data Warehouse. |
POSITION_ID
Format NUMBER
Indexed? No
May be Null? No |
The system ID of the related position in the Interfolio system. |
STATE
Format VARCHAR2(50)
Indexed? No
May be Null? Yes |
The state of the person's address. |
TELEPHONE
Format VARCHAR2(50)
Indexed? No
May be Null? Yes |
The person's telephone number. |
WITHDRAWN
Format VARCHAR2(10)
Indexed? No
May be Null? Yes |
Indicates whether the application was withdrawn. |
ZIP
Format VARCHAR2(15)
Indexed? No
May be Null? Yes |
The postal code of the person's address. |
