4 Oracle Communications Data Model Physical Data Model

This chapter provides information about the physical data model of Oracle Communications Data Model.

This chapter includes the following sections:

Introduction to Oracle Communications Data Model Physical Data Model
Reference Tables
Lookup Tables
Base Tables
Derived Tables
Aggregate Tables
Temporary and Other Tables
Database Sequences
Compressed Tables
Oracle Communications Data Model OLAP Cube MV, Cube View

Introduction to Oracle Communications Data Model Physical Data Model

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:

Reference Tables
Lookup Tables
Base Tables
Derived Tables
Aggregate Tables
Database Sequences

Important:

Do not make changes to the schemas as such changes are not supported.

Oracle Communications Data Model provides the following types of tables:

Reference tables contain information that is usually used as dimensions. They usually do not change often (or at all). Typically, Reference tables are PARTY, CUSTOMER, ADDRESS LOCATION, ACCOUNT, SUBSCRIPTION, and so on
Lookup tables in the foundation layer are added to save the definition of short codes used in other tables.
Base tables store information about any type of transactions (Calls Data Records or CDRs, Invoices, Payments, Business Interactions, and so on). They are usually transformed into facts.
Derived Tables in the analytic layer are usually transition tables to STARs. They are also leveraged for the Mining models.
Aggregate Tables, or materialized views, are the STAR schema themselves at a higher level of aggregation. They may be related to the OLAP cubes.

For more information on Oracle Communications Data Model table types, see "Oracle Communications Data Model Concepts".

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-1 Table Name Prefix Conventions

Prefix	Description
DWA_	Aggregate table
DWB_	Base transaction table
DWD_	Derived table (Mining included)
DWL_	Lookup table
DWR_	Reference data table

Reference Tables

Table 4-2 briefly describes the Reference tables in Oracle Communications Data Model.

Table 4-2 Reference Tables

Table Name	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_ACCS_MTHD_SRVC_ASGN	ACCESS METHOD SERVICE ASSIGNMENT
DWR_ACCSRS	ACCESSORIES
DWR_ACCT	ACCOUNT
DWR_ACCT_ASGN	ACCOUNT ASSIGNMENT
DWR_ACCT_BAL_GRP	ACCOUNT BALANCE GROUP
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_ASSET	ASSET
DWR_ASSET_PRTY_ASSOCTN	ASSET PARTY ASSOCIATION
DWR_ASSET_SITE_ASGN	ASSET SITE ASSIGNMENT
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_RTNG_PLN	BROADBAND RATING PLAN
DWR_BRDBND_SRVC	BROADBAND SERVICE
DWR_BRDGNG_PROTCL	BRIDGING PROTOCOL
DWR_BROWSER_VRSN	BROWSER VERSION
DWR_BRND	BRAND
DWR_BSNS_ASSET	BUSINESS ASSET
DWR_BSNS_HLF_MO	BUSINESS HALF MONTH
DWR_BSNS_HLF_YR	BUSINESS HALF YEAR
DWR_BSNS_INTRACN_ASGN	BUSINESS INTERACTION ASSIGNMENT
DWR_BSNS_INTRACN_CHTRSTC	BUSINESS INTERACTION CHARACTERISTIC
DWR_BSNS_INTRACN_CHTRSTC_VAL	BUSINESS INTERACTION CHARACTERISTIC VALUE
DWR_BSNS_INTRACN_LOC_ASGN	BUSINESS INTERACTION LOCATION ASSIGNMENT
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_COMPLEX_ADDR	COMPLEX ADDRESS
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_COMMUNITY	CUSTOMER COMMUNITY
DWR_CUST_DOC	CUSTOMER DOCUMENT
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
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_LN_ITEM	DEAL LINE ITEM
DWR_DEMOG_ATRIB	DEMOGRAPHY ATTRIBUTE
DWR_DEMOG_CHTRSTC	DEMOGRAPHIC CHARACTERISTIC
DWR_DEMOG_CHTRSTC_VAL	DEMOGRAPHIC CHARACTERISTIC VALUE
DWR_DEMOG_GRP	DEMOGRAPHY ATTRIBUTE
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_EML_SRVC	EMAIL SERVICE
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_RNTNG_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_FDA	FDA
DWR_FIXED_LN_PRT	FIXED LINE PORT
DWR_FIXED_LN_RTNG_PLN	FIXED LINE RATING PLAN
DWR_FIXED_LN_SRVC	FIXED LINE SERVICE
DWR_FRWL_RL	FIREWALL ROLE
DWR_FSAM	FSAM
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_COMPLEX	GEOGRAPHY COMPLEX
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_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_ACCT	GL ACCOUNT
DWR_GL_ACCT_ASGN	GL ACCOUNT ASSIGNMENT
DWR_GL_ACCT_SGMNT	GL ACCOUNT SEGMENT
DWR_GL_COST_CNTR_SGMNT	GL COST CENTER SEGMENT
DWR_GL_LDGR	GL LEDGER
DWR_GL_LDGR_ACCT_ASGN	GL LEDGER ACCOUNT ASSIGNMENT
DWR_GL_ORG_BSNS_UNIT_SGMNT	GL ORG BSNS UNIT SEGMENT
DWR_GL_PRD	GL PERIOD
DWR_GL_PROD_SGMNT	GL PRODUCT SEGMENT
DWR_GL_PROJ_SGMNT	GL PROJECT SEGMENT
DWR_GL_REF	GL REFERENCE
DWR_GL_SBLDGR	GL SUBLEDGER
DWR_GL_SGMNT	GL SEGMENT
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_HM_SBCRBR_SERVER	HOME SUBSCRIBER SERVER
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_INTRACN_NAVGTN_ASGN	INTERACTION NAVIGATION ASSIGNMENT
DWR_INTRACN_NAVGTN_ITEM	INTERACTION NAVIGATION ITEM
DWR_INTRACN_NAVGTN_TYP_VRSN	INTERACTION NAVIGATNION TYPE VERSION
DWR_INVC_ADJ_QTA	INVOICE ADJUSTMENT QUOTA
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_LAND_PARCEL_ADDR	LAND PARCEL ADDRESS
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_SRVC	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_CPCTY	NETWORK CAPACITY
DWR_NTWK_DOMAIN	NETWORK DOMAIN
DWR_NTWK_DOMAIN_ASGN	NETWORK DOMAIN ASSIGNMENT
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_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_ORACLE_GEOMETRY	ORACLE GEOMETRY
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_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_PIT_CHTRSTC	PIT CHARACTERISTIC
DWR_PIT_CHTRSTC_VAL	PIT CHARACTERISTIC VALUE
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_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_CTGRY	PERFORMANCE CATEGORY
DWR_PRFMNC_CTGRY_RLTN	PERFORMANCE CATEGORY RELATIONSHIP
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_NTFCTN_SPECFTN	PERFORMANCE NOTIFICATION SPECIFICATION
DWR_PRFMNC_OBJCTV	PERFORMANCE OBJECTIVE
DWR_PRFMNC_OBJCTV_APLBLETY	PERFORMANCE OBJECTIVE APPLICABILITY
DWR_PRFMNC_OBJ_APLBLETY_CNSEQ	PERFORMANCE OBJECTIVE APPLICABILITY CONSEQUENCE
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_PROJ	PROJECT
DWR_PROJ_ELMNT	PROJECT ELEMENT
DWR_PROPOSAL	PROPOSAL
DWR_PROPOSAL_RLTN	PROPOSAL RELATIONSHIP
DWR_PROTCL	PROTOCOL
DWR_PRPD_VCHR_BTCH	PREPAID VOUCHER BATCH
DWR_PRPD_VCHR_INSTNC	PREPAID VOUCHER INSTANCE
DWR_PRPD_VCHR_RCHRG_OPTN	PREPAID VOUCHER RECHARGE OPTION
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_PYTV_SRVC	PAY TV
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 SPECROLE
DWR_RESRE_FCNG_SRVC_SPEC_VRSN	RESOURCE FACING SERVICE SPEC VERSION
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_ASGN	SUBSCRIPTION SERVICE 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_SRVC	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_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_STTSTCL_ENT	STATISTICAL ENTITY
DWR_SURVEY	SURVEY
DWR_SVCSPEC_NTWK_ELETYP_RLTN	SERVICE SPEC NETWORK ELEMENT TYPE RELATIONSHIP
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_TASK	TASK
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_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_VHCL	VEHICLE
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_VPN_SRVC	VPN SERVICE
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_SRVC	WIRLESS SERVICE
DWR_WRLS_SPTRUM	WIRELESS SPECTRUM
DWR_YR_TRANS	YEAR TRANSFORMATION

Lookup Tables

Table 4-3 briefly describes the Lookup tables in Oracle Communications Data Model.

Table 4-3 Lookup Tables

Table Name	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_RL_TYP	ACCOUNT ROLE TYPE
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_ASSET_TYP	ASSET TYPE
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_RSN	BILLING STATUS REASON
DWL_BLLG_STAT_TYP	BILLING STATUS TYPE
DWL_BROWSER_TYP	BROWSER TYPE
DWL_BSNS_INTRACN_ASGN_TYP	BUSINESS INTERACTION ASSIGNMENT TYPE
DWL_BSNS_INTRACN_CHTRSTC_TYP	BUSINESS INTERACTION CHARACTERISTIC TYPE
DWL_BSNS_INTRACN_STAT_RSN	BUSINESS INTERACTION STATUS REASON
DWL_BSNS_INTRACN_STAT_TYP	BUSINESS INTERACTION STATUS 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_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_EXP_RPT_STATE_TYP	EXPENSE REPORT STATE TYPE
DWL_EXP_TYP	EXPENSE 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_GL_ACCT_TYP	GL ACCOUNT TYPE
DWL_GL_JE_CTGRY	GL JOURNAL ENTRY CATEGORY
DWL_GL_SGMNT_TYP	GL SEGMENT TYPE
DWL_GNDR	GENDER
DWL_INTRACN_DRCTN	INTERACTION DIRECTION
DWL_INTRACN_NAVGTN_ITEM_TYP	INTERACTION NAVIGATION ITEM TYPE
DWL_INTRACN_NAVGTN_LVL	INTERACTION NAVIGATION LEVEL
DWL_INTRACN_NAVGTN_TYP	INTERACTION NAVIGATION TYPE
DWL_INTRACN_PRIORITY_TYP	INTERACTION PRIORITY TYPE
DWL_INTRACN_RSLT_TYP	INTERACTION RESULT TYPE
DWL_INTRACN_RSN	INTERACTION REASON
DWL_INTRACN_STAT	INTERACTION STATUS
DWL_INTRACN_TRNSFR_RSN	INTERACTION TRANSFER REASON
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_STAT_TYP	INVOICE STATUS TYPE
DWL_INVC_TYP	INVOICE TYPE
DWL_ISP_BSNS_TYP	ISP BUSINESS TYPE
DWL_ISP_TYP	ISP TYPE
DWL_ITEM_TYP	ITEM TYPE
DWL_IVR_MENU_ITEM	IVR MENU ITEM
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_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_STATE_RSN	NETWORK ELEMENT STATE REASON
DWL_NTWK_ELMNT_STATE_TYP	NETWORK ELEMENT STATE 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_FLT_PRIORITY_TYP	NETWORK FAULT PRIORITY 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_PCHSE_ORDR_STATE_TYP	PURCHASE ORDER STATE 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_PIT_CHTRSTC_TYP	PIT CHARACTERISTIC TYPE
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_BRND	PRODUCT BRAND
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_COVRG_AREA_TYP	PRODUCT COVERAGE AREA 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_INSTNC_STAT_TYP	PRODUCT INSTANCE STATUS 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_PYMT_TYP	PARTNER PAYMENT TYPE
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_RATABLE_UNIT_MEASUREMENT	RATABLE UNIT MEASUREMENT
DWL_RDMPTN_TYP	REDEMPTION TYPE
DWL_RECHRG_RVN_SLB	RECHARGE REVENUE SLAB
DWL_RELGN	RELIGION
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_CTGRY	SERVICE CATEGORY
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_STAT	SERVICE STATUS
DWL_SRVC_STAT_CTGRY	SERVICE STATUS CATEGORY
DWL_SRVC_STAT_RSN	SERVICE STATUS REASON
DWL_SRVC_TYP	SERVICE TYPE
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_RNDRNG_TYP	WEB PAGE RENDERING TYPE
DWL_WEB_PG_TYP	WEB PAGE TYPE

Base Tables

Table 4-4 briefly describes the Base tables in Oracle Communications Data Model.

Table 4-4 Base Tables

Table Name	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_BUCKET	ACCOUNT BALANCE BUCKET
DWB_ACCT_BAL_HIST	ACCOUNT BALANCE HISTORY
DWB_ACCT_BAL_IMPC	ACCOUNT BALANCE IMPACT
DWB_ACCT_BAL_TRNSFR	ACCOUNT BALANCE TRANSFER
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_BAL_IMPC	ACCOUNT PAYMENT BALANCE IMPACT
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	APPOINTMENT
DWB_APNMNT_CLNDR	APPOINTMENT CALENDAR
DWB_ASSET_APPRSL_HIST	ASSET APPRAISAL HISTORY
DWB_ASSET_CNDTN_HIST	ASSET CONDITION HISTORY
DWB_ASSET_DEPRCN_HIST	ASSET DEPRECIATION HISTORY
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_INTRACN_PYMT_ASGN	BUSINESS INTERACTION PAYMENT ASSIGNMENT
DWB_BSNS_INTRACN_RL	BUSINESS INTERACTION ROLE
DWB_BSNS_INTRACN_STAT_HIST	BUSINESS INTERACTION STATUS HISTORY
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_EXP_RPT	EMPLOYEE EXPENSE REPORT
DWB_EMP_EXP_RPT_ITEM	EMPLOYEE EXPENSE REPORT ITEM
DWB_EMP_EXP_RPT_STATE	EMPLOYEE EXPENSE REPORT STATE
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_CHAT	EVENT CHAT
DWB_EVT_CHAT_DTL	EVENT CHAT DETAIL
DWB_EVT_CNRT	EVENT CONTRACT
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_ITEM	EVENT PARTY INTERACTION ITEM
DWB_EVT_PRTY_INTRACN_LTTR	EVENT PARTY INTERACTION LETTER
DWB_EVT_PRTY_INTRACN_PRTCPTN	EVENT PARTY INTERACTION PARTICIPATION
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_EXP_RPT_PRTY_ASGN	EXPENSE REPORT PARTY ASSIGNMENT
DWB_FIXED_LN_CALL_EVT	FIXED LINE CALL EVENT
DWB_GL_BAL	GL BALANCE
DWB_GL_JE	GL JOURNAL ENTRY
DWB_GL_JE_BTCH	GL JOURNAL ENTRY BATCH
DWB_GL_JE_LN	GL JOURNAL ENTRY LINE
DWB_GL_JE_LN_SBLDGR_ASGN	GL JE LINE SUBLEDGER ASSIGNMENT
DWB_GL_SBLDGR_JE	GL SUBLEDGER JOURNAL ENTRY
DWB_GL_SBLDGR_JE_LN	GL SUBLEDGER JOURNAL ENTRY LINE
DWB_GPRS_USG_EVT	GPRS USAGE EVENT
DWB_IDD_CALL_EVT	IDD CALL EVENT
DWB_INSTLMNT_CNRT	INSTALLMENT CONTRACT
DWB_INTRACN_ANSWR_CHOICE	INTERACTION ANSWER CHOICE
DWB_INTRACN_NAVGTN_HIST	INTERACTION NAVIGATION HISTORY
DWB_INTRACN_QUES_RESPN	INTERACTION QUESTION RESPONSE
DWB_INTRACN_TRNSFR_HIST	INTERACTION TRANSFER HISTORY
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_PYMT_TERM	INVOICE PAYMENT TERM
DWB_INVC_STAT_HIST	INVOICE STATUS HISTORY
DWB_INVC_TAX_ITEM	INVOICE TAX ITEM
DWB_INV_ITEM_STATE	INVENTORY ITEM STATE
DWB_ISP_USG_EVT	ISP USAGE EVENT
DWB_IVR_INTRACN_NAVGTN_HIST	IVR INTERACTION NAVIGATION HISTORY
DWB_JE_LN_CUST_ORDR_ITEM_ASGN	JOURNAL ENTRY LINE CUSTOMER ORDER ITEM ASSIGNMENT
DWB_JE_LN_INVC_ITEM_ASGN	JOURNAL ENTRY LINE INVOICE ITEM ASSIGNMENT
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_ELMNT_STATE_HIST	NETWORK ELEMENT STATE HISTORY
DWB_NTWK_EVT	NETWORK EVENT
DWB_NTWK_EVT_ACCT_BAL_BKT_IMPC	NETWORK EVENT ACCOUNT BALANCE BUCKET IMPACT
DWB_NTWK_EVT_ACCT_BAL_IMPC	NETWORK EVENT ACCOUNT BALANCE IMPACT
DWB_NTWK_EVT_ASGN	NETWORK EVENT ASSIGNMENT
DWB_NTWK_FLT	NETWORK FAULT
DWB_NTWK_FLT_SBRP_ASGN	NETWORK FAULT SUBSCRIPTION ASSIGNMENT
DWB_NTWK_FLT_SRVC_ASGN	NETWORK FAULT SERVICE ASSIGNMENT
DWB_NTWK_FLT_STAT_HIST	NETWORK FAULT STATUS HISTORY
DWB_ORG_BSNS_UNIT_COST	ORGANIZATION BUSINESS UNIT COST
DWB_PCHSE_ORDR	PURCHASE ORDER
DWB_PCHSE_ORDR_LN_ITEM	PURCHASE ORDER LINE ITEM
DWB_PCHSE_ORDR_LN_ITEM_STATE	PURCHASE ORDER LINE ITEM STATE
DWB_PCHSE_ORDR_STATE	PURCHASE ORDER STATE
DWB_PLCY_EVT	POLICY EVENT
DWB_PLCY_EVT_ATMC	POLICY EVENT ATOMIC
DWB_PLCY_EVT_CMPST	POLICY EVENT COMPOSITE
DWB_PRFMNC	PERFORMANCE
DWB_PRFMNC_CNSEQ	PERFORMANCE CONSEQUENCE
DWB_PRFMNC_IND	PERFORMANCE INDICATOR
DWB_PRFMNC_IP_ADDR	PERFORMANCE IP ADDRESS
DWB_PRFMNC_MBL_ADDR	PERFORMANCE MOBILE ADDRESS
DWB_PRFMNC_NTFCTN	PERFORMANCE NOTIFICATION
DWB_PRFMNC_NTWK_ADDR	PERFORMANCE NETWORK ADDRESS
DWB_PRFMNC_PNT_CD	PERFORMANCE POINT CODE
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_INSTNC_STAT_HIST	PRODUCT INSTANCE STATUS HISTORY
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_PRTNR_PYMT	PARTNER PAYMENT
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_INTRACN_THRD_SBRP_ASN	PARTY INTERACTION THREAD SUBSCRIPTION ASSIGNMENT
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_RESRE_PRFMNC	RESOURCE PERFORMANCE
DWB_RTD_NTWK_EVT	RATED NETWORK EVENT
DWB_SBRP_STAT_HIST	SUBSCRIPTION STATUS HISTORY
DWB_SBRP_TERM_VAL	SUBSCRIPTION TERM VALUE
DWB_SL_CHNL_CMISN_PLN_ASGN	SALES CHANNEL COMMISSION PLAN ASSIGNMENT
DWB_SL_CMISN_DTL	SALES COMMISSION DETAIL
DWB_SL_CMISN_PYRL	SALES COMMISSION PAYROLL
DWB_SMS_EVT	SMS EVENT
DWB_SRVC_LVL_AGRMNT_VILTN	SERVICE LEVEL AGREEMENT VIOLATION
DWB_SRVC_ORDR	SERVICE ORDER
DWB_SRVC_ORDR_LN_ITEM	SERVICE ORDER LINE ITEM
DWB_SRVC_PRFMNC	SERVICE PERFORMANCE
DWB_SRVC_RQST	SERVICE REQUEST
DWB_SRVC_STAT_HIST	SERVICE STATUS HISTORY
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_WEB_INTRACN_NAVGTN_HIST	WEB INTERACTION NAVIGATION HISTORY
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

Derived Tables

Table 4-5 briefly describes the Derived tables in Oracle Communications Data Model.

Table 4-5 Derived Tables

Table Name	More Information
DWD_ACCT_BAL_MO	ACCOUNT BALANCE MONTH DRVD
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_CALL_SCL_NTWK	CUSTOMER CALL SOCIAL NETWORK
DWD_CUST_COMMUNITY_ASGN	CUSTOMER COMMUNITY ASSIGNMENT
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_ACTVTN_DAY	PREPAID ACCOUNT ACTIVATION DAY 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_PRPD_VCHR_RCHRG_DAY	PREPAID VOUCHER RECHARGE 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_SBRP_STTSTC	SUBSCRIPTION 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

Aggregate Tables

Table 4-6 briefly describes the Aggregate tables in Oracle Communications Data Model.

Table 4-6 Aggregate Tables

Table Name	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 DRVD
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_SBRP_STTSTC_MO	SUBSCRIPTION 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_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

Temporary and Other Tables

Table 4-7, Table 4-8, and Table 4-9 briefly describes the temporary and control tables in Oracle Communications Data Model.

Table 4-7 Temporary Oracle Communications Data Model Tables

Table Name	Description
`DWA_CUST_GROSS_ORDRS_QTR`	This entity gives order measures, number of orders and total order amount, in same quarters of consecutive years.
`DWA_CUST_NET_ORDRS_QTR`	This entity gives order measures, number of orders and total order amount, in consecutive quarters.
`DWA_CUST_ORDR_MO`	This entity summarizes orders placed by customers at month level aggregation. Using this entity, order measures, number of orders and total order amount, across order status, order type, product, product type dimensions can be computed.

Table 4-8 Control Tables

Table Name	Description
`DWC_ETL_PARAMETER`	Store ETL parameters such as etl start date and etl end date. For more information, see "Intra-ETL Load Parameters Control Table".
`DWC_INTRA_ETL_ACTIVITY`	Reports errors at the individual program level. For more information, see "Intra-ETL Monitoring Process Control Tables".
`DWC_INTRA_ETL_PROCESS`	Reports errors at the whole batch load level. For more information, see "Intra-ETL Monitoring Process Control Tables".

Table 4-9 Miscellaneous Oracle Communications Data Model Tables

Table Name	Description
`DWV_CNRT_ACCT_SBRP_PROD`	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.
`STG_DWD_VOI_CALL_DAY`	Table stores staging results in populating data for DWD_VOI_CALL_DAY.

Database Sequences

Table 4-10 lists the Sequence Names in Oracle Communications Data Model.

Table 4-10 Database Sequences

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_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_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_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

Compressed Tables

Table 4-11 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 4-11 Compressed Tables

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

Oracle Communications Data Model OLAP Cube MV, Cube View

This section includes information on the following:

