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