TELEPHONE CHARGE TYPE Table
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.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CHARGE_CATEGORY |
Category of telephone charge type: itemized call charges, local summary charges and phone charges (including equipment & voice mail). |
VARCHAR2 |
30 |
CHARGE_SUBCATEGORY |
Subcategory of telephone charge categories: basic service charges; calling card calls; itemized calls, customer assigned; itemized calls, not customer assigned; local summary charges; telephone equipment charges; voice mail charges and voice mail equipment charges. |
VARCHAR2 |
40 |
CHARGE_TYPE_KEY |
Key used to join the TELEPHONE_CHARGE_TYPE table to the TELEPHONE_DETAIL table, NOT for reporting. |
VARCHAR2 |
15 |
IS_BASIC_SERVICE_CHARGE |
Flag indicating whether charge amount is a basic service charge: Y or N. |
VARCHAR2 |
1 |
IS_CALLING_CARD_CHARGE |
Flag indicating whether charge amount is a calling card charge: Y or N. |
VARCHAR2 |
1 |
IS_CUSTOMER_ASSIGNED_CHARGE |
Flag indicating whether charge amount is a customer assigned charge: Y or N. |
VARCHAR2 |
1 |
IS_IPASS_CHARGE |
Is this an ipass charge? Y or N. |
VARCHAR2 |
1 |
IS_ITEMIZED_CALL_CHARGE |
Flag indicating whether charge amount is an itemized call charge: Y or N. |
VARCHAR2 |
1 |
IS_LOCAL_SUMMARY_CHARGE |
Flag indicating whether charge amount is a local summary charge: Y or N. |
VARCHAR2 |
1 |
IS_PAGER_CHARGE |
XXX |
VARCHAR2 |
1 |
IS_PHONE_CHARGE |
Flag indicating whether charge amount is a phone charge: Y or N. |
VARCHAR2 |
1 |
IS_TELEPHONE_EQUIPMENT_CHARGE |
Flag indicating whether charge amount is a telephone equipment charge: Y or N. |
VARCHAR2 |
1 |
IS_VOICE_MAIL_CHARGE |
Flag indicating whether charge amount is a voice mail charge: Y or N. |
VARCHAR2 |
1 |
IS_VOICE_MAIL_EQUIPMENT_CHARGE |
Flag indicating whether charge amount is a voice mail equipment charge: Y or N. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |