Penn Computing

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

CT_REPORT Table - Data Element Index

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



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.
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.
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

CT_REPORT 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