Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Telephone Detail


Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.


Table Name

Description

Type

Primary Provider

Sensitivity

Load Frequency

Last Load Date

TELEPHONE_BILLING_NUMBERS

Contains information about telephone numbers at MIT, including default cost collectors, profit center assignments, and listed directory names. The Telephone_Billing_Number is the source telephone charges are billed to.

Dimension

Telecommunications

MIT ONLY

Monthly

28-APR-2019

TELEPHONE_CHARGE_TYPE

Contains information about the types of telephone charges broken down into categories and subcategories. Categories include Itemized, Local summary and Phone charges. subcategories include Basic Service Charges; Voice Mail Charges; Telephone Equipment Charges; Voice Mail Equipment Charges; Calling Card Calls; Itemized Calls, Customer Assigned; Itemized Calls, Not Customer Assigned; and Local Summary Charges.

Dimension

Telecommunications

MIT ONLY

As Needed

15-JUN-1999

TELEPHONE_DETAIL

Contains information about telephone charges. Detailed information about charge amounts resides in this table. Data about call length, total calls, total minutes, date of call, and time of call is also available.

Fact

Telecommunications

SENSITIVE

Monthly

28-APR-2019