Shared Dimensions
The dimensions that are used in the star schemas of other source products as well are called the shared dimensions. The other products also populate these shared dimensions with their data. The data source indicator (DSI) column plays a vital role in identifying the records belonging to a specific source product.
Account Dimension
Though Account dimension is referenced in the Oracle Utilities Meter Data Management facts, it is populated only by the Oracle Utilities Customer Care and Billing source product. The ETL processes of the Oracle Utilities Meter Data Management facts map this dimension based on the integration between Oracle Utilities Meter Data Management and Oracle Utilities Customer Care and Billing.
Since this dimension is not populated by Oracle Utilities Meter Data Management, the source mapping details are not provided in the document. See the Oracle Utilities Extractors and Schema for Oracle Utilities Customer Care and Billing for the mapping details.
Address Dimension
The Address dimension includes a record for every service point’s address in the Oracle Utilities Meter Data Management system.
This dimension is also populated by Oracle Utilities Operational Device Management, Oracle Utilities Mobile Workforce Management, Oracle Utilities Customer Care and Billing, Oracle Utilities Network Management System, and Oracle Utilities Work and Asset Management.
Properties
Property
Value
Target Table
CD_ADDR
Table Type
Dimension
SCD Type
Type 2
Source System Driver Table
D1_SP
Stage Table
STG_CD_ADDR
ODI Package
B1_PKG_CD_ADDR
ETL View
B1_D_ADDR_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
ADDR_KEY
Address Dimension Surrogate Key
 
This field is populated from the SPL_ADDR_SEQ sequence.
Natural Keys
SRC_ADDR_ID
Service Point ID
D1_SP.D1_SP_ID
 
Attributes
ADDR_LINE1
Address Line 1
D1_SP.ADDRESS1
 
ADDR_LINE2
Address Line 2
D1_SP.ADDRESS2
 
ADDR_LINE3
Address Line 3
D1_SP.ADDRESS3
 
ADDR_LINE4
Address Line 4
D1_SP.ADDRESS4
 
ADDR_INFO
Address
D1_SP. ADDRESS1
 
D1_SP.CITY
 
D1_SP.STATE
 
D1_SP.POSTAL
This field is a concatenation of address, city, state, and postal code, separated by comma.
CITY
City
D1_SP.CITY_UPPER
 
COUNTY
County
D1_SP.COUNTY
 
POSTAL
Postal Code
D1_SP. POSTAL
 
STATE_DESCR
State Description
CI_STATE_L.DESCR
 
COUNTRY_DESCR
Country Description
CI_COUNTRY_L.DESCR
 
GEO_CODE
Geographical Code
D1_SP.GEO_CODE
 
CROSS_STREET
Cross Street
 
Note: This field is populated only for the Oracle Utilities Mobile Workforce Management source product.
SUBURB
Suburb
 
Note: This field is populated only for the Oracle Utilities Mobile Workforce Management source product.
User Defined Attributes
UDF1_CD
City Code
D1_SP.CITY_UPPER
 
UDF1_DESCR
City Description
D1_SP.CITY_UPPER
 
UDF2_CD
County Code
D1_SP.COUNTY
 
UDF2_DESCR
County Code
D1_SP.COUNTY
 
UDF3_CD
Postal Code
D1_SP.POSTAL
 
UDF3_DESCR
Postal Code
D1_SP.POSTAL
 
UDF4_CD
State Code
D1_SP.STATE
 
UDF4_DESCR
State Description
CI_STATE_L.DESCR
 
UDF5_CD
Country Code
D1_SP.COUNTRY
 
UDF5_DESCR
Country Description
CI_COUNTRY_L.DESCR
 
UDF6_CD
Geo Code Value
D1_SP.GEO_CODE
 
UDF6_DESCR
Geo Code Description
D1_SP.GEO_CODE
 
