| Data element |
Definition |
APPROVER_HOME_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-digit number used to identify the organization that owns the approver's record and is responsible for its maintenance in the PennWorks system. |
APPROVER_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 approver's record and is responsible for its maintenance in the PennWorks system. |
APPROVER_PENN_ID
Indexed - yes
Format - varchar2(8)
May be null? yes |
8-digit identification number assigned to the approver by the Penn Community system. |
AUTH_APPR_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies an authorized approver record. |
EMP_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the employee in the Concur system. |
EXCPT_APPRV_AUTH
Indexed - no
Format - char(1)
May be null? yes |
|
HIER_NODE_KEY
Indexed - no
Format - number
May be null? yes |
|
LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the authorized approver record was last modified. |
SUBJECT_CODE
Indexed - yes
Format - varchar2(16)
May be null? yes |
|
