Penn Computing

University of Pennsylvania
Penn Computing << go backback
IFRPT_FORM_EC_BY_CANDIDATE_V Table    Tables and Data Elements   Faculty Home   Data Warehouse Home

IFRPT_FORM_EC_BY_CANDIDATE_V Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.




Data element Definition

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

 
IFRPT_FORM_EC_BY_CANDIDATE_V Table    Tables and Data Elements   Faculty Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania