Go to main content
2/33
List of Tables
1-1 Oracle Development Tools Used with Oracle Communications Data Model
1-2 Oracle Communications Data Model Foundation Layer Components
1-3 Oracle Communications Data Model Analytic Layer Components
1-4 Business Areas
2-1 A to C Entity Descriptions
2-2 D to F Entity Descriptions
2-3 G to J Entity Descriptions
2-4 K to N Entity Descriptions
2-5 O to R Entity Descriptions
2-6 S to V Entity Descriptions
2-7 W to Z Entity Descriptions
3-1 Access Method Total
3-2 Access Method Type
3-3 Access Method Detail
3-4 Account Total
3-5 Account Type
3-6 Account Detail
3-7 Account Payment Method Status Type Total
3-8 Account Payment Method Status Type Detail
3-9 Account Refund Reason Total
3-10 Account Refund Reason Detail
3-11 Address Location Total
3-12 Address Location Detail
3-13 Age Band Total
3-14 Age Band Detail
3-15 Age Group Total
3-16 AGE GROUP Detail
3-17 Age on Net Band Total
3-18 Age On Net Band Detail
3-19 ARPU Band Total
3-20 ARPU Band Detail
3-21 AGREEMENT CHANGE INITIATOR TYPE Total
3-22 AGREEMENT CHANGE INITIATOR TYPE Detail
3-23 AGREEMENT TYPE Total
3-24 AGREEMENT TYPE Detail
3-25 Bank Direct Debt Channel Total
3-26 Bank Direct Debit Channel Detail
3-27 Ber Fer Type Total
3-28 Ber Fer Type Detail
3-29 BILLING CYCLE Total
3-30 BILLING CYCLE Detail
3-31 Billing Status Type Total
3-32 Billing Status Type Detail
3-33 Business Time Total
3-34 Business Year
3-35 Business Half Year
3-36 Business Quarter
3-37 Business Month
3-38 Business Half Month
3-39 Day
3-40 Calendar Time Total
3-41 Calendar Year
3-42 Calendar Half Year
3-43 Calendar Quarter
3-44 Calendar Month
3-45 Calendar Half Month
3-46 Day
3-47 Call Category Total
3-48 Call Category Detail
3-49 Call Center Agent Total
3-50 Call Center Agent Type
3-51 Call Center Agent Detail
3-52 Call Center Case Title Total
3-53 Call Center Case Title Detail
3-54 Call Center Total
3-55 Call Center Detail
3-56 Call Direction Total
3-57 Call Direction Detail
3-58 Call Other Type Total
3-59 Call Other Type Detail
3-60 Call Routing Type Total
3-61 Call Routing Type Detail
3-62 Call Service Type Total
3-63 Call Service Type Detail
3-64 Call Source Destination Total
3-65 Call Source Destination Detail
3-66 Call Successful Fail Total
3-67 Call Successful Fail Detail
3-68 Call Type Total
3-69 Call Type Detail
3-70 CAMPAIGN Total
3-71 CAMPAIGN Detail
3-72 Campaign Channel Total
3-73 Campaign Channel Detail
3-74 CAMPAIGN MEDIA Total
3-75 CAMPAIGN MEDIA Detail
3-76 Cell Outage Reason Total
3-77 Cell Outage Reason Detail
3-78 CONTENT Detail
3-79 CHANGE PROPOSED BY TYPE Total
3-80 CHANGE PROPOSED BY TYPE Detail
3-81 CHANNEL Total
3-82 CHANNEL TYPE
3-83 CHANNEL Detail
3-84 Collection Agency Total
3-85 Collection Agency Detail
3-86 Commission Type Total
3-87 Commission Type Detail
3-88 COMPETITOR Total
3-89 COMPETITOR Detail
3-90 CONTACT LIST Total
3-91 CONTACT LIST Detail
3-92 CONTENT Total
3-93 CONTENT Detail
3-94 All Content Type
3-95 Content Type Detail
3-96 Contract Change InitiatorType Total
3-97 Contract Change Initiator Type Detail
3-98 Contract Assignment Reason Total
3-99 Contract Assignment Reason Detail
3-100 COST CENTER Total
3-101 COST CENTER Detail
3-102 Credit Category Total
3-103 Credit Category Detail
3-104 CURRENCY Total
3-105 CURRENCY Detail
3-106 CUSTOMER Total
3-107 CUSTOMER TYPE
3-108 CUSTOMER Detail
3-109 CUSTOMER CLUSTER Total
3-110 CUSTOMER CLUSTER Detail
3-111 Customer Revenue Band Total
3-112 Customer Revenue Band Detail
3-113 Customer Segment Total
3-114 Customer Segment Detail
3-115 Dealer Total
3-116 Dealer Detail
3-117 Debt Aging Band Total
3-118 Debt Aging Band Detail
3-119 Direct Debit Status Reason Total
3-120 Direct Debit Status Reason Detail
3-121 Divert Retrieve Type Total
3-122 Divert Retrieve Type Detail
3-123 Employee Total
3-124 Employee Detail
3-125 ENVIRONMENT TYPE Total
3-126 EVENT CATEGORY Total
3-127 EVENT CATEGORY Detail
3-128 Event Result Total
3-129 Event Result Detail
3-130 Event Type Total
3-131 Event Type Detail
3-132 EXTERNAL OPERATOR Total
3-133 EXTERNAL OPERATOR Detail
3-134 Fraud Profile Class Total
3-135 Fraud Profile Class Detail
3-136 Geography World
3-137 Geography Region
3-138 Geography Sub Region
3-139 Geography Country
3-140 Geography State
3-141 Geography City
3-142 Geography County
3-143 Address Location
3-144 All Give Away Type
3-145 Give Away Type Detail
3-146 GRRS Services Total
3-147 GRRS Services Detail
3-148 Handset Model Total
3-149 Handset Model Detail
3-150 IN Platform Total
3-151 IN Platform Detail
3-152 Initiative Type Total
3-153 Initiative Type Detail
3-154 Interaction Channel Total
3-155 Interaction Channel Detail
3-156 INTERACTION DIRECTION Total
3-157 INTERACTION DIRECTION Detail
3-158 INTERACTION TYPE Total
3-159 INTERACTION TYPE Detail
3-160 Invoice Adjustment Reason Total
3-161 Invoice Adjustment Reason Detail
3-162 Invoice Adjustment Type Total
3-163 Invoice Adjustment Type Detail
3-164 INVOICE STATUS Total
3-165 INVOICE STATUS Detail
3-166 ISP Total
3-167 ISP Detail
3-168 ITEM SUBCLASS Total
3-169 ITEM SUBCLASS Detail
3-170 Legal Process Status Type Total
3-171 Legal Process Status Type Detail
3-172 LIFECYCLE TYPE Total
3-173 LIFECYCLE TYPE Detail
3-174 Loyalty Program Channel Total
3-175 Loyalty Program Channel Detail
3-176 LOYALTY TIER Total
3-177 LOYALTY TIER CLASS Detail
3-178 LOYALTY TIER Detail
3-179 Market Area Total
3-180 Market Area Details
3-181 MEDIA OBJECT TYPE Total
3-182 MEDIA OBJECT TYPE Detail
3-183 Network Total
3-184 Network Detail
3-185 NETWORK TOUCHPOINT Total
3-186 NETWORK TOUCHPOINT Detail
3-187 Network Touchpoint Class Total
3-188 Network Touchpoint Class Detail
3-189 Network Touchpoint Status Total
3-190 Network Touchpoint Status Detail
3-191 Network Touchpoint Type Total
3-192 Network Touchpoint Type Detail
3-193 NETWORK TYPE Total
3-194 NETWORK TYPE Detail
3-195 Notification Type Total
3-196 Notification Type Detail
3-197 NP Request Type Total
3-198 NP Request Type Detail
3-199 ON OFF NET TYPE Total
3-200 ON OFF NET TYPE Detail
3-201 ORDER LINE ITEM STATE Total
3-202 ORDER LINE ITEM STATE TYPE Detail
3-203 ORDER LINE ITEM STATE Detail
3-204 ORDER STATE Total
3-205 ORDER STATE TYPE Detail
3-206 ORDER STATE Detail
3-207 ORDER TYPE Total
3-208 ORDER TYPE Detail
3-209 All Organization Total
3-210 Organization Corporate
3-211 Organization Banner Levels
3-212 Organization Banner
3-213 All Organization Company
3-214 Organization Company
3-215 Organization Division Total
3-216 Organization Division
3-217 Organization Chain Total
3-218 Organization Chain Detail
3-219 Organization Area Total
3-220 Organization Area Detail
3-221 All Organization Regions
3-222 Organization Region
3-223 All Organization District
3-224 Organization District
3-225 All Organization Business Unit
3-226 Organization Business Unit
3-227 PACKET CONTROL UNIT OUTAGE REASON Total
3-228 PACKET CONTROL UNIT OUTAGE REASON Detail
3-229 Partner Settlement Reason Total
3-230 Partner Settlement Reason Detail
3-231 Party Total
3-232 Party Detail
3-233 Payment Channel Total
3-234 Payment Channel Detail
3-235 Payment Method Type Total
3-236 Payment Method Type Detail
3-237 Payment Transaction Type Total
3-238 Payment Transaction Type Detail
3-239 PCU Outage Reason Total
3-240 PCU Outage Reason Detail
3-241 Peak Offpeak Time Total
3-242 Peak Offpeak Time Detail
3-243 PPA Category Total
3-244 PPA Category Detail
3-245 Product Total
3-246 Product Type
3-247 PRODUCT SPECIFICATION TYPE Total
3-248 PRODUCT SPECIFICATION TYPE Detail
3-249 PRODUCT SUBSCRIPTION STATUS Total
3-250 PRODUCT SUBSCRIPTION STATUS Detail
3-251 PRODUCT SUBSCRIPTION TYPE Total
3-252 PRODUCT SUBSCRIPTION TYPE Detail
3-253 Campaign
3-254 Campaign Type
3-255 Promotion Type
3-256 Promotion
3-257 Promotion Result Type Total
3-258 Promotion Result Type Detail
3-259 QUARTER HOUR Total
3-260 QUARTER HOUR Detail
3-261 REASON Total
3-262 REASON Detail
3-263 Recharge Revenue Slab Total
3-264 Recharge Revenue Slab Detail
3-265 Redemption Type Total
3-266 Redemption Type
3-267 RETAIL TYPE Total
3-268 RETAIL TYPE Detail
3-269 RF Carrier Total
3-270 RF Carrier Detail
3-271 Roaming Type Total
3-272 Roaming Type Detail
3-273 Sales Channel Total
3-274 Sales Channel Detail
3-275 Sales Channel Representative Total
3-276 Sales Channel Representative
3-277 SCRIPT Total
3-278 SCRIPT Detail
3-279 Service Coverage Area Total
3-280 Service Coverage Area
3-281 SKU ITEM Total
3-282 SKU ITEM Detail
3-283 SPNM OTHER PARTY NUMBER Total
3-284 SPNM OTHER PARTY NUMBER Detail
3-285 Subsidy Type Total
3-286 Subsidy Type Detail
3-287 Switch Total
3-288 Switch Detail
3-289 Technology Type Total
3-290 Technology Types
3-291 TENDER CLASS Detail
3-292 TENDER Detail
3-293 Time Slot Total
3-294 Time Slot Detail
3-295 UMS Access Type Total
3-296 UMS Access Type Detail
3-297 Value Added Service Total
3-298 Value Added Service
4-1 Table Name Prefix Conventions
4-2 Other Table Name Prefix Conventions
4-3 Reference Tables
4-4 Lookup Tables
4-5 Base Tables
4-6 Oracle Communications Data Model Derived Tables
4-7 Aggregate Tables
4-8 Temporary Oracle Communications Data Model Tables
4-9 Control Tables
4-10 Sequence Name for Oracle Communications Data Model
4-11 OLAP Cube Materialized Views in ocdm_sys Schema
4-12 OLAP Cube Views in ocdm_sys schema
5-1 Entity Mapping Table: Logical to Physical Mapping A to M
5-2 Entity Mapping Table: Logical to Physical Mapping: N to Z
6-1 Physical Data Model Partitioning
7-1 PKG_DWD_ACCT_BAL_MO Business Rules
7-2 PKG_DWD_ACCT_BAL_MO Lookup Values
7-3 PKG_DWD_ACCT_DEBT_MO Business Rules
7-4 PKG_DWD_ACCT_DEBT_MO Lookup Values
7-5 PKG_DWD_ACCT_FRST_ACTVTY Business Rules
7-6 PKG_DWD_FRST_ACTVTY Lookup Values
7-7 PKG_DWD_ACCT_LAST_ACTVTY Business Rules
7-8 PKG_DWD_ACCT_LAST_ACTVTY Lookup Values
7-9 PKG_DWD_ACCT_PYMT_DAY Lookup Values
7-10 PKG_DWD_AGRMNT Business Rules
7-11 PKG_DWD_AGRMNT_CHG Package Source Tables
7-12 PKG_DWD_AGRMNT_CHG Business Rules
7-13 PKG_DWD_AGRMNT_RVN_DAY Business Rules
7-14 PKG_DWD_CANBLZTN_DTL_DAY Business Rules
7-15 DWD_CMPGN_HIST_DAY Business Rules
7-16 DWD_CMPGN_HIST_DAY Lookup Values
7-17 DWD_CNT_DAY Business Rules
7-18 DWD_CNT_DAY Lookup Values
7-19 DWD_CNTCT_CNTR Business Rules
7-20 DWD_CNTCT_CNTR Lookup Values
7-21 DWD_CUST_EQPMNT_INSTLTN_DAY Business Rules
7-22 DWD_CUST_EQPMNT_INSTLTN_DAY Lookup Values
7-23 DWD_DATA_USG_DAY Business Rules
7-24 PKG_DWD_GIVE_AWAY_ITEM_DAY Business Rules
7-25 PKG_DWD_GIVE_AWAY_ITEM_DAY Lookup Values
7-26 PKG_DWD_INV_RCPT_ITEM_DAY Business Rules
7-27 PKG_DWD_INV_UNAVL_ITEM_DAY Business Rules
7-28 PKG_DWD_INV_UNAVL_ITEM_DAY Lookup Values
7-29 PKG_DWD_INV_XFER_ITEM_DAY Lookup Values
7-30 PKG_DWD_INVC_AGNG_DAY Business Rules
7-31 PKG_DWD_PRCS_INVC_DAY Business Rules
7-32 PKG_DWD_RVN_DAY Business Rules
7-33 DWD_RVN_DAY Lookup Values
7-34 PKG_DWD_SRVC_PBRLM_DAY Business Rules
7-35 PKG_DWD_STORE_EFFNCY_DAY Business Rules
7-36 DWD_STORE_EFFNCY_DAY Lookup Values
7-37 DWD_VAS_USG_DAY Business Rules
7-38 DWD_VAS_USG_DAY Lookup Values
7-39 DWD_VOI_CALL_DAY Business Rules
8-1 Account Refund Reason (ARRSN) Levels and Hierarchies
8-2 Account Refund Reason Long Description Attribute Mapping
8-3 Account Refund Reason Short Description Attribute Mapping
8-4 Bank Direct Debit Channel (MOBJTYP) Levels and Hierarchies
8-5 Bank Direct Debit Channel Long Description Attribute Mapping
8-6 Bank Direct Debit Channel Long Description Attribute Mapping
8-7 Billing Cycle (BCYCL) Levels and Hierarchies
8-8 Billing Cycle Long Description Attribute Mapping
8-9 Billing Cycle Long Description Attribute Mapping
8-10 Churn Reason (CRNRSN) Levels and Hierarchies
8-11 Churn Reason Long Description Attribute Mapping
8-12 Churn Reason Short Description Attribute Mapping
8-13 Collection Agency (CAGNCY) Levels and Hierarchies
8-14 Collection Agency Long Description Attribute Mapping
8-15 Collection Agency Short Description Attribute Mapping
8-16 Collection Agency Agency Manager Attribute Mapping
8-17 Collection Agency Domestic Indicator Attribute Mapping
8-18 Commission Type (CMTYP) Levels and Hierarchies
8-19 Commission Type Long Description Attribute Mapping
8-20 Commission Type Short Description Attribute Mapping
8-21 Cost Center (CCK) Levels and Hierarchies
8-22 Cost Center Long Description Attribute Mapping
8-23 Cost Center Short Description Attribute Mapping
8-24 Currency (CRNCY) Levels and Hierarchies
8-25 Currency Long Description Attribute Mapping
8-26 Currency Type Short Description Attribute Mapping
8-27 Customer (CUST) Levels and Hierarchies
8-28 Customer Long Description Attribute Mapping
8-29 Customer Short Description Attribute Mapping
8-30 Customer Segment (CSGMNT) Levels and Hierarchies
8-31 Customer Segment Long Description Attribute Mapping
8-32 Customer Segment Short Description Attribute Mapping
8-33 Customer Type (CUSTYP) Levels and Hierarchies
8-34 Customer Type Long Description Attribute Mapping
8-35 Customer Type Short Description Attribute Mapping
8-36 Debt Aging Band (DAB) Levels and Hierarchies
8-37 Debt Aging Band Long Description Attribute Mapping
8-38 Debt Aging Band Short Description Attribute Mapping
8-39 Geography (GEO) Levels and Hierarchies
8-40 Geography Long Description Attribute Mapping
8-41 Geography Short Description Attribute Mapping
8-42 Geography County Name Attribute Mapping
8-43 Geography County Code Attribute Mapping
8-44 Handset Model (HSMDL) Levels and Hierarchies
8-45 Handset Model Long Description Attribute Mapping
8-46 Handset Model Short Description Attribute Mapping
8-47 Invoice Adjustment Reason (IARSN) Levels and Hierarchies
8-48 Invoice Adjustment Reason Long Description Attribute Mapping
8-49 Invoice Adjustment Reason Short Description Attribute Mapping
8-50 Invoice Adjustment Type (IATYP) Levels and Hierarchies
8-51 Invoice Adjustment Type Long Description Attribute Mapping
8-52 Invoice Adjustment Type Short Description Attribute Mapping
8-53 Organization (ORG) Levels and Hierarchies
8-54 Organization Long Description Attribute Mapping
8-55 Organization Short Description Attribute Mapping
8-56 Organization Store Name Attribute Mapping
8-57 Organization Store Description Attribute Mapping
8-58 Organization Store Manager Attribute Mapping
8-59 Organization Store Open Date Attribute Mapping
8-60 Organization Store Close Date Attribute Mapping
8-61 Payment Channel (PCK) Levels and Hierarchies
8-62 Payment Channel Long Description Attribute Mapping
8-63 Payment Channel Short Description Attribute Mapping
8-64 Payment Method Type (PMTYP) Levels and Hierarchies
8-65 Payment Method Type Long Description Attribute Mapping
8-66 Payment Method Type Short Description Attribute Mapping
8-67 Payment Transaction Type (PTTYP) Levels and Hierarchies
8-68 Payment Transaction Type Long Description Attribute Mapping
8-69 Payment Transaction Type Short Description Attribute Mapping
8-70 Peak Offpeak Time (POPT) Levels and Hierarchies
8-71 Peak Offpeak Time Long Description Attribute Mapping
8-72 Peak Offpeak Time Short Description Attribute Mapping
8-73 Peak Offpeak Time Peak Offpeak Start Time Attribute Mapping
8-74 Peak Offpeak Time Peak Offpeak End Time Attribute Mapping
8-75 Peak Offpeak Time Holiday Indicator Attribute Mapping
8-76 Peak Offpeak Time Weekend Indicator Attribute Mapping
8-77 Product (PROD) Levels and Hierarchies
8-78 Product Long Description Attribute Mapping
8-79 Product Short Description Attribute Mapping
8-80 Product IN Platform Key Attribute Mapping
8-81 Product Offer (ARRSN) Levels and Hierarchies
8-82 Product Offer Long Description Attribute Mapping
8-83 Product Offer Short Description Attribute Mapping
8-84 Product Offer Joint Program Indicator Attribute Mapping
8-85 Product Offer Loyalty Program Indicator Attribute Mapping
8-86 Product Offer New Customer Only Indicator Attribute Mapping
8-87 Product Offer VAS Indicator Attribute Mapping
8-88 Promotion (PRMTN) Levels and Hierarchies
8-89 Promotion (HCMPGN) Levels and Hierarchies
8-90 Promotion Long Description Attribute Mapping
8-91 Promotion Short Description Attribute Mapping
8-92 Resource (RSCEK) Levels and Hierarchies
8-93 Resource Long Description Attribute Mapping
8-94 Resource Short Description Attribute Mapping
8-95 Sales Channel (SLCHNL) Levels and Hierarchies
8-96 Sales Channel Long Description Attribute Mapping
8-97 Sales Channel Short Description Attribute Mapping
8-98 Sales Channel Capacity Quantity Attribute Mapping
8-99 Sales Channel Representative (SLR) Levels and Hierarchies
8-100 Sales Channel Representative Long Description Attribute Mapping
8-101 Sales Channel Representative Short Description Attribute Mapping
8-102 Product Hierarchy and Cluster Hierarchy
8-103 Product Long Description Attribute Mapping
8-104 Product Short Description Attribute Mapping
8-105 Product Buyer Code Attribute Mapping
8-106 Product Buyer Name Attribute Mapping
8-107 Product Item Conv Type Code Attribute Mapping
8-108 Product Item Discount Indicator Attribute Mapping
8-109 Product Item Display Unit Type Code Attribute Mapping
8-110 Product Item Number Attribute Mapping
8-111 Product Merchandiser Code Attribute Mapping
8-112 Product Merchandiser Name Attribute Mapping
8-113 Product SKU Item Number Attribute Mapping
8-114 Time (TIME) Levels and Hierarchies
8-115 Time Long Description Attribute Mapping
8-116 Time Short Description Attribute Mapping
8-117 Time Time Number Attribute Mapping
8-118 Time Time Span Attribute Mapping
8-119 Time Start Date Attribute Mapping
8-120 Time End Date Attribute Mapping
8-121 Time Levels and Hierarchies
8-122 Time Long Description Attribute Mapping
8-123 Time Short Description Attribute Mapping
8-124 Time End Date Attribute Mapping
8-125 Time Time Span Attribute Mapping
8-126 Time Business Holiday Indicator Attribute Mapping
8-127 Time Business Weekend Indicator Attribute Mapping
8-128 Time Business Working Day Indicator Attribute Mapping
8-129 Time Number Attribute Mapping
8-130 Time Calendar Holiday Indicator Attribute Mapping
8-131 Time Calendar Weekend Indicator Attribute Mapping
8-132 Time Calendar Working Day Indicator Attribute Mapping
8-133 Time Identifier Attribute Mapping
8-134 Time Start Date Attribute Mapping
8-135 Time Slot (TSLT) Levels and Hierarchies
8-136 Time Slot Long Description Attribute Mapping
8-137 Time Slot Short Description Attribute Mapping
9-1 Account Debt Cube Dimensions and Load Level
9-2 Account Debt Cube Aggregation Operator and Order
9-3 Account Debt Cube Base Measures
9-4 Account Debt Cube Derived Measures
9-5 Account Payment Cube Dimensions and Load Level
9-6 Account Payment Cube Aggregation Operator and Order
9-7 Account Payment Cube Base Measures
9-8 Account Payment Cube Derived Measures
9-9 Agreement Cube Dimensions and Load Level
9-10 Agreement Cube Aggregation Operator and Order
9-11 Agreement Cube Base Measures
9-12 Agreement Cube Derived Measures
9-13 Cell Statistic Cube Dimensions and Load Level
9-14 Cell Statistic Cube Aggregation Operator and Order
9-15 Cell Statistic Cube Base Measures
9-16 Cell Statistic Cube Derived Measures
9-17 Commission Cube Dimensions and Load Level
9-18 Commission Cube Aggregation Operator and Order
9-19 Commission Cube Base Measures
9-20 Commission Cube Derived Measures
9-21 Cost Organizational Cube Dimensions and Load Level
9-22 Cost Organizational Cube Aggregation Operator and Order
9-23 Cost Organizational Cube Base Measures
9-24 Cost Organizational Cube Derived Measures
9-25 Cost Product Offering Cube Dimensions and Load Level
9-26 Cost Product Offering Cube Aggregation Operator and Order
9-27 Cost Product Offering Cube Base Measures
9-28 Cost Product Offering Derived Measures
9-29 Customer Acquisition Cube Dimensions and Load Level
9-30 Customer Acquisition Cube Aggregation Operator and Order
9-31 Customer Acquisition Cube Base Measures
9-32 Customer Acquisition Cube Derived Measures
9-33 Invoice Adjustment Cube Dimensions and Load Level
9-34 Invoice Adjustment Cube Aggregation Operator and Order
9-35 Invoice Adjustment Cube Base Measures
9-36 Invoice Adjustment Cube Derived Measures
9-37 Invoice Customer Type Cube Dimensions and Load Level
9-38 Invoice Customer Type Cube Aggregation Operator and Order
9-39 Invoice Customer Type Base Measures
9-40 Invoice Customer Type Derived Measures
9-41 Revenue Cube Dimensions and Load Level
9-42 Revenue Cube Aggregation Operator and Order
9-43 Revenue Cube Base Measures
9-44 Revenue Cube Derived Measures
9-45 Subscriber Churn Statistic Cube Dimensions and Load Level
9-46 Subscriber Churn Statistic Cube Aggregation Operator and Order
9-47 Subscriber Chrn Statistic Cube Base Measures
9-48 Subscriber Churn Statistic Cube Derived Measures
9-49 Customer Acquisition Forecast Cube Dimensions and Load Level
9-50 Customer Acquisition Forecast Cube Aggregation Operator and Order
9-51 Customer Acquisition Forecast Cube Base Measures
9-52 Customer Acquisition Forecast Statistic Cube Dimensions and Load Level
9-53 Customer Acquisition Forecast Statistic Aggregation Operator and Order
9-54 Customer Acquisition Forecast Statistic Cube Base Measures
9-55 Cell Statistic Forecast Cube Dimensions and Load Level
9-56 Cell Statistic Forecast Cube Aggregation Operator and Order
9-57 Cell Statistic Forecast Cube Base Measures
9-58 Revenue Forecast Cube Dimensions and Load Level
9-59 Revenue Forecast Cube Aggregation Operator and Order
9-60 Revenue Forecast Cube Base Measures
9-61 Revenue Forecast Cube Derived Measures
10-1 Target Columns in DWD_CUST_DNA Data Mining Result Table
10-2 DWD_CUST_PROD_AFFLTN Data Mining Result Table
10-3 DWD_CHRN_SVM_FACTOR Data Mining Result Table
10-4 DWD_PROMO_SVM_FACTOR Data Mining Result Table
10-5 DWR_CUST_DT_NODE Data Mining Result Table
10-6 DWD_CHRN_SVM_ROC Data Mining Result Table
10-7 DWD_PROMO_SVM_ROC Data Mining Result Table
10-8 DWV_PRPD_CUST_CHRN_SRC
10-9 DWV_PSTPD_CUST_CHRN_SRC
10-10 DWV_CUST_PROFILE_SRC
10-11 DWV_PROD_MIX_SRC
10-12 DWV_CUST_LTV_SRC
10-13 DWV_CUST_LTV_SRC
10-14 DM_CUST_CMMNT Customer Sentiment Source Table
10-15 Data Mining Algorithm Setting Table Structure
10-16 DM_STNG_CHURN_SVM_PRIORS Data Mining Algorithm Setting Table
10-17 DM_STNG_CHURN_DT_COST Data Mining Algorithm Setting Table
10-18 DWD_CUST_SNTMNT_MANUAL_SCORE Data Mining Source Table
10-19 DWL_MNNG_CHRN_TYP Data Mining Lookup Table
10-20 DWL_MNNG_SNTMNT_CTGRY Data Mining Lookup Table
10-21 DWL_MNNG_LTV_BAND Data Mining Result Table
10-22 DWL_MNNG_LT_SRVVL_BAND Data Mining Result Table
10-23 Sequences Defined for Data Mining
10-24 Prepaid Customer Life Time Value Computation
10-25 Prepaid Customer Life Time Value Additional Required Parameter Values
10-26 Postpaid Customer Life Time Value Computation
10-27 Postpaid Customer Life Time Value Additional Required Parameter Values
11-1 DWD_CUST_DNA Data Mining Results Table
11-2 DWD_CUST_PROD_AFFLTN - Data Mining Results Table
11-3 DWD_CHRN_SVM_FACTOR - Data Mining Results Table
11-4 DWD_PROMO_SVM_FACTOR - Data Mining Results Table
11-5 DWR_CUST_DT_NODE - Data Mining Results Table
11-6 DWD_PRPD_CHRN_SVM_ROC - Data Mining Results Table
11-7 DWD_PSTPD_CHRN_SVM_ROC - Data Mining Results Table
11-8 DWD_TARGET_PROMO_SVM_ROC - Data Mining Results Table
11-9 DWD_PRPD_CHRN_SVM_LIFT - Data Mining Results Table
11-10 DWD_PSTPD_CHRN_SVM_LIFT - Data Mining Results Table
11-11 DWD_TARGET_PROMO_SVM_LIFT - Data Mining Results Table
11-12 DWD_PRPD_CHRN_SVM_LIFT - Data Mining Results Table
11-13 DWD_PSTPD_CHRN_SVM_LIFT - Data Mining Results Table
11-14 DWD_PSTPD_CHRN_SVM_LIFT - Data Mining Results Table
11-15 DWR_CUST_SGMNT - Data Mining Results Table
11-16 DWR_CUST_SGMNT_DTL - Data Mining Results Table
11-17 DWC_ODMR_WF_EXCTN – Data Miner Workflow Status Log Table
11-18 DWD_CUST_SNTMNT_MANUAL_SCORE - Data Mining Source Table
11-19 DWL_MNNG_CHRN_TYP - Data Mining Lookup Table
11-20 DWL_MNNG_SNTMNT_CTGRY - Data Mining Lookup Table
11-21 DWL_MNNG_LTV_BAND - Data Mining Result Table
11-22 DWL_MNNG_LT_SRVVL_BAND - Data Mining Result Table
11-23 DM_STNG_USER_ALL – Data Mining Setting Table
11-24 Attributes Identified from DWD_CUST_DNA for Prepaid Churn
11-25 Target Tables (columns) that get updated/loaded/created
11-26 Source Attributes Identified from DWD_CUST_DNA table for Postpaid Churn
11-27 Target Tables
11-28 Source Attributes Identified from DWD_CUST_DNA for Customer Profiling
11-29 Data Mining Model Target Tables
11-30 Source Attributes Identified from DWD_CUST_DNA table for Customer Lifetime Value
11-31 Attributes Identified from DWD_CUST_DNA table for Customer Lifetime Survival Value
11-32 Data Mining Target Tables Customer Lifetime Survival Value
11-33 Attributes Identified from DWD_VAS_SBRP_QCK_SUMM, DWR_CUST, and DWD_CUST_DNA table for
Target Promotion
A-1 DWC_ETL_PARAMETER Table
A-2 ETL Parameters in the DWC_OLAP_ETL_PARAMETER Table
A-3 DWC_INTRA_ETL_PROCESS Columns
A-4 DWC_INTRA_ETL_ACTIVITY Columns
B-1 General Entities
B-2 Product Offering and Specifications Entities
B-3 Party and Party Subtype Entities
B-4 Business Interactions
B-5 Business Interaction Items Tables
B-6 BSS/OSS Interaction Event Tables
B-7 Predefined UDR Event Tables
B-8 Notes Table
B-9 Loyalty Event Additional Information
Scripting on this page enhances content navigation, but does not change the content in any way.