Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TELEPHONE BILLING NUMBERS Table


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.


Field Name

Description

Data Type

Length

CALLING_CARD_USER

XXX

VARCHAR2

40

EQUIPMENT_COST_COLLECTOR

Default cost collector for telephone equipment charges.

VARCHAR2

7

ITEMIZED_CALL_COST_COLLECTOR

Default cost collector for telephone itemized call charges.

VARCHAR2

7

LISTED_DIRECTORY_NAME

Name associated with a particular extension as found in the MIT employee directory.

VARCHAR2

90

LOCAL_SUMMARY_COST_COLLECTOR

Default cost collector for telephone local summary charges.

VARCHAR2

7

MIT_EXTENSION

Five digit MIT extension.

VARCHAR2

5

PROFIT_CENTER_ID

A unique key that identifies the profit center.

VARCHAR2

7

PROFIT_CENTER_NAME

The text name of the profit center.

VARCHAR2

40

TELEPHONE_BILLING_KEY

Key used to join the TELEPHONE_BILLING_NUMBERS table to the TELEPHONE_DETAIL table, NOT for reporting.

VARCHAR2

10

TELEPHONE_BILLING_NUMBER

Telephone billing number to which charges are applied.

VARCHAR2

12

TELEPHONE_BILLING_TYPE

Type of telephone billing number: telephone, calling card or voice mail.

VARCHAR2

15

TELEPHONE_NUMBER_COUNTER

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

1

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8