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
Though Account dimension is referenced in the Oracle Utilities Mobile Workforce Management facts, it is populated only by the Oracle Utilities Customer Care and Billing source product. The ETL processes of the Oracle Utilities Mobile Workforce Management facts map this dimension based on the integration between Oracle Utilities Mobile Workforce Management and Oracle Utilities Customer Care and Billing.
Since this dimension is not populated by Oracle Utilities Mobile Workforce 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
Includes a record for every address (such as location, task, POU, and resources) defined in the Oracle Utilities Mobile Workforce Management system.
This dimension is also populated by Oracle Utilities Operational Device Management, Oracle Utilities Meter Data 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
M1_TASK_ADDR
M1_LOCATION
M1_POU
M1_RESRC
Stage Table
STG_CD_ADDR
ODI Package
B1_PKG_CD_ADDR
ETL View
B1_D_ADDR_VW
Fields
Source 1 - Task Address (M1_TASK ADDR)
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
Premise ID
M1_TASK_ADDR.ADDRESS1

M1_TASK_ADDR.ADDRESS2
 
M1_TASK_ADDR.ADDRESS3
 
M1_TASK_ADDR.ADDRESS4
 
M1_TASK_ADDR.CROSS_STREET
 
M1_TASK_ADDR.SUBURB
 
M1_TASK_ADDR.CITY
 
M1_TASK_ADDR.COUNTY
 
M1_TASK_ADDR.STATE
 
M1_TASK_ADDR.POSTAL
M1_TASK_ADDR.COUNTRY
This natural key is the concatenation of all address attributes, in uppercase.
Attributes
ADDR_LINE1
Address Line 1
M1_TASK_ADDR.ADDRESS1
 
ADDR_LINE2
Address Line 2
M1_TASK_ADDR.ADDRESS2
 
ADDR_LINE3
Address Line 3
M1_TASK_ADDR.ADDRESS3
 
ADDR_LINE4
Address Line 4
M1_TASK_ADDR.ADDRESS4
 
ADDR_INFO
Address Information
M1_TASK_ADDR.ADDRESS1
 
M1_TASK_ADDR.CITY
 
M1_TASK_ADDR.STATE
 
M1_TASK_ADDR.POSTAL
This field is populated from the Task Address table based on the concatenation of the address, city, state, and postal code.
CITY
City
M1_TASK_ADDR.UPPER(CITY)
 
COUNTY
County
M1_TASK_ADDR.COUNTY
 
POSTAL
Postal Code
M1_TASK_ADDR.POSTAL
 
STATE_DESCR
State Description
CI_STATE_L.DESCR
 
COUNTRY_DESCR
Country Description
CI_COUNTRY_L.DESCR
 
CROSS_STREET
Cross Street
M1_TASK_ADDR.CROSS_STREET
 
SUBURB
Suburb
M1_TASK_ADDR.SUBURB
 
STATE_CD
State Code
M1_TASK_ADDR.STATE
 
COUNTRY_CD
Country Code
M1_TASK_ADDR.COUNTRY
 
GEO_CODE
Geographical Code
 
 
User Defined Attributes
UDF1_CD
City Code
M1_TASK_ADDR.UPPER(CITY)
 
UDF1_DESCR
City Description
M1_TASK_ADDR.UPPER(CITY)
 
UDF2_CD
County Code
M1_TASK_ADDR.COUNTY
 
UDF2_DESCR
County Description
M1_TASK_ADDR.COUNTY
 
UDF3_CD
Postal Code
M1_TASK_ADDR.POSTAL
 
UDF3_DESCR
Postal Code
M1_TASK_ADDR.POSTAL
 
UDF4_CD
State Code
M1_TASK_ADDR.STATE
 
UDF4_DESCR
State Description
CI_STATE_L.DESCR
 
UDF5_CD
Country Code
M1_TASK_ADDR.COUNTRY
 
UDF5_DESCR
Country Description
CI_COUNTRY_L.DESCR
 
