Skip Headers
Oracle® Communications Data Model Reference
Release 11.3.2

E28440-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

8 Oracle Communications Data Model OLAP Model Dimensions

This chapter of Oracle Communications Data Model Reference describes the Data Flow between fact tables and dimension tables of Oracle Communications Data Model relational part to target materialize views and cubes to support the module Oracle Communications Data Model OLAP.

This chapter includes the following sections:

For more information, see Chapter 9, "Oracle Communications Data Model OLAP Model Cubes".

Introduction to OLAP Architecture

Oracle Data Warehouse for Communications (Oracle Communications Data Model Relational) contains the lowest level CDR details, low level combination of base tables and the summary, average, and so on, of Base and Derived data. Oracle Communications Data Model Relational was developed in a relational database.

General Process to Populate the OLAP Module in Oracle Communications Data Model

Oracle Communications Data Model ocdm_sys schema does the following:

  • Directly maps the leaf level data from the relational table/mv into the OLAP cube.

  • Cube organized materialized views represent the cube to SQL-based applications as materialized views that you can use for both refresh and query rewrite. With Query Re-write enabled, Oracle will automatically re-write SQL queries targeted against relational tables. to use the Cube-Organized Materialized View. To use this feature the OLAP cubes and relational components are in a single schema (ocdm_sys).

  • All cubes are available for the end user SQL based Query Tool access through CUBE_TABLE based SQL Views, which are created and maintained automatically during the cube build/update process.

  • Cubes are built from level 0 DWA materialized views or DWB/DWD tables (which, when a date is present, usually means at the month level).

Using SQL to access the cubes and dimensions is a significant feature of Oracle OLAP because it enables reporting tools that only generate SQL to use all of the powerful features of the analytic workspace. In Oracle Database 11g this is achieved by the use of the CUBE_TABLE function that extracts multidimensional data from a cube in an analytic workspace and presents it to the relational SQL engine in the form of a two dimensional table, such as, a set of rows and columns. It provides a mapping between the cube in the analytic workspace and the rows and columns that the SQL sees.

Query Rewrite to Cube Organized Materialized Views

Oracle Communications Data Model uses SQL to query the relational base tables and the optimizer transparently translates the SQL to access either the table materialized views or the cube materialized views (and hence the analytic workspace cubes and dimensions) depending upon which provides the better performance. This allows all of the benefits of the analytic workspace to be easily available to any product using regular SQL.

Oracle Communications Data Model OLAP Dimensions

The dimensions section describes the detail information for all the dimensions. Each dimension includes the following information:

  • Levels

  • Hierarchies

  • Attributes and Attribute mappings

Table 8-1 lists the dimensions.

Account Refund Reason: ARRSN

This dimension keeps all the information for the reason why this refund occurs.

Table 8-2 Account Refund Reason (ARRSN) Levels and Hierarchies

Level Description Account Refund Reason Hierarchy (HARRSN)

TARRSN

Total Account Refund Reason

TARRSN

ARRSN

Account Refund Reason

ARRSN


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-3 Account Refund Reason Long Description Attribute Mapping

Level Mapping (Physical Column)

TARRSN

"Total Account Refund Reason"

ARRSN

DWL_ACCT_RFND_RSN.ACCT_RFND_RSN_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-4 Account Refund Reason Short Description Attribute Mapping

Level Mapping (Physical Column)

TARRSN

"Total Account Refund Reason"

ARRSN

DWL_ACCT_RFND_RSN.ACCT_RFND_RSN_CD


Bank Direct Debit Channel: MOBJTYP

This dimension keeps all the information of media object type.

Table 8-5 Bank Direct Debit Channel (MOBJTYP) Levels and Hierarchies

Level Description Bank Direct Debit Channel Hierarchy (HMOBJTYP)

TMOBJTYP

Total bank direct debit channel

TMOBJTYP

MOBJTYP

Bank direct debit channel

MOBJTYP


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-6 Bank Direct Debit Channel Long Description Attribute Mapping

Level Mapping (Physical Column)

TMOBJTYP

"Total Bank Direct Debit Channel"

MOBJTYP

DWL_MEDIA_OBJ_TYP.MEDIA_OBJ_TYP_DSCR


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-7 Bank Direct Debit Channel Long Description Attribute Mapping

Level Mapping (Physical Column)

TMOBJTYP

"Total Bank Direct Debit Channel"

MOBJTYP

DWL_MEDIA_OBJ_TYP.MEDIA_OBJ_TYP_NAME


Billing Cycle: BCYCL

This dimension keeps all the information of the billing cycle.

Table 8-8 Billing Cycle (BCYCL) Levels and Hierarchies

Level Description Billing Cycle Hierarchy (HBCYCL)

TBCYCL

Totalbilling cycle

TBCYCL

BCYCL

Billing cycle

BCYCL


This dimension keeps all the information of the billing cycle.

Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-9 Billing Cycle Long Description Attribute Mapping

Level Mapping (Physical Column)
 

"Total Billing Cycle"

 

DWR_BLLG_CYCL.BLLG_CYCL_DSCR


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-10 Billing Cycle Long Description Attribute Mapping

Level Mapping (Physical Column)
   
 

DWR_BLLG_CYCL.BLLG_CYCL_NAME


Churn Reason: CRNRSN

This dimension keeps all the information of the Churn Reason. This dimension stores information regarding the reason for subscriber churn. This information is required for churn analysis.

Table 8-11 Churn Reason (CRNRSN) Levels and Hierarchies

Level Description Churn Reason Hierarchy (HCRNRSN)

TCRNRSN

Total Churn Reason

TCRNRSN

CRNRSN

Churn Reason

CRNRSN


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-12 Churn Reason Long Description Attribute Mapping

Level Mapping (Physical Column)

TCRNRSN

"Total Churn Reason"

CRNRSN

DWL_CHRN_RSN.CHRN_RSN_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-13 Churn Reason Short Description Attribute Mapping

Level Mapping (Physical Column)

TCRNRSN

"Total Churn Reason"

CRNRSN

DWL_CHRN_RSN.CHRN_RSN_CD


Collection Agency: CAGNCY

This dimension keeps all the information of the collection agency. Commission type is all type of commissions to the sales representatives.

Table 8-14 Collection Agency (CAGNCY) Levels and Hierarchies

Level Description Collection Agency Hierarchy (HCAGNCY)

TCAGNCY

Total Collection Agency

TCAGNCY

CAGNCY

Collection Agency

CAGNCY


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-15 Collection Agency Long Description Attribute Mapping

Level Mapping (Physical Column)

TCAGNCY

"Total Collection Agency"

CAGNCY

DWR_COLLCTN_AGNCY.PRTY_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-16 Collection Agency Short Description Attribute Mapping

Level Mapping (Physical Column)

TCAGNCY

"Total Collection Agency"

CAGNCY

DWR_COLLCTN_AGNCY.COLLCTN_AGNCY_CD


Attribute Name: Agency Manager(MGR_NAME)

Table 8-17 Collection Agency Agency Manager Attribute Mapping

