Penn Computing

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

CT_EXCEPTION Table - Data Element Index

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



Data element Definition
EXCEPTION_CODE

Indexed - yes
Format - varchar2(8)
May be null? yes
Code that identifies the exception associated to the audit rule that was triggered.
EXCEPTION_CODE_LAST_MODIFIED

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

Indexed - no
Format - varchar2(512)
May be null? yes
Text description of the exception.
EXCEPTION_MSG_LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the exception description was last modified.
IS_DELETED

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the exception record has been deleted from Concur.
SYSTEM_RECORD

Indexed - no
Format - char(1)
May be null? yes
 
XCT_KEY

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the currency record has been deleted from Concur.
IS_REIMBURSEMENT_CURRENCY

Indexed - yes
Format - number
May be null? no
Unique system-assigned key that identifies the exception record.

CT_EXCEPTION 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