Dimensions
This section lists all the dimension tables that belong to the Oracle Utilities Work and Asset Management star schemas only and are populated only from the Oracle Utilities Work and Asset Management source product.
Asset Age Bucket
Includes the configurable ranges used to group assets based on their ages.
For details about how the buckets are configured, see Configuring Source in Oracle Utilities Analytics Warehouse Installation and Configuration Guide included in this release. The documentation is available on Oracle Help Center at:
https://docs.oracle.com/en/industries/energy-water/analytics/index.html
Properties
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
Fields
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.
 
Asset Disposition
Extracts all possible dispositions of an asset entity in the source system.
Properties
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
Fields
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.
 
Asset Install Age Bucket
Includes configurable ranges used for grouping assets based on their installation ages.
For details about bucket configuration, see Configuring Source in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
Properties
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
Fields
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.
 
Number of Cycles Overdue Bucket
Stores the bucket ranges used for grouping activities based on how many cycles they are overdue.
See Configuring Source in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide for details about how to configure the buckets.
Properties
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
 
Fields
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.
 
Owning Organization
Stores all the owning organizations’ details from the source system.
Properties
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
Fields
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.
 
Planner
Stores all planners from the source system.
Properties
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
Fields
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.
 
Resource Type
Stores all resource types from the source system.
Properties
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
Fields
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.
 
Service History
Stores all service histories from the source system.
Properties
Property
Value
Target Table
CD_SERVICE_HIST
Table Type
Dimension
SCD Type
Type 2
Source System Driver Table
W1_SVC_HIST
ODI Package
B1_PKG_CD_SERVICE_HIST
ETL View
B1_D_SERVICE_HIST_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
SERVICE_HIST_KEY
Service History Dimension Surrogate Key
 
Populated from the B1_SERVICE_HIST_SEQ sequence.
Natural Keys
SRC_SERVICE_HIST_ID
Source Service History ID
W1_SVC_HIST.SVC_HIST_ID
 
