Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TELEPHONE BILLING NUMBERS Table


View exposing telephone billing-number reference data including billing number, billing type, MIT extension, directory name, calling-card user, profit center, cost collectors for equipment and call charges, and telephone number counter.


Field Name

Description

Data Type

Length

CALLING_CARD_USER

Calling card user associated with the record.

VARCHAR2

40

EQUIPMENT_COST_COLLECTOR

Equipment cost collector associated with the record.

VARCHAR2

7

ITEMIZED_CALL_COST_COLLECTOR

Itemized call cost collector associated with the record.

VARCHAR2

7

LISTED_DIRECTORY_NAME

Listed directory name associated with the record.

VARCHAR2

90

LOCAL_SUMMARY_COST_COLLECTOR

Local summary cost collector associated with the record.

VARCHAR2

7

MIT_EXTENSION

Mit extension associated with the record.

VARCHAR2

5

PROFIT_CENTER_ID

Business identifier for the profit center.

VARCHAR2

7

PROFIT_CENTER_NAME

Profit center name associated with the record.

VARCHAR2

40

TELEPHONE_BILLING_KEY

Telephone billing key associated with the record.

VARCHAR2

60

TELEPHONE_BILLING_NUMBER

Telephone billing number associated with the record.

VARCHAR2

60

TELEPHONE_BILLING_TYPE

Telephone billing type associated with the record.

VARCHAR2

15

TELEPHONE_NUMBER_COUNTER

Telephone number counter associated with the record.

NUMBER

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE