TELEPHONE DETAIL Table
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.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BILLING_DATE |
Date telephone charges are billed to a cost collector. |
DATE |
8 |
CHARGE_AMOUNT |
Dollar amount of the telephone charge. |
NUMBER |
22 |
CHARGE_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
CHARGE_TYPE_KEY |
Key used to join the TELEPHONE_CHARGE_TYPE table to the TELEPHONE_DETAIL table, NOT for reporting. |
VARCHAR2 |
15 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
DATE_OF_CALL |
Date of itemized telephone call. |
DATE |
8 |
DESTINATION_PHONE |
Phone receiving the telephone call. |
VARCHAR2 |
12 |
EQUIPMENT_CHARGE_DESC |
Description of the telephone equipment charge. |
VARCHAR2 |
25 |
FROM_PLACE |
City where the telephone call originated. |
VARCHAR2 |
10 |
FROM_STATE |
State (country) where the telephone call originated. |
VARCHAR2 |
2 |
GL_ACCOUNT_KEY |
Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
IS_INTERNATIONAL_CALL |
Indicates whether or not a call is an international call as marked by the 5ESS switch by telephony rules. Please note that calls to countries whose country codes starts with "1+" (Canada and others) are marked as long distance and not as international calls by the switch. |
VARCHAR2 |
1 |
ORIGINATING_PHONE |
Phone which originated the telephone call. |
VARCHAR2 |
10 |
PHONE_LOCATION |
MIT Building and Room number where phone is located. |
VARCHAR2 |
15 |
TELEPHONE_BILLING_KEY |
Key used to join the TELEPHONE_BILLING_NUMBERS table to the TELEPHONE_DETAIL table, NOT for reporting. |
VARCHAR2 |
10 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
TIME_OF_CALL |
Time of itemized telephone call in HH:MM:SS format. |
VARCHAR2 |
8 |
TOTAL_CALLS |
Counter which lists the total calls for itemized and local summary charge subcategories. |
NUMBER |
22 |
TOTAL_MINUTES |
For itemized calls, the total minutes per call; for local summary calls, the total minutes for that charge subcategory. |
NUMBER |
11 |
TO_PLACE |
City receiving the telephone call. |
VARCHAR2 |
10 |
TO_STATE |
State (country) receiving the telephone call. |
VARCHAR2 |
2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |