| Data element |
Definition |
ACTION_DATE
Indexed - no
Format - date
May be null? yes |
Date on which the workflow step was performed. |
DELEGATE_EMP_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the person in the Concur system who was delegated the workflow step. |
EMP_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the person in the Concur system who was assigned the workflow step. |
ENTRY_DATE
Indexed - no
Format - date
May be null? yes |
Date on which the workflow step was initiated. |
FINAL_STAT_KEY
Indexed - no
Format - char(6)
May be null? yes |
The status in effect at the completion of the workflow step. |
IS_DELETED
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the workflow step instance record has been deleted from Concur. |
LAST_MODIFIED
Indexed - no
Format - date
May be null? no |
Date on which the workflow process instance record was last modified. |
PERSON_HOME_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-digit number used to identify the organization that owns the employee’s record and is responsible for its maintenance in the PennWorks system. |
PERSON_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 employee’s record and is responsible for its maintenance in the PennWorks system. |
PERSON_PENN_ID
Indexed - yes
Format - varchar2(8)
May be null? yes |
8-digit identification number assigned to the person by the Penn Community system. |
PROCESS_INSTANCE_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies a workflow process instance 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_INSTANCE_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies a workflow process step instance in the Concur system. |
STEP_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies a workflow process step in the Concur system. |
