| Data element |
Definition |
ACCOUNT_OBJ_CODE1
Indexed - yes
Format - varchar2(20)
May be null? yes |
|
ACCOUNT_OBJ_CODE2
Indexed - yes
Format - varchar2(20)
May be null? yes |
|
ALLOC_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key identifying an allocation record. |
ALLOCATION_COST_OBJ_BC
Indexed - yes
Format - varchar2(1)
May be null? yes |
1-character budgetary control segment of the allocation Cost Object. |
ALLOCATION_COST_OBJ_CNAC
Indexed - yes
Format - varchar2(3)
May be null? yes |
3-character Center Net Asset Class code segment of the allocation Cost Object. |
ALLOCATION_COST_OBJ_CREF
Indexed - yes
Format - varchar2(4)
May be null? yes |
Penn Center Reference code associated with the allocation. |
ALLOCATION_COST_OBJ_FUND
Indexed - yes
Format - varchar2(6)
May be null? yes |
6-character Fund segment of the allocation Cost Object. |
ALLOCATION_COST_OBJ_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-character Organization segment of the allocation Cost Object. |
ALLOCATION_COST_OBJ_PROGRAM
Indexed - yes
Format - varchar2(4)
May be null? yes |
Penn Program code associated with the allocation. |
ALLOCATION_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 allocation cost object. |
ALLOCATION_COST_OBJECT
Indexed - yes
Format - varchar2(48)
May be null? yes |
Allocation Cost Object (comprised of Penn Chart of Accounts CNAC, ORG, BC, and FUND segments). |
ALLOCATION_PERCENTAGE
Indexed - no
Format - number
May be null? yes |
Percentage of the expense allocated to the account code. |
ALLOCATION_SCHOOL_CTR
Indexed - yes
Format - varchar2(2)
May be null? yes |
Penn School/Center code associated with the allocation. |
LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the allocation record was last modified. |
RPE_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the associated report entry expense. |
TYPE_OF_TRAVEL
Indexed - yes
Format - varchar2(48)
May be null? yes |
Type of travel used when the expense was incurred (e.g., Local Domestic, International, Team Travel, etc). |
