Penn Computing

University of Pennsylvania
Penn Computing << go backback
CT_DELEGATION Table   Tables and Data Elements   Travel & Expense Management Home    Data Warehouse Home

CT_DELEGATION Table - Data Element Index

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



Data element Definition
CAN_APPROVE

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the delegate can approve on behalf of the delegator.
CAN_APPROVE_TEMP

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the delegate can temporarily approve on behalf of the delegator.
CAN_PREPARE

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the delegate can prepare expense reports on behalf of the delegator.
CAN_SUBMIT

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the delegate can submit expense reports on behalf of the delegator.
CAN_VIEW_RECEIPT

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the delegate can view receipts on behalf of the delegator.
DELEGATE_EMP_KEY

Indexed - yes
Format - number
May be null? yes
Unique system-assigned key that identifies the delegate authorized to act on behalf of the person (the delegator).
DELEGATE_HOME_ORG

Indexed - yes
Format - varchar2(4)
May be null? yes
4-digit number used to identify the organization that owns the delegate’s record and is responsible for its maintenance in the PennWorks system.
DELEGATE_HOME_SCHOOL_CTR

Indexed - yes
Format - varchar2(2)
May be null? yes
4-digit number used to identify the organization that owns the delegate’s record and is responsible for its maintenance in the PennWorks system.
DELEGATE_PENN_ID

Indexed - yes
Format - varchar2(8)
May be null? yes
8-digit identification number assigned to the delegate by the Penn Community system.
DELEGATION_KEY

Indexed - yes
Format - number
May be null? no
Unique system-assigned key that identifies a delegation record.
DELEGATOR_EMP_KEY

Indexed - yes
Format - number
May be null? yes
Unique system-assigned key that identifies the delegator in the Concur system.
DELEGATOR_HOME_ORG

Indexed - yes
Format - varchar2(4)
May be null? yes
4-digit number used to identify the organization that owns the delegator’s record and is responsible for its maintenance in the PennWorks system.
DELEGATOR_HOME_SCHOOL_CTR

Indexed - yes
Format - varchar2(2)
May be null? yes
2-digit number used to identify the school or center that owns the delegator’s record and is responsible for its maintenance in the PennWorks system.
DELEGATOR_PENN_ID

Indexed - yes
Format - varchar2(8)
May be null? yes
8-digit identification number assigned to the delegator by the Penn Community system.
END_APPROVE_DATE

Indexed - no
Format - date
May be null? yes
Date until which the delegate can approve on behalf of the delegator.
LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the delegation record was last modified.
START_APPROVE_DATE

Indexed - no
Format - date
May be null? yes
Date from which the delegate can approve on behalf of the delegator.

CT_DELEGATION Table   Tables and Data Elements   Travel & Expense Management 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