Penn Computing

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

IFRPT_FORM_REVIEW_COMPLETION_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

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

CREATED_AT

Format DATE

Indexed? No

May be Null? Yes

The date on which the Case Review Completion form was completed in Interfolio.

CREATED_BY

Format NUMBER

Indexed? No

May be Null? Yes

The unique Interfolio system identifier for the person who completed the Case Review Completion form.

CREATED_BY_FIRST_NAME

Format VARCHAR2(400)

Indexed? No

May be Null? Yes

The first name of the person who completed the Case Review Completion form.

CREATED_BY_LAST_NAME

Format VARCHAR2(400)

Indexed? No

May be Null? Yes

The last name of the person who completed the Case Review Completion form.

CREATED_BY_PENN_KEY

Format VARCHAR2(96)

Indexed? No

May be Null? Yes

The PennKey of the person who completed the Case Review Completion form.

DECISION

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

The case decision, as noted on the Case Review Completion form.

NOTES

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

Notes associated with the Case Review Completion form for the case.

UPDATED_AT

Format DATE

Indexed? No

May be Null? Yes

The date on which the Case Review Completion form was updated in Interfolio.

UPDATED_BY

Format NUMBER

Indexed? No

May be Null? Yes

The unique Interfolio system identifier for the person who updated the Case Review Completion form.

 
IFRPT_FORM_REVIEW_COMPLETION_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