Level Mapping (Physical Column)

TCAGNCY

 

CAGNCY

DWR_COLLCTN_AGNCY.MGR_NAME


Attribute Name: Domestic Indicator(DMSTC_IND)

Table 8-18 Collection Agency Domestic Indicator Attribute Mapping

Level Mapping (Physical Column)

TCAGNCY

 

CAGNCY

DWR_COLLCTN_AGNCY.DMSTC_IND


Commission Type: CMTYP

This dimension keeps all the information of the commission type. Commission type is all type of commissions to the sales representatives.

Table 8-19 Commission Type (CMTYP) Levels and Hierarchies

Level Description Commission Type Hierarchy (HCMTYP)

TCMTYP

Total Commission Type

TCMTYP

CMTYP

Commission Type

CMTYP


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-20 Commission Type Long Description Attribute Mapping

Level Mapping (Physical Column)

TCMTYP

"Total Commission Type"

CMTYP

DWL_CMISN_TYP.CMISN_TYP_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-21 Commission Type Short Description Attribute Mapping

Level Mapping (Physical Column)

TCMTYP

"Total Commission Type"

CMTYP

DWL_CMISN_TYP.CMISN_TYP_NAME


Cost Center: CCK

This dimension keeps all the information of the cost center.

Table 8-22 Cost Center (CCK) Levels and Hierarchies

Level Description Customer Hierarchy (HCCK)

TCCK

Totalcost center

TCCK

CCK

Cost center

CCK


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-23 Cost Center Long Description Attribute Mapping

Level Mapping (Physical Column)

TCCK

"TotalCost Center

CCK

DWR_COST_CNTR.COST_CNTR_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-24 Cost Center Short Description Attribute Mapping

Level Mapping (Physical Column)

TCCK

"TotalCost Center"

CCK

DWR_COST_CNTR.COST_CNTR_CD


Currency: CRNCY

This dimension keeps all the information of the different currencies.

Table 8-25 Currency (CRNCY) Levels and Hierarchies

Level Description Currency Hierarchy (HCRNCY)

TCRNCY

Total currency

TCRNCY

CRNCY

Currency

CRNCY


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-26 Currency Long Description Attribute Mapping

Level Mapping (Physical Column)

TCRNCY

"Total Currency"

CRNCY

DWL_CRNCY.CRNCY_DSCR


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-27 Currency Type Short Description Attribute Mapping

Level Mapping (Physical Column)

TCRNCY

"Total Currency"

CRNCY

DWL_CRNCY.CRNCY_NAME


Customer: CUST

This dimension keeps all the information of individual customers.

Table 8-28 Customer (CUST) Levels and Hierarchies

Level Description Customer Hierarchy (HCUST)

TCUST

Total customer

TCUST

CUSTYP

Customer Type

CUSTYP

ICUST

Individual Customer

ICUST


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-29 Customer Long Description Attribute Mapping

Level Mapping (Physical Column)

TCUST

"Total Customer"

CUSTYP

DWL_CUST_TYP.CUST_TYP_NAME

ICUST

DWR_CUST.NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-30 Customer Short Description Attribute Mapping

Level Mapping (Physical Column)

TCUST

"Total Customer"

CUSTYP

DWL_CUST_TYP.CUST_TYP_CD

ICUST

DWR_CUST.CUST_CD


Customer Segment: CSGMNT

This dimension keeps all the information of the Customer Segment. The Segments table holds details of all marketing segments. A segment identifies distinct groupings of customers or accounts with similar characteristics. The segments are typically used in marketing campaigns.

Table 8-31 Customer Segment (CSGMNT) Levels and Hierarchies

Level Description Customer Segment Hierarchy (HCSGMNT)

TCSGMNT

Total Customer Segment

TCSGMNT

CSGMNT

Customer Segment

CSGMNT


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-32 Customer Segment Long Description Attribute Mapping

Level Mapping (Physical Column)

TCSGMNT

"Total Customer Segment"

CSGMNT

DWR_CUST_SGMNT.CUST_SGMNT_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-33 Customer Segment Short Description Attribute Mapping

Level Mapping (Physical Column)

TCSGMNT

"Total Customer Segment"

CSGMNT

DWR_CUST_SGMNT.CUST_SGMNT_CD


Customer Type: CUSTYP

This dimension keeps all the information of customer type

Table 8-34 Customer Type (CUSTYP) Levels and Hierarchies

Level Description Customer Type Hierarchy (HCUSTYP)

TCUSTYP

Total Customer Type

TCUSTYP

CUSTYP

Customer Type

CUSTYP


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-35 Customer Type Long Description Attribute Mapping

Level Mapping (Physical Column)

TCUSTYP

"Total Customer Type"

CUSTYP

DWL_CUST_TYP.CUST_TYP_DESC


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-36 Customer Type Short Description Attribute Mapping

Level Mapping (Physical Column)

TCUSTYP

"Total Customer Type"

CUSTYP

DWL_CUST_TYP.CUST_TYP_NAME


Debt Aging Band: DAB

This dimension keeps all the information of debt aging band. There are customers who have not paid or partially paid one or more bills. This is called as Aging for the bill payment. Based on the age of unpaid or partial paid bill those amounts are put into different buckets for each customer.

Table 8-37 Debt Aging Band (DAB) Levels and Hierarchies

Level Description Debt Aging Band Hierarchy (HDAB)

TDAB

Total Aging Band

TDAB

DAB

Aging Band

DAB


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-38 Debt Aging Band Long Description Attribute Mapping

Level Mapping (Physical Column)

TDAB

"Total Aging Band"

DAB

DWL_DEBT_AGNG_BND.DEBT_AGNG_BND_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-39 Debt Aging Band Short Description Attribute Mapping

Level Mapping (Physical Column)

TDAB

"Total Aging Band"

DAB

DWL_DEBT_AGNG_BND.DEBT_AGNG_BND_CD


Geography: GEO

This dimension keeps all the geography information.

Table 8-40 Geography (GEO) Levels and Hierarchies

Level Description Geography Hierarchy (HGEO)

TGEO

Total Geography

TGEO

WORLD

World

WORLD

REGION

Region

REGION

SUB_REGION

Sub Region

SUB_REGION

COUNTRY

Country

COUNTRY

STATE

State

STATE

CITY

City

CITY

COUNTY

County

COUNTY


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-41 Geography Long Description Attribute Mapping

Level Mapping (Physical Column)

TGEO

"Total Geography"

WORLD

DWR_GEO_WORLD.WORLD_NAME

REGION

DWR_GEO_RGN.RGN_NAME

SUB_REGION

DWR_GEO_SBRGN.SB_RGN_NAME

COUNTRY

DWR_GEO_CNTRY.CNTRY_NAME

STATE

DWR_GEO_STATE.STATE_NAME

CITY

DWR_GEO_CITY.CITY_NAME

COUNTY

DWR_GEO_CNTY.CNTY_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-42 Geography Short Description Attribute Mapping

Level Mapping (Physical Column)

TGEO

"Total Geography"

WORLD

DWR_GEO_WORLD.WORLD_CD

REGION

DWR_GEO_RGN.RGN_CD

SUB_REGION

DWR_GEO_SBRGN.SB_RGN_CD

COUNTRY

DWR_GEO_CNTRY.CNTRY_CD

STATE

DWR_GEO_STATE.STATE_CD

CITY

DWR_GEO_CITY.CITY_CD

COUNTY

DWR_GEO_CNTY.CNTY_CD


Attribute Name: County Name(CNTY_NAME)

Table 8-43 Geography County Name Attribute Mapping

Level Mapping (Physical Column)

TGEO

 

WORLD

 

REGION

 

SUB_REGION

 

COUNTRY

 

STATE

 

CITY

 

COUNTY

DWR_GEO_CNTY.CNTY_NAME


Attribute Name: County Code(CNTY_CD)

Table 8-44 Geography County Code Attribute Mapping

Level Mapping (Physical Column)

TGEO

 

WORLD

 

REGION

 

SUB_REGION

 

COUNTRY

 

STATE

 

CITY

 

COUNTY

DWR_GEO_CNTY.CNTY_CD


Handset Model: HSMDL

This dimension keeps all the information about models of handsets.

Table 8-45 Handset Model (HSMDL) Levels and Hierarchies

Level Description Handset Model Hierarchy (HHSMDL)

THSMDL

Total Handset Model

THSMDL

HSMDL

Handset Model

HSMDL


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-46 Handset Model Long Description Attribute Mapping

Level Mapping (Physical Column)

THSMDL

"Total Handset Model"

HSMDL

DWR_HNDST_MDL.HNDST_MDL_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-47 Handset Model Short Description Attribute Mapping

Level Mapping (Physical Column)

THSMDL

"Total Handset Model"

HSMDL

DWR_HNDST_MDL.HNDST_MDL_CD


Invoice Adjustment Reason: IARSN

This dimension keeps all the information of invoice adjustment reason. The reason why the adjustment was put on the invoice.

Table 8-48 Invoice Adjustment Reason (IARSN) Levels and Hierarchies

Level Description Invoice Adjustment Reason Hierarchy (HIARSN)

TIARSN

Total Invoice Adjustment Reason

TIARSN

IARSN

Invoice Adjustment Reason

IARSN


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-49 Invoice Adjustment Reason Long Description Attribute Mapping

Level Mapping (Physical Column)

TIARSN

"Total Invoice Adjustment Reason"

IARSN

DWL_INVC_ADJ_RSN.INVC_ADJ_RSN_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-50 Invoice Adjustment Reason Short Description Attribute Mapping

Level Mapping (Physical Column)

TIARSN

"Total Invoice Adjustment Reason"

IARSN

DWL_INVC_ADJ_RSN.INVC_ADJ_RSN_CD


Invoice Adjustment Type: IATYP

This dimension keeps all the information of invoice adjustment type. The categories of adjustment applied to a Customer Invoices.

Table 8-51 Invoice Adjustment Type (IATYP) Levels and Hierarchies

Level Description Invoice Adjustment Type Hierarchy (HIATYP)

TIATYP

Total invoice adjustment type

TIATYP

IATYP

Invoice adjustment type

IATYP


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-52 Invoice Adjustment Type Long Description Attribute Mapping

Level Mapping (Physical Column)

TIATYP

"Total Invoice Adjustment Type"

IATYP

DWL_INVC_ADJ_TYP.INVC_ADJ_TYP_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-53 Invoice Adjustment Type Short Description Attribute Mapping

Level Mapping (Physical Column)

TIATYP

"Total Invoice Adjustment Type"

IATYP

DWL_INVC_ADJ_TYP.INVC_ADJ_TYP_CD


Organization: ORG

This dimension keeps all the information of organization

Default Hierarchy: HCHAIN

Table 8-54 Organization (ORG) Levels and Hierarchies

Level Description Corporation Hierarchy (HCORPORATE) Banner Hierarchy (HBANNER) Chain Hierarchy (HCHAIN)

TORG

Organization Total

TORG

TORG

TORG

CORPORATION

Head Office or Parent Company.

CORPORATION

CORPORATION

CORPORATION

COMPANY

Company, it includes branch company or subsidiary company.

   

COMPANY

DIVISION

The parent level of business unit. It is to organize the organization business units according to their functional role, for example, call center, warehouse, and so on.

DIVISION

   

BANNER

Holds the information about different organization banners under which product or service are sold.

 

BANNER

 

CHAIN

Chain of outlets through which the organization conducts business.

   

CHAIN

AREA

Areas within a organization chain.

   

AREA

REGION

Holds region within a company, chain area.

   

REGION

DISTRICT

Holds districts within a company, chain, area, region.

   

DISTRICT

BU

Organization Business Unit contains 2 kinds of information -store and branch company. In the higher level is branch company.Some customer cannot belong to a particular store, in that case, they are associated with a branch company. So branch company are put in organization business unit level.

BU

BU

BU


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-55 Organization Long Description Attribute Mapping

Level Mapping (Physical Column)

TORG

'Total Organization'

CORPORATION

DWR_ORG_RGN.RGN_NAME

COMPANY

DWR_ORG_CMPNY.CMPNY_NAME

DIVISION

DWR_ORG_DIV.DIV_NAME

BANNER

DWR_ORG_BNR.BNR_NAME

CHAIN

DWR_ORG_CHAIN.CHAIN_NAME

AREA

DWR_ORG_AREA.AREA_NAME

REGION

DWR_ORG_RGN.RGN_NAME

DISTRICT

DWR_ORG_RGN.RGN_NAME

BU

DWR_ORG_BSNS_UNIT.PRTY_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-56 Organization Short Description Attribute Mapping

Level Mapping (Physical Column)

TORG

 

CORPORATION

DWR_ORG_CRPRT.CRPRT_CD

COMPANY

DWR_ORG_CMPNY.CMPNY_CD

DIVISION

DWR_ORG_DIV.DIV_CD

BANNER

DWR_ORG_BNR.BNR_CD

CHAIN

DWR_ORG_CHAIN.CHAIN_CD

AREA

DWR_ORG_AREA.AREA_CD

REGION

DWR_ORG_RGN.RGN_CD

DISTRICT

DWR_ORG_DSTRCT.DSTRCT_CD

BU

DWR_ORG_BSNS_UNIT.PRTY_CD


Attribute Name: Store Name (STORE_NAME)

Table 8-57 Organization Store Name Attribute Mapping

Level Mapping (Physical Column)

TORG

 

CORPORATION

 

COMPANY

 

DIVISION

 

BANNER

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

BU

DWR_ORG_BSNS_UNIT.PRTY_NAME


Attribute Name: Store Description (STORE_DESC)

Table 8-58 Organization Store Description Attribute Mapping

Level Mapping (Physical Column)

TORG

 

CORPORATION

 

COMPANY

 

DIVISION

 

BANNER

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

BU

DWR_ORG_BSNS_UNIT.PRTY_DSCR