UDF6_CD
Geo Code Value
 
 
UDF6_DESCR
Geo Code
 
 
UDF7_CD
Premise Char 1 Code
 
 
UDF7_DESCR
Premise Char 1
 
 
UDF8_CD
Premise Char 2 Code
 
 
UDF8_DESCR
Premise Char 2
 
 
UDF9_CD
Premise Char 3 Code
 
 
UDF9_DESCR
Premise Char 3
 
 
UDF10_CD
Premise Char 4 Code
 
 
UDF10_DESCR
Premise Char 4 Code
 
 
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.
 
Source 2 - Location (M1_LOCATION)
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
Premise ID
M1_LOCATION.ADDRESS1

M1_LOCATION.ADDRESS2
 
M1_LOCATION.ADDRESS3
 
M1_LOCATION.ADDRESS4
 
M1_LOCATION.CROSS_STREET
 
M1_LOCATION.SUBURB
 
M1_LOCATION.CITY
 
M1_LOCATION.COUNTY
 
M1_LOCATION.STATE
 
M1_LOCATION.POSTAL
 
M1_LOCATION.COUNTRY
This natural key is the concatenation of all address attributes, in uppercase.
Attributes
ADDR_LINE1
Address Line 1
M1_LOCATION.ADDRESS1
 
ADDR_LINE2
Address Line 2
M1_LOCATION.ADDRESS2
 
ADDR_LINE3
Address Line 3
M1_LOCATION.ADDRESS3
 
ADDR_LINE4
Address Line 4
M1_LOCATION.ADDRESS4
 
ADDR_INFO
Address Information
M1_LOCATION.ADDRESS1
 
M1_LOCATION.CITY
 
M1_LOCATION.STATE
 
M1_LOCATION.POSTAL
This field is populated from the Location table based on the concatenation of the address, city, state, and postal code.
CITY
City
M1_LOCATION.UPPER(CITY)
 
COUNTY
County
M1_LOCATION.COUNTY
 
POSTAL
Postal Code
M1_LOCATION.POSTAL
 
STATE_DESCR
State Description
CI_STATE_L.DESCR
 
COUNTRY_DESCR
Country Description
CI_COUNTRY_L.DESCR
 
CROSS_STREET
Cross Street
M1_LOCATION.CROSS_STREET
 
SUBURB
Suburb
M1_LOCATION.SUBURB
 
STATE_CD
State Code
M1_LOCATION.STATE
 
COUNTRY_CD
Country Code
M1_LOCATION.COUNTRY
 
GEO_CODE
Geographical Code
 
 
User Defined Attributes
UDF1_CD
City Code
M1_LOCATION.UPPER(CITY)
 
UDF1_DESCR
City Description
M1_LOCATION.UPPER(CITY)
 
UDF2_CD
County Code
M1_LOCATION.COUNTY
 
UDF2_DESCR
County Description
M1_LOCATION.COUNTY
 
UDF3_CD
Postal Code
M1_LOCATION.POSTAL
 
UDF3_DESCR
Postal Code
M1_LOCATION.POSTAL
 
UDF4_CD
State Code
M1_LOCATION.STATE
 
UDF4_DESCR
State Description
CI_STATE_L.DESCR
 
UDF5_CD
Country Code
M1_LOCATION.COUNTRY
 
UDF5_DESCR
Country Description
CI_COUNTRY_L.DESCR
 
UDF6_CD
Geo Code Value
 
 
UDF6_DESCR
Geo Code
 
 
UDF7_CD
Premise Char 1 Code
 
 
UDF7_DESCR
Premise Char 1
 
 
UDF8_CD
Premise Char 2 Code
 
 
UDF8_DESCR
Premise Char 2
 
 
UDF9_CD
Premise Char 3 Code
 
 
UDF9_DESCR
Premise Char 3
 
 
UDF10_CD
Premise Char 4 Code
 
 
UDF10_DESCR
Premise Char 4 Code
 
 
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.
 
Source 3 - POU (M1_POU)
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
Premise ID
M1_POU.ADDRESS1

M1_POU.ADDRESS2
 
M1_POU.ADDRESS3
 
M1_POU.ADDRESS4
 
M1_POU.CROSS_STREET
 
M1_POU.SUBURB
 
M1_POU.CITY
 
M1_POU.COUNTY
 
M1_POU.STATE
 
M1_POU.POSTAL
 
