| Data element |
Definition |
ADJUSTED_AMOUNT
Indexed - no
Format - number
May be null? yes |
In most cases, the adjusted amount equals the approved amount. For travel allowance expenses, however, the adjusted amount may additionally reflect the amount that exceeds the travel allowance limit, pro-rated over more than one expense. |
AIR_TRAVEL_SERV_CODE
Indexed - yes
Format - varchar2(48)
May be null? yes |
Airline travel service code. |
ALLOCATION_STATE
Indexed - no
Format - char(1)
May be null? yes |
|
ALLOCATION_VERSION
Indexed - no
Format - date
May be null? yes |
|
APPROVED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Amount of the expense approved for reimbursement, converted as needed to the person's reimbursement currency. |
ATTENDEE_COUNT
Indexed - no
Format - number
May be null? yes |
Number of attendees associated with the expense. |
CCT_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies a credit card transaction, if the expense originated from a downloaded credit card transaction. |
CLAIMED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Amount of the expense the person is claiming for reimbursement. This may differ from the Expense Amount if, for example, a portion of the expense has been marked as personal.. |
CLASS_OF_SERVICE
Indexed - no
Format - varchar2(48)
May be null? yes |
The class of air travel service. |
COMMENT_COUNT
Indexed - no
Format - number
May be null? yes |
Number of comments associated with the expense. |
COUNTRY
Indexed - yes
Format - varchar2(58)
May be null? yes |
Country associated with the expense. |
CRN_KEY
Indexed - yes
Format - number
May be null? yes |
Currency in which the person is reimbursed. |
ENTRY_COST_OBJ_BC
Indexed - no
Format - varchar2(1)
May be null? yes |
1-character budgetary control segment of the expense report entry Cost Object. |
ENTRY_COST_OBJ_CNAC
Indexed - yes
Format - varchar2(3)
May be null? yes |
3-character Center Net Asset Class code segment of the expense report entry Cost Object. |
ENTRY_COST_OBJ_CREF
Indexed - yes
Format - varchar2(4)
May be null? yes |
Penn Center Reference code associated with the expense report entry. |
ENTRY_COST_OBJ_FUND
Indexed - yes
Format - varchar2(6)
May be null? yes |
6-character Fund segment of the expense report entry Cost Object. |
ENTRY_COST_OBJ_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-character Organization segment of the expense report entry Cost Object. |
ENTRY_COST_OBJ_PROGRAM
Indexed - yes
Format - varchar2(4)
May be null? yes |
Penn Program code associated with the expense report entry. |
ENTRY_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 expense report entry cost object. |
ENTRY_COST_OBJECT
Indexed - yes
Format - varchar2(48)
May be null? yes |
Expense report entry Cost Object (comprised of Penn Chart of Accounts CNAC, ORG, BC, and FUND segments). |
ENTRY_SCHOOL_CTR
Indexed - yes
Format - varchar2(2)
May be null? yes |
Penn School/Center code associated with the expense report entry cost object. |
EXCEPTION_COUNT
Indexed - no
Format - number
May be null? yes |
Number of exceptions the expense generated. |
EXCHANGE_RATE
Indexed - no
Format - number
May be null? yes |
Exchange rate used to convert the expense from the transaction currency amount to the reimbursement currency amount. |
EXCHANGE_RATE_DIRECTION
Indexed - no
Format - char(1)
May be null? yes |
Direction of exchange:
• M = the amount was multiplied by the exchange rate to determine the reimbursement amount
• D = the transaction amount was divided by the exchange rate to determine the reimbursement amount. |
EXP_KEY
Indexed - yes
Format - char(5)
May be null? yes |
Expense type assigned to the expense. |
EXPENSE_DESCRIPTION
Indexed - no
Format - varchar2(48)
May be null? yes |
Description of the the expense. |
EXTRACT_CCT_KEY
Indexed - yes
Format - number
May be null? yes |
|
FOREIGN_OR_DOMESTIC
Indexed - yes
Format - char(4)
May be null? yes |
Indicates whether the expense was incurred in the person's country, either:
FRGN = this expense was incurred in a country other than the employee's home country
HOME = this expense was incurred in the employee's home country |
FROM_LOCATION
Indexed - yes
Format - varchar2(48)
May be null? yes |
Location from which the person traveled when incurring the expense. |
HAS_VAT
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the expense has associated VAT. |
IMAGE_REQUIRED
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the policy dictates that scanned (or faxed) image of the receipt be submitted for the expense. |
IS_PERSONAL
Indexed - yes
Format - char(1)
May be null? yes |
Indicates whether the submitter marked the expense as personal (do not reimburse). |
LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the expense report entry line record was last modified. |
LAWSON_AU_UPHS_COA
Indexed - no
Format - varchar2(48)
May be null? yes |
Account number from the University of Pennsylvania Health System (UPHS). |
LN_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the location where the expense was incurred. |
MEAL_LODGING_TYPE
Indexed - no
Format - char(1)
May be null? yes |
Type of meal. |
PARENT_RPE_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the child expense's parent expense. NOTE: If the expense was not itemized, then there is no Parent Entry Key |
PAT_KEY
Indexed - yes
Format - char(4)
May be null? yes |
Method by which the person paid for the expense, such as cash or a credit card. |
POSTED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Amount of the expense posted. |
RECEIPT_RECEIVED
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether receipts have been marked as received for the expense. |
RECEIPT_REQUIRED
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the policy dictates that a receipt be submitted for the expense. |
RECEIPT_TYPE
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether a receipt is available for the expense and, if so, whether the receipt includes tax information (for VAT purposes). |
RPE_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies the report entry expense. |
RPT_ENTRY_DESCRIPTION
Indexed - yes
Format - varchar2(64)
May be null? yes |
Submitter-entered business purpose or description of the expense entry. |
RPT_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the expense report on which the expense was submitted. |
TA_DAY_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the associated travel allowance day record. |
TA_RB_KEY
Indexed - yes
Format - number
May be null? yes |
|
TO_LOCATION
Indexed - yes
Format - varchar2(48)
May be null? yes |
Location to which the person traveled when incurring the expense. |
TRANSACTION_AMOUNT
Indexed - no
Format - number
May be null? yes |
Amount of the expense, in the currency in which it was incurred. |
TRANSACTION_DATE
Indexed - no
Format - date
May be null? yes |
Date the expense transaction was incurred. |
TRANSACTION_TYPE
Indexed - yes
Format - char(3)
May be null? yes |
Type of transaction of the expense:
• REG = Regular
• PAR = Parent (when an expense is itemized)
• CHD = Child (when an expense is itemized).
Note that PAR (Parent) lines are a summary of the itemized CHD (Child) charges, and the transaction amounts for these two types of transactions should not be combined. |
TRAVEL_ALLOWANCE
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the expense is a travel allowance or counts against a travel allowance. |
TRIP_BEGINNING_DATE
Indexed - no
Format - varchar2(48)
May be null? yes |
Date on which the trip began. |
TRIP_END_DATE
Indexed - no
Format - varchar2(48)
May be null? yes |
Date on which the trip ended. |
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). |
VENDOR_DESCRIPTION
Indexed - yes
Format - varchar2(64)
May be null? yes |
Submitter-entered vendor name. |
VENDOR_NAME
Indexed - yes
Format - varchar2(32)
May be null? yes |
Vendor associated with the expense. Vendor name, as selected from the corporate vendor list. |
