Penn Computing

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

CT_PERSON Table - Data Element Index

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



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
 

CT_PERSON 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