M1_POU.COUNTRY
This natural key is the concatenation of all address attributes, in uppercase.
Attributes
ADDR_LINE1
Address Line 1
M1_POU.ADDRESS1
 
ADDR_LINE2
Address Line 2
M1_POU.ADDRESS2
 
ADDR_LINE3
Address Line 3
M1_POU.ADDRESS3
 
ADDR_LINE4
Address Line 4
M1_POU.ADDRESS4
 
ADDR_INFO
Address Information
M1_POU.ADDRESS1
 
M1_POU.CITY
 
M1_POU.STATE
 
M1_POU.POSTAL
This field is populated from the POU table based on the concatenation of the address, city, state, and postal code.
CITY
City
M1_POU.UPPER(CITY)
 
COUNTY
County
M1_POU.COUNTY
 
POSTAL
Postal Code
M1_POU.POSTAL
 
STATE_DESCR
State Description
CI_STATE_L.DESCR
 
COUNTRY_DESCR
Country Description
CI_COUNTRY_L.DESCR
 
CROSS_STREET
Cross Street
M1_POU.CROSS_STREET
 
SUBURB
Suburb
M1_POU.SUBURB
 
STATE_CD
State Code
M1_POU.STATE
 
COUNTRY_CD
Country Code
M1_POU.COUNTRY
 
GEO_CODE
Geographical Code
 
 
User Defined Attributes
UDF1_CD
City Code
M1_POU.UPPER(CITY)
 
UDF1_DESCR
City Description
M1_POU.UPPER(CITY)
 
UDF2_CD
County Code
M1_POU.COUNTY
 
UDF2_DESCR
County Description
M1_POU.COUNTY
 
UDF3_CD
Postal Code
M1_POU.POSTAL
 
UDF3_DESCR
Postal Code Description
M1_POU.POSTAL
 
UDF4_CD
State Code
M1_POU.STATE
 
UDF4_DESCR
State Description
CI_STATE_L.DESCR
 
UDF5_CD
Country Code
M1_POU.COUNTRY
 
UDF5_DESCR
Country Description
CI_COUNTRY_L.DESCR
 
UDF6_CD
Geo Code Value
 
 
UDF6_DESCR
Geo Code
 
 
UDF7_CD
Premise Char 1 Code
 
 
UDF7_DESCR
Premise Char 1
 
 
UDF8_CD
Premise Char 2 Code
 
 
UDF8_DESCR
Premise Char 2
 
 
UDF9_CD
Premise Char 3 Code
 
 
UDF9_DESCR
Premise Char 3
 
 
UDF10_CD
Premise Char 4 Code
 
 
UDF10_DESCR
Premise Char 4 Code
 
 
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.
 
Source 4 - Resource (M1_RESRC)
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
Premise ID
M1_RESRC.BO_DATA_
AREA
This natural key is the concatenation of all address attributes, in uppercase.
Attributes
ADDR_LINE1
Address Line 1
M1_RESRC.BO_DATA_
AREA
 
ADDR_LINE2
Address Line 2
M1_RESRC.BO_DATA_
AREA
 
ADDR_LINE3
Address Line 3
M1_RESRC.BO_DATA_
AREA
 
ADDR_LINE4
Address Line 4
M1_RESRC.BO_DATA_
AREA
 
ADDR_INFO
Address Information
M1_RESRC.BO_DATA_
AREA
This field is populated from the Task Address table based on the concatenation of the address, city, state, and postal code.
CITY
City
M1_RESRC.BO_DATA_
AREA
 
COUNTY
County
M1_RESRC.BO_DATA_
AREA
 
POSTAL
Postal Code
M1_RESRC.BO_DATA_
AREA
 
STATE_DESCR
State Description
CI_STATE_L.DESCR
 
COUNTRY_DESCR
Country Description
CI_COUNTRY_L.DESCR
 
CROSS_STREET
Cross Street
M1_RESRC.BO_DATA_
AREA
 
SUBURB
Suburb
M1_RESRC.BO_DATA_
AREA
 
STATE_CD
State Code
M1_RESRC.BO_DATA_
AREA
 
COUNTRY_CD
Country Code
M1_RESRC.BO_DATA_
AREA
 
