Penn Computing

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

CT_REPORT_EXCEPTION Table - Data Element Index

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



Data element Definition
EVENT_CODE

Indexed - yes
Format - varchar2(20)
May be null? yes

Code that indicates the point in the workflow process when the report was checked for the exception:
• ENTRY_SAVE = Entry Save
• ENTRY_SUBMIT = Entry Submit
• PMT_HDR_POSTSUBMIT = Payment Post Request Submit
• PMT_HEADER_SAVE = Payment Request Save
• PMT_HEADER_SUBMIT = Payment Request Submit
• PMT_LINEITEM_SAVE = Payment Request Details Save
• PMT_LINEITEM_SUBMIT = Payment Request Details Submit
• REPORT_POSTSUBMIT = Post Report Submit
• REPORT_SAVE = Report Save
• REPORT_SUBMIT = Report Submit
• RL_ENTRY_SAVE = Entry Save - Receipt Limit
• TR_ENTRY_SAVE = Travel Request Category Save
• TR_ENTRY_SUBMIT = Travel Request Category Submit
• TR_POSTSUBMIT = Post Travel Request Submit
• TR_SAVE = Travel Request Save
• TR_SUBMIT = Travel Request Submit

IS_CLEARED

Indexed - no
Format - char(1)
May be null? yes
Indicates whether an Expense Processor has cleared the  exception.
IS_LOGGED

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

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

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

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

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

Indexed - yes
Format - number
May be null? no
Code that identifies the exception associated to the audit rule that was triggered.

CT_REPORT_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