Penn Computing

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

IFRPT_FORM_DEPT_VOTE_V Table - Data Element Index

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




Data element Definition

NOTES

Format VARCHAR2(4000)

Indexed? No

May be Null? Yes

Notes associated with the case department votes.

VOTES_ABSTAIN

Format NUMBER

Indexed? No

May be Null? Yes

The number of instances where departmental reviewers abstained from voting on the case.

VOTES_NO

Format NUMBER

Indexed? No

May be Null? Yes

The number of instances where departmental reviewers voted No regarding on the case.

VOTES_YES

Format NUMBER

Indexed? No

May be Null? Yes

The number of instances where departmental reviewers voted Yes regarding on the case.

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

UPDATED_AT

Format DATE

Indexed? No

May be Null? Yes

The date on which the case voting record was updated in Interfolio.

CREATED_BY_FIRST_NAME

Format VARCHAR2(400)

Indexed? No

May be Null? Yes

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

CREATED_BY_LAST_NAME

Format VARCHAR2(400)

Indexed? No

May be Null? Yes

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

CREATED_BY_PENN_KEY

Format VARCHAR2(96)

Indexed? No

May be Null? Yes

The PennKey of the person who created the case voting record

CREATED_BY

Format NUMBER

Indexed? No

May be Null? Yes

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

UPDATED_BY

Format NUMBER

Indexed? No

May be Null? Yes

The unique Interfolio system identifier for the person who updated the case voting record.

 
IFRPT_FORM_DEPT_VOTE_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