Penn Computing

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

CT_REPORT_ENTRY Table - Data Element Index

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



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.

CT_REPORT_ENTRY 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