| Data element |
Definition |
CCA_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies the credit card account. |
EFFECTIVE_DATE
Indexed - no
Format - date
May be null? yes |
Date on which the credit card account became effective. |
EMP_KEY
Indexed - yes
Format - number
May be null? yes |
Unique code or number that identifies the person assigned to the card. NOTE: Not all cards may be assigned to a person.. |
HIER_NODE_KEY
Indexed - yes
Format - number
May be null? yes |
|
IS_DELETED
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the credit card account record has been deleted from Concur. |
LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the credit card account record was last modified. |
LAST_SEGMENT
Indexed - no
Format - varchar2(5)
May be null? yes |
The final segment (likely 4 digits) of the credit card number. |
NAME_ON_CARD
Indexed - no
Format - varchar2(40)
May be null? yes |
Name on the corporate card, as supplied by the credit card vendor. |
PAT_KEY
Indexed - no
Format - char(4)
May be null? yes |
Unique system-assigned key that identifies the payment type (method) used to pay the expense. |
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. |
