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
ISC_INVOICE_NUMBER
ITEM
SERVICE_ID
|
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 XXX 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 XXXX 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.
Questions about this page? Email us at da-staff@isc.upenn.edu
|