Penn Computing

University of Pennsylvania
Penn Computing << go backback
MAINFRAME_CHGBK_SUMMARY Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home

MAINFRAME_CHGBK_SUMMARY Table

Explanation
Contains ISC Mainframe chargeback invoice summary data, by accounting period. This data comprises the chargeback feeder (journal source UMIS_CHARGES) aggregated amounts which are posted to the General Ledger on a monthly basis.

Common Uses
Reporting on Mainframe chargeback invoice summary data for a given Cost Center, ORG or other accounting segment, for a given time period.

Primary Key Indexed Data Elements Related Tables
ACCOUNTING_PERIOD
COA_ACCOUNT
MICS_COST_CENTER
INVOICE_CATEGORY
USER_ID   
ACCOUNTING_PERIOD
BILLING_CYCLE
CALENDAR_MONTH
CALENDAR_YEAR
COA_ACCOUNT
COA_CNAC
COA_CREF
COA_FUND
COA_OBJECT
COA_PROGRAM
COA_RESPONSIBLE_ORG
COST_CENTER
FISCAL_MONTH_SEQ
FISCAL_YEAR
INVOICE_CATEGORY
USER_ID
BALANCES
CENTER_REF_CODES
CNAC_CODES
FUND_CODES
GL_DETAIL
OBJECT_CODES
ORG_CODES
PARENT_CNAC_CODES
PARENT_FUND_CODES
PARENT_OBJECT_CODES
PARENT_ORG_CODES
PARENT_PROGRAM_CODES
PROGRAM_CODES

Cautions
  • The Accounting_Period and corresponding fiscal/calendar year information indicate the point at which the feeder containing this data was posted to the General Ledger. The Billing_Cycle represents the calendar year and month in which the mainframe activity occurred. Note that activity that occured in June will be posted to the ADJ period (e.g., for activity in June 2007, Billing_Cycle will be 200712, Accounting_Period will be ADJ-07, Fiscal_Year will be 2007, Fiscal_Month_Seq will be 13).
  • Mainframe chargeback summary data is available in the Warehouse (DWCHG schema) from fiscal year 2007 (the AUG-06 period, since July activity is posted to the August period) and on.
MAINFRAME_CHGBK_SUMMARY Table - Data Element Index   Tables and Data Elements   General Ledger 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