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 |
|---|---|---|---|---|---|---|
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-2022 |
|
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 |
|
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-2022 |