• ANSWER_ID
• ANSWER_ORDER
• APPLICATION_ID
• CREATION_DATE
• DATA_ANSWER_TEXT
• DISPLAY_ANSWER_TEXT
• FORM_ID
• FORM_NAME
• QUESTION_ID
• QUESTION_TEXT

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.