Penn Computing

University of Pennsylvania
Penn Computing << go backback
TEM_SAE_DETAIL Table - Data Element Index   Tables and Data Elements   Travel & Expense Management Home   Data Warehouse Home

TEM_SAE_DETAIL Table

Explanation
The TEM_SAE_DETAIL table contains Concur Expense standard accounting extract (SAE) report feeder lines as loaded to BEN Financials.

Common Uses
Reviewing SAE records loaded to BEN Financials.

Primary Key Indexed Data Elements Related Tables 
SAE_BATCH_ID
SAE_BATCH_SEQ_NUM
 
ALLOCATION_COST_OBJ_CNAC
ALLOCATION_COST_OBJ_FUND
ALLOCATION_COST_OBJ_ORG
ALLOCATION_COST_OBJ_RESPORG
ALLOCATION_SCHOOL_CTR
CCARD_TRX_MERCHANT_COUNTRY
CCARD_TRX_MERCHANT_NAME
DESTINATION_COUNTRY_CODE
FULL_NAME
JOUNAL_ACCOUNT_OBJECT_CODE
LAST_NAME
PAYMENT_TYPE_CODE
PENN_ID
PERSON_COST_OBJ_CNAC
PERSON_COST_OBJ_CREF
PERSON_COST_OBJ_FUND
PERSON_COST_OBJ_ORG
PERSON_COST_OBJ_PROGRAM
PERSON_COST_OBJ_RESPORG
PERSON_HOME_ORG
PERSON_SCHOOL_CTR
SAE_BATCH_DATE
SAE_BATCH_ID
TEM_RPT_COST_OBJ_CNAC
TEM_RPT_COST_OBJ_CREF
TEM_RPT_COST_OBJ_FUND
TEM_RPT_COST_OBJ_ORG
TEM_RPT_COST_OBJ_PROGRAM
TEM_RPT_COST_OBJ_RESPORG
TEM_RPT_COUNTRY_CODE
TEM_RPT_ENTRY_DESC
TEM_RPT_ENTRY_EXPENSE_TYPE
TEM_RPT_ENTRY_ID
TEM_RPT_ENTRY_SPEND_CONTRY
TEM_RPT_ENTRY_SPEND_CTRY_SUBCD
TEM_RPT_ENTRY_TRX_DATE
TEM_RPT_ENTRY_TRX_TYPE
TEM_RPT_ENTRY_VENDOR_DESC
TEM_RPT_ID
TEM_RPT_NAME
TEM_RPT_PROCESS_DATE
TEM_RPT_SCHOOL_CTR
TEM_RPT_SUBMIT_DATE
 
CENTER_REF_CODES (DWADMIN)
CNAC_CODES (DWADMIN)
COMP_PERSON (DWCOMP)
CT_ALLOCATION (DWGL)
CT_COUNTRY (DWGL)
CT_CTRY_SUBDIVISION (DWGL)
CT_JOURNAL (DWGL)
CT_REPORT (DWGL)
CT_REPORT_ENTRY (DWGL)
CT_MERCHANT_CODE (DWGL)
EMPLOYEE (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
FUND_CODES (DWADMIN)
OBJECT_CODES (DWADMIN)
ORG_CODES (DWADMIN)
PROGRAM_CODES (DWADMIN)

Cautions

  • TEM_SAE_DETAIL contains Concur Expense report feeder lines as loaded to BEN Financials. Only records that have been fed to BEN are included. For expense report header information (for reports in any status), refer to CT_REPORT. For line-level detail of reports in any status, refer to CT_REPORT_ENTRY. To view summary report information as it was loaded to BEN Financials, refer to TEM_SAE_DETAIL.
  • Rows in TEM_SAE_DETAIL are visible based on access to PERSON_HOME_ORG, TEM_RPT_COST_OBJ_ORG, TEM_RPT_COST_OBJ_RESPORG, PERSON_COST_OBJ_ORG, PERSON_COST_OBJ_RESPORG, ALLOCATION_COST_OBJ_ORG, ALLOCATION_COST_OBJ_RESPORG.
  • The TEM_SAE_DETAIL table is stored in the DWGL schema in the Data Warehouse.

Source

Concur Expense, in use at Penn since 2013.

TEM_SAE_DETAIL Table - Data Element Index   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