Attribute Name: Store Manager (STORE_MANAGER)

Table 8-59 Organization Store Manager Attribute Mapping

Level Mapping (Physical Column)

TORG

 

CORPORATION

 

COMPANY

 

DIVISION

 

BANNER

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

BU

DWR_ORG_BSNS_UNIT.MGR_NAME


Attribute Name: Store Open Date (STORE_OPEN_DT)

Table 8-60 Organization Store Open Date Attribute Mapping

Level Mapping (Physical Column)

TORG

 

CORPORATION

 

COMPANY

 

DIVISION

 

BANNER

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

BU

DWR_ORG_BSNS_UNIT.VALID_STRT_DT


Attribute Name: Store Close Date (STORE_CLOSE_DT)

Table 8-61 Organization Store Close Date Attribute Mapping

Level Mapping (Physical Column)

TORG

 

CORPORATION

 

COMPANY

 

DIVISION

 

BANNER

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

BU

DWR_ORG_BSNS_UNIT.VALID_END_DT


Payment Channel: PCK

This dimension keeps all the information all the information of the payment channel.

Table 8-62 Payment Channel (PCK) Levels and Hierarchies

Level Description Payment Channel Hierarchy (HPCK)

TPCK

Totalpayment channel

TPCK

PCK

Payment channel

PCK


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-63 Payment Channel Long Description Attribute Mapping

Level Mapping (Physical Column)

TPCK

"TotalPayment Channel"

PCK

DWR_PYMT_CHNL.CHNL_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-64 Payment Channel Short Description Attribute Mapping

Level Mapping (Physical Column)

TPCK

"TotalPayment Channel"

PCK

DWR_PYMT_CHNL.CHNL_KEY


Payment Method Type: PMTYP

This dimension keeps all the information of the payment method type. Payment method type describes the different methods by which payments may be made. Customers can pay their bills, deposits, other charges by different modes of payment such as: Cash, Check, Inter-bank transfer, Postal order, Wire transfer, Voucher.

Table 8-65 Payment Method Type (PMTYP) Levels and Hierarchies

Level Description Payment Method Type Hierarchy (HPMTYP)

TPMTYP

Total Payment Method Type

TPMTYP

PMTYP

Payment Method Type

PMTYP


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-66 Payment Method Type Long Description Attribute Mapping

Level Mapping (Physical Column)

TPMTYP

"Total Payment Method Type"

PMTYP

DWL_PYMT_MTHD_TYP.PYMT_MTHD_TYP_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-67 Payment Method Type Short Description Attribute Mapping

Level Mapping (Physical Column)

TPMTYP

"Total Account Payment Method Status Type"

PMTYP

DWL_PYMT_MTHD_TYP.PYMT_MTHD_TYP_CD


Payment Transaction Type: PTTYP

This dimension keeps all the information of the type of transaction.

Table 8-68 Payment Transaction Type (PTTYP) Levels and Hierarchies

Level Description Payment Transaction Type Hierarchy (HPTTYP)

TPTTYP

Total Payment Transaction Type

TPTTYP

PTTYP

Payment transaction type

PTTYP


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-69 Payment Transaction Type Long Description Attribute Mapping

Level Mapping (Physical Column)

TPTTYP

"Total Payment Transaction Type"

PTTYP

DWL_PYMT_TRX_TYP.PYMT_TRX_TYP_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-70 Payment Transaction Type Short Description Attribute Mapping

Level Mapping (Physical Column)

TPTTYP

"Total Payment Transaction Type"

PTTYP

DWL_PYMT_TRX_TYP. PYMT_TRX_TYP_CD


Peak Offpeak Time: POPT

This dimension keeps all the information of the peak and offpeak time. Based on the usage or traffic on the network each day is divided into various time slots such as the time when the usage is highest is called as the peak time slot

Table 8-71 Peak Offpeak Time (POPT) Levels and Hierarchies

Level Description Peak Offpeak Time Hierarchy (HPOPT)

TPOPT

Total Peak Offpeak Time

TPOPT

POPT

Peak Offpeak Time

POPT


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-72 Peak Offpeak Time Long Description Attribute Mapping

Level Mapping (Physical Column)

TPOPT

"Total Peak Offpeak Time"

POPT

DWL_PK_OFPK_TIME.PK_OFPK_TIME_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-73 Peak Offpeak Time Short Description Attribute Mapping

Level Mapping (Physical Column)

TPOPT

"Total Peak Offpeak Time"

POPT

DWL_PK_OFPK_TIME.PK_OFPK_TIME_CD


Attribute Name: Peak Offpeak Start Time(PK_OFPK_STRT)

Table 8-74 Peak Offpeak Time Peak Offpeak Start Time Attribute Mapping

Level Mapping (Physical Column)

TPOPT

 

POPT

DWL_PK_OFPK_TIME.PK_OFPK_STRT


Attribute Name: Peak Offpeak End Time(PK_OFPK_END)

Table 8-75 Peak Offpeak Time Peak Offpeak End Time Attribute Mapping

Level Mapping (Physical Column)

TPOPT

 

POPT

DWL_PK_OFPK_TIME.PK_OFPK_END


Attribute Name: Holiday Indicator (HOLIDY_IND)

Table 8-76 Peak Offpeak Time Holiday Indicator Attribute Mapping

Level Mapping (Physical Column)

TPOPT

 

POPT

DWL_PK_OFPK_TIME.HOLIDY_IND


Attribute Name: Weekend Indicator (WEEKEND_IND)

Table 8-77 Peak Offpeak Time Weekend Indicator Attribute Mapping

Level Mapping (Physical Column)

TPOPT

 

POPT

DWL_PK_OFPK_TIME.WKEND_IND


Product: PROD

This dimension keeps all the information of products, services and value added features offering by the telecommunication company.

Table 8-78 Product (PROD) Levels and Hierarchies

Level Description Product Hierarchy (HPROD)

TPROD

Total Product

TPROD

PRODTYP

Type of the product

PRODTYP

PROD

The product provided by the carrier.

PROD


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-79 Product Long Description Attribute Mapping

Level Mapping (Physical Column)

TPROD

"Total Product"

PRODTYP

DWL_PROD_SPEC_TYP.PROD_SPEC_TYP_NAME

PROD

DWR_PROD_SPEC.PROD_SPEC_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-80 Product Short Description Attribute Mapping

Level Mapping (Physical Column)

TPROD

"Total Product"

PRODTYP

DWL_PROD_SPEC_TYP.PROD_SPEC_TYP_CD

PROD

DWR_PROD_SPEC.PROD_SPEC_CD


Attribute Name: IN Platform Key(IN_PLTFRM_KEY)

Id for IN Platform

Table 8-81 Product IN Platform Key Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PRODTYP

 

PROD

DWR_PROD_SPEC.IN_PLTFRM_KEY


Product Offer: POFR

This dimension keeps all the information of the product offer.

Table 8-82 Product Offer (ARRSN) Levels and Hierarchies

Level Description Product Hierarchy (HPOFR)

TPOFR

Totalproduct offer

TPOFR

POFRTYPE

Product offer type

POFRTYPE

POFR

Product offer

POFR


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-83 Product Offer Long Description Attribute Mapping

Level Mapping (Physical Column)

TPOFR

Total Product Offer

POFRTYPE

DWL_PROD_OFR_TYP.PROD_OFR_TYP_NAME

POFR

DWL_PROD_OFR_TYP.PROD_OFR_TYP_CD


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-84 Product Offer Short Description Attribute Mapping

Level Mapping (Physical Column)

TPOFR

Total Product Offer'

POFRTYPE

DWR_CALL_CNTR. CALL_CNTR_CD

POFR

DWR_PROD_OFR.PROD_OFR_CD


Attribute Name: Joint Program Indicator (JP_IND)

Table 8-85 Product Offer Joint Program Indicator Attribute Mapping

Level Mapping (Physical Column)

TPOFR

 

POFRTYPE

 

POFR

DWR_PROD_OFR.JNT_PROG_IND


Attribute Name: Loyalty Program Indicator (LP_IND)

Table 8-86 Product Offer Loyalty Program Indicator Attribute Mapping

Level Mapping (Physical Column)

TPOFR

 

POFRTYPE

 

POFR

DWR_PROD_OFR.LYLTY_PROG_IND


Attribute Name: New Customer Only Indicator (NC_IND)

Table 8-87 Product Offer New Customer Only Indicator Attribute Mapping

Level Mapping (Physical Column)

TPOFR

 

POFRTYPE

 

POFR

DWR_PROD_OFR.NEW_CUST_ONLY_IND


Attribute Name: VAS Indicator (VAS_IND)

Table 8-88 Product Offer VAS Indicator Attribute Mapping

Level Mapping (Physical Column)

TCCNTR

 

CCNTR

 

CCAT

DWR_PROD_OFR.VAS_IND


Promotion: PRMTN

This dimension keeps all the information of the promotion.

Table 8-89 Promotion (PRMTN) Levels and Hierarchies

Level Description Promotion Hierarchy (HPRMTN)

TPRMTN

Total promotion

TPRMTN

PRMTNTYP

Promotion type

PRMTNTYP

CCCSTYP

Promotion

CCCSTYP


Table 8-90 Promotion (HCMPGN) Levels and Hierarchies

Level Description Promotion Hierarchy (HCMPGN)

TPRMTN

Total promotion

TPRMTN

CMPGN

Campaign

CMPGN

PRMTN

Promotion

PRMTN


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-91 Promotion Long Description Attribute Mapping

Level Mapping (Physical Column)

TCCC

"Total Promotion"

PRMTNTYP

DWL_PRMTN_TYP.PRMTN_TYP_NAME

CMPGN

DWR_CMPGN.CMPGN_DSCR

PRMTN

DWR_PRMTN.PRMTN_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-92 Promotion Short Description Attribute Mapping

Level Mapping (Physical Column)

TCCC

"Total Promotion"

PRMTNTYP

DWL_PRMTN_TYP.PRMTN_TYP_CD

CMPGN

DWR_CMPGN.CMPGN_CD

PRMTN

DWR_PRMTN.PRMTN_CD


Resource: RSCEK

This dimension keeps all the information for resources.

Table 8-93 Resource (RSCEK) Levels and Hierarchies

Level Description Resource Hierarchy (HRSCEK)

TRSCEK

Total resource

TRSCEK

RSCEK

Resource

RSCEK


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-94 Resource Long Description Attribute Mapping

Level Mapping (Physical Column)

TRSCEK

"Total Resourc"

RSCEK

DWR_RSCE.RSCE_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-95 Resource Short Description Attribute Mapping

Level Mapping (Physical Column)

TRSCEK

"Total Resource"

RSCEK

DWR_RSCE.RSCE_CD


Sales Channel: SLCHNL

This dimension keeps all the information of Sales Channel.

Table 8-96 Sales Channel (SLCHNL) Levels and Hierarchies

Level Description Sales Channel Hierarchy (HSLCHNL)

TSLCHNL

Total Sales Channel

TSLCHNL

SLCHNL

Sales Channel

SLCHNL


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-97 Sales Channel Long Description Attribute Mapping

Level Mapping (Physical Column)

TSLCHNL

"Total Sales Channel"

SLCHNL

DWR_SL_CHNL.CHNL_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-98 Sales Channel Short Description Attribute Mapping

Level Mapping (Physical Column)

TSLCHNL

"Total Sales Channel"

SLCHNL

DWR_SL_CHNL.CHNL_CD


Attribute Name: Capacity Quantity (CPCTY_QTY):

The number of transaction that a Channel can handle, at a point of time.

Table 8-99 Sales Channel Capacity Quantity Attribute Mapping

Level Mapping (Physical Column)

TSLCHNL

 

SLCHNL

DWR_SL_CHNL.CPCTY_QTY


Sales Channel Representative: SLR

This dimension keeps all the information for the sales channel representative.

Table 8-100 Sales Channel Representative (SLR) Levels and Hierarchies

Level Description Sales Channel Representative Hierarchy (HRSCEK)

TSLR

Total sales channelrepresentative

TSLR

SLR

Sales channelrepresentive

SLR


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-101 Sales Channel Representative Long Description Attribute Mapping

Level Mapping (Physical Column)

TSLR

Total Sale Channel Representative'

SLR

DWR_SL_CHNL_RPRSTV.SL_CHNL_RPRSTV_CD


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-102 Sales Channel Representative Short Description Attribute Mapping

Level Mapping (Physical Column)

TSLR

Total Sale Channel Representative'

SLR

DWR_SL_CHNL_RPRSTV.SL_CHNL_RPRSTV_CD


SKU Item: SKUITEM

This dimension stores the products as SKU items used in Oracle Communications Data Model.

Default Hierarchy:

Table 8-103 Product Hierarchy and Cluster Hierarchy

Level Description Product Hierarchy (HPROD) Product Cluster Hierarchy (HPCLUSTER)

TPROD

Total Product

TPROD

TPROD

PCLUSTER

Product Cluster

 

PCLUSTER

COMPANY

Company

COMPANY

 

DIVISION

Division

DIVISION

 

GROUPFoot 1 

Group

GROUP

 

DEPT

Department

DEPT

 

CLASS

Class

CLASS

 

SUBCLASS

Sub Class

SUBCLASS

 

ITEM

Item

ITEM

ITEM

SKU

SKU Item

SKU

SKU


Footnote 1 For Oracle Communications Data Model for OLAP 11g, this level is named GROUP. However, since GROUP is a restricted keyword for Oracle OLAP 11g metadata, in Oracle Communications Data Model for OLAP 11g, this level has been renamed to GROUP1. The Level Description continues to be Group in both versions.

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-104 Product Long Description Attribute Mapping

Level Mapping (Physical Column)

TPROD

'Total Product'

PCLUSTER

DWR_ITEM_CLSTR.ITEM_CLSTR_DESC

COMPANY

DWR_ITEM_CMPNY.ITEM_CMPNY_NAME

DIVISION

DWR_ITEM_DIV.ITEM_DIV_NAME

GROUP

DWR_ITEM_GRP.ITEM_GRP_NAME

DEPT

DWR_ITEM_DEPT.ITEM_DEPT_NAME

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_NAME

SUBCLASS

DWR_ITEM_SBC.SBC_NAME

ITEM

DWR_ITEM.ITEM_DESC

SKU

DWR_SKU_ITEM.SKU_ITEM_DESC


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-105 Product Short Description Attribute Mapping

Level Mapping (Physical Column)

TPROD

'Total Product'

PCLUSTER

DWR_ITEM_CLSTR.ITEM_CLSTR_CD

COMPANY

DWR_ITEM_CMPNY.ITEM_CMPNY_CD

DIVISION

DWR_ITEM_DIV.ITEM_DIV_CD

GROUP

DWR_ITEM_GRP.ITEM_GRP_CD

DEPT

DWR_ITEM_DEPT.ITEM_DEPT_CD

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_CD

SUBCLASS

DWR_ITEM_SBC.SBC_CD

ITEM

DWR_ITEM.ITEM_NAME

SKU

DWR_SKU_ITEM.SKU_ITEM_NAME


Attribute Name: Buyer Code (BUYER_CODE)

Table 8-106 Product Buyer Code Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

DWR_ITEM_DIV.ITEM_DIV_BYR_CD

GROUP

DWR_ITEM_GRP.ITEM_GRP_BYR_CD

DEPT

DWR_ITEM_DEPT.ITEM_DEPT_BYR_CD

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_BYR_CD

SUBCLASS

DWR_ITEM_SBC.SBC_BYR_CD

ITEM

 

SKU

 

Attribute Name: Buyer Name (BUYER_NAME)

Table 8-107 Product Buyer Name Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

DWR_ITEM_DIV.ITEM_DIV_BYR_NAME

GROUP

DWR_ITEM_GRP.ITEM_GRP_BYR_NAME

DEPT

DWR_ITEM_DEPT.ITEM_DEPT_BYR_NAME

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_BYR_NAME

SUBCLASS

DWR_ITEM_SBC.SBC_BYR_NAME

ITEM

 

SKU

 

Attribute Name: Item Conv Type Code (ITEM_CONV_TYPE_CD)

Table 8-108 Product Item Conv Type Code Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

 

GROUP

 

DEPT

 

CLASS

 

SUBCLASS

 

ITEM

DWR_ITEM.CONVBL_TYP_CD

SKU

 

Attribute Name: Item Discount Indicator (ITEM_DISC_IND)

Table 8-109 Product Item Discount Indicator Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

 

GROUP

 

DEPT

 

CLASS

 

SUBCLASS

 

ITEM

DWR_ITEM.DISC_IND

SKU

 

Attribute Name: Item Display Unit Type Code (ITEM_DISP_UNIT_TYP_CD)

Table 8-110 Product Item Display Unit Type Code Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

 

GROUP

 

DEPT

 

CLASS

 

SUBCLASS

 

ITEM

DWR_ITEM.DSPLY_UNIT_TYP_CD

SKU

 

Attribute Name: Item Number (ITEM_NBR)

Table 8-111 Product Item Number Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

 

GROUP

 

DEPT

 

CLASS

 

SUBCLASS

 

ITEM

DWR_ITEM.ITEM_NBR

SKU

 

Attribute Name: Merchandiser Code (MERC_CODE)

Table 8-112 Product Merchandiser Code Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

DWR_ITEM_DIV.ITEM_DIV_MRCHNDSR_CD

GROUP

DWR_ITEM_GRP.ITEM_GRP_MRCHNDSR_CD

DEPT

DWR_ITEM_DEPT.DEPT_MRCHNDSR_CD

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_MRCHNDSR_CD

SUBCLASS

DWR_ITEM_SBC.SBC_MRCHNDSR_CD

ITEM

 

SKU

 

Attribute Name: Merchandiser Name (MERC_NAME)

Table 8-113 Product Merchandiser Name Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

DWR_ITEM_DIV.ITEM_DIV_MRCHNDSR_NAME

GROUP

DWR_ITEM_GRP.ITEM_GRP_MRCHNDSR_NAME

DEPT

DWR_ITEM_DEPT.DEPT_MRCHNDSR_NAME

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_MRCHNDSR_NAME

SUBCLASS

DWR_ITEM_SBC.SBC_MRCHNDSR_NAME

ITEM

 

SKU

 

Attribute Name: SKU Item Number (SKU_ITEM_NBR)

Table 8-114 Product SKU Item Number Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

 

GROUP

 

DEPT

 

CLASS

 

SUBCLASS

 

ITEM

 

SKU

DWR_SKU_ITEM.SKU_ITEM_NBR


Time: TIME

This dimension keeps all the information of time.

Table 8-115 Time (TIME) Levels and Hierarchies

Level Description Time Business Hierarchy (HTBSNS)

TTIME

Time Total

TTIME

BSNS_YR

Business Year

BSNS_YR

BSNS_HLF_YR

Business Half Year

BSNS_HLF_YR

BSNS_QTR

Business Quarter

BSNS_QTR

BSNS_MO

Business Month

BSNS_MO


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-116 Time Long Description Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TIME_TOT.TOT_DSCR

BSNS_YR

DWR_BSNS_YR.BSNS_YR_DSCR

BSNS_HLF_YR

DWR_BSNS_HLF_YR.BSNS_HLF_YR_DSCR

BSNS_QTR

DWR_BSNS_QTR.BSNS_QTR_DSCR

BSNS_MO

DWR_BSNS_MO.BSNS_MO_DSCR


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-117 Time Short Description Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TIME_TOT.TOT_CD

BSNS_YR

DWR_BSNS_YR.BSNS_YR_CD

BSNS_HLF_YR

DWR_BSNS_HLF_YR.BSNS_HLF_YR_CD

BSNS_QTR

DWR_BSNS_QTR.BSNS_QTR_CD

BSNS_MO

DWR_BSNS_MO.BSNS_MO_CD


Attribute Name: Time Number(TIME_NBR)

Table 8-118 Time Time Number Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TIME_TOT.TOT_NBR

BSNS_YR

DWR_BSNS_YR.BSNS_YR_NBR

BSNS_HLF_YR

DWR_BSNS_HLF_YR.BSNS_HLF_YR_NBR

BSNS_QTR

DWR_BSNS_QTR.BSNS_QTR_NBR

BSNS_MO

DWR_BSNS_MO.BSNS_MO_NBR


Attribute Name: Time Span(TIME_SPAN)

Table 8-119 Time Time Span Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TIME_TOT.TOT_TIMESPN

BSNS_YR

DWR_BSNS_YR.BSNS_YR_TIMESPN

BSNS_HLF_YR

DWR_BSNS_HLF_YR.BSNS_HLF_YR_TIMESPN

BSNS_QTR

DWR_BSNS_QTR.BSNS_QTR_TIMESPN

BSNS_MO

DWR_BSNS_MO.BSNS_MO_TIMESPN


Attribute Name: Start Date(START_DATE)

Table 8-120 Time Start Date Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TIME_TOT.TOT_STRT_DT

BSNS_YR

DWR_BSNS_YR.BSNS_YR_STRT_DT

BSNS_HLF_YR

DWR_BSNS_HLF_YR.BSNS_HLF_YR_STRT_DT

BSNS_QTR

DWR_BSNS_QTR.BSNS_QTR_ STRT_DT

BSNS_MO

DWR_BSNS_MO.BSNS_MO_STRT_DT


Attribute Name: End Date(END_DATE)

Table 8-121 Time End Date Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TIME_TOT.TOT_END_DT

BSNS_YR

DWR_BSNS_YR.BSNS_YR_END_DT

BSNS_HLF_YR

DWR_BSNS_HLF_YR.BSNS_HLF_YR_END_DT

BSNS_QTR

DWR_BSNS_QTR.BSNS_QTR_END_DT

BSNS_MO

DWR_BSNS_MO.BSNS_MO_END_DT


Time Day: TIME_DAY

This dimension stores Time related data used in Oracle Communications Data Model.

Default Hierarchy: HTBSNS

Table 8-122 Time Levels and Hierarchies

Level Description Time Business Hierarchy (HTBSNS) Time Calendar Hierarchy (HTCLNDR) Time Calendar Week Hierarchy (HTCLNDRWK)

TTIME

Total Time

TTIME

TTIME

TTIME

CLNDR_YR

Calendar Year

 

CLNDR_YR

 

CLNDR_HLF_YR

Calendar Half Year

 

CLNDR_HLF_YR

 

CLNDR_QTR

Calendar Quarter

 

CLNDR_QTR

 

CLNDR_MO

Calendar Month

 

CLNDR_MO

 

CLNDR_HLF_MO

Calendar Half Month

 

CLNDR_HLF_MO

 

CLNDR_WK

Calendar Week

 

CLNDR_WK

CLNDR_WK

BSNS_YR

Business Year

BSNS_YR

   

BSNS_HLF_YR

Business Half Year

BSNS_HLF_YR

   

BSNS_QTR

Business Quarter

BSNS_QTR

   

BSNS_MO

Business Month

BSNS_MO

   

BSNS_HLF_MO

Business Half Month

BSNS_HLF_MO

   

BSNS_WK

Business Week

BSNS_WK

   

DAY

Day

DAY

DAY

DAY


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-123 Time Long Description Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TOT_TIME.TOT_DSCR

CLNDR_YR

DWR_CLNDR_YR.YR_DSCR

CLNDR_HLF_YR

DWR_CLNDR_HLF_YR.HLF_YR_DSCR

CLNDR_QTR

DWR_CLNDR_QTR.QTR_DSCR

CLNDR_MO

DWR_CLNDR_MO.MO_DSCR

CLNDR_HLF_MO

DWR_CLNDR_HLF_MO.HLF_MO_DSCR

CLNDR_WK

DWR_CLNDR_WK.WK_DSCR

BSNS_YR

DWR_BSNS_YR.YR_DSCR

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_DSCR

BSNS_QTR

DWR_BSNS_QTR.QTR_DSCR

BSNS_MO

DWR_BSNS_MO.MO_DSCR

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_DSCR

BSNS_WK

DWR_BSNS_WK.WK_DSCR

DAY

DWR_DAY.BSNS_DT_DSCR


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-124 Time Short Description Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TOT_TIME.TOT_CD

CLNDR_YR

DWR_CLNDR_YR.YR_CD

CLNDR_HLF_YR

DWR_CLNDR_HLF_YR.HLF_YR_CD

CLNDR_QTR

DWR_CLNDR_QTR.QTR_CD

CLNDR_MO

DWR_CLNDR_MO.MO_CD

CLNDR_HLF_MO

DWR_CLNDR_HLF_MO.HLF_MO_CD

CLNDR_WK

DWR_CLNDR_WK.WK_CD

BSNS_YR

DWR_BSNS_YR.YR_CD

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_CD

BSNS_QTR

DWR_BSNS_QTR.QTR_CD

BSNS_MO

DWR_BSNS_MO.MO_CD

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_CD

BSNS_WK

DWR_BSNS_WK.WK_CD

DAY

DWR_DAY.BSNS_DT_DSCR


Attribute Name: End Date (END_DATE)

Table 8-125 Time End Date Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TOT_TIME.END_DATE

CLNDR_YR

DWR_CLNDR_YR.YR_END_DT

CLNDR_HLF_YR

DWR_CLNDR_HLF_YR.HLF_YR_END_DT

CLNDR_QTR

DWR_CLNDR_QTR.QTR_END_DT

CLNDR_MO

DWR_CLNDR_MO.MO_END_DT

CLNDR_HLF_MO

DWR_CLNDR_HLF_MO.HLF_MO_END_DT

CLNDR_WK

DWR_CLNDR_WK.WK_END_DT

BSNS_YR

DWR_BSNS_YR.YR_END_DT

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_END_DT

BSNS_QTR

DWR_BSNS_QTR.QTR_END_DT

BSNS_MO

DWR_BSNS_MO.MO_END_DT

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_END_DT

BSNS_WK

DWR_BSNS_WK.WK_END_DT

DAY

DWR_DAY.BSNS_END_DT


Attribute Name: Time Span (TIME_SPAN)

Table 8-126 Time Time Span Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TOT_TIME.TOT_TIME_SPAN

CLNDR_YR

DWR_CLNDR_YR.YR_TIMESPN

CLNDR_HLF_YR

DWR_CLNDR_HLF_YR.HLF_YR_TIMESPN

CLNDR_QTR

DWR_CLNDR_QTR.QTR_TIMESPN

CLNDR_MO

DWR_CLNDR_MO.MO_TIMESPN

CLNDR_HLF_MO

DWR_CLNDR_HLF_MO.HLF_MO_TIMESPN

CLNDR_WK

DWR_CLNDR_WK.WK_TIMESPN

BSNS_YR

DWR_BSNS_YR.YR_TIMESPN

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_TIMESPN

BSNS_QTR

DWR_BSNS_QTR.QTR_TIMESPN

BSNS_MO

DWR_BSNS_MO.MO_TIMESPN

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_TIMESPN

BSNS_WK

DWR_BSNS_WK.WK_TIMESPN

DAY

DWR_DAY.BSNS_DAY_TIMESPAN


Attribute Name: Business Holiday Indicator (BSNS_HLDY_IND)

Table 8-127 Time Business Holiday Indicator Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

 

CLNDR_HLF_YR

 

CLNDR_QTR

 

CLNDR_MO

 

CLNDR_HLF_MO

 

CLNDR_WK

 

BSNS_YR

 

BSNS_HLF_YR

 

BSNS_QTR

 

BSNS_MO

 

BSNS_HLF_MO

 

BSNS_WK

 

DAY

DWR_DAY.BSNS_HOLIDY_IND


Attribute Name: Business Weekend Indicator (BSNS_WEND_IND)