GEO_CODE
Geographical Code
 
 
User Defined Attributes
UDF1_CD
City Code
M1_RESRC.BO_DATA_
AREA
 
UDF1_DESCR
City Description
M1_RESRC.BO_DATA_
AREA
 
UDF2_CD
County Code
M1_RESRC.BO_DATA_
AREA
 
UDF2_DESCR
County Description
M1_RESRC.BO_DATA_
AREA
 
UDF3_CD
Postal Code
M1_RESRC.BO_DATA_
AREA
 
UDF3_DESCR
Postal Code Description
M1_RESRC.BO_DATA_
AREA
 
UDF4_CD
State Code
M1_RESRC.BO_DATA_
AREA
 
UDF4_DESCR
State Description
CI_COUNTRY_L.DESCR
 
UDF5_CD
Country Code
M1_POU.COUNTRY
 
UDF5_DESCR
Country Description
CI_COUNTRY_L.DESCR
 
UDF6_CD
Geo Code Value
 
 
UDF6_DESCR
Geo Code Description
 
 
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.
 
Crew
The Crew dimension includes the details of all crews defined in the source system up to three levels of crew hierarchy.
This dimension is also populated by Oracle Utilities Network Management System.
Properties
Property
Value
Target Table
CD_CREW
Table Type
Dimension
SCD Type
Type 2
Source System Driver Table
M1_RESRC
M1_RESRC_TYPE
M1_HIERARCHY
Stage Table
STG_CD_CREW
ODI Package
B1_PKG_CD_CREW
ETL View
B1_D_CREW_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
CREW_KEY
Crew Dimension Surrogate Key
 
This field is populated from the SPL_CREW_SEQ sequence.
Natural Keys
SRC_CREW_ID
Crew ID
M1_RESRC.RESRC_ID
 
Attributes
CREW_DESCR
Crew Description
M1_RESRC_ID.RESRC_ID_VAL
 
CREW_TYPE_DESCR
Crew Type Description
M1_RESRC_TYPE_L.DESCR
 
CREW_CD
Crew Code
 
Note: This field is populated only for the Oracle Utilities Network Management System source product.
CREW_TYPE_CD
Crew Type Code
M1_RESRC.RESRC_TYPE_CD
 
ORG_UNIT1_CD
Crew Hierarchy-1 Code
M1_HIER_UPSTREAM.M1_PARENT_HIER_CD
This field is populated from the Hierarchy Upstream table based on the hierarchy and hierarchy level.
 
Note: The hierarchy is based on the reporting hierarchy stored on the crew’s characteristic (where characteristic type is Crew Hierarchy ‘M1CRHIER’) and for which the hierarchy level is Level 1 (‘M101’).
ORG_UNIT2_CD
Crew Hierarchy-2 Code
M1_HIER_UPSTREAM.M1_PARENT_HIER_CD
This field is populated from the Hierarchy Upstream table based on the hierarchy and hierarchy level.
 
Note: The hierarchy is based on the reporting hierarchy stored on the crew’s characteristic (where characteristic type is Crew Hierarchy ‘M1CRHIER’) and for which the hierarchy level is Level 1 (‘M102’).
ORG_UNIT3_CD
Crew Hierarchy-3 Code
M1_HIER_UPSTREAM.M1_PARENT_HIER_CD
This field is populated from the Hierarchy Upstream table based on the hierarchy and hierarchy level.
 
Note: The hierarchy is based on the reporting hierarchy stored on the crew’s characteristic (where characteristic type is Crew Hierarchy ‘M1CRHIER’) and for which the hierarchy level is Level 1 (‘M103’).
ORG_UNIT1_DESCR
Crew Hierarchy-1 Description
M1_HIERARCHY_L.DESCR
This field is populated from the hierarchy description based on the parent hierarchy code and language configured.
 
Note: To retrieve the parent hierarchy code, see the transformation logic of the ORG_UNIT1_CD column.
ORG_UNIT2_DESCR
Crew Hierarchy-2 Description
M1_HIERARCHY_L.DESCR
This field is populated from the hierarchy description based on the parent hierarchy code and language configured.
 