Oracle OLAP Cube Views: Oracle OLAP cube views provide organizations with the ability to both improve the performance and analytic content of SQL-based business intelligence applications. OLAP cube views are relational views of OLAP cubes, dimensions, and hierarchies that reveal the full content of cubes and dimensions.
Cube MV (Materialized Cube Views): Cube-organized materialized views, introduced,in Oracle Database 11g, play the same role as table-based materialized views. That is, a summary management solution that is transparent to the querying application. Like table-based materialized views, the application queries the detail tables and the database automatically rewrites the query to access summary data in the materialized view. In the case of cube-organized materialized views, the data is managed in the cube rather than a table.

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
`CB$ACM`	`ACM`	Cube	Customer Acquisition Cube
`CB$ADM`	`ADM`	Cube	Account Debt Cube
`CB$APM`	`APM`	Cube	Account Payment Cube
`CB$ARM`	`ARM`	Cube	Account Refund Cube
`CB$ARRSN_HARRSN`	`ARRSN_HARRSN`	Dimension_Hierarchy	Account Refund Reason: ARRSN
`CB$CAGNCY_HCAGNCY`	`CAGNCY_HCAGNCY`	Dimension_Hierarchy	Collection Agency: CAGNCY
`CB$CCM`	`CCM`	Cube	Cost Product Market Plan Cube
`CB$CHRN`	`CHRN`	Cube	Subscriber Churn Statistic Cube
`CB$CM`	`CM`	Cube	Contract Cube
`CB$CMSN`	`CMSN`	Cube	Commission Cube
`CB$CMTYP_HCMTYP`	`CMTYP_HCMTYP`	Dimension_Hierarchy	Commission Type: CMTYP
`CB$COM`	`COM`	Cube	Cost Organizational Cube
`CB$CRNRSN_HCRNRSN`	`CRNRSN_HCRNRSN`	Dimension_Hierarchy	Churn Reason: CRNRSN
`CB$CSGMNT_HCSGMNT`	`CSGMNT_HCSGMNT`	Dimension_Hierarchy	Customer Segment: CSGMNT
`CB$CSM`	`CSM`	Cube	Cell Statistic Cube
`CB$CUSTYP_HCUSTYP`	`CUSTYP_HCUSTYP`	Dimension_Hierarchy	Customer Type: CUSTYP
`CB$CUST_HCUST`	`CUST_HCUST`	Dimension_Hierarchy	Customer: CUST
`CB$DAB_HDAB`	`DAB_HDAB`	Dimension_Hierarchy	Debt Aging Band: DAB
`CB$EDCM`	`EDCM`	Cube	External Debt Collection Cube
`CB$GEO_HGEO`	`GEO_HGEO`	Dimension_Hierarchy	Geography: GEO
`CB$HSKM`	`HSKM`	Cube	Handset Stock Cube
`CB$HSMDL_HHSMDL`	`HSMDL_HHSMDL`	Dimension_Hierarchy	Handset Model: HSMDL
`CB$IAM`	`IAM`	Cube	Invoice Adjustment Cube
`CB$IARSN_HIARSN`	`IARSN_HIARSN`	Dimension_Hierarchy	Invoice Adjustment Reason: IARSN
`CB$IATYP_HIATYP`	`IATYP_HIATYP`	Dimension_Hierarchy	Invoice Adjustment Type: IATYP
`CB$ICT`	`ICT`	Cube	Invoice Customer Type Cube
`CB$MNCT_HMNCT`	`MNCT_HMNCT`	Dimension_Hierarchy	Mining Churn Type: MNCT
`CB$MNLSB_HMNLSB`	`MNLSB_HMNLSB`	Dimension_Hierarchy	Mining Life Time Survival Band: MNLSB
`CB$MNLVB_HMNLVB`	`MNLVB_HMNLVB`	Dimension_Hierarchy	Mining Life Time Value Band: MNLVB
`CB$MNSC_HMNSC`	`MNSC_HMNSC`	Dimension_Hierarchy	Mining Sentiment Category: MNSC
`CB$NELMNT_HNELMNT`	`NELMNT_HNELMNT`	Dimension_Hierarchy	Network Element: NELMNT
`CB$ORG_HBANNER`	`ORG_HBANNER`	Dimension_Hierarchy	Organization: ORG
`CB$ORG_HCHAIN`	`ORG_HCHAIN`	Dimension_Hierarchy	Organization: ORG
`CB$ORG_HCORPORATE`	`ORG_HCORPORATE`	Dimension_Hierarchy	Organization: ORG
`CB$PCHNL_HPCHNL`	`PCHNL_HPCHNL`	Dimension_Hierarchy	Payment Channel: PCHNL
`CB$PMP_HPMP`	`PMP_HPMP`	Dimension_Hierarchy	Product Market Plan: PMP
`CB$PMTYP_HPMTYP`	`PMTYP_HPMTYP`	Dimension_Hierarchy	Payment Method Type: PMTYP
`CB$POPT_HPOPT`	`POPT_HPOPT`	Dimension_Hierarchy	Peak Offpeak Time: POPT
`CB$PRMTN_HCMPGN`	`PRMTN_HCMPGN`	Dimension_Hierarchy	Promotion: PRMTN
`CB$PRMTN_HPRMTN`	`PRMTN_HPRMTN`	Dimension_Hierarchy	Promotion: PRMTN
`CB$PROD_HPROD`	`PROD_HPROD`	Dimension_Hierarchy	Product: PROD
`CB$PTTYP_HPTTYP`	`PTTYP_HPTTYP`	Dimension_Hierarchy	Payment Transaction Type: PTTYP
`CB$RVN`	`RVN`	Cube	Revenue Cube
`CB$SLCHNL_HSLCHNL`	`SLCHNL_HSLCHNL`	Dimension_Hierarchy	Sales Channel: SLCHNL
`CB$TIME_HTBSNS`	`TIME_HTBSNS`	Dimension_Hierarchy	Time: TIME
`CB$TSLT_HTSLT`	`TSLT_HTSLT`	Dimension_Hierarchy	Time Slot: TSLT

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
`ACM_FCST_STTSTC_VIEW`	`ACM_FCST_STTSTC`	Cube	Customer Acquisition Forecast Statistic Cube
`ACM_FCST_VIEW`	`ACM_FCST`	Cube	Customer Acquisition Forecast Cube
`ACM_VIEW`	`ACM`	Cube	Customer Acquisition Forecast Cube
`ADM_VIEW`	`ADM`	Cube	Customer Acquisition Cube
`APM_VIEW`	`APM`	Cube	Account Payment Cube
`ARM_VIEW`	`ARM`	Cube	Account Refund Cube
`ARRSN_HARRSN_VIEW`	`ARRSN_HARRSN`	Hierarchy	Account Refund Reason: ARRSN
`ARRSN_VIEW`	`ARRSN`	Dimension	Account Refund Reason: ARRSN
`CAGNCY_HCAGNCY_VIEW`	`CAGNCY_HCAGNCY`	Hierarchy	Collection Agency: CAGNCY
`CAGNCY_VIEW`	`CAGNCY`	Dimension	Collection Agency: CAGNCY
`CCM_VIEW`	`CCM`	Cube	Cost Product Market Plan Cube
`CHRN_VIEW`	`CHRN`	Cube	Subscriber Churn Statistic Cube
`CMSN_VIEW`	`CMSN`	Cube	Commission Cube
`CMTYP_HCMTYP_VIEW`	`CMTYP_HCMTYP`	Hierarchy	Commission Type: CMTYP
`CMTYP_VIEW`	`CMTYP`	Dimension	Commission Type: CMTYP
`CM_VIEW`	`CM`	Cube	Contract Cube
`COM_VIEW`	`COM`	Cube	Cost Organizational Cube
`CRNRSN_HCRNRSN_VIEW`	`CRNRSN_HCRNRSN`	Hierarchy	Churn Reason: CRNRSN
`CRNRSN_VIEW`	`CRNRSN`	Dimension	Churn Reason: CRNRSN
`CSGMNT_HCSGMNT_VIEW`	`CSGMNT_HCSGMNT`	Hierarchy	Customer Segment: CSGMNT
`CSGMNT_VIEW`	`CSGMNT`	Dimension	Customer Segment: CSGMNT
`CSM_FCST_VIEW`	`CSM_FCST`	Cube	Cell Statistic Forecast Cube
`CSM_VIEW`	`CSM`	Cube	Cell Statistic Cube
`CUSTYP_HCUSTYP_VIEW`	`CUSTYP_HCUSTYP`	Hierarchy	Customer Type: CUSTYP
`CUSTYP_VIEW`	`CUSTYP`	Dimension	Customer Type: CUSTYP
`CUST_HCUST_VIEW`	`CUST_HCUST`	Hierarchy	Customer: CUST
`CUST_VIEW`	`CUST`	Dimension	Customer: CUST
`DAB_HDAB_VIEW`	`DAB_HDAB`	Hierarchy	Debt Aging Band: DAB
`DAB_VIEW`	`DAB`	Dimension	Debt Aging Band: DAB
`EDCM_VIEW`	`EDCM`	Cube	External Debt Collection Cube
`GEO_HGEO_VIEW`	`GEO_HGEO`	Hierarchy	Geography: GEO
`GEO_VIEW`	`GEO`	Dimension	Geography: GEO
`HSKM_FCST_VIEW`	`HSKM_FCST`	Cube	Handset Stock Forecast Cube
`HSKM_VIEW`	`HSKM`	Cube	Handset Stock Cube
`HSMDL_HHSMDL_VIEW`	`HSMDL_HHSMDL`	Hierarchy	Handset Model: HSMDL
`HSMDL_VIEW`	`HSMDL`	Dimension	Handset Model: HSMDL
`IAM_VIEW`	`IAM`	Cube	Invoice Adjustment Cube
`IARSN_HIARSN_VIEW`	`IARSN_HIARSN`	Hierarchy	Invoice Adjustment Reason: IARSN
`IARSN_VIEW`	`IARSN`	Dimension	Invoice Adjustment Reason: IARSN
`IATYP_HIATYP_VIEW`	`IATYP_HIATYP`	Hierarchy	Invoice Adjustment Type: IATYP
`IATYP_VIEW`	`IATYP`	Dimension	Invoice Adjustment Type: IATYP
`ICT_VIEW`	`ICT`	Cube	Invoice Customer Type Cube
`MNCT_HMNCT_VIEW`	`MNCT_HMNCT`	Hierarchy	Mining Churn Type: MNCT
`MNCT_VIEW`	`MNCT`	Dimension	Mining Churn Type: MNCT
`MNLSB_HMNLSB_VIEW`	`MNLSB_HMNLSB`	Hierarchy	Mining Life Time Survival Band: MNLSB
`MNLSB_VIEW`	`MNLSB`	Dimension	Mining Life Time Survival Band: MNLSB
`MNLVB_HMNLVB_VIEW`	`MNLVB_HMNLVB`	Hierarchy	Mining Life Time Value Band: MNLVB
`MNLVB_VIEW`	`MNLVB`	Dimension	Mining Life Time Value Band: MNLVB
`MNSC_HMNSC_VIEW`	`MNSC_HMNSC`	Hierarchy	Mining Sentiment Category: MNSC
`MNSC_VIEW`	`MNSC`	Dimension	Mining Sentiment Category: MNSC
`NELMNT_HNELMNT_VIEW`	`NELMNT_HNELMNT`	Hierarchy	Network Element: NELMNT
`NELMNT_VIEW`	`NELMNT`	Dimension	Network Element: NELMNT
`ORG_HBANNER_VIEW`	`ORG_HBANNER`	Hierarchy	Organization: ORG
`ORG_HCHAIN_VIEW`	`ORG_HCHAIN`	Hierarchy	Organization: ORG
`ORG_HCORPORATE_VIEW`	`ORG_HCORPORATE`	Hierarchy	Organization: ORG
`ORG_VIEW`	`ORG`	Dimension	Organization: ORG
`PCHNL_HPCHNL_VIEW`	`PCHNL_HPCHNL`	Hierarchy	Payment Channel: PCHNL
`PCHNL_VIEW`	`PCHNL`	Dimension	Payment Channel: PCHNL
`PMP_HPMP_VIEW`	`PMP_HPMP`	Hierarchy	Product Market Plan: PMP
`PMP_VIEW`	`PMP`	Dimension	Product Market Plan: PMP
`PMTYP_HPMTYP_VIEW`	`PMTYP_HPMTYP`	Hierarchy	Payment Method Type: PMTYP
`PMTYP_VIEW`	`PMTYP`	Dimension	Payment Method Type: PMTYP
`POPT_HPOPT_VIEW`	`POPT_HPOPT`	Hierarchy	Peak Offpeak Time: POPT
`POPT_VIEW`	`POPT`	Dimension	Peak Offpeak Time: POPT
`PRMTN_HCMPGN_VIEW`	`PRMTN_HCMPGN`	Hierarchy	Promotion: PRMTN
`PRMTN_HPRMTN_VIEW`	`PRMTN_HPRMTN`	Hierarchy	Promotion: PRMTN
`PRMTN_VIEW`	`PRMTN`	Dimension	Promotion: PRMTN
`PROD_HPROD_VIEW`	`PROD_HPROD`	Hierarchy	Product: PROD
`PROD_VIEW`	`PROD`	Dimension	Product: PROD
`PTTYP_HPTTYP_VIEW`	`PTTYP_HPTTYP`	Hierarchy	Payment Transaction Type: PTTYP
`PTTYP_VIEW`	`PTTYP`	Dimension	Payment Transaction Type: PTTYP
`RVN_FCST_VIEW`	`RVN_FCST`	Cube	Revenue Forecast Cube
`RVN_VIEW`	`RVN`	Cube	Revenue Cube
`SLCHNL_HSLCHNL_VIEW`	`SLCHNL_HSLCHNL`	Hierarchy	Sales Channel: SLCHNL
`SLCHNL_VIEW`	`SLCHNL`	Dimension	Sales Channel: SLCHNL
`TIME_HTBSNS_VIEW`	`TIME_HTBSNS`	Hierarchy	Time: TIME
`TIME_VIEW`	`TIME`	Dimension	Time: TIME
`TSLT_HTSLT_VIEW`	`TSLT_HTSLT`	Hierarchy	Time Slot: TSLT
`TSLT_VIEW`	`TSLT`	Dimension	Time Slot: TSLT