Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

  
  UPDATES
Current Load Status
Regular Availability
  
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
  
  DATA COLLECTIONS
Advancement
Assets
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Student
Travel Expense Management
Tuition Distribution
Cross-Collection

Travel & Expense Management Collection Tables & Data Elements

Tables are listed in alphabetical order. Select Table to obtain the explanation, common uses, primary key, indexed data elements, related tables, and cautions for a table. Select Elements to obtain the definition, list of values, formats, and not null constraints for each data element in the table. A description of table and data element terminology is in the document What the Warehouse Contains.

CT_ALLOCATION
Table   Elements

CT_ATTENDEE
Table   Elements

CT_ATTENDEE_TYPE
Table   Elements

CT_AUTHORIZED_APPROVER
Table   Elements

CT_CAR_LOG_ENTRY
Table   Elements

CT_CASH_ADVANCE
Table   Elements

CT_CASH_ADVANCE_COMMENT
Table   Elements

CT_CASH_ADVANCE_ENTRY
Table   Elements

CT_CC_TRANS_CAR_RENTAL
Table   Elements

CT_CC_TRANS_LODGING
Table   Elements

CT_CC_TRANS_PURCHASE
Table   Elements

CT_CC_TRANS_TRAVEL
Table   Elements

CT_CC_TRANS_TRAVEL_DTL
Table   Elements

CT_COUNTRY
Table   Elements

CT_CREDIT_CARD_ACCOUNT
Table   Elements

CT_CREDIT_CARD_TRANSACTION
Table   Elements

CT_CTRY_CURRENCY_MAP
Table   Elements

CT_CTRY_SUBDIVISION
Table   Elements

CT_CURRENCY
Table   Elements



CT_DELEGATION
Table   Elements

CT_EXCEPTION
Table   Elements

CT_EXPENSE_CODE
Table   Elements

CT_EXPENSE_COMMENT
Table   Elements

CT_EXPENSE_TYPE
Table   Elements

CT_JOURNAL
Table   Elements

CT_LIST
Table   Elements

CT_LIST_CATEGORY
Table   Elements

CT_LIST_ITEM
Table   Elements

CT_LIST_ITEM_MAP
Table   Elements

CT_LOCATION
Table   Elements

CT_MERCHANT_CODE
Table   Elements

CT_PAYMENT_CODE
Table   Elements

CT_PAYMENT_TYPE
Table   Elements

CT_PERSON
Table   Elements

CT_PERSON_ROLE_MAP
Table   Elements

CT_POL_TR_EXP_CAT_MAP
Table   Elements

CT_POLICY
Table   Elements

CT_POLICY_EXPENSE_TYPE_MAP
Table   Elements



CT_POLICY_HIST
Table   Elements

CT_POLICY_LANG_HIST
Table   Elements

CT_REPORT
Table   Elements

CT_REPORT_ENTRY
Table   Elements

CT_REPORT_EXCEPTION
Table   Elements

CT_REPORT_STATUS_AUDIT
Table   Elements

CT_ROLE
Table   Elements

CT_STATUS
Table   Elements

CT_TA_DAY
Table   Elements

CT_TA_FIXED
Table   Elements

CT_TA_ITINERARY
Table   Elements

CT_TA_ITINERARY_ROW
Table   Elements

CT_TA_RATE
Table   Elements

CT_WORKFLOW_PROCESS
Table   Elements

CT_WORKFLOW_PROCESS_INSTANCE
Table   Elements

CT_WORKFLOW_STEP
Table   Elements

CT_WORKFLOW_STEP_INSTANCE
Table   Elements

CT_WORKFLOW_SUBJECT
Table   Elements

TEM_SAE_DETAIL
Table   Elements

Related GL reference tables included in the Travel & Expense universe:

CENTER_REF_CODES
Table   Element
CNAC_CODES
Table   Element
FUND_CODES
Table   Element
OBJECT_CODES
Table   Element
ORG_CODES
Table   Element
PROGRAM_CODES
Table   Element

Related Salary Management tables included in the Travel & Expense universe:

COMP_PERSON
Table   Element
EMPLOYEE_GENERAL
Table   Element
JOB_CLASS_GENERAL
Table   Element

  Collection Information:


top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania