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 |