Note: To retrieve the parent hierarchy code, see the transformation logic of the ORG_UNIT2_CD column.
ORG_UNIT3_DESCR
Crew Hierarchy-3 Description
M1_HIERARCHY_L.DESCR
This field is populated from the hierarchy description based on the parent hierarchy code and language configured.
 
Note: To retrieve the parent hierarchy code, see the transformation logic of the ORG_UNIT3_CD column.
User Defined Attributes
UDF1_CD
User Defined Field 1 Code
 
 
UDF1_DESCR
User Defined Field 1 Description
 
 
UDF2_CD
User Defined Field 2 Code
 
 
UDF2_DESCR
User Defined Field 2 Description
 
 
UDF3_CD
User Defined Field 3 Code
 
 
UDF3_DESCR
User Defined Field 3 Description
 
 
UDF4_CD
User Defined Field 4 Code
 
 
UDF4_DESCR
User Defined Field 4 Description
 
 
UDF5_CD
User Defined Field 5 Code
 
 
UDF5_DESCR
User Defined Field 5 Description
 
 
UDF6_CD
User Defined Field 6 Code
 
 
UDF6_DESCR
User Defined Field 6 Description
 
 
UDF7_CD
User Defined Field 7Code
 
 
UDF7_DESCR
User Defined Field 7 Description
 
 
UDF8_CD
User Defined Field 8 Code
 
 
UDF8_DESCR
User Defined Field 8 Description
 
 
UDF9_CD
User Defined Field 9 Code
 
 
UDF9_DESCR
User Defined Field 9 Description
 
 
UDF10_CD
User Defined Field 10 Code
 
 
UDF10_DESCR
User Defined Field 10 Description
 
 
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.
 
Contact
Though Contact dimension is referenced in the Oracle Utilities Mobile Workforce Management facts, it is populated only by the Oracle Utilities Meter Data Management source product. The ETL processes of the Oracle Utilities Mobile Workforce Management facts map this dimension based on the integration between Oracle Utilities Mobile Workforce Management and Oracle Utilities Meter Data Management.
Since this dimension is not populated by Oracle Utilities Mobile Workforce Management, the source mapping details are not provided in the document. See the Oracle Utilities Extractors and Schema for Oracle Utilities Meter Data Management Data Mapping Guide for the mapping details.
Device
Though Device dimension is referenced in the Oracle Utilities Mobile Workforce Management facts, it is populated only by the Oracle Utilities Meter Data Management source product. The ETL processes of the Oracle Utilities Mobile Workforce Management facts map this dimension based on the integration between Oracle Utilities Mobile Workforce Management and Oracle Utilities Meter Data Management.
Since this dimension is not populated by Oracle Utilities Mobile Workforce Management, the source mapping details are not provided in the document. See the Oracle Utilities Extractors and Schema for Oracle Utilities Meter Data Management Data Mapping Guide for the mapping details.
Person
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 Data Mapping Guide for the mapping details.
Premise
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 Data Mapping Guide for the mapping details.
Service Agreement
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 Data Mapping Guide for the mapping details.
Service Point
Though Service Point dimension is referenced in the Oracle Utilities Mobile Workforce Management facts, it is populated only by the Oracle Utilities Meter Data Management source product. The ETL processes of the Oracle Utilities Mobile Workforce Management facts map this dimension based on the integration between Oracle Utilities Mobile Workforce Management and Oracle Utilities Meter Data Management.
Since this dimension is not populated by Oracle Utilities Mobile Workforce Management, the source mapping details are not provided in the document. See the Oracle Utilities Extractors and Schema for Oracle Utilities Meter Data Management Data Mapping Guide for the mapping details.
Usage Subscription
Though Usage Subscription dimension is referenced in the Oracle Utilities Mobile Workforce Management facts, it is populated only by the Oracle Utilities Meter Data Management source product. The ETL processes of the Oracle Utilities Mobile Workforce Management facts map this dimension based on the integration between Oracle Utilities Mobile Workforce Management and Oracle Utilities Meter Data Management.
Since this dimension is not populated by Oracle Utilities Mobile Workforce Management, the source mapping details are not provided in the document. See the Oracle Utilities Extractors and Schema for Oracle Utilities Meter Data Management Data Mapping Guide for the mapping details.