Dimensions
Asset Disposition
Stores all possible dispositions that an asset entity can be in.
Properties
Property
Value
Target Table Name
CD_ASSET_DISP
Table Type
Dimension
SCD Type
Type 1
Driver Table Name
F1_EXT_LOOKUP_VAL_L
ODI Package Name
B1_PKG_CD_ASSET_DISP
ETL View Name
B1_D_ASSET_DISP_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
ASSET_DISP_KEY
Asset Disposition Dimension Key
 
This field is populated from the B1_ASSET_DISP_SEQ sequence.
Natural Keys
ASSET_DISP_CD
Asset Disposition Code
F1_EXT_LOOKUP_VAL_L.F1_EXT_LOOKUP_VALUE
 
Attributes
ASSET_DISP_DESCR
Asset Disposition Description
F1_EXT_LOOKUP_VAL_L.DESCR_OVRD
 
F1_EXT_LOOKUP_VAL_L.DESCR
 
F1_EXT_LOOKUP_VAL_L.LANGUAGE_CD
This field is populated with the description of the asset disposition from Lookup Language table for ASSET_DISP_FLG lookup field.
 
If an override description is not available, the 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
DATA_LOAD_DTTM
Data Load Date/Time
 
This field is populated with the load timestamp value.
UPDATE_DTTM
Update Date/Time
 
 
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 Age
Extracts the age buckets for an asset as configured in the source Oracle Utilities Operational Device Management system.
Properties
Property
Value
Target Table Name
CD_ASSET_AGE
Table Type
Dimension
SCD Type
Type 1
Driver Table Name
W1_BKT_CONFIG_VAL
ODI Package Name
B1_PKG_CD_ASSET_AGE
ETL View Name
B1_D_ASSET_AGE_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
ASSET_AGE_KEY
Asset Age Dimension Key
 
This field is populated from the B1_ASSET_AGE_SEQ sequence.
Natural Keys
ASSET_TYPE_CD
Asset Type Code
W1_BKT_CONFIG_REL_OBJ.PK_VALUE1
 
Attributes
ASSET_AGE_DESCR
Asset Age Description
W1_BKT_CONFIG_VAL_L.DESCR
 
W1_BKT_CONFIG_VAL_L.LANGUAGE_CD
This field is populated with the description of the asset age from Lookup Language table for ASSET_AGE_FLG lookup field.
 
If an override description is not available, the regular description is extracted.
ASSET_AGE_ST_RANGE
Age Start Range
W1_BKT_CONFIG_VAL.START_RANGE
This field is populated based on the bucket ranges defined for the business object W1-WAssetAgeBuckets.
ASSET_AGE_ED_RANGE
Age End Range
W1_BKT_CONFIG_VAL.END_RANGE
This field is populated based on the bucket ranges defined for the business object W1-WAssetAgeBuckets.
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
DATA_LOAD_DTTM
Data Load Date/Time
 
This field is populated with the load timestamp value.
UPDATE_DTTM
Update Date/Time
 
 
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.
Note: The bucket dimension ELT job is configured to be initial load only. Any incremental changes to these buckets after the initial run will not be captured in BI. However, if there arises a need to reconfigure the buckets, then data should be truncated in the BI star schema tables and reloaded to reflect the changes. The bucket dimensions, along with the associated facts (Operational Device Snapshot and Accumulation), should be truncated and reloaded.
For details about reloading the data, see the Data Reload section in Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
Asset Install Age
Extracts the age buckets for an asset’s installed age as configured in the source Oracle Utilities Operational Device Management system.
Properties
Property
Value
Target Table Name
CD_ASSET_INSTALL_AGE
Table Type
Dimension
SCD Type
Type 1
Driver Table Name
W1_BKT_CONFIG_VAL
ODI Package Name
B1_PKG_CD_ASSET_INSTALL_AGE
ETL View Name
B1_D_ASSET_INSTALL_AGE_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
ASSET_INSTALL_AGE_
KEY
Asset Install Age Dimension Key
 
This field is populated from the B1_ASSET_INSTALL_AGE_SEQ sequence.
Natural Keys
ASSET_TYPE_CD
Asset Type Code
W1_BKT_CONFIG_REL_OBJ.PK_VALUE1
 
Attributes
ASSET_INSTALL_AGE_
DESCR
Asset Install Age Description
W1_BKT_CONFIG_VAL_L.DESCR
 
W1_BKT_CONFIG_VAL_L.LANGUAGE_CD
This field is populated with the description of the asset install age from the Lookup Language table for ASSET_INSTALL_AGE_FLG lookup field.
 
If an override description is not available, the regular description is extracted.
ASSET_INSTALL_AGE_
ST_RANGE
Asset Install Age Start Range
W1_BKT_CONFIG_VAL.START_RANGE
This field is populated based on the bucket ranges defined for the business object W1-WAssetAgeBuckets.
ASSET_INSTALL_AGE_
ED_RANGE
Asset Install Age End Range
W1_BKT_CONFIG_VAL.END_RANGE
This field is populated based on the bucket ranges defined for the business object W1-WAssetAgeBuckets.
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
DATA_LOAD_DTTM
Data Load Date/Time
 
This field is populated with the load timestamp value.
UPDATE_DTTM
Update Date/Time
 
 
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.
Note: The bucket dimension ELT job is configured to be initial load only. Any incremental changes to these buckets after the initial run will not be captured in BI. However, if there arises a need to reconfigure the buckets, then data should be truncated in the BI star schema tables and reloaded to reflect the changes. The bucket dimensions, along with the associated facts (Operational Device Snapshot and Accumulation), should be truncated and reloaded.
For details about reloading the data, see the Data Reload section in Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
Asset Instore Age
Populated with the age ranges for the days since the asset was put in storage.
Properties
Property
Value
Target Table Name
CD_ASSET_INSTORE_AGE
Table Type
Dimension
SCD Type
Type 1
Driver Table Name
W1_BKT_CONFIG_VAL
ODI Package Name
B1_PKG_CD_ASSET_INSTORE_AGE
ETL View Name
B1_D_ASSET_INSTORE_AGE_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
ASSET_INSTORE_AGE_KEY
Asset Instore Age Dimension Key
 
This field is populated from the B1_ASSET_INSTORE_AGE_SEQ sequence.
Natural Keys
ASSET_TYPE_CD
Asset Type Code
W1_BKT_CONFIG_REL_OBJ.PK_VALUE1
 
Attributes
ASSET_INSTORE_AGE_DESCR
Asset Instore Age Description
W1_BKT_CONFIG_VAL_L.DESCR
 
W1_BKT_CONFIG_VAL_L.LANGUAGE_CD
This field is populated with the description of the asset instore age from the Lookup Language table for ASSET_INSTORE_AGE_FLG lookup field.
 
If an override description is not available, the regular description is extracted.
ASSET_INSTORE_AGE_
ST_RANGE
Asset Instore Age Start Range
W1_BKT_CONFIG_VAL.START_RANGE
This field is populated based on the bucket ranges defined for the business object W1-WAssetAgeBuckets.
ASSET_INSTORE_AGE_ED_RANGE
Asset Instore Age End Range
W1_BKT_CONFIG_VAL.END_RANGE
This field is populated based on the bucket ranges defined for the business object W1-WAssetAgeBuckets.
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
DATA_LOAD_DTTM
Data Load Date/Time
 
