TELECOM_CALL_DETAIL Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home

TELECOM_CALL_DETAIL Table

Explanation
Contains Telecommunications charge detail data, including originating and terminating number, location called, type of call, duration and cost. This data comprises the detail of TELECOM_INVOICE_SUMMARY.

Common Uses
Reporting on Telecommunications detail data for a given ORG or other accounting segment, for a given time period.

ACCOUNTING_PERIOD
CALL_DATE
COA_ACCOUNT
TRANSACTION_SEQ
USER_NUMBER

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
TRANSACTION_SEQ
USER_NUMBER

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
TELECOM_INVOICE_SUMMARY

• 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.
• Telecommunications charge and detail data are available (in the DWCHG schema in the Data Warehouse) from fiscal year 2006 (the AUG-05 period) and on.

TELECOM_CALL_DETAIL Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home