Attributes
FAILURE_TYPE_CD
Failure Cause Code
W1_SVC_HIST.FAILURE_TYPE_CD
Populated only for failure service histories.
FAILURE_TYPE_DESCR
Failure Cause Description
W1_FAILURE_TYPE_L.DESCR100
Populated with the description of the Failure Type.
FAILURE_MODE_CD
Failure Mode Code
W1_SVC_HIST.FAILURE_MODE_CD
Populated only for failure service histories.
FAILURE_MODE_DESCR
Failure Mode Description
W1_FAILURE_MODE_L.DESCR100
Populated with the description of the Failure Mode Code.
FAILURE_REPAIR_CD
Failure Repair Code
W1_SVC_HIST. FAILURE_REPAIR_CD
Populated only for failure service histories.
FAILURE_ REPAIR_DESCR
Failure Repair Description
W1_FAILURE_REPAIR_L.DESCR100
Populated with the description of the Failure Repair Code.
FAILURE_ROOT_CAUSE
Failure Root Cause
W1_SVC_HIST.BO_DATA_AREA
Populated with the value for the failure root cause XML element from the CLOB column. It is populated only for failure service histories.
FAILURE_COMMENT
Failure Comment
W1_SVC_HIST.BO_DATA_AREA
Populated with the value for the comments XML element from the CLOB column. It is populated only for failure service histories.
FAILURE_COMP_CD
Failure Component Code
W1_SVC_HIST.FAILURE_COMP_CD
Populated only for the failure service histories.
FAILURE_COMP_DESCR
Failure Component Description
W1_FAILURE_COMP_L.DESCR100
Populated with the description of the Failure Component Code.
User Defined Attributes
UDF1_CD
User Defined Field 1 Code
 
 
UDF1_DESCR
User Defined Field 1 Description
 
 
UDF2_CD
User Defined Field 2 Code
 
 
UDF2_DESCR
User Defined Field 2 Description
 
 
UDF3_CD
User Defined Field 3 Code
 
 
UDF3_DESCR
User Defined Field 3 Description
 
 
UDF4_CD
User Defined Field 4 Code
 
 
UDF4_DESCR
User Defined Field 4 Description
 
 
UDF5_CD
User Defined Field 5 Code
 
 
UDF5_DESCR
User Defined Field 5 Description
 
 
UDF6_CD
User Defined Field 6 Code
 
 
UDF6_DESCR
User Defined Field 6 Description
 
 
UDF7_CD
User Defined Field 7 Code
 
 
UDF7_DESCR
User Defined Field 7 Description
 
 
UDF8_CD
User Defined Field 8 Code
 
 
UDF8_DESCR
User Defined Field 8 Description
 
 
UDF9_CD
User Defined Field 9 Code
 
 
UDF9_DESCR
User Defined Field 9 Description
 
 
UDF10_CD
User Defined Field 10 Code
 
 
UDF10_DESCR
User Defined Field 10 Description
 
 
UDF11_CD
User Defined Field 11 Code
 
 
UDF11_DESCR
User Defined Field 11 Description
 
 
UDF12_CD
User Defined Field 12 Code
 
 
UDF12_DESCR
User Defined Field 12 Description
 
 
UDF13_CD
User Defined Field 13 Code
 
 
UDF13_DESCR
User Defined Field 13 Description
 
 
UDF14_CD
User Defined Field 14 Code
 
 
UDF14_DESCR
User Defined Field 14 Description
 
 
UDF15_CD
User Defined Field 15 Code
 
 
UDF15_DESCR
User Defined Field 15 Description
 
 
UDF1_NUM
User Defined Field 1 Number
 
 
UDF2_NUM
User Defined Field 2 Number
 
 
UDF3_NUM
User Defined Field 3 Number
 
 
UDF4_NUM
User Defined Field 4 Number
 
 
UDF5_NUM
User Defined Field 5 Number
 
 
UDF6_NUM
User Defined Field 6 Number
 
 
UDF7_NUM
User Defined Field 7 Number
 
 
UDF8_NUM
User Defined Field 8 Number
 
 
UDF9_NUM
User Defined Field 9 Number
 
 
UDF10_NUM
User Defined Field 10 Number
 
 
UDF1_DATE
User Defined Field 1 Date
 
 
UDF2_DATE
User Defined Field 2 Date
 
 
UDF3_DATE
User Defined Field 3 Date
 
 
UDF4_DATE
User Defined Field 4 Date
 
 
UDF5_DATE
User Defined Field 5 Date
 
 
UDF6_DATE
User Defined Field 6 Date
 
 
UDF7_DATE
User Defined Field 7 Date
 
 
UDF8_DATE
User Defined Field 8 Date
 
 
UDF9_DATE
User Defined Field 9 Date
 
 
UDF10_DATE
User Defined Field 10 Date
 
 
FLEXFIELD1
Flex Field 1
 
 
FLEXFIELD2
Flex Field 2
 
 
FLEXFIELD3
Flex Field 3
 
 
FLEXFIELD4
Flex Field 4
 
 
FLEXFIELD5
Flex Field 5
 
 
FLEXFIELD6
Flex Field 6
 
 
FLEXFIELD7
Flex Field 7
 
 
FLEXFIELD8
Flex Field 8
 
 
FLEXFIELD9
Flex Field 9
 
 
FLEXFIELD10
Flex Field 10
 
 
Data Load Attributes
EFF_START_DTTM
Effective Start Date/Time
 
 
EFF_END_DTTM
Effective End Date/Time
 
 
DATA_LOAD_DTTM
Data Load Date/Time
 
Populated with the load timestamp value.
DATA_SOURCE_IND
Data Source Indicator
CI_INSTALLATION.ENV_ID
Populated with the DSI value on the source product instance configuration.
 
The table is populated as part of the initial setup and the DSI value is extracted from the environment ID of the source system.
JOB_NBR
Job Number
 
Populated with the ODI job execution session number.
 
Work Order
Stores all planned work orders from the source system.
Properties
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
Fields
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.
 
Work Order Activity
Includes the activities in the system with work role of planning allowed.
Properties
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
Fields
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.
 
Work Order Activity BO Status
Contains all combinations of BO/status/status reason that are applicable for instantiable business objects for Activity maintenance object.
Properties
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
Fields
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.
 
Work Order BO Status
Includes all combinations of BO/status/status reason that are applicable for instantiable business objects for Work Order maintenance object.
Properties
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
Fields
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.