PK ˚FJoa,mimetypeapplication/epub+zipPK˚FJMETA-INF/container.xml PKYuPK˚FJOEBPS/app_buc2.htm Oracle Communications Data Model Business Use Case

B Oracle Communications Data Model Business Use Case

This appendix provides an overview and examples of Oracle Communications Data Model business use case scenarios.

This appendix includes the following sections:

Sample Use Case: Introduction

The sample business use case for Oracle Communications Data Model includes the following:

  • A Multi-play telecom Carrier, including:

    • SuperTelcoGroup

    • SuperTelcoCommunications

    • SuperData

The SuperTelco Communications organization comprises two business units:

  • Mobile

  • Broadband: The broadband unit, named SuperData, is an acquired company; this organization has a different hierarchy. The broadband unit includes both video and broadband data services.

Their Product Offering includes (among others):

  • Broadband Services for B2C and B2B

  • Video on Demand

  • Mobile (for example 3G) services

Their prospects and then customers will be Tom Daniels and his family (Mary Daniels and their children) and some companies.

Sample Use Case 1: Setting Up the Business Unit Organization

This business use case, describes how to build up the organization SuperTelco as a PARTY in the data model. In particular, the two main business units (Mobile with SuperTelco and Broadband with SuperData) will be modeled into Oracle Communications Data Model corresponding Subject Area, shown in Figure B-1.

Figure B-1 Organization Business Units in Sample Use Case

Description of Figure B-1 follows

Oracle Communications Data Model should capture the following administrative functions for the Mobile and Broadband business units:

  • HQ, HQ Mobile/HQ Broadband, Customer Care, Sales Marketing

  • Related geographic information (for state, county, City, Dealers/Shops and Web Service)

  • The people involved, in particular all employees (who is a manager from whom in which organization)

To work with the sample use case you build up the organization SuperTelco as a PARTY in the Oracle Communications Data Model:

  1. There are two ways to store the information for an ORGANIZATION BUSINESS UNIT:

    • Using a standard pre-defined hierarchy

    • Using a flexible hierarchy

  2. As shown in Figure B-1, the business unit follows a simple hierarchy stored in the corresponding tables:

    • ORGANIZATION BUSINESS UNIT: this is the smallest "independent" unit of an organization which can contain several sales channels and/or customer contact possibilities, such as call centers (stored in CALL CENTER), a website (stored in "Service Web Site"), and shops (in RETAIL STORE). The business unit is of a specified type, as detailed in the ORGANIZATION BUSINESS UNIT TYPE. All the information relative to this business unit, such as the business address or the company registry number is stored in the ORGANIZATION BUSINESS UNIT. It is a sub-type of PARTY.

    • This business unit is geographically (and somehow "administratively") situated in a district, region, and area. The geographic entity is stored as specified in the entities: ORGANIZATION DISTRICT, ORGANIZATION REGION, and ORGANIZATION AREA.

    • To understand the notion of "organizational chain" above the organization area, consider for example that the SuperTelco stores are located inside a given supermarket chain. SuperTelco may have a part of the organization related to this chain of supermarket, which would then be stored in the ORGANIZATION CHAIN table.

    • The ORGANIZATION CHAIN belongs to a company; in this example, the company SuperTelco is stored in the ORGANIZATION COMPANY table, itself member of a group whose information is stored in ORGANIZATION CORPORATE.

    • When you use a "banner" for a given sales channel, store the banner in the ORGANIZATION BANNER table, linking the business unit to the corporate level.

  3. As shown in Figure B-1, the business unit could also be part of a proper and changeable hierarchy (or hierarchies) that would then be stored in the corresponding tables of the so-called "flexible" Organization hierarchy:

Of these two choices: simple hierarchy and flexible hierarchy, the SuperTelco sample use case uses the flexible hierarchy. This is the preferred hierarchy for this sample because the historic growth of SuperTelco specifies that the hierarchy changes over time. To deal with the geographical organization of the SuperTelco stores dispatched in the country however, the standard hierarchy could be used. Such a hierarchy would support a detailed analysis of the local and geographical differences for the impact of a national marketing campaign.

Sample Use Case 2: Acquiring a New Customer (with Family Plan)

For the sample use case, let us assume that a father (Tom Daniels) goes to a SuperTelco dealer and asks for a Family Plan offering with the following features:

  • One main mobile phone postpaid (his)

  • One secondary mobile phone postpaid (wife)

  • Two additional mobile phones prepaid (children)

  • One Friends and Family option that allows calls between these users to be free of charge

The father is moving his service from a competitor and wants to keep his current mobile number (number portability required). This example provides details on the information stored in the various agreement, account, customer, and party entities. The actions covered in this area include the following, as shown in Figure B-2.

  • Party Interaction (Customer - Dealer)

  • Contract setup (Customer, Account, Billing, and others)

  • Subscription

  • Product Association

  • Phone number and equipment associations

Figure B-2 Customer Acquisition: Family Plan Model

Description of Figure B-2 follows

New Customer with Family Plan Data:

  1. The ORGANIZATION BUSINESS UNIT information was previously setup, as described in Sample Use Case 1: Setting Up the Business Unit Organization.

  2. The newly acquired customer information is stored in the CRM and/or the billing system. This information will feed Oracle Communications Data Model using a custom ETL. One record in CUSTOMER is inserted with a name, in this case "Tom Daniels", of type "individual". Usually customers are not required to provide additional user information when purchasing multiple numbers. If this information is provided, you can save the information with the PARTY entity (and you should use the PARTY ASSIGNMENT table to describe their relationship to "Tom Daniel" - assuming this information is available in the data source).

  3. Save the related information about a customer, such as profession, age, education, and other information in the related CUSTOMER tables, the referential lookup tables, such as SOC JOB ("Standard Occupational Classification" system for the work activity of the individual customer). Save confidential information such as the date of birth in the table called CUSTOMER RESTRICTED INFO that can be individually hidden or encrypted in the database.

  4. A contract between Tom Daniels and SuperTelco is set up in the AGREEMENT table (equivalent to a contract but generalized). The customer has a agreement with the Service Provider which defines the accounts (normally with a unique login or a unique identifier). For example this sample agreement is based on a special package "PKG_Mobile_300". The product packages available to any type of consumers (individual - B2C or businesses - B2B) are saved in the PRODUCT OFFERING entity.

  5. One customer account is inserted into the ACCOUNT entity, with the customer key pointing to the new customer instance. The account is the financial vision of the customer. There is normally only one account per customer (whatever the number of subscriptions they buy) but multiple accounts per customer is allowed (typically to either reproduce the billing vision or in some specific cases).

  6. The customer, Tom Daniels, has selected four different handsets (stored in the EQUIPMENT table; this is not visible on the diagram shown in Figure B-2).

  7. Four Mobile phone numbers are saved into the table ACCESS METHOD and the associated handset. Each phone number uses the current date for the effective date and also has the account ID pointing to the account (as the account ID was set up).

  8. A customer order, stored in the CUSTOMER ORDER entity, is generated with all the items that the customer ordered including mobile numbers, product packages, and so on (including the number portability request).

  9. A number portability request is triggered by the order and a number portability event is stored in the NP REQUEST HEADER table. Due to the number portability request, the customer order may be processed with some delay; the old network provider must respond positively to SuperTelco's number portability request. In this case, either only Tom Daniels's IMSI or all IMSIs related to Tom Daniels will be activated after the agreement date ("today"). For this case, creating an additional, custom ETL(s) to the mediation or provisioning system may be necessary.

  10. Four subscriptions are inserted into the PRODUCT SUBSCRIPTION table. A subscription is considered a "non-network event" as opposed to a call, which is a "network event". Each subscription associates one product, one customer, one account, and one ACCESS METHOD (mobile number).

  11. The customer order could be loaded into Oracle Communications Data Model through the Extract-Transform-Load scripts (ETL) at each change of status or only once it is completed and fulfilled in the BSS/OSS systems.

  12. A fulfilled (closed) customer order automatically impacts the data mining tables related to the customer segmentation, market share, and the revenue OLAP cubes: For example, due to the number portability request, the competitor looses one customer and SuperTelco wins one customer in the given segment.

  13. In the pure prepaid case, no bill is created. However, the purchase of a voucher for any type of prepaid services is taken in account in Oracle Communications Data Model: PayTV, Music downloads, Prepaid card with handset, and so on. The original prepaid allowance or the recharge will be recorded and an account is created, similarly to the postpaid case.

Sample Use Case 3: Service Implementation

After Tom purchased the family plan, made the payment, and the customer order was generated, the provisioning engine takes over.

The service implementation is stored with Oracle Communications Data Model as shown in Figure B-3.

Figure B-3 Service Implementation

Description of Figure B-3 follows

For the service implementation, the provisioning engine does the following:

  1. Each "customer Order" is disassembled into multiple "Service Order", each of which is used by the provisioning engine to orchestrate the whole system. Each "Service Order" is normally corresponding to a specific "Network Element" or a group of "Network Element". For example, one customer order of Prepaid GSM phone can be fulfilled by multiple "Service Order", including account setup of in the billing and CRM systems, in Intelligent Network system, and so on.

  2. Once the "Service Order" is executed, some new services may be generated. The service may be "customer facing service", which is an internal presentation of "Subscription". The business user sees each product realization on each customer as a "subscription" to track the business usage, while the technical user (from the network) sees a customer activation (and usage) on a "network element" (including logical "network element" like phone numbers) as a "Resource Facing Service". These notions are those defined by the TeleManagement Forum.

  3. In case any "Network Element" failed, technical support can easily track which customers or accounts may be affected by following relationships from "network element" to "Service" and then to "Subscription".

  4. As subtype of the Business Interaction, the CUSTOMER FIELD SERVICE ACTIVITY table (not visible on the diagram) would store any direct interaction on customer's or network's site for this order.

Sample Use Case 4: Storing Customer Call Data

After Tom Daniels has got his phone, and after the phones for his wife and children are activated, Tom Daniels regularly calls his family and friends. Tom Daniels uses the phone primarily to make voice calls and to send SMS messages; he rarely uses the data or MMS services.

The customer call information is stored with Oracle Communications Data Model as shown in Figure B-4.

Figure B-4 Customer Call Data Model

Description of Figure B-4 follows

The call data can be saved in Oracle Communications Data Model:

  1. The CUSTOMER, PRODUCT SPECIFICATION, and ACCESS METHOD are set up, as described in Sample Use Case 2: Acquiring a New Customer (with Family Plan).

  2. Each time the customer makes a call, this generates a Call Detail Record (CDR) in the network, at the switch level (raw CDRs) which then will be collected by the mediation (Mediated CDRs) and forwarded to the rating and/or billing engine (Rated CDRs). This last CDR - in the wireless case - is saved into the WIRELESS CALL EVENT table in Oracle Communications Data Model (this is a sub-entity of the UDR EVENT table). A UDR EVENT is an abstract entity which defines the minimal common definition of any network events (calls and service usage of any type).

  3. The CALL CATEGORY tracks the type of a call, such as a data or a voice call.

  4. The ROAMING TYPE tracks whether the call roams from another operator or to another operator.

  5. The MEDIATED CALL EVENT table stores the CDRs from the mediation system (before entering the billing engine).

  6. The UDR EVENT table stores the call details such as the call date and time and the call duration.

Note: Depending on where the source Call Detail Record (CDR) is taken, the CDR may contain a charge for the following:

  • In case of Roaming, the (base) charge is set by the other operator (raw or mediated CDRs level), while the carrier itself usually adds a surcharge (fixed percentage or fixed price per minute - normally higher than the roaming charge).

  • In case of Value Added Service, the charge is set by the vendor (raw or mediated CDRs).

  • In case the CDR source is the billing system, after rating has taken place (rated CDRs). This is also true for CDRs from the IN Platform which is doing the rating (typically for Prepaid).

Depending on the type of analysis, it is usually recommended for revenue assurance to check at least both mediated (before the billing system) and rated or billed CDRs (from the billing). The raw CDRs, direct input from the network, are usually more complex to deal with (binary type of data, a potential factor 100 in number of CDRs and additional signaling information) but are very interesting from a network operation and revenue assurance point of view.

Sample Use Case 5: Customer Billing

At the end of each bill cycle period (usually a specific day of the month for a given bill cycle), SuperTelco runs the billing process over the calling records for the customer and generates an invoice. In our example, Tom Daniels receives an invoice of $100 for all the phone numbers (Postpaid only normally, but one could think that he could also have agreed to pay by default every month some Recharges for his children "Prepaid" phones). Tom Daniels has to pay SuperTelco within a month or the service could be suspended.

Oracle Communications Data Model stores the customer billing, invoice, and payment information as shown in Figure B-5.

Figure B-5 Billing and Payment Data Model (simplified and missing some entities)

Description of Figure B-5 follows

Billing Data in Oracle Communications Data Model:

  1. The section, Sample Use Case 4: Storing Customer Call Data, describes the collection of call data records data.

  2. To store the details of the product charging information, Oracle Communications Data Model uses the PRODUCT SPECIFICATION sub-entities such as: PRODUCT OFFERING RATING PLAN, PRODUCT OFFERING RATING PLAN DETAIL, and PRODUCT OFFERING PRICE and PRICE TYPE.

  3. Each ACCOUNT is billed independently. If a customer owns multiple agreements, multiple INVOICEs are generated in the same month.

  4. An agreement may have a different billing period than other agreements associated to the same account. A billing period may be specified monthly, bi-weekly, and so on.

  5. After the billing and invoicing have occurred in the billing system, the INVOICE, INVOICE ITEM and INVOICE ITEM DETAIL tables store all the information of the invoice for the given billing period (usually a month). The term at which the customer has to pay the invoice is saved in the INVOICE PAYMENT TERM TYPE associated with each invoice (for example, one month or 90 days). The term is fixed when the agreement is signed.

  6. In case a discount or adjustment is applied to the invoice, this information is stored in the corresponding table (INVOICE DISCOUNT or INVOICE ADJUSTMENT). An EMPLOYEE can make invoice adjustments to the amount limited by INVOICE ADJUSTMENT QUOTA.

  7. The invoice delivery to Tom Daniels is a small part in the complete billing and invoice issuing and dispatching processes. The specific information related to Tom's invoice is stored in the INVOICE PROCESS ASSIGNMENT table (not visible in the diagram) and eventually in the INVOICE itself (see the date at which it is created, issued and dispatched).

  8. The ACCOUNT PAYMENT METHOD stores the payment method chosen when the agreement was signed and this method is the default for the payment transaction.

  9. When Tom Daniels pays the invoice, for example using a bank transfer, the payment is stored in ACCOUNT PAYMENT and assigned to the corresponding open invoice. The ACCOUNT PAYMENT is stored into the INVOICE PAYMENT ASSIGNMENT. The ACCOUNT PAYMENT table stores any type of payment (normal payment, recharge, transfer, refund, and so on). You may define a view for each subtype whenever required.

  10. The difference between the INVOICE amount and the payment adds to the debt (the debt is not shown in Figure B-5).

Note: for the revenue assurance sub-area and its corresponding reports, it is important to store the itemized bill in Oracle Communications Data Model. The usage items (detailed call list) can then be compared, one by one, with the rated CDRs and using this method you can find the difference between rated and billed CDRs.

The section, Sample Use Case 7: Targeted Promotion for Video-on-Demand Services" shows a campaign set-up with the prospect choice. For this campaign, a measure of the campaign success could be obtained by analyzing the number of subscribers who contacted the call center and requested a product change based on the promotion, as a factor of time, in hours or days, between sending the promotion and customer call-back.

Sample Use Case 6: Changing Plan and Billing Address

SuperTelco launches a campaign to promote a package with converged broadband and mobile services. Tom Daniels sees the promotion message, delivered through an SMS campaign, and decides to take advantage of the promotion. He calls the call center and asks to change his product package to obtain the new converged family plan that includes broadband services. Later, using the SuperTelco Web Self-Service Interface he changes his billing address.

The section, Sample Use Case 7: Targeted Promotion for Video-on-Demand Services shows a campaign set-up with the prospect choice. For this campaign, a measure of the campaign success could be obtained by analyzing the number of subscribers who contacted the call center and requested a product change based on the promotion, as a factor of time, in hours or days, between sending the promotion and customer call-back.

SuperTelco uses Oracle Communications Data Model to store this customer interaction as shown in Figure B-6 and as outlined in the corresponding steps.

Figure B-6 Changing Plan and Billing Address

Description of Figure B-6 follows

  1. The section, "Sample Use Case 1: Setting Up the Business Unit Organization" covers information about the call center.

    The call center agent, stored in CALL CENTER AGENT, as well as the team and department, in CALL CENTER table, are uniquely identified in Oracle Communications Data Model. The call center agent may be an employee (stored then in EMPLOYEE) of SuperTelco or an employee of a partner company that runs the call center for SuperTelco. For this example the CALL CENTER AGENTis a subtype of EMPLOYEE. All INTERACTION CHANNELs need to be configured, such as the CALL CENTER and any Web or Online business system, or a counter (in a shop), to make sure that one can trace the interaction with the customer at any time.

  2. The details for interaction information for the call center are stored as a "non network event". Depending on the method Tom Daniels uses to contact the call center, the corresponding code from INTERACTION TYPE is stored with the event:

    • Using EVENT PARTY INTERACTION (use interaction type as "Call" in this case). This information is aggregated in the CALL CENTER CALL MONTH AGGR for further analysis.

    • A thread will be defined by the first interaction of the chain in EVENT PARTY INTERACTION to store the reason for the customer call. A thread groups all interactions having to do with the same list of requests, inquiries and issues the customer deals with. This information is aggregated in the CALL CENTER CASE MONTH AGGR for further analysis.

  3. When the customer confirms the agreement change, the product change process occurs in the CRM and billing system. This process triggers two PRODUCT SUBSCRIPTION events for the ACCOUNT (when the converged product is a complete package which cannot be split). Oracle Communications Data Model stores the following events:

    If as part of the commercial process for this offering defined by the Service Provider the AGREEMENT requires changes, then do the following:

    • Close the old agreement with a "cancellation reason" specified (find the cancellation reason in the lookup table AGREEMENT STATUS REASON).

    • Create a new agreement with the corresponding AGREEMENT TERM supplied.

    • If the AGREEMENT does not need to be replaced and the new product uses the same agreement, then one case either:

      a) Close the Agreement Item with the old PRODUCT SUBSCRIPTION.

      b) Create a new Agreement Item with the new PRODUCT SUBSCRIPTION.

      c) You may also change the product assignment for the existing agreement in the table AGREEMENT PRODUCT SPEC ASSIGNMENT with a specific assignment code.

    Important Notes:

    • If by changing the PRODUCT SUBSCRIPTION, the main PRODUCT OFFERING changes, a new line in AGREEMENT (new agreement key) is required, even if the agreement code (Agreement identifier) does not change.

    • A product change impacts several other tables on the next automatic data movement (and their corresponding reports).

      • The CANNIBALIZATION DETAIL DAY DRVD table which captures the individual record related to the tariff and package change. This table fills the Cross and Up-sell mining model.

      • The customer Lifetime Value associated table is also updated. The agreement or product has changed and this change impacts the likelihood to churn.

      • The Revenue Forecast OLAP cube also changes for this customer.

The details for the product charge information are stored in the various PRODUCT SPECIFICATION sub-entities, including: PRODUCT OFFERING RATING PLAN and PRODUCT OFFERING RATING PLAN DETAIL.

Note: the Oracle Communications Data Model does not rate, from the monetary perspective, any kind of event (no "shadow billing" as such), although one could customize Oracle Communications Data Model for this purpose.

The customer table, using the entity CUSTOMER and the attribute Billing Address Location Code, stores the customer's billing address. This attribute links to the actual address entity ADDRESS LOCATION. The billing address is one type with a value from the ADDRESS TYPE for the new address. For example, when Tom Daniels changes the billing address, using the SuperTelco Web Self-Service Interface, the change is captured by the ETLs (from the CRM or from the web interface) and is stored in Oracle Communications Data Model as a the non-network event (from the source Web Interface, the Web based customer self-care system, typically where you login to obtain your offer).

When Tom Daniels has given the new address, the two addresses are linked with the ADDRESS RELATED entity. With more than one address, changes are required in the ADDRESS RELATED and CUSTOMER entities:

  • The current billing address in ADDRESS RELATED has the value "Old Billing Address" as reason.

  • The new billing address reason is assigned: if this is a new home address the new address exists in Oracle Communications Data Model and becomes the new billing address.

  • The ADDRESS STATUS of new address is set to "Active" while the ADDRESS STATUS for the old address becomes "Inactive".

  • In the CUSTOMER table, the new billing address location is overwritten and the billing address effective date is updated to the correct date.

  • The change of address may impact the customer profiling mining model.

Additionally, the PARTY STATUS HISTORY could be updated (depending on what information the Service Provider requires).

Sample Use Case 7: Targeted Promotion for Video-on-Demand Services

SuperTelco analyzes the current customer base to identify the customers who are most likely to purchase the Video-On-Demand service. The Marketing department would also like to increase the number of customers in the loyalty program (this can help limit churn). Using the Data Mining tool for target promotion, the business analyst in the SuperTelco Marketing generates a list of customers that are likely to be interested in this service and that are not currently members of a loyalty program ("supervised" mining).

A sample of the target list of customers is selected to test the promotion. Customer Tom Daniels is among the target list of customers. SuperTelco sends the target customers an email. In order to collect customer feedback, SuperTelco decides that the test promotion customers must contact the call center to get the Video-On-Demand service and one free DVD.

SuperTelco uses Oracle Communications Data Model to store this customer interaction as shown in Figure B-6 and as outlined in the corresponding steps.

Figure B-7 Targeted Promotion Data Model

Description of Figure B-7 follows

Tom Daniels decides to buy the service and calls the CALL CENTER to get the new promotion, including:

  • A month of Video-On-Demand service for ten dollars.

  • Five films per month free and one free DVD.

  • During the call he is offered the option to be added to the loyalty program with 500 Loyalty bonus points.

The section, "Sample Use Case 6: Changing Plan and Billing Address" covers the impact of a product change.

The business analyst prepares the campaign, selects the prospects, and measures the campaign success as follow:

  1. The marketing manager determines the number of customers that are members of the loyalty program. Membership in the loyalty program seems to be a factor in reducing churn and increasing SuperTelco's knowledge of a customer's preferences. To increase the number of customers in the loyalty program the marketing manager decides to contact existing customers to proposing a new offering, the Video-On-Demand product, and bind the offering to the loyalty program membership. The loyalty program membership is proposed whether the customer takes advantages of the Video-On-Demand promotion or not. Thus, the promotion includes two promotions:

    1. Service Offering: Video-On-Demand

    2. Loyalty Program Membership

  2. The product setting for Video-On-Demand is specified in the PRODUCT SPECIFICATION and PRODUCT OFFERING tables. The purpose and summary information for each promotion is specified in the PROMOTION table. Some PROMOTIONs may serve a single strategic purpose (the CAMPAIGN tracks the promotion purpose).

  3. The business analyst for this campaign has the following requirements:

    1. Prospects for Video-On-Demand should have an active broadband service.

    2. Prospects for the loyalty program should not yet be a member of the loyalty program.

    3. Prospects should only be individuals.

    4. Prospects should not be in a campaign or have recently, within the last three months, been contacted for a promotional offering.

    5. Prospect revenue should be at least in the middle range.

    6. Prospect payment should be on-time, debt aging at zero or near zero, and the prospect should have had no service suspension for bad payments.

    7. Before proposing the promotion on a large scale the business analyst should select a list of two hundred sample customers to test the campaign.

  4. Because of the information received the business analyst uses the "supervised" method for targeted promotion data mining, using the specified criteria to find the prospect list.

  5. The business analyst determines that there are two possibilities to generate the prospect list contacts:

For the sample use case the customer Tom Daniels is part of the two hundred customer test sample. He is tagged as a prospect for this campaign and will appear in the table PROSPECT. Tom Daniels can be a prospect of only one campaign at a time. This is strictly necessary to correctly measure the campaign response. Because Tom Daniels is an individual, the table PROSPECT INDIVIDUAL is filled; in addition, some data may be collected during the promotion customer interaction.

Following Tom Daniels's interaction with the CALL CENTER, as specified in the PARTY INTERACTION THREAD, the tables INITIATIVE RESULT TYPE, PARTY PROMOTION RESPONSE, and PROSPECT, field Prospect Result Code, are updated:

  1. Tom Daniels bought the service as specified in the promotion and the video chosen by Tom Daniels is recorded for further analysis (for billing and because the interest is saved information on "Tom Daniels's interest" and on most successful "Videos" type and name).

  2. Tom Daniels accepts membership in the loyalty program, stored in the LOYALTY PROGRAM entity, thus increasing the number of loyalty program members and the knowledge of Tom Daniels's interests.

Each response from a targeted customer is recorded in PARTY PROMOTION RESPONSE. A positive response is stored as part of the mining result to the campaign, thus providing a better score to individual customers in a similar segment as Tom Daniels. The scoring table is reused to calculate the likelihood of a positive answer to the campaign when the campaign is broadened beyond the test to other customers.

Note: A customer email triggered this initiative and the initiative was completed by the call center. Thus, Tom Daniels's CALL CENTER call was triggered by the email so the medium of this targeted promotion is email while the sales channel is the CALL CENTER.

As a consequence of the new loyalty program membership and the associated 500 bonus points, a "CRM" event of type Loyalty is created and stored in the LOYALTY MEMBERSHIP ENROLL table. A new MEMBERSHIP ACCOUNT is created. A membership account is an account of type Loyalty. It is specifically tracked separately and should never be part of the standard ACCOUNT BALANCE. The 500 Bonus point shall also appear in the EVENT LOYALTY PROGRAM table and also in ACCRUAL EVENT, in both cases associated with Tom's membership account. Tom Daniels also appears in the MEMBERSHIP ACCOUNT BALANCE HISTORY table (LOYALTY MEMBER POINT DAY DRVD and LOYALTY PROGRAM MO AGGR) coming from the previously defined CALL CENTER entity. The PARTY STATUS HISTORY is changed and some fields of CUSTOMER are updated (for example, Initiative Number and Customer Balance).

Note: Earning Loyalty point events (“accrual” events) are expected to come from a Billing System (or equivalent, as long as the loyalty balance is tracked), whatever their origin (purchase, retail transaction, payment, usage and so on).

Sample Use Case 8: Retention of Terminating Agreement

After a period as a customer, Tom Daniels's agreement and plan ends. Before the agreement ends SuperTelco notices that he is likely to churn, according to the socio-demographic data, the subscriptions he has, the usage and revenue pattern (based on comparisons with the customer segment).

The call center proposes that this customer continue with a new offering:

  • Family Broadband

  • Video-On-Demand and Phone

  • The new generation phone as equipment

  • A special 12% Discount for 12 months (12 month sign up)

SuperTelco uses Oracle Communications Data Model to store this customer interaction as shown in Figure B-8 and as outlined in the corresponding steps.

Figure B-8 Retention of Terminating Contract Model

Description of Figure B-8 follows

The terminating agreement and call center retention involves the following steps:

  1. Tom Daniels's churn likelihood increases as the end of the agreement approaches. Because he is an important customer, belonging to the loyalty program, the churn likelihood should be lower than in other segments (according to AWARD LEVEL when Tom Daniels participates in the loyalty program by LOYALTY MEMBERSHIP ENROLL).

  2. The operator may run Oracle Communications Data Model mining model to identify the highest probability churners. The result from mining model is saved in CUSTOMER MINING_TBS table. For more information, see "Model 1: Prepaid Churn Prediction", and "Model 3: Customer Profiling".

  3. There are usually two possible actions when a agreement is due to terminate:

    • Do nothing: In this case the agreement renews itself automatically when it is not actively canceled (assume that the customer will not churn). This is typically the case for a "sleeping" customer" that does not take the latest cheaper offering.

    • Actively contact the customer: In this case, contact the customer before the customer is sent an end agreement term letter (do this if it appears that the probability of customer churn is high and this customer is worth the investment). This action is particularly true for short-term churn-conditions. For example, when a communication is indicated up to one month before the end of the agreement where the customer may get an offer from a competitor. If the agreement ended automatically an action of the Service Provider is required for a renewal.

  4. Assuming that Tom Daniels is contacted, SuperTelco needs to know what to propose. Choices for this contact include the following:

    • Renew the agreement with no changes: this is possible but usually after several years this option in not attractive, due to competition.

    • Proposing a new offering.

    • Renewing the agreement with new hardware and a discount if the customer engages for more than twelve months.

      For the sample use case with Tom Daniels, agreement renewal with new hardware might be a good offering when the handsets for all the family members are old, over two years old, as specified in the information from HANDSET INSTANCE (subtype of EQUIPMENT INSTANCE). By offering a agreement renewal with new hardware, you could allow the customer to use-up some loyalty points he has earned (by selecting different equipment). Additionally, binding the customer to twelve more months according to his ARPU Band could be worth a 12% discount.

      When you offer a new handset, this could provide new capabilities. For example, applications to download that could generate additional revenue for SuperTelco. This expectation can be reinforced due to the age of the children.

  5. From the process perspective this use case is similar to the targeted promotion as described in "Sample Use Case 7: Targeted Promotion for Video-on-Demand Services" with similar entities and similar changes. After the customer accepts the new offer, a new AGREEMENT is setup. In addition to the new AGREEMENT, Tom Daniels is granted a gift. In this example, the new agreement offer includes a new handset or a one month data service free pass. How the customer decides to pick up the gift is tracked in REDEMPTION EVENT.

  6. Additionally to the party interaction, a non network event is stored in the table REDEMPTION EVENT to contain the free handset information. The free handset comes out of the association with the RETAIL TENDER LINE ITEM (as GIVE AWAY TYPE table assigned from the corresponding product offering (in PRODUCT OFFERING table). The handset itself is in the HANDSET INSTANCE table.

  7. If Tom Daniels was not a member of a loyalty program a similar offer could be available; the purchase for this handset offering would be stored into the CUSTOMER ORDER LINE ITEM or PURCHASE ORDER LINE ITEM table.

Sample Use Case 9: Dealer and Employee Sales Commission

This use case expands the details for customer information, as described in the section, "Sample Use Case 2: Acquiring a New Customer (with Family Plan)". This use case provides details for how sales information from a dealer is stored. Recall that in Use Case 2, the customer Tom Daniels asked for a family plan offering with the following features:

  • Four numbers: two Postpaid mobile and two PrePaid

  • One Friends and Family option

During the interaction the customer calls the call center to get the phone and broadband offering and the Video On Demand Service. Assuming that SuperTelco rewards dealers depending on customer revenue, the number of services and the customer loyalty, one shall consider the commissions and costs spending for dealers and for a given campaign:

Actions for the dealer and employee sales commission use case include the following:

  • Party interaction, customer, and dealer

  • Impact on commission and cost

  • Loyalty campaign cost

SuperTelco uses Oracle Communications Data Model to store this dealer and customer interaction as shown in Figure B-9 and as outlined in the corresponding steps.

Figure B-9 Dealer and Employee Sales Commission Data Model

Description of Figure B-9 follows

  1. The information for the customer and account setup is described in "Sample Use Case 2: Acquiring a New Customer (with Family Plan)".

  2. At implementation time or when the dealer first appeared, the dealer is entered as a DEALER, for example John Dealer, a sub-type of the PARTY table. A DEALER includes the associated entities:

    1. An address (stored in ADDRESS LOCATION and related to DEALER).

    2. A SALES CHANNEL and a channel to identify the dealer. The SALES CHANNEL is an abstracted umbrella that unifies both an external DEALER and the internal sales agents as an EMPLOYEE. The JOB ROLE for each employee is in EMPLOYEE JOB ROLE ASSIGNMENT. For example, the job role for a Sales Employee should be "Sales Agent".

    3. An organization structure or a relationship to individuals (ORGANIZATION BUSINESS UNIT).

    4. A discount group in the DISCOUNT GROUP entity within the DEALER DISCOUNT GROUP ASSIGNMENT table. All the discounts the provider allows for a dealer are defined in DEALER DISCOUNT GROUP ASSIGNMENT (as a group). This entity feeds the dealer cost and customer cost table.

  3. As an employee in sales, John Dealer is associated with a sales commission plan code from the SALES COMMISSION PLAN table (using JOB ROLE). The details of the plan SALES COMMISSION PLAN DETAIL or the type of commission COMMISSION TYPE are stored in associated entities so that the full commissions and rewards for the item, equipment, services, and product market plan sold are set-up. The EMPLOYEE JOB ROLE ASSIGNMENT.

  4. The Party interaction between John Dealer and Tom Daniels generates a new CUSTOMER ORDER. The customer order is generated in the BOSS/OSS system and loaded into Oracle Communications Data Model. For each customer order the SALES COMMISSION DETAIL is loaded to track how much commission should be granted to the DEALER in this sales transaction. Once the CUSTOMER ORDER is fulfilled in the provisioning system, an agreement is settled with four activations, four handsets (ITEM SPECIFICATIONs) and probably five products (one per mobile and the shared Friends and Family offering (even if there is only one agreement). This has the following consequences in Oracle Communications Data Model:

    1. John Dealer generated revenue increases and the number of customer and subscriptions: the revenue is compared to the quota the dealer had at the beginning of the month on each of these items, revenue, number of customers, and subscriptions, for the calculation of the dealer's commission and potential bonus and for the final dealer report.

    2. John Dealer "costs" increase correspondingly, as he wins a percentage of the generated revenue.

    3. The number of handsets available at John's shop is reduced by four (two Postpaid and two Prepaid). The out-of-stock forecast mining model is automatically fed and correspondingly updated.

    4. The commission associated with the handsets through the commission indicator attribute ("Commission Ind") will trigger the calculation of an extra commission for the items sold, aggregated on the monthly basis (using COMMISSION DRVD and SALES CAMPAIGN SUMMARY MONTH AGGR).

  5. Assuming SuperTelco rewards on the effective revenue generated by the customer, depending on the ARPU band of the account associated with the customer, the special bonus for John Dealer is updated with Tom Daniel's profile and added as a supplementary cost for the dealer and for the customer. Often at this stage a fraud detection mechanism is applied to limit dealer or customer fraud.

  6. As Tom Daniels changes the package to the convergent offering, due to a campaign, SuperTelco does not reward John Dealer. The campaign cost may be increased by the cost of creating and sending the SMS, in general, and by the cost of the call center agent interaction. The customer cost could also only be increased by the cost of the call center agent interaction (assuming the SMS sent to Tom Daniels is not considered). The fact that Tom Daniels changes his package will probably impact the Band ARPU that could also change the bonus for John Dealer.

  7. As Tom Daniels's agreement comes to an end SuperTelco may decide to reward only the call center as a successful clawback action rather than granting further John Dealer with a bonus for the loyalty of the customer, as the later was not involved at all in the action. The customer cost for Tom Daniels would still increase. The employee and call center cost would also correspondingly increase (here, probably only the employee cost, as the call center cost must be considered to be the sum of the labor, employee, costs and other costs). For example the rent for the building or of the call center service is typically associated with the location of the call center only. Note that its total margin, due to the revenue generation through the agreement renewal, is increasing even if the relative margin will probably decrease over the month.

  8. At each end of month when the sales agent commissions are paid by payroll, the information in SALES COMMISSION PAYROLL is populated.

  9. Sometimes certain dealers may commit fraud when bringing in new customers. For example, a dealer may have friends sign agreements to win a gift but then terminate the agreement. The new customers brought in by the fraudulent dealer may be identified by SUBSCRIPTION STATISTIC MONTH AGGR. In this table some statistical functions are applied to find a high churn rate by a possibly cheating DEALER, compared to all other dealers.

Sample Use Case 10: Handling a Service Problem

The Network Monitoring System detects a failure at a switch. SuperTelco wants to understand how many customers are affected by the incident. The Network Monitoring System queries the Network Inventory to get the resource ID of the faulty element. The Network Monitoring System then generates a "network failure" event and Oracle Communications Data Model captures this event.

SuperTelco uses Oracle Communications Data Model to handle a network fault, as shown in Figure B-10 and as outlined in the corresponding steps.

SuperTelco includes the full network structure as specified in Oracle Communications Data Model and both the network operating and the network inventory applications provide information to Oracle Communications Data Model once a day.

This model has been strongly extended to better fit the TeleManagement Forum Shared Information Model (TMF SID) ResourceAlarm and ServiceProblem Aggregate Business Entities.

Figure B-10 Handling a Network Fault Data Model

Description of Figure B-10 follows

Consider the case and steps required to handle a network fault:

The first questions for the manager after identifying the issue are:

  1. One evening at 8pm a network cell suffers a power outage after being hit by lightning, and the network cell goes out and does not restart. The real-time network monitoring system alerts SuperTelco maintenance central. This allows SuperTelco to quickly identify where the failure is (site, location, default configuration before the break-down) and SuperTelco sends a team to look at the issue. Assume that this outage is a cell which is difficult to reach, despite being in a high density population area; thus it takes four hours to the maintenance team to repair and restart the network cell.

  2. While the network is down, SuperTelco customers call the call center from fixed lines to complain. Some customers threaten)8 to quit the service if the problem persists.

  3. Up to this stage, Oracle Communications Data Model does not play a role. One could assume that Oracle Communications Data Model gets this summary information events, status, and so on, daily (at 2am the following morning). Note if the ETLs for the network controlling applications are configured such that Oracle Communications Data Model is updated in near real-time, for example hourly, then Oracle Communications Data Model may know about the event sooner.

  4. The SuperTelco manager gets the network fault information in real-time from the network applications team.

    • Where is the cell located?

    • Whose qualified team is in charge now?

    • Which services are impacted?

    • Which customers may be impacted?

    • What is the average revenue impact if nothing is done?

  5. Network applications should be able to answer directly where the cell is located and the team in charge. Note that Oracle Communications Data Model could also identify this information if the ID of the cell that broke down is supplied (even if Oracle Communications Data Model does not yet know that it broke down). A simple adhoc query on the RESOURCE (previously called NETWORK ELEMENT) table, and its sub-tables, could answer the question:

    "Where is my network element ID xxx?"

    To answer the question:

    "Who is in charge according to the maintenance plan?"

    Oracle Communications Data Model can supply this information with a customization of the model (this information is not available out-of-the-box). If the network fault happens to multiple RESOURCEs, all the faulted network elements are tracked in RESOURCE FAULT ASSIGNMENT. We assume that corresponding RESOURCE ALARMs are triggered.

  6. Each occurrence of a network failure is recorded in SERVICE PROBLEM. When a network fault happens at customer site, technical support activities to solve the problem are saved in the CUSTOMER FIELD SERVICE ACTIVITY when loaded into Oracle Communications Data Model.

  7. Once the network fault is resolved the resolution type of the network fault is loaded according to FAULT RESOLUTION TYPE.

  8. The list of services impacted is related to the list of elements which were out. In the sample use case, with a lightning strike, consider the full wireless traffic is down in the area near the antenna. Because this area is a high density area, one could expect that other antennae may partly cover the geographic coverage. In a GSM network, geographic areas are divided into different CELLs which are served by the corresponding BASE STATION CONTROLLER. The BASE STATION CONTROLLER is a subtype COMPOUND RESOURCE (itself a sybtype of RESOURCE). A simple report showing the affected areas and services also lists the services associated with the cell.

  9. You can obtain a list of impacted customers through the SERVICE PROBLEM SUBSCRIPTION ASSIGNMENT, which links the network fault to the PRODUCT SUBSCRIPTION table. The later contains the Circuit Component Code attribute that allows you to use the table CIRCUIT COMPONENT to get the NETWORK TOUCHPOINT concerned, the CELL SITE being a sub-table of NETWORK TOUCHPOINT. Consequently, a simple query on all subscriptions whose circuit component is tied to the cell ID that failed provides a list all the customer information associated with the given cell.

  10. Similarly, the exact list of products impacted, per customer, can easily be provided (related to the service that is down and the subscriptions concerned).

  11. With a list of products impacted, the manager can check how many calls normally run Friday evening between 8pm and 12pm, and get the average revenue generated at that time for those customers. This provides the average revenue loss within the four hours of time-off. The manager may send an email to the call center with the list of potential customers, to warn the call center that within the next three to four hours, those customers may be complaining about a loss of coverage.

  12. When a customer calls the call center, an interaction event is created in EVENT PARTY INTERACTION, with an interaction type of Complain.

  13. With the email and the customer list, a call center manager can warn the call center employees, and possibly ask for a additional personnel to manage the potential increase of complaint calls. Not that it is important to identify all the customer calls to the call center, associated with the failed cell that may be related to the network issue. This identification can be done either upfront in real-time by the call center agent or on a later with analysis from Oracle Communications Data Model. Note: the call center manager may have then an explanation ready for the next monthly meeting when he shows the customer satisfaction report.

  14. For the most valuable customers that complain and threaten to churn, the customer care manager may decide to run a compensation program. For example, by providing ten free SMS or ten minutes for free next month for private customers and provide a 10% discount for business customers at risk of churning.

  15. Later, if these procedures were not carried out, an increase in churn for the following month may be quickly related to the network issue: the default reports might show an alert due to an unusual increase in churn in a specific area (using the outlier function of the database associated to the alert functionality of Oracle Business Intelligence Suite Enterprise Edition).

  16. With Oracle Communications Data Model, there are therefore several ways to come to the same conclusion, in our case:

    • The network cell ID (near real-time).

    • The abnormally limited geographic distribution of origin of some complaints (most probably the next two days).

    • The abnormally increase of churn in a limited region (a month later).

Sample Use Case 11: Implementing a Business Area

The CFO requests that the SuperTelco IT manager (Susan) has to implement all the billing related reports of Oracle Communications Data Model

For simplification, assume that:

  • The CFO wants to get the value as quickly as possible, so that Susan is not supposed to customize anything unless strictly necessary.

  • SuperTelco uses Oracle Business Intelligence Suite Enterprise Edition as the reporting tool.

  • Oracle Communications Data Model is installed but all tables are completely empty.

Despite the fact that some DWHs exist, on customers and products, Susan goes forward as for a "greenfield" implementation. But she will reuse part of the work that was done before, either directly from the DWH tables, used as a source to Oracle Communications Data Model or using the ETLs to directly feed Oracle Communications Data Model tables.

In a second phase, the CFO requests a special report to take the customers that are diplomats and hence do not pay any VAT. A special customer code must be created and the CFO wants a report only for these specially coded customers. Thus, Susan decides she needs to enhance the customer table with a column Tax Rate Amount and introduce a new Customer Type: Diplomat. These changes should be done in parallel in the CRM, in the Customer DWH, and in the billing system.

To implement these steps, the IT manager, Susan, does the following:

  1. The project follows a typical DWH project plan with one important exception: because Oracle Communications Data Model is a "DWH-out-of-the-box", with an optimized design and an automatic data movement, intra-ETL provided, the main challenges for Susan are:

    1. Limiting the Scope of the project to quickly deliver value to the CFO:

      Identifying the reports associated with the chosen business area.

      Identifying the OLAP cubes and Mining needed or wanted by the business.

      Identifying the input tables required to fulfill the expectations.

      Identifying from the source systems the data needed to fill the tables.

    2. Analysis:

      Identifying the gaps between the organization needs and Oracle Communications Data Model out-of-the-box delivery. In Susan's case, one could assume these are reduced to a minimum. If it has not been a "greenfield" implementation, the gap analysis between the existing reports and underlying DWH structure with Oracle Communications Data Model should also be run.

      Identifying and writing down the difference in semantics between the various terms (normally, this should be quickly done after training with Oracle Communications Data Model). Mapping the source systems (in this case, only the billing and maybe the Product and Customer DWH) to Target Data Element.

    3. Design and Development:

      ETL (Billing to Oracle Communications Data Model and other DWH toOracle Communications Data Model).

      Logical Data Model and Reports Design Enhancement

    4. Training and Testing:

      Scenarii creation and run

      Acceptance Testing with some (trained) power-users

    5. Deployment:

      Initial / history data load

      Incremental load

    6. Maintenance:

  2. Within a given business area, Susan will find the reports available out-of-the-box (directly looking at the reports themselves or in the associated documentation) and discuss those the CFO wants to see absolutely.

  3. Once with the list of reports to feed, Susan checks the documentation to find out the entities from which these reports are filled and the programs used. She first turns to the Oracle Metadata dashboard (visible in Oracle Business Intelligence Suite Enterprise Edition): for each report, she finds all the tables that need to be filled (Dashboard Report-Entities) and gets also access to the Intra-ETLs that access these tables (Dashboard Entities-Programs).

  4. Going down to the entity description, she can decide which attributes (columns) per table she needs to fill and compare those with the data she can get out of its different sources. Note that Susan will be able to find which KPIs is associated to which column in the Excel file OCDM_KPI_Aggr_spec.xls:

    1. UDR EVENT as rated event from the billing system.

    2. INVOICE details from the billing system.

    3. Customer data either from the billing or the CRM system, or from its own Customer DWH.

    4. Product and product rating data from either the billing system or its Product DWH.

  5. Finally, it is Susan's decision to determine the source and then create the ETLs that load the corresponding information. In this case, she has two possibilities, the choice between the two being rather an architecture/process decision:

    1. She uses the Product and Customer DWHs as the base for true and up-to-date customer and product information (product and customer "hubs" principle). If she used the standard DWH principles, those are probably in 3NF format, thus easing the mapping process to Oracle Communications Data Model base tables for customers, products and services.

    2. She uses the ETLs that were feeding the Product and Customer DWHs and adapt them to feed Oracle Communications Data Model directly.

  6. Important for Susan is that, as soon as some data are available in Oracle Communications Data Model, it will be automatically pushed to reporting level, in the OLAP cubes and to the various mining models (following the plan agreed at implementation time). She can therefore cross-check the data at each Oracle Communications Data Model level (reference, base, derived, aggregation,…) and compare them with previous reports she has. The difference in definitions (what is a subscriber, a customer, an offering, a service,…?) must have been run upfront to be able to compare the data and clarify any differences appearing.

  7. On the second phase, adding a new type costs nothing but adding one line in the corresponding lookup table (CUSTOMER TYPE). The ETLs should be able to reference correctly the new customer type.

  8. For the tax customization, Susan will check in the Oracle Metadata dashboard the list of all intra-ETLs and programs hit by a customization of the customer table: in principle, there are a lot impacted. However, with a new attribute, most of them won't need any changes; only those that need to aggregate the result of any facts according to this new column must be extended.

  9. With this information, Susan will access and adapt the code of each intra-ETL she needs to. She will then adapt Oracle Business Intelligence Suite Enterprise Edition repository and the sample reports to present the new dimension.

PKP88)8PK˚FJOEBPS/physical_cdm.htm Oracle Communications Data Model Physical Data Model

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

