TELEPHONE CHARGE TYPE Table
View exposing telephone charge-type reference data including charge category and subcategory together with indicators for phone, service, voicemail, equipment, itemized-call, calling-card, local-summary, pager, and iPass charges.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CHARGE_CATEGORY |
Charge category associated with the record. |
VARCHAR2 |
30 |
CHARGE_SUBCATEGORY |
Charge subcategory associated with the record. |
VARCHAR2 |
40 |
CHARGE_TYPE_KEY |
Surrogate key identifying the charge type. |
VARCHAR2 |
15 |
IS_BASIC_SERVICE_CHARGE |
Indicator identifying whether basic service charge (Y/N). |
VARCHAR2 |
1 |
IS_CALLING_CARD_CHARGE |
Indicator identifying whether calling card charge (Y/N). |
VARCHAR2 |
1 |
IS_CUSTOMER_ASSIGNED_CHARGE |
Indicator identifying whether customer assigned charge (Y/N). |
VARCHAR2 |
1 |
IS_IPASS_CHARGE |
Indicator identifying whether ipass charge (Y/N). |
VARCHAR2 |
1 |
IS_ITEMIZED_CALL_CHARGE |
Indicator identifying whether itemized call charge (Y/N). |
VARCHAR2 |
1 |
IS_LOCAL_SUMMARY_CHARGE |
Indicator identifying whether local summary charge (Y/N). |
VARCHAR2 |
1 |
IS_PAGER_CHARGE |
Indicator identifying whether pager charge (Y/N). |
VARCHAR2 |
1 |
IS_PHONE_CHARGE |
Is phone charge associated with the record. |
VARCHAR2 |
1 |
IS_TELEPHONE_EQUIPMENT_CHARGE |
Is telephone equipment charge associated with the record. |
VARCHAR2 |
1 |
IS_VOICE_MAIL_CHARGE |
Indicator identifying whether voice mail charge (Y/N). |
VARCHAR2 |
1 |
IS_VOICE_MAIL_EQUIPMENT_CHARGE |
Indicator identifying whether voice mail equipment charge (Y/N). |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |