| Data element |
Definition |
CA_RETURNS_AMOUNT
Indexed - no
Format - number
May be null? yes |
Indicates whether cash advance returns entered by the submitter on the expense report have been marked as received. |
CA_RETURN_RECEIVED
Indexed - no
Format - char(1)
May be null? yes |
Total amount of cash advance the person returned to the company. |
CA_UTILIZED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Total amount of cash advances applied against expenses on the report. |
CC_ENTRIES_COUNT
Indexed - no
Format - number
May be null? yes |
Total number of credit card entries submitted on the expense report. |
CLEARED_EXCEPTION_COUNT
Indexed - no
Format - number
May be null? yes |
Total number of exceptions that have been cleared by an Expense Processor. |
COMMENT_COUNT
Indexed - no
Format - number
May be null? yes |
Total number of comments associated with the expense report. Note that this also includes comments at the report entry level, as well as those for the overall report itself. |
COMPANY_TO_CREDIT_CARDS_AMOUNT
Indexed - no
Format - number
May be null? yes |
Total amount to be reimbursed to credit cards or other accounts. |
COMPANY_TO_PERSON_AMOUNT
Indexed - no
Format - number
May be null? yes |
Total amount to be reimbursed to the person. |
COUNTRY
Indexed - yes
Format - varchar2(48)
May be null? yes |
Country associated with the expense report. |
CREATED_BY_CLIENT_TYPE
Indexed - no
Format - varchar2(8)
May be null? yes |
Indicates the type of client (e.g., online or mobile) on which the expense report was created. |
CREATION_DATE
Indexed - no
Format - date
May be null? yes |
Date on which the expense report was created. |
CRN_KEY
Indexed - yes
Format - number
May be null? yes |
Currency in which the person was reimbursed. |
CTRY_CODE
Indexed - yes
Format - char(2)
May be null? yes |
Employee country. Typically, this information copies down from the person record; however, depending on a client's configuration of the report header form, it is possible that the Country could be different from the person's assigned 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)Employee sub-country (State/Province/Region). Typically, this information copies down from the person record; however, depending on a client's configuration, this information could be changed on the expense report. |
CURRENT_WORKFLOW
Indexed - no
Format - number
May be null? yes |
Indicates the workflow instance through which the transaction is currently progressing. A single transaction may have more than one associated workflow instance, but only one will be active or current. For example, if an expense report is sent back to the submitter, that action terminates one workflow instance. When the person resubmits the report, that action initiates a new workflow instance. |
DELEGATE_APPROVED
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the expense report was approved by a delegate on behalf of the person from whom workflow required approval. |
DELEGATE_SUBMITTED
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the expense report was submitted by a delegate on behalf of the person who incurred the expenses. |
EMP_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the person associated with the report in the Concur system. |
ENTRIES_COUNT
Indexed - no
Format - number
May be null? yes |
Total number of entries submitted on the expense report. |
EXCEPTION_APPROVED
Indexed - yes
Format - char(1)
May be null? yes |
Indicates whether an Authorized Approver with Exception Approval rights approved the expense report. |
EXCEPTION_COUNT
Indexed - no
Format - number
May be null? yes |
Total number of exceptions generated for the expense report, at either the report header level or entry level. Note that this also includes exceptions at the report entry level, as well as those for the overall report itself. |
EXCEPTION_LEVEL_MAX
Indexed - no
Format - number
May be null? yes |
Maximum severity level among the exceptions the expense report generated. |
EXCEPTION_LEVEL_TOTAL
Indexed - no
Format - number
May be null? yes |
Sum of the severity levels assigned to exceptions the expense report generated. |
EXPENSE_GROUP_ID
Indexed - no
Format - varchar2(48)
May be null? yes |
|
FIRST_APPROVE_DATE
Indexed - yes
Format - date
May be null? yes |
Date that the expense report passed the first step in the approval process. |
FIRST_SUBMIT_DATE
Indexed - yes
Format - date
May be null? yes |
Date that the expense report was first submitted for approval. If the report was returned to the submitter and had to be resubmitted, this date is the date the report was first submitted. |
IMAGE_REQUIRED
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether any expenses on the report require a scanned image of the receipt. |
ITIN_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the itinerary associated with the expense report. |
LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the expense report 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). |
LEDGER_KEY
Indexed - yes
Format - number
May be null? yes |
Code that identifies the ledger associated with the account codes charged for the expenses and other entries on the report. Typically, this copies down from the person record. |
LIMIT_APPROVED
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether an Authorized Approver with sufficient Limit Approval rights approved the expense report. |
PAID_DATE
Indexed - yes
Format - date
May be null? yes |
Date the expense report was extracted from the expense system for payment in another accounting system (such as Accounts Payable or Payroll). |
PERSON_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. |
PERSON_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. |
PERSON_PENN_ID
Indexed - yes
Format - varchar2(8)
May be null? yes |
8-digit identification number assigned to the person by the Penn Community system. |
POL_KEY
Indexed - yes
Format - number
May be null? yes |
Code that identifies the policy used to determine the configuration settings governing the expense report. |
PROCESSING_PAYMENT_DATE
Indexed - no
Format - date
May be null? yes |
Date the expense report was extracted from the expense system for payment in another accounting system (such as Accounts Payable or Payroll). |
REBUILD_JOURNAL
Indexed - no
Format - char(1)
May be null? yes |
|
RECEIPT_IMAGE_AVAIL
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether receipt images are available for the report. |
RECEIPT_REQUIRED
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether any expenses on the report require a receipt. |
RECEIPTS_RECEIVED
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether receipts have been marked as received for the report. |
REPORT_ID
Indexed - no
Format - varchar2(32)
May be null? yes |
Unique system-assigned code that identifies the expense report. |
REPORT_NAME
Indexed - yes
Format - varchar2(40)
May be null? yes |
Submitter-entered name of the expense report. |
REPORT_PURPOSE
Indexed - yes
Format - varchar2(2000)
May be null? yes |
Submitter-entered business purpose or description of the expense report. Also referred to as the Business Justification. |
RPT_COST_OBJ_BC
Indexed - no
Format - varchar2(1)
May be null? yes |
1-character budgetary control segment of the expense report Cost Object. |
RPT_COST_OBJ_CNAC
Indexed - yes
Format - varchar2(3)
May be null? yes |
3-character Center Net Asset Class code segment of the expense report Cost Object. |
RPT_COST_OBJ_CREF
Indexed - yes
Format - varchar2(4)
May be null? yes |
Penn Center Reference code associated with the expense report. |
RPT_COST_OBJ_FUND
Indexed - yes
Format - varchar2(6)
May be null? yes |
6-character Fund segment of the expense report Cost Object. |
RPT_COST_OBJ_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-character Organization segment of the expense report Cost Object. |
RPT_COST_OBJ_PROGRAM
Indexed - yes
Format - varchar2(4)
May be null? yes |
Penn Program code associated with the expense report. |
RPT_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 cost object. |
RPT_COST_OBJECT
Indexed - yes
Format - varchar2(48)
May be null? yes |
Expense report Cost Object (comprised of Penn Chart of Accounts CNAC, ORG, BC, and FUND segments). |
RPT_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies the expense report in Concur Expense. |
RPT_PERSON_AFFILIATION
Indexed - yes
Format - varchar2(48)
May be null? yes |
Affiliation of the person associated with the expense report (e.g., Faculty/Staff, Student). |
RPT_SCHOOL_CTR
Indexed - yes
Format - varchar2(2)
May be null? yes |
Penn School/Center code associated with the expense report cost object. |
SCHEDULE_F_REPORTABLE
Indexed - no
Format - varchar2(1)
May be null? yes |
Indicates whether the report should be considered in Schedule F reporting analysis. |
SUBMIT_DATE
Indexed - no
Format - date
May be null? yes |
Date that the expense report was last submitted by the submitter for approval. If the person submitted the report more than once, for example, because it was returned to the submitter for corrections, this date is the date the report was last submitted. |
SUPPL_APPROVER_REQD
Indexed - no
Format - varchar2(48)
May be null? yes |
Indicates whether the report required supplemental approval. |
TA_ENTRIES_COUNT
Indexed - no
Format - number
May be null? yes |
Total number of travel advance entries submitted on the expense report. |
TOTAL_APPROVED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Total amount approved to be reimbursed. |
TOTAL_CLAIMED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Total amount of expenses on the report, less personal and less cash advance return. |
TOTAL_COPD_POSTED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Total amount paid to vendors by the company (for example, charges on a company-paid credit card). |
TOTAL_PERSONAL_AMOUNT
Indexed - no
Format - number
May be null? yes |
Total expense amounts marked as personal (non-reimbursable). |
TOTAL_POSTED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Total amount of the expenses on the report. |
TRIP_BEGIN_DATE
Indexed - no
Format - date
May be null? yes |
The date on which the trip began. |
TRIP_END_DATE
Indexed - no
Format - date
May be null? yes |
The date on which the trip ended. |
TYPE_OF_TRAVEL
Indexed - yes
Format - varchar2(48)
May be null? yes |
Type of travel associated with the expense report. |
USER_DEFINED_DATE
Indexed - yes
Format - date
May be null? yes |
Custom date/time specified by user. |
VAT_ENTRIES_COUNT
Indexed - no
Format - number
May be null? yes |
Total number of VAT entries submitted on the expense report. |
WAITING_PROCESSING
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the report is awaiting processing |
