Penn Computing

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

IFRPT_EXTERNAL_EVALUATION 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 VARCHAR2(50)

Indexed? No

May be Null? No

The system ID of the case in the Interfolio system.

CREATION_DATE

Format DATE

Indexed? No

May be Null? No

The date on which the record was created.

EMAIL

Format VARCHAR2(100)

Indexed? No

May be Null? No

The external evaluator's email address.

FIRST_NAME

Format VARCHAR2(100)

Indexed? No

May be Null? No

The first name of the external evaluator.

ID

Format NUMBER

Indexed? Yes

May be Null? No

The name of the document linked to the case.

LAST_NAME

Format VARCHAR2(150)

Indexed? No

May be Null? No

The last name of the external evaluator.

RECEIVED_DATE

Format DATE

Indexed? No

May be Null? Yes

The date the external evaluation was received.

REQUEST_DATE

Format DATE

Indexed? No

May be Null? No

The date the external evaluation was requested.

RESPONSE_DATE

Format DATE

Indexed? No

May be Null? Yes

The date the external evaluator first responded to the request for evaluation.

STATUS

Format VARCHAR2(15)

Indexed? No

May be Null? No

The status of the external evaluation request.

 
IFRPT_EXTERNAL_EVALUATION 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