Penn Computing

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

CT_STATUS Table - Data Element Index

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



Data element Definition
ACTION_TEXT

Indexed - no
Format - varchar2(64)
May be null? yes

Action text associated with the status.

IS_DELETED

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

Indexed - yes
Format - char(6)
May be null? no
Unique system-assigned key that identifies a status in the Concur system.
STATUS_CODE_LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the status code record was last modified.
STATUS_DESCRIPTION

Indexed - no
Format - varchar2(255)
May be null? yes
Description of the status.
STATUS_NAME

Indexed - no
Format - varchar2(64)
May be null? yes
Name of the status in the Concur system.
STATUS_NAME_LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the status name record was last modified.
SYSTEM_RECORD

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

Indexed - no
Format - varchar2(3)
May be null? yes
Status type code.

CT_STATUS 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