Table 8-128 Time Business Weekend Indicator Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

 

CLNDR_HLF_YR

 

CLNDR_QTR

 

CLNDR_MO

 

CLNDR_HLF_MO

 

CLNDR_WK

 

BSNS_YR

 

BSNS_HLF_YR

 

BSNS_QTR

 

BSNS_MO

 

BSNS_HLF_MO

 

BSNS_WK

 

DAY

DWR_DAY.BSNS_WEEKEND_IND


Attribute Name: Business Working Day Indicator (BSNS_WRK_IND)

Table 8-129 Time Business Working Day Indicator Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

 

CLNDR_HLF_YR

 

CLNDR_QTR

 

CLNDR_MO

 

CLNDR_HLF_MO

 

CLNDR_WK

 

BSNS_YR

 

BSNS_HLF_YR

 

BSNS_QTR

 

BSNS_MO

 

BSNS_HLF_MO

 

BSNS_WK

 

DAY

DWR_DAY.BSNS_WRKING_DAY_IND


Attribute Name: Number (NBR)

Table 8-130 Time Number Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

TO_NUMBER(DWR_CLNDR_YR.YR_NBR)

CLNDR_HLF_YR

TO_NUMBER(DWR_CLNDR_HLF_YR.HLF_YR_NBR)

CLNDR_QTR

TO_NUMBER(DWR_CLNDR_QTR.QTR_NBR)

CLNDR_MO

TO_NUMBER(DWR_CLNDR_MO.MO_NBR)

CLNDR_HLF_MO

TO_NUMBER(DWR_CLNDR_HLF_MO.HLF_MO_NBR)

CLNDR_WK

TO_NUMBER(DWR_CLNDR_WK.WK_NBR)

BSNS_YR

TO_NUMBER(DWR_BSNS_YR.YR_NBR)

BSNS_HLF_YR

TO_NUMBER(DWR_BSNS_HLF_YR.HLF_YR_NBR)

BSNS_QTR

TO_NUMBER(DWR_BSNS_QTR.QTR_NBR)

BSNS_MO

TO_NUMBER(DWR_BSNS_MO.MO_NBR)

BSNS_HLF_MO

TO_NUMBER(DWR_BSNS_HLF_MO.HLF_MO_NBR)

BSNS_WK

TO_NUMBER(DWR_BSNS_WK.WK_NBR)

DAY

TO_NUMBER(DWR_DAY.BSNS_DAY_OF_YR)


Attribute Name: Calendar Holiday Indicator (CLNDR_HLDY_IND)

Table 8-131 Time Calendar Holiday Indicator Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

 

CLNDR_HLF_YR

 

CLNDR_QTR

 

CLNDR_MO

 

CLNDR_HLF_MO

 

CLNDR_WK

 

BSNS_YR

 

BSNS_HLF_YR

 

BSNS_QTR

 

BSNS_MO

 

BSNS_HLF_MO

 

BSNS_WK

 

DAY

DWR_DAY.CLNDR_HOLIDY_IND


Attribute Name: Calendar Weekend Indicator (CLNDR_WEND_IND)

Table 8-132 Time Calendar Weekend Indicator Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

 

CLNDR_HLF_YR

 

CLNDR_QTR

 

CLNDR_MO

 

CLNDR_HLF_MO

 

CLNDR_WK

 

BSNS_YR

 

BSNS_HLF_YR

 

BSNS_QTR

 

BSNS_MO

 

BSNS_HLF_MO

 

BSNS_WK

 

DAY

DWR_DAY.CLNDR_WEEKEND_IND


Attribute Name: Calendar Working Day Indicator (CLNDR_WRK_IND)

Table 8-133 Time Calendar Working Day Indicator Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

 

CLNDR_HLF_YR

 

CLNDR_QTR

 

CLNDR_MO

 

CLNDR_HLF_MO

 

CLNDR_WK

 

BSNS_YR

 

BSNS_HLF_YR

 

BSNS_QTR

 

BSNS_MO

 

BSNS_HLF_MO

 

BSNS_WK

 

DAY

DWR_DAY.CLNDR_WRKING_DAY_IND


Attribute Name: Identifier (ID)

Table 8-134 Time Identifier Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TOT_TIME.TOT_KEY

CLNDR_YR

DWR_CLNDR_YR.CLNDR_YR_KEY

CLNDR_HLF_YR

DWR_CLNDR_HLF_YR.CLNDR_HLF_YR_KEY

CLNDR_QTR

DWR_CLNDR_QTR.CLNDR_QTR_KEY

CLNDR_MO

DWR_CLNDR_MO.CLNDR_MO_KEY

CLNDR_HLF_MO

DWR_CLNDR_HLF_MO.CLNDR_HLF_MO_KEY

CLNDR_WK

DWR_CLNDR_WK.CLNDR_WK_KEY

BSNS_YR

DWR_BSNS_YR.BSNS_YR_KEY

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_KEY

BSNS_QTR

DWR_BSNS_QTR.QTR_KEY

BSNS_MO

DWR_BSNS_MO.MO_KEY

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_KEY

BSNS_WK

DWR_BSNS_WK.WK_KEY

DAY

DWR_DAY.DAY_KEY


Attribute Name: Start Date (START_DATE)

Table 8-135 Time Start Date Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

DWR_CLNDR_YR.YR_STRT_DT

CLNDR_HLF_YR

DWR_CLNDR_HLF_YR.HLF_YR_STRT_DT

CLNDR_QTR

DWR_CLNDR_QTR.QTR_STRT_DT

CLNDR_MO

DWR_CLNDR_MO.MO_STRT_DT

CLNDR_HLF_MO

DWR_CLNDR_HLF_MO.HLF_MO_STRT_DT

CLNDR_WK

DWR_CLNDR_WK.WK_STRT_DT

BSNS_YR

DWR_BSNS_YR.YR_STRT_DT

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_STRT_DT

BSNS_QTR

DWR_BSNS_QTR.QTR_STRT_DT

BSNS_MO

DWR_BSNS_MO.MO_STRT_DT

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_STRT_DT

BSNS_WK

DWR_BSNS_WK.WK_STRT_DT

DAY

DWR_DAY.BSNS_STRT_DT


Time Slot: TSLT

This dimension keeps information for Time Slot.

Default Hierarchy: HTSLT

Table 8-136 Time Slot (TSLT) Levels and Hierarchies

Level Description Time Slot Hierarchy (HTSLT)

TTSLT

Total Time Slot

TTSLT

TSLT

Time Slot

TSLT


Attribute Name: Long Description(LONG_DESCRIPTION)

Table 8-137 Time Slot Long Description Attribute Mapping

Level Mapping (Physical Column)

TTSLT

"Total Time Slot"

TSLT

DWR_TIME_SLT.TIME_SLT_NAME


Attribute Name: Short Description(SHORT_DESCRIPTION)

Table 8-138 Time Slot Short Description Attribute Mapping

Level Mapping (Physical Column)

TTSLT

"Total Time Slot"

TSLT

DWR_TIME_SLT.TIME_SLT_CD