Oracle® Communications Data Model Reference 11g Release 2 (11.2) Part Number E15886-04 |
|
|
PDF · Mobi · ePub |
This chapter provides information about the physical data model of Oracle Communications Data Model.
This chapter includes the following sections:
The Physical Data Model of the Oracle Communications Data Model is the physical manifestation of the logical data model into database tables and relationships (or foreign key constraints). Partitions, indexes, and Materialized Views have been added to aid performance.
The Physical data model includes the following:
Important:
Do not make changes to the schemas as such changes are not supported.Table 4-1 shows the table name prefix conventions. When you examine the predefined physical model, keep in mind the naming conventions shown in Table 4-1 that use DW (Data Warehouse) prefixes to identify the types of tables and views.
Table 4-2 briefly describes the Reference tables in Oracle Communications Data Model.
Table Name | Description | More information |
---|---|---|
DWR_ACCS_MTHD |
ACCESS METHOD |
|
DWR_ACCS_MTHD_ACCT_ASGN |
ACCESS METHOD ACCOUNT ASSIGNMENT |
|
DWR_ACCS_MTHD_ASGN |
ACCESS METHOD ASSIGNMENT |
|
DWR_ACCS_MTHD_ELMNT |
ACCESS METHOD ELEMENT |
|
DWR_ACCS_MTHD_EQPMNT_ASGN |
ACCESS METHOD EQUIPMENT ASSIGNMENT |
|
DWR_ACCS_MTHD_GEO_ASGN |
ACCESS METHOD GEOGRAPHY ASSIGNMENT |
|
DWR_ACCS_MTHD_POOL |
ACCESS METHOD POOL |
|
DWR_ACCS_MTHD_PRTY_ASGN |
ACCESS METHOD PARTY ASSIGNMENT |
|
DWR_ACCS_MTHD_SBRP_ASGN |
ACCESS METHOD SUBSCRIPTION ASSIGNMENT |
|
DWR_ACCS_MTHD_SGMNT |
ACCESS METHOD SEGMENT |
|
DWR_ACCSRS |
ACCESSORIES |
|
DWR_ACCT |
ACCOUNT |
|
DWR_ACCT_ASGN |
ACCOUNT ASSIGNMENT |
|
DWR_ACCT_BLLG_CYCL_HIST |
ACCOUNT BILLING CYCLE HISTORY |
|
DWR_ACCT_BLLG_FRQNCY_HIST |
ACCOUNT BILLING FREQUENCY HISTORY |
|
DWR_ACCT_BLLG_PRD_HIST |
ACCOUNT BILLING PERIOD HISTORY |
|
DWR_ACCT_BSNS_INTRACN_RL |
ACCOUNT BUSINESS INTERACTION ROLE |
|
DWR_ACCT_CNRT_RLTN |
ACCOUNT CONTRACT RELATIONSHIP |
|
DWR_ACCT_PREF_INVC_DLVRY |
ACCOUNT PREFERRED INVOICE DELIVERY |
|
DWR_ACCT_PREF_PYMT_MTHD |
ACCOUNT PREFERRED PAYMENT METHOD |
|
DWR_ACCT_PRFL |
ACCOUNT PROFILE |
|
DWR_ACCT_PRTY_PMP_RLTN |
ACCOUNT PARTY PMP RELATIONSHIP |
|
DWR_ACCT_SBRP_ASGN |
ACCOUNT SUBSCRIPTION ASSIGNMENT |
|
DWR_ACCT_SGMNT |
ACCOUNT SEGMENT |
|
DWR_ACCT_SGMNT_ASGN_HIST |
ACCOUNT SEGMENT ASSIGNMENT HISTORY |
|
DWR_ACCT_SGMNT_MDL |
ACCOUNT SEGMENTATION MODEL |
|
DWR_ADDR_LCTN_NAME |
ADDRESS LOCATION NAME |
|
DWR_ADDR_LOC |
ADDRESS LOCATION |
|
DWR_ADDR_RLTD |
ADDRESS RELATED |
|
DWR_ADTNL_TXT |
ADDITIONAL TEXT |
|
DWR_ADVR_PRD |
ADVERTISING PERIOD |
|
DWR_ADVR_QTR |
ADVERTISING QUARTER |
|
DWR_ADVR_WK |
ADVERTISING WEEK |
|
DWR_ADVR_YR |
ADVERTISING YEAR |
|
DWR_AGGRTN_INTRFC |
AGGREGATION INTERFACE |
|
DWR_ALWNCE_SBRP_PRICE_ALTRTN |
ALLOWANCE SBRP PRICE ALTERNATION |
|
DWR_AMRCN_PRPTY_ADDR |
AMERICAN PROPERTY ADDRESS |
|
DWR_AM_SGMNT_PROD_CPBLTY_RL |
ACCESS METHOD SEGMENT PROD CAPABILITY RL |
|
DWR_ANZSIC_CLSFCTN |
ANZSIC CLASSIFICATION |
|
DWR_ATM_INTRFC |
ATM INTERFACE |
|
DWR_ATONOMS_SYS |
AUTONOMOUS SYSTEM |
|
DWR_AUXILIARY_CMPNT |
AUXILIARY COMPONENT |
|
DWR_BASE_DAY |
BASE DAY |
|
DWR_BASE_STN_CNTRLR |
BASE STATION CONTROLLER |
|
DWR_BASE_TRNSCVR_STN |
BASE TRANSCEIVER STATION |
|
DWR_BNK |
BANK |
|
DWR_BNK_DRCT_DEBT_CHNL |
BANK DIRECT DEBIT CHANNEL |
|
DWR_BRDBND |
BROADBAND |
|
DWR_BRDBND_RTNG_PLN |
BROADBAND RATING PLAN |
|
DWR_BRDGNG_PROTCL |
BRIDGING PROTOCOL |
|
DWR_BRND |
BRAND |
|
DWR_BSNS_HLF_MO |
BUSINESS HALF MONTH |
|
DWR_BSNS_HLF_YR |
BUSINESS HALF YEAR |
|
DWR_BSNS_INTRACN_ASGN |
BUSINESS INTERACTION ASSIGNMENT |
|
DWR_BSNS_INTRACN_LOC_ASGN |
BUSINESS INTERACTION LOCATION ASSIGNMENT |
|
DWR_BSNS_INTRACN_RL |
BUSINESS INTERACTION ROLE |
|
DWR_BSNS_INTRACN_VRSN |
BUSINESS INTERACTION VERSION |
|
DWR_BSNS_MO |
BUSINESS MONTH |
|
DWR_BSNS_QTR |
BUSINESS QUARTER |
|
DWR_BSNS_UNIT_JB_RL |
BUSINESS UNIT JOB ROLE |
|
DWR_BSNS_UNIT_SHFT |
BUSINESS UNIT SHIFT |
|
DWR_BSNS_WK |
BUSINESS WEEK |
|
DWR_BSNS_YR |
BUSINESS YEAR |
|
DWR_CALL_CNTR |
CALL CENTER |
|
DWR_CALL_CNTR_AGNT |
CALL CENTER AGENT |
|
DWR_CALL_CNTR_SRVC_CAPBLTY |
CALL CENTER SERVICE CAPABILITY |
|
DWR_CALL_FRWD |
CALL FORWARD |
|
DWR_CALL_SRC_DSTN |
CALL SOURCE DESTINATION |
|
DWR_CALLR_ID |
CALLER ID |
|
DWR_CARD |
CARD |
|
DWR_CARD_RLTN |
CARD RELATIONSHIP |
|
DWR_CBL |
CABLE |
|
DWR_CBL_MDM |
CABLE MODEM |
|
DWR_CELL |
CELL |
|
DWR_CELL_SCTR |
CELL SECTOR |
|
DWR_CELL_SITE |
CELL SITE |
|
DWR_CFS_SPEC_VRSN_DTL |
CFS SPEC VERSION DETAIL |
|
DWR_CHASSIS |
CHASSIS |
|
DWR_CHASSIS_POSN |
CHASSIS POSITION |
|
DWR_CHNL |
CHANNEL |
|
DWR_CLNDR_HLF_MO |
CALENDAR HALF MONTH |
|
DWR_CLNDR_HLF_YR |
CALENDAR HALF YEAR |
|
DWR_CLNDR_MO |
CALENDAR MONTH |
|
DWR_CLNDR_QTR |
CALENDAR QUARTER |
|
DWR_CLNDR_WK |
CALENDAR WEEK |
|
DWR_CLNDR_YR |
CALENDAR YEAR |
|
DWR_CMPGN |
CAMPAIGN |
|
DWR_CMPGN_CHNL_ASGN |
CAMPAIGN CHANNEL ASSIGNMENT |
|
DWR_CMPGN_CHNL |
CAMPAIGN CHANNEL |
|
DWR_CMPGN_CHTRSTC |
CAMPAIGN CHARACTERISTIC |
|
DWR_CMPGN_CHTRSTC_VAL |
CAMPAIGN CHARACTERISTIC VALUE |
|
DWR_CMPGN_DOC |
CAMPAIGN DOCUMENT |
|
DWR_CMPGN_MGMT_HIST |
CAMPAIGN MANAGEMENT HISTORY |
|
DWR_CMPGN_MSG |
CAMPAIGN MESSAGE |
|
DWR_CMPGN_MSG_DPCT |
CAMPAIGN MESSAGE DEPICTION |
|
DWR_CMPGN_RLTN |
CAMPAIGN RELATIONSHIP |
|
DWR_CMPGN_TERM_VAL |
CAMPAIGN TERM VALUE |
|
DWR_CMPND_ELMNT |
COMPOUND ELEMENT |
|
DWR_CMPND_ELMNT_CMPND_DTL |
COMPOUND ELEMENT COMPOUND DETAIL |
|
DWR_CMPND_ELMNT_COLLCTN |
COMPOUND ELEMENT COLLECTION |
|
DWR_CMPND_ELMNT_DTL |
COMPOUND ELEMENT DETAIL |
|
DWR_CMPND_ELMNT_LGICL_DTL |
COMPOUND ELEMENT LOGICAL DETAIL |
|
DWR_CMPND_ELMNT_PHY_DTL |
COMPOUND ELEMENT PHYSICAL DETAIL |
|
DWR_CMPND_ELMNT_RL |
COMPOUND ELEMENT ROLE |
|
DWR_CMPND_ELMNT_RL_ASGN |
COMPOUND ELEMENT ROLE ASSIGNMENT |
|
DWR_CMPND_ELMNT_RL_SPEC |
COMPOUND ELEMENT ROLE SPEC |
|
DWR_CMPND_ELMNT_TP_DTL |
COMPOUND ELEMENT TP DETAIL |
|
DWR_CMPND_ELMNT_UNIT |
COMPOUND ELEMENT UNIT |
|
DWR_CMPNT_SBRP_PRICE |
COMPONENT SUBSCRIPTION PRICE |
|
DWR_CMPST_COMP_PROD_CRL_CHTRTC |
COMPOSITE COMP PROD CRRL CHARACTERISTIC |
|
DWR_CMPST_PROD_RTNG_PLN |
COMPOSITE PRODUCT RATING PLAN |
|
DWR_CMPST_PROD_RTNG_PLN_ASGN |
COMPOSITE PRODUCT RATING PLAN ASSIGNMENT |
|
DWR_CMPST_SBRP_PRICE |
COMPOSITE SUBSCRIPTION PRICE |
|
DWR_CMPST_SRVC |
COMPOSITE SERVICE |
|
DWR_CMPST_SRVC_INCLSN |
COMPOSITE SERVICE INCLUSION |
|
DWR_CMPST_SRVC_TYP_INCLSN |
COMPOSITE SERVICE TYPE INCLUSION |
|
DWR_CMPTR |
COMPETITOR |
|
DWR_CMPTR_INTLGNCE |
COMPETITOR INTELLIGENCE |
|
DWR_CMPTR_INTLGNCE_PRTY_RL |
COMPETITOR INTELLIGENCE PARTY ROLE |
|
DWR_CMPTR_MKT_SGMNT_ASGN |
COMPETITOR MARKET SEGMENT ASSIGNMENT |
|
DWR_CMPTR_MKT_SGMNT_SWOT |
COMPETITOR MARKET SEGMENT SWOT |
|
DWR_CMPTR_PROD_CRLTN |
COMPETITOR PRODUCT CORRELATION |
|
DWR_CMPTR_SWOT |
COMPETITOR SWOT |
|
DWR_CMPTR_TIER_ASGN |
COMPETITOR TIER ASSIGNMENT |
|
DWR_CMPTVE_TIER |
COMPETITIVE TIER |
|
DWR_CNCT_LST |
CONTACT LIST |
|
DWR_CNCTN |
CONNECTION |
|
DWR_CNCTN_TMNT_PNT |
CONNECTION TERMINATION POINT |
|
DWR_CNRT |
CONTRACT |
|
DWR_CNRT_ASGN |
CONTRACT ASSIGNMENT |
|
DWR_CNRT_DOC |
CONTRACT DOCUMENT |
|
DWR_CNRT_ITEM |
CONTRACT ITEM |
|
DWR_CNRT_PROD_ASGN |
CONTRACT PRODUCT ASSIGNMENT |
|
DWR_CNSEQ_PRFMNC_NTFCTN |
CONSEQUENCE PERFORMANCE NOTIFICATION |
|
DWR_CNSEQ_PRFMNC_NTFCTN_SPEC |
CONSEQUENCE PERFORMANCE NOTIFICATION SPEC |
|
DWR_CNTNT |
CONTENT |
|
DWR_CNTNT_PRICE |
CONTENT PRICE |
|
DWR_CNTNT_PRVDR |
CONTENT PROVIDER |
|
DWR_COLLCTN |
COLLECTION |
|
DWR_COLLCTN_AGNCY |
COLLECTION AGENCY |
|
DWR_COMP_INTL_CHTRSTC |
COMP INTEL CHARACTERISTIC |
|
DWR_COMP_INTL_CHTRSTC_VAL |
COMP INTEL CHARACTERISTIC VALUE |
|
DWR_COMP_INTL_MKT_SGMNT |
COMP INTEL MARKET SEGMENT |
|
DWR_COMP_PROD_CRRL_CHTRSTC |
COMP PROD CRRL CHARACTERISTIC |
|
DWR_COMP_PROD_CRRL_CHTRTC_ASGN |
COMP PROD CRRL CHARACTERISTIC ASSIGNMENT |
|
DWR_COMP_PROD_CRRL_CHRSTC_RLTN |
COMP PROD CRRL CHARACTERISTIC RELATIONSHIP |
|
DWR_COMP_PROD_CRRL_CHTRSTC_VAL |
COMP PROD CRRL CHARACTERISTIC VALUE |
|
DWR_COMUNICTN_SRVC |
COMMUNICATION SERVICE |
|
DWR_CORE_INTRFC |
CORE INTERFACE |
|
DWR_COST_CNTR |
COST CENTER |
|
DWR_COURIER |
COURIER |
|
DWR_CPCTY |
CAPACITY |
|
DWR_CPE_LGICL_DVC_RL |
CPE LOGICAL DEVICE ROLE |
|
DWR_CRCUT_CMPNT |
CIRCUIT COMPONENT |
|
DWR_CRDT_CTGRY |
CREDIT CATEGORY |
|
DWR_CRDT_SCR_PRVDR |
CREDIT SCORE PROVIDER |
|
DWR_CRNCY_GEO_ENT_ASGN |
CURRENCY GEOGRAPHY ENTITY ASSIGNMENT |
|
DWR_CUST |
CUSTOMER |
|
DWR_CUST_CLASS_ASGN |
CUSTOMER CLASS ASSIGNMENT |
|
DWR_CUST_DOC |
CUSTOMER DOCUMENT |
|
DWR_CUST_DT_NODE |
||
DWR_CUST_FCNG_SRVC |
CUSTOMER FACING SERVICE |
|
DWR_CUST_FCNG_SRVC_RL |
CUSTOMER FACING SERVICE ROLE |
|
DWR_CUST_FCNG_SRVC_SPEC_RL |
CUSTOMER FACING SERVICE SPEC ROLE |
|
DWR_CUST_FCNG_SRVC_SPEC_VRSN |
CUSTOMER FACING SERVICE SPEC VERSION |
|
DWR_CUST_GRP_ASGN |
CUSTOMER GROUP ASSIGNMENT |
|
DWR_CUST_INDVL |
CUSTOMER INDIVIDUAL |
|
DWR_CUST_OCCSN |
CUSTOMER OCCASION |
|
DWR_CUST_ORDR_DOC |
CUSTOMER ORDER DOCUMENT |
|
DWR_CUST_ORG |
CUSTOMER ORGANIZATION |
|
DWR_CUST_RSTRCT_INFO |
CUSTOMER RESTRICTED INFO |
|
DWR_CUST_RVN_BND_ASGN |
CUSTOMER REVENUE BAND ASSIGNMENT |
|
DWR_CUST_SCR |
CUSTOMER SCORE |
|
DWR_CUST_SGMNT |
CUSTOMER SEGMENT |
|
DWR_CUST_SGMNT_MDL |
CUSTOMER SEGMENTATION MODEL |
|
DWR_CUST_SIC_ASGN |
CUSTOMER SIC ASSIGNMENT |
|
DWR_CUST_SRC |
CUSTOMER SOURCE |
|
DWR_DAY |
DAY |
|
DWR_DAY_ACT_CONDITION |
DAY ACTUAL CONDITION |
|
DWR_DAY_TODATE_TRANS |
DAY TODATE TRANSFORMATION |
|
DWR_DAY_TRANS |
DAY TRANSFORMATION |
|
DWR_DEAL |
DEAL |
|
DWR_DEAL_VNDR_ITEM_ASGN |
DEAL VENDOR ITEM ASSIGNMENT |
|
DWR_DEMOG_ATRIB |
DEMOGRAPHY ATTRIBUTE |
|
DWR_DEMOG_CHTRSTC |
DEMOGRAPHIC CHARACTERISTIC |
|
DWR_DEMOG_CHTRSTC_VAL |
DEMOGRAPHIC CHARACTERISTIC VALUE |
|
DWR_DEMOG_GRP |
DEMOGRAPHY GROUP |
|
DWR_DISC_GRP |
DISCOUNT GROUP |
|
DWR_DISC_SBRP_PRICE_ALTRTN |
DISCOUNT SBRP PRICE ALTERATION |
|
DWR_DLR |
DEALER |
|
DWR_DLR_DISC_GRP_ASGN |
DEALER DISCOUNT GROUP ASSIGNMENT |
|
DWR_DOC_TYP_GRP_ASGN |
DOCUMENT TYPE GROUP ASSIGNMENT |
|
DWR_DRVD_VAL |
DERIVED VALUE |
|
DWR_DSL_MDM |
DSL MODEM |
|
DWR_DVC_INTRFC |
DEVICE INTERFACE |
|
DWR_DVC_INTRFC_DTL |
DEVICE INTERFACE DETAIL |
|
DWR_DVC_INTRFC_PHY_PRT_ASGN |
DEVICE INTERFACE PHYSICAL PORT ASSIGNMENT |
|
DWR_DVC_INTRFC_RL |
DEVICE INTERFACE ROLE |
|
DWR_DVC_INTRFC_TP_ASGN |
DEVICE INTERFACE TP ASSIGNMENT |
|
DWR_EDGE_INTRFC |
EDGE INTERFACE |
|
DWR_ELMNT_CHTRSTC |
ELEMENT CHARACTERISTIC |
|
DWR_ELMNT_CHTRSTC_ASGN |
ELEMENT CHARACTERISTIC ASSIGNMENT |
|
DWR_ELMNT_CHTRSTC_RLTN |
ELEMENT CHARACTERISTIC RELATIONSHIP |
|
DWR_ELMNT_CHTRSTC_VAL |
ELEMENT CHARACTERISTIC VALUE |
|
DWR_ELMNT_CHTRSTC_VAL_ASGN |
ELEMENT CHARACTERISTIC VALUE ASSIGNMENT |
|
DWR_ELMNT_CHTRSTC_VAL_RLTN |
ELEMENT CHARACTERISTIC VALUE RELATIONSHIP |
|
DWR_EMP |
EMPLOYEE |
|
DWR_EMP_DISC_GRP_ASGN |
EMPLOYEE DISCOUNT GROUP ASSIGNMENT |
|
DWR_EMP_JB_RL_ASGN |
EMPLOYEE JOB ROLE ASSIGNMENT |
|
DWR_EMP_LANG_CAPBLTY |
EMPLOYEE LANGUAGE CAPABILITY |
|
DWR_EMP_RSTRCT_INFO |
EMPLOYEE RESTRICTED INFO |
|
DWR_EMP_SCHL |
EMPLOYEE SCHEDULE |
|
DWR_ENT |
ENTITY |
|
DWR_ENT_RL |
ENTITY ROLE |
|
DWR_ENT_SPECFTN |
ENTITY SPECIFICATION |
|
DWR_EQPMNT |
EQUIPMENT |
|
DWR_EQPMNT_CNTR |
EQUIPMENT CENTER |
|
DWR_EQPMNT_FNCTNLTY |
EQUIPMENT FUNCTIONALITY |
|
DWR_EQPMNT_FNCTNLTY_ASGN |
EQUIPMENT FUNCTIONALITY ASSIGNMENT |
|
DWR_EQPMNT_HLDR |
EQUIPMENT HOLDER |
|
DWR_EQPMNT_INSTNC |
EQUIPMENT INSTANCE |
|
DWR_EQPMNT_INSTNC_RENTING_CNRT |
EQUIPMENT INSTANCE RENTING CONTRACT |
|
DWR_EQPMNT_SBRP |
EQUIPMENT SUBSCRIPTION |
|
DWR_EVT_LOC |
EVENT LOCATION |
|
DWR_EVT_PRTY_RL |
EVENT PARTY ROLE |
|
DWR_EVT_RSLTN |
EVENT RESOLUTION |
|
DWR_EXCLD_PRT_DTL |
EXCLUDE PORT DETAIL |
|
DWR_EXTRNL_CRDT_PRFL |
EXTERNAL CREDIT PROFILE |
|
DWR_EXTRNL_CRDT_PRFL_ASGN |
EXTERNAL CREDIT PROFILE ASSIGNMENT |
|
DWR_EXTRNL_INFO_SRC |
EXTERNAL INFORMATION SOURCE |
|
DWR_EXTRNL_OPRTR |
EXTERNAL OPERATOR |
|
DWR_FCTR_CMPNY |
FACTOR COMPANY |
|
DWR_FIXED_LN |
FIXED LINE |
|
DWR_FIXED_LN_PRT |
FIXED LINE PORT |
|
DWR_FIXED_LN_RTNG_PLN |
FIXED LINE RATING PLAN |
|
DWR_FRWL_RL |
FIREWALL ROLE |
|
DWR_FSCL_HLF_MO |
FISCAL HALF MONTH |
|
DWR_FSCL_HLF_YR |
FISCAL HALF YEAR |
|
DWR_FSCL_MO |
FISCAL MONTH |
|
DWR_FSCL_QTR |
FISCAL QUARTER |
|
DWR_FSCL_WK |
FISCAL WEEK |
|
DWR_FSCL_YR |
FISCAL YEAR |
|
DWR_FXBLE_CHTRSTC |
FLEXIBLE CHARACTERISTIC |
|
DWR_FXBLE_CHTRSTC_ASGN |
FLEXIBLE CHARACTERISTIC ASSIGNMENT |
|
DWR_FXBLE_CHTRSTC_ASGN_TYP |
FLEXIBLE CHARACTERISTIC ASSIGNMENT TYPE |
|
DWR_FXBLE_CHTRSTC_RLTN |
FLEXIBLE CHARACTERISTIC RELATIONSHIP |
|
DWR_FXBLE_CHTRSTC_TYP |
FLEXIBLE CHARACTERISTIC TYPE |
|
DWR_FXBLE_CHTRSTC_VAL |
FLEXIBLE CHARACTERISTIC VALUE |
|
DWR_FXBLE_CHTRSTC_VAL_ASGN |
FLEXIBLE CHARACTERISTIC VALUE ASSIGNMENT |
|
DWR_FXBLE_CHTRSTC_VAL_RLTN |
FLEXIBLE CHARACTERISTIC VALUE RELATIONSHIP |
|
DWR_GEO_BLDG |
GEOGRAPHY BUILDING |
|
DWR_GEO_CITY |
GEOGRAPHY CITY |
|
DWR_GEO_CNTRY |
GEOGRAPHY COUNTRY |
|
DWR_GEO_CNTY |
GEOGRAPHY COUNTY |
|
DWR_GEO_DEMOG_ATRIB |
GEOGRAPHY DEMOGRAPHY ATTRIBUTE |
|
DWR_GEO_DEMOG_GRP |
GEOGRAPHY DEMOGRAPHIC GROUP |
|
DWR_GEO_DEMOG_VAL |
GEOGRAPHY DEMOGRAPHY VALUE |
|
DWR_GEO_ENT |
GEOGRAPHY ENTITY |
|
DWR_GEO_ENT_ASGN |
GEOGRAPHY ENTITY ASSIGNMENT |
|
DWR_GEO_ENT_HIER_LVL_ASGN |
GEOGRAPHY ENTITY HIER LEVEL ASSIGNMENT |
|
DWR_GEO_HRCHY |
GEOGRAPHY HIERARCHY |
|
DWR_GEO_HRCHY_LVL |
GEOGRAPHY HIERARCHY LEVEL |
|
DWR_GEO_HRCHY_LVL_ASGN |
GEOGRAPHY HIERARCHY LEVEL ASSIGNMENT |
|
DWR_GEO_LVL |
GEOGRAPHY LEVEL |
|
DWR_GEO_LVL_ATRIB |
GEOGRAPHY LEVEL ATTRIBUTE |
|
DWR_GEO_LVL_ATRIB_VAL |
GEOGRAPHY LEVEL ATTRIBUTE VALUE |
|
DWR_GEO_NIEHBRHD |
GEOGRAPHY NEIGHBORHOOD |
|
DWR_GEO_RGN |
GEOGRAPHY REGION |
|
DWR_GEO_SBRGN |
GEOGRAPHY SUB REGION |
|
DWR_GEO_STATE |
GEOGRAPHY STATE |
|
DWR_GEO_STRT |
GEOGRAPHY STREET |
|
DWR_GEO_WORLD |
GEOGRAPHY WORLD |
|
DWR_GL_REF |
GL REFERENCE |
|
DWR_GPRS_SRVC |
GPRS SERVICE |
|
DWR_HH |
HOUSEHOLD |
|
DWR_HLDR_ATMC |
HOLDER ATOMIC |
|
DWR_HLDR_CMPST |
HOLDER COMPOSITE |
|
DWR_HLF_HR |
HALF HOUR |
|
DWR_HLF_MO_TODATE_TRANS |
HALF MONTH TODATE TRANSFORMATION |
|
DWR_HLF_MO_TRANS |
HALF MONTH TRANSFORMATION |
|
DWR_HLF_YR_TODATE_TRANS |
HALF YEAR TODATE TRANSFORMATION |
|
DWR_HLF_YR_TRANS |
HALF YEAR TRANSFORMATION |
|
DWR_HNDST_INSTNC |
HANDSET INSTANCE |
|
DWR_HNDST_MDL |
HANDSET MODEL |
|
DWR_HR |
HOUR |
|
DWR_HRDWR |
HARDWARE |
|
DWR_IDD |
IDD |
|
DWR_IN_PLTFRM |
IN PLATFORM |
|
DWR_IN_RUTNG_DVC |
IN ROUTING DEVICE |
|
DWR_INDVL_DEMOG_PRFL |
INDIVIDUAL DEMOGRAPHY PROFILE |
|
DWR_INDVL_DEMOG_VAL |
INDIVIDUAL DEMOGRAPHY VALUE |
|
DWR_INDVL_NAME |
INDIVIDUAL NAME |
|
DWR_INTRACN_CHNL |
INTERACTION CHANNEL |
|
DWR_INVC_ADJ_QTA |
INVOICE ADJUSTMENT QUOTA |
|
DWR_INVC_PYMT_TRM |
INVOICE PAYMENT TERM |
|
DWR_IP_ADDR |
IP ADDRESS |
|
DWR_IP_ADDR_POOL |
IP ADDRESS POOL |
|
DWR_IP_SUBNET |
IP SUBNET |
|
DWR_IPV4_ADDR |
IPV4 ADDRESS |
|
DWR_ISP |
ISP |
|
DWR_ISP_BSNS |
ISP BUSINESS |
|
DWR_ISP_BSNS_ASGN |
ISP BUSINESS ASSIGNMENT |
|
DWR_ISP_USER |
ISP USER |
|
DWR_ITEM |
ITEM |
|
DWR_JB |
JOB |
|
DWR_JB_RL |
JOB ROLE |
|
DWR_KEY_PRFMNC_IND_SLS_PARM |
KEY PERFORMANCE INDICATOR SLS PARM |
|
DWR_KEY_QLTY_IND_SLS_PARM |
KEY QUALITY INDICATOR SLS PARM |
|
DWR_LAN |
LAN |
|
DWR_LAN_PROTCL |
LAN PROTOCOL |
|
DWR_LANG_DIALECT |
LANGUAGE DIALECT |
|
DWR_LAYER_NTWK |
LAYER NETWORK |
|
DWR_LCL_ADDR_LOC |
LOCAL ADDRESS LOCATION |
|
DWR_LGICL_CPCTY |
LOGICAL CAPACITY |
|
DWR_LGICL_DVC |
LOGICAL DEVICE |
|
DWR_LGICL_DVC_ATMC |
LOGICAL DEVICE ATOMIC |
|
DWR_LGICL_DVC_CMPST |
LOGICAL DEVICE COMPOSITE |
|
DWR_LGICL_DVC_OS_ASGN |
LOGICAL DEVICE OS ASSIGNMENT |
|
DWR_LGICL_DVC_RL |
LOGICAL DEVICE ROLE |
|
DWR_LGICL_DVC_RL_SPEC |
LOGICAL DEVICE ROLE SPEC |
|
DWR_LGICL_ELMNT |
LOGICAL ELEMENT |
|
DWR_LGICL_ELMNT_PHY_SPPRT |
LOGICAL ELEMENT PHYSICAL SUPPORT |
|
DWR_LGICL_ELMNT_RL |
LOGICAL ELEMENT ROLE |
|
DWR_LGICL_ELMNT_RL_ASGN |
LOGICAL ELEMENT ROLE ASSIGNMENT |
|
DWR_LGICL_ELMNT_RL_SPEC |
LOGICAL ELEMENT ROLE SPEC |
|
DWR_LGICL_ELMNT_SPEC_PHY_SPPRT |
LOGICAL ELEMENT SPEC PHYSICAL SUPPORT |
|
DWR_LGICL_ELMNT_TYP_VRSN |
LOGICAL ELEMENT TYPE VERSION |
|
DWR_LGICL_INTRFC |
LOGICAL INTERFACE |
|
DWR_LYLTY_PROG |
LOYALTY PROGRAM |
|
DWR_LYLTY_PROG_CHNL |
LOYALTY PROGRAM CHANNEL |
|
DWR_MAILBOX |
MAILBOX |
|
DWR_MANAGED_ENT |
MANAGED ENTITY |
|
DWR_MANAGED_HRDWR |
MANAGED HARDWARE |
|
DWR_MANAGED_TRNSMISN_ENT |
MANAGED TRANSMISSION ENTITY |
|
DWR_MBL_SWTCHNG_CNTR |
MOBILE SWITCHING CENTER |
|
DWR_MEDIA_INTRFC |
MEDIA INTERFACE |
|
DWR_MEDIA_OBJ |
MEDIA OBJECT |
|
DWR_MEDIA_OBJ_ASGN |
MEDIA OBJECT ASSIGNMENT |
|
DWR_MGMT_DOMAIN |
MANAGEMENT DOMAIN |
|
DWR_MGMT_PROTCL |
MANAGEMENT PROTOCOL |
|
DWR_MKT_AREA |
MARKET AREA |
|
DWR_MKT_AREA_LVL |
MARKET AREA LEVEL |
|
DWR_MKT_PLN_DOC_REQRMNT |
MARKET PLAN DOCUMENT REQUIREMENT |
|
DWR_MKT_PLN_SUB_BY_DOC |
MARKET PLAN SUBSTITUTE BY DOC |
|
DWR_MKT_PLN_TERM_VAL |
MARKET PLAN TERM VALUE |
|
DWR_MKT_SGMNT |
MARKET SEGMENT |
|
DWR_MKT_SGMNT_CHTRSTC |
MARKET SEGMENT CHARACTERISTIC |
|
DWR_MKT_SGMNT_CHTRSTC_VAL |
MARKET SEGMENT CHARACTERISTIC VALUE |
|
DWR_MKT_STTSTCS |
MARKET STATISTICS |
|
DWR_MMS |
MMS |
|
DWR_MNT |
MINUTE |
|
DWR_MO_TODATE_TRANS |
MONTH TODATE TRANSFORMATION |
|
DWR_MO_TRANS |
MONTH TRANSFORMATION |
|
DWR_MUS_DNLD |
MUSIC DOWNLOAD |
|
DWR_NAICS_CLSFCTN |
NAICS CLASSIFICATION |
|
DWR_NAICS_INDSTRY |
NAICS INDUSTRY |
|
DWR_NAICS_INDSTRY_GRP |
NAICS INDUSTRY GROUP |
|
DWR_NAICS_INDSTRY_SCTR |
NAICS INDUSTRY SECTOR |
|
DWR_NAICS_INDSTRY_SUBSCTR |
NAICS INDUSTRY SUBSECTOR |
|
DWR_NBR_AREA |
NUMBER AREA |
|
DWR_NBR_CNTRY |
NUMBER COUNTRY |
|
DWR_NEGOTIATED_SRVC_LVL_SPEC |
NEGOTIATED SERVICE LEVEL SPEC |
|
DWR_NP_MBL_MSISDN |
NP MOBILE MSISDN |
|
DWR_NTWK |
NETWORK |
|
DWR_NTWK_ADDR |
NETWORK ADDRESS |
|
DWR_NTWK_ADDR_INTRFC_BNDNG |
NETWORK ADDRESS INTERFACE BINDING |
|
DWR_NTWK_ASGN |
NETWORK ASSIGNMENT |
|
DWR_NTWK_ATMC |
NETWORK ATOMIC |
|
DWR_NTWK_CMPST |
NETWORK COMPOSITE |
|
DWR_NTWK_DOMAIN |
NETWORK DOMAIN |
|
DWR_NTWK_ELMNT |
NETWORK ELEMENT |
|
DWR_NTWK_ELMNT_BSNS_INTRACN_RL |
NETWORK ELEMENT BUSINESS INTERACTION ROLE |
|
DWR_NTWK_ELMNT_PRTY_ASSOCTN |
NETWORK ELEMENT PARTY ASSOCIATION |
|
DWR_NTWK_ELMNT_PRTY_MGMT |
NETWORK ELEMENT PARTY MANAGEMENT |
|
DWR_NTWK_ELMNT_RL |
NETWORK ELEMENT ROLE |
|
DWR_NTWK_ELMNT_RL_ASGN |
NETWORK ELEMENT ROLE ASSIGNMENT |
|
DWR_NTWK_ELMNT_RL_PRTY_ASGN |
NETWORK ELEMENT ROLE PARTY ASSIGNMENT |
|
DWR_NTWK_ELMNT_RL_SPEC |
NETWORK ELEMENT ROLE SPEC |
|
DWR_NTWK_ELMNT_RLTN |
NETWORK ELEMENT RELATIONSHIP |
|
DWR_NTWK_ELMNT_TYP |
NETWORK ELEMENT TYPE |
|
DWR_NTWK_ELMNT_TYP_VRSN |
NETWORK ELEMENT TYPE VERSION |
|
DWR_NTWK_ELMNT_TYP_VRSN_USG |
NETWORK ELEMENT TYPE VERSION USAGE |
|
DWR_NTWK_ELMNT_USG |
NETWORK ELEMENT USAGE |
|
DWR_NTWK_EVT_CHTRSTC |
NETWORK EVENT CHARACTERISTIC |
|
DWR_NTWK_EVT_CHTRSTC_ASGN |
NETWORK EVENT CHARACTERISTIC ASSIGNMENT |
|
DWR_NTWK_EVT_CHTRSTC_RLTN |
NETWORK EVENT CHARACTERISTIC RELATIONSHIP |
|
DWR_NTWK_EVT_CHTRSTC_VAL |
NETWORK EVENT CHARACTERISTIC VALUE |
|
DWR_NTWK_EVT_CHTRSTC_VAL_ASGN |
NETWORK EVENT CHARACTERISTIC VALUE ASSIGNMENT |
|
DWR_NTWK_EVT_CHTRSTC_VAL_RLTN |
NETWORK EVENT CHARACTERISTIC VALUE RELATIONSHIP |
|
DWR_NTWK_EVT_TYP_VRSN |
NETWORK EVENT TYPE VERSION |
|
DWR_NTWK_ROUTE |
NETWORK ROUTE |
|
DWR_NTWK_ROUTE_PNT |
NETWORK ROUTE POINT |
|
DWR_NTWK_ROUTE_PNT_ASGN |
NETWORK ROUTE POINT ASSIGNMENT |
|
DWR_NTWK_SITE |
NETWORK SITE |
|
DWR_NTWK_SRVC_COVRG_ASGN |
NETWORK SERVICE COVERAGE ASSIGNMENT |
|
DWR_NTWK_TCHPNT |
NETWORK TOUCHPOINT |
|
DWR_OPERTNG_SYS |
OPERATING SYSTEM |
|
DWR_ORDR_LN_ITEM_STATE |
ORDER LINE ITEM STATE |
|
DWR_ORG_AREA |
ORGANIZATION AREA |
|
DWR_ORG_BNR |
ORGANIZATION BANNER |
|
DWR_ORG_BSNS_ENT |
ORGANIZATION BUSINESS ENTITY |
|
DWR_ORG_BSNS_UNIT |
ORGANIZATION BUSINESS UNIT |
|
DWR_ORG_CHAIN |
ORGANIZATION CHAIN |
|
DWR_ORG_CMPNY |
ORGANIZATION COMPANY |
|
DWR_ORG_CRPRT |
ORGANIZATION CORPORATE |
|
DWR_ORG_DIV |
ORGANIZATION DIVISION |
|
DWR_ORG_DSTRCT |
ORGANIZATION DISTRICT |
|
DWR_ORG_HRCHY |
ORGANIZATION HIERARCHY |
|
DWR_ORG_HRCHY_LVL |
ORGANIZATION HIERARCHY LEVEL |
|
DWR_ORG_HRCHY_LVL_ASGN |
ORGANIZATION HIERARCHY LEVEL ASSIGNMENT |
|
DWR_ORG_HRCHY_VRSN |
ORGANIZATION HIERARCHY VERSION |
|
DWR_ORG_ITEM_SLNG_PRICE |
ORGANIZATION ITEM SELLING PRICE |
|
DWR_ORG_LVL |
ORGANIZATION LEVEL |
|
DWR_ORG_LVL_ATRIB_VAL |
ORGANIZATION LEVEL ATTRIBUTE VALUE |
|
DWR_ORG_LVL_ATTR |
ORGANIZATION LEVEL ATTRIBUTES |
|
DWR_ORG_MKT_DATA |
ORGANIZATION MARKET DATA |
|
DWR_ORG_NAME |
ORGANIZATION NAME |
|
DWR_ORG_RGN |
ORGANIZATION REGION |
|
DWR_ORG_SRVC_WBSITE |
ORGANIZATION SERVICE WEBSITE |
|
DWR_ORG_WRHS |
ORGANIZATION WAREHOUSE |
|
DWR_ORGNTL_DEMOG_VAL |
ORGANIZATIONAL DEMOGRAPHY VALUE |
|
DWR_OS_LICNS_ASGN |
OS LICENSE ASSIGNMENT |
|
DWR_OTHR_INDVL |
OTHER INDIVIDUAL |
|
DWR_PASPRT |
PASSPORT |
|
DWR_PAY_TV |
PAY TV |
|
DWR_PBLCTN |
PUBLICATION |
|
DWR_PE_LGICL_DVC_RL |
PE LOGICAL DEVICE ROLE |
|
DWR_PHONE_NBR |
TELEPHONE NUMBER |
|
DWR_PHONE_NBR_POOL |
TELEPHONE NUMBER POOL |
|
DWR_PHY_CMPNT |
PHYSICAL COMPONENT |
|
DWR_PHY_CNCTR |
PHYSICAL CONNECTOR |
|
DWR_PHY_CONTNR |
PHYSICAL CONTAINER |
|
DWR_PHY_CPCTY |
PHYSICAL CAPACITY |
|
DWR_PHY_CPCTY_DTL |
PHYSICAL CAPACITY DETAIL |
|
DWR_PHY_DVC |
PHYSICAL DEVICE |
|
DWR_PHY_DVC_ATMC |
PHYSICAL DEVICE ATOMIC |
|
DWR_PHY_DVC_CMPST |
PHYSICAL DEVICE COMPOSITE |
|
DWR_PHY_DVC_RL_SPEC |
PHYSICAL DEVICE ROLE SPEC |
|
DWR_PHY_DVC_RL_SPEC_DTL |
PHYSICAL DEVICE ROLE SPEC DETAIL |
|
DWR_PHY_DVC_SPEC |
PHYSICAL DEVICE SPEC |
|
DWR_PHY_ELMNT |
PHYSICAL ELEMENT |
|
DWR_PHY_ELMNT_CHTRSTC |
PHYSICAL ELEMENT CHARACTERISTIC |
|
DWR_PHY_ELMNT_RL |
PHYSICAL ELEMENT ROLE |
|
DWR_PHY_ELMNT_RL_ASGN |
PHYSICAL ELEMENT ROLE ASSIGNMENT |
|
DWR_PHY_ELMNT_RL_SPEC |
PHYSICAL ELEMENT ROLE SPEC |
|
DWR_PHY_EQPMNT |
PHYSICAL EQUIPMENT |
|
DWR_PHY_LNK |
PHYSICAL LINK |
|
DWR_PHY_PRT |
PHYSICAL PORT |
|
DWR_PHY_PRT_RESRE_PRT_ASGN |
PHYSICAL PORT RESOURCE PORT ASSIGNMENT |
|
DWR_PHY_RESRE_RL_SPEC_DTL |
PHYSICAL RESOURCE ROLE SPEC DETAIL |
|
DWR_PIPE |
PIPE |
|
DWR_PLCY |
POLICY |
|
DWR_PLCY_ACTN |
POLICY ACTION |
|
DWR_PLCY_ACTN_ASGN |
POLICY ACTION ASSIGNMENT |
|
DWR_PLCY_ACTN_ATMC |
POLICY ACTION ATOMIC |
|
DWR_PLCY_ACTN_CMPST |
POLICY ACTION COMPOSITE |
|
DWR_PLCY_ACTN_RULE_ASGN |
POLICY ACTION RULE ASSIGNMENT |
|
DWR_PLCY_ACTN_VNDR |
POLICY ACTION VENDOR |
|
DWR_PLCY_APPLN_ASGN |
POLICY APPLICATION ASSIGNMENT |
|
DWR_PLCY_CNDTN |
POLICY CONDITION |
|
DWR_PLCY_CNDTN_ASGN |
POLICY CONDITION ASSIGNMENT |
|
DWR_PLCY_CNDTN_ATMC |
POLICY CONDITION ATOMIC |
|
DWR_PLCY_CNDTN_CMPST |
POLICY CONDITION COMPOSITE |
|
DWR_PLCY_CNDTN_RULE_ASGN |
POLICY CONDITION RULE ASSIGNMENT |
|
DWR_PLCY_GRP |
POLICY GROUP |
|
DWR_PLCY_GRP_EXEC_DTL |
POLICY GROUP EXECUTION DETAIL |
|
DWR_PLCY_OPRTR |
POLICY OPERATOR |
|
DWR_PLCY_OPRTR_VARBLE_ASGN |
POLICY OPERATOR VARIABLE ASSIGNMENT |
|
DWR_PLCY_RL |
POLICY ROLE |
|
DWR_PLCY_RULE |
POLICY RULE |
|
DWR_PLCY_SET |
POLICY SET |
|
DWR_PLCY_SET_ASGN |
POLICY SET ASSIGNMENT |
|
DWR_PLCY_STMT |
POLICY STATEMENT |
|
DWR_PLCY_VAL |
POLICY VALUE |
|
DWR_PLCY_VARBLE |
POLICY VARIABLE |
|
DWR_PLCY_VARBLE_VAL_ASGN |
POLICY VARIABLE VALUE ASSIGNMENT |
|
DWR_PLNG_PRD |
PLANNING PERIOD |
|
DWR_PLNG_QTR |
PLANNING QUARTER |
|
DWR_PLNG_SEASON |
PLANNING SEASON |
|
DWR_PLNG_WK |
PLANNING WEEK |
|
DWR_PLNG_YR |
PLANNING YEAR |
|
DWR_PMP_AVLBLTY |
PMP AVAILABILITY |
|
DWR_PMP_LYLTY_PROG_AVLBLTY |
PMP LOYALTY PROGRAM AVAILABILITY |
|
DWR_PMP_MKT_SGMNT_AVLBLTY |
PMP MARKET SEGMENT AVAILABILITY |
|
DWR_PMP_ORG_AVLBLTY |
PMP ORGANIZATION AVAILABILITY |
|
DWR_PMP_PRICE_PLCY_ACTN |
PMP PRICE POLICY ACTION |
|
DWR_PMP_PRICE_PLCY_CNDTN |
PMP PRICE POLICY CONDITION |
|
DWR_PMP_PRICE_PLCY_VAL |
PMP PRICE POLICY VALUE |
|
DWR_PMP_PRICE_PLCY_VARBLE |
PMP PRICE POLICY VARIABLE |
|
DWR_PMP_PROD_INSTNC_ASGN |
PMP PRODUCT INSTANCE ASSIGNMENT |
|
DWR_PMP_RTNG_PLN |
PMP RATING PLAN |
|
DWR_PMP_RTNG_PLN_DTL |
PMP RATING PLAN DETAIL |
|
DWR_PNT_CD |
POINT CODE |
|
DWR_POSTCD |
POSTCODE |
|
DWR_PRICE_DRVTN_RULE |
PRICE DERIVATION RULE |
|
DWR_PRD_TODATE_TRANS |
PERIOD TO DATE TRANSFORMATION |
|
DWR_PRD_TRANS |
PERIOD TRANSFORMATION |
|
DWR_PRFMNC |
PERFORMANCE |
|
DWR_PRFMNC_APLBLETY |
PERFORMANCE APPLICABILITY |
|
DWR_PRFMNC_CAT_CHTRSTC_VAL |
PERFORMANCE CAT CHARACTERISTIC VALUE |
|
DWR_PRFMNC_CAT_SPECFTN |
PERFORMANCE CAT SPECIFICATION |
|
DWR_PRFMNC_CAT_SPEC_RLTN |
PERFORMANCE CAT SPEC RELATIONSHIP |
|
DWR_PRFMNC_CHTRSTC_VAL |
PERFORMANCE CHARACTERISTIC VALUE |
|
DWR_PRFMNC_CNSEQ |
PERFORMANCE CONSEQUENCE |
|
DWR_PRFMNC_CTGRY |
PERFORMANCE CATEGORY |
|
DWR_PRFMNC_CTGRY_RLTN |
PERFORMANCE CATEGORY RELATIONSHIP |
|
DWR_PRFMNC_IND |
PERFORMANCE INDICATOR |
|
DWR_PRFMNC_IND_RLTN |
PERFORMANCE INDICATOR RELATIONSHIP |
|
DWR_PRFMNC_IND_SPECFTN |
PERFORMANCE INDICATOR SPECIFICATION |
|
DWR_PRFMNC_IND_SPEC_RLTN |
PERFORMANCE INDICATOR SPEC RELATIONSHIP |
|
DWR_PRFMNC_IP_ADDR |
PERFORMANCE IP ADDRESS |
|
DWR_PRFMNC_MBL_ADDR |
PERFORMANCE MOBILE ADDRESS |
|
DWR_PRFMNC_NTFCTN |
PERFORMANCE NOTIFICATION |
|
DWR_PRFMNC_NTFCTN_SPECFTN |
PERFORMANCE NOTIFICATION SPECIFICATION |
|
DWR_PRFMNC_NTWK_ADDR |
PERFORMANCE NETWORK ADDRESS |
|
DWR_PRFMNC_OBJCTV |
PERFORMANCE OBJECTIVE |
|
DWR_PRFMNC_OBJCTV_APLBLETY |
PERFORMANCE OBJECTIVE APPLICABILITY |
|
DWR_PRFMNC_OBJ_APLBLETY_CNSEQ |
PERFORMANCE OBJECTIVE APPLICABILITY CONSEQUENCE |
|
DWR_PRFMNC_PNT_CD |
PERFORMANCE POINT CODE |
|
DWR_PRFMNC_SPECFTN |
PERFORMANCE SPECIFICATION |
|
DWR_PRFMNC_SPECFTN_INTRVL |
PERFORMANCE SPECIFICATION INTERVAL |
|
DWR_PRFMNC_SPEC_INTRVL_CNVRSN |
PERFORMANCE SPEC INTERVAL CONVERSION |
|
DWR_PRMTN |
PROMOTION |
|
DWR_PRMTN_MKT_PLN_ASGN |
PROMOTION MARKET PLAN ASSIGNMENT |
|
DWR_PRMTN_MSG_RNDRNG |
PROMOTION MESSAGE RENDERING |
|
DWR_PRMTN_PROD_ASGN |
PROMOTION PRODUCT ASSIGNMENT |
|
DWR_PRMTN_PROD_CTLG_ASGN |
PROMOTION PRODUCT CATALOG ASSIGNMENT |
|
DWR_PRMTN_RLTN |
PROMOTION RELATIONSHIP |
|
DWR_PRMTN_SL_CHNL_ASGN |
PROMOTION SALES CHANNEL ASSIGNMENT |
|
DWR_PROD |
PRODUCT |
|
DWR_PROD_ADTNL_TXT |
PRODUCT ADDITIONAL TEXT |
|
DWR_PROD_ASGN |
PRODUCT ASSIGNMENT |
|
DWR_PROD_CAPBLTY |
PRODUCT CAPABILITY |
|
DWR_PROD_CAPBLTY_VAL |
PRODUCT CAPABILITY VALUE |
|
DWR_PROD_CHRG_TYP_RLTN |
PRODUCT CHARGE TYPE RELATIONSHIP |
|
DWR_PROD_CHTRSTC |
PRODUCT CHARACTERISTIC |
|
DWR_PROD_CHTRSTC_ASGN |
PRODUCT CHARACTERISTIC ASSIGNMENT |
|
DWR_PROD_CHTRSTC_RLTN |
PRODUCT CHARACTERISTIC RELATIONSHIP |
|
DWR_PROD_CHTRSTC_VAL |
PRODUCT CHARACTERISTIC VALUE |
|
DWR_PROD_CHTRSTC_VAL_ASGN |
PRODUCT CHARACTERISTIC VALUE ASSIGNMENT |
|
DWR_PROD_CHTRSTC_VAL_RLTN |
PRODUCT CHARACTERISTIC VALUE RELATIONSHIP |
|
DWR_PROD_COVRG_AREA |
PRODUCT COVERAGE AREA |
|
DWR_PROD_COVRG_GEO_DTL |
PRODUCT COVERAGE GEO DETAIL |
|
DWR_PROD_CTLG |
PRODUCT CATALOG |
|
DWR_PROD_CTLG_CHTRSTC |
PRODUCT CATALOG CHARACTERISTIC |
|
DWR_PROD_CTLG_CHTRSTC_ASGN |
PRODUCT CATALOG CHARACTERISTIC ASSIGNMENT |
|
DWR_PROD_CTLG_CHTRSTC_RLTN |
PRODUCT CATALOG CHARACTERISTIC RELATIONSHIP |
|
DWR_PROD_CTLG_CHTRSTC_VAL |
PRODUCT CATALOG CHARACTERISTIC VALUE |
|
DWR_PROD_CTLG_CHTRSTC_VAL_ASGN |
PRODUCT CATALOG CHARACTERISTIC VALUE ASSIGNMENT |
|
DWR_PROD_CTLG_CHTRSTC_VAL_RLTN |
PRODUCT CATALOG CHARACTERISTIC VALUE RELATIONSHIP |
|
DWR_PROD_CTLG_GEO_ASGN |
PRODUCT CATALOG GEOGRAPHY ASSIGNMENT |
|
DWR_PROD_CTLG_MKT_PLN_ASGN |
PRODUCT CATALOG MARKET PLAN ASSIGNMENT |
|
DWR_PROD_CTLG_SL_CHNL_ASGN |
PRODUCT CATALOG SALES CHANNEL ASSIGNMENT |
|
DWR_PROD_FNCTNLTY_DPNDNTCY |
PRODUCT FUNCTIONALITY DEPENDENCY |
|
DWR_PROD_FTR |
PRODUCT FEATURE |
|
DWR_PROD_FTR_ASGN |
PRODUCT FEATURE ASSIGNMENT |
|
DWR_PROD_GEO_ASGN |
PRODUCT GEOGRAPHY ASSIGNMENT |
|
DWR_PROD_GRP_ASGN |
PRODUCT GROUP ASSIGNMENT |
|
DWR_PROD_INSTNC |
PRODUCT INSTANCE |
|
DWR_PROD_MKT_PLN |
PRODUCT MARKET PLAN |
|
DWR_PROD_MKT_PLN_ASGN |
PRODUCT MARKET PLAN ASSIGNMENT |
|
DWR_PROD_MKT_PLN_GEO_ASGN |
PRODUCT MARKET PLAN GEOGRAPHY ASSIGNMENT |
|
DWR_PROD_MKT_PLN_GRP |
PRODUCT MARKET PLAN GROUP |
|
DWR_PROD_MKT_PLN_GRP_ASGN |
PRODUCT MARKET PLAN GROUP ASSIGNMENT |
|
DWR_PROD_MKT_PLN_RLTN |
PRODUCT MARKET PLAN RELATIONSHIP |
|
DWR_PROD_NTWK_ASGN |
PRODUCT NETWORK ASSIGNMENT |
|
DWR_PROD_PKG |
PRODUCT PACKAGE |
|
DWR_PROD_PKG_ASGN |
PRODUCT PACKAGE ASSIGNMENT |
|
DWR_PROD_RTNG_PLN |
PRODUCT RATING PLAN |
|
DWR_PROD_RTNG_PLN_DTL |
PRODUCT RATING PLAN DETAIL |
|
DWR_PROD_USRNM |
PRODUCT USERNAME |
|
DWR_PROD_VRSN |
PRODUCT VERSION |
|
DWR_PROPOSAL |
PROPOSAL |
|
DWR_PROPOSAL_RLTN |
PROPOSAL RELATIONSHIP |
|
DWR_PROTCL |
PROTOCOL |
|
DWR_PRPD_MBL_VCHR |
PREPAID MOBILE VOUCHER |
|
DWR_PRPD_VCHR |
PREPAID VOUCHER |
|
DWR_PRPD_WRLS |
PREPAID WIRELESS |
|
DWR_PRPTY |
PROPERTY |
|
DWR_PRPTY_ADDR_LOC_ASGN |
PROPERTY ADDRESS LOCATION ASSIGNMENT |
|
DWR_PRSPCT |
PROSPECT |
|
DWR_PRSPCT_INDVL |
PROSPECT INDIVIDUAL |
|
DWR_PRSPCT_ORG |
PROSPECT ORGANIZATION |
|
DWR_PRSPCT_QLTY_SCR_VAL |
PROSPECT QUALITY SCORE VALUE |
|
DWR_PRTNR_PRMTN_PROG |
PARTNER PROMOTION PROGRAM |
|
DWR_PRTY |
PARTY |
|
DWR_PRTY_ACCT_ASGN |
PARTY ACCOUNT ASSIGNMENT |
|
DWR_PRTY_ADDR_LOC_ASGN |
PARTY ADDRESS LOCATION ASSIGNMENT |
|
DWR_PRTY_ASGN |
PARTY ASSIGNMENT |
|
DWR_PRTY_BSNS_INTRACN_RL |
PARTY BUSINESS INTERACTION ROLE |
|
DWR_PRTY_CNCT_INFO |
PARTY CONTACT INFORMATION |
|
DWR_PRTY_CNRT_ASGN |
PARTY CONTRACT ASSIGNMENT |
|
DWR_PRTY_DEMOG |
PARTY DEMOGRAPHIC |
|
DWR_PRTY_DEMOG_VAL |
PARTY DEMOGRAPHY VALUE |
|
DWR_PRTY_GEO_ENT_ASGN |
PARTY GEOGRAPHY ENTITY ASSIGNMENT |
|
DWR_PRTY_ID |
PARTY IDENTIFICATION |
|
DWR_PRTY_LANG_CAPBLTY |
PARTY LANGUAGE CAPABILITY |
|
DWR_PRTY_LYLTY_PROG_PRTCPTN |
PARTY LOYALTY PROGRAM PARTICIPATION |
|
DWR_PRTY_MKT_SGMNT_ASGN |
PARTY MARKET SEGMENT ASSIGNMENT |
|
DWR_PRTY_NAME |
PARTY NAME |
|
DWR_PRTY_PRFL_CHTRSTC |
PARTY PROFILE CHARACTERISTIC |
|
DWR_PRTY_PRFL_CHTRSTC_VAL |
PARTY PROFILE CHARACTERISTIC VALUE |
|
DWR_PRTY_RL_ASGN |
PARTY ROLE ASSIGNMENT |
|
DWR_PRTY_RL_OS_PRCS_ASGN |
PARTY ROLE OS PROCESS ASSIGNMENT |
|
DWR_PRTY_RL_STAT |
PARTY ROLE STATUS |
|
DWR_PRTY_SBRP_ASGN |
PARTY SUBSCRIPTION ASSIGNMENT |
|
DWR_PRTY_SIM_CARD_ASGN |
PARTY SIM CARD ASSIGNMENT |
|
DWR_PRTY_SKILL |
PARTY SKILL |
|
DWR_PRTY_SRVC_ASGN |
PARTY SERVICE ASSIGNMENT |
|
DWR_PSTPD_WRLS |
POSTPAID WIRELESS |
|
DWR_PVAR_BIT_STRING_VARBLE |
PVAR BIT STRING VARIABLE |
|
DWR_PVAR_STRING_VARBLE |
PVAR STRING VARIABLE |
|
DWR_PV_BIT_STRING_VAL |
PV BIT STRING VALUE |
|
DWR_PV_BOLEN_VAL |
PV BOOLEAN VALUE |
|
DWR_PV_INTEGER_VAL |
PV INTEGER VALUE |
|
DWR_PV_IP_ADDR_VAL |
PV IP ADDRESS VALUE |
|
DWR_PV_STRING_VAL |
PV STRING VALUE |
|
DWR_PYMT_CHNL |
PAYMENT CHANNEL |
|
DWR_P_LGICL_DVC_RL |
P LOGICAL DEVICE ROLE |
|
DWR_QOS_SRVC |
QOS SERVICE |
|
DWR_QTR_HR |
QUARTER HOUR |
|
DWR_QTR_TODATE_TRANS |
QUARTER TO DATE TRANSFORMATION |
|
DWR_QTR_TRANS |
QUARTER TRANSFORMATION |
|
DWR_RACK |
RACK |
|
DWR_RCRNG_PMP_RTNG_PLN_DTL |
RECURRING PMP RATING PLAN DETAIL |
|
DWR_RESRE_FCNG_SRVC |
RESOURCE FACING SERVICE |
|
DWR_RESRE_FCNG_SRVC_RL |
RESOURCE FACING SERVICE ROLE |
|
DWR_RESRE_FCNG_SRVC_SPEC_RL |
RESOURCE FACING SERVICE SPEC ROLE |
|
DWR_RESRE_FCNG_SRVC_SPEC_VRSN |
RESOURCE FACING SERVICE SPEC VERSION |
|
DWR_RESRE_PRFMNC |
RESOURCE PERFORMANCE |
|
DWR_RESRE_PRFMNC_SPEC |
RESOURCE PERFORMANCE SPEC |
|
DWR_RESRE_PRT |
RESOURCE PORT |
|
DWR_RESRE_SPEC_PERF_RL |
RESOURCE SPEC PERF ROLE |
|
DWR_RFS_SPEC_VRSN_DTL |
RFS SPEC VERSION DETAIL |
|
DWR_RF_CARRIER |
RF CARRIER |
|
DWR_RLS_HRCHY |
ROLES HIERARCHY |
|
DWR_RL |
ROLE |
|
DWR_RNGTN |
RINGTONE |
|
DWR_ROOT_ENT |
ROOT ENTITY |
|
DWR_ROUTED_PROTCL |
ROUTED PROTOCOL |
|
DWR_ROUTER |
ROUTER |
|
DWR_RTL_STORE |
RETAIL STORE |
|
DWR_RUTNG_DVC |
ROUTING DEVICE |
|
DWR_RUTNG_PROTCL |
ROUTING PROTOCOL |
|
DWR_RUTNG_RL |
ROUTING ROLE |
|
DWR_SB_NTWK |
SUB NETWORK |
|
DWR_SBRP |
SUBSCRIPTION |
|
DWR_SBRP_ASGN |
SUBSCRIPTION ASSIGNMENT |
|
DWR_SBRP_CLASS_OF_SRVC |
SUBSCRIPTION SERVICE CLASS ASSIGNMENT |
|
DWR_SBRP_NTWK_ELMNT_RL_ASGN |
SUBSCRIPTION NETWORK ELEMENT ROLE ASSIGNMENT |
|
DWR_SBRP_PMP_ASGN |
SUBSCRIPTION PMP ASSIGNMENT |
|
DWR_SBRP_PRICE |
SUBSCRIPTION PRICE |
|
DWR_SBRP_PRICE_ALTRTN |
SUBSCRIPTION PRICE ALTERATION |
|
DWR_SBRP_PRICE_CHRG |
SUBSCRIPTION PRICE CHARGE |
|
DWR_SBRP_PRICE_PRTY_RL_ASGN |
SUBSCRIPTION PRICE PARTY ROLE ASSIGNMENT |
|
DWR_SBRP_SRVC_CLASS_ASGN |
SUBSCRIPTION SERVICE CLASS ASSIGNMENT |
|
DWR_SCND |
SECOND |
|
DWR_SCRPT |
SCRIPT |
|
DWR_SCRPT_QUES |
SCRIPT QUESTION |
|
DWR_SECURE_HLDR |
SECURE HOLDER |
|
DWR_SET_TOP_BOX |
SET TOP BOX |
|
DWR_SET_TOP_BOX_MDL |
SET TOP BOX MODEL |
|
DWR_SGMNT_CRTRA |
SEGMENT CRITERIA |
|
DWR_SGNLNG_PROTCL |
SIGNALING PROTOCOL |
|
DWR_SHELF |
SHELF |
|
DWR_SIC_ASGN |
SIC ASSIGNMENT |
|
DWR_SIC_DIV |
SIC DIVISION |
|
DWR_SIM_CARD |
SIM CARD |
|
DWR_SIM_CARD_ACCS_MTHD_ASGN |
SIM CARD ACCESS METHOD ASSIGNMENT |
|
DWR_SIM_CARD_HNDST_ASGN |
SIM CARD HANDSET ASSIGNMENT |
|
DWR_SIM_CARD_SBRP_ASGN |
SIM CARD SUBSCRIPTION ASSIGNMENT |
|
DWR_SITE |
SITE |
|
DWR_SITE_INTRFC_RL |
SITE INTERFACE ROLE |
|
DWR_SL_CHNL |
SALES CHANNEL |
|
DWR_SL_CHNL_RPRSTV |
SALES CHANNEL REPRESENTATIVE |
|
DWR_SL_CMISN_PLN |
SALES COMMISSION PLAN |
|
DWR_SL_CMISN_PLN_DTL |
SALES COMMISSION PLAN DETAIL |
|
DWR_SLNG_LOC |
SELLING LOCATION |
|
DWR_SLT |
SLOT |
|
DWR_SLT_RLTN |
SLOT RELATIONSHIP |
|
DWR_SMS |
SMS |
|
DWR_SMS_RTNG_PLN |
SMS RATING PLAN |
|
DWR_SOC_JB |
SOC JOB |
|
DWR_SOC_JB_CTGRY |
SOC JOB CATEGORY |
|
DWR_SOC_JB_GRP |
SOC JOB GROUP |
|
DWR_SOC_JB_MJR_GRP |
SOC JOB MAJOR GROUP |
|
DWR_SOFTWARE |
SOFTWARE |
|
DWR_SOFTWARE_ATMC |
SOFTWARE ATOMIC |
|
DWR_SOFTWARE_CMND |
SOFTWARE COMMAND |
|
DWR_SOFTWARE_CMPST |
SOFTWARE COMPOSITE |
|
DWR_SOFTWARE_FTR_SETS |
SOFTWARE FEATURE SETS |
|
DWR_SOFTWARE_OS_RLTN |
SOFTWARE OS RELATIONSHIP |
|
DWR_SPECFTN |
SPECIFICATION |
|
DWR_SPECFTN_RL |
SPECIFICATION ROLE |
|
DWR_SPLMNTR_SRVC |
SUPPLEMENTARY SERVICE |
|
DWR_SPTRUM_COVRG_AREA |
SPECTRUM COVERAGE AREA |
|
DWR_SRC_SYS |
SOURCE SYSTEM |
|
DWR_SRC_SYS_KEY_MAPPING |
SOURCE SYSTEM KEY MAPPING |
|
DWR_SRVC |
SERVICE |
|
DWR_SRVC_BNDL |
SERVICE BUNDLE |
|
DWR_SRVC_BNDL_SPEC |
SERVICE BUNDLE SPEC |
|
DWR_SRVC_BNDL_SPEC_ATMC |
SERVICE BUNDLE SPEC ATOMIC |
|
DWR_SRVC_BNDL_SPEC_CMPST |
SERVICE BUNDLE SPEC COMPOSITE |
|
DWR_SRVC_CHTRSTC |
SERVICE CHARACTERISTIC |
|
DWR_SRVC_CHTRSTC_ASGN |
SERVICE CHARACTERISTIC ASSIGNMENT |
|
DWR_SRVC_CHTRSTC_RLTN |
SERVICE CHARACTERISTIC RELATIONSHIP |
|
DWR_SRVC_CHTRSTC_VAL |
SERVICE CHARACTERISTIC VALUE |
|
DWR_SRVC_CHTRSTC_VAL_ASGN |
SERVICE CHARACTERISTIC VALUE ASSIGNMENT |
|
DWR_SRVC_CHTRSTC_VAL_RLTN |
SERVICE CHARACTERISTIC VALUE RELATIONSHIP |
|
DWR_SRVC_COVRG_AREA |
SERVICE COVERAGE AREA |
|
DWR_SRVC_COVRG_GEO_DTL |
SERVICE COVERAGE GEO DETAIL |
|
DWR_SRVC_DPNDCY |
SERVICE DEPENDENCY |
|
DWR_SRVC_DVC_INTRFC_ASGN |
SERVICE DEVICE INTERFACE ASSIGNMENT |
|
DWR_SRVC_EQPMNT_ASGN |
SERVICE EQUIPMENT ASSIGNMENT |
|
DWR_SRVC_LR_DPNDCY |
SERVICE LR DEPENDENCY |
|
DWR_SRVC_LVL_AGRMNT |
SERVICE LEVEL AGREEMENT |
|
DWR_SRVC_LVL_AGRMNT_ITEM |
SERVICE LEVEL AGREEMENT ITEM |
|
DWR_SRVC_LVL_OBJCTV |
SERVICE LEVEL OBJECTIVE |
|
DWR_SRVC_LVL_SPECFTN |
SERVICE LEVEL SPECIFICATION |
|
DWR_SRVC_LVL_SPEC_APLBLETY |
SERVICE LEVEL SPEC APPLICABILITY |
|
DWR_SRVC_LVL_SPEC_CNSEQ |
SERVICE LEVEL SPEC CONSEQUENCE |
|
DWR_SRVC_LVL_SPEC_PRMTR |
SERVICE LEVEL SPEC PARAMETER |
|
DWR_SRVC_NTWK_ELMNT_ASGN |
SERVICE NETWORK ELEMENT ASSIGNMENT |
|
DWR_SRVC_PKG |
SERVICE PACKAGE |
|
DWR_SRVC_PKG_BNDL_DTL |
SERVICE PACKAGE BUNDLE DETAIL |
|
DWR_SRVC_PRFMNC |
SERVICE PERFORMANCE |
|
DWR_SRVC_PRFMNC_SPEC |
SERVICE PERFORMANCE SPEC |
|
DWR_SRVC_PR_DPNDCY |
SERVICE PR DEPENDENCY |
|
DWR_SRVC_RL |
SERVICE ROLE |
|
DWR_SRVC_SPEC |
SERVICE SPEC |
|
DWR_SRVC_SPEC_ATMC |
SERVICE SPEC ATOMIC |
|
DWR_SRVC_SPEC_CMPST |
SERVICE SPEC COMPOSITE |
|
DWR_SRVC_SPEC_PROD_RLTN |
SERVICE SPEC PRODUCT RELATIONSHIP |
|
DWR_SRVC_SPEC_VRSN |
SERVICE SPEC VERSION |
|
DWR_SRVC_SPECFTN_RL |
SERVICE SPECIFICATION ROLE |
|
DWR_SVCSPEC_NTWK_ELETYP_RLTN |
SERVICE SPEC NETWORK ELEMENT TYPE RELATIONSHIP |
|
DWR_STTSTCL_ENT |
STATISTICAL ENTITY |
|
DWR_SURVEY |
SURVEY |
|
DWR_SWTCH |
SWITCH |
|
DWR_SWTCH_CAPBLTY |
SWITCH CAPABILITY |
|
DWR_SWTCH_CMMND |
SWITCH COMMAND |
|
DWR_SWTCH_RUTNG_DVC_ASGN |
SWITCH ROUTING DEVICE ASSIGNMENT |
|
DWR_SWTCHNG_PROTCL |
SWITCHING PROTOCOL |
|
DWR_SWTCHNG_RL |
SWITCHING ROLE |
|
DWR_SVCSPEC_NTWK_ELETYP_RLTN |
SERVICE SPEC NETWORK ELEMENT TYPE RELATIONSHIP |
|
DWR_TAX_AUTH |
TAX AUTHORITY |
|
DWR_TEMPLATE_SRVC_LVL_SPEC |
TEMPLATE SERVICE LEVEL SPEC |
|
DWR_TIME_SLT |
TIME SLOT |
|
DWR_TIME_STNDRD_BY_DAY |
TIME STANDARD BY DAY |
|
DWR_TIME_STNDRD_BY_WK |
TIME STANDARD BY WEEK |
|
DWR_TIME_TOT |
TIME TOTAL |
|
DWR_TMNT_PNT |
TERMINATION POINT |
|
DWR_TRAIL |
TRAIL |
|
DWR_TRAIL_TMNT_PNT |
TRAIL TERMINATION POINT |
|
DWR_TRGT_ACCS_MTHD |
TARGET ACCESS METHOD |
|
DWR_TRGT_ACCT |
TARGET ACCOUNT |
|
DWR_TRGT_CNRT |
TARGET CONTRACT |
|
DWR_TRGT_GEO_AREA |
TARGET GEOGRAPHY AREA |
|
DWR_TRGT_MKT_SGMNT |
TARGET MARKET SEGMENT |
|
DWR_TV_CHNL |
TV CHANNEL |
|
DWR_URBN_PRPTY_ADDR |
URBAN PROPERTY ADDRESS |
|
DWR_USER |
USER |
|
DWR_VAL_ADD_SRVC |
VALUE ADDED SERVICE |
|
DWR_VAL_CSTM |
VALUE CUSTOM |
|
DWR_VAL_STNDRD |
VALUE STANDARD |
|
DWR_VARBLE_CSTM |
VARIABLE CUSTOM |
|
DWR_VARBLE_STNDRD |
VARIABLE STANDARD |
|
DWR_VAS_SBRP |
VAS SUBSCRIPTION |
|
DWR_VNDR |
VENDOR |
|
DWR_VNDR_CNRT |
VENDOR CONTRACT |
|
DWR_VNDR_FCTR_CMPNY_ASGN |
VENDOR FACTOR COMPANY ASSIGNMENT |
|
DWR_VNDR_RTNG |
VENDOR RATING |
|
DWR_VNDR_SITE |
VENDOR SITE |
|
DWR_VNDR_SITE_COURIER_ASGN |
VENDOR SITE COURIER ASSIGNMENT |
|
DWR_VOI_MSG_SRVC |
VOICE MESSAGE SERVICE |
|
DWR_VPN_LGICL_DVC_RL |
VPN LOGICAL DEVICE ROLE |
|
DWR_VRTL_TEAM |
VIRTUAL TEAM |
|
DWR_WAN_PROTCL |
WAN PROTOCOL |
|
DWR_WEATHR_CNDTN |
WEATHER CONDITION |
|
DWR_WEB_PG |
WEB PAGE |
|
DWR_WEB_PG_CNTNT |
WEB PAGE CONTENT |
|
DWR_WK_TODATE_TRANS |
WEEK TODATE TRANSFORMATION |
|
DWR_WK_TRANS |
WEEK TRANSFORMATION |
|
DWR_WKDAY |
WEEKDAY |
|
DWR_WRLS_NTWK_ELMNT |
WIRELESS NETWORK ELEMENT |
|
DWR_WRLS_RTNG_PLN |
WIRELESS RATING PLAN |
|
DWR_WRLS_SPTRUM |
WIRELESS SPECTRUM |
|
DWR_YR_TRANS |
YEAR TRANSFORMATION |
Table 4-3 briefly describes the Lookup tables in Oracle Communications Data Model.
Table Name | Description | More Information |
---|---|---|
DWL_ACCS_MTHD_ASGN_TYP |
ACCESS METHOD ASSIGNMENT TYPE |
|
DWL_ACCS_MTHD_ELMNT_TYP |
ACCESS METHOD ELEMENT TYPE |
|
DWL_ACCS_MTHD_PRTY_ASGN_TYP |
ACCESS METHOD PARTY ASSIGNMENT TYPE |
|
DWL_ACCS_MTHD_STAT_RSN |
ACCESS METHOD STATUS REASON |
|
DWL_ACCS_MTHD_STAT_TYP |
ACCESS METHOD STATUS TYPE |
|
DWL_ACCS_MTHD_TYP |
ACCESS METHOD TYPE |
|
DWL_ACCT_ADJ_RSN |
ACCOUNT ADJUSTMENT REASON |
|
DWL_ACCT_ASGN_RSN |
ACCOUNT ASSIGNMENT REASON |
|
DWL_ACCT_ASGN_TYP |
ACCOUNT ASSIGNMENT TYPE |
|
DWL_ACCT_BAL_ADJ_TYP |
ACCOUNT BALANCE ADJUSTMENT TYPE |
|
DWL_ACCT_BAL_TYP |
ACCOUNT BALANCE TYPE |
|
DWL_ACCT_CYCL |
ACCOUNTING CYCLE |
|
DWL_ACCT_EVT_TYP |
ACCOUNT EVENT TYPE |
|
DWL_ACCT_ITEM_CTGRY |
ACCOUNTING ITEM CATEGORY |
|
DWL_ACCT_PYMT_MTHD_STAT_RSN |
ACCOUNT PAYMENT METHOD STATUS REASON |
|
DWL_ACCT_PYMT_MTHD_STAT_TYP |
ACCOUNT PAYMENT METHOD STATUS TYPE |
|
DWL_ACCT_RFND_RSN |
ACCOUNT REFUND REASON |
|
DWL_ACCT_SBRP_ASGN_RSN |
ACCOUNT SUBSCRIPTION ASSIGNMENT REASON |
|
DWL_ACCT_STAT_RSN |
ACCOUNT STATUS REASON |
|
DWL_ACCT_STAT_TYP |
ACCOUNT STATUS TYPE |
|
DWL_ACCT_TYP |
ACCOUNT TYPE |
|
DWL_ADDR_RLTD_RSN |
ADDRESS RELATED REASON |
|
DWL_ADDR_RLTD_TYP |
ADDRESS RELATED TYPE |
|
DWL_ADDR_STAT_RSN |
ADDRESS STATUS REASON |
|
DWL_ADDR_TYP |
ADDRESS TYPE |
|
DWL_AGE_BND |
AGE BAND |
|
DWL_AGE_ON_NET_BND |
AGE ON NET BAND |
|
DWL_APNMNT_TYP |
APPOINTMENT TYPE |
|
DWL_ARPU_BND |
ARPU BAND |
|
DWL_AWRD_LVL |
AWARD LEVEL |
|
DWL_BARNG_RSN |
BARING REASON |
|
DWL_BER_FER_TYP |
BER FER TYPE |
|
DWL_BLLG_CYCL |
BILLING CYCLE |
|
DWL_BLLG_FRQNCY |
BILLING FREQUENCY |
|
DWL_BLLG_OCCRNCE_TYP |
BILLING OCCURRENCE TYPE |
|
DWL_BLLG_PRD |
BILLING PERIOD |
|
DWL_BLLG_STAT_CTGRY |
BILLING STATUS CATEGORY |
|
DWL_BLLG_STAT_TYP |
BILLING STATUS TYPE |
|
DWL_BSNS_INTRACN_ASGN_TYP |
BUSINESS INTERACTION ASSIGNMENT TYPE |
|
DWL_BSNS_INTRACN_TYP |
BUSINESS INTERACTION TYPE |
|
DWL_BSNS_LEGAL_STAT |
BUSINESS LEGAL STATUS |
|
DWL_CALL_CNTR_AGNT_TYP |
CALL CENTER AGENT TYPE |
|
DWL_CALL_CNTR_CASE_SUB_TYP |
CALL CENTER CASE SUB TYPE |
|
DWL_CALL_CNTR_CASE_TTL |
CALL CENTER CASE TITLE |
|
DWL_CALL_CNTR_CASE_TYP |
CALL CENTER CASE TYPE |
|
DWL_CALL_CTGRY |
CALL CATEGORY |
|
DWL_CALL_DRCTN |
CALL DIRECTION |
|
DWL_CALL_OTHR_TYP |
CALL OTHER TYPE |
|
DWL_CALL_RCYLD_RSN |
CALL RECYCLED REASON |
|
DWL_CALL_RUTNG_TYP |
CALL ROUTING TYPE |
|
DWL_CALL_SRCHRG |
CALL SURCHARGE |
|
DWL_CALL_SRVC_TYP |
CALL SERVICE TYPE |
|
DWL_CALL_SUCC_FAIL_TYP |
CALL SUCCESS FAILURE TYPE |
|
DWL_CALL_TMNT_RSN |
CALL TERMINATION REASON |
|
DWL_CALL_TYP |
CALL TYPE |
|
DWL_CELL_OUTAGE_RSN |
CELL OUTAGE REASON |
|
DWL_CELL_SITE_TYP |
CELL SITE TYPE |
|
DWL_CELL_TYP |
CELL TYPE |
|
DWL_CHNG_PPSD_BY_TYP |
CHANGE PROPOSED BY TYPE |
|
DWL_CHNL_TYP |
CHANNEL TYPE |
|
DWL_CHRN_RSN |
CHURN REASON |
|
DWL_CMISN_TYP |
COMMISSION TYPE |
|
DWL_CMPGN_CHNL_TYP |
CAMPAIGN CHANNEL TYPE |
|
DWL_CMPGN_PRPS_TYP |
CAMPAIGN PURPOSE TYPE |
|
DWL_CMPGN_STAT |
CAMPAIGN STATUS |
|
DWL_CMPGN_TYP |
CAMPAIGN TYPE |
|
DWL_CMPND_ELMNT_SPEC |
COMPOUND ELEMENT SPEC |
|
DWL_CMPND_ELMNT_SPEC_ATMC |
COMPOUND ELEMENT SPEC ATOMIC |
|
DWL_CMPND_ELMNT_SPEC_CMPST |
COMPOUND ELEMENT SPEC COMPOSITE |
|
DWL_CNCT_LST_CHNG_RSN |
CONTACT LIST CHANGE REASON |
|
DWL_CNCT_LST_RECRNC_TYP |
CONTACT LIST RECURRENCE TYPE |
|
DWL_CNCT_RLS |
CONTACT ROLES |
|
DWL_CNRT_ASGN_RSN |
CONTRACT ASSIGNMENT REASON |
|
DWL_CNRT_ASGN_TYP |
CONTRACT ASSIGNMENT TYPE |
|
DWL_CNRT_CHNG_INTTR_TYP |
CONTRACT CHANGE INITIATOR TYPE |
|
DWL_CNRT_CHNG_TYP |
CONTRACT CHANGE TYPE |
|
DWL_CNRT_STAT_RSN |
CONTRACT STATUS REASON |
|
DWL_CNRT_STAT_TYP |
CONTRACT STATUS TYPE |
|
DWL_CNRT_TERM_TYP |
CONTRACT TERM TYPE |
|
DWL_CNRT_TYP |
CONTRACT TYPE |
|
DWL_CNTNT_PRCNG_TYP |
CONTENT PRICING TYPE |
|
DWL_CNTNT_TYP |
CONTENT TYPE |
|
DWL_COST_RSN |
COST REASON |
|
DWL_COST_SUBTYP |
COST SUBTYPE |
|
DWL_COST_TYP |
COST TYPE |
|
DWL_CRCUT_CTGRY |
CIRCUIT CATEGORY |
|
DWL_CRCUT_RNTL_EVT_TYP |
CIRCUIT RENTAL EVENT TYPE |
|
DWL_CRCUT_TYP |
CIRCUIT TYPE |
|
DWL_CRNCY |
CURRENCY |
|
DWL_CUST_CLASS |
CUSTOMER CLASS |
|
DWL_CUST_FCNG_SRVC_SPEC |
CUSTOMER FACING SERVICE SPEC |
|
DWL_CUST_FCNG_SRVC_SPEC_ATMC |
CUSTOMER FACING SERVICE SPEC ATOMIC |
|
DWL_CUST_FCNG_SRVC_SPEC_CMPST |
CUSTOMER FACING SERVICE SPEC COMPOSITE |
|
DWL_CUST_GRP |
CUSTOMER GROUP |
|
DWL_CUST_OCCSN_TYP |
CUSTOMER OCCASION TYPE |
|
DWL_CUST_ORDR_PRIORITY_TYP |
CUSTOMER ORDER PRIORITY TYPE |
|
DWL_CUST_ORDR_STATE_CHNG_RSN |
CUSTOMER ORDER STATE CHANGE REASON |
|
DWL_CUST_RVN_BND |
CUSTOMER REVENUE BAND |
|
DWL_CUST_RVN_TYP |
CUSTOMER REVENUE TYPE |
|
DWL_CUST_SNTMNT |
CUSTOMER SENTIMENT |
|
DWL_CUST_TYP |
CUSTOMER TYPE |
|
DWL_DEBT_AGNG_BND |
DEBT AGING BAND |
|
DWL_DOC_CNDTN_TYP |
DOCUMENT CONDITION TYPE |
|
DWL_DOC_TYP |
DOCUMENT TYPE |
|
DWL_DOC_TYP_GRP |
DOCUMENT TYPE GROUP |
|
DWL_DRCT_DEBT_STAT_RSN |
DIRECT DEBIT STATUS REASON |
|
DWL_DSTN_TYP |
DESTINATION TYPE |
|
DWL_DSTNC_BND |
DISTANCE BAND |
|
DWL_DVRT_RTRV_RSN |
DIVERT RETRIEVE REASON |
|
DWL_DVRT_RTRV_TYP |
DIVERT RETRIEVE TYPE |
|
DWL_EDU |
EDUCATION |
|
DWL_EMP_DESIG |
EMPLOYEE DESIGNATION |
|
DWL_EMP_JB_RL_TYP |
EMPLOYEE JOB ROLE TYPE |
|
DWL_EMP_TYP |
EMPLOYEE TYPE |
|
DWL_EQPMNT_INSTNC_STAT_TYP |
EQUIPMENT INSTANCE STATUS TYPE |
|
DWL_EQPMNT_TYP |
EQUIPMENT TYPE |
|
DWL_EVT_ASGN_RSN |
EVENT ASSIGNMENT REASON |
|
DWL_EVT_ASGN_TYP |
EVENT ASSIGNMENT TYPE |
|
DWL_EVT_CLASS |
EVENT CLASS |
|
DWL_EVT_CTGRY |
EVENT CATEGORY |
|
DWL_EVT_RESPN_RSN |
EVENT RESPONSE REASON |
|
DWL_EVT_RSLT |
EVENT RESULT |
|
DWL_EVT_RSN |
EVENT REASON |
|
DWL_EVT_RSN_CTGRY |
EVENT REASON CATEGORY |
|
DWL_EVT_STAT_RSN |
EVENT STATUS REASON |
|
DWL_EVT_STAT_TYP |
EVENT STATUS TYPE |
|
DWL_EVT_TYP |
EVENT TYPE |
|
DWL_EXTRNL_ORG_TYP |
EXTERNAL ORGANIZATION TYPE |
|
DWL_FLD_ACTVTY_RSLT_TYP |
FIELD ACTIVITY RESULT TYPE |
|
DWL_FLD_ACTVTY_TYP |
FIELD ACTIVITY TYPE |
|
DWL_FLT_RSLTN_TYP |
FAULT RESOLUTION TYPE |
|
DWL_FLT_TYP |
FAULT TYPE |
|
DWL_FRAUD_PRFL_CLASS |
FRAUD PROFILE CLASS |
|
DWL_GIVE_AWAY_TYP |
GIVE AWAY TYPE |
|
DWL_GNDR |
GENDER |
|
DWL_INTRACN_DRCTN |
INTERACTION DIRECTION |
|
DWL_INTRACN_RSLT_TYP |
INTERACTION RESULT TYPE |
|
DWL_INTRACN_RSN |
INTERACTION REASON |
|
DWL_INTRACN_STAT |
INTERACTION STATUS |
|
DWL_INTRACN_TYP |
INTERACTION TYPE |
|
DWL_INTTV_RSLT_TYP |
INITIATIVE RESULT TYPE |
|
DWL_INTTV_TYP |
INITIATIVE TYPE |
|
DWL_INVC_ADJ_RSN |
INVOICE ADJUSTMENT REASON |
|
DWL_INVC_ADJ_TYP |
INVOICE ADJUSTMENT TYPE |
|
DWL_INVC_DISC_RSN |
INVOICE DISCOUNT REASON |
|
DWL_INVC_DISC_TYP |
INVOICE DISCOUNT TYPE |
|
DWL_INVC_DLVRY_FRMT |
INVOICE DELIVERY FORMAT |
|
DWL_INVC_DLVRY_TYP |
INVOICE DELIVERY TYPE |
|
DWL_INVC_ITEM_DTL_TYP |
INVOICE ITEM DETAIL TYPE |
|
DWL_INVC_ITEM_TYP |
INVOICE ITEM TYPE |
|
DWL_INVC_PYMT_TERM_TYP |
INVOICE PAYMENT TERM TYPE |
|
DWL_INVC_TYP |
INVOICE TYPE |
|
DWL_ISP_BSNS_TYP |
ISP BUSINESS TYPE |
|
DWL_ISP_TYP |
ISP TYPE |
|
DWL_ITEM_TYP |
ITEM TYPE |
|
DWL_LANG |
LANGUAGE |
|
DWL_LEGAL_PRCS_STAT_TYP |
LEGAL PROCESS STATUS TYPE |
|
DWL_LGICL_ELMNT_SPEC |
LOGICAL ELEMENT SPEC |
|
DWL_LGICL_ELMNT_SPEC_ATMC |
LOGICAL ELEMENT SPEC ATOMIC |
|
DWL_LGICL_ELMNT_SPEC_CMPST |
LOGICAL ELEMENT SPEC COMPOSITE |
|
DWL_LOOKUP |
LOOKUP |
|
DWL_LTTR_TYP |
LETTER TYPE |
|
DWL_LYLTY_PROG_EVT_CTGRY |
LOYALTY PROGRAM EVENT CATEGORY |
|
DWL_LYLTY_PROG_EVT_TYP |
LOYALTY PROGRAM EVENT TYPE |
|
DWL_LYLTY_PROG_PRTY_RL |
LOYALTY PROGRAM PARTY ROLE |
|
DWL_LYLTY_PROG_TMNT_RSN |
LOYALTY PROGRAM TERMINATION REASON |
|
DWL_MDL_TYP |
MODEL TYPE |
|
DWL_MDTN_STAT_CTGRY |
MEDIATION STATUS CATEGORY |
|
DWL_MDTN_STAT_RSN |
MEDIATION STATUS REASON |
|
DWL_MDTN_STAT_TYP |
MEDIATION STATUS TYPE |
|
DWL_MEDIA_OBJ_TYP |
MEDIA OBJECT TYPE |
|
DWL_MNNG_CHRN_TYP |
||
DWL_MNNG_LTV_BAND |
CUSTOMER LTV BAND |
|
DWL_MNG_ACTN_TYP |
MANAGE ACTION TYPE |
|
DWL_MRTL_STAT |
MARITAL STATUS |
|
DWL_NBR_NTWK_TYP |
NUMBER NETWORK TYPE |
|
DWL_NP_RQST_LN_ITEM_STATE_TYP |
NP REQUEST LINE ITEM STATE TYPE |
|
DWL_NP_RQST_STATE_TYP |
NP REQUEST STATE TYPE |
|
DWL_NP_RQST_TYP |
NP REQUEST TYPE |
|
DWL_NP_STEP |
NP STEP |
|
DWL_NTFCTN_TYP |
NOTIFICATION TYPE |
|
DWL_NTNLTY |
NATIONALITY |
|
DWL_NTWK_ADDR_TYP |
NETWORK ADDRESS TYPE |
|
DWL_NTWK_ASGN_TYP |
NETWORK ASSIGNMENT TYPE |
|
DWL_NTWK_ELMNT_CTGRY |
NETWORK ELEMENT CATEGORY |
|
DWL_NTWK_ELMNT_RLTN_TYP |
NETWORK ELEMENT RELATIONSHIP TYPE |
|
DWL_NTWK_ELMNT_USG_EVT_TYP |
NETWORK ELEMENT USAGE EVENT TYPE |
|
DWL_NTWK_EVT_CHTRSTC_TYP |
NETWORK EVENT CHARACTERISTIC TYPE |
|
DWL_NTWK_EVT_STAT |
NETWORK EVENT STATUS |
|
DWL_NTWK_EVT_TYP |
NETWORK EVENT TYPE |
|
DWL_NTWK_TCHPNT_CLASS |
NETWORK TOUCHPOINT CLASS |
|
DWL_NTWK_TCHPNT_STAT |
NETWORK TOUCHPOINT STATUS |
|
DWL_NTWK_TCHPNT_TYP |
NETWORK TOUCHPOINT TYPE |
|
DWL_NTWK_TYP |
NETWORK TYPE |
|
DWL_ONOFF_NET |
ON OFF NET TYPE |
|
DWL_OPRTR_GRP |
OPERATOR GROUP |
|
DWL_OPRTR_TYP |
OPERATOR TYPE |
|
DWL_ORDR_STATE |
ORDER STATE |
|
DWL_ORDR_STAT |
ORDER STATUS |
|
DWL_ORDR_TYP |
ORDER TYPE |
|
DWL_ORG_BSNS_UNIT_TYP |
ORGANIZATION BUSINESS UNIT TYPE |
|
DWL_PAY_CTGRY |
PAY CATEGORY |
|
DWL_PAY_TYP |
PAY TYPE |
|
DWL_PBLCTN_TYP |
PUBLICATION TYPE |
|
DWL_PCU_OUTAGE_RSN |
PCU OUTAGE REASON |
|
DWL_PHY_ELMNT_SPEC |
PHYSICAL ELEMENT SPEC |
|
DWL_PHY_ELMNT_SPEC_ATMC |
PHYSICAL ELEMENT SPEC ATOMIC |
|
DWL_PHY_ELMNT_SPEC_CMPST |
PHYSICAL ELEMENT SPEC COMPOSITE |
|
DWL_PK_OFPK_TIME |
PEAK OFFPEAK TIME |
|
DWL_POSTL_SRVC_TYP |
POSTAL SERVICE TYPE |
|
DWL_PPA_CTGRY |
PPA CATEGORY |
|
DWL_PPA_DEDCTN_TYP |
PPA DEDUCTION TYPE |
|
DWL_PRMTN_RSLT_TYP |
PROMOTION RESULT TYPE |
|
DWL_PRMTN_TERM_TYP |
PROMOTION TERM TYPE |
|
DWL_PRMTN_TYP |
PROMOTION TYPE |
|
DWL_PROD_ASGN_RSN |
PRODUCT ASSIGNMENT REASON |
|
DWL_PROD_CAPBLTY_TYP |
PRODUCT CAPABILITY TYPE |
|
DWL_PROD_CHRG_TYP |
PRODUCT CHARGE TYPE |
|
DWL_PROD_CHRG_TYP_RLTN_RSN |
PRODUCT CHARGE TYPE RLTN REASON |
|
DWL_PROD_CHRGNG_RSN |
PRODUCT CHARGING REASON |
|
DWL_PROD_CHTRSTC_TYP |
PRODUCT CHARACTERISTIC TYPE |
|
DWL_PROD_CTGRY |
PRODUCT CATEGORY |
|
DWL_PROD_CTLG_PRSNT_TYP |
PRODUCT CATALOG PRESENTATION TYPE |
|
DWL_PROD_CTLG_TYP |
PRODUCT CATALOG TYPE |
|
DWL_PROD_GRP |
PRODUCT GROUP |
|
DWL_PROD_GRP_TYP |
PRODUCT GROUP TYPE |
|
DWL_PROD_LN |
PRODUCT LINE |
|
DWL_PROD_MGMT_RL |
PRODUCT MANAGEMENT ROLE |
|
DWL_PROD_MGMT_RSN |
PRODUCT MANAGEMENT REASON |
|
DWL_PROD_MKT_PLN_ASGN_TYP |
PRODUCT MARKET PLAN ASSIGNMENT TYPE |
|
DWL_PROD_MKT_PLN_GRP_TYP |
PRODUCT MARKET PLAN GROUP TYPE |
|
DWL_PROD_MKT_PLN_RLTN_TYP |
PRODUCT MARKET PLAN RELATIONSHIP TYPE |
|
DWL_PROD_MKT_PLN_TYP |
PRODUCT MARKET PLAN TYPE |
|
DWL_PROD_PKG_CHRG_TYP |
PRODUCT PACKAGE CHARGE TYPE |
|
DWL_PROD_RTNG_PLN_TYP |
PRODUCT RATING PLAN TYPE |
|
DWL_PROD_STAT_TYP |
PRODUCT STATUS TYPE |
|
DWL_PROD_TYP |
PRODUCT TYPE |
|
DWL_PRPD_MBL_EVT_TYP |
PREPAID MOBILE EVENT TYPE |
|
DWL_PRSPCT_PRIORITY_TYP |
PROSPECT PRIORITY TYPE |
|
DWL_PRSPCT_QLTY_SCR_TYP |
PROSPECT QUALITY SCORE TYPE |
|
DWL_PRSPCT_REJECT_RSN |
PROSPECT REJECT REASON |
|
DWL_PRTNR_STLMNT_RSN |
PARTNER SETTLEMENT REASON |
|
DWL_PRTY_ACCT_ASGN_TYP |
PARTY ACCOUNT ASSIGNMENT TYPE |
|
DWL_PRTY_ASGN_RSN |
PARTY ASSIGNMENT REASON |
|
DWL_PRTY_ASGN_TYP |
PARTY ASSIGNMENT TYPE |
|
DWL_PRTY_CNCT_INFO_TYP |
PARTY CONTACT INFORMATION TYPE |
|
DWL_PRTY_CNCT_LST_PRTCPTN |
PARTY CONTACT LIST PARTICIPATION |
|
DWL_PRTY_CNCT_LST_RL |
PARTY CONTACT LIST ROLE |
|
DWL_PRTY_CNRT_ASGN_RL |
PARTY CONTRACT ASSIGNMENT ROLE |
|
DWL_PRTY_CNRT_ASGN_TYP |
PARTY CONTRACT ASSIGNMENT TYPE |
|
DWL_PRTY_EVT_TYP |
PARTY EVENT TYPE |
|
DWL_PRTY_IDNT_TYP |
PARTY IDENTIFICATION TYPE |
|
DWL_PRTY_INTRACN_THRD_TYP |
PARTY INTERACTION THREAD TYPE |
|
DWL_PRTY_LOC_RSN |
PARTY LOCATION REASON |
|
DWL_PRTY_LOC_TYP |
PARTY LOCATION TYPE |
|
DWL_PRTY_MGMT_RL |
PARTY MANAGEMENT ROLE |
|
DWL_PRTY_ORDR_ASGN_TYP |
PARTY ORDER ASSIGNMENT TYPE |
|
DWL_PRTY_RL |
PARTY ROLE |
|
DWL_PRTY_SBRP_RL |
PARTY SUBSCRIPTION ROLE |
|
DWL_PRTY_SGMNT_MTHD |
PARTY SEGMENTATION METHOD |
|
DWL_PRTY_SIM_CARD_RL |
PARTY SIM CARD ROLE |
|
DWL_PRTY_SRVC_ASGN_RL |
PARTY SERVICE ASSIGNMENT ROLE |
|
DWL_PRTY_SRVC_ASGN_RSN |
PARTY SERVICE ASSIGNMENT REASON |
|
DWL_PRTY_STAT_CHNG_RSN |
PARTY STATUS CHANGE REASON |
|
DWL_PRTY_STAT_CTGRY |
PARTY STATUS CATEGORY |
|
DWL_PRTY_STAT_TYP |
PARTY STATUS TYPE |
|
DWL_PRTY_TYP |
PARTY TYPE |
|
DWL_PYMT_AGNG_CLASS |
PAYMENT AGING CLASS |
|
DWL_PYMT_MTHD_TYP |
PAYMENT METHOD TYPE |
|
DWL_PYMT_TRX_TYP |
PAYMENT TRANSACTION TYPE |
|
DWL_RDMPTN_TYP |
REDEMPTION TYPE |
|
DWL_RECHRG_RVN_SLB |
RECHARGE REVENUE SLAB |
|
DWL_RESRE_FCNG_SRVC_SPEC |
RESOURCE FACING SERVICE SPEC |
|
DWL_RESRE_FCNG_SRVC_SPEC_ATMC |
RESOURCE FACING SERVICE SPEC ATOMIC |
|
DWL_RESRE_FCNG_SRVC_SPEC_CMPST |
RESOURCE FACING SERVICE SPEC COMPOSITE |
|
DWL_RMNG_TYP |
ROAMING TYPE |
|
DWL_RTNG_MTHD_TYP |
RATING METHOD TYPE |
|
DWL_SBRP_ASGN_TYP |
SUBSCRIPTION ASSIGNMENT TYPE |
|
DWL_SBRP_EVT_TYP |
SUBSCRIPTION EVENT TYPE |
|
DWL_SBRP_STAT |
SUBSCRIPTION STATUS |
|
DWL_SBRP_STAT_CTGRY |
SUBSCRIPTION STATUS CATEGORY |
|
DWL_SBRP_STAT_RSN |
SUBSCRIPTION STATUS REASON |
|
DWL_SBRP_STAT_TYP |
SUBSCRIPTION STATUS TYPE |
|
DWL_SBRP_TERM_TYP |
SUBSCRIPTION TERM TYPE |
|
DWL_SBRP_TYP |
SUBSCRIPTION TYPE |
|
DWL_SBSCRP_ACTVTN_RSN |
SUBSCRIBER ACTIVATION REASON |
|
DWL_SCRPT_QUES_TYP |
SCRIPT QUESTION TYPE |
|
DWL_SCRTY_REQD_TYP |
SECURITY REQUIRED TYPE |
|
DWL_SEASON |
SEASON |
|
DWL_SGMNT_TYP |
SEGMENT TYPE |
|
DWL_SIC_ASGN_RSN |
SIC ASSIGNMENT REASON |
|
DWL_SIC_CLSFCTN |
SIC CLASSIFICATION |
|
DWL_SIC_INDSTRY_GRP |
SIC INDUSTRY GROUP |
|
DWL_SIM_CARD_ACCS_MTHD_RSN |
SIM CARD ACCESS METHOD REASON |
|
DWL_SIM_CARD_ACTVTN_RSN |
SIM CARD ACTIVATION REASON |
|
DWL_SIM_CARD_ACTVTN_TYP |
SIM CARD ACTIVATION TYPE |
|
DWL_SIM_CARD_SBRP_RSN |
SIM CARD SUBSCRIPTION REASON |
|
DWL_SIM_CARD_TYP |
SIM CARD TYPE |
|
DWL_SITE_TYP |
SITE TYPE |
|
DWL_SKILL_TYP |
SKILL TYPE |
|
DWL_SLNG_LOC_TYP |
SELLING LOCATION TYPE |
|
DWL_SRC_SYS_TYP |
SOURCE SYSTEM TYPE |
|
DWL_SRVC_CLASS |
SERVICE CLASS |
|
DWL_SRVC_CLASS_TYP |
SERVICE CLASS TYPE |
|
DWL_SRVC_COVRG_AREA_TYP |
SERVICE COVERAGE AREA TYPE |
|
DWL_SRVC_LVL_AGRMNT_TYP |
SERVICE LEVEL AGREEMENT TYPE |
|
DWL_SRVC_LVL_UNMET_CNSEQ_TYP |
SERVICE LEVEL UNMET CONSEQUENCE TYPE |
|
DWL_SRVC_PKG_SPEC |
SERVICE PACKAGE SPEC |
|
DWL_SRVC_PKG_SPEC_ATMC |
SERVICE PACKAGE SPEC ATOMIC |
|
DWL_SRVC_PKG_SPEC_CMPST |
SERVICE PACKAGE SPEC COMPOSITE |
|
DWL_SRVC_USG_TYP |
SERVICE USAGE TYPE |
|
DWL_SUBSDY_TYP |
SUBSIDY TYPE |
|
DWL_SWOT_TYP |
SWOT TYPE |
|
DWL_SWTCH_CAPBLTY_TYP |
SWITCH CAPABILITY TYPE |
|
DWL_SWTCH_TYP |
SWITCH TYPE |
|
DWL_TAX_CTGRY |
TAX CATEGORY |
|
DWL_TAX_EXMPT |
TAX EXEMPT |
|
DWL_TCH_TYP |
TCH TYPE |
|
DWL_TECH |
TECHNOLOGY |
|
DWL_TECH_TYP |
TECHNOLOGY TYPE |
|
DWL_TIME_BND |
TIME BAND |
|
DWL_TIME_ZN |
TIME ZONE |
|
DWL_TRGT_TYP |
TARGET TYPE |
|
DWL_UMS_ACCS_TYP |
UMS ACCESS TYPE |
|
DWL_UMS_EVT_TYP |
UMS EVENT TYPE |
|
DWL_UOM |
UNIT OF MEASURE |
|
DWL_VAL_TYP |
VALUE TYPE |
|
DWL_VNDR_CLASS |
VENDOR CLASS |
|
DWL_VNDR_RTNG_TYP |
VENDOR RATING TYPE |
|
DWL_VNDR_SITE_TYP |
VENDOR SITE TYPE |
|
DWL_VOL_BND |
VOLUME BAND |
|
DWL_WEB_PG_TYP |
WEB PAGE TYPE |
Table 4-4 briefly describes the Base tables in Oracle Communications Data Model.
Table Name | Description | More Information |
---|---|---|
DWB_ACCS_MTHD_PORT_HIST |
ACCESS METHOD PORTING HISTORY |
|
DWB_ACCS_MTHD_STAT_HIST |
ACCESS METHOD STATUS HISTORY |
|
DWB_ACCT_ACCTNG_CYCL_HIST |
ACCOUNT ACCOUNTING CYCLE HISTORY |
|
DWB_ACCT_BAL_ADJ |
ACCOUNT BALANCE ADJUSTMENT |
|
DWB_ACCT_BAL_HIST |
ACCOUNT BALANCE HISTORY |
|
DWB_ACCT_BLLG_OCCRNCE |
ACCOUNT BILLING OCCURRENCE |
|
DWB_ACCT_COST |
ACCOUNT COST |
|
DWB_ACCT_CRDT_LMT |
ACCOUNT CREDIT LIMIT |
|
DWB_ACCT_DEBT_WRT_OFF |
ACCOUNT DEBT WRITE OFF |
|
DWB_ACCT_MNGMNT_HIST |
ACCOUNT MANAGEMENT HISTORY |
|
DWB_ACCT_PMP_PRTCPTN_HIST |
ACCOUNT PMP PARTICIPATION HISTORY |
|
DWB_ACCT_PYMT |
ACCOUNT PAYMENT |
|
DWB_ACCT_PYMT_MTHD_STAT |
ACCOUNT PAYMENT METHOD STATUS |
|
DWB_ACCT_RCHRG |
ACCOUNT RECHARGE |
|
DWB_ACCT_RFND |
ACCOUNT REFUND |
|
DWB_ACCT_STAT_HIST |
ACCOUNT STATUS HISTORY |
|
DWB_ADDR_STAT |
ADDRESS STATUS |
|
DWB_APNMNT_CLNDR |
APPOINTMENT CALENDAR |
|
DWB_BLK_LST_HIST |
BLACK LIST HISTORY |
|
DWB_BNDLD_NTWK_EVT |
BUNDLED NETWORK EVENT |
|
DWB_BRDBND_USG_EVT |
BROADBAND USAGE EVENT |
|
DWB_BSNS_INTRACN |
BUSINESS INTERACTION |
|
DWB_BSNS_INTRACN_ITEM |
BUSINESS INTERACTION ITEM |
|
DWB_BSNS_INTRACN_ITEM_PRICE |
BUSINESS INTERACTION ITEM PRICE |
|
DWB_BSNS_UNIT_COST |
ORGANIZATION BUSINESS UNIT COST |
|
DWB_CELL_SITE_COST |
CELL SITE COST |
|
DWB_CHNL_COST |
CHANNEL COST |
|
DWB_CMPGN_COST |
CAMPAIGN COST |
|
DWB_CMPGN_MSG_CRTVE |
CAMPAIGN MESSAGE CREATIVE |
|
DWB_CNCT_LST_COST |
CONTACT LIST COST |
|
DWB_CNRT_APRVL |
CONTRACT APPROVAL |
|
DWB_CNRT_STAT |
CONTRACT STATUS |
|
DWB_CNRT_TERM_VAL |
CONTRACT TERM VALUE |
|
DWB_CNTNT_DLVRY_EVT |
CONTENT DELIVERY EVENT |
|
DWB_COST |
COST |
|
DWB_COST_CNTR_BDGT |
COST CENTER BUDGET |
|
DWB_COURIER_COST |
COURIER COST |
|
DWB_CRCUT_RNTL |
CIRCUIT RENTAL |
|
DWB_CRCUT_TRFC |
CIRCUIT TRAFFIC |
|
DWB_CRNCY_EXCHNG_RATE |
CURRENCY EXCHANGE RATE |
|
DWB_CUST_COST |
CUSTOMER COST |
|
DWB_CUST_FLD_INSTLTN |
CUSTOMER FIELD INSTALLATION |
|
DWB_CUST_FLD_SPPRT |
CUSTOMER FIELD SUPPORT |
|
DWB_CUST_FLD_SRVC_ACTVTY |
CUSTOMER FIELD SERVICE ACTIVITY |
|
DWB_CUST_FLD_SRVC_DTL |
CUSTOMER FIELD SERVICE DETAIL |
|
DWB_CUST_ORDR |
CUSTOMER ORDER |
|
DWB_CUST_ORDR_LN_ITEM |
CUSTOMER ORDER LINE ITEM |
|
DWB_CUST_ORDR_LN_ITEM_ST_ASGN |
CUSTOMER ORDER LINE ITEM STATE ASSIGN |
|
DWB_CUST_ORDR_PYMT |
CUSTOMER ORDER PAYMENT |
|
DWB_CUST_ORDR_STATE_ASGN |
CUSTOMER ORDER STATE ASSIGNMENT |
|
DWB_DATA_SRVC_EVT |
DATA SERVICE EVENT |
|
DWB_DEBT_COLLCTN |
DEBT COLLECTION |
|
DWB_DEBT_COLLCTN_ASGN |
DEBT COLLECTION ASSIGNMENT |
|
DWB_DEBT_COLLCTN_ASGN_BTCH |
DEBT COLLECTION ASSIGNMENT BATCH |
|
DWB_EMP_ACT_LBR_HRLY |
EMPLOYEE ACTUAL LABOR HOURLY |
|
DWB_EMP_ACT_LBR_SALARIED |
EMPLOYEE ACTUAL LABOR SALARIED |
|
DWB_EMP_COST |
EMPLOYEE COST |
|
DWB_EMP_TRNG_REC |
EMPLOYEE TRAINING RECORD |
|
DWB_EQPMNT_CNTR_COST |
EQUIPMENT CENTER COST |
|
DWB_EQPMNT_INSTNC_STAT_HIST |
EQUIPMENT INSTANCE STATUS HISTORY |
|
DWB_ERRD_MDTD_CALL_EVT |
ERRORED MEDIATED CALL EVENT |
|
DWB_ERRD_RAW_WRLS_CALL_EVT |
ERRORED RATED WIRELESS CALL EVENT |
|
DWB_ERRD_RTD_WRLS_CALL_EVT |
ERRORED RAW WIRELESS CALL EVENT |
|
DWB_EVT |
EVENT |
|
DWB_EVT_ACCS_MTHD_ACTVTY |
EVENT ACCESS METHOD ACTIVITY |
|
DWB_EVT_ACCT |
EVENT ACCOUNT |
|
DWB_EVT_ASGN |
EVENT ASSIGNMENT |
|
DWB_EVT_COST |
EVENT COST |
|
DWB_EVT_CRCUT_RNTL |
EVENT CIRCUIT RENTAL |
|
DWB_EVT_EMIT_DTL |
EVENT EMIT DETAIL |
|
DWB_EVT_EMP_PYRL |
EVENT EMPLOYEE PAYROLL |
|
DWB_EVT_EQPMNT_INSTNC |
EVENT EQUIPMENT INSTANCE |
|
DWB_EVT_FINCL |
EVENT FINANCIAL |
|
DWB_EVT_GEO |
EVENT GEOGRAPHY |
|
DWB_EVT_GFT_RDMPTN |
EVENT GIFT REDEMPTION |
|
DWB_EVT_INVC_DLVRY |
EVENT INVOICE DELIVERY |
|
DWB_EVT_LYLTY_PROG |
EVENT LOYALTY PROGRAM |
|
DWB_EVT_LYLTY_PROG_ACMLTN |
EVENT LOYALTY PROGRAM ACCUMULATION |
|
DWB_EVT_LYLTY_PROG_RDMPTN |
EVENT LOYALTY PROGRAM REDEMPTION |
|
DWB_EVT_PROD_PKG |
EVENT PRODUCT PACKAGE |
|
DWB_EVT_PRPD_MBL |
EVENT PREPAID MOBILE |
|
DWB_EVT_PRTY_ASGN |
EVENT PARTY ASSIGNMENT |
|
DWB_EVT_PRTY_INTRACN |
EVENT PARTY INTERACTION |
|
DWB_EVT_PRTY_INTRACN_CALL |
EVENT PARTY INTERACTION CALL |
|
DWB_EVT_PRTY_INTRACN_EML |
EVENT PARTY INTERACTION EMAIL |
|
DWB_EVT_PRTY_INTRACN_LTTR |
EVENT PARTY INTERACTION LETTER |
|
DWB_EVT_PRTY_INTRACN_VST |
EVENT PARTY INTERACTION VISIT |
|
DWB_EVT_PRTY_PRFL |
EVENT PARTY PROFILE |
|
DWB_EVT_SBRP |
EVENT SUBSCRIPTION |
|
DWB_EVT_SBRP_CHNG |
EVENT SUBSCRIPTION CHANGE |
|
DWB_EVT_SIM_CARD |
EVENT SIM CARD |
|
DWB_EVT_STAT |
EVENT STATUS |
|
DWB_EVT_TRGR_DTL |
EVENT TRIGGER DETAIL |
|
DWB_EVT_WEB_RGSTRN |
EVENT WEB REGISTRATION |
|
DWB_EVT_WEB_VST |
EVENT WEB VISIT |
|
DWB_FIXED_LN_CALL_EVT |
FIXED LINE CALL EVENT |
|
DWB_IDD_CALL_EVT |
IDD CALL EVENT |
|
DWB_INTRACN_ANSWR_CHOICE |
INTERACTION ANSWER CHOICE |
|
DWB_INTRACN_QUES_RESPN |
INTERACTION QUESTION RESPONSE |
|
DWB_INTRNT_ACCS_EVT |
INTERNET ACCESS EVENT |
|
DWB_INVC |
INVOICE |
|
DWB_INVC_ADJ |
INVOICE ADJUSTMENT |
|
DWB_INVC_DISC |
INVOICE DISCOUNT |
|
DWB_INVC_ITEM |
INVOICE ITEM |
|
DWB_INVC_ITEM_DTL |
INVOICE ITEM DETAIL |
|
DWB_INVC_ITEM_RLTN |
INVOICE ITEM RELATIONSHIP |
|
DWB_INVC_PYMT_ASGN |
INVOICE PAYMENT ASSIGNMENT |
|
DWB_INVC_TAX_ITEM |
INVOICE TAX ITEM |
|
DWB_ISP_USG_EVT |
ISP USAGE EVENT |
|
DWB_LYLTY_PROG_PTS_BAL |
LOYALTY PROGRAM POINTS BALANCE |
|
DWB_MDTD_CALL_EVT |
MEDIATED CALL EVENT |
|
DWB_MEDIA_OBJ_COST |
MEDIA OBJECT COST |
|
DWB_MKT_PLN_MGMT |
MARKET PLAN MANAGEMENT |
|
DWB_MMS_EVT |
MMS EVENT |
|
DWB_MNT_ALLWNC |
MINUTE ALLOWANCE |
|
DWB_NP_RQST_HDR |
NP REQUEST HEADER |
|
DWB_NP_RQST_LN_ITEM |
NP REQUEST LINE ITEM |
|
DWB_NP_RQST_LN_ITEM_STATE_HIST |
NP REQUEST LINE ITEM STATE HISTORY |
|
DWB_NP_RQST_STATE_HIST |
NP REQUEST STATE HISTORY |
|
DWB_NTWK_ELMNT_COST |
NETWORK ELEMENT COST |
|
DWB_NTWK_ELMNT_FLT_ASGN |
NETWORK ELEMENT FAULT ASSIGNMENT |
|
DWB_NTWK_EVT |
NETWORK EVENT |
|
DWB_NTWK_EVT_ASGN |
NETWORK EVENT ASSIGNMENT |
|
DWB_NTWK_FLT |
NETWORK FAULT |
|
DWB_NTWK_FLT_SBRP_ASGN |
NETWORK FAULT SUBSCRIPTION ASSIGNMENT |
|
DWB_ORG_BSNS_UNIT_COST |
ORGANIZATIONAL BUSINESS UNIT COST |
|
DWB_PLCY_EVT |
POLICY EVENT |
|
DWB_PLCY_EVT_ATMC |
POLICY EVENT ATOMIC |
|
DWB_PLCY_EVT_CMPST |
POLICY EVENT COMPOSITE |
|
DWB_PRICE_EVT |
PRICE EVENT |
|
DWB_PRMTN_CLSTR_USG |
PROMOTION CLUSTER USAGE |
|
DWB_PRMTN_CNCT_LST_UTLZTN |
PROMOTION CONTACT LIST UTILIZATION |
|
DWB_PRMTN_COST |
PROMOTION COST |
|
DWB_PRMTN_MGMT_HIST |
PROMOTION MANAGEMENT HISTORY |
|
DWB_PRMTN_TERM_VAL |
PROMOTION TERM VALUE |
|
DWB_PROD_COST |
PRODUCT COST |
|
DWB_PROD_MGMT_HIST |
PRODUCT MANAGEMENT HISTORY |
|
DWB_PROD_MKT_PLN_COST |
PRODUCT MARKET PLAN COST |
|
DWB_PROD_STAT_HIST |
PRODUCT STATUS HISTORY |
|
DWB_PRPD_RCHRG |
PREPAID RECHARGE |
|
DWB_PRTY_AM_PMP_ASGN_HIST |
PARTY AM PMP ASSIGNMENT HISTORY |
|
DWB_PRTY_AM_PMP_ASGN_STAT |
PARTY AM PMP ASSIGNMENT STATUS |
|
DWB_PRTY_COST_ASGN |
PARTY COST ASSIGNMENT |
|
DWB_PRTY_INTRACN_THRD |
PARTY INTERACTION THREAD |
|
DWB_PRTY_ORDR_ASGN |
PARTY ORDER ASSIGNMENT |
|
DWB_PRTY_PRMTN_RESPN |
PARTY PROMOTION RESPONSE |
|
DWB_PRTY_STAT_HIST |
PARTY STATUS HISTORY |
|
DWB_PTV_FULL_CHNL_ACTVTN |
PTV FULL CHANNEL ACTIVATION |
|
DWB_PTV_QPI_SRVC_EVT |
PTV QPI SERVICE EVENT |
|
DWB_PTV_USG_EVT |
PTV USAGE EVENT |
|
DWB_RAW_MMS_EVT |
RAW MMS EVENT |
|
DWB_RAW_WRLS_CALL_EVT |
RAW WIRELESS CALL EVENT |
|
DWB_RESRE_ORDR |
RESOURCE ORDER |
|
DWB_RESRE_ORDR_ITEM |
RESOURCE ORDER ITEM |
|
DWB_RTD_NTWK_EVT |
RATED NETWORK EVENT |
|
DWB_SBRP_STAT_HIST |
SUBSCRIPTION STATUS HISTORY |
|
DWB_SBRP_TERM_VAL |
SUBSCRIPTION TERM VALUE |
|
DWB_SL_CMISN_DTL |
SALES COMMISSION DETAIL |
|
DWB_SL_CMISN_PYRL |
SALES COMMISSION PAYROLL |
|
DWB_SMS_EVT |
SMS EVENT |
|
DWB_SRVC_ORDR |
SERVICE ORDER |
|
DWB_SRVC_ORDR_LN_ITEM |
SERVICE ORDER LINE ITEM |
|
DWB_SRVC_RQST |
SERVICE REQUEST |
|
DWB_TAP_IN_WRLS_RMNG_EVT |
TAP IN WIRELESS ROAMING EVENT |
|
DWB_TAP_OUT_WRLS_RMNG_EVT |
TAP OUT WIRELESS ROAMING EVENT |
|
DWB_UMS_EVT |
UMS EVENT |
|
DWB_VNDR_APNMNT |
VENDOR APPOINTMENT |
|
DWB_VOIP_CALL_EVT |
VOIP CALL EVENT |
|
DWB_WRLS_CALL_EVT |
WIRELESS CALL EVENT |
|
DWB_WRLS_CNTNT_DNLDG_EVT |
WIRELESS CONTENT DOWNLOADING EVENT |
|
DWB_WRLS_RMNG_EVT |
WIRELESS ROAMING EVENT |
|
DWB_WRLS_RMNG_EVT_BTCH |
WIRELESS ROAMING EVENT BATCH |
Table 4-5 briefly describes the Derived tables in Oracle Communications Data Model.
Table Name | Description | More Information |
---|---|---|
DWD_ACCT_DEBT_DAY |
ACCOUNT DEBT DAY DRVD |
|
DWD_ACCT_PYMT_DAY |
ACCOUNT PAYMENT DAY DRVD |
|
DWD_ACCT_PYMT_MTHD_STAT_HIST |
ACCOUNT PAYMENT METHOD STATUS HIST DRVD |
|
DWD_ACCT_RFND_DAY |
ACCOUNT REFUND DAY DRVD |
|
DWD_ACCT_STAT |
ACCOUNT STATUS DRVD |
|
DWD_ACCT_STTSTC |
ACCOUNT STATISTIC DRVD |
|
DWD_ARPU_BASE |
ARPU BASE DRVD |
|
DWD_BER_FER_ERR_RATIO_DAY |
BER FER ERROR RATIO DAY DRVD |
|
DWD_CALL_CNTR_CALL_DAY |
CALL CENTER CALL DAY DRVD |
|
DWD_CALL_CNTR_CASE_DAY |
CALL CENTER CASE DAY DRVD |
|
DWD_CANBLZTN_DTL_DAY |
CANNIBALIZATION DETAIL DAY DRVD |
|
DWD_CELL_STTSTC_DAY |
CELL STATISTIC DAY DRVD |
|
DWD_CHRN_PRDCT_SRC |
CHURN PREDICT SOURCE DERIVED |
|
DWD_CMISN_DAY |
COMMISSION DAY DRVD |
|
DWD_CNCT_DSCNCT_DAY |
CONNECT DISCONNECT DAY DRVD |
|
DWD_CNRT |
CONTRACT DRVD |
|
DWD_CNRT_CHNG |
CONTRACT CHANGED DRVD |
|
DWD_COST_CUST |
COST CUSTOMER DRVD |
|
DWD_COST_ORG |
COST ORGANIZATIONAL DRVD |
|
DWD_CRDT_CTGRY |
CREDIT CATEGORY DRVD |
|
DWD_CUST_ACQSTN_SUMM_DAY |
CUSTOMER ACQUISITION SUMMARY DAY DRVD |
|
DWD_CUST_DEBT_COLLCTN |
CUSTOMER DEBT COLLECTION DRVD |
|
DWD_CUST_MNNG |
CUSTOMER MINING |
|
DWD_CUST_EQPMNT_INSTLTN_DAY |
CUSTOMER EQUIPMENT INSTALLATION DAY DRVD |
|
DWD_DATA_USG_DAY |
DATA USAGE DAY DRVD |
|
DWD_EXTRNL_DEBT_COLLCTN_DAY |
EXTERNAL DEBT COLLECTION DAY DRVD |
|
DWD_GIVE_AWAY_ITEM_DAY |
GIVE AWAY ITEM DAY DRVD |
|
DWD_GPRS_PCU_DAY |
GPRS PCU DAY DRVD |
|
DWD_GPRS_SRVCS_DAY |
GPRS SERVICES DAY DRVD |
|
DWD_HNDST_STCK_DAY |
HANDSET STOCK DAY DRVD |
|
DWD_HNDST_SUBSDY_DAY |
HANDSET SUBSIDY DAY DRVD |
|
DWD_IN_PLTFRM_DAY |
IN PLATFORM DAY DRVD |
|
DWD_INTRNL_DEBT_COLLCTN_DAY |
INTERNAL DEBT COLLECTION DAY DRVD |
|
DWD_INVC |
INVOICE DRVD |
|
DWD_INVC_ADJ |
INVOICE ADJUSTMENT DRVD |
|
DWD_LN_ACTVTN_TMNT_DAY |
LINE ACTIVATION TERMINATION DAY DRVD |
|
DWD_LYLTY_PROG_DAY |
LOYALTY PROGRAM DAY DRVD |
|
DWD_MKT_OPRTR_PRTNG |
MARKET OPERATOR PORTING DERIVED |
|
DWD_MKT_SHARE |
MARKET SHARE DRVD |
|
DWD_MSC_TRFC_DAY |
MSC TRAFFIC DAY DRVD |
|
DWD_NBR_PRT_DAY |
NUMBER PORT DAY DRVD |
|
DWD_NTWK_AVLBLTY_DAY |
NETWORK AVAILABILITY DAY DRVD |
|
DWD_NTWK_TCHPNT |
NETWORK TOUCHPOINT DRVD |
|
DWD_PRPD_ACCT_STTSTC |
PREPAID ACCOUNT STATISTIC DRVD |
|
DWD_PRPD_ALWNCE_DAY |
PREPAID ALLOWANCE DAY DRVD |
|
DWD_PRPD_CALL_SUMM_DAY |
PREPAID CALL SUMMARY DAY DRVD |
|
DWD_PRTNR_STLMNT |
PARTNER SETTLEMENT DRVD |
|
DWD_PYMT_AGNG_DAY |
PAYMENT AGING DAY DRVD |
|
DWD_RDMPTN_DAY |
REDEMPTION DAY DRVD |
|
DWD_RF_NTWK_CPCTY_DAY |
RF NETWORK CAPACITY DAY DRVD |
|
DWD_SBCRBR_CHRN_STTSTC |
SUBSCRIBER CHURN STATISTIC DRVD |
|
DWD_SHOP_EFFNCY_DAY |
SHOP EFFICIENCY DAY DRVD |
|
DWD_SHARED_PKG_USG_STTSTC_DAY |
SHARED PACKAGE USAGE STATISTICS DAY DRVD |
|
DWD_SL_CMPGN_SUMM_DAY |
SALES CAMPAIGN SUMMARY DAY DRVD |
|
DWD_SL_DAY |
SALES DAY DRVD |
|
DWD_SL_RPRSTV_STTSTC |
SALES REPRESENTATIVE STATISTICS DRVD |
|
DWD_SPLMNTR_SRVC_USG |
SUPPLEMENTARY SERVICE USAGE DRVD |
|
DWD_SUBSDY_AMT |
SUBSIDY AMOUNT DRVD |
|
DWD_VAS_SBRP_QCK_SUMM |
VAS SUBSCRIPTION QUICK SUMMARY DRVD |
|
DWD_VAS_USG_DAY |
VAS USAGE DAY DRVD |
|
DWD_VOI_CALL_DAY |
VOICE CALL DAY DRVD |
Table 4-6 briefly describes the Aggregate tables in Oracle Communications Data Model.
Table Name | Description | More Information |
---|---|---|
DWA_ACCT_DEBT_MO |
ACCOUNT DEBT MONTH AGGR |
|
DWA_ACCT_PYMT_MO |
ACCOUNT PAYMENT MONTH AGGR |
|
DWA_ACCT_PYMT_MTHD_STAT_HIST |
ACCOUNT PAYMENT METHOD STATUS HIST AGGR |
|
DWA_ACCT_RFND_MO |
ACCOUNT REFUND MONTH AGGR |
|
DWA_ACCT_STAT_TYP |
ACCOUNT STATUS TYPE AGGR |
|
DWA_ACCT_STTSTC_TYP |
ACCOUNT STATISTIC TYPE AGGR |
|
DWA_ARPU_BASE_CUST_TYP |
ARPU BASE CUSTOMER TYPE AGGR |
|
DWA_BER_FER_ERR_RATIO_MO |
BER FER ERROR RATIO MONTH AGGR |
|
DWA_CALL_CNTR_CALL_MO |
CALL CENTER CALL MONTH AGGR |
|
DWA_CALL_CNTR_CASE_MO |
CALL CENTER CASE MONTH AGGR |
|
DWA_CANBLZTN_DTL_MO |
CANNIBALIZATION DETAIL MONTH AGGR |
|
DWA_CELL_STTSTC_MO |
CELL STATISTIC MONTH AGGR |
|
DWA_CMISN_MO |
COMMISSION MONTH AGGR |
|
DWA_CNCT_DSCNCT_MO |
CONNECT DISCONNECT MONTH AGGR |
|
DWA_CNRT_MO |
CONTRACT MONTH AGGR |
|
DWA_COST_CUST_MO |
COST CUSTOMER MONTH AGGR |
|
DWA_COST_ORG_MO |
COST ORGANIZATIONAL MONTH AGGR |
|
DWA_CRDT_CTGRY_MO |
CREDIT CATEGORY MONTH AGGR |
|
DWA_CUST_ACQSTN_SUMM_MO |
CUSTOMER ACQUISITION SUMMARY MONTH AGGR |
|
DWA_CUST_DEBT_COLLCTN_MO |
CUSTOMER DEBT COLLECTION MONTH AGGR |
|
DWA_CUST_EQPMNT_INSTLTN_MO |
CUSTOMER EQUIPMENT INSTALLATION MO AGGR |
|
DWA_DATA_USG_MO |
DATA USAGE MONTH AGGR |
|
DWA_EXTRNL_DEBT_COLLCTN_MO |
EXTERNAL DEBT COLLECTION MONTH AGGR |
|
DWA_GIVE_AWAY_ITEM_MO |
GIVE AWAY ITEM MONTH AGGR |
|
DWA_GPRS_PCU_MO |
GPRS PCU MONTH AGGR |
|
DWA_GPRS_SRVCS_MO |
GPRS SERVICES MONTH AGGR |
|
DWA_HNDST_STCK_MO |
HANDSET STOCK MO AGGR |
|
DWA_HNDST_SUBSDY_MO |
HANDSET SUBSIDY MONTH AGGR |
|
DWA_IN_PLTFRM_MO |
IN PLATFORM MONTH AGGR |
|
DWA_INTRNL_DEBT_COLLCTN_MO |
INTERNAL DEBT COLLECTION MONTH AGGR |
|
DWA_INVC_ADJ_MO |
INVOICE ADJUSTMENT MONTH AGGR |
|
DWA_INVC_CUST_TYP |
INVOICE CUSTOMER TYPE AGGR |
|
DWA_LN_ACTVTN_TMNT_MO |
LINE ACTIVATION TERMINATION MONTH AGGR |
|
DWA_LYLTY_PROG_MO |
LOYALTY PROGRAM MO AGGR |
|
DWA_MKT_SHARE |
MARKET SHARE AGGR |
|
DWA_MSC_TRFC_MO |
MSC TRAFFIC MONTH AGGR |
|
DWA_NBR_PRT_MO |
NUMBER PORT MONTH AGGR |
|
DWA_NTWK_AVLBLTY_MO |
NETWORK AVAILABILITY MONTH AGGR |
|
DWA_NTWK_TCHPNT_MO |
NETWORK TOUCHPOINT MONTH AGGR |
|
DWA_PRPD_ACCT_STTSTC_SGMNT |
PREPAID ACCOUNT STATISTIC SEGMENT AGGR |
|
DWA_PRPD_ALWNCE_MO |
PREPAID ALLOWANCE MONTH AGGR |
|
DWA_PRPD_CALL_SUMM_MO |
PREPAID CALL SUMMARY MONTH AGGR |
|
DWA_PRTNR_STLMNT_MO |
PARTNER SETTLEMENT MONTH AGGR |
|
DWA_PYMT_AGNG_MO |
PAYMENT AGING MONTH AGGR |
|
DWA_RDMPTN_MO |
REDEMPTION MO AGGR |
|
DWA_RF_NTWK_CPCTY_MO |
RF NETWORK CAPACITY MONTH AGGR |
|
DWA_SBCRBR_CHRN_STTSTC_MO |
SUBSCRIBER CHURN STATISTIC MONTH AGGR |
|
DWA_SHARED_PKG_USG_STTSTC_MO |
SHARED PACKAGE USAGE STATISTICS MO AGGR |
|
DWA_SHOP_EFFNCY_MO |
SHOP EFFICIENCY MONTH AGGR |
|
DWA_SL_CMPGN_SUMM_MO |
SALES CAMPAIGN SUMMARY MONTH AGGR |
|
DWA_SL_MO |
SALES MONTH AGGR |
|
DWA_SL_RPRSTV_STTSTCS_MO_AGGR |
SALES REPRESENTATIVE STATISTICS MO AGGR |
|
DWA_SPLMNTR_SRVC_USG_MO |
SUPPLEMENTARY SERVICE USAGE MONTH AGGR |
|
DWA_SUBSDY_AMT_MO |
SUBSIDY AMOUNT MONTH AGGR |
|
DWA_VAS_SBRP_QCK_SUMM_MO |
VAS SUBSCRIPTION QUICK SUMMARY MO AGGR |
|
DWA_VAS_USG_MO |
VAS USAGE MONTH AGGR |
|
DWA_VOI_CALL_MO |
VOICE CALL MONTH AGGR |
Table 4-7 briefly describes the temporary tables in Oracle Communications Data Model.
Table 4-7 Temporary Oracle Communications Data Model Tables
Table Name | Description |
---|---|
DMV_CUST_GROSS_ORDRS_QTR |
|
DMV_CUST_NET_ORDRS_QTR |
|
DMV_CUST_ORDR_MO |
Table 4-8 Miscellaneous Oracle Communications Data Model Tables
Table Name | Description |
---|---|
|
The MV which prejoins dwr_cnrt,dwr_sbrp, dwr_acct, dwr_prod, and dwr_cust. This MV is on sbrp_key level . This join occurs frequently in the Intra ETL, so it is prejoined and stores the result MV, then the Intra ETL only needs to access the MV instead of joining the five tables. |
|
Table stores staging results in populating data for DWD_VOI_CALL_DAY. |
Table 4-9 lists the Sequence Names in Oracle Communications Data Model.
Generates the Physical Key for Table Name | Sequence Name |
---|---|
DWR_ACCS_MTHD |
AM_SEQ |
DWR_ACCS_MTHD_ELMNT |
AME1_SEQ |
DWR_ACCS_MTHD_POOL |
AMP_SEQ |
DWR_ACCS_MTHD_SGMNT |
AMS_SEQ |
DWR_ACCSRS |
ACCE_SEQ |
DWR_ACCT |
ACCT_SEQ |
DWR_ACCT_BLLG_CYCL_HIST |
ABCH_SEQ |
DWR_ACCT_BLLG_FRQNCY_HIST |
ABFH_SEQ |
DWR_ACCT_BLLG_PRD_HIST |
ABPH_SEQ |
DWR_ACCT_BSNS_INTRACN_RL |
ABIR_SEQ |
DWR_ACCT_PREF_PYMT_MTHD |
APP_SEQ |
DWR_ACCT_PRFL |
APH1_SEQ |
DWR_ACCT_SGMNT |
ACCT_SEG_SEQ |
DWR_ACCT_SGMNT_MDL |
CSM_2_SEQ |
DWR_ADDR_LOC |
AL1_SEQ |
DWR_ADDR_RLTD |
AR_1_SEQ |
DWR_ADTNL_TXT |
AT2_SEQ |
DWR_ADVR_PRD |
AP_SEQ |
DWR_ADVR_QTR |
AQ_SEQ |
DWR_ADVR_WK |
AW_SEQ |
DWR_ADVR_YR |
AY_SEQ |
DWR_AGGRTN_INTRFC |
AGIN_SEQ |
DWR_AMRCN_PRPTY_ADDR |
APA_SEQ |
DWR_ANZSIC_CLSFCTN |
ANZSIC_SEQ |
DWR_ATM_INTRFC |
ATIN_SEQ |
DWR_ATONOMS_SYS |
AOSY_SEQ |
DWR_AUXILIARY_CMPNT |
AXCM_SEQ |
DWR_BASE_TRNSCVR_STN |
BTS_SEQ |
DWR_BNK |
BAN1_SEQ |
DWR_BNK_DRCT_DEBT_CHNL |
BDDC_SEQ |
DWR_BRDGNG_PROTCL |
BP1_SEQ |
DWR_BRND |
BRA_SEQ |
DWR_BSNS_HLF_MO |
BHM_SEQ |
DWR_BSNS_HLF_YR |
BHY_SEQ |
DWR_BSNS_INTRACN_LOC_ASGN |
BILA_SEQ |
DWR_BSNS_INTRACN_RL |
BIR_SEQ |
DWR_BSNS_MO |
BM_SEQ |
DWR_BSNS_QTR |
BQ_SEQ |
DWR_BSNS_UNIT_SHFT |
BUS_SEQ |
DWR_BSNS_WK |
BW_SEQ |
DWR_BSNS_YR |
BY1_SEQ |
DWR_CALL_CNTR |
CC3_SEQ |
DWR_CALL_CNTR_AGNT |
CCA_SEQ |
DWR_CALL_CNTR_SRVC_CAPBLTY |
CCSC_SEQ |
DWR_CALL_SRC_DSTN |
CD3_SEQ |
DWR_CARD |
CARD_SEQ |
DWR_CBL |
CBL_SEQ |
DWR_CELL |
CEL_SEQ |
DWR_CELL_SCTR |
CS1_SEQ |
DWR_CELL_SITE |
CS2_SEQ |
DWR_CHASSIS |
CHS_SEQ |
DWR_CHNL |
CHNL_SEQ |
DWR_CLNDR_HLF_MO |
CHM_SEQ |
DWR_CLNDR_HLF_YR |
CHY_SEQ |
DWR_CLNDR_MO |
CM_SEQ |
DWR_CLNDR_QTR |
CQ_SEQ |
DWR_CLNDR_WK |
CW_SEQ |
DWR_CLNDR_YR |
CY_SEQ |
DWR_CMPGN |
CAM_SEQ |
DWR_CMPGN_CHNL |
RCC_SEQ |
DWR_CMPGN_CHTRSTC |
CMCH_SEQ |
DWR_CMPGN_CHTRSTC_VAL |
CCV_SEQ |
DWR_CMPGN_DOC |
RCMD_SEQ |
DWR_CMPGN_MSG |
RCM_SEQ |
DWR_CMPGN_MSG_DPCT |
CMD_SEQ |
DWR_CMPND_ELMNT |
CE_SEQ |
DWR_CMPND_ELMNT_CMPND_DTL |
CECD_SEQ |
DWR_CMPND_ELMNT_COLLCTN |
CECL_SEQ |
DWR_CMPND_ELMNT_DTL |
CED_SEQ |
DWR_CMPND_ELMNT_LGICL_DTL |
CELD_SEQ |
DWR_CMPND_ELMNT_PHY_DTL |
CEPD_SEQ |
DWR_CMPND_ELMNT_RL |
CER1_SEQ |
DWR_CMPND_ELMNT_RL_ASGN |
CERA_SEQ |
DWR_CMPND_ELMNT_RL_SPEC |
CERS_SEQ |
DWR_CMPND_ELMNT_TP_DTL |
CETD_SEQ |
DWR_CMPND_ELMNT_UNIT |
CEU_SEQ |
DWR_CMPNT_SBRP_PRICE |
CTSP_SEQ |
DWR_CMPST_COMP_PROD_CRL_CHTRTC |
CPCC_SEQ |
DWR_CMPST_PROD_RTNG_PLN |
CPRP_SEQ |
DWR_CMPST_SBRP_PRICE |
CSPR_SEQ |
DWR_CMPST_SRVC |
CMST_SEQ |
DWR_CMPTR |
CPTR_SEQ |
DWR_CMPTR_INTLGNCE_PRTY_RL |
CPTR9_SEQ |
DWR_CNCT_LST |
CL_SEQ |
DWR_CNCTN |
CTN_SEQ |
DWR_CNCTN_TMNT_PNT |
CTP_SEQ |
DWR_CNRT |
CON_SEQ |
DWR_CNRT_DOC |
CD_SEQ |
DWR_CNRT_ITEM |
CNIT_SEQ |
DWR_CNSEQ_PRFMNC_NTFCTN |
CQPN_SEQ |
DWR_CNTNT |
CNTNT_SEQ |
DWR_CNTNT_PRICE |
CP1_SEQ |
DWR_CNTNT_PRVDR |
CP_SEQ |
DWR_COLLCTN |
CLTN_SEQ |
DWR_COLLCTN_AGNCY |
CAP_SEQ |
DWR_COMP_INTL_CHTRSTC |
CICH_SEQ |
DWR_COMP_INTL_CHTRSTC_VAL |
CIHV_SEQ |
DWR_COMP_PROD_CRRL_CHTRSTC |
CPCH_SEQ |
DWR_COMP_PROD_CRRL_CHTRSTC_VAL |
CCHV_SEQ |
DWR_COMUNICTN_SRVC |
CMSR_SEQ |
DWR_CORE_INTRFC |
CRI1_SEQ |
DWR_COST_CNTR |
CC1_SEQ |
DWR_COURIER |
CAR1_SEQ |
DWR_CPCTY |
CPY_SEQ |
DWR_CPE_LGICL_DVC_RL |
CLDR_SEQ |
DWR_CRCUT_CMPNT |
CC_SEQ |
DWR_CRDT_CTGRY |
DLCC_SEQ |
DWR_CRDT_SCR_PRVDR |
CSP_SEQ |
DWR_CRNCY_GEO_ENT_ASGN |
CGER_SEQ |
DWR_CUST |
CI_SEQ |
DWR_CUST_CLASS_ASGN |
CCAI_SEQ |
DWR_CUST_DOC |
CDOC_SEQ |
DWR_CUST_FCNG_SRVC |
CFS1_SEQ |
DWR_CUST_FCNG_SRVC_RL |
CFSR_SEQ |
DWR_CUST_FCNG_SRVC_SPEC_RL |
CFSSR_SEQ |
DWR_CUST_FCNG_SRVC_SPEC_VRSN |
CFV_SEQ |
DWR_CUST_INDVL |
CUSTI_SEQ |
DWR_CUST_OCCSN |
CO2_SEQ |
DWR_CUST_ORDR_DOC |
COD_SEQ |
DWR_CUST_RSTRCT_INFO |
CRI_1_SEQ |
DWR_CUST_SCR |
DLCS_SEQ |
DWR_CUST_SGMNT |
SEG_SEQ |
DWR_CUST_SGMNT_MDL |
CSM_SEQ |
DWR_CUST_SIC_ASGN |
CSIC_SEQ |
DWR_CUST_SRC |
CS5_SEQ |
DWR_DAY |
DAY_SEQ |
DWR_DAY_ACT_CONDITION |
DAC_SEQ |
DWR_DAY_TODATE_TRANS |
DTT_SEQ |
DWR_DAY_TRANS |
DTRAN_SEQ |
DWR_DEAL |
DEA2_SEQ |
DWR_DEMOG_ATRIB |
DA_SEQ |
DWR_DEMOG_CHTRSTC |
DGCH_SEQ |
DWR_DEMOG_CHTRSTC_VAL |
DCHV_SEQ |
DWR_DEMOG_GRP |
DG_SEQ |
DWR_DISC_GRP |
XEDG_SEQ |
DWR_DISC_SBRP_PRICE_ALTRTN |
DSPA_SEQ |
DWR_DLR |
DEA1_SEQ |
DWR_DLR_DISC_GRP_ASGN |
DDGA_SEQ |
DWR_DRVD_VAL |
DV_SEQ |
DWR_DVC_INTRFC |
DVI_SEQ |
DWR_DVC_INTRFC_RL |
DIR_SEQ |
DWR_EDGE_INTRFC |
EGI_SEQ |
DWR_ELMNT_CHTRSTC |
ECH_SEQ |
DWR_ELMNT_CHTRSTC_ASGN |
ECHA_SEQ |
DWR_ELMNT_CHTRSTC_RLTN |
ECHR_SEQ |
DWR_ELMNT_CHTRSTC_VAL |
ECHV_SEQ |
DWR_ELMNT_CHTRSTC_VAL_ASGN |
EHVA_SEQ |
DWR_ELMNT_CHTRSTC_VAL_RLTN |
EHVR_SEQ |
DWR_EMP |
EMP_SEQ |
DWR_EMP_LANG_CAPBLTY |
ELC_SEQ |
DWR_EMP_RSTRCT_INFO |
CRI_SEQ |
DWR_ENT |
ENT_SEQ |
DWR_ENT_RL |
ETR1_SEQ |
DWR_ENT_SPECFTN |
ETS_SEQ |
DWR_EQPMNT |
EQU_SEQ |
DWR_EQPMNT_CNTR |
EC2_SEQ |
DWR_EQPMNT_FNCTNLTY |
EF_SEQ |
DWR_EQPMNT_HLDR |
EQH_SEQ |
DWR_EQPMNT_INSTNC |
EI_SEQ |
DWR_EQPMNT_INSTNC_RENTING_CNRT |
EISH_SEQ |
DWR_EQPMNT_SBRP |
EQS_SEQ |
DWR_EVT_PRTY_RL |
EPR_SEQ |
DWR_EVT_RSLTN |
ER2_SEQ |
DWR_EXCLD_PRT_DTL |
EXPD_SEQ |
DWR_EXTRNL_INFO_SRC |
EIS_SEQ |
DWR_EXTRNL_OPRTR |
PEO_SEQ |
DWR_FCTR_CMPNY |
FC_SEQ |
DWR_FRWL_RL |
FWL_SEQ |
DWR_FSCL_HLF_MO |
FHM_SEQ |
DWR_FSCL_HLF_YR |
FHY_SEQ |
DWR_FSCL_MO |
FM_SEQ |
DWR_FSCL_QTR |
FQ_SEQ |
DWR_FSCL_WK |
FW_SEQ |
DWR_FSCL_YR |
FY_SEQ |
DWR_FXBLE_CHTRSTC |
FCH_SEQ |
DWR_FXBLE_CHTRSTC_ASGN |
FCA_SEQ |
DWR_FXBLE_CHTRSTC_ASGN_TYP |
FCAT_SEQ |
DWR_FXBLE_CHTRSTC_RLTN |
FCR_SEQ |
DWR_FXBLE_CHTRSTC_TYP |
FCT_SEQ |
DWR_FXBLE_CHTRSTC_VAL |
FCV_SEQ |
DWR_FXBLE_CHTRSTC_VAL_ASGN |
FCVA_SEQ |
DWR_FXBLE_CHTRSTC_VAL_RLTN |
FCVR_SEQ |
DWR_GEO_BLDG |
GEOB_SEQ |
DWR_GEO_CITY |
GC1_SEQ |
DWR_GEO_CNTRY |
GC_SEQ |
DWR_GEO_CNTY |
GEOC_SEQ |
DWR_GEO_DEMOG_ATRIB |
GDA_SEQ |
DWR_GEO_DEMOG_GRP |
GDG_SEQ |
DWR_GEO_DEMOG_VAL |
GDV_SEQ |
DWR_GEO_ENT |
GE_1_SEQ |
DWR_GEO_HRCHY |
GH_SEQ |
DWR_GEO_HRCHY_LVL |
GHL_SEQ |
DWR_GEO_LVL |
GL_SEQ |
DWR_GEO_LVL_ATRIB |
GLATTR_SEQ |
DWR_GEO_LVL_ATRIB_VAL |
GLA_SEQ |
DWR_GEO_NIEHBRHD |
GEOCM_SEQ |
DWR_GEO_RGN |
GR_1_SEQ |
DWR_GEO_SBRGN |
GSR_SEQ |
DWR_GEO_STATE |
GS_1_SEQ |
DWR_GEO_STRT |
GEOS_SEQ |
DWR_GEO_WORLD |
GW_SEQ |
DWR_GL_REF |
GR_SEQ |
DWR_GPRS_SRVC |
GS_SEQ |
DWR_HH |
HOU1_SEQ |
DWR_HLDR_ATMC |
HA_SEQ |
DWR_HLDR_CMPST |
HC_SEQ |
DWR_HLF_HR |
HH_SEQ |
DWR_HLF_MO_TODATE_TRANS |
HMTT_SEQ |
DWR_HLF_MO_TRANS |
HMT_SEQ |
DWR_HLF_YR_TRANS |
HYT_SEQ |
DWR_HNDST_INSTNC |
HAN_SEQ |
DWR_HNDST_MDL |
HM_SEQ |
DWR_HR |
HOU_SEQ |
DWR_HRDWR |
HW_SEQ |
DWR_IN_PLTFRM |
DRIP_SEQ |
DWR_IN_RUTNG_DVC |
IR1_SEQ |
DWR_INDVL_DEMOG_VAL |
IDV_1_SEQ |
DWR_INDVL_NAME |
IVNM_SEQ |
DWR_INTRACN_CHNL |
IC_SEQ |
DWR_INVC_PYMT_TRM |
IPT_SEQ |
DWR_IP_ADDR |
IPA_SEQ |
DWR_IP_SUBNET |
ISN_SEQ |
DWR_IPV4_ADDR |
IPA4_SEQ |
DWR_ISP |
ISP_SEQ |
DWR_ISP_BSNS |
IBT_SEQ |
DWR_ISP_USER |
IU_SEQ |
DWR_ITEM |
ITE_SEQ |
DWR_JB |
DLJ_SEQ |
DWR_JB_RL |
JR_SEQ |
DWR_KEY_PRFMNC_IND_SLS_PARM |
KPIP_SEQ |
DWR_KEY_QLTY_IND_SLS_PARM |
KQSP_SEQ |
DWR_LAN |
LAN1_SEQ |
DWR_LAN_PROTCL |
LP1_SEQ |
DWR_LANG_DIALECT |
LDI_SEQ |
DWR_LAYER_NTWK |
LN_SEQ |
DWR_LGICL_CPCTY |
LGCP_SEQ |
DWR_LGICL_DVC |
LD_SEQ |
DWR_LGICL_DVC_ATMC |
LDA_SEQ |
DWR_LGICL_DVC_CMPST |
LDC_SEQ |
DWR_LGICL_DVC_RL |
LDR_SEQ |
DWR_LGICL_DVC_RL_SPEC |
LDRS_SEQ |
DWR_LGICL_ELMNT |
LE_SEQ |
DWR_LGICL_ELMNT_RL |
LER_SEQ |
DWR_LGICL_ELMNT_RL_ASGN |
LERA_SEQ |
DWR_LGICL_ELMNT_RL_SPEC |
LRS_SEQ |
DWR_LGICL_ELMNT_TYP_VRSN |
LETV_SEQ |
DWR_LGICL_INTRFC |
LGIN_SEQ |
DWR_LYLTY_PROG |
LP_SEQ |
DWR_LYLTY_PROG_CHNL |
LPC_SEQ |
DWR_MAILBOX |
MAI_SEQ |
DWR_MANAGED_ENT |
ME1_SEQ |
DWR_MANAGED_HRDWR |
MHW_SEQ |
DWR_MANAGED_TRNSMISN_ENT |
MTE_SEQ |
DWR_MBL_SWTCHNG_CNTR |
MSC_SEQ |
DWR_MEDIA_INTRFC |
MI_SEQ |
DWR_MEDIA_OBJ |
MO_SEQ |
DWR_MGMT_DOMAIN |
MDM_SEQ |
DWR_MGMT_PROTCL |
MPT_SEQ |
DWR_MKT_AREA |
OMA_SEQ |
DWR_MKT_AREA_LVL |
OMAL_SEQ |
DWR_MKT_PLN_TERM_VAL |
MPTV_SEQ |
DWR_MKT_SGMNT |
RMSCHZ_SEQ |
DWR_MKT_SGMNT_CHTRSTC |
MSCH_SEQ |
DWR_MKT_SGMNT_CHTRSTC_VAL |
MSCV_SEQ |
DWR_MNT |
MIN_SEQ |
DWR_MO_TODATE_TRANS |
MTT_SEQ |
DWR_MO_TRANS |
MT1_SEQ |
DWR_NAICS_CLSFCTN |
NAIC_SEQ |
DWR_NAICS_INDSTRY |
NI_SEQ |
DWR_NAICS_INDSTRY_GRP |
NIG_SEQ |
DWR_NAICS_INDSTRY_SCTR |
IS3_SEQ |
DWR_NAICS_INDSTRY_SUBSCTR |
NIS_SEQ |
DWR_NBR_AREA |
DAX_SEQ |
DWR_NBR_CNTRY |
DCC1_SEQ |
DWR_NP_MBL_MSISDN |
NMM_SEQ |
DWR_NTWK |
NET1_SEQ |
DWR_NTWK_ADDR |
NWA_SEQ |
DWR_NTWK_ATMC |
NWAT_SEQ |
DWR_NTWK_CMPST |
NWC_SEQ |
DWR_NTWK_DOMAIN |
NTWK_DOMAIN_SEQ |
DWR_NTWK_ELMNT |
DWNE_SEQ |
DWR_NTWK_ELMNT_BSNS_INTRACN_RL |
NEBIR_SEQ |
DWR_NTWK_ELMNT_RL |
NER_SEQ |
DWR_NTWK_ELMNT_RL_ASGN |
NTRA_SEQ |
DWR_NTWK_ELMNT_RL_SPEC |
NERS_SEQ |
DWR_NTWK_ELMNT_TYP |
NET4_SEQ |
DWR_NTWK_ELMNT_TYP_VRSN |
ELTV_SEQ |
DWR_NTWK_EVT_CHTRSTC |
NEC_SEQ |
DWR_NTWK_EVT_CHTRSTC_ASGN |
NCHA_SEQ |
DWR_NTWK_EVT_CHTRSTC_VAL |
NECV_SEQ |
DWR_NTWK_EVT_CHTRSTC_VAL_ASGN |
NEVA_SEQ |
DWR_NTWK_EVT_CHTRSTC_VAL_RLTN |
NEVR_SEQ |
DWR_NTWK_EVT_TYP_VRSN |
NETV_SEQ |
DWR_NTWK_ROUTE_PNT |
NRP_SEQ |
DWR_NTWK_SITE |
NWS_SEQ |
DWR_NTWK_TCHPNT |
NTP_SEQ |
DWR_OPERTNG_SYS |
OPSY_SEQ |
DWR_ORDR_LN_ITEM_STATE |
OLIS_SEQ |
DWR_ORG_AREA |
ARE_SEQ |
DWR_ORG_BNR |
BAN_SEQ |
DWR_ORG_BSNS_ENT |
OBE_SEQ |
DWR_ORG_BSNS_UNIT |
DOBU_SEQ |
DWR_ORG_CHAIN |
CHA_1_SEQ |
DWR_ORG_CMPNY |
COM_SEQ |
DWR_ORG_CRPRT |
COR_SEQ |
DWR_ORG_DIV |
DIV_SEQ |
DWR_ORG_DSTRCT |
DOD_SEQ |
DWR_ORG_HRCHY |
OH_SEQ |
DWR_ORG_HRCHY_LVL |
OHL_SEQ |
DWR_ORG_HRCHY_LVL_ASGN |
OHLA_SEQ |
DWR_ORG_HRCHY_VRSN |
OHV_SEQ |
DWR_ORG_LVL |
OL_SEQ |
DWR_ORG_LVL_ATRIB_VAL |
OBEA_SEQ |
DWR_ORG_LVL_ATTR |
OLA_SEQ |
DWR_ORG_NAME |
ORGN_SEQ |
DWR_ORG_RGN |
REG_SEQ |
DWR_ORG_WRHS |
OW_SEQ |
DWR_OTHR_INDVL |
OI_SEQ |
DWR_P_LGICL_DVC_RL |
PLD_SEQ |
DWR_PASPRT |
RPP_SEQ |
DWR_PAY_TV |
PTV_SEQ |
DWR_PBLCTN |
PUB_SEQ |
DWR_PE_LGICL_DVC_RL |
PLDR_SEQ |
DWR_PHONE_NBR |
TPN_SEQ |
DWR_PHY_CMPNT |
PHCM_SEQ |
DWR_PHY_CNCTR |
PHCO_SEQ |
DWR_PHY_CONTNR |
PHC_SEQ |
DWR_PHY_DVC |
PHD_SEQ |
DWR_PHY_DVC_ATMC |
PDA_SEQ |
DWR_PHY_DVC_CMPST |
PDC_SEQ |
DWR_PHY_DVC_RL_SPEC |
PDRS_SEQ |
DWR_PHY_DVC_SPEC |
PDS_SEQ |
DWR_PHY_ELMNT |
PHE_SEQ |
DWR_PHY_ELMNT_CHTRSTC |
PECH_SEQ |
DWR_PHY_ELMNT_RL |
PEL_SEQ |
DWR_PHY_ELMNT_RL_ASGN |
PERA_SEQ |
DWR_PHY_ELMNT_RL_SPEC |
PERS_SEQ |
DWR_PHY_EQPMNT |
PEQ_SEQ |
DWR_PHY_LNK |
PHL_SEQ |
DWR_PHY_PRT |
PHP_SEQ |
DWR_PIPE |
PIE_SEQ |
DWR_PLCY |
PY_SEQ |
DWR_PLCY_ACTN |
PYA_SEQ |
DWR_PLCY_ACTN_ATMC |
PYAA_SEQ |
DWR_PLCY_ACTN_CMPST |
PYAC_SEQ |
DWR_PLCY_ACTN_VNDR |
PYAV_SEQ |
DWR_PLCY_CNDTN |
PYC_SEQ |
DWR_PLCY_CNDTN_ASGN |
PYCD_SEQ |
DWR_PLCY_CNDTN_ATMC |
PYCA_SEQ |
DWR_PLCY_CNDTN_CMPST |
PYCC_SEQ |
DWR_PLCY_GRP |
PYG_SEQ |
DWR_PLCY_OPRTR |
POPR_SEQ |
DWR_PLCY_RL |
PYRL_SEQ |
DWR_PLCY_RULE |
PYR_SEQ |
DWR_PLCY_SET |
PYS_SEQ |
DWR_PLCY_STMT |
PYST_SEQ |
DWR_PLCY_VAL |
PYV_SEQ |
DWR_PLCY_VARBLE |
PYB_SEQ |
DWR_PLNG_PRD |
PP4_SEQ |
DWR_PLNG_QTR |
PQ1_SEQ |
DWR_PLNG_SEASON |
PS1_SEQ |
DWR_PLNG_WK |
PW_1_SEQ |
DWR_PLNG_YR |
ADV_SEQ |
DWR_PMP_AVLBLTY |
PMPA_SEQ |
DWR_PMP_LYLTY_PROG_AVLBLTY |
PMPLPA_SEQ |
DWR_PMP_MKT_SGMNT_AVLBLTY |
PMPMSA_SEQ |
DWR_PMP_PRICE_PLCY_ACTN |
PPLA_SEQ |
DWR_PMP_PRICE_PLCY_CNDTN |
PPLC_SEQ |
DWR_PMP_PRICE_PLCY_VAL |
PPLV_SEQ |
DWR_PMP_PRICE_PLCY_VARBLE |
PLVA_SEQ |
DWR_PMP_PROD_INSTNC_ASGN |
PMPPIA_SEQ |
DWR_PMP_RTNG_PLN |
PRPL_SEQ |
DWR_PMP_RTNG_PLN_DTL |
PRDL_SEQ |
DWR_PNT_CD |
PCD_SEQ |
DWR_POSTCD |
POS_SEQ |
DWR_PRFMNC |
PRF_SEQ |
DWR_PRFMNC_IP_ADDR |
PIAD_SEQ |
DWR_PRFMNC_MBL_ADDR |
PMAR_SEQ |
DWR_PRFMNC_NTFCTN |
PNF_SEQ |
DWR_PRFMNC_NTWK_ADDR |
PNA_SEQ |
DWR_PRFMNC_PNT_CD |
PPCD_SEQ |
DWR_PRICE_DRVTN_RULE |
PDR_SEQ |
DWR_PRMTN |
P_SEQ |
DWR_PRMTN_PROD_CTLG_ASGN |
PPCA_SEQ |
DWR_PROD |
PRO_SEQ |
DWR_PROD_ADTNL_TXT |
PAT_SEQ |
DWR_PROD_CAPBLTY |
PC_SEQ |
DWR_PROD_CHTRSTC |
PCH1_SEQ |
DWR_PROD_CHTRSTC_ASGN |
PCHA_SEQ |
DWR_PROD_CHTRSTC_VAL |
PCHV_SEQ |
DWR_PROD_CHTRSTC_VAL_ASGN |
PHVA_SEQ |
DWR_PROD_COVRG_AREA |
PCA_SEQ |
DWR_PROD_COVRG_GEO_DTL |
PCGD_SEQ |
DWR_PROD_CTLG_CHTRSTC |
PCC_SEQ |
DWR_PROD_CTLG_CHTRSTC_ASGN |
PCCA_SEQ |
DWR_PROD_CTLG_CHTRSTC_RLTN |
PCHR_SEQ |
DWR_PROD_CTLG_CHTRSTC_VAL |
PCCHV_SEQ |
DWR_PROD_CTLG_CHTRSTC_VAL_ASGN |
PCHVA_SEQ |
DWR_PROD_CTLG_CHTRSTC_VAL_RLTN |
PHVR_SEQ |
DWR_PROD_FTR |
EF1_SEQ |
DWR_PROD_GRP_ASGN |
PGR_SEQ |
DWR_PROD_INSTNC |
PI3_SEQ |
DWR_PROD_MKT_PLN |
PMP_SEQ |
DWR_PROD_MKT_PLN_GRP |
PMPG_SEQ |
DWR_PROD_MKT_PLN_RLTN |
PMPR_SEQ |
DWR_PROD_PKG |
PPACK_SEQ |
DWR_PROD_RTNG_PLN |
CPP_SEQ |
DWR_PROD_RTNG_PLN_DTL |
CRPD_SEQ |
DWR_PROD_USRNM |
PDUSR_SEQ |
DWR_PROD_VRSN |
PV_SEQ |
DWR_PROTCL |
POTL_SEQ |
DWR_PRPD_MBL_VCHR |
PMV_SEQ |
DWR_PRPD_VCHR |
ACCE1_SEQ |
DWR_PRPTY |
PRPTY_SEQ |
DWR_PRSPCT |
PRO1_SEQ |
DWR_PRTNR_PRMTN_PROG |
PPP_SEQ |
DWR_PRTY |
PAR_SEQ |
DWR_PRTY_BSNS_INTRACN_RL |
PBIR_SEQ |
DWR_PRTY_CNCT_INFO |
PCI_SEQ |
DWR_PRTY_DEMOG_VAL |
PDV_SEQ |
DWR_PRTY_ID |
PI_SEQ |
DWR_PRTY_LANG_CAPBLTY |
PLC_SEQ |
DWR_PRTY_LYLTY_PROG_PRTCPTN |
PLPP_SEQ |
DWR_PRTY_NAME |
PRTY_NAME_SEQ |
DWR_PRTY_PRFL_CHTRSTC |
PPC_SEQ |
DWR_PRTY_PRFL_CHTRSTC_VAL |
PPCV_SEQ |
DWR_PRTY_RL_ASGN |
PRR_SEQ |
DWR_PRTY_RL_STAT |
PRSH_SEQ |
DWR_PRTY_SIM_CARD_ASGN |
PSCH_SEQ |
DWR_PRTY_SKILL |
PRS_SEQ |
DWR_PRTY_SRVC_ASGN |
PSA2_SEQ |
DWR_PV_BIT_STRING_VAL |
PBSV_SEQ |
DWR_PV_BOLEN_VAL |
PBV_SEQ |
DWR_PV_INTEGER_VAL |
PIV_SEQ |
DWR_PV_IP_ADDR_VAL |
PIAV_SEQ |
DWR_PV_STRING_VAL |
PSV_SEQ |
DWR_PVAR_BIT_STRING_VARBLE |
PBIV_SEQ |
DWR_PVAR_STRING_VARBLE |
PSGV_SEQ |
DWR_PYMT_CHNL |
PC2_SEQ |
DWR_QOS_SRVC |
QS_SEQ |
DWR_QTR_HR |
QUA_SEQ |
DWR_QTR_TODATE_TRANS |
QTDT_SEQ |
DWR_QTR_TRANS |
QT_SEQ |
DWR_RACK |
RACK_SEQ |
DWR_RCRNG_PMP_RTNG_PLN_DTL |
RRD_SEQ |
DWR_RESRE_FCNG_SRVC |
RFS_SEQ |
DWR_RESRE_FCNG_SRVC_RL |
RFSR_SEQ |
DWR_RESRE_FCNG_SRVC_SPEC_RL |
RFSSR_SEQ |
DWR_RESRE_FCNG_SRVC_SPEC_VRSN |
RFSV_SEQ |
DWR_RESRE_PRFMNC |
RPF_SEQ |
DWR_RESRE_PRT |
RST_SEQ |
DWR_RF_CARRIER |
CAR_SEQ |
DWR_RL |
RL_SEQ |
DWR_ROOT_ENT |
RET_SEQ |
DWR_ROUTED_PROTCL |
RP_SEQ |
DWR_ROUTER |
R_SEQ |
DWR_RTL_STORE |
RS_SEQ |
DWR_RUTNG_PROTCL |
RPO_SEQ |
DWR_RUTNG_RL |
RR_SEQ |
DWR_SB_NTWK |
SNW_SEQ |
DWR_SBRP |
SUB_SEQ |
DWR_SBRP_CLASS_OF_SRVC |
SCOS_SEQ |
DWR_SBRP_PRICE |
SBPR_SEQ |
DWR_SBRP_PRICE_ALTRTN |
SBPA_SEQ |
DWR_SBRP_PRICE_CHRG |
SPCH_SEQ |
DWR_SCND |
SEC_SEQ |
DWR_SCRPT |
SCR_SEQ |
DWR_SCRPT_QUES |
IQ_SEQ |
DWR_SECURE_HLDR |
SH_SEQ |
DWR_SGMNT_CRTRA |
SC_1_SEQ |
DWR_SGNLNG_PROTCL |
SGPO_SEQ |
DWR_SHELF |
SLF_SEQ |
DWR_SIC_DIV |
SICD_SEQ |
DWR_SIM_CARD_ACCS_MTHD_ASGN |
SCAMH_SEQ |
DWR_SIM_CARD_HNDST_ASGN |
SCHH_SEQ |
DWR_SIM_CARD_SBRP_ASGN |
SCSH_SEQ |
DWR_SITE |
ST_SEQ |
DWR_SITE_INTRFC_RL |
SINR_SEQ |
DWR_SL_CHNL |
CHR_SEQ |
DWR_SL_CHNL_RPRSTV |
RSCR_SEQ |
DWR_SL_CMISN_PLN |
SCP_SEQ |
DWR_SL_CMISN_PLN_DTL |
SCPD_SEQ |
DWR_SLNG_LOC |
SL_SEQ |
DWR_SLT |
SLT1_SEQ |
DWR_SOC_JB |
SJ_SEQ |
DWR_SOC_JB_CTGRY |
SJC_SEQ |
DWR_SOC_JB_GRP |
SJG_SEQ |
DWR_SOC_JB_MJR_GRP |
SJMG_SEQ |
DWR_SOFTWARE |
SWR_SEQ |
DWR_SOFTWARE_ATMC |
SWRA_SEQ |
DWR_SOFTWARE_CMND |
SWC_SEQ |
DWR_SOFTWARE_CMPST |
SWRC_SEQ |
DWR_SOFTWARE_FTR_SETS |
SFS_SEQ |
DWR_SPECFTN |
SFN_SEQ |
DWR_SPECFTN_RL |
SFR_SEQ |
DWR_SPTRUM_COVRG_AREA |
SPCA_SEQ |
DWR_SRC_SYS |
SS_SEQ |
DWR_SRVC |
SRVC_SEQ |
DWR_SRVC_BNDL |
SRBN_SEQ |
DWR_SRVC_BNDL_SPEC |
SBS_SEQ |
DWR_SRVC_BNDL_SPEC_ATMC |
SBSA_SEQ |
DWR_SRVC_BNDL_SPEC_CMPST |
SBSC_SEQ |
DWR_SRVC_CHTRSTC |
SC_SEQ |
DWR_SRVC_CHTRSTC_ASGN |
SCHA_SEQ |
DWR_SRVC_CHTRSTC_RLTN |
SCHR_SEQ |
DWR_SRVC_CHTRSTC_VAL |
SCHV_SEQ |
DWR_SRVC_CHTRSTC_VAL_ASGN |
SCVA_SEQ |
DWR_SRVC_CHTRSTC_VAL_RLTN |
SCVR_SEQ |
DWR_SRVC_COVRG_AREA |
OTA_SEQ |
DWR_SRVC_COVRG_GEO_DTL |
SCGD_SEQ |
DWR_SRVC_LR_DPNDCY |
SRDY_SEQ |
DWR_SRVC_LVL_AGRMNT |
SLA_SEQ |
DWR_SRVC_LVL_AGRMNT_ITEM |
SLAI_SEQ |
DWR_SRVC_LVL_SPEC_PRMTR |
SRSP_SEQ |
DWR_SRVC_NTWK_ELMNT_ASGN |
SNEA_SEQ |
DWR_SRVC_PR_DPNDCY |
SPDN_SEQ |
DWR_SRVC_PKG |
SPK_SEQ |
DWR_SRVC_PRFMNC |
SPF_SEQ |
DWR_SRVC_RL |
SRL_SEQ |
DWR_SRVC_SPEC |
STYP_SEQ |
DWR_SRVC_SPEC_ATMC |
STA_SEQ |
DWR_SRVC_SPEC_CMPST |
CSTY_SEQ |
DWR_SRVC_SPEC_VRSN |
STV_SEQ |
DWR_SRVC_SPECFTN_RL |
SSRL_SEQ |
DWR_STTSTCL_ENT |
STE_SEQ |
DWR_SURVEY |
SUR_SEQ |
DWR_SWTCH |
SWH_SEQ |
DWR_SWTCH_CAPBLTY |
SC3_SEQ |
DWR_SWTCH_CMMND |
SCMD_SEQ |
DWR_SWTCH_RUTNG_DVC_ASGN |
SRDR_SEQ |
DWR_SWTCHNG_PROTCL |
SPO_SEQ |
DWR_SWTCHNG_RL |
SWHR_SEQ |
DWR_TIME_SLT |
DRTS_SEQ |
DWR_TIME_STNDRD_BY_WK |
TSBW_SEQ |
DWR_TMNT_PNT |
TMP_SEQ |
DWR_TRAIL |
TL_SEQ |
DWR_TRAIL_TMNT_PNT |
TTP_SEQ |
DWR_URBN_PRPTY_ADDR |
UPA_SEQ |
DWR_USER |
USE_SEQ |
DWR_VAL_ADD_SRVC |
VAS1_SEQ |
DWR_VAL_CSTM |
VALC_SEQ |
DWR_VAL_STNDRD |
VALS_SEQ |
DWR_VARBLE_CSTM |
VRBC_SEQ |
DWR_VARBLE_STNDRD |
VRBS_SEQ |
DWR_VNDR |
VEN_SEQ |
DWR_VNDR_CNRT |
VC_SEQ |
DWR_VNDR_FCTR_CMPNY_ASGN |
VFCA_SEQ |
DWR_VNDR_RTNG |
VR_SEQ |
DWR_VNDR_SITE |
VS2_SEQ |
DWR_VPN_LGICL_DVC_RL |
VDRL_SEQ |
DWR_WAN_PROTCL |
WP_SEQ |
DWR_WEB_PG |
WBPG_SEQ |
DWR_WK_TODATE_TRANS |
WTT_SEQ |
DWR_WK_TRANS |
WT_SEQ |
DWR_WKDAY |
TWD1_SEQ |
DWR_WRLS_NTWK_ELMNT |
NETELEM_SEQ |
DWR_WRLS_SPTRUM |
WS_SEQ |
DWR_YR_TRANS |
YT_SEQ |
Table 4-10 lists the Compressed Tables in Oracle Communications Data Model. Oracle Communications Data Model uses Database Compression on these tables to save space and load times.
Table Name |
---|
DWB_ACCS_MTHD_PORT_HIST |
DWB_ACCS_MTHD_STAT_HIST |
DWB_ACCT_ACCTNG_CYCL_HIST |
DWB_ACCT_BAL_ADJ |
DWB_ACCT_BAL_HIST |
DWB_ACCT_BLLG_OCCRNCE |
DWB_ACCT_COST |
DWB_ACCT_CRDT_LMT |
DWB_ACCT_DEBT_WRT_OFF |
DWB_ACCT_MNGMNT_HIST |
DWB_ACCT_PMP_PRTCPTN_HIST |
DWB_ACCT_PYMT |
DWB_ACCT_PYMT_MTHD_STAT |
DWB_ACCT_RCHRG |
DWB_ACCT_RFND |
DWB_ACCT_STAT_HIST |
DWB_ADDR_STAT |
DWB_APNMNT_CLNDR |
DWB_BLK_LST_HIST |
DWB_BNDLD_NTWK_EVT |
DWB_BRDBND_USG_EVT |
DWB_BSNS_INTRACN |
DWB_BSNS_INTRACN_ITEM |
DWB_BSNS_INTRACN_ITEM_PRICE |
DWB_BSNS_UNIT_COST |
DWB_CELL_SITE_COST |
DWB_CHNL_COST |
DWB_CMPGN_COST |
DWB_CMPGN_MSG_CRTVE |
DWB_CNCT_LST_COST |
DWB_CNRT_APRVL |
DWB_CNRT_STAT |
DWB_CNRT_TERM_VAL |
DWB_CNTNT_DLVRY_EVT |
DWB_COST |
DWB_COST_CNTR_BDGT |
DWB_COURIER_COST |
DWB_CRCUT_RNTL |
DWB_CRCUT_TRFC |
DWB_CRNCY_EXCHNG_RATE |
DWB_CUST_COST |
DWB_CUST_FLD_INSTLTN |
DWB_CUST_FLD_SPPRT |
DWB_CUST_FLD_SRVC_ACTVTY |
DWB_CUST_FLD_SRVC_DTL |
DWB_CUST_ORDR |
DWB_CUST_ORDR_LN_ITEM |
DWB_CUST_ORDR_LN_ITEM_ST_ASGN |
DWB_CUST_ORDR_PYMT |
DWB_CUST_ORDR_STATE_ASGN |
DWB_DATA_SRVC_EVT |
DWB_DEBT_COLLCTN |
DWB_DEBT_COLLCTN_ASGN |
DWB_DEBT_COLLCTN_ASGN_BTCH |
DWB_EMP_ACT_LBR_HRLY |
DWB_EMP_ACT_LBR_SALARIED |
DWB_EMP_COST |
DWB_EMP_TRNG_REC |
DWB_EQPMNT_CNTR_COST |
DWB_EQPMNT_INSTNC_STAT_HIST |
DWB_ERRD_MDTD_CALL_EVT |
DWB_ERRD_RAW_WRLS_CALL_EVT |
DWB_ERRD_RTD_WRLS_CALL_EVT |
DWB_EVT |
DWB_EVT_ACCS_MTHD_ACTVTY |
DWB_EVT_ACCT |
DWB_EVT_ASGN |
DWB_EVT_COST |
DWB_EVT_CRCUT_RNTL |
DWB_EVT_EMIT_DTL |
DWB_EVT_EMP_PYRL |
DWB_EVT_EQPMNT_INSTNC |
DWB_EVT_FINCL |
DWB_EVT_GEO |
DWB_EVT_GFT_RDMPTN |
DWB_EVT_INVC_DLVRY |
DWB_EVT_LYLTY_PROG |
DWB_EVT_LYLTY_PROG_ACMLTN |
DWB_EVT_LYLTY_PROG_RDMPTN |
DWB_EVT_PROD_PKG |
DWB_EVT_PRPD_MBL |
DWB_EVT_PRTY_ASGN |
DWB_EVT_PRTY_INTRACN |
DWB_EVT_PRTY_INTRACN_CALL |
DWB_EVT_PRTY_INTRACN_EML |
DWB_EVT_PRTY_INTRACN_LTTR |
DWB_EVT_PRTY_INTRACN_VST |
DWB_EVT_PRTY_PRFL |
DWB_EVT_SBRP |
DWB_EVT_SBRP_CHNG |
DWB_EVT_SIM_CARD |
DWB_EVT_STAT |
DWB_EVT_TRGR_DTL |
DWB_EVT_WEB_RGSTRN |
DWB_EVT_WEB_VST |
DWB_FIXED_LN_CALL_EVT |
DWB_IDD_CALL_EVT |
DWB_INTRACN_ANSWR_CHOICE |
DWB_INTRACN_QUES_RESPN |
DWB_INTRNT_ACCS_EVT |
DWB_INVC |
DWB_INVC_ADJ |
DWB_INVC_DISC |
DWB_INVC_ITEM |
DWB_INVC_ITEM_DTL |
DWB_INVC_ITEM_RLTN |
DWB_INVC_PYMT_ASGN |
DWB_ISP_USG_EVT |
DWB_LYLTY_PROG_PTS_BAL |
DWB_MDTD_CALL_EVT |
DWB_MEDIA_OBJ_COST |
DWB_MKT_PLN_MGMT |
DWB_MMS_EVT |
DWB_MNT_ALLWNC |
DWB_NP_RQST_HDR |
DWB_NP_RQST_LN_ITEM |
DWB_NP_RQST_LN_ITEM_STATE_HIST |
DWB_NP_RQST_STATE_HIST |
DWB_NTWK_ELMNT_COST |
DWB_NTWK_EVT |
DWB_NTWK_EVT_ASGN |
DWB_NTWK_FLT |
DWB_PLCY_EVT |
DWB_PLCY_EVT_ATMC |
DWB_PLCY_EVT_CMPST |
DWB_PRICE_EVT |
DWB_PRMTN_CLSTR_USG |
DWB_PRMTN_CNCT_LST_UTLZTN |
DWB_PRMTN_COST |
DWB_PRMTN_MGMT_HIST |
DWB_PRMTN_TERM_VAL |
DWB_PROD_COST |
DWB_PROD_MGMT_HIST |
DWB_PROD_MKT_PLN_COST |
DWB_PROD_STAT_HIST |
DWB_PRPD_RCHRG |
DWB_PRTY_AM_PMP_ASGN_HIST |
DWB_PRTY_AM_PMP_ASGN_STAT |
DWB_PRTY_COST_ASGN |
DWB_PRTY_INTRACN_THRD |
DWB_PRTY_ORDR_ASGN |
DWB_PRTY_PRMTN_RESPN |
DWB_PRTY_STAT_HIST |
DWB_PTV_FULL_CHNL_ACTVTN |
DWB_PTV_QPI_SRVC_EVT |
DWB_PTV_USG_EVT |
DWB_RAW_MMS_EVT |
DWB_RAW_WRLS_CALL_EVT |
DWB_RESRE_ORDR |
DWB_RESRE_ORDR_ITEM |
DWB_RTD_NTWK_EVT |
DWB_SBRP_STAT_HIST |
DWB_SBRP_TERM_VAL |
DWB_SL_CMISN_DTL |
DWB_SL_CMISN_PYRL |
DWB_SMS_EVT |
DWB_SRVC_ORDR |
DWB_SRVC_ORDR_LN_ITEM |
DWB_SRVC_RQST |
DWB_TAP_IN_WRLS_RMNG_EVT |
DWB_TAP_OUT_WRLS_RMNG_EVT |
DWB_UMS_EVT |
DWB_VNDR_APNMNT |
DWB_VOIP_CALL_EVT |
DWB_WRLS_CALL_EVT |
DWB_WRLS_CNTNT_DNLDG_EVT |
DWB_WRLS_RMNG_EVT |
DWB_WRLS_RMNG_EVT_BTCH |
DWD_ACCT_DEBT_DAY |
DWD_ACCT_PYMT_DAY |
DWD_ACCT_PYMT_MTHD_STAT_HIST |
DWD_ACCT_RFND_DAY |
DWD_ACCT_STAT |
DWD_ACCT_STTSTC |
DWD_ARPU_BASE |
DWD_BER_FER_ERR_RATIO_DAY |
DWD_CALL_CNTR_CALL_DAY |
DWD_CALL_CNTR_CASE_DAY |
DWD_CANBLZTN_DTL_DAY |
DWD_CELL_STTSTC_DAY |
DWD_CHRN_PRDCT_SRC |
DWD_CMISN_DAY |
DWD_CNCT_DSCNCT_DAY |
DWD_CNRT |
DWD_CNRT_CHNG |
DWD_COST_CUST |
DWD_COST_ORG |
DWD_CRDT_CTGRY |
DWD_CUST_ACQSTN_SUMM_DAY |
DWD_CUST_DEBT_COLLCTN |
DWD_CUST_EQPMNT_INSTLTN_DAY |
DWD_DATA_USG_DAY |
DWD_EXTRNL_DEBT_COLLCTN_DAY |
DWD_GIVE_AWAY_ITEM_DAY |
DWD_GPRS_PCU_DAY |
DWD_GPRS_SRVCS_DAY |
DWD_HNDST_STCK_DAY |
DWD_HNDST_SUBSDY_DAY |
DWD_INTRNL_DEBT_COLLCTN_DAY |
DWD_INVC |
DWD_INVC_ADJ |
DWD_IN_PLTFRM_DAY |
DWD_LN_ACTVTN_TMNT_DAY |
DWD_LYLTY_PROG_DAY |
DWD_MKT_OPRTR_PRTNG |
DWD_MKT_SHARE |
DWD_MSC_TRFC_DAY |
DWD_NBR_PRT_DAY |
DWD_NTWK_AVLBLTY_DAY |
DWD_NTWK_TCHPNT |
DWD_PRPD_ACCT_STTSTC |
DWD_PRPD_ALWNCE_DAY |
DWD_PRPD_CALL_SUMM_DAY |
DWD_PRTNR_STLMNT |
DWD_PYMT_AGNG_DAY |
DWD_RDMPTN_DAY |
DWD_RF_NTWK_CPCTY_DAY |
DWD_SBCRBR_CHRN_STTSTC |
DWD_SHARED_PKG_USG_STTSTC_DAY |
DWD_SHOP_EFFNCY_DAY |
DWD_SL_CMPGN_SUMM_DAY |
DWD_SL_DAY |
DWD_SL_RPRSTV_STTSTC |
DWD_SPLMNTR_SRVC_USG |
DWD_SUBSDY_AMT |
DWD_VAS_SBRP_QCK_SUMM |
DWD_VAS_USG_DAY |
DWD_VOI_CALL_DAY |
Table 4-11 lists the Partition Tables, Partition Column, Partition Level and Partition Table space for Partition definitions in Oracle Communications Data Model.
Table 4-11 Partition Definitions
Table Name | Partition Column | Partition Level | Partition Table space |
---|---|---|---|
DWA_ACCT_DEBT_MO |
DT |
QTY |
TBS_MV |
DWA_ACCT_PYMT_MO |
DT |
QTY |
TBS_MV |
DWA_ACCT_PYMT_MTHD_STAT_HIST |
DT |
QTY |
TBS_MV |
DWA_ACCT_RFND_MO |
DT |
QTY |
TBS_MV |
DWA_ACCT_STAT_TYP |
DT |
QTY |
TBS_MV |
DWA_ACCT_STTSTC_TYP |
DT |
QTY |
TBS_MV |
DWA_ARPU_BASE_CUST_TYP |
DT |
QTY |
TBS_MV |
DWA_BER_FER_ERR_RATIO_MO |
DT |
QTY |
TBS_MV |
DWA_CALL_CNTR_CALL_MO |
DT |
QTY |
TBS_MV |
DWA_CALL_CNTR_CASE_MO |
DT |
QTY |
TBS_MV |
DWA_CANBLZTN_DTL_MO |
DT |
QTY |
TBS_MV |
DWA_CELL_STTSTC_MO |
DT |
QTY |
TBS_MV |
DWA_CMISN_MO |
DT |
QTY |
TBS_MV |
DWA_CNCT_DSCNCT_MO |
DT |
QTY |
TBS_MV |
DWA_CNRT_MO |
DT |
QTY |
TBS_MV |
DWA_COST_CUST_MO |
DT |
QTY |
TBS_MV |
DWA_COST_ORG_MO |
DT |
QTY |
TBS_MV |
DWA_CRDT_CTGRY_MO |
DT |
QTY |
TBS_MV |
DWA_CUST_ACQSTN_SUMM_MO |
DT |
QTY |
TBS_MV |
DWA_CUST_DEBT_COLLCTN_MO |
DT |
QTY |
TBS_MV |
DWA_CUST_EQPMNT_INSTLTN_MO |
DT |
QTY |
TBS_MV |
DWA_DATA_USG_MO |
DT |
QTY |
TBS_MV |
DWA_EXTRNL_DEBT_COLLCTN_MO |
DT |
QTY |
TBS_MV |
DWA_GIVE_AWAY_ITEM_MO |
DT |
QTY |
TBS_MV |
DWA_GPRS_PCU_MO |
DT |
QTY |
TBS_MV |
DWA_GPRS_SRVCS_MO |
DT |
QTY |
TBS_MV |
DWA_HNDST_STCK_MO |
DT |
QTY |
TBS_MV |
DWA_HNDST_SUBSDY_MO |
DT |
QTY |
TBS_MV |
DWA_INTRNL_DEBT_COLLCTN_MO |
DT |
QTY |
TBS_MV |
DWA_INVC_ADJ_MO |
DT |
QTY |
TBS_MV |
DWA_INVC_CUST_TYP |
DT |
QTY |
TBS_MV |
DWA_IN_PLTFRM_MO |
DT |
QTY |
TBS_MV |
DWA_LN_ACTVTN_TMNT_MO |
DT |
QTY |
TBS_MV |
DWA_LYLTY_PROG_MO |
DT |
QTY |
TBS_MV |
DWA_MKT_SHARE |
DT |
QTY |
TBS_MV |
DWA_MSC_TRFC_MO |
DT |
QTY |
TBS_MV |
DWA_NBR_PRT_MO |
DT |
QTY |
TBS_MV |
DWA_NTWK_AVLBLTY_MO |
DT |
QTY |
TBS_MV |
DWA_NTWK_TCHPNT_MO |
DT |
QTY |
TBS_MV |
DWA_PRPD_ACCT_STTSTC_SGMNT |
DT |
QTY |
TBS_MV |
DWA_PRPD_ALWNCE_MO |
DT |
QTY |
TBS_MV |
DWA_PRPD_CALL_SUMM_MO |
DT |
QTY |
TBS_MV |
DWA_PRTNR_STLMNT_MO |
DT |
QTY |
TBS_MV |
DWA_PYMT_AGNG_MO |
DT |
QTY |
TBS_MV |
DWA_RDMPTN_MO |
DT |
QTY |
TBS_MV |
DWA_RF_NTWK_CPCTY_MO |
DT |
QTY |
TBS_MV |
DWA_SBCRBR_CHRN_STTSTC_MO |
DT |
QTY |
TBS_MV |
DWA_SHARED_PKG_USG_STTSTC_MO |
DT |
QTY |
TBS_MV |
DWA_SHOP_EFFNCY_MO |
DT |
QTY |
TBS_MV |
DWA_SL_CMPGN_SUMM_MO |
DT |
QTY |
TBS_MV |
DWA_SL_MO |
DT |
QTY |
TBS_MV |
DWA_SPLMNTR_SRVC_USG_MO |
DT |
QTY |
TBS_MV |
DWA_SUBSDY_AMT_MO |
DT |
QTY |
TBS_MV |
DWA_VAS_SBRP_QCK_SUMM_MO |
DT |
QTY |
TBS_MV |
DWA_VAS_USG_MO |
DT |
QTY |
TBS_MV |
DWA_VOI_CALL_MO |
DT |
QTY |
TBS_MV |
DWB_ACCS_MTHD_PORT_HIST |
ACT_CTVR_DT |
QTR |
TBS_BASE |
DWB_ACCS_MTHD_STAT_HIST |
EFF_FROM_DT |
QTR |
TBS_BASE |
DWB_ACCT_BAL_HIST |
BAL_DT |
MONTH |
TBS_BASE |
DWB_ACCT_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_ACCT_CRDT_LMT |
CRDT_RTNG_DT |
MONTH |
TBS_BASE |
DWB_ACCT_MNGMNT_HIST |
ASGN_STRT_DT |
MONTH |
TBS_BASE |
DWB_ACCT_PMP_PRTCPTN_HIST |
RLTN_STRT_DT |
MONTH |
TBS_BASE |
DWB_ACCT_PYMT |
PYMT_DT |
MONTH |
TBS_BASE |
DWB_ACCT_PYMT_MTHD_STAT |
EFF_FROM_DT |
MONTH |
TBS_BASE |
DWB_ACCT_RFND |
PYMT_DT |
MONTH |
TBS_BASE |
DWB_ACCT_STAT_HIST |
EFF_FROM_DT |
MONTH |
TBS_BASE |
DWB_APNMNT_CLNDR |
DAY_KEY |
DAY |
TBS_BASE |
DWB_BLK_LST_HIST |
EFF_FROM_DT |
MONTH |
TBS_BASE |
DWB_BRDBND_USG_EVT |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
DWB_BSNS_UNIT_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_CELL_SITE_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_CHNL_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_CMPGN_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_CMPGN_MSG_CRTVE |
CRTN_DT |
MONTH |
TBS_BASE |
DWB_CNCT_LST_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_CNRT_APRVL |
CNRT_APRVL_DT |
MONTH |
TBS_BASE |
DWB_CNRT_STAT |
EFF_FROM_DT |
MONTH |
TBS_BASE |
DWB_CNRT_TERM_VAL |
TERM_PRD_STRT_DT |
MONTH |
TBS_BASE |
DWB_CNTNT_DLVRY_EVT |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
DWB_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_COST_CNTR_BDGT |
EFF_FROM_DT |
MONTH |
TBS_BASE |
DWB_CRCUT_RNTL |
EFF_FROM_DT |
MONTH |
TBS_BASE |
DWB_CRCUT_TRFC |
EFF_STRT_DT |
MONTH |
TBS_BASE |
DWB_CUST_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_CUST_FLD_INSTLTN |
FLD_ACTVTY_STRT_DT |
MONTH |
TBS_BASE |
DWB_CUST_FLD_SPPRT |
FLD_ACTVTY_STRT_DT |
MONTH |
TBS_BASE |
DWB_CUST_FLD_SRVC_ACTVTY |
FLD_ACTVTY_STRT_DT |
MONTH |
TBS_BASE |
DWB_CUST_FLD_SRVC_DTL |
ACTN_DT |
MONTH |
TBS_BASE |
DWB_CUST_ORDR |
ORGNL_ORDR_DT |
MONTH |
TBS_BASE |
DWB_CUST_ORDR_LN_ITEM |
ORGNL_ORDR_DT |
MONTH |
TBS_BASE |
DWB_CUST_ORDR_LN_ITEM_ST_ASGN |
ORDR_LN_ITEM_STATE_BEGIN_DT |
MONTH |
TBS_BASE |
DWB_CUST_ORDR_PYMT |
PYMT_DT |
MONTH |
TBS_BASE |
DWB_CUST_ORDR_STATE_ASGN |
ORDR_STATE_BEGIN_DT |
MONTH |
TBS_BASE |
DWB_DATA_SRVC_EVT |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
DWB_DEBT_COLLCTN |
INTRACN_THRD_STRT_DT |
MONTH |
TBS_BASE |
DWB_DEBT_COLLCTN_ASGN |
ASGN_DT |
MONTH |
TBS_BASE |
DWB_DEBT_COLLCTN_ASGN_BTCH |
ASGN_DT |
MONTH |
TBS_BASE |
DWB_EMP_ACT_LBR_HRLY |
DAY_KEY |
DAY |
TBS_BASE |
DWB_EMP_ACT_LBR_SALARIED |
DAY_KEY |
DAY |
TBS_BASE |
DWB_EMP_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_EMP_TRNG_REC |
TRNG_STRT_DT |
MONTH |
TBS_BASE |
DWB_EQPMNT_CNTR_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_EQPMNT_INSTNC_STAT_HIST |
EFF_BEGIN_DT |
MONTH |
TBS_BASE |
DWB_EVT |
STRT_DT |
DAY |
TBS_BASE |
DWB_EVT_ACCS_MTHD_ACTVTY |
STRT_DT |
DAY |
TBS_BASE |
DWB_EVT_ACCT |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_ASGN |
EFF_FROM_DT |
DAY |
TBS_BASE |
DWB_EVT_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_EVT_CRCUT_RNTL |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_EMP_PYRL |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_EQPMNT_INSTNC |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_FINCL |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_GEO |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_GFT_RDMPTN |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_INVC_DLVRY |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_LYLTY_PROG |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_LYLTY_PROG_ACMLTN |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_LYLTY_PROG_RDMPTN |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_PROD_PKG |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_PRPD_MBL |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_PRTY_ASGN |
EFF_DT |
DAY |
TBS_BASE |
DWB_EVT_PRTY_INTRACN |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_PRTY_INTRACN_CALL |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_PRTY_INTRACN_EML |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_PRTY_INTRACN_LTTR |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_PRTY_INTRACN_VST |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_PRTY_PRFL |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_SBRP |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_SBRP_CHNG |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_SIM_CARD |
STRT_DT |
MONTH |
TBS_BASE |
DWB_EVT_STAT |
EFF_FROM_DT |
DAY |
TBS_BASE |
DWB_EVT_WEB_RGSTRN |
STRT_DT |
MONTH |
TBS_BASE |
DWB_FIXED_LN_CALL_EVT |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
DWB_IDD_CALL_EVT |
EVT_BEGIN_DT |
MONTH |
TBS_BASE |
DWB_INTRNT_ACCS_EVT |
EVT_BEGIN_DT |
MONTH |
TBS_BASE |
DWB_INVC |
BLLG_DT |
MONTH |
TBS_BASE |
DWB_INVC_ADJ |
STRT_DT |
MONTH |
TBS_BASE |
DWB_INVC_DISC |
BLLG_DT |
MONTH |
TBS_BASE |
DWB_INVC_ITEM |
BLLG_DT |
MONTH |
TBS_BASE |
DWB_INVC_ITEM_DTL |
BLLG_DT |
MONTH |
TBS_BASE |
DWB_INVC_PYMT_ASGN |
EFF_FROM_DT |
MONTH |
TBS_BASE |
DWB_ISP_USG_EVT |
EVT_BEGIN_DT |
MONTH |
TBS_BASE |
DWB_LYLTY_PROG_PTS_BAL |
EFF_FROM_DT |
MONTH |
TBS_BASE |
DWB_MDTD_CALL_EVT |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
DWB_MEDIA_OBJ_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_MKT_PLN_MGMT |
MNG_ACTN_DT |
MONTH |
TBS_BASE |
DWB_MMS_EVT |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
DWB_MNT_ALLWNC |
BAL_DT |
MONTH |
TBS_BASE |
DWB_NP_RQST_HDR |
APLCTN_DT |
MONTH |
TBS_BASE |
DWB_NP_RQST_LN_ITEM |
NP_STEP_STRT_DT |
MONTH |
TBS_BASE |
DWB_NP_RQST_LN_ITEM_STATE_HIST |
EFF_FROM_DT |
MONTH |
TBS_BASE |
DWB_NP_RQST_STATE_HIST |
EFF_FROM_DT |
MONTH |
TBS_BASE |
DWB_NTWK_ELMNT_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_NTWK_EVT |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
DWB_NTWK_FLT |
OPEN_DT |
MONTH |
TBS_BASE |
DWB_PRMTN_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_PRMTN_MGMT_HIST |
EFF_FROM_DT |
MONTH |
TBS_BASE |
DWB_PRMTN_TERM_VAL |
TERM_PRD_STRT |
MONTH |
TBS_BASE |
DWB_PROD_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_PROD_MKT_PLN_COST |
INCURR_DT |
MONTH |
TBS_BASE |
DWB_PRPD_RCHRG |
PYMT_DT |
MONTH |
TBS_BASE |
DWB_PRTY_AM_PMP_ASGN_HIST |
ASGN_BEGIN_DT |
MONTH |
TBS_BASE |
DWB_PRTY_AM_PMP_ASGN_STAT |
ASGN_BEGIN_DT |
MONTH |
TBS_BASE |
DWB_PRTY_INTRACN_THRD |
INTRACN_THRD_STRT_DT |
MONTH |
TBS_BASE |
DWB_PRTY_ORDR_ASGN |
EFF_FROM_DT |
MONTH |
TBS_BASE |
DWB_PRTY_PRMTN_RESPN |
RESPN_DT |
MONTH |
TBS_BASE |
DWB_PRTY_STAT_HIST |
EFF_FROM_DT |
MONTH |
TBS_BASE |
DWB_PTV_FULL_CHNL_ACTVTN |
EVT_BEGIN_DT |
MONTH |
TBS_BASE |
DWB_PTV_QPI_SRVC_EVT |
EVT_BEGIN_DT |
MONTH |
TBS_BASE |
DWB_PTV_USG_EVT |
EVT_BEGIN_DT |
MONTH |
TBS_BASE |
DWB_SBRP_STAT_HIST |
EFF_FROM_DT |
MONTH |
TBS_BASE |
DWB_SBRP_TERM_VAL |
TERM_PRD_STRT_DT |
MONTH |
TBS_BASE |
DWB_SL_CMISN_DTL |
PYMT_DT |
MONTH |
TBS_BASE |
DWB_SL_CMISN_PYRL |
PAY_DT |
MONTH |
TBS_BASE |
DWB_SMS_EVT |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
DWB_SRVC_RQST |
INTRACN_THRD_STRT_DT |
MONTH |
TBS_BASE |
DWB_UMS_EVT |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
DWB_VNDR_APNMNT |
VNDR_APNMNT_DT |
MONTH |
TBS_BASE |
DWB_VOIP_CALL_EVT |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
DWB_WRLS_CALL_EVT |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
DWB_WRLS_CNTNT_DNLDG_EVT |
EVT_BEGIN_DT |
MONTH |
TBS_BASE |
DWD_ACCT_DEBT_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_ACCT_PYMT_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_ACCT_PYMT_MTHD_STAT_HIST |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_ACCT_RFND_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_ACCT_STAT |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_ACCT_STTSTC |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_ARPU_BASE |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_BER_FER_ERR_RATIO_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_CALL_CNTR_CALL_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_CALL_CNTR_CASE_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_CANBLZTN_DTL_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_CELL_STTSTC_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_CHRN_PRDCT_SRC |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_CMISN_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_CNCT_DSCNCT_DAY |
DAY_KEY |
DAY |
TBS_DERIVED |
DWD_CNRT |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_CNRT_CHNG |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_COST_CUST |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_COST_ORG |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_CRDT_CTGRY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_CUST_ACQSTN_SUMM_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_CUST_DEBT_COLLCTN |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_CUST_EQPMNT_INSTLTN_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_DATA_USG_DAY |
DAY_KEY |
DAY |
TBS_DERIVED |
DWD_EXTRNL_DEBT_COLLCTN_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_GIVE_AWAY_ITEM_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_GPRS_PCU_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_GPRS_SRVCS_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_HNDST_STCK_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_HNDST_SUBSDY_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_INTRNL_DEBT_COLLCTN_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_INVC |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_INVC_ADJ |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_IN_PLTFRM_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_LN_ACTVTN_TMNT_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_LYLTY_PROG_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_MKT_OPRTR_PRTNG |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_MKT_SHARE |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_MSC_TRFC_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_NBR_PRT_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_NTWK_AVLBLTY_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_NTWK_TCHPNT |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_PRPD_ACCT_STTSTC |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_PRPD_ALWNCE_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_PRPD_CALL_SUMM_DAY |
DAY_KEY |
DAY |
TBS_DERIVED |
DWD_PRTNR_STLMNT |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_PYMT_AGNG_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_RDMPTN_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_RF_NTWK_CPCTY_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_SBCRBR_CHRN_STTSTC |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_SHARED_PKG_USG_STTSTC_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_SHOP_EFFNCY_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_SL_CMPGN_SUMM_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_SL_DAY |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_SL_RPRSTV_STTSTC |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_SPLMNTR_SRVC_USG |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_SUBSDY_AMT |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_VAS_SBRP_QCK_SUMM |
MO_KEY |
MONTH |
TBS_DERIVED |
DWD_VAS_USG_DAY |
DAY_KEY |
DAY |
TBS_DERIVED |
DWD_VOI_CALL_DAY |
DAY_KEY |
DAY |
TBS_DERIVED |
Table 4-12 shows the cube materialized views in ocdm_sys
schema.
Table 4-12 OLAP Cube Materialized Views in ocdm_sys Schema
Cube Materialized View Name | OLAP Object Name | OLAP Object Type | More Information |
---|---|---|---|
|
|
Cube |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
Table 4-13 shows the OLAP cube views in ocdm_sys
schema.
Table 4-13 OLAP Cube Views in ocdm_sys schema
Cube View Name | OLAP Object Name | OLAP Object Type | More Information |
---|---|---|---|
|
|
Cube |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Cube |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Hierarchy |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |