Penn Computing

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

CT_WORKFLOW_STEP Table - Data Element Index

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



Data element Definition
INITIAL_STAT_KEY

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

The status in effect at the initiation of the workflow step.

IS_DELETED

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

Indexed - yes
Format - number
May be null? yes
Unique system-assigned key that identifies the associated workflow process in the Concur system.
ROLE_CODE

Indexed - no
Format - varchar2(15)
May be null? yes
The user role associated with the workflow step.
SEQUENCE_ORDER

Indexed - no
Format - number
May be null? yes
Number of the process sequence in which the workflow step is performed.
STEP_CODE_LAST_MODIFIED

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

Indexed - yes
Format - number
May be null? no
Unique system-assigned key that identifies a workflow process step in the Concur system.
STEP_NAME

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

Name of the workflow step in the Concur system.

STEP_NAME_LAST_MODIFIED

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

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

CT_WORKFLOW_STEP 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