• CANDIDATE_FIRST_NAME
• CASE_ID
• CREATION_DATE
• ID
• NAME
• SECTION
• TYPE

CANDIDATE_FIRST_NAME

Format VARCHAR2(50)

Indexed? No

May be Null? No

The first name of the candidate.

CASE_ID

Format NUMBER

Indexed? No

May be Null? No

The system ID of the related case in the Interfolio system.

CREATION_DATE

Format DATE

Indexed? No

May be Null? No

The date on which the case document record was created in the Data Warehouse.

ID

Format NUMBER

Indexed? Yes

May be Null? No

The unique identifier for the case document record in the Interfolio system.

NAME

Format VARCHAR2(300)

Indexed? No

May be Null? No

The name of the document linked to the case.

SECTION

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The section of the case form to which the document applies.

TYPE

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The type of document.