The Physical Data Model of the Oracle Communications Data Model is the physical manifestation of the logical data model into database tables and relationships (or foreign key constraints). Partitions, indexes, and Materialized Views have been added to aid performance.

The Physical data model includes the following:


Important:

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

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.

  • Other table types, as show in Table 4-2.

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

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

PrefixDescription

DWA_

Aggregate table

DWB_

Base transaction table

DWD_

Derived table (Mining included)

DWL_

Lookup table

DWR_

Reference data table


Table 4-2 Other Table Name Prefix Conventions

PrefixDescription

DM$

DR$

Created when the mining models are trained. Used to store trained model and logs.

CUBE

Created when OLAP cubes are built. Used to store logs and results.


Reference Tables

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

Table 4-3 Reference Tables

BUSINESS INTERACTION LOCATION ASSIGNMENT


<td id="r420c1-t5" align="left" headers="r1c1-t5" rowspan="1" colspan="1">

DWR_MGMT_INFO

Table NameMore 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_PROD_SBRP_ASGN

ACCESS METHOD PRODUCT SUBSCRIPTION ASSIGNMENT


DWR_ACCS_MTHD_PRTY_ASGN

ACCESS METHOD PARTY ASSIGNMENT


DWR_ACCS_MTHD_SGMNT

ACCESS METHOD SEGMENT


DWR_ACCS_MTHD_SRVC_ASGN

ACCESS METHOD SERVICE ASSIGNMENT


DWR_ACCSRS

ACCESSORIES


DWR_ACCSRS_INSTNC

ACCESSORIES INSTANCE


DWR_ACCT

ACCOUNT


DWR_ACCT_AGRMNT_RLTN

ACCOUNT AGREEMENT RELATIONSHIP


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_PREF_INVC_DLVRY

ACCOUNT PREFERRED INVOICE DELIVERY


DWR_ACCT_PYMT_MTHD

ACCOUNT PAYMENT METHOD


DWR_ACCT_PRFL

ACCOUNT PROFILE


DWR_ACCT_PROD_SBRP_ASGN

ACCOUNT PRODUCT SUBSCRIPTION ASSIGNMENT


DWR_ACCT_PRTY_PROD_OFR_RLTN

ACCOUNT PARTY PRODUCT OFFERING RELATIONSHIP


DWR_ACCT_PYMT_PLN_ASGN

ACCOUNT PAYMENT PLAN ASSIGNMENT


DWR_ACCT_SGMNT

ACCOUNT SEGMENT


DWR_ACCT_SGMNT_ASGN_HIST

ACCOUNT SEGMENT ASSIGNMENT HISTORY


DWR_ACCT_SGMNT_MDL

ACCOUNT SEGMENTATION MODEL


DWR_ACCT_TAX_EXMPT_ASGN

ACCOUNT TAX EXEMPT ASSIGNMENT


DWR_ADDR_LOC

ADDRESS LOCATION


DWR_ADDR_LOC_ADMIN_AREA_ASGN

ADDRESS LOCATION ADMIN AREA ASSIGNMENT


DWR_ADDR_LOC_NAME

ADDRESS LOCATION NAME


DWR_ADDR_PHONE

ADDRESS PHONE


DWR_ADDR_RLTD

ADDRESS RELATED


DWR_ADMINSTVE_AREA

ADMINISTRATIVE AREA


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_AF_SRVC

AF SERVICE


DWR_AGNT

AGENT


DWR_AGGRTN_INTRFC

AGGREGATION INTERFACE


DWR_AGRMNT

AGREEMENT


DWR_AGRMNT_ASGN

AGREEMENT ASSIGNMENT


DWR_AGRMNT_DOC

AGREEMENT DOCUMENT


DWR_AGRMNT_INTNT

AGREEMENT INTENT


DWR_AGRMNT_ITEM

AGREEMENT ITEM


DWR_AGRMNT_PROD_SPEC_ASGN

AGREEMENT PRODUCT SPEC ASSIGNMENT


DWR_AGRMNT_SRVCLVL_AGRMNT_RLTN

AGREEMENT SLA RELATIONSHIP


DWR_ALWNCE_SBRP_PRICE_ALTRTN

ALLOWANCE SBRP PRICE ALTERNATION


DWR_AM_SGMNT_PROD_CPBLTY_RL

ACCESS METHOD SEGMENT PROD CAPABILITY RL


DWR_AMRCN_PRPTY_ADDR

AMERICAN PROPERTY ADDRESS


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_BLLG_CYCL

BILLING CYCLE


DWR_BNK

BANK


DWR_BNK_DRCT_DEBIT_CHNL

BANK DIRECT DEBIT CHANNEL


DWR_BRDBND_RTNG_PLN

BROADBAND RATING PLAN


DWR_BRDBND_SRVC

BROADBAND SERVICE


DWR_BRDGNG_PROTCL

BRIDGING PROTOCOL


DWR_BRND

BRAND


DWR_BROWSER_VRSN

BROWSER VERSION


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_CHAR

BUSINESS INTERACTION CHARACTERISTIC


DWR_BSNS_INTRACN_CHAR_VAL

BUSINESS INTERACTION CHARACTERISTIC VALUE


DWR_BSNS_INTRACN_ITEM_SPEC

BUSINESS INTERACTION ITEM SPECIFICATION


DWR_BSNS_INTRACN_LOC_ASGN

DWR_BSNS_INTRACN_SPEC

BUSINESS INTERACTION SPECIFICATION


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_CFGBL_PROSPCCHAR_PROSPCAGN

CONFIGURABLE PRODSPECCHAR PRODSPEC ASSIGNMENT


DWR_CFGBL_PROD_SPEC_CHAR

CONFIGURABLE PRODUCT SPECIFICATION CHARACTERISTIC


DWR_CFS_SPEC_VRSN_DTL

CFS SPEC VERSION DETAIL


DWR_CHASSIS

CHASSIS


DWR_CHASSIS_POSN

CHASSIS POSITION


DWR_CHNL

CHANNEL


DWR_CLASS_BASEWTD_FAIRQUE_SRVC

CLASS BASE WEIGHTED FAIR QUEUE SERVICE


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_CLNT_HOST

CLIENT HOST


DWR_CLSSIFR_SRVC

CLASSIFIER SERVICE


DWR_CMPGN

CAMPAIGN


DWR_CMPGN_CHAR

CAMPAIGN CHARACTERISTIC


DWR_CMPGN_CHAR_VAL

CAMPAIGN CHARACTERISTIC VALUE


DWR_CMPGN_CHNL

CAMPAIGN CHANNEL


DWR_CMPGN_CHNL_ASGN

CAMPAIGN CHANNEL ASSIGNMENT


DWR_CMPGN_DOC

CAMPAIGN DOCUMENT


DWR_CMPGN_MEDIA

CAMPAIGN MEDIA


DWR_CMPGN_MEDIA_SLNG_ITEM

CAMPAIGN MEDIA SELLING ITEM


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_CNDITNNG_ELMNT

COMPOUND CONDITIONING ELEMENT


DWR_CMPND_RSCE_CMPND_DTL_ASGN

COMPOUND RESOURCE COMPOUND DETAIL ASSIGNMENT


DWR_CMPND_RSCE_COLLCTN

COMPOUND RESOURCE COLLECTION


DWR_CMPND_RSCE_DTL

COMPOUND RESOURCE DETAIL


DWR_CMPND_RSCE_RL

COMPOUND RESOURCE ROLE


DWR_CMPND_RSCE_RL_ASGN

COMPOUND RESOURCE ROLE ASSIGNMENT


DWR_CMPND_RSCE_RL_SPEC

COMPOUND RESOURCE ROLE SPEC


DWR_CMPND_RSCE_SPEC

COMPOUND RESOURCE SPEC


DWR_CMPND_RSCE_SPEC_ATMC

COMPOUND RESOURCE SPEC ATOMIC


DWR_CMPND_RSCE_SPEC_CMPST

COMPOUND RESOURCE SPEC COMPOSITE


DWR_CMPND_RSCE_TP_DTL

COMPOUND RESOURCE TP DETAIL


DWR_CMPND_RSCE_UNIT

COMPOUND RESOURCE UNIT


DWR_CMPND_RSCE

COMPOUND RESOURCE


DWR_CMPST_COMP_PROD_CRL_CHAR

COMPOSITE COMP PROD CRRL CHARACTERISTIC


DWR_CMPST_PROD_SPEC

COMPOSITE PRODUCT SPECIFICATION


DWR_CMPST_PROD_SPEC_ASGN

COMPOSITE PRODUCT SPECIFICATION ASSIGNMENT


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_CMST_PRODOFR_PRC_CMNT_ASGN

COMPOSITE PROD OFFER PRICE COMPONENT ASSIGNMENT


DWR_CMPTVE_TIER

COMPETITIVE TIER


DWR_CNCT_LST

CONTACT LIST


DWR_CNCTN

CONNECTION


DWR_CNCTN_TMNT_PNT

CONNECTION TERMINATION POINT


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_CHAR

COMP INTEL CHARACTERISTIC


DWR_COMP_INTL_CHAR_VAL

COMP INTEL CHARACTERISTIC VALUE


DWR_COMP_INTL_MKT_SGMNT

COMP INTEL MARKET SEGMENT


DWR_COMP_PROD_CRRL_CHAR

COMP PROD CRRL CHARACTERISTIC


DWR_COMP_PROD_CRRL_CHAR_ASGN

COMP PROD CRRL CHARACTERISTIC ASSIGNMENT


DWR_COMP_PROD_CRRL_CHAR_RLTN

COMP PROD CRRL CHARACTERISTIC RELATIONSHIP


DWR_COMP_PROD_CRRL_CHAR_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_CROSSD_THRSHLD

CROSSED THRESHOLD


DWR_CSTM_QUENG_SRVC

CUSTOM QUEUING SERVICE


DWR_CUST

CUSTOMER


DWR_CUST_ACCT

CUSTOMER ACCOUNT


DWR_CUST_ADDR

CUSTOMER ADDRESS


DWR_CUST_AFFLTN

CUSTOMER AFFILIATION


DWR_CUST_CLASS_ASGN

CUSTOMER CLASS ASSIGNMENT


DWR_CUST_CLSTR

CUSTOMER CLUSTER


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

CUSTOMER FACING SERVICE SPECIFICATION


DWR_CUST_FCNG_SRVC_SPEC_ATMC

CUSTOMER FACING SERVICE SPECIFICATION ATOMIC


DWR_CUST_FCNG_SRVC_SPEC_CMPST

CUSTOMER FACING SERVICE SPECIFICATION COMPOSITE


DWR_CUST_FCNG_SRVC_SPEC_RL

CUSTOMER FACING SERVICE SPECIFICATION ROLE


DWR_CUST_FCNG_SRVC_SPEC_VRSN

CUSTOMER FACING SERVICE SPECIFICATION VERSION


DWR_CUST_GRP_ASGN

CUSTOMER GROUP ASSIGNMENT


DWR_CUST_GRP_ITEM

CUSTOMER GROUP ITEM


DWR_CUST_INDVL

CUSTOMER INDIVIDUAL


DWR_CUST_OCCSN

CUSTOMER OCCASION


DWR_CUST_ORDR_DOC

CUSTOMER ORDER DOCUMENT


DWR_CUST_ORG

CUSTOMER ORGANIZATION


DWR_CUST_PREF

CUSTOMER PREFERENCE


DWR_CUST_RLTN

CUSTOMER RELATIONSHIP


DWR_CUST_RSTRCT_INFO

CUSTOMER RESTRICTED INFO


DWR_CUST_RVN_BND_ASGN

CUSTOMER REVENUE BAND ASSIGNMENT


DWR_CUST_SCR

CUSTOMER SCORE


DWR_CUST_SGMNT

CUSTOMER SEGMENT


DWR_CUST_SGMNT_MDL

CUSTOMER SEGMENTATION MODEL


DWR_CUST_SIC_ASGN

CUSTOMER SIC ASSIGNMENT


DWR_CUST_SRC

CUSTOMER SOURCE


DWR_DAY

DAY


DWR_DAY_ACT_CONDITION

DAY ACTUAL CONDITION


DWR_DAY_TODATE_TRANS

DAY TODATE TRANSFORMATION


DWR_DAY_TRANS

DAY TRANSFORMATION


DWR_DEAL

DEAL


DWR_DEAL_LN_ITEM

DEAL LINE ITEM


DWR_DEMOG_ATRIB

DEMOGRAPHY ATTRIBUTE


DWR_DEMOG_CHAR

DEMOGRAPHIC CHARACTERISTIC


DWR_DEMOG_CHAR_VAL

DEMOGRAPHIC CHARACTERISTIC VALUE


DWR_DEMOG_GRP

DEMOGRAPHY GROUP


DWR_DFCT_RND_RBIN_SCHDLNG_SRVC

DEFICIT ROUND ROBIN SCHEDULING SERVICE


DWR_DIFFSERV_SRVC

DIFFSERV SERVICE


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_DOMAIN

DOMAIN


DWR_DRPPR_SRVC

DROPPER SERVICE


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_EF_SRVC

EF SERVICE


DWR_EIGHT_ZERO_TWO_SRVC

802 SERVICE


DWR_EML_ADDR

EMAIL ADDRESS


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_SPEC

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_RNTNG_AGRMNT

EQUIPMENT RENTING AGREEMENT


DWR_EVT_LOC

EVENT LOCATION


DWR_EVT_PRTY_INTRACN_CHAR_VAL

EVENT PARTY INTERACTION CHARACTERISTIC VALUE


DWR_EXCHNG_LOC

EXCHANGE LOCATION


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_FAIR_QUENG_SRVC

FAIR QUEUING SERVICE


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_CHAR

FLEXIBLE CHARACTERISTIC


DWR_FXBLE_CHAR_ASGN

FLEXIBLE CHARACTERISTIC ASSIGNMENT


DWR_FXBLE_CHAR_RLTN

FLEXIBLE CHARACTERISTIC RELATIONSHIP


DWR_FXBLE_CHAR_VAL

FLEXIBLE CHARACTERISTIC VALUE


DWR_FXBLE_CHAR_VAL_ASGN

FLEXIBLE CHARACTERISTIC VALUE ASSIGNMENT


DWR_FXBLE_CHAR_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_SPEC_SGMNT

GL PRODUCT SPECIFICATION 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_HEAD_TAIL_DRPPR_SRVC

HEAD TAIL DROPPER 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_INSTLMNT_AGRMNT

INSTALLMENT AGREEMENT


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 NAVIGATION TYPE VERSION


DWR_INV_LOC

INVENTORY LOCATION


DWR_INVC_ADJ_QTA

INVOICE ADJUSTMENT QUOTA


DWR_INVC_PRCS_ASGN

INVOICE PROCESS ASSIGNMENT


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_CLASS

ITEM CLASS


DWR_ITEM_CLSTR

ITEM CLUSTER


DWR_ITEM_CMPNY

ITEM COMPANY


DWR_ITEM_DEPT

ITEM DEPARTMENT


DWR_ITEM_DIV

ITEM DIVISION


DWR_ITEM_GRP

ITEM GROUP


DWR_ITEM_SBC

ITEM SUBCLASS


DWR_ITEM_SPEC

ITEM SPECIFICATION


DWR_IVR_MENU_CNTNT

IVR MENU CONTENT


DWR_IVR_MENU_ITEM

IVR MENU ITEM


DWR_JB

JOB


DWR_JB_RL

JOB ROLE


DWR_JUR

JURISDICTION


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_DVC_SPEC

LOGICAL DEVICE SPECIFICATION


DWR_LGICL_INTRFC

LOGICAL INTERFACE


DWR_LGICL_RSCE

LOGICAL RESOURCE


DWR_LGICL_RSCE_PHY_SPPRT

LOGICAL RESOURCE PHYSICAL SUPPORT


DWR_LGICL_RSCE_RL

LOGICAL RESOURCE ROLE


DWR_LGICL_RSCE_RL_ASGN

LOGICAL RESOURCE ROLE ASSIGNMENT


DWR_LGICL_RSCE_RL_SPEC

LOGICAL RESOURCE ROLE SPECIFICATION


DWR_LGICL_RSCE_SPEC

LOGICAL RESOURCE SPECIFICATION


DWR_LGICL_RSCE_SPEC_ATMC

LOGICAL RESOURCE SPEC ATOMIC


DWR_LGICL_RSCE_SPEC_CMPST

LOGICAL RESOURCE SPEC COMPOSITE


DWR_LGICL_RSCE_SPEC_PHY_SPPRT

LOGICAL RESOURCE SPEC PHYSICAL SUPPORT


DWR_LGICL_RSCE_SPEC_VRSN

LOGICAL RESOURCE SPEC VERSION


DWR_LYLTY_PROG

LOYALTY PROGRAM


DWR_LYLTY_TIER

LOYALTY TIER


DWR_LYLTY_TIER_CLASS

LOYALTY TIER CLASS


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_MBRSHIP_ACCT

MEMBERSHIP ACCOUNT


DWR_MDIA_ITRFC_LGL_INTRFC_ASGN

MEDIA INTERFACE LOGICAL INTERFACE ASSIGNMENT


DWR_MEDIA_INTRFC

MEDIA INTERFACE


DWR_MEDIA_OBJ

MEDIA OBJECT


DWR_MEDIA_OBJ_ASGN

MEDIA OBJECT ASSIGNMENT


DWR_MGMT_DOMAIN

MANAGEMENT DOMAIN


MANAGEMENT INFORMATION


DWR_MGMT_PROTCL

MANAGEMENT PROTOCOL


DWR_MKT_AREA

MARKET AREA


DWR_MKT_AREA_LVL

MARKET AREA LEVEL


DWR_MKT_SGMNT

MARKET SEGMENT


DWR_MKT_SGMNT_CHAR

MARKET SEGMENT CHARACTERISTIC


DWR_MKT_SGMNT_CHAR_VAL

MARKET SEGMENT CHARACTERISTIC VALUE


DWR_MKT_STTSTCS

MARKET STATISTICS


DWR_MMS_SRVC

MMS SERVICE


DWR_MNITRD_CLASS_CRTRA

MONITORED CLASS CRITERIA


DWR_MNITRD_INSTNCS_CRTRA

MONITORED INSTANCES CRITERIA


DWR_MNITRD_OBJS_CRTRA

MONITORED OBJECTS CRITERIA


DWR_MNT

MINUTE


DWR_MO_TODATE_TRANS

MONTH TODATE TRANSFORMATION


DWR_MO_TRANS

MONTH TRANSFORMATION


DWR_MRKR_POOL

MARKER POOL


DWR_MRKR_SRVC

MARKER SERVICE


DWR_MRKR_SRVC_MRKR_POOL_ASGN

MARKER SERVICE MARKER POOL ASSIGNMENT


DWR_MSRMNT_JB

MEASUREMENT JOB


DWR_MTR_PRFL

METER PROFILE


DWR_MTR_SRVC

METER SERVICE


DWR_MTR_SRVC_PRFL_ASGN

METER SERVICE PROFILE ASSIGNMENT


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_FRWRDNG_SRVC

NETWORK FORWARDING SERVICE


DWR_NTWK_ROUTE

NETWORK ROUTE


DWR_NTWK_ROUTE_PNT

NETWORK ROUTE POINT


DWR_NTWK_ROUTE_PNT_ASGN

NETWORK ROUTE POINT ASSIGNMENT


DWR_NTWK_ROUTE_SECTN

NETWORK ROUTE SECTION


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_ORG

ORGANIZATION


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_P_LGICL_DVC_RL

P LOGICAL DEVICE ROLE


DWR_PASPRT

PASSPORT


DWR_PBLCTN

PUBLICATION


DWR_PDSPC_CHRVL_RESPC_CHRVL_AN

PRODUCT SPEC CHAR VAL RESOURCE SPEC CHAR VAL ASSIGNMENT


DWR_PE_LGICL_DVC_RL

PE LOGICAL DEVICE ROLE


DWR_PG

PAGE


DWR_PHONE_NBR

PHONE NUMBER


DWR_PHONE_NBR_POOL

PHONE NUMBER POOL


DWR_PHS

PHASE


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_EQPMNT

PHYSICAL EQUIPMENT


DWR_PHY_LNK

PHYSICAL LINK


DWR_PHY_PRT

PHYSICAL PORT


DWR_PHY_PRT_RSCE_PRT_ASGN

PHYSICAL PORT RESOURCE PORT ASSIGNMENT


DWR_PHY_RSCE

PHYSICAL RESOURCE


DWR_PHY_RSCE_ADDR

PHYSICAL RESOURCE ADDRESS


DWR_PHY_RSCE_CHAR

PHYSICAL RESOURCE CHARACTERISTIC


DWR_PHY_RSCE_PROD_SBRP

PHYSICAL RESOURCE PRODUCT SUBSCRIPTION


DWR_PHY_RSCE_RL

PHYSICAL RESOURCE ROLE


DWR_PHY_RSCE_RL_ASGN

PHYSICAL RESOURCE ROLE ASSIGNMENT


DWR_PHY_RSCE_RL_SPEC

PHYSICAL RESOURCE ROLE SPECIFICATION


DWR_PHY_RSCE_RL_SPEC_DTL

PHYSICAL RESOURCE ROLE SPECIFICATION DETAIL


DWR_PHY_RSCE_SPEC

PHYSICAL RESOURCE SPECIFICATION


DWR_PHY_RSCE_SPEC_ATMC

PHYSICAL RESOURCE SPECIFICATION ATOMIC


DWR_PHY_RSCE_SPEC_CMPST

PHYSICAL RESOURCE SPECIFICATION COMPOSITE


DWR_PIPE

PIPE


DWR_PIT_CHAR

PIT CHARACTERISTIC


DWR_PLCIR_SRVC

POLICIER SERVICE


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_CNDTN_TIME_PRD

POLICY CONDITION TIME PERIOD


DWR_PLCY_CNDTN_VNDR

POLICY CONDITION VENDOR


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_PNT_BLCK

POINT BLOCK


DWR_PNT_CD

POINT CODE


DWR_POS_DEPT

POINT OF SALE DEPARTMENT


DWR_POSTCD

POSTCODE


DWR_PRAMBL_MRKNG_DTLS_ASGN

PREAMBLE MARKING DETAILS ASSIGNMENT


DWR_PRAMBL_MRKR_SRVC

PREAMBLE MARKER SERVICE


DWR_PRBLM_TRBLE_TCKT_ASGN

PROBLEM TROUBLE TICKET ASSIGNMENT


DWR_PRCS

PROCESS


DWR_PRCE_EVT_PRODOFR_PRCE_ASGN

PROCESS EVENT PRODUCT OFFER PRICE ASSIGNMENT


DWR_PRCS_EVT_ASGN

PROCESS EVENT ASSIGNMENT


DWR_PRCS_PRMTR

PROCESS PARAMETER


DWR_PRCS_PRMTR_ASGN

PROCESS PARAMETER ASSIGNMENT


DWR_PRCS_PRMTR_VAL

PROCESS PARAMETER VALUE


DWR_PRCS_RLTN

PROCESS RELATIONSHIP


DWR_PRCS_SPEC

PROCESS SPECIFICATION


DWR_PRCS_SPEC_RLTN

PROCESS SPECIFICATION RELATIONSHIP


DWR_PRD_TODATE_TRANS

PERIOD TO DATE TRANSFORMATION


DWR_PRD_TRANS

PERIOD TRANSFORMATION


DWR_PRDSPC_CHR_RSCESPC_CHR_AGN

PRODUCT SPEC CHAR RESOURCE SPEC CHAR ASSIGNMENT


DWR_PRFMNC_APLBLETY

PERFORMANCE APPLICABILITY


DWR_PRFMNC_CAT_CHAR_VAL

PERFORMANCE CAT CHARACTERISTIC VALUE


DWR_PRFMNC_CAT_SPEC

PERFORMANCE CAT SPECIFICATION


DWR_PRFMNC_CAT_SPEC_RLTN

PERFORMANCE CAT SPEC RELATIONSHIP


DWR_PRFMNC_CHAR_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_SPEC_RLTN

PERFORMANCE INDICATOR SPEC RELATIONSHIP


DWR_PRFMNC_IND_SPEC

PERFORMANCE INDICATOR SPECIFICATION


DWR_PRFMNC_IP_ADDR

PERFORMANCE IP ADDRESS


DWR_PRFMNC_NTFCTN_SPEC

PERFORMANCE NOTIFICATION SPECIFICATION


DWR_PRFMNC_NTWK_ADDR

PERFORMANCE NETWORK ADDRESS


DWR_PRFMNC_OBJ_APLBLETY_CNSEQ

PERFORMANCE OBJECTIVE APPLICABILITY CONSEQUENCE


DWR_PRFMNC_OBJCTV

PERFORMANCE OBJECTIVE


DWR_PRFMNC_OBJCTV_APLBLETY

PERFORMANCE OBJECTIVE APPLICABILITY


DWR_PRFMNC_PNT_CD

PERFORMANCE POINT CODE


DWR_PRFMNC_SPEC

PERFORMANCE SPECIFICATION


DWR_PRFMNC_SPEC_INTRVL_CNVRSN

PERFORMANCE SPEC INTERVAL CONVERSION


DWR_PRFMNC_SPEC_INTRVL

PERFORMANCE SPECIFICATION INTERVAL


DWR_PRICE_DRVTN_RULE

PRICE DERIVATION RULE


DWR_PRICE_TYP_RLTN

PRICE TYPE RELATIONSHIP


DWR_PRIORITY_QUENG_SRVC

PRIORITY QUEUING SERVICE


DWR_PRMTN

PROMOTION


DWR_PRMTN_MSG_RNDRNG

PROMOTION MESSAGE RENDERING


DWR_PRMTN_PROD_CTLG_ASGN

PROMOTION PRODUCT CATALOG ASSIGNMENT


DWR_PRMTN_PROD_OFR_ASGN

PROMOTION PRODUCT OFFERING ASSIGNMENT


DWR_PRMTN_RLTN

PROMOTION RELATIONSHIP


DWR_PRMTN_SL_CHNL_ASGN

PROMOTION SALES CHANNEL ASSIGNMENT


DWR_PROD

PRODUCT


DWR_PRODOFR_PRODOFR_PRICE_ASGN

PRODUCT OFFERING PRODUCT OFFERING PRICE ASSIGNMENT


DWR_PROD_CAPBLTY

PRODUCT CAPABILITY


DWR_PROD_CAPBLTY_VAL

PRODUCT CAPABILITY VALUE


DWR_PROD_CHAR_VAL

PRODUCT CHARACTERISTIC VALUE


DWR_PROD_COVRG_AREA

PRODUCT COVERAGE AREA


DWR_PROD_COVRG_GEO_DTL

PRODUCT SPECIFICATION COVERAGE GEO DETAIL


DWR_PROD_CTLG

PRODUCT CATALOG


DWR_PROD_CTLG_CHAR

PRODUCT CATALOG CHARACTERISTIC


DWR_PROD_CTLG_CHAR_ASGN

PRODUCT CATALOG CHARACTERISTIC ASSIGNMENT


DWR_PROD_CTLG_CHAR_RLTN

PRODUCT CATALOG CHARACTERISTIC RELATIONSHIP


DWR_PROD_CTLG_CHAR_VAL

PRODUCT CATALOG CHARACTERISTIC VALUE


DWR_PROD_CTLG_CHAR_VAL_ASGN

PRODUCT CATALOG CHARACTERISTIC VALUE ASSIGNMENT


DWR_PROD_CTLG_CHAR_VAL_RLTN

PRODUCT CATALOG CHARACTERISTIC VALUE RELATIONSHIP


DWR_PROD_CTLG_GEO_ASGN

PRODUCT CATALOG GEOGRAPHY ASSIGNMENT


DWR_PROD_CTLG_PROD_OFR_ASGN

PRODUCT CATALOG PRODUCT OFFERING ASSIGNMENT


DWR_PROD_CTLG_SL_CHNL_ASGN

PRODUCT CATALOG SALES CHANNEL ASSIGNMENT


DWR_PROD_FNCTNLTY_DPNDNTCY

PRODUCT FUNCTIONALITY DEPENDENCY


DWR_PROD_GEO_ASGN

PRODUCT GEOGRAPHY ASSIGNMENT


DWR_PROD_OFR

PRODUCT OFFERING


DWR_PROD_OFR_AVLBLTY

PRODUCT OFFERING AVAILABILITY


DWR_PROD_OFR_DOC_REQRMNT

PRODUCT OFFERING DOCUMENT REQUIREMENT


DWR_PROD_OFR_GEO_ASGN

PRODUCT OFFERING GEOGRAPHY ASSIGNMENT


DWR_PROD_OFR_GRP

PRODUCT OFFERING GROUP


DWR_PROD_OFR_GRP_ASGN

PRODUCT OFFERING GROUP ASSIGNMENT


DWR_PROD_OFR_MKT_SGMNT_AVLBLTY

PRODUCT OFFERING MARKET SEGMENT AVAILABILITY


DWR_PROD_OFR_ORG_AVLBLTY

PRODUCT OFFERING ORGANIZATION AVAILABILITY


DWR_PROD_OFR_PRICE

PRODUCT OFFERING PRICE


DWR_PROD_OFR_PRICE_CMPNT

PRODUCT OFFERING PRICE COMPONENT


DWR_PROD_OFR_PRICE_CMPST

PRODUCT OFFERING PRICE COMPOSITE