UDF7_CD
Premise Char 1 Code
 
 
UDF7_DESCR
Premise Char 1 Description
 
 
UDF8_CD
Premise Char 2 Code
 
 
UDF8_DESCR
Premise Char 2 Description
 
 
UDF9_CD
Premise Char 3 Code
 
 
UDF9_DESCR
Premise Char 3 Description
 
 
UDF10_CD
Premise Char 4 Code
 
 
UDF10_DESCR
Premise Char 4 Description
 
 
UDF11_CD
User Defined Field 11 Code
 
 
UDF11_DESCR
User Defined Field 11 Description
 
 
UDF12_CD
User Defined Field 12 Code
 
 
UDF12_DESCR
User Defined Field 12 Description
 
 
UDF13_CD
User Defined Field 13 Code
 
 
UDF13_DESCR
User Defined Field 13 Description
 
 
UDF14_CD
User Defined Field 14 Code
 
 
UDF14_DESCR
User Defined Field 14 Description
 
 
UDF15_CD
User Defined Field 15 Code
 
 
UDF15_DESCR
User Defined Field 15 Description
 
 
UDF16_CD
User Defined Field 16 Code
 
 
UDF16_DESCR
User Defined Field 16 Description
 
 
UDF1_NUM
User Defined Field 1 Number
 
 
UDF2_NUM
User Defined Field 2 Number
 
 
UDF3_NUM
User Defined Field 3 Number
 
 
UDF4_NUM
User Defined Field 4 Number
 
 
UDF5_NUM
User Defined Field 5 Number
 
 
UDF6_NUM
User Defined Field 6 Number
 
 
UDF7_NUM
User Defined Field 7 Number
 
 
UDF8_NUM
User Defined Field 8 Number
 
 
UDF9_NUM
User Defined Field 9 Number
 
 
UDF10_NUM
User Defined Field 10 Number
 
 
UDF1_DATE
User Defined Field 1 Date
 
 
UDF2_DATE
User Defined Field 2 Date
 
 
UDF3_DATE
User Defined Field 3 Date
 
 
UDF4_DATE
User Defined Field 4 Date
 
 
UDF5_DATE
User Defined Field 5 Date
 
 
UDF6_DATE
User Defined Field 6 Date
 
 
UDF7_DATE
User Defined Field 7 Date
 
 
UDF8_DATE
User Defined Field 8 Date
 
 
UDF9_DATE
User Defined Field 9 Date
 
 
UDF10_DATE
User Defined Field 10 Date
 
 
FLEXFIELD1
Flex Field 1
 
 
FLEXFIELD2
Flex Field 2
 
 
FLEXFIELD3
Flex Field 3
 
 
FLEXFIELD4
Flex Field 4
 
 
FLEXFIELD5
Flex Field 5
 
 
FLEXFIELD6
Flex Field 6
 
 
FLEXFIELD7
Flex Field 7
 
 
FLEXFIELD8
Flex Field 8
 
 
FLEXFIELD9
Flex Field 9
 
 
FLEXFIELD10
Flex Field 10
 
 
Data Load Attributes
EFF_END_DTTM
Effective End Date/Time
 
 
EFF_START_DTTM
Effective Start Date/Time
 
 
DATA_LOAD_DTTM
Data Load Date/Time
 
This field is populated with the load timestamp value.
DATA_SOURCE_IND
Data Source Indicator
CI_INSTALLATION.ENV_ID
This field is populated with the DSI value on the source product instance configuration. The table is populated as part of the initial setup and the DSI value is extracted from the environment ID of the source system.
JOB_NBR
Job Number
 
This field is populated with the ODI job execution session number.
 
Person Dimension
Though Person dimension is referenced in the Oracle Utilities Meter Data Management facts, it is populated only by the Oracle Utilities Customer Care and Billing source product. The ETL processes of the Oracle Utilities Meter Data Management facts map this dimension based on the integration between Oracle Utilities Meter Data Management and Oracle Utilities Customer Care and Billing.
Since this dimension is not populated by Oracle Utilities Meter Data Management, the source mapping details are not provided in the document. See the Oracle Utilities Extractors and Schema for Oracle Utilities Customer Care and Billing for the mapping details.
Premise Dimension
Though Premise dimension is referenced in the Oracle Utilities Meter Data Management facts, it is populated only by the Oracle Utilities Customer Care and Billing source product. The ETL processes of the Oracle Utilities Meter Data Management facts map this dimension based on the integration between Oracle Utilities Meter Data Management and Oracle Utilities Customer Care and Billing.
Since this dimension is not populated by Oracle Utilities Meter Data Management, the source mapping details are not provided in the document. See the Oracle Utilities Extractors and Schema for Oracle Utilities Customer Care and Billing for the mapping details.
Service Agreement Dimension
Though Service Agreement dimension is referenced in the Oracle Utilities Meter Data Management facts, it is populated only by the Oracle Utilities Customer Care and Billing source product. The ETL processes of the Oracle Utilities Meter Data Management facts map this dimension based on the integration between Oracle Utilities Meter Data Management and Oracle Utilities Customer Care and Billing.
Since this dimension is not populated by Oracle Utilities Meter Data Management, the source mapping details are not provided in the document. See the Oracle Utilities Extractors and Schema for Oracle Utilities Customer Care and Billing for the mapping details.