This field is populated with the load timestamp value.
UPDATE_DTTM
Update Date/Time
 
 
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.
Note: The bucket dimension ELT job is configured to be initial load only. Any incremental changes to these buckets after the initial run will not be captured in BI. However, if there arises a need to reconfigure the buckets, then data should be truncated in the BI star schema tables and reloaded to reflect the changes. The bucket dimensions, along with the associated facts (Operational Device Snapshot and Accumulation), should be truncated and reloaded.
For details about reloading the data, see the Data Reload section in Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
Operational Device
Extracts asset data related to operational devices from the Oracle Utilities Operational Device Management system. The appropriate firmware versions are retrieved based on the configuration set on the BI Extract Parameters in Oracle Utilities Operational Device Management.
Properties
Property
Value
Target Table
CD_OPR_DEVICE
Table Type
Dimension
SCD Type
Type 2
Source System Driver Table
W1_ASSET
ODI Package
B1_PKG_CD_OPR_DEVICE
ETL View
B1_D_OPR_DEVICE_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
OPR_DEVICE_KEY
Operational Device Dimension Key
 
This field is populated from the B1_OPR_DEVICE_SEQ sequence.
Natural Keys
SRC_ASSET_ID
Source Asset ID
 
This field is populated with only those assets whose BO name (BUS_OBJ_CD) is as configured in the BI config table.
Attributes
FIRMWARE1
Firmware Version 1
W1_ASSET_IDENTIFIER.W1_ID_VALUE
The identifier value is retrieved based on the firmware Identifier Type configured in the Master Configuration for BI extract parameters. The Identifier Type configured for firmware 1 slot is retrieved.
FIRMWARE2
Firmware Version 2
W1_ASSET_IDENTIFIER.W1_ID_VALUE
The identifier value is retrieved based on the firmware Identifier Type configured in the Master Configuration for BI extract parameters. The Identifier Type configured for firmware 2 slot is retrieved.
FIRMWARE3
Firmware Version 3
W1_ASSET_IDENTIFIER.W1_ID_VALUE
The identifier value is retrieved based on the firmware Identifier Type configured in the Master Configuration for BI extract parameters. The Identifier Type configured for firmware 3 slot is retrieved.
FIRMWARE4
Firmware Version 4
W1_ASSET_IDENTIFIER.W1_ID_VALUE
The identifier value is retrieved based on the firmware Identifier Type configured in the Master Configuration for BI extract parameters. The Identifier Type configured for firmware 4 slot is retrieved.
FIRMWARE5
Firmware Version 5
W1_ASSET_IDENTIFIER.W1_ID_VALUE
The identifier value is retrieved based on the firmware Identifier Type configured in the Master Configuration for BI extract parameters. The Identifier Type configured for firmware 5 slot is retrieved.
FIRMWARE6
Firmware Version 6
W1_ASSET_IDENTIFIER.W1_ID_VALUE
The identifier value is retrieved based on the firmware Identifier Type configured in the Master Configuration for BI extract parameters. The Identifier Type configured for firmware 6 slot is retrieved.
FIRMWARE7
Firmware Version 7
W1_ASSET_IDENTIFIER.W1_ID_VALUE
The identifier value is retrieved based on the firmware Identifier Type configured in the Master Configuration for BI extract parameters. The Identifier Type configured for firmware 7 slot is retrieved.
FIRMWARE8
Firmware Version 8
W1_ASSET_IDENTIFIER.W1_ID_VALUE
The identifier value is retrieved based on the firmware Identifier Type configured in the Master Configuration for BI extract parameters. The Identifier Type configured for firmware 8 slot is retrieved.
FIRMWARE9
Firmware Version 9
W1_ASSET_IDENTIFIER.W1_ID_VALUE
The identifier value is retrieved based on the firmware Identifier Type configured in the Master Configuration for BI extract parameters. The Identifier Type configured for firmware 9 slot is retrieved.
FIRMWARE10
Firmware Version 10
W1_ASSET_IDENTIFIER.W1_ID_VALUE
The identifier value is retrieved based on the firmware Identifier Type configured in the Master Configuration for BI extract parameters. The Identifier Type configured for firmware 10 slot is retrieved.
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
DATA_LOAD_DTTM
Data Load Date/Time
 
This field is populated with the load timestamp value.
EFF_START_DTTM
Effective Start Date/Time
 
 
EFF_END_DTTM
Effective End Date/Time
 
 
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.