DWR_PROD_OFR_PRICE_PLCY_ACTN

PRODUCT OFFERING PRICE POLICY ACTION


DWR_PROD_OFR_PRICE_PLCY_CNDTN

PRODUCT OFFERING PRICE POLICY CONDITION


DWR_PROD_OFR_PRICE_PLCY_VAL

PRODUCT OFFERING PRICE POLICY VALUE


DWR_PROD_OFR_PRICE_PLCY_VAR

PRODUCT OFFERING PRICE POLICY VARIABLE


DWR_PROD_OFR_PRICE_RCRNG

PRODUCT OFFERING PRICE RECURRING


DWR_PROD_OFR_PRICE_RLTN

PRODUCT OFFERING PRICE RELATIONSHIP


DWR_PROD_OFR_PROD_ASGN

PRODUCT OFFERING PRODUCT ASSIGNMENT


DWR_PROD_OFR_PROD_SPEC_ASGN

PRODUCT OFFERING PRODUCT SPECIFICATION ASSIGNMENT


DWR_PROD_OFR_RLTN

PRODUCT OFFERING RELATIONSHIP


DWR_PROD_OFR_RTNG_PLN

PRODUCT OFFERING RATING PLAN


DWR_PROD_OFR_RTNG_PLN_DTL

PRODUCT OFFERING RATING PLAN DETAIL


DWR_PROD_OFR_SUB_BY_DOC

PRODUCT OFFERING SUBSTITUTE BY DOC


DWR_PROD_OFR_TERM

PRODUCT OFFERING TERM


DWR_PROD_PRICE_ALTRTN

PRODUCT PRICE ALTERATION


DWR_PROD_PRICE_CMPNT

PRODUCT PRICE COMPONENT


DWR_PROD_PRICE_PRTY_RL

PRODUCT PRICE PARTY ROLE


DWR_PROD_PROD_CAPBLTY_VAL_ASGN

PRODUCT PRODUCT CAPABILITY VALUE ASSIGNMENT


DWR_PROD_RLTN

PRODUCT RELATIONSHIP


DWR_PROD_SBRP

PRODUCT SUBSCRIPTION


DWR_PROD_SBRP_ASGN

PRODUCT SUBSCRIPTION ASSIGNMENT


DWR_PROD_SBRP_PRICE

PRODUCT SUBSCRIPTION PRICE


DWR_PROD_SBRP_PRICE_RLTN

PRODUCT SUBSCRIPTION PRICE RELATIONSHIP


DWR_PROD_SBRP_PRODOFRPRIE_ASGN

PRODUCT SUBSCRIPTION PRODUCT OFFERING PRICE ASSIGNMENT


DWR_PROD_SPEC

PRODUCT SPECIFICATION


DWR_PROD_SPEC_ADTNL_TXT

PRODUCT SPECIFICATION ADDITIONAL TEXT


DWR_PROD_SPEC_CHAR

PRODUCT SPECIFICATION CHARACTERISTIC


DWR_PROD_SPEC_CHAR_CFG_ASGN

PRODUCT SPECIFICATION CHARACTERISTIC CONFIGURABLE ASSIGNMENT


DWR_PROD_SPEC_CHAR_RLTN

PRODUCT SPECIFICATION CHARACTERISTIC RELATIONSHIP


DWR_PROD_SPEC_CHAR_USE

PRODUCT SPECIFICATION CHARACTERISTIC USE


DWR_PROD_SPEC_CHAR_VAL

PRODUCT SPECIFICATION CHARACTERISTIC VALUE


DWR_PROD_SPEC_CHAR_VAL_RLTN

PRODUCT SPECIFICATION CHARACTERISTIC VALUE RELATIONSHIP


DWR_PROD_SPEC_CHAR_VAL_USE

PRODUCT SPECIFICATION CHARACTERISTIC VALUE USE


DWR_PROD_SPEC_GRP_ASGN

PRODUCT SPECIFICATION GROUP ASSIGNMENT


DWR_PROD_SPEC_HIST

PRODUCT SPECIFICATION HISTORY


DWR_PROD_SPEC_NTWK_ASGN

PRODUCT SPECIFICATION NETWORK ASSIGNMENT


DWR_PROD_SPEC_RLTN

PRODUCT SPECIFICATION RELATIONSHIP


DWR_PROD_SPEC_VRSN

PRODUCT SPECIFICATION VERSION


DWR_PROD_USRNM

PRODUCT USERNAME


DWR_PROJ

PROJECT


DWR_PROJ_ELMNT

PROJECT ELEMENT


DWR_PROPOSAL

PROPOSAL


DWR_PROPOSAL_RLTN

PROPOSAL RELATIONSHIP


DWR_PROTCL

PROTOCOL


DWR_PRPD_VCHR

PREPAID VOUCHER


DWR_PRPD_VCHR_BTCH

PREPAID VOUCHER BATCH


DWR_PRPD_VCHR_RCHRG_OPTN

PREPAID VOUCHER RECHARGE OPTION


DWR_PRPD_VCHR_SPEC

PREPAID VOUCHER SPECIFICATION


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_PRSPCT_RSTRCT_INFO

PROSPECT RESTRICTED INFORMATION


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_AGRMNT_ASGN

PARTY AGREEMENT ASSIGNMENT


DWR_PRTY_ASGN

PARTY ASSIGNMENT


DWR_PRTY_BSNS_INTRACN_RL

PARTY BUSINESS INTERACTION ROLE


DWR_PRTY_CNCT_INFO

PARTY CONTACT INFORMATION


DWR_PRTY_DEMOG

PARTY DEMOGRAPHIC


DWR_PRTY_DEMOG_VAL

PARTY DEMOGRAPHIC VALUE


DWR_PRTY_GEO_ENT_ASGN

PARTY GEOGRAPHY ENTITY ASSIGNMENT


DWR_PRTY_ID

PARTY IDENTIFICATION


DWR_PRTY_LANG_CAPBLTY

PARTY LANGUAGE CAPABILITY


DWR_PRTY_MKT_SGMNT_ASGN

PARTY MARKET SEGMENT ASSIGNMENT


DWR_PRTY_NAME

PARTY NAME


DWR_PRTY_PRFL

PARTY PROFILE


DWR_PRTY_PRFL_CHAR_ASGN

PARTY PROFILE CHAR ASSIGNMENT


DWR_PRTY_PRFL_TYP_CHAR

PARTY PROFILE TYPE CHARACTERISTIC


DWR_PRTY_PRFL_TYP_CHAR_VAL

PARTY PROFILE TYPE CHARACTERISTIC VALUE


DWR_PRTY_PROD_SBRP_ASGN

PARTY PRODUCT SUBSCRIPTION ASSIGNMENT


DWR_PRTY_RL_ASGN

PARTY ROLE ASSIGNMENT


DWR_PRTY_RL_CTGRY_ASGN

PARTY ROLE CATEGORY ASSIGNMENT


DWR_PRTY_RL_OS_PRCS_ASGN

PARTY ROLE OS PROCESS ASSIGNMENT


DWR_PRTY_RL_PRFL_ASGN

PARTY ROLE PROFILE ASSIGNMENT


DWR_PRTY_RL_STAT

PARTY ROLE STATUS


DWR_PRTY_SIM_CARD_ASGN

PARTY SIM CARD ASSIGNMENT


DWR_PRTY_SKILL

PARTY SKILL


DWR_PRTY_SRVC_ASGN

PARTY SERVICE ASSIGNMENT


DWR_PTS_EXPRY_BASIS

POINTS EXPIRY BASIS


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_MAC_ADDR_VAL

PV MAC ADDRESS VALUE


DWR_PV_STRING_VAL

PV STRING VALUE


DWR_PVAR_1QCOS_VARBLE

PVAR 1QCOS VARIABLE


DWR_PVAR_BIT_STRING_VARBLE

PVAR BIT STRING VARIABLE


DWR_PVAR_DN_VARBLE

PVAR DN VARIABLE


DWR_PVAR_DSCP_VARBLE

PVAR DSCP VARIABLE


DWR_PVAR_ETHER_TYP_VARBLE

PVAR ETHER TYPE VARIABLE


DWR_PVAR_IPTOS_VARBLE

PVAR IPTOS VARIABLE


DWR_PVAR_IPV4_VARBLE

PVAR IPV4 VARIABLE


DWR_PVAR_IPV6_FLOW_ID_VARBLE

PVAR IPV6 FLOW VARIABLE


DWR_PVAR_IPV6_VARBLE

PVAR IPV6 VARIABLE


DWR_PVAR_IPVRSN_VARBLE

PVAR IPVERSION VARIABLE


DWR_PVAR_IP_PROTCL_VARBLE

PVAR IP PROTOCOL VARIABLE


DWR_PVAR_MAC_VARBLE

PVAR MAC VARIABLE


DWR_PVAR_PRT_VARBLE

PVAR PORT VARIABLE


DWR_PVAR_STRING_VARBLE

PVAR STRING VARIABLE


DWR_PVAR_VLAN_VARBLE

PVAR VLAN VARIABLE


DWR_PYMT_CHNL

PAYMENT CHANNEL


DWR_PYMT_PLN

PAYMENT PLAN


DWR_PYTV_SRVC

PAY TV SERVICE


DWR_QOS_SRVC

QOS SERVICE


DWR_QOS_SRVC_RLTN

QOS SERVICE RELATIONSHIP


DWR_QUE_SRVC

QUEUE SERVICE


DWR_QTR_HR

QUARTER HOUR


DWR_QTR_TODATE_TRANS

QUARTER TO DATE TRANSFORMATION


DWR_QTR_TRANS

QUARTER TRANSFORMATION


DWR_RACK

RACK


DWR_RED_DRPPR_SRVC

RED DROPPER SERVICE


DWR_RED_SRVC_ELMNT

RED SERVICE ELEMENT


DWR_REFERRING_CTGRY

REFERRING CATEGORY


DWR_REFERRING_CTGRY_LVL

REFERRING CATEGORY LEVEL


DWR_REFERRING_URL

REFERRING URL


DWR_RF_CARRIER

RF CARRIER


DWR_RFS_SPEC_VRSN_DTL

RFS SPEC VERSION DETAIL


DWR_RL

ROLE


DWR_RLS_HRCHY

ROLES HIERARCHY


DWR_RND_RBIN_SCHDLNG_SRVC

ROUND ROBIN SCHEDULING SERVICE


DWR_RNGTN

RINGTONE


DWR_ROOT_ENT

ROOT ENTITY


DWR_ROUTED_PROTCL

ROUTED PROTOCOL


DWR_ROUTER

ROUTER


DWR_RPLCMT_SET

REPLACEMENT SET


DWR_RSCE

RESOURCE


DWR_RSCE_CHAR

RESOURCE CHARACTERISTIC


DWR_RSCE_CHAR_ASGN

RESOURCE CHARACTERISTIC ASSIGNMENT


DWR_RSCE_CHAR_RLTN

RESOURCE CHARACTERISTIC RELATIONSHIP


DWR_RSCE_CHAR_VAL

RESOURCE CHARACTERISTIC VALUE


DWR_RSCE_CHAR_VAL_ASGN

RESOURCE CHARACTERISTIC VALUE ASSIGNMENT


DWR_RSCE_CHAR_VAL_RLTN

RESOURCE CHARACTERISTIC VALUE RELATIONSHIP


DWR_RSCE_FCNG_SRVC

RESOURCE FACING SERVICE


DWR_RSCE_FCNG_SRVC_RL

RESOURCE FACING SERVICE ROLE


DWR_RSCE_FCNG_SRVC_SPEC

RESOURCE FACING SERVICE SPECIFICATION


DWR_RSCE_FCNG_SRVC_SPEC_ATMC

RESOURCE FACING SERVICE SPECIFICATION ATOMIC


DWR_RSCE_FCNG_SRVC_SPEC_CMPST

RESOURCE FACING SERVICE SPECIFICATION COMPOSITE


DWR_RSCE_FCNG_SRVC_SPEC_RL

RESOURCE FACING SERVICE SPECIFICATION ROLE


DWR_RSCE_FCNG_SRVC_SPEC_VRSN

RESOURCE FACING SERVICE SPEC VERSION


DWR_RSCE_INVLMNT_RL

RESOURCE INVOLVEMENT ROLE


DWR_RSCE_PRFMNC_SPEC

RESOURCE PERFORMANCE SPEC


DWR_RSCE_PRT

RESOURCE PORT


DWR_RSCE_PRTY_ASSOCTN

RESOURCE PARTY ASSOCIATION


DWR_RSCE_PRTY_MGMT

RESOURCE PARTY MANAGEMENT


DWR_RSCE_RL

RESOURCE ROLE


DWR_RSCE_RL_ASGN

RESOURCE ROLE ASSIGNMENT


DWR_RSCE_RL_PRTY_ASGN

RESOURCE ROLE PARTY ASSIGNMENT


DWR_RSCE_RL_PRTY_RL_DTLS

RESOURCE ROLE PARTY ROLE DETAILS


DWR_RSCE_RL_SPEC

RESOURCE ROLE SPECIFICATION


DWR_RSCE_RLTN

RESOURCE RELATIONSHIP


DWR_RSCE_SPEC

RESOURCE SPECIFICATION


DWR_RSCE_SPEC_CHAR

RESOURCE SPECIFICATION CHARACTERISTIC


DWR_RSCE_SPEC_CHAR_ASGN

RESOURCE SPECIFICATION CHARACTERISTIC ASSIGNMENT


DWR_RSCE_SPEC_CHAR_RLTN

RESOURCE SPECIFICATION CHARACTERISTIC RELATIONSHIP


DWR_RSCE_SPEC_CHAR_VAL

RESOURCE SPECIFICATION CHARACTERISTIC VALUE


DWR_RSCE_SPEC_CHAR_VAL_ASGN

RESOURCE SPECIFICATION CHARACTERISTIC VALUE ASSIGNMENT


DWR_RSCE_SPEC_CHAR_VAL_RLTN

RESOURCE SPECIFICATION CHARACTERISTIC VALUE RELATIONSHIP


DWR_RSCE_SPEC_PERF_RL

RESOURCE SPECIFICATION PERF ROLE


DWR_RSCE_SPEC_VRSN

RESOURCE SPECIFICATION VERSION


DWR_RSCE_SPEC_VRSN_USG

RESOURCE SPECIFICATION VERSION USAGE


DWR_RTL_STORE

RETAIL STORE


DWR_RTL_TCHPNT

RETAIL TOUCHPOINT


DWR_RUTNG_DVC

ROUTING DEVICE


DWR_RUTNG_PROTCL

ROUTING PROTOCOL


DWR_RUTNG_RL

ROUTING ROLE


DWR_SB_NTWK

SUB NETWORK


DWR_SBRP_RSCE_RL_ASGN

SUBSCRIPTION RESOURCE ROLE ASSIGNMENT


DWR_SBRP_SRVC_ASGN

SUBSCRIPTION SERVICE ASSIGNMENT


DWR_SBRP_SRVC_CLASS_ASGN

SUBSCRIPTION SERVICE CLASS ASSIGNMENT


DWR_SCHDLNG_SRVC

SCHEDULING SERVICE


DWR_SCHDLNG_SRVC_ATMC

SCHEDULING SERVICE ATOMIC


DWR_SCHDLNG_SRVC_CMPST

SCHEDULING SERVICE COMPOSITE


DWR_SCND

SECOND


DWR_SCRPT

SCRIPT


DWR_SCRPT_QUES

SCRIPT QUESTION


DWR_SEARCH

SEARCH


DWR_SECURE_HLDR

SECURE HOLDER


DWR_SERVER

SERVER


DWR_SERVER_FARM

SERVER FARM


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_SHPR_SRVC

SHAPER SERVICE


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_PROD_SBRP_ASGN

SIM CARD PRODUCT SUBSCRIPTION ASSIGNMENT


DWR_SITE

SITE


DWR_SITE_INTRFC_RL

SITE INTERFACE ROLE


DWR_SITE_RL

SITE ROLE


DWR_SKU_ITEM

SKU ITEM


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_RTNG_PLN

SMS RATING PLAN


DWR_SMS_SRVC

SMS SERVICE


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_SPEC

SPECIFICATION


DWR_SPEC_RL

SPECIFICATION ROLE


DWR_SPLMNTR_SRVC

SUPPLEMENTARY SERVICE


DWR_SPNM_OTHR_PRTY_NBR</p>

SPNM OTHER PARTY NUMBER


DWR_SPTRUM_COVRG_AREA

SPECTRUM COVERAGE AREA


DWR_SRC_SYS

SOURCE SYSTEM


DWR_SRC_SYS_KEY_MAPPING

SOURCE SYSTEM KEY MAPPING


DWR_SRSPC_CHRVL_RESPC_CHRVL_AN

SERVICE SPECIFICATION CHAR VAL RESOURCE SPEC CHAR VAL ASSIGNMENT


DWR_SRVC

SERVICE


DWR_SRVC_ADDR_LOC_ASGN

SERVICE ADDRESS LOCATION ASSIGNMENT


DWR_SRVC_BNDL

SERVICE BUNDLE


DWR_SRVC_BNDL_SPEC

SERVICE BUNDLE SPECIFICATION


DWR_SRVC_BNDL_SPEC_ATMC

SERVICE BUNDLE SPECIFICATION ATOMIC


DWR_SRVC_BNDL_SPEC_CMPST

SERVICE BUNDLE SPECIFICATION COMPOSITE


DWR_SRVC_CHAR_VAL

SERVICE CHARACTERISTIC VALUE


DWR_SRVC_CHAR_VAL_RLTN

SERVICE CHARACTERISTIC VALUE RELATIONSHIP


DWR_SRVC_CHRVL_PROD_CHRVL_ASGN

SERVICE CHARACTERISTIC VALUE PRODUCT CHARACTERISTIC VALUE ASSIGNMENT


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_AGRMNT_RLTN

SERVICE LEVEL AGREEMENT RELATIONSHIP


DWR_SRVC_LVL_OBJCTV

SERVICE LEVEL OBJECTIVE


DWR_SRVC_LVL_SPEC_APLCBLTY

SERVICE LEVEL SPEC APPLICABILITY


DWR_SRVC_LVL_SPEC_CNSEQ

SERVICE LEVEL SPEC CONSEQUENCE


DWR_SRVC_LVL_SPEC_PRMTR

SERVICE LEVEL SPEC PARAMETER


DWR_SRVC_PKG

SERVICE PACKAGE


DWR_SRVC_PKG_BNDL_DTL

SERVICE PACKAGE BUNDLE DETAIL


DWR_SRVC_PKG_SPEC

SERVICE PACKAGE SPECIFICATION


DWR_SRVC_PKG_SPEC_ATMC

SERVICE PACKAGE SPECIFICATION ATOMIC


DWR_SRVC_PKG_SPEC_CMPST

SERVICE PACKAGE SPECIFICATION COMPOSITE


DWR_SRVC_PR_DPNDCY

SERVICE PR DEPENDENCY


DWR_SRVC_PRBLM_CHAR

SERVICE PROBLEM CHARACTERISTIC


DWR_SRVC_PRBLM_CHAR_VAL

