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 |
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. |
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 |
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. |
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 |
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. |
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 |
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. |
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 |
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. |