Shared Dimensions
Shared dimensions are used in the star schemas of other source products as well. 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.
Address
Extracts data from the Location/Node entity in the Oracle Utilities Operational Device Management system. The address constituents from the location are retrieved and stored in the target dimension.
Properties
Property
Value
Target Table
CD_ADDR
Table Type
Dimension
SCD Type
Type 2
Source System Driver Table
W1_NODE
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
 
This field is populated from the SPL_ADDR_SEQ sequence.
Natural Keys
SRC_ADDR_ID
Address ID
 
 
Attributes
ADDR_INFO
Address
W1_NODE.ADDRESS1

W1_NODE.CITY

W1_NODE.STATE

W1_NODE.POSTAL
This field is populated from the W1_NODE table based on the concatenation of the address, city, state, and postal code.
ADDR_LINE1
Address Line 1
W1_NODE.ADDRESS1
 
ADDR_LINE2
Address Line 2
W1_NODE.ADDRESS2
 
ADDR_LINE3
Address Line 3
W1_NODE.ADDRESS3
 
ADDR_LINE4
Address Line 4
W1_NODE.ADDRESS4
 
CITY
City
W1_NODE.CITY
 
COUNTY
County
W1_NODE.COUNTY
 
POSTAL
Postal Code
W1_NODE.POSTAL
 
STATE_CD
State Code
W1_NODE.STATE
 
STATE_DESCR
State Description
CI_STATE_L.DESCR
 
COUNTRY_CD
Country Code
W1_NODE.COUNTRY
 
COUNTRY_DESCR
Country Description
CI_COUNTRY_L.DESCR
 
CROSS_STREET
Cross Street
W1_NODE.W1_CROSS_STREET
 
SUBURB
Suburb
W1_NODE.W1_SUBURB
 
GEO_CODE
Geographical Code
W1_NODE.GEO_CODE
 
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 7 Code
 
 
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
 
 
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
 
 
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_START_DTTM
Effective Start Date/Time
 
 
EFF_END_DTTM
Effective End 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.
 
Asset
Extracts all assets defined in the system. The dimension holds all generic asset information, such as the specification details, asset type, and asset class information.
Properties
Property
Value
Target Table
CD_UTIL_ASSET
Table Type
Dimension
SCD Type
Type 2
Source System Driver Table
W1_ASSET
ODI Package
B1_PKG_CD_UTIL_ASSET
ETL View
B1_D_UTIL_ASSET_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
UTIL_ASSET_KEY
Utility Asset Dimension
 
This field is populated from the B1_UTIL_ASSET_SEQ sequence.
Natural Keys
SRC_UTIL_ASSET_ID
Source Utility Asset ID
W1_ASSET.ASSET_ID
 
Attributes
UTIL_ASSET_INFO
Utility Asset Information
W1_ASSET_IDENTIFIER.W1_ID_VALUE
This field is populated with the badge number retrieved based on the Asset ID populated.
UTIL_ASSET_DESCR
Utility Asset Description
W1_ASSET.DESCRLONG
This field is populated with the first 254 characters from the respective column in the Asset table.
SPEC_CD
Specification Code
W1_ASSET.SPECIFICATION_CD
 
SPEC_DESCR
Specification Description
W1_SPECIFICATION_L.DESCR100
 
MANUFACTURER_CD
Manufacturer Code
W1_SPECIFICATION. W1_MANUFACTURER_CD
 
MANUFACTURER_
DESCR
Manufacturer Description
W1_MANUFACTURER_L.DESCR100
 
MODEL
Model
W1_SPECIFICATION_IDENTIFIER.W1_ID_VALUE
This field is populated based on the specification code on the asset and where the specification identifier flag is W1MD.
UTIL_ASSET_TYPE_CD
Utility Asset Type Code
W1_ASSET.ASSET_TYPE_CD
 
UTIL_ASSET_TYPE_
DESCR
Utility Asset Type Description
W1_ASSET_TYPE_L.DESCR100
 
UTIL_ASSET_CLASS_CD
Utility Asset Class Code
W1_ASSET_TYPE.ASSET_CLASS_FLG
 
UTIL_ASSET_CLASS_
DESCR
Utility Asset Class Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the description from the Lookup Language table for the lookup field ASSET_CLASS_FLG.
 
If an override description is not available, regular description is extracted.
UTIL_ASSET_CAT_CD
Utility Asset Category Code
W1_ASSET_TYPE.ASSET_CAT_FLG
 
UTIL_ASSET_CAT_
DESCR
Utility Asset Category Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the description from the Lookup Language table for the lookup field ASSET_CAT_FLG.
 
If an override description is not available, regular description is extracted.
UTIL_ASSET_COND_
SCORE
Asset Condition Score
W1_ASSET.CONDITION_RATING
 
UTIL_ASSET_CONF_
RAT
Confidence Rating
W1_ASSET.CONFIDENCE_RATING
 
COND_SCORE_BKT_ST_RANGE
Asset Condition Score Bucket Start Range
F1_BKT_CONFIG_VAL.B KT_START_RANGE
This field is populated with the start range of the condition score bucket for which this asset's condition score falls into. It goes hand in hand with the Asset Condition Score Bucket End Range to constitute the actual bucket range the asset's score falls into.
 
Note: For details about how the buckets are configured, see Configuring Source in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
COND_SCORE_BKT_ED_RANGE
Asset Condition Score Bucket End Range
F1_BKT_CONFIG_VAL.B KT_END_RANGE
This field is populated with the end range of the condition score bucket for which this asset's condition score falls into. It goes hand in hand with the Asset Condition Score Bucket Start Range to constitute the actual bucket range the asset's score falls into.
 
Note: For details about how the buckets are configured, see Configuring Source in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
COND_SCORE_BKT_
DESCR
Asset Condition Score Bucket Description
F1_BKT_CONFIG_VAL_ L.DESCR
This field is populated with the description of the condition score bucket for which this asset's condition score falls into.
 
Note: For details about how the buckets are configured, see Configuring Source in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
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 7 Code
 
 
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
 
 
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
 
 
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_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_START_DTTM
Effective Start Date/Time
 
 
EFF_END_DTTM
Effective End 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.
 
Asset Inspection Status
Populated with all the possible outcomes for asset inspections. For example: whether it passed, failed, etc.
Properties
Property
Value
Target Table
CD_ASSET_INSP_STATUS
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
CI_LOOKUP_VAL_L
ODI Package
B1_PKG_CD_ASSET_INSP_STATUS
ETL View
B1_D_ASSET_INSP_STATUS_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
ASSET_INSP_STATUS_
KEY
Asset Inspection Status Dimension Surrogate Key
 
This field is populated from the B1_ASSET_INSP_STATUS_SEQ sequence.
Natural Keys
ASSET_INSP_STATUS_
CD
Asset Inspection Status Code
CI_LOOKUP_VAL_L.FIELD_VALUE
This field is populated with the lookup value for the lookup field INSPECTION_INDICATOR_FLG.
Attributes
ASSET_INSP_STATUS_
DESCR
Asset Inspection Status Description
CI_LOOKUP_VAL_L.DESCR
 
CI_LOOKUP_VAL_L.DESCR_OVRD
This field is populated with the description from Lookup Language table for the ASSET_INSP_STATUS_FLG lookup field.
 
If override description is not available, regular description is extracted.
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 7 Code
 
 
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
 
 
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
 
 
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
UPDATE_DTTM
Update Date and 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.
 
Location
Extracts data from the Location entity in Oracle Utilities Work and Asset Management system. The location hierarchy is extracted up to 10 levels.
Properties
Property
Value
Target Table
CD_LOCATION
Table Type
Dimension
SCD Type
Type 2
Source System Driver Table
W1_NODE
ODI Package
B1_PKG_CD_LOCATION
ETL View
B1_D_LOCATION_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
LOCATION_KEY
Location Dimension Surrogate Key
 
This field is populated from the B1_LOCATION_SEQ sequence.
Natural Keys
SRC_LOCATION_ID
Source Location ID
W1_NODE.NODE_ID
 
Attributes
LOCATION_INFO
Location Information
W1_NODE.DESCR100
Note: This field can be customized to override the value provided out-of-the-box.
LOCATION_TYPE_CD
Location Type Code
W1_NODE.NODE_TYPE_CD
 
LOCATION_TYPE_
DESCR
Location Type Description
W1_NODE_TYPE_L.DESCR100
 
LOCATION_CLASS_CD
Location Class Code
W1_NODE.LOCATION_CLASS_FLG
 
LOCATION_CLASS_
DESCR
Location Class Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the description from the Lookup Language table for the lookup field LOCATION_CLASS_FLG.
 
If an override description is not available, regular description is extracted
LOCATION_TYPE_
CLASS_CD
Location Type Class Code
W1_NODE_TYPE.NODE_CLASS_FLG
 
LOCATION_TYPE_
CLASS_DESCR
Location Type Class Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the description from the Lookup Language table for the lookup field NODE_CLASS_FLG.
 
If an override description is not available, regular description is extracted.
LOCATION_CATEGORY
Location Category
 
This field is populated with:
• A - if the location is an Asset Location
• S - if the location is a Storeroom
• O - if the location is an Organization
CRITICALITY_VAL
Asset Criticality Flag
W1_NODE.CRITICALITY_FLG
This field is populated with the location's actual criticality.
CRITICALITY_BKT_ST_
RANGE
Asset Criticality Bucket Start Range
F1_BKT_CONFIG_VAL.BKT_START_RANGE
This field is populated with the start range of the criticality bucket for which this asset's criticality falls into. It goes hand in hand with the Asset Criticality Bucket End Range to constitute the actual bucket range the asset's criticality falls into.
 
Note: See Configuring Source in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide for details about how to configure the buckets.
CRITICALITY_BKT_ED_RANGE
Asset Criticality Bucket End Range
F1_BKT_CONFIG_VAL.BKT_END_RANGE
This field is populated with the end range of the criticality bucket for which this asset's criticality falls into. It goes hand in hand with the Asset Criticality Bucket Start Range to constitute the actual bucket range the asset's criticality falls into.
 
Note: See Configuring Source in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide for details about how to configure the buckets.
CRITICALITY_BKT_
DESCR
Asset Criticality Bucket Description
F1_BKT_CONFIG_VAL_L.DESCR
This field is populated with the description of the criticality bucket for which the location's criticality falls into.
 
Note: See Configuring Source in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide for details about how to configure the buckets.
CRITICALITY_CAT_CD
Location Criticality Category Code
F1_BKT_CONFIG_VAL.BKT_VAL_TYPE_CD
This field is populated with the category of the Criticality Bucket for which this location's criticality falls into.
 
Examples of criticality category are 'Critical', 'High', 'Medium', and 'Low'.
 
Note: See Configuring Source in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide for details about how to configure the buckets.
CRITICALITY_CAT_
DESCR
Location Criticality Category Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the description from the Lookup Language table for the lookup field CRIT_CAT_FLG. If override description is not available, regular description is extracted
 
Note: See Configuring Source in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide for details about how to configure the buckets.
ENV_RATING
Environment Rating
 
This field is populated with the Environment Rating retrieved from the location's characteristic of type “Environment Rating (W1-ENVRT)”.
RCM_SYSTEM_CD
RCM System Code
W1_NODE. RCM_SYSTEM_FLG
 
RCM_SYSTEM_DESCR
RCM System Description
 
If an override description is not available, regular description is extracted.
PARENT_LOCATION_LVL1_CD
Parent Location Level 1 Code
W1_NODE.PARENT_NODE_ID
This field is populated with the location ID of the parent of the current location.
PARENT_LOCATION_LVL1_DESCR
Parent Location Level 1 Description
W1_NODE.DESCR100
This field is populated with the description of parent 1 location.
PARENT_LOCATION_LVL2_CD
Parent Location Level 2 Code
W1_NODE.PARENT_NODE_ID
This field is populated with the location ID of the parent of the current location.
PARENT_LOCATION_LVL2_DESCR
Parent Location Level 2 Description
W1_NODE.DESCR100
This field is populated with the description of parent 2 location.
PARENT_LOCATION_LVL3_CD
Parent Location Level 3 Code
W1_NODE.PARENT_NODE_ID
This field is populated with the location ID of the parent of the current location.
PARENT_LOCATION_LVL3_DESCR
Parent Location Level 3 Description
W1_NODE.DESCR100
This field is populated with the description of parent 3 location.
PARENT_LOCATION_LVL4_CD
Parent Location Level 4 Code
W1_NODE.PARENT_NODE_ID
This field is populated with the location ID of the parent of the current location.
PARENT_LOCATION_LVL4_DESCR
Parent Location Level 4 Description
W1_NODE.DESCR100
This field is populated with the description of parent 4 location.
PARENT_LOCATION_LVL5_CD
Parent Location Level 5 Code
W1_NODE.PARENT_NODE_ID
This field is populated with the location ID of the parent of the current location.
PARENT_LOCATION_LVL5_DESCR
Parent Location Level 5 Description
W1_NODE.DESCR100
This field is populated with the description of parent 5 location.
PARENT_LOCATION_LVL6_CD
Parent Location Level 6 Code
W1_NODE.PARENT_NODE_ID
This field is populated with the location ID of the parent of the current location.
PARENT_LOCATION_LVL6_DESCR
Parent Location Level 6 Description
W1_NODE.DESCR100
This field is populated with the description of parent 6 location.
PARENT_LOCATION_LVL7_CD
Parent Location Level 7 Code
W1_NODE.PARENT_NODE_ID
This field is populated with the location ID of the parent of the current location.
PARENT_LOCATION_LVL7_DESCR
Parent Location Level 7 Description
W1_NODE.DESCR100
This field is populated with the description of parent 7 location.
PARENT_LOCATION_LVL8_CD
Parent Location Level 8 Code
W1_NODE.PARENT_NODE_ID
This field is populated with the location ID of the parent of the current location.
PARENT_LOCATION_LVL8_DESCR
Parent Location Level 8 Description
W1_NODE.DESCR100
This field is populated with the description of parent 8 location.
PARENT_LOCATION_LVL9_CD
Parent Location Level 9 Code
W1_NODE.PARENT_NODE_ID
This field is populated with the location ID of the parent of the current location.
PARENT_LOCATION_LVL9_DESCR
Parent Location Level 9 Description
W1_NODE.DESCR100
This field is populated with the description of parent 9 location.
PARENT_LOCATION_LVL10_CD
Parent Location Level 10 Code
W1_NODE.PARENT_NODE_ID
This field is populated with the location ID of the parent of the current location.
PARENT_LOCATION_LVL10_DESCR
Parent Location Level 10 Description
W1_NODE.DESCR100
This field is populated with the description of parent 10 location.
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 7 Code
 
 
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
 
 
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
 
 
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
UPDATE_DTTM
Update Date and Time
 
 
EFF_START_DTTM
Effective Start Date/Time
 
 
EFF_END_DTTM
Effective End 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.
 
Service History
Stores all service histories from the source system.
Properties
Property
Value
Target Table
CD_SERVICE_HIST
Table Type
Dimension
SCD Type
Type 2
Source System Driver Table
W1_SVC_HIST
ODI Package
B1_PKG_CD_SERVICE_HIST
ETL View
B1_D_SERVICE_HIST_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
SERVICE_HIST_KEY
Service History Dimension Surrogate Key
 
Populated from the B1_SERVICE_HIST_SEQ sequence.
Natural Keys
SRC_SERVICE_HIST_ID
Source Service History ID
W1_SVC_HIST.SVC_HIST_ID
 
Attributes
FAILURE_TYPE_CD
Failure Cause Code
W1_SVC_HIST.FAILURE_TYPE_CD
Populated only for failure service histories.
FAILURE_TYPE_DESCR
Failure Cause Description
W1_FAILURE_TYPE_L.DESCR100
Populated with the description of the Failure Type.
FAILURE_MODE_CD
Failure Mode Code
W1_SVC_HIST.FAILURE_MODE_CD
Populated only for failure service histories.
FAILURE_MODE_DESCR
Failure Mode Description
W1_FAILURE_MODE_L.DESCR100
Populated with the description of the Failure Mode Code.
FAILURE_REPAIR_CD
Failure Repair Code
W1_SVC_HIST. FAILURE_REPAIR_CD
Populated only for failure service histories.
FAILURE_ REPAIR_DESCR
Failure Repair Description
W1_FAILURE_REPAIR_L.DESCR100
Populated with the description of the Failure Repair Code.
FAILURE_ROOT_CAUSE
Failure Root Cause
W1_SVC_HIST.BO_DATA_AREA
Populated with the value for the failure root cause XML element from the CLOB column. It is populated only for failure service histories.
FAILURE_COMMENT
Failure Comment
W1_SVC_HIST.BO_DATA_AREA
Populated with the value for the comments XML element from the CLOB column. It is populated only for failure service histories.
FAILURE_COMP_CD
Failure Component Code
W1_SVC_HIST.FAILURE_COMP_CD
Populated only for the failure service histories.
FAILURE_COMP_DESCR
Failure Component Description
W1_FAILURE_COMP_L.DESCR100
Populated with the description of the Failure Component Code.
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 7 Code
 
 
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
 
 
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
 
 
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_START_DTTM
Effective Start Date/Time
 
 
EFF_END_DTTM
Effective End Date/Time
 
 
DATA_LOAD_DTTM
Data Load Date/Time
 
Populated with the load timestamp value.
DATA_SOURCE_IND
Data Source Indicator
CI_INSTALLATION.ENV_ID
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
 
Populated with the ODI job execution session number.
 
Service History Type
Extracts the service history types and the respective category details from the source system.
Properties
Property
Value
Target Table
CD_SERVICE_HIST_TYPE
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
W1_SVC_HIST_TYPE
ODI Package
B1_PKG_CD_SERVICE_HIST_TYPE
ETL View
B1_D_SERVICE_HIST_TYPE_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
SERVICE_HIST_TYPE_
KEY
Service History Type Dimension Surrogate Key
 
This field is populated from the B1_SERVICE_HIST_TYPE_SEQ sequence.
Natural Keys
SERVICE_HIST_TYPE_
CD
Service History Type Code
W1_SVC_HIST_TYPE.SVC_HIST_TYPE_CD
 
Attributes
SERVICE_HIST_TYPE_
DESCR
Service History Type Description
W1_SVC_HIST_TYPE_L.DESCR100
 
SERVICE_HIST_CAT_CD
Service History Category Code
W1_SVC_HIST_TYPE.SVC_HIST_CATEGORY_FLG
 
SERVICE_HIST_CAT_
DESCR
Service History Category Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with description from the Lookup Language table for the SVC_HIST_CATEGORY_FLG lookup field.
 
If an override description is not available, regular description is extracted.
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 7 Code
 
 
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
UPDATE_DTTM
Update Date and 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.