Data element |
Definition |
ANSWER_ID
Format NUMBER
Indexed? Yes
May be Null? No |
For answers selected from a list of values in Interfolio, the unique identifier for the question answer option. |
ANSWER_ORDER
Format NUMBER
Indexed? No
May be Null? Yes |
The sort order in which the particular answer option appears in the Interfolio system. |
APPLICATION_ID
Format NUMBER
Indexed? Yes
May be Null? No |
The system ID of the related position application in the Interfolio system. |
CREATION_DATE
Format DATE
Indexed? No
May be Null? No |
The date on which the application form record was created in the Data Warehouse. |
DATA_ANSWER_TEXT
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
For answers selected from a list of values in Interfolio, the full text of the question answer option. |
DISPLAY_ANSWER_TEXT
Format VARCHAR2(400)
Indexed? No
May be Null? Yes |
The full text of the answer to the form question entered by the position applicant. |
FORM_ID
Format NUMBER
Indexed? Yes
May be Null? No |
The unique identifier for the form record in the Interfolio system. |
FORM_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? No |
The name of the form in the Interfolio system, e.g., Reference Contact Form; Request for Voluntary Self-Identification. |
QUESTION_ID
Format NUMBER
Indexed? Yes
May be Null? No |
The unique identifier for the form question in the Interfolio system. |
QUESTION_TEXT
Format VARCHAR2(400)
Indexed? No
May be Null? No |
The full text of the form question. |