Penn Computing

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

ISC_BILLING_DETAIL Table

Explanation
Contains ISC Network Billing detail data, by accounting period. This data comprises the ISC Billing feeder (for IP, email and wall plate charges) aggregated amounts which are posted to the General Ledger on a monthly basis.

Common Uses
Reporting on detailed ISC billing data for a given ORG or other accounting segment, for a given time period.

Primary Key Indexed Data Elements Related Tables
ACCOUNTING_PERIOD
COA_ACCOUNT
DESC1
DESC2
DESC3
DESC4
ISC_INVOICE_NUMBER
ITEM
LOAD_DATE
SERVICE_ID    
SOURCE
TRANSACTION_AMOUNT
ACCOUNTING_PERIOD
CALENDAR_MONTH
CALENDAR_YEAR
COA_ACCOUNT
COA_CNAC
COA_CREF
COA_FUND
COA_OBJECT
COA_PROGRAM
COA_RESPONSIBLE_ORG
CYCLE_END_DATE
CYCLE_START_DATE
FISCAL_MONTH_SEQ
FISCAL_YEAR
INVOICE_DATE
SERVICE_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
  • This data comprises the ISC Billing feeder aggregated amounts which are posted to the General Ledger on a monthly basis. From fiscal year 2005 through 2017, the ISC_BILLING_DETAIL table contained only network billing (IP, email and wall plate) charges. Additonal services (e.g., voice installation, training, and more) were added in 2017. Details of services included, including their respective usage of the Item and Desc attributes, are described here.
  • The Cycle_Start_Date and Cycle_End_Date represent the time period for which the item was billed; the Invoice_Date, Accounting_Period and corresponding fiscal/calendar year information indicate the point at which the feeder containing this data was posted to the General Ledger.
  • ISC Billing Detail data is available (in the DWCHG schema in the Data Warehouse) from fiscal year 2005 (the AUG-04 period) and on.
  • Effective July 1, 2007, the IP service was renamed to CS as of July 1, 2007, to more accurately describe the charges as being for Central Service fees.
ISC_BILLING_DETAIL 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