Penn Computing

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

IFRPT_FORM_PSC_MEMBER_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 PSC voting record was created in Interfolio.

CREATED_BY

Format NUMBER

Indexed? No

May be Null? Yes

The unique Interfolio system identifier for the person who created the PSC voting record.

CREATED_BY_FIRST_NAME

Format VARCHAR2(400)

Indexed? No

May be Null? Yes

The first name of the person who created the PSC voting record.

CREATED_BY_LAST_NAME

Format VARCHAR2(400)

Indexed? No

May be Null? Yes

The last name of the person who created the PSC voting record.

CREATED_BY_PENN_KEY

Format VARCHAR2(96)

Indexed? No

May be Null? Yes

The PennKey of the person who created the PSC voting record

NOTES

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

Notes associated with the Provost Staff Conference (PSC) member votes for the case.

RECOMMENDATION

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

PSC member recommendation regarding the case.

UPDATED_AT

Format DATE

Indexed? No

May be Null? Yes

The date on which the PSC voting record 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 PSC voting record.

 
IFRPT_FORM_PSC_MEMBER_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