Property | Value |
Target Table | CD_W_ASSET_AGE |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | F1_BKT_CONFIG |
ODI Package | B1_PKG_CD_W_ASSET_AGE |
ETL View | B1_D_AGE_BUCKETS_VW |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
W_ASSET_AGE_KEY | Asset Age Dimension | Populated from the B1_W_ASSET_AGE_SEQ sequence. | |
Natural Keys | |||
W_ASSET_AGE_ST_ RANGE | Asset Age Start Range | F1_BKT_CONFIG_VAL.BKT_START_RANGE | Populated based on the bucket ranges defined for the business object W1-WAssetAgeBuckets. |
W_ASSET_AGE_ED_ RANGE | Asset Age End Range | F1_BKT_CONFIG_VAL.BKT_END_RANGE | Populated based on the bucket ranges defined for the business object W1-WAssetAgeBuckets. |
Attributes | |||
W_ASSET_AGE_DESCR | Asset Age Range Description | F1_BKT_CONFIG_VAL_L.DESCR | 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 | ||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
UPDATE_DTTM | Update Date and Time | ||
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_ASSET_DISP |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | F1_EXT_LOOKUP_VAL_L |
ODI Package | B1_PKG_CD_ASSET_DISP |
ETL View | B1_D_ASSET_DISP_VW |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
ASSET_DISP_KEY | Asset Disposition Dimension | 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 | Populated with the lookup value for the extendable lookup business object W1-AssetDisposition. |
Attributes | |||
ASSET_DISP_DESCR | Asset Disposition Description | F1_EXT_LOOKUP_VAL_L.DESCR_OVRD F1_EXT_LOOKUP_VAL_L.DESCR | Populated with the description from the Lookup Language table for the lookup field ASSET_DISP_FLG. 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 | 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_W_ASSET_INSTALL_AGE |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | B1_D_W_ASSET_INSTALL_AGE_VW |
ODI Package | B1_PKG_CD_W_ASSET_INSTALL_AGE |
ETL View | B1_D_AGE_BUCKETS_VW |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
W_ASSET_INSTALL_AGE_KEY | Asset Install Age Dimension Surrogate Key | Populated from the B1_W_ASSET_INSTALL_AGE_SEQ sequence. | |
Natural Keys | |||
W_ASSET_INSTALL_ST_RANGE | Asset Install Age Start Range | F1_BKT_CONFIG_VAL.BKT_START_RANGE | Populated based on the bucket ranges defined for the business object W1-WAssetInstallAgeBuckets. |
W_ASSET_INSTALL_ED_RANGE | Asset Install Age End Range | F1_BKT_CONFIG_VAL.BKT_END_RANGE | Populated based on the bucket ranges defined for the business object W1-WAssetInstallAgeBuckets. |
Attributes | |||
W_ASSET_INSTALL_AGE_DESCR | Asset Install Age Range | F1_BKT_CONFIG_VAL_L.DESCR | Populated based on the bucket ranges defined for the business object W1-WAssetInstallAgeBuckets. |
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 | 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_NUM_CYC_OD |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | F1_BKT_CONFIG |
ODI Package | B1_PKG_CD_NUM_CYC_OD |
ETL View |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
NUM_CYC_OD_KEY | Number of Cycles Overdue Dimension Surrogate Key | Populated from the B1_NUM_CYC_OD_SEQ sequence. | |
Natural Keys | |||
NUM_CYC_OD_ST_ RANGE | Number of Cycles Overdue Start Range | F1_BKT_CONFIG_VAL.BKT_START_RANGE | Populated based on the bucket ranges defined for the business object W1-NumberOfCyclesOverdue Bucket. |
NUM_CYC_OD_ED_ RANGE | Number of Cycles Overdue End Range | F1_BKT_CONFIG_VAL.BKT_END_RANGE | Populated based on the bucket ranges defined for the business object W1-NumberOfCyclesOverdue Bucket. |
Attributes | |||
NUM_CYC_OD_DESCR | Number of Cycles Overdue Description | F1_BKT_CONFIG_VAL_L.DESCR | Populated based on the bucket ranges defined for the business object W1-NumberOfCyclesOverdue Bucket. |
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 | 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_OWNING_ORG |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | CI_ACC_GRP_L |
ODI Package | B1_PKG_CD_OWNING_ORG |
ETL View | B1_D_OWNING_ORG_VW |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
OWNING_ORG_KEY | Owning Organization Dimension Surrogate Key | Populated from the B1_OWNING_ORG_SEQ sequence. | |
Natural Keys | |||
OWNING_ORG_CD | Owning Organization Code | CI_ACC_GRP_L.ACCESS_GRP_CD | |
Attributes | |||
OWNING_ORG_DESCR | Owning Organization Description | CI_ACC_GRP_L.DESCR | |
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 | 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_W_PLANNER |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | W1_PLANNER_L |
ODI Package | B1_PKG_CD_W_PLANNER |
ETL View | B1_D_W_PLANNER_VW |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
W_PLANNER_KEY | Planner Dimension Surrogate Key | Populated from the B1_W_PLANNER_SEQ sequence. | |
Natural Keys | |||
W_PLANNER_CD | Planner Code | W1_PLANNER_L. PLANNER_CD | |
Attributes | |||
W_PLANNER_DESCR | Planner | W1_PLANNER_L. DESCR100 | |
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 | 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_RESRC_TYPE |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | W1_RESRC_TYPE |
ODI Package | B1_PKG_CD_RESRC_TYPE |
ETL View | B1_D_RESRC_TYPE_VW |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
RESRC_TYPE_KEY | Resource Type Dimension Surrogate Key | Populated from the B1_RESRC_TYPE_SEQ sequence. | |
Natural Keys | |||
RESRC_TYPE_ID | Resource Type ID | W1_RESRC_TYPE.RESRC_TYPE_ID | |
Attributes | |||
RESRC_TYPE_DESCR | Resource Type Description | W1_RESRC_TYPE_L. DESCR100 | |
RESRC_CLASS_CD | Resource Class Flag | W1_RESRC_TYPE.W1_ RESRC_CLASS_FLG | |
RESRC_CLASS_DESCR | Resource Class Description | CI_LOOKUP_VAL_L. DESCR_OVRD CI_LOOKUP_VAL_L. DESCR | Populated with the description from Lookup Language table for W1_RESRC_CLASS_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 | 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 |
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_WO |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | W1_WO |
ODI Package | B1_PKG_CD_WO |
ETL View | B1_D_WO_VW |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
WO_KEY | Work Order Dimension Surrogate Key | Populated from the B1_WO_SEQ sequence. | |
Natural Keys | |||
SRC_WO_ID | Source Work Order ID | W1_WO.WO_ID | |
Attributes | |||
WO_DESCR | Work Order Description | W1_WO.DESCR100 | |
WORK_PRIORITY_VAL | Work Priority | W1_WO.WORK_PRIORITY_FLG | Populated with the work order’s work priority. |
PRIORITY_BKT_ST_ RANGE | Work Priority Bucket Start Range | F1_BKT_CONFIG_VAL.BKT_START_RANGE | Populated with the start range of the work priority bucket for which this work order's work priority falls into. It goes hand in hand with the Work Priority Bucket End Range to constitute the actual bucket range the work order's work priority falls into. See Configuring Source in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide for details about how to configure the buckets. |
PRIORITY_BKT_ED_ RANGE | Work Priority Bucket End Range | F1_BKT_CONFIG_VAL.BKT_END_RANGE | Populated with the end range of the work priority bucket for which this work order's work priority falls into. It goes hand in hand with the Work Priority Bucket Start Range to constitute the actual bucket range the work order's work priority falls into. See Configuring Source in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide for details about how to configure the buckets. |
PRIORITY_BKT_DESCR | Work Priority Bucket Description | F1_BKT_CONFIG_VAL_L.DESCR | Populated with the description of the work priority bucket for which this work order's work priority falls into. See Configuring Source in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide for details about how to configure the buckets. |
PRIORITY_CAT_CD | Work Priority Category Code | F1_BKT_CONFIG_VAL.BKT_VAL_TYPE_CD | Populated with the category of the work priority bucket for which this work order's work priority falls into. An example of a category is 'High'. |
PRIORITY_CAT_DESCR | Work Priority Category Description | CI_LOOKUP_VAL_L. DESCR_OVRD CI_LOOKUP_VAL_L. DESCR | Populated with the description of the work priority category from Lookup Language table for PRI_CAT_FLG lookup field. If an override description is not available, the regular description is extracted. |
WO_NUM | Work Order Number | W1_WO.WO_NUM | |
WORK_TYPE_CD | Work Type Flag | W1_WO.WORK_TYPE_ FLG | |
WORK_TYPE_DESCR | Work Type Description | CI_LOOKUP_VAL_L. DESCR_OVRD CI_LOOKUP_VAL_L. DESCR | Populated with the description of the work type from Lookup Language table for WORK_TYPE_FLG lookup field. If an override description is not available, the regular description is extracted. |
WORK_CAT_CD | Work Category Flag | W1_WO.WORK_ CATEGORY_FLG | |
WORK_CAT_DESCR | Work Category | CI_LOOKUP_VAL_L. DESCR_OVRD CI_LOOKUP_VAL_L. DESCR | Populated with the description of the work category from Lookup Language table for WORK_CATEGORY_FLG lookup field. If an override description is not available, the regular description is extracted. |
WORK_CLASS_CD | Work Class Flag | W1_WO.WORK_CLASS_FLG | |
WORK_CLASS_DESCR | Work Class | CI_LOOKUP_VAL_L. DESCR_OVRD CI_LOOKUP_VAL_L. DESCR | Populated with the description of the work class from Lookup Language table for WORK_CLASS_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 | |||
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_WO_ACTIVITY |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | W1_ACTIVITY |
ODI Package | B1_PKG_CD_WO_ACTIVITY |
ETL View | B1_D_WO_ACTIVITY_VW |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
WO_ACTIVITY_KEY | Work Order Activity Key | Populated from the B1_WO_ACTIVITY_SEQ sequence. | |
Natural Keys | |||
SRC_WO_ACTIVITY_ID | Source Activity ID | W1_ACTIVITY.ACT_ID | |
Attributes | |||
HELD_FOR_PARTS_CD | Held for Parts Code | W1_ACTIVITY.HELD_ FOR_PARTS_FLG | |
HELD_FOR_PARTS_ DESCR | Held for Parts Description | CI_LOOKUP_VAL_L. DESCR_OVRD CI_LOOKUP_VAL_L. DESCR | Populated with the description from the Lookup Language table for the lookup field HELD_FOR_PARTS_FLG. If an override description is not available, regular description is extracted. |
WO_ACTIVITY_TYPE_ CD | Activity Type Code | W1_ACTIVITY.ACT_ TYPE_CD | |
WO_ACTIVITY_TYPE_ DESCR | Activity Type Description | W1_ACTIVITY_TYPE_L.DESCR100 | |
SERVICE_CLASS_CD | Service Class Code | W1_ACTIVITY.SERVICE_CLASS_CD | |
SERVICE_CLASS_DESCR | Service Class Description | W1_SERVICE_CLASS_L.DESCR100 | |
RENEWAL_CD | Renewal Flag | W1_SERVICE_CLASS. RENEWAL_FLG | |
RENEWAL_DESCR | Renewal Description | CI_LOOKUP_VAL_L. DESCR_OVRD CI_LOOKUP_VAL_L. DESCR | Populated with the description from the Lookup Language table for the lookup field RENEWAL_FLG. If an override description is not available, regular description is extracted. |
EMERGENCY_CD | Emergency Flag | W1_ACTIVITY. EMERGENCY_FLG | |
EMERGENCY_DESCR | Emergency Description | CI_LOOKUP_VAL_L. DESCR_OVRD CI_LOOKUP_VAL_L. DESCR | Populated with the description from the Lookup Language table for the lookup field EMERGENCY_FLG. If an override description is not available, regular description is extracted. |
WO_ACTIVITY_DESCR | Activity Description | W1_ACTIVITY. DESCR100 | |
WO_ACTIVITY_NBR | Activity Number | W1_ACTIVITY.ACT_ NUM | |
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_WO_ACTIVITY_STATUS |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | F1_BUS_OBJ F1_BUS_OBJ_STATUS_RSN |
ODI Package | B1_PKG_CD_WO_ACTIVITY_STATUS |
ETL View | B1_D_WO_ACTIVITY_STATUS_VW |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
WO_ACTIVITY_STATUS_KEY | Work Order Activity BO Status Key | Populated from the B1_WO_ACTIVITY_STATUS_SEQ sequence. | |
Natural Keys | |||
BUS_OBJ_CD | Business Object | F1_BUS_OBJ.BUS_OBJ_ CD | |
STATUS_CD | BO Status Code | F1_BUS_OBJ_STATUS. BO_STATUS_CD | Populated with the statuses available on life cycle business object of the current business object. |
STATUS_RSN_CD | Status Reason Code | F1_BUS_OBJ_STATUS. BO_STATUS_REASON_CD | For business objects where status reason is optional, a record with a dummy value of ‘***’ for status reason code is inserted. It is used to map the fact records which do not have a status reason code. |
Attributes | |||
STATUS_COND_CD | Status Condition Code | F1_BUS_OBJ_STATUS. BO_STATUS_COND_ FLG | |
STATUS_COND_DESCR | Status Condition Description | CI_LOOKUP_VAL_L. DESCR_OVRD CI_LOOKUP_VAL_L. DESCR | Populated with the status condition description from the Lookup Language table for the lookup field BO_STATUS_COND_FLG. If an override description is not available, regular description is extracted. |
BUS_OBJ_DESCR | Business Object Description | F1_BUS_OBJ_L.DESCR | |
STATUS_DESCR | Status Description | F1_BUS_OBJ_STATUS_L.DESCR | |
STATUS_RSN_DESCR | Status Reason Description | F1_BUS_OBJ_STATUS_ RSN_L.DESCR | |
BACKLOG_IND | Backlog Indicator | F1_BUS_OBJ_STATUS_ OPT.BO_OPT_VAL | Set to ‘1’ if the BO option value for the current BO status is set as backlog (W1BL). Else, it is set to ‘0’. |
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 | 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_WO_STATUS |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | F1-BUS OBJ F1-STSREASON |
ODI Package | B1_PKG_CD_WO_STATUS |
ETL View | B1_D_WO_STATUS_VW |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
WO_STATUS_KEY | Work Order BO Status Key | Populated from the B1_WO_STATUS_SEQ sequence. | |
Natural Keys | |||
BUS_OBJ_CD | Business Object | F1_BUS_OBJ.BUS_OBJ_ CD | |
STATUS_CD | BO Status Code | F1_BUS_OBJ_STATUS. BO_STATUS_CD | Populated with the statuses available on life cycle business object of the current business object. |
STATUS_RSN_CD | Status Reason Code | F1_BUS_OBJ_STATUS. BO_STATUS_REASON_ FLG | For business objects where status reason is optional, a record with a dummy value of ‘***’ for status reason code is inserted. It is used to map the fact records which do not have a status reason code. |
Attributes | |||
STATUS_COND_CD | Status Condition Code | F1_BUS_OBJ_STATUS. BO_STATUS_COND_ FLG | |
STATUS_COND_DESCR | Status Condition Description | CI_LOOKUP_VAL_L. DESCR_OVRD CI_LOOKUP_VAL_L. DESCR | Populated with the status condition description from the Lookup Language table for the lookup field BO_STATUS_COND_FLG. If an override description is not available, regular description is extracted. |
BUS_OBJ_DESCR | Business Object Description | F1_BUS_OBJ_L.DESCR | |
STATUS_DESCR | Status Description | F1_BUS_OBJ_STATUS_L.DESCR | |
STATUS_RSN_DESCR | Status Reason Description | F1_BUS_OBJ_STATUS_RSN_L.DESCR | |
BACKLOG_IND | Backlog Indicator | F1_BUS_OBJ_STATUS_ OPT.BO_OPT_VAL | Set to ‘1’ if the BO option value for the current BO status is set as backlog (W1BL). Else, it is set to ‘0’. |
PLANNED_IND | Planned Indicator | F1_BUS_OBJ_STATUS_ OPT.BO_OPT_VAL | Set to ‘1’ if the BO option value for the current BO status is set as backlog (W1PL). Else, it is set to ‘0’. |
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 | 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. |