• CASE_ID
• CREATED_AT
• CREATED_BY
• CREATED_BY_FIRST_NAME
• CREATED_BY_LAST_NAME
• CREATED_BY_PENN_KEY
• EC_1_ADVISOR
• EC_1_APPEAR
• EC_1_COUNTRY
• EC_1_EMAIL
• EC_1_FIELD
• EC_1_INDUSTRY
• EC_1_INSTITUTION
• EC_1_NAME
• EC_1_NOTES
• EC_1_PENN
• EC_1_QUAL
• EC_1_RELATIONSHIP
• EC_1_SAME_DEPT
• EC_1_SAME_TRAINING
• EC_1_SCHOOL
• EC_1_TITLE
• EC_1_URL
• EC_2_ADVISOR
• EC_2_APPEAR
• EC_2_COUNTRY
• EC_2_EMAIL
• EC_2_FIELD
• EC_2_INDUSTRY
• EC_2_INSTITUTION
• EC_2_NAME
• EC_2_NOTES
• EC_2_PENN
• EC_2_QUAL
• EC_2_RELATIONSHIP
• EC_2_SAME_DEPT
• EC_2_SAME_TRAINING
• EC_2_SCHOOL
• EC_2_TITLE
• EC_2_URL
• EC_3_ADVISOR
• EC_3_APPEAR
• EC_3_COUNTRY
• EC_3_EMAIL
• EC_3_FIELD
• EC_3_INDUSTRY
• EC_3_INSTITUTION
• EC_3_NAME
• EC_3_NOTES
• EC_3_PENN
• EC_3_QUAL
• EC_3_RELATIONSHIP
• EC_3_SAME_DEPT
• EC_3_SAME_TRAINING
• EC_3_SCHOOL
• EC_3_TITLE
• EC_3_URL
• UPDATED_AT
• UPDATED_BY

CASE_ID

Format NUMBER

Indexed? Yes

May be Null? No

CREATED_AT

Format DATE

Indexed? No

May be Null? Yes

CREATED_BY

Format NUMBER

Indexed? No

May be Null? Yes

CREATED_BY_FIRST_NAME

Format VARCHAR2(400)

Indexed? No

May be Null? Yes

CREATED_BY_LAST_NAME

Format VARCHAR2(400)

Indexed? No

May be Null? Yes

CREATED_BY_PENN_KEY

Format VARCHAR2(96)

Indexed? No

May be Null? Yes

EC_1_ADVISOR

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

The Workday Academic Unit associated with Interfolio organizational unit.

EC_1_APPEAR

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

The date on which the record was extracted from Interfolio and loaded to the Data Warehouse.

EC_1_COUNTRY

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

The system ID of the organizational unit in the Interfolio system.

EC_1_EMAIL

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

The name of the organizational unit.

EC_1_FIELD

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

The system ID of the parent organizational unit associated with the unit record.

EC_1_INDUSTRY

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_1_INSTITUTION

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_1_NAME

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_1_NOTES

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_1_PENN

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_1_QUAL

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_1_RELATIONSHIP

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_1_SAME_DEPT

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_1_SAME_TRAINING

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_1_SCHOOL

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_1_TITLE

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_1_URL

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_ADVISOR

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_APPEAR

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_COUNTRY

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_EMAIL

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_FIELD

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_INDUSTRY

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_INSTITUTION

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_NAME

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_NOTES

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_PENN

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_QUAL

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_RELATIONSHIP

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_SAME_DEPT

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_SAME_TRAINING

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_SCHOOL

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_TITLE

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_2_URL

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_ADVISOR

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_APPEAR

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_COUNTRY

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_EMAIL

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_FIELD

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_INDUSTRY

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_INSTITUTION

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_NAME

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_NOTES

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_PENN

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_QUAL

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_RELATIONSHIP

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_SAME_DEPT

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_SAME_TRAINING

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_SCHOOL

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_TITLE

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

EC_3_URL

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

UPDATED_AT

Format DATE

Indexed? No

May be Null? Yes

UPDATED_BY

Format NUMBER

Indexed? No

May be Null? Yes