SERVICE PROBLEM CHARACTERISTIC VALUE


DWR_SRVC_PRFMNC_SPEC

SERVICE PERFORMANCE SPEC


DWR_SRVC_PRTY_MGMT_HIST

SERVICE PARTY MANAGEMENT HISTORY


DWR_SRVC_RL

SERVICE ROLE


DWR_SRVC_RSCE_ASGN

SERVICE RESOURCE ASSIGNMENT


DWR_SRVC_SPEC

SERVICE SPECIFICATION


DWR_SRVC_SPEC_ATMC

SERVICE SPECIFICATION ATOMIC


DWR_SRVC_SPEC_CHAR

SERVICE SPECIFICATION CHARACTERISTIC


DWR_SRVC_SPEC_CHAR_RLTN

SERVICE SPECIFICATION CHARACTERISTIC RELATIONSHIP


DWR_SRVC_SPEC_CHAR_USE

SERVICE SPECIFICATION CHAR USE


DWR_SRVC_SPEC_CHAR_VAL

SERVICE SPECIFICATION CHARACTERISTIC VALUE


DWR_SRVC_SPEC_CHAR_VAL_ASGN

SERVICE SPECIFICATION CHARACTERISTIC VALUE ASSIGNMENT


DWR_SRVC_SPEC_CHAR_VAL_RLTN

SERVICE SPECIFICATION CHAR VALUE RELATIONSHIP


DWR_SRVC_SPEC_CHAR_VAL_USE

SERVICE SPECIFICATION CHAR VALUE USE


DWR_SRVC_SPEC_CMPST

SERVICE SPECIFICATION COMPOSITE


DWR_SRVC_SPEC_PROD_SPEC_RLTN

SERVICE SPECIFICATION PRODUCT SPECIFICATION RELATIONSHIP


DWR_SRVC_SPEC_RLTN

SERVICE SPECIFICATION RELATIONSHIP


DWR_SRVC_SPEC_RL

SERVICE SPECIFICATION ROLE


DWR_SRVC_SPEC_RSCE_SPEC_RLTN

SERVICE SPECIFICATION RESOURCE SPEC RELATIONSHIP


DWR_SRVC_SPEC_VRSN

SERVICE SPECIFICATION VERSION


DWR_SRVC_UTLZTN_DTL

SERVICE UTILIZATION DETAIL


DWR_SRVSPC_CHR_RSCESPC_CHR_AGN

SERVICE SPECIFICATION CHAR RESOURCE SPEC CHAR ASSIGNMENT


DWR_STNDRD_MRKR_SRVC

STANDARD MARKER SERVICE


DWR_STRCT_SCHDLNG_SRVC

STRICT SCHEDULING SERVICE


DWR_STRT_NAME

STREET NAME


DWR_STRT_SGMNT

STREET SEGMENT


DWR_STRT_SGMNT_ADDR_ASGN

STREET SEGMENT ADDRESS ASSIGNMENT


DWR_STTSTCL_ENT

STATISTICAL ENTITY


DWR_SURVEY

SURVEY


DWR_SWTCH

SWITCH


DWR_SWTCH_CAPBLTY

SWITCH CAPABILITY


DWR_SWTCH_CMMND

SWITCH COMMAND


DWR_SWTCH_RUTNG_DVC_ASGN

SWITCH ROUTING DEVICE ASSIGNMENT


DWR_SWTCHNG_PROTCL

SWITCHING PROTOCOL


DWR_SWTCHNG_RL

SWITCHING ROLE


DWR_SYMBLGY

SYMBOLOGY


DWR_TASK

TASK


DWR_TAX_AUTH

TAX AUTHORITY


DWR_TAX_EXMPT

TAX EXEMPT


DWR_TEMPLATE_SRVC_LVL_SPEC

TEMPLATE SERVICE LEVEL SPEC


DWR_TIME_BND

TIME BAND


DWR_TIME_SLT

TIME SLOT


DWR_TIME_STNDRD_BY_DAY

TIME STANDARD BY DAY


DWR_TIME_STNDRD_BY_WK

TIME STANDARD BY WEEK


DWR_TIME_TOT

TIME TOTAL


DWR_TMNT_PNT

TERMINATION POINT


DWR_TNDR

TENDER


DWR_TOKN_BCKT

TOKEN BUCKET


DWR_TOS_SRVC

TOS SERVICE


DWR_TRAIL

TRAIL


DWR_TRAIL_TMNT_PNT

TRAIL TERMINATION POINT


DWR_TRFC_CNDITNNG_SRVC

TRAFFIC CONDITIONING SERVICE


DWR_TRFC_ID_SRVC

TRAFFIC IDENTIFICATION SERVICE


DWR_TRFC_MTCH_CRTRA

TRAFFIC MATCH CRITERIA


DWR_TRGT_ACCS_MTHD

TARGET ACCESS METHOD


DWR_TRGT_ACCT

TARGET ACCOUNT


DWR_TRGT_AGRMNT

TARGET AGREEMENT


DWR_TRGT_GEO_AREA

TARGET GEOGRAPHY AREA


DWR_TRGT_MKT_SGMNT

TARGET MARKET SEGMENT


DWR_TV_CHNL

TV CHANNEL


DWR_UDR_EVT_CHAR

UDR EVENT CHARACTERISTIC


DWR_UDR_EVT_CHAR_RLTN

UDR EVENT SPECIFICATION CHARACTERISTIC RELATIONSHIP


DWR_UDR_EVT_CHAR_VAL

UDR EVENT CHARACTERISTIC VALUE


DWR_UDR_EVT_SPEC

UDR EVENT SPECIFICATION


DWR_UDR_EVT_SPEC_CHAR

UDR EVENT SPECIFICATION CHARACTERISTIC


DWR_UDR_EVT_SPEC_CHAR_USE

UDR EVENT SPECIFICATION CHARACTERISTIC USE


DWR_UDR_EVT_SPEC_CHAR_VAL

UDR EVENT SPECIFICATION CHARACTERISTIC VALUE


DWR_UDR_EVT_SPEC_CHAR_VAL_RLTN

UDR EVENT SPECIFICATION CHARACTERISTIC VALUE RELATIONSHIP


DWR_UDR_EVT_SPEC_CHAR_VAL_USE

UDR EVENT SPECIFICATION CHARACTERISTIC VALUE USE


DWR_UDR_EVT_SPEC_RLTN

UDR EVENT SPECIFICATION RELATIONSHIP


DWR_UDR_EVT_SPEC_VRSN

UDR EVENT SPECIFICATION VERSION


DWR_UDR_EVT_TYP_VRSN

UDR EVENT TYPE VERSION


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_VISITOR

VISITOR


DWR_VNDR

VENDOR


DWR_VNDR_AGRMNT

VENDOR AGREEMENT


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_WBSITE

WEBSITE


DWR_WBSITE_USER

WEBSITE USER


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_RSCE

WIRELESS RESOURCE


DWR_WRLS_RTNG_PLN

WIRELESS RATING PLAN


DWR_WRLS_SPTRUM

WIRELESS SPECTRUM


DWR_WRLS_SRVC

WIRELESS SERVICE


DWR_WTD_FAIR_QUENG_SRVC

WEIGHTED FAIR QUEUING SERVICE


DWR_WTD_RND_RBIN_SCHDLNG_SRVC

WEIGHTED ROUND ROBIN SCHEDULING SERVICE


DWR_YR_TRANS

YEAR TRANSFORMATION



Lookup Tables

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

Table 4-4 Lookup Tables

Table NameMore 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_PROD_SBRP_ASGN_RSN

ACCOUNT PRODUCT SUBSCRIPTION ASSIGNMENT REASON


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_STAT_RSN

ACCOUNT STATUS REASON


DWL_ACCT_STAT_TYP

ACCOUNT STATUS TYPE


DWL_ACCT_TYP

ACCOUNT TYPE


DWL_ACTVTY_CTGRY

ACTIVITY CATEGORY


DWL_ACTVTY_RSLT_TYP

ACTIVITY RESULT TYPE


DWL_ACTVTY_TYP

ACTIVITY TYPE


DWL_ADDR_RLTD_RSN

ADDRESS RELATED REASON


DWL_ADDR_RLTD_TYP

ADDRESS RELATED TYPE


DWL_ADDR_STAT

ADDRESS STATUS


DWL_ADDR_STAT_RSN

ADDRESS STATUS REASON


DWL_ADDR_TYP

ADDRESS TYPE


DWL_ADDR_VRFY_TYP

ADDRESS VERIFICATION TYPE


DWL_ADJ_TYP

ADJUSTMENT TYPE


DWL_AGE_BND

AGE BAND


DWL_AGE_GRP

AGE GROUP


DWL_AGE_ON_NET_BND

AGE ON NET BAND


DWL_AGRMNT_ASGN_RSN

AGREEMENT ASSIGNMENT REASON


DWL_AGRMNT_ASGN_TYP

AGREEMENT ASSIGNMENT TYPE


DWL_AGRMNT_CHNG_INTTR_TYP

AGREEMENT CHANGE INITIATOR TYPE


DWL_AGRMNT_CHNG_RSN

AGREEMENT CHANGE REASON


DWL_AGRMNT_CHNG_TYP

AGREEMENT CHANGE TYPE


DWL_AGRMNT_STAT_RSN

AGREEMENT STATUS REASON


DWL_AGRMNT_STAT_TYP

AGREEMENT STATUS TYPE


DWL_AGRMNT_TERM_TYP

AGREEMENT TERM TYPE


DWL_AGRMNT_TYP

AGREEMENT TYPE


DWL_APNMNT_TYP

APPOINTMENT TYPE


DWL_ARPU_BND

ARPU BAND


DWL_ASSET_TYP

ASSET TYPE


DWL_ATHRZTN_MTHD

AUTHORIZATION METHOD


DWL_AWRD_LVL

AWARD LEVEL


DWL_BARNG_RSN

BARING REASON


DWL_BER_FER_TYP

BER FER TYPE


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_CHAR_TYP

BUSINESS INTERACTION CHARACTERISTIC TYPE


DWL_BSNS_INTRACN_STAT_RSN

BUSINESS INTERACTION STATUS REASON


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_CARD_HLDR_VRFY_TYP

CARD HOLDER VERIFICATION TYPE


DWL_CARD_TYP

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

COMPOUND RESOURCE DETAIL TYPE


DWL_CMPNSATRY_RSN

COMPENSATORY REASON


DWL_CMPST_PROD_SPEC_CHRG_TYP

COMPOSITE PRODUCT SPECIFICATION CHARGE TYPE


DWL_CMPST_PROD_SPEC_TYP

COMPOSITE PRODUCT SPECIFICATION TYPE


DWL_CNCT_LST_CHNG_RSN

CONTACT LIST CHANGE REASON


DWL_CNCT_LST_RECRNC_TYP

CONTACT LIST RECURRENCE TYPE


DWL_CNCT_RLS

CONTACT ROLES


DWL_CNTCT_MEDIUM

CONTACT MEDIUM


DWL_CNTNT_PRCNG_TYP

CONTENT PRICING TYPE


DWL_CNTNT_TYP

CONTENT TYPE


DWL_COLLCTN_TYP

COLLECTION TYPE


DWL_COST_RSN

COST REASON


DWL_COST_SUBTYP

COST SUBTYPE


DWL_COST_TYP

COST TYPE


DWL_CPN_SCAN

COUPON SCAN


DWL_CPN_TYP

COUPON TYPE


DWL_CRCUT_CTGRY

CIRCUIT CATEGORY


DWL_CRCUT_RNTL_EVT_TYP

CIRCUIT RENTAL EVENT TYPE


DWL_CRCUT_TYP

CIRCUIT TYPE


DWL_CRNCY

CURRENCY


DWL_CRTFCT_TYP

CERTIFICATE TYPE


DWL_CUST_CLASS

CUSTOMER CLASS


DWL_CUST_CLSTR_TYP

CUSTOMER CLUSTER TYPE


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_RLTN_TYP

CUSTOMER RELATIONSHIP TYPE


DWL_CUST_RVN_BND

CUSTOMER REVENUE BAND


DWL_CUST_RVN_TYP

CUSTOMER REVENUE TYPE


DWL_CUST_STAT_RSN

CUSTOMER STATUS REASON


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_DOMAIN_TYP

DOMAIN TYPE


DWL_DRCT_DEBIT_STAT_RSN

DIRECT DEBIT STATUS REASON


DWL_DSPSTN_TYP

DISPOSITION TYPE


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_ENRL_CHNL

ENROLL CHANNEL


DWL_ENRL_TYP

ENROLL TYPE


DWL_ENTRY_MTHD

ENTRY METHOD


DWL_ENV_TYP

ENVIRONMENT TYPE


DWL_EQPMNT_INSTNC_STAT_TYP

EQUIPMENT INSTANCE STATUS 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_PRTY_RL

EVENT PARTY ROLE


DWL_EVT_RESPN_RSN

EVENT RESPONSE REASON


DWL_EVT_RSLT

EVENT RESULT


DWL_EVT_RSLTN

EVENT RESOLUTION


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_BASIS_TYP

EXPIRY BASIS 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_FUEL_SL_STAT

FUEL SALE STATUS


DWL_FXBLE_CHAR_ASGN_TYP

FLEXIBLE CHARACTERISTIC ASSIGNMENT TYPE


DWL_FXBLE_CHAR_TYP

FLEXIBLE CHARACTERISTIC TYPE


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_IMPRESSION_EVT_TYP

IMPRESSION EVENT TYPE


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_STAT_TYP

INTERACTION STATUS TYPE


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

INVOICE STATUS


DWL_INVC_TYP

INVOICE TYPE


DWL_INVLMNT_RL

INVOLVEMENT ROLE


DWL_ISP_BSNS_TYP

ISP BUSINESS TYPE


DWL_ISP_TYP

ISP TYPE


DWL_ITEM_LKUP_MTHD

ITEM LOOKUP METHOD


DWL_ITEM_TYP

ITEM TYPE


DWL_LANG

LANGUAGE


DWL_LEGAL_PRCS_STAT_TYP

LEGAL PROCESS STATUS TYPE


DWL_LFCCL_TYP

LIFECYCLE TYPE


DWL_LND_USE_TYP

LAND USE TYPE


DWL_LOOKUP

LOOKUP


DWL_LR_STAT

LR STATUS


DWL_LTTR_TYP

LETTER TYPE


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_INTRFC_TYP

MEDIA INTERFACE TYPE


DWL_MEDIA_OBJ_TYP

MEDIA OBJECT TYPE


DWL_MNG_ACTN_TYP

MANAGE ACTION TYPE


DWL_MRKR_TYP

MARKER 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_RSN

NP REQUEST STATE REASON


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

ORDER LINE ITEM STATE


DWL_ORDR_LN_ITEM_STATE_TYP

ORDER LINE ITEM STATE TYPE


DWL_ORDR_STATE

ORDER STATE


DWL_ORDR_STATE_TYP

ORDER STATE TYPE


DWL_ORDR_TYP

ORDER TYPE


DWL_ORG_BSNS_UNIT_TYP

ORGANIZATION BUSINESS UNIT TYPE


DWL_ORG_TYP

ORGANIZATION 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

PACKET CONTROL UNIT OUTAGE REASON


DWL_PIT_CHAR_TYP

PIT CHARACTERISTIC TYPE


DWL_PK_OFPK_TIME

PEAK OFFPEAK TIME


DWL_POS_IDNT_TYP

POINT OF SALE IDENTITY TYPE


DWL_POS_TYP

POINT OF SALE TYPE


DWL_POSTL_SRVC_TYP

POSTAL SERVICE TYPE


DWL_PPA_CTGRY

PPA CATEGORY


DWL_PPA_DEDCTN_TYP

PPA DEDUCTION TYPE


DWL_PRBLM_ESCALATN_LVL

PROBLEM ESCALATION LEVEL


DWL_PRCS_PRMTR_OPRTR

PROCESS PARAMETER OPERATOR


DWL_PRCS_RLTN_TYP

PROCESS RELATIONSHIP TYPE


DWL_PRCS_STAT

PROCESS STATUS


DWL_PRCS_TYP

PROCESS TYPE


DWL_PREF_TYP

PREFERENCE TYPE


DWL_PRFMNC_IND_GRP_SPEC

PERFORMANCE INDICATOR GROUP SPEC


DWL_PRICE_RSN

PRICE REASON


DWL_PRICE_TYP

PRICE TYPE


DWL_PRICE_TYPE_RLTN_RSN

PRICE TYPE RELATION REASON


DWL_PRMTN_RSLT_TYP

PROMOTION RESULT TYPE


DWL_PRMTN_TERM_TYP

PROMOTION TERM TYPE


DWL_PRMTN_TYP

PROMOTION TYPE


DWL_PROD_BRND

PRODUCT BRAND


DWL_PROD_CAPBLTY_TYP

PRODUCT CAPABILITY TYPE


DWL_PROD_CHAR_TYP

PRODUCT CHARACTERISTIC TYPE


DWL_PROD_CTLG_PRSNT_TYP

PRODUCT CATALOG PRESENTATION TYPE


DWL_PROD_CTLG_TYP

PRODUCT CATALOG TYPE


DWL_PROD_LN

PRODUCT LINE


DWL_PROD_OFR_ASGN_TYP

PRODUCT OFFERING ASSIGNMENT TYPE


DWL_PROD_OFR_GRP_TYP

PRODUCT OFFERING GROUP TYPE


DWL_PROD_OFR_PRICE_RLTN_TYP

PRODUCT OFFERING PRICE RELATIONSHIP TYPE


DWL_PROD_OFR_PRICE_TYP

PRODUCT OFFERING PRICE TYPE


DWL_PROD_OFR_RLTN_TYP

PRODUCT OFFERING RELATIONSHIP TYPE


DWL_PROD_OFR_TYP

PRODUCT OFFERING TYPE


DWL_PROD_RLTN_TYP

PRODUCT RELATIONSHIP TYPE


DWL_PROD_SBRP_ASGN_TYP

PRODUCT SUBSCRIPTION ASSIGNMENT TYPE


DWL_PROD_SBRP_EVT_TYP

PRODUCT SUBSCRIPTION EVENT TYPE


DWL_PROD_SBRP_STAT

PRODUCT SUBSCRIPTION STATUS


DWL_PROD_SBRP_STAT_CTGRY

PRODUCT SUBSCRIPTION STATUS CATEGORY


DWL_PROD_SBRP_STAT_RSN

PRODUCT SUBSCRIPTION STATUS REASON


DWL_PROD_SBRP_STAT_TYP

PRODUCT SUBSCRIPTION STATUS TYPE


DWL_PROD_SBRP_TERM_TYP

PRODUCT SUBSCRIPTION TERM TYPE


DWL_PROD_SBRP_TYP

PRODUCT SUBSCRIPTION TYPE


DWL_PROD_SPEC_ASGN_RSN

PRODUCT SPECIFICATION ASSIGNMENT REASON


DWL_PROD_SPEC_COVRG_AREA_TYP

PRODUCT SPECIFICATION COVERAGE AREA TYPE


DWL_PROD_SPEC_CTGRY

PRODUCT SPECIFICATION CATEGORY


DWL_PROD_SPEC_GRP

PRODUCT SPECIFICATION GROUP


DWL_PROD_SPEC_GRP_TYP

PRODUCT SPECIFICATION GROUP TYPE


DWL_PROD_SPEC_MGMT_RL

PRODUCT SPECIFICATION MANAGEMENT ROLE


DWL_PROD_SPEC_MGMT_RSN

PRODUCT SPECIFICATION MANAGEMENT REASON


DWL_PROD_SPEC_STAT_TYP

PRODUCT SPECIFICATION STATUS TYPE


DWL_PROD_SPEC_TYP

PRODUCT SPECIFICATION TYPE


DWL_PROD_STAT_TYP

PRODUCT STATUS TYPE


DWL_PRPD_MBL_EVT_TYP

PREPAID MOBILE EVENT TYPE


DWL_PRSNL_ID_REQD_TYP

PERSONAL ID REQUIRED 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_AGRMNT_ASGN_RL

PARTY AGREEMENT ASSIGNMENT ROLE


DWL_PRTY_AGRMNT_ASGN_TYP

PARTY AGREEMENT 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_EVT_TYP

PARTY EVENT TYPE


DWL_PRTY_IDNT_TYP

PARTY IDENTIFICATION TYPE


DWL_PRTY_LOC_RSN

PARTY LOCATION REASON


DWL_PRTY_LOC_TYP

PARTY LOCATION TYPE


DWL_PRTY_MGMT_RL

PARTY MANAGEMENT ROLE


DWL_PRTY_PRFL_TYP

PARTY PROFILE TYPE


DWL_PRTY_ORDR_ASGN_TYP

PARTY ORDER ASSIGNMENT TYPE


DWL_PRTY_PROD_SBRP_RL

PARTY PRODUCT SUBSCRIPTION ROLE


DWL_PRTY_RL

PARTY ROLE


DWL_PRTY_RL_CTGRY

PARTY ROLE CATEGORY


DWL_PRTY_RL_TYP

PARTY ROLE TYPE


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_QOS_SRVC_SPEC_TYP

QOS SERVICE SPEC TYPE


DWL_RATABLE_UNIT_MEASUREMENT

RATABLE UNIT MEASUREMENT


DWL_RDMPTN_TYP

REDEMPTION TYPE


DWL_RECHRG_RVN_SLB

RECHARGE REVENUE SLAB


DWL_RELGN

RELIGION


DWL_RELIGIOUS_AFFLTN

RELIGIOUS AFFILIATION


DWL_RFMP_MTHD

RFMP METHOD


DWL_RLTN_TYP

RELATION TYPE


DWL_RMNG_TYP

ROAMING TYPE


DWL_ROOT_ENT_TYP

ROOT ENTITY TYPE


DWL_RSCE_RLTN_TYP

RESOURCE RELATIONSHIP TYPE


DWL_RSCE_SPEC_CTGRY

RESOURCE SPECIFICATION CATEGORY


DWL_RSCE_SPEC_TYP

RESOURCE SPECIFICATION TYPE


DWL_RSCE_STATE_RSN

RESOURCE STATE REASON


DWL_RSCE_STATE_TYP

RESOURCE STATE TYPE


DWL_RSCE_USG_EVT_TYP

RESOURCE USAGE EVENT TYPE


DWL_RSN

REASON


DWL_RSN_CTGRY

REASON CATEGORY


DWL_RTL_TRML_STAT

RETAIL TERMINAL STATUS


DWL_RTL_TRX_LI_TYP

RETAIL TRANSACTION LINE ITEM TYPE


DWL_RTL_TYP

RETAIL TYPE


DWL_RTNG_MTHD_TYP

RATING METHOD 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_SERVER_STAT

SERVER STATUS


DWL_SESSION_TYP

SESSION TYPE


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_PROD_SBRP_RSN

SIM CARD PRODUCT SUBSCRIPTION REASON


DWL_SIM_CARD_TYP

SIM CARD TYPE


DWL_SITE_TYP

SITE TYPE


DWL_SKILL_TYP

SKILL TYPE


DWL_SKU_TYP

SKU TYPE


DWL_SL_OR_RETRN_ACTN

SALE OR RETURN ACTION


DWL_SLNG_LOC_TYP

SELLING LOCATION TYPE


DWL_SPNM

SPNM


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_SPEC

SERVICE LEVEL SPECIFICATION


DWL_SRVC_LVL_UNMET_CNSEQ_TYP

SERVICE LEVEL UNMET CONSEQUENCE TYPE


DWL_SRVC_PRBLM_CHAR_TYP

SERVICE PROBLEM CHAR TYPE


DWL_SRVC_SPEC_TYP

SERVICE SPECIFICATION TYPE


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_TCH_TYP

TCH TYPE


DWL_TECH

TECHNOLOGY


DWL_TECH_TYP

TECHNOLOGY TYPE


DWL_TIER_CARD_TYP

TIER CARD TYPE


DWL_TIME_ZN

TIME ZONE


DWL_TNDR_CLASS

TENDER CLASS


DWL_TRGT_TYP

TARGET TYPE


DWL_TRNK_GRP

TRUNK GROUP


DWL_TRNSFR_TYP

TRANSFER TYPE


DWL_TRX_CTGRY

TRANSACTION CATEGORY


DWL_TRX_TYP

TRANSACTION TYPE


DWL_UDR_EVT_CHAR_TYP

UDR EVENT CHARACTERISTIC TYPE


DWL_UDR_EVT_SPEC_TYP

UDR EVENT SPECIFICATION TYPE


DWL_UDR_EVT_STAT

UDR EVENT STATUS


DWL_UDR_EVT_TYP

UDR EVENT TYPE


DWL_UMS_ACCS_TYP

UMS ACCESS TYPE


DWL_UMS_EVT_TYP

UMS EVENT TYPE


DWL_UOM

UNIT OF MEASURE


DWL_USG_TYP

USAGE TYPE


DWL_VAL_TYP

VALUE TYPE


DWL_VISITOR_TYP

VISITOR TYPE


DWL_VNDR_CLASS

<p>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-5 briefly describes the Base tables in Oracle Communications Data Model.

Table 4-5 Base Tables

Table NameMore Information

DWB_ACCRUAL_EVT

ACCRUAL EVENT


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

ACCOUNT BALANCE


DWB_ACCT_BAL_IMPC

ACCOUNT BALANCE IMPACT


DWB_ACCT_BLLG_OCCRNCE

ACCOUNT BILLING OCCURRENCE


DWB_ACCT_COST

ACCOUNT COST


DWB_ACCT_CRDT_LMT

ACCOUNT CREDIT LIMIT


DWB_ACCT_DEBT

ACCOUNT DEBT


DWB_ACCT_DEBT_HIST

ACCOUNT DEBT HISTORY


DWB_ACCT_MNGMNT_HIST

ACCOUNT MANAGEMENT HISTORY


DWB_ACCT_PROD_OFR_PRTCPTN_HIST

ACCOUNT PRODUCT OFFERING PARTICIPATION HISTORY


DWB_ACCT_PYMT

ACCOUNT PAYMENT


DWB_ACCT_PYMT_MTHD_STAT

ACCOUNT PAYMENT METHOD STATUS


DWB_ACCT_PYMT_PYMT_PLN_ASGN

ACCOUNT PAYMENT PAYMENT PLAN ASSIGNMENT


DWB_ACCT_STAT_HIST

ACCOUNT STATUS HISTORY


DWB_ADDR_STAT_HIST

ADDRESS STATUS HISTORY


DWB_ADHOC_COLLCTN

ADHOC COLLECTION


DWB_AGRMNT_APRVL

AGREEMENT APPROVAL


DWB_AGRMNT_APRVL_ASGN

AGREEMENT APPROVAL ASSIGNMENT


DWB_AGRMNT_STAT

AGREEMENT STATUS


DWB_AGRMNT_TERM

AGREEMENT TERM


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_BRDBND_USG_EVT

BROADBAND USAGE EVENT


DWB_BSNS_INTRACN

BUSINESS INTERACTION


DWB_BSNS_INTRACN_HIST

BUSINESS INTERACTION HISTORY


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_VRSN

BUSINESS INTERACTION VERSION


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_CNSEQ_PRFMNC_NTFCTN

CONSEQUENCE PERFORMANCE NOTIFICATION


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

DISCOUNT LINE ITEM


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

EVENT AGREEMENT


DWB_EVT_ASGN

EVENT ASSIGNMENT


DWB_EVT_CMPST_PROD_SPEC

EVENT COMPOSITE PRODUCT SPECIFICATION


DWB_EVT_COST

EVENT COST


DWB_EVT_CRCUT_RNTL

EVENT CIRCUIT RENTAL


DWB_EVT_EMP_ACTVTY

EVENT EMPLOYEE ACTIVITY


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_LYLTY_PROG

EVENT LOYALTY PROGRAM


DWB_EVT_PROD_SBRP_WRLS

EVENT PRODUCT SUBSCRIPTION WIRELESS


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_CHAT_DTL

EVENT PARTY INTERACTION CHAT DETAIL


DWB_EVT_PRTY_INTRACN_ITEM

EVENT PARTY INTERACTION ITEM


DWB_EVT_PRTY_INTRACN_PRTCPTN

EVENT PARTY INTERACTION PARTICIPATION


DWB_EVT_PRTY_PRFL

EVENT PARTY PROFILE


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

IMPRESSION


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_INV_ITEM_STATE

INVENTORY ITEM STATE


DWB_INVC

INVOICE


DWB_INVC_ADJ

INVOICE ADJUSTMENT


DWB_INVC_DISC

INVOICE DISCOUNT


DWB_INVC_GENRTN_PRCS

INVOICE GENERATION PROCESS


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_ADJ_DOC_LI

INVENTORY ADJUSTMENT DOCUMENT LINE ITEM


DWB_INV_CNTRL_DOC

INVENTORY CONTROL DOCUMENT


DWB_INV_CNTRL_DOC_LI

INVENTORY CONTROL DOCUMENT LINE ITEM


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_MBRSHIP_ENRL

LOYALTY MEMBERSHIP ENROLL


DWB_LYLTY_TIER_CHNG_HIST

LOYALTY TIER CHANGE HISTORY


DWB_MBRSHIP_ACCT_BAL_HIST

MEMBERSHIP ACCOUNT BALANCE HISTORY


DWB_MDTD_CALL_EVT

MEDIATED CALL EVENT


DWB_MEDIA_OBJ_COST

MEDIA OBJECT COST


DWB_MMS_EVT

MMS EVENT


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

PHYSICAL COUNT DOCUMENT


DWB_PHY_CNT_DOC_LI

PHYSICAL COUNT DOCUMENT LINE ITEM


DWB_PLCY_EVT

POLICY EVENT


DWB_PLCY_EVT_ATMC

POLICY EVENT ATOMIC


DWB_PLCY_EVT_CMPST

POLICY EVENT COMPOSITE


DWB_PRBLM

PROBLEM


DWB_PRBLM_CMNTS

PROBLEM COMMENTS


DWB_PRBLM_LOC_ASGN

PROBLEM LOCATION ASSIGNMENT


DWB_PRBLM_RLTN

PROBLEM RELATIONSHIP


DWB_PRBLM_RSCE_ASGN

PROBLEM RESOURCE ASSIGNMENT


DWB_PRBLM_SRVC_ASGN

PROBLEM SERVICE ASSIGNMENT


DWB_PRBLM_STAT_HIST

PROBLEM STATUS HISTORY


DWB_PRBLM_TRKNG_REC_ASGN

PROBLEM TRACKING RECORD ASSIGNMENT


DWB_PRCS_COST

PROCESS COST


DWB_PRCS_EVT

PROCESS EVENT


DWB_PRCS_INVC_DSPTCHG_EVT

PROCESS INVOICE DISPATCHING EVENT


DWB_PRCS_INVC_GNRTN_EVT

PROCESS INVOICE GENERATION EVENT


DWB_PRCS_INVC_ISSNG_EVT

PROCESS INVOICE ISSUING EVENT


DWB_PRCSEVT_PRMTRVAL_OPRTR_ASG

PROCESS EVENT PARAMETER VALUE OPERATOR ASSIGNMENT


DWB_PRFMNC

PERFORMANCE


DWB_PRFMNC_CNSEQ

PERFORMANCE CONSEQUENCE


DWB_PRFMNC_IND

PERFORMANCE INDICATOR


DWB_PRFMNC_IND_GRP

PERFORMANCE INDICATOR GROUP


DWB_PRFMNC_MBL_ADDR

PERFORMANCE MOBILE ADDRESS


DWB_PRFMNC_NTFCTN

PERFORMANCE NOTIFICATION


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_OFR_COST

PRODUCT OFFERING COST


DWB_PROD_OFR_MGMT

PRODUCT OFFERING MANAGEMENT


DWB_PROD_SBRP_STAT_HIST

PRODUCT SUBSCRIPTION STATUS HISTORY


DWB_PROD_SPEC_COST

PRODUCT SPECIFICATION COST


DWB_PROD_SPEC_MGMT_HIST

PRODUCT SPECIFICATION MANAGEMENT HISTORY


DWB_PROD_SPEC_STAT_HIST

PRODUCT SPECIFICATION STATUS HISTORY


DWB_PROD_STAT_HIST

PRODUCT STATUS HISTORY


DWB_PRPD_RCHRG

PREPAID RECHARGE


DWB_PRTNR_PYMT

PARTNER PAYMENT


DWB_PRTY_AM_PROD_OFR_ASGN_HIST

PARTY AM PRODUCT OFFERING ASSIGNMENT HISTORY


DWB_PRTY_AM_PROD_OFR_ASGN_STAT

PARTY AM PRODUCT OFFERING ASSIGNMENT STATUS


DWB_PRTY_COST_ASGN

PARTY COST 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_REDEM_EVT

REDEMPTION EVENT


DWB_RSCE_ALRM

RESOURCE ALARM


DWB_RSCE_ALRM_CMNT

RESOURCE ALARM COMMENT


DWB_RSCE_ALRM_RLTN

RESOURCE ALARM RELATIONSHIP


DWB_RSCE_ALRM_RSCE_ASGN

RESOURCE ALARM RESOURCE ASSIGNMENT


DWB_RSCE_ALRM_TRKNG_REC_ASGN

RESOURCE ALARM TRACKING RECORD ASSIGNMENT


DWB_RSCE_BSNS_INTRACN_RL

RESOURCE BUSINESS INTERACTION ROLE


DWB_RSCE_COST

RESOURCE COST


DWB_RSCE_FLT_ASGN

RESOURCE FAULT ASSIGNMENT


DWB_RSCE_HIST

RESOURCE HISTORY


DWB_RSCE_ORDR

RESOURCE ORDER


DWB_RSCE_ORDR_LN_ITEM

RESOURCE ORDER LINE ITEM


DWB_RSCE_PRFMNC

RESOURCE PERFORMANCE


DWB_RSCE_STATE_HIST

RESOURCE STATE HISTORY


DWB_RTD_UDR_EVT

RATED UDR EVENT


DWB_RTL_SL_RTRN_LI

RETAIL SALES RETURN LINE ITEM


DWB_RTL_TNDR_LI

RETAIL TENDER LINE ITEM


DWB_RTL_TRX

RETAIL TRANSACTION


DWB_RTL_TRX_LN_ITEM

RETAIL TRANSACTION LINE ITEM


DWB_SBRP_TERM_VAL

SUBSCRIPTION TERM VALUE


DWB_SESSION

SESSION


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_PRBLM

SERVICE PROBLEM


DWB_SRVC_PRBLM_RSCE_ALRM_ASGN

SERVICE PROBLEM RESOURCE ALARM ASSIGNMENT


DWB_SRVC_PRBLM_SBRP_ASGN

SERVICE PROBLEM SUBSCRIPTION ASSIGNMENT


DWB_SRVC_PRBLM_SRVC_ASGN

SERVICE PROBLEM SERVICE ASSIGNMENT


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_TNDR_CNTRL_TRX

TENDER CONTROL TRANSACTION


DWB_TRBLE_TCKT

TROUBLE TICKET


DWB_TRBLE_TCKT_FLD_SPPRT_ASGN

TROUBLE TICKET FIELD SUPPORT ASSIGNMENT


DWB_TRBLE_TCKT_ITEM

TROUBLE TICKET ITEM


DWB_TRKNG_REC

TRACKING RECORD


DWB_UDR_EVT

UDR EVENT


DWB_UDR_EVT_ASGN

UDR EVENT ASSIGNMENT


DWB_UMS_EVT

UMS EVENT


DWB_UNIT_ALWNCE

UNIT ALLOWANCE


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-6 Oracle Communications Data Model Derived Tables

Table NameMore Information

DWD_ACCT_BAL_MO

ACCOUNT BALANCE MONTH DRVD


DWD_ACCT_DEBT_MO

Not used

DWD_ACCT_FRST_ACTVTY

ACCOUNT FIRST ACTIVITY DERIVED


DWD_ACCT_LAST_ACTVTY

ACCOUNT LAST ACTIVITY DERIVED


DWD_ACCT_PYMT_DAY

ACCOUNT PAYMENT DAY DRVD


DWD_ACCT_PYMT_MTHD_STAT_HIST

ACCOUNT PAYMENT METHOD STATUS HIST DRVD


DWD_AGRMNT

AGREEMENT DRVD


DWD_AGRMNT_CHNG

AGREEMENT CHANGED DRVD


DWD_AGRMNT_RVN_DAY

AGREEMENT REVENUE DAY DRVD


DWD_BER_FER_ERR_RATIO_DAY

BER FER ERROR RATIO DAY DRVD


DWD_CANBLZTN_DTL_DAY

CANNIBALIZATION DETAIL DAY DRVD


DWD_CELL_STTSTC_DAY

CELL STATISTIC DAY DRVD


DWD_CMISN

COMMISSION DRVD


DWD_CMPGN_HIST_DAY

CAMPAIGN HISTORY DAY DRVD


DWD_CNT_DAY

COUNT DAY DRVD


DWD_CNTCT_CNTR_DAY

CONTACT CENTER DAY DERIVED


DWD_COST_CNTR

COST CENTER DERIVED


DWD_CUST_COST

CUSTOMER COST DRVD


DWD_CUST_DNA

CUSTOMER DNA DRVD


DWD_CUST_EQPMNT_INSTLTN_DAY

CUSTOMER EQUIPMENT INSTALLATION DAY DRVD


DWD_CUST_ORDR_DAY

CUSTOMER ORDER DAY DERIVED


DWD_CUST_ORDR_LN_ITEM_DAY

CUSTOMER ORDER LINE ITEM DAY DERIVED


DWD_CUST_RFMP_SCR

CUSTOMER RFMP SCORE


DWD_CUST_SKU_SL_RETRN_DAY

CUSTOMER SKU SALES RETURN DAY DRVD


DWD_DATA_USG_DAY

DATA USAGE DAY DRVD


DWD_GIVE_AWAY_ITEM_DAY

GIVE AWAY ITEM DAY DRVD


DWD_INVC_AGNG_DAY

INVOICE AGING DAY DRVD


DWD_INVC_DAY

INVOICE DRVD


DWD_INV_ADJ_ITEM_DAY

Not used

DWD_INV_POSN_ITEM_DAY

INVENTORY POSITION ITEM DAY DRVD


DWD_INV_RCPT_ITEM_DAY

INVENTORY RECEIPT ITEM DAY DRVD


DWD_INV_UNAVL_ITEM_DAY

INVENTORY UNAVAILABLE ITEM DAY DRVD


DWD_INV_VNDR_CMPLNC_DAY

INVENTORY VENDOR COMPLIANCE DAY DRVD


DWD_INV_XFER_ITEM_DAY

INVENTORY TRANSFER ITEM DAY DRVD


DWD_IN_PLTFRM_DAY

IN PLATFORM DAY DRVD


DWD_LYLTY_MBR_PNT_DAY

LOYALTY MEMBER POINT DAY DRVD


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_ORG_BSNS_UNT_HRS_DAY

ORGANIZATION BUSINESS UNIT HOURS DAY DRVD


DWD_POS_TNDR_FLOW

POINT OF SALE TENDER FLOW DRVD


DWD_PRCS_INVC_DAY

PROCESS INVOICE DAY DRVD


DWD_PRPD_ACCT_STTSTC_DAY

PREPAID ACCOUNT STATISTIC DRVD


DWD_PRPD_ALWNCE_DAY

Not used

DWD_PRTNR_STLMNT

PARTNER SETTLEMENT DRVD


DWD_RTL_SL_RETRN_ITEM_DAY

RETAIL SALES RETURN ITEM DAY DRVD


DWD_RF_NTWK_CPCTY_DAY

RF NETWORK CAPACITY DAY DRVD


DWD_RVN_DAY

REVENUE DAY DRVD


DWD_SL_RPRSTV_STTSTC

SALES REPRESENTATIVE STATISTICS DRVD


DWD_SPLMNTR_SRVC_USG

SUPPLEMENTARY SERVICE USAGE DRVD


DWD_SRVC_PRBLM_DAY

SERVICE PROBLEM DAY DRVD


DWD_STORE_EFFNCY_DAY

STORE EFFICIENCY DAY DRVD


DWD_TMF_KPI

TMF KPI 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-7 briefly describes the Aggregate tables in Oracle Communications Data Model.

Table 4-7 Aggregate Tables

Table NameMore Information

DWA_ACCT_DEBT_MO

ACCOUNT DEBT MONTH AGGR


DWA_ACCT_PYMT_MO

ACCOUNT PAYMENT MONTH AGGR


DWA_ACCT_STTSTC_MO

ACCOUNT STATISTIC MONTH AGGR


DWA_AGRMNT_ACCT_SBRP_PROD

AGREEMENT ACCOUNT SUBSCRIPTION PRODUCT 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_CELL_STTSTC_MO

CELL STATISTIC MONTH AGGR


DWA_CMISN_MO

COMMISSION MONTH AGGR


DWA_CNT_MO

COUNT MONTH AGGR


DWA_COST_CNTR_MO

COST CENTER MONTH AGGR


DWA_CUST_ACQSTN_SUMM_MO

CUSTOMER ACQUISITION SUMMARY MONTH AGGR


DWA_CUST_CHRN_MO

CUSTOMER CHURN MONTH AGGR


DWA_CUST_COST_MO

CUSTOMER COST MONTH AGGR


DWA_CUST_DEBT_COLLCTN_MO

CUSTOMER DEBT COLLECTION MONTH AGGR


DWA_CUST_EQPMNT_INSTLTN_MO

CUSTOMER EQUIPMENT INSTALLATION MO AGGR


DWA_CUST_GROSS_ORDRS_QTR

CUSTOMER GROSS ORDER QUARTERLY


DWA_CUST_ORDR_MO

CUSTOMER ORDER MONTH AGGR


DWA_DATA_USG_MO

DATA USAGE MONTH AGGR


DWA_IN_PLTFRM_MO

IN PLATFORM MONTH AGGR


DWA_INV_POSN_DEPT_DAY

INVENTORY POSITION DEPARTMENT DAY AGGR


DWA_INV_POSN_SBC_MO

INVENTORY POSITION SUBCLASS MONTH AGGR


DWA_INVC_MO

INVOICE MONTH AGGR


DWA_INVC_ADJ_MO

INVOICE ADJUSTMENT 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_ALWNCE_MO

PREPAID ALLOWANCE MONTH AGGR


DWA_PRTNR_STLMNT_MO

PARTNER SETTLEMENT MONTH AGGR


DWA_RDMPTN_MO

REDEMPTION MO AGGR


DWA_RF_NTWK_CPCTY_MO

RF NETWORK CAPACITY MONTH AGGR


DWA_RVN_MO

REVENUE MONTH AGGR


DWA_SBSCBR_STTSTC_MO

SUBSCRIPTION STATISTIC MONTH AGGR


DWA_SL_CMPGN_SUMM_MO

SALES CAMPAIGN SUMMARY MONTH AGGR


DWA_SPLMNTR_SRVC_USG_MO

Not used

DWA_STORE_EFFNCY_MO

STORE EFFICIENCY 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-8 and Table 4-9 briefly describes the temporary and control tables in Oracle Communications Data Model.

Table 4-8 Temporary Oracle Communications Data Model Tables

Table NameDescription

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.

TMP_DWD_CUST_RFMP_SCR_1


TMP_DWD_CUST_RFMP_SCR_2



Table 4-9 Control Tables

Table NameDescription

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".

DWC_MESSAGE

"Intra-ETL Monitoring Process Control Tables"


DWC_OLAP_ETL_PARAMETER

Reports OLAP ETL parameter. For more information, see "Intra-ETL OLAP Mapping Control Table".


Sequences in Oracle Communications Data Model

Table 4-10 lists the sequence names in Oracle Communications Data Model.

Table 4-10 Sequence Name for Oracle Communications Data Model

Table NameSequence Name

DWC_INTRA_ETL_ACTIVITY

INTRA_ETL_ACTIVITY_SEQ

DWC_INTRA_ETL_PROCESS

INTRA_ETL_PROCESS_SEQ

DWD_TMF_KPI

DWD_TMF_KPI_SEQ

DWR_DAY_TODATE_TRANS

DAY_TODATE_TRANS_SEQ

DWR_HLF_MO_TODATE_TRANS

HLF_MO_TODATE_TRANS_SEQ

DWR_MO_TODATE_TRANS

MO_TODATE_TRANS_SEQ

DWR_MO_TRANS

MO_TRANS_SEQ

DWR_QTR_TODATE_TRANS

QTR_TODATE_TRANS_SEQ

DWR_QTR_TRANS

QTR_TRANS_SEQ

DWR_WK_TODATE_TRANS

WK_TODATE_TRANS_SEQ

DWR_YR_TRANS

YR_TRANS_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

DWA_ACCT_DEBT_MO

DWA_ACCT_PYMT_MO

DWA_ACCT_STTSTC_MO

DWA_ARPU_BASE_CUST_TYP

DWA_BER_FER_ERR_RATIO_MO

DWA_CALL_CNTR_CALL_MO

DWA_CALL_CNTR_CASE_MO

DWA_CELL_STTSTC_MO

DWA_CMISN_MO

DWA_CNT_MO

DWA_COST_CNTR_MO

DWA_CUST_ACQSTN_SUMM_MO

DWA_CUST_CHRN_MO

DWA_CUST_COST_MO

DWA_CUST_DEBT_COLLCTN_MO

DWA_CUST_EQPMNT_INSTLTN_MO

DWA_CUST_GROSS_ORDRS_QTR

DWA_CUST_ORDR_MO

DWA_DATA_USG_MO

DWA_IN_PLTFRM_MO

DWA_INV_POSN_DEPT_DAY

DWA_INV_POSN_SBC_MO

DWA_INVC_ADJ_MO

DWA_INVC_MO

DWA_LYLTY_PROG_MO

DWA_MKT_SHARE

DWA_MSC_TRFC_MO

DWA_NBR_PRT_MO

DWA_NTWK_AVLBLTY_MO

DWA_NTWK_TCHPNT_MO

DWA_PRPD_ALWNCE_MO

DWA_PRTNR_STLMNT_MO

DWA_RDMPTN_MO

DWA_RF_NTWK_CPCTY_MO

DWA_RVN_MO

DWA_SBSCBR_STTSTC_MO

DWA_SL_CMPGN_SUMM_MO

DWA_SPLMNTR_SRVC_USG_MO

DWA_STORE_EFFNCY_MO

DWA_VAS_SBRP_QCK_SUMM_MO

DWA_VAS_USG_MO

DWA_VOI_CALL_MO

DWB_ACCS_MTHD_PORT_HIST

DWB_ACCS_MTHD_STAT_HIST

DWB_ACCT_ACCTNG_CYCL_HIST

DWB_ACCT_BAL_IMPC

DWB_ACCT_BLLG_OCCRNCE

DWB_ACCT_COST

DWB_ACCT_CRDT_LMT

DWB_ACCT_MNGMNT_HIST

DWB_ACCT_PROD_OFR_PRTCPTN_HIST

DWB_ACCT_PYMT

DWB_ACCT_PYMT_MTHD_STAT

DWB_ACCT_STAT_HIST

DWB_ADDR_STAT_HIST

DWB_AGRMNT_APRVL

DWB_AGRMNT_STAT

DWB_AGRMNT_TERM

DWB_APNMNT_CLNDR

DWB_BLK_LST_HIST

DWB_BRDBND_USG_EVT

DWB_BSNS_INTRACN

DWB_BSNS_INTRACN_HIST

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

DWB_EMP_ACT_LBR_HRLY

DWB_EMP_ACT_LBR_SALARIED

DWB_EMP_COST

DWB_EMP_EXP_RPT

DWB_EMP_TRNG_REC

DWB_EQPMNT_CNTR_COST

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_AGRMNT

DWB_EVT_ASGN

DWB_EVT_CMPST_PROD_SPEC

DWB_EVT_COST

DWB_EVT_CRCUT_RNTL

DWB_EVT_EMP_PYRL

DWB_EVT_EQPMNT_INSTNC

DWB_EVT_FINCL

DWB_EVT_GEO

DWB_EVT_LYLTY_PROG

DWB_EVT_PROD_SBRP_WRLS

DWB_EVT_PRPD_MBL

DWB_EVT_PRTY_ASGN

DWB_EVT_PRTY_INTRACN

DWB_EVT_PRTY_PRFL

DWB_EVT_SBRP_CHNG

DWB_EVT_SIM_CARD

DWB_EVT_STAT

DWB_EXP_RPT_PRTY_ASGN

DWB_FIXED_LN_CALL_EVT

DWB_GPRS_USG_EVT

DWB_IDD_CALL_EVT

DWB_INTRACN_QUES_RESPN

DWB_INTRNT_ACCS_EVT

DWB_INV_ADJ_DOC_LI

DWB_INV_CNTRL_DOC

DWB_INV_CNTRL_DOC_LI

DWB_INV_ITEM_STATE

DWB_INVC

DWB_INVC_ADJ

DWB_INVC_DISC

DWB_INVC_ITEM

DWB_INVC_ITEM_DTL

DWB_INVC_PYMT_ASGN

DWB_INVC_PYMT_TERM

DWB_INVC_STAT_HIST

DWB_ISP_USG_EVT

DWB_MDTD_CALL_EVT

DWB_MEDIA_OBJ_COST

DWB_MMS_EVT

DWB_NP_RQST_HDR

DWB_NP_RQST_LN_ITEM

DWB_NP_RQST_LN_ITEM_STATE_HIST

DWB_NP_RQST_STATE_HIST

DWB_PHY_CNT_DOC

DWB_PHY_CNT_DOC_LI

DWB_PLCY_EVT_ATMC

DWB_PLCY_EVT_CMPST

DWB_PRBLM_CMNTS

DWB_PRBLM_LOC_ASGN

DWB_PRBLM_RLTN

DWB_PRBLM_RSCE_ASGN

DWB_PRBLM_SRVC_ASGN

DWB_PRCS_COST

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_OFR_COST

DWB_PROD_OFR_MGMT

DWB_PROD_SBRP_STAT_HIST

DWB_PROD_SPEC_COST

DWB_PROD_SPEC_MGMT_HIST

DWB_PROD_SPEC_STAT_HIST

DWB_PRPD_RCHRG

DWB_PRTNR_PYMT

DWB_PRTY_AM_PROD_OFR_ASGN_HIST

DWB_PRTY_AM_PROD_OFR_ASGN_STAT

DWB_PRTY_COST_ASGN

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_RSCE_COST

DWB_RSCE_HIST

DWB_RSCE_ORDR

DWB_RSCE_ORDR_LN_ITEM

DWB_RSCE_PRFMNC

DWB_RSCE_STATE_HIST

DWB_RTD_UDR_EVT

DWB_RTL_SL_RTRN_LI

DWB_RTL_TNDR_LI

DWB_RTL_TRX

DWB_SBRP_TERM_VAL

DWB_SL_CMISN_DTL

DWB_SL_CMISN_PYRL

DWB_SMS_EVT

DWB_SRVC_LVL_AGRMNT_VILTN

DWB_SRVC_ORDR

DWB_SRVC_ORDR_LN_ITEM

DWB_SRVC_RQST

DWB_TAP_IN_WRLS_RMNG_EVT

DWB_TAP_OUT_WRLS_RMNG_EVT

DWB_TNDR_CNTRL_TRX

DWB_TRBLE_TCKT

DWB_TRBLE_TCKT_FLD_SPPRT_ASGN

DWB_TRBLE_TCKT_ITEM

DWB_TRKNG_REC

DWB_UDR_EVT

DWB_UDR_EVT_ASGN

DWB_UMS_EVT

DWB_UNIT_ALWNCE

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_BAL_MO

DWD_ACCT_DEBT_MO

DWD_ACCT_FRST_ACTVTY

DWD_ACCT_LAST_ACTVTY

DWD_ACCT_PYMT_DAY

DWD_ACCT_PYMT_MTHD_STAT_HIST

DWD_AGRMNT

DWD_AGRMNT_CHNG

DWD_AGRMNT_RVN_DAY

DWD_BER_FER_ERR_RATIO_DAY

DWD_CANBLZTN_DTL_DAY

DWD_CELL_STTSTC_DAY

DWD_CMISN

DWD_CMPGN_HIST_DAY

DWD_CNT_DAY

DWD_CNTCT_CNTR_DAY

DWD_COST_CNTR

DWD_CUST_COST

DWD_CUST_DNA

DWD_CUST_EQPMNT_INSTLTN_DAY

DWD_CUST_ORDR_DAY

DWD_CUST_ORDR_LN_ITEM_DAY

DWD_CUST_RFMP_SCR

DWD_CUST_SKU_SL_RETRN_DAY

DWD_DATA_USG_DAY

DWD_GIVE_AWAY_ITEM_DAY

DWD_IN_PLTFRM_DAY

DWD_INV_ADJ_ITEM_DAY

DWD_INV_POSN_ITEM_DAY

DWD_INV_RCPT_ITEM_DAY

DWD_INV_UNAVL_ITEM_DAY

DWD_INV_VNDR_CMPLNC_DAY

DWD_INV_XFER_ITEM_DAY

DWD_INVC_AGNG_DAY

DWD_INVC_DAY

DWD_LYLTY_MBR_PNT_DAY

DWD_MKT_SHARE

DWD_MSC_TRFC_DAY

DWD_NBR_PRT_DAY

DWD_NTWK_AVLBLTY_DAY

DWD_NTWK_TCHPNT

DWD_ORG_BSNS_UNT_HRS_DAY

DWD_POS_TNDR_FLOW

DWD_PRCS_INVC_DAY

DWD_PRPD_ACCT_STTSTC_DAY

DWD_PRPD_ALWNCE_DAY

DWD_PRTNR_STLMNT

DWD_RF_NTWK_CPCTY_DAY

DWD_RTL_SL_RETRN_ITEM_DAY

DWD_RVN_DAY

DWD_SL_RPRSTV_STTSTC

DWD_SPLMNTR_SRVC_USG

DWD_SRVC_PRBLM_DAY

DWD_STORE_EFFNCY_DAY

DWD_TMF_KPI

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 NameOLAP Object NameOLAP Object TypeMore Information

CB$ACM

ACM

Cube

Customer Acquisition Cube: ACM


CB$ADM

ADM

Cube

Account Debt Cube: ADM


CB$AGRMNT

AGRMNT

Cube

Agreement Cube: AGRMNT


CB$APM

APM

Cube

Account Payment Cube: APM


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 Offering Cube: CCM


CB$CHRN

CHRN

Cube

Subscriber Churn Statistic Cube: CHRN


CB$CMSN

CMSN

Cube

Commission Cube: CMSN


CB$CMTYP_HCMTYP

CMTYP_HCMTYP

Dimension_Hierarchy

Commission Type: CMTYP


CB$COM

COM

Cube

Cost Organizational Cube: COM


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: CSM


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$GEO_HGEO

GEO_HGEO

Dimension_Hierarchy

Geography: GEO


CB$IAM

IAM

Cube

Invoice Adjustment Cube: IAM


CB$IARSN_HIARSN

IARSN_HIARSN

Dimension_Hierarchy

Invoice Adjustment Reason: IARSN


CB$IATYP_HIATYP

IATYP_HIATYP

Dimension_Hierarchy

Invoice Adjustment Type: IATYP


CB$INVCM

INVCM

Cube

Invoice Customer Type Cube: INVCM


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$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: RVN


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 NameOLAP Object NameOLAP Object TypeMore Information

ACM_FCST_STTSTC_VIEW

ACM_FCST_STTSTC

Cube

Customer Acquisition Forecast Statistic Cube: ACM_FCST_STTSTC


ACM_FCST_VIEW

ACM_FCST

Cube

Customer Acquisition Forecast Cube: ACM_FCST


ACM_VIEW

ACM

Cube

Customer Acquisition Forecast Cube: ACM_FCST


ADM_VIEW

ADM

Cube

Customer Acquisition Cube: ACM


APM_VIEW

APM

Cube

Account Payment Cube: APM


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 Offering Cube: CCM


CHRN_VIEW

CHRN

Cube

Subscriber Churn Statistic Cube: CHRN


CMSN_VIEW

CMSN

Cube

Commission Cube: CMSN


CMTYP_HCMTYP_VIEW

CMTYP_HCMTYP

Hierarchy

Commission Type: CMTYP


CMTYP_VIEW

CMTYP

Dimension

Commission Type: CMTYP


CM_VIEW

CM

Cube

Agreement Cube: AGRMNT


COM_VIEW

COM

Cube

Cost Organizational Cube: COM


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_FCST


CSM_VIEW

CSM

Cube

Cell Statistic Cube: CSM


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


GEO_HGEO_VIEW

GEO_HGEO

Hierarchy

Geography: GEO


GEO_VIEW

GEO

Dimension

Geography: GEO


IAM_VIEW

IAM

Cube

Invoice Adjustment Cube: IAM


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: INVCM


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


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_FCST


RVN_VIEW

RVN

Cube

Revenue Cube: RVN


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



PKs  PK˚FJOEBPS/olap_cdm.htm Oracle Communications Data Model OLAP Model Dimensions