| Data element |
Definition |
ACTIVE
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the person is active in the Concur system. |
ALLOW_CC_ARRIVAL_EMAILS
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the person’s profile is set to receive credit card related emails from Concur. |
ALLOW_IMAGE_AVAIL_EMAILS
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the person’s profile is set to receive image related emails from Concur. |
AUTO_ADD_TRIP_CARD_TRANS
Indexed - no
Format - char(1)
May be null? yes |
|
AUDIT_STATUS
Indexed - no
Format - varchar2(48)
May be null? yes |
|
CRN_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the person’s currency. |
CTRY_CODE
Indexed - yes
Format - char(2)
May be null? yes |
Two-character code that identifies the person’s country. |
CTRY_SUB_CODE
Indexed - yes
Format - varchar2(6)
May be null? yes |
Unique code identifying the person’s country subdivision (e.g., State, Province, Region). |
EMAIL_ADDRESS
Indexed - no
Format - varchar2(255)
May be null? yes |
Person’s email address as stored in the Concur system. |
EMP_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies the person in the Concur system. |
EXPENSE_GROUP_ID
Indexed - no
Format - varchar2(48)
May be null? yes |
|
FIRST_NAME
Indexed - yes
Format - varchar2(32)
May be null? yes |
Person’s first name. |
FULL_NAME
Indexed - yes
Format - varchar2(68)
May be null? yes |
Person’s full name (in format LASTNAME,FIRSTNAME MIDDLEINITIAL). |
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. |
INVOICE_GROUP_ID
Indexed - no
Format - varchar2(48)
May be null? yes |
|
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. |
LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the person record was last modified. |
LAST_NAME
Indexed - yes
Format - varchar2(32)
May be null? yes |
Person’s last name. |
LOGIN_ID
Indexed - no
Format - varchar2(64)
May be null? yes |
Person’s login ID for the Concur system. |
MIDDLE_INITIAL
Indexed - no
Format - varchar2(2)
May be null? yes |
Person’s middle initial. |
PENN_ID
Indexed - yes
Format - varchar2(8)
May be null? yes |
8-digit identification number assigned to the person by the Penn Community system. |
PERSON_AFFILIATION
Indexed - yes
Format - varchar2(48)
May be null? yes |
Person’s affiliation (e.g., Faculty/Staff, Student). |
PERSON_COST_OBJ_BC
Indexed - no
Format - varchar2(1)
May be null? yes |
1-character budgetary control segment of the person’s default Cost Object. |
PERSON_COST_OBJ_CNAC
Indexed - yes
Format - varchar2(3)
May be null? yes |
3-character Center Net Asset Class code segment of the person’s default Cost Object. |
PERSON_COST_OBJ_CREF
Indexed - yes
Format - varchar2(4)
May be null? yes |
Default Center Reference code associated with the person. |
PERSON_COST_OBJ_FUND
Indexed - yes
Format - varchar2(6)
May be null? yes |
6-character Fund segment of the person’s default Cost Object. |
PERSON_COST_OBJ_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-character Organization segment of the person’s default Cost Object. |
PERSON_COST_OBJ_PROGRAM
Indexed - yes
Format - varchar2(4)
May be null? yes |
Default Penn Program code associated with the person. |
PERSON_COST_OBJ_RESPORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-character code for the Organization responsible for managing the Fund of the person’s default Cost Object. |
PERSON_COST_OBJECT
Indexed - yes
Format - varchar2(4)
May be null? yes |
Person’s default Cost Object (comprised of Penn Chart of Accounts CNAC, ORG, BC, and FUND segments). |
PERSON_SCHOOL_CTR
Indexed - yes
Format - varchar2(2)
May be null? yes |
Penn School/Center code associated with the person’s default cost object. |
PROMPT_FOR_CARD_TRANSACTIONS
Indexed - no
Format - char(1)
May be null? yes |
|
SYSTEM_RECORD
Indexed - no
Format - char(1)
May be null? yes |
|
