Dimensions

This section lists all the dimension tables belonging to the Oracle Utilities Mobile Workforce Management star schemas only and are populated only from the Oracle Utilities Mobile Workforce Management source product.

Appointment Time

Stores the time ranges in minutes indicating whether the crew missed an appointment, and if so, by how much time.

Properties

Property	Value
Target Table	CD_APPT_TM
Table Type	Dimension
SCD Type	Type 1
Source System Driver Table	F1_BKT_CONFIG
Stage Table	STG_CD_APPT_TM
ODI Package	B1_PKG_CD_APPT_TM
ETL View	B1_D_APPT_VW

Fields

Target Field	Description	Source Field	Transformation Logic
Surrogate Key
APPT_TM_KEY	Appointment Time Dimension Surrogate Key		This field is populated from the OUBI_APPT_TM_SEQ sequence.
Natural Keys
START_RANGE	Appointment Time Start Range	F1_BKT_CONFIG_VAL.BKT_START_RANGE	This field is populated with the bucket start range based on the bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for appointment time.
END_RANGE	Appointment Time End Range	F1_BKT_CONFIG_VAL.BKT_END_RANGE	The field is populated with the bucket end range based on the bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for appointment time.
Attributes
APPT_TM_DESCR	Appointment Time Description	F1_BKT_CONFIG_VAL_L.DESCR
APPT_STATUS_DESCR	Appointment Status Description	CI_LOOKUP_VAL_L.DESCR_OVRD CI_LOOKUP_VAL_L.DESCR	This field is populated with the description from Lookup Language table for M1_APPT_STATUS_FLG lookup field. If override description is not available, regular description is extracted.
APPT_STATUS_CD	Appointment Status Code	F1_BKT_CONFIG_VAL.BKT_VAL_TYPE_CD
APPT_TM_CD	Appointment Time Code		Note: This field is obsolete and is not populated. The new bucket configurations based on the OUAF bucket configuration tables do not need this.
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.

Note: This bucket dimension is configured as one time load only. For information about data reload, see Reloading the Bucket Configuration section in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide.

Appointment Time of Day

Stores time ranges classifying an appointment time of day.

Properties

Property	Value
Target Table	CD_APPT_TM_OF_DAY
Table Type	Dimension
SCD Type	Type 1
Source System Driver Table	F1_BKT_CONFIG
Stage Table	STG_CD_APPT_TM_OF_DAY
ODI Package	B1_PKG_CD_APPT_TM_OF_DAY
ETL View	B1_D_APPT_OF_DAY_VW

Fields

Target Field	Description	Source Field	Transformation Logic
Surrogate Key
APPT_TM_OF_DAY_KEY	Appointment Time of Day Dimension Surrogate Key		This field is populated from the OUBI_APPT_TM_OF_DAY_SEQ sequence.
Natural Keys
START_RANGE	Appointment Time of Day Start Range	F1_BKT_CONFIG_VAL.BKT_START_RANGE	The field is populated with the bucket start range based on the bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for appointment time of day.
END_RANGE	Appointment Time of Day End Range	F1_BKT_CONFIG_VAL.BKT_END_RANGE	The field is populated with the bucket end range based on the bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for appointment time of day.
Attributes
APPT_TM_OF_DAY_DESCR	Appointment Time of Day Description	F1_BKT_CONFIG_VAL_L.DESCR
APPT_TM_OF_DAY_CD	Appointment Time Of Day Code		Note: This field is obsolete and is not populated. The new bucket configurations based on the OUAF bucket configuration tables do not need this.
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.

Note: This bucket dimension is configured as one time load only. For information about data reload, see the Reloading the Bucket Configuration section in Oracle Utilities Analytics Warehouse Installation and Configuration Guide.

Crew Shift

Includes the details of all crew shifts defined in the Oracle Utilities Extractors and Schema for Oracle Utilities Mobile Workforce Management system.

Properties

Property	Value
Target Table	CD_CREW_SHIFT
Table Type	Dimension
SCD Type	Type 2
Source System Driver Table	M1_CREW_SHFT F1_BUS_OBJ
Stage Table	STG_CD_CREW_SHIFT
ODI Package	B1_PKG_CD_CREW_SHIFT
ETL View	B1_D_CREW_SHIFT_VW

Fields

Target Field	Description	Source Field	Transformation Logic
Surrogate Key
CREW_SHIFT_KEY	Crew Shift Surrogate Key		This field is populated from the SPL_CREW_SHIFT_SEQ sequence.
Natural Keys
SRC_CREW_SHIFT_ID	Crew Shift ID	M1_CREW_SHFT.CREW_SHFT_ID
Attributes
CREW_SHIFT_TYPE_DESCR	Crew Shift Type Description	M1_CREW_SHFT_TYPE_L.DESCR
PRIMARY_FN_DESCR	Primary Function Description	M1_SVC_CLS_L.DESCR
CREW_SHIFT_INFO	Crew Shift Description	M1_RESRC_ID.RESRC_ID_VAL M1_CREW_SHFT_TYPE_L.DESCR M1_CREW_SHFT.PLAN_START_DTTM M1_CREW_SHFT.PLAN_END_DTTM F1_BUS_OBJ_STATUS_L.DESCR	This field is a concatenation of crew name, crew shift type, planned start date, planned end date, and shift status.
CREW_SHIFT_TYPE_CD	Crew Shift Type Code	M1_CREW_SHFT.CREW_SHFT_TYPE_CD
PRIMARY_FN_CD	Primary Function Code	M1_CREW_SHFT_SVC_CLS.SVC_CLS_CD	This field is populated from the Crew Shift Service Class table based on the usage flag (set as 'Primary') associated with the current shift ID.
User Defined Attributes
UDF1_CD	Shift Type
UDF1_DESCR	Shift Type Code
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 7Code
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
EFF_END_DTTM	Effective End Date/Time
EFF_START_DTTM	Effective Start 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.

Crew Time Usage

Holds all valid values for crew time usages based on the tasks carried out by crews. The crew time usages are further classified as productive or non productive.

Properties

Property	Value
Target Table	CD_CREW_TM_USG
Table Type	Dimension
SCD Type	Type 1
Source System Driver Table	F1_EXT_LOOKUP_VAL
Stage Table	STG_CD_CREW_TM_USG
ODI Package	B1_PKG_CD_CREW_TM_USG
ETL View	B1_D_CREW_TM_USG_VW

Fields

Target Field	Description	Source Field	Transformation Logic
Surrogate Key
CREW_TM_USG_KEY	Crew Time Usage Dimension Surrogate Key		This field is populated from the OUBI_CREW_TM_USG_SEQ sequence.
Natural Keys
CREW_TM_USG_CD	Crew Time Usage Code	F1_EXT_LOOKUP_VAL.F1_EXT_LOOKUP_VALUE	This field extracts the records defined only for the M1-CrewTimeUsageLookup lookup business object.
Attributes
CREW_TM_USG_DESCR	Crew Time Usage Description	F1_EXT_LOOKUP_VAL_L.DESCR_OVRD F1_EXT_LOOKUP_VAL_L.DESCR	If override description is not available, regular description is extracted.
PRODUCTIVITY_DESCR	Productivity 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 M1_CREW_TM_USG_CLS_FLG lookup field. If override description is not available, regular description is extracted.
PRODUCTIVITY_CD	Productivity Code	F1_EXT_LOOKUP_VAL.BO_DATA_AREA	This field is populated with the productivity code from the CLOB column.
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 7Code
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/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.

Early Logoff Time

Stores the time ranges (in minutes) indicating by how much time the crew is logging off the shift earlier than planned.

Properties

Property	Value
Target Table	CD_EARLY_LOGOFF_TM
Table Type	Dimension
SCD Type	Type 1
Source System Driver Table	F1_BKT_CONFIG
Stage Table	STG_CD_EARLY_LOGOFF_TM
ODI Package	B1_PKG_CD_EARLY_LOGOFF_TM
ETL View	B1_D_EARLY_LOGOFF_TM_VW

Fields

Target Field	Description	Source Field	Transformation Logic
Surrogate Key
EARLY_LOGOFF_TM_ KEY	Early Logoff Time Dimension Surrogate Key		This field is populated from the OUBI_EARLY_LOGOFF_TM_SEQ sequence.
Natural Keys
START_RANGE	Early Logoff Time Start Range	F1_BKT_CONFIG_VAL.BKT_START_RANGE	The field is populated with the bucket start range based on bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for early logoff time.
END_RANGE	Early Logoff Time End Ran	F1_BKT_CONFIG_VAL.BKT_END_RANGE	The field is populated with the bucket end range based on bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for early log off time.
Attributes
EARLY_LOGOFF_TM_ DESCR	Early Logoff Time Description	F1_BKT_CONFIG_VAL_L.DESCR
CONSIDERED_ONTIME_CD	Considered On Time Code	F1_BKT_CONFIG_VAL.BKT_VAL_TYPE_CD
CONSIDERED_ONTIME_DESCR	Considered On Time 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 M1_CONSD_ON_TIME_FLG lookup field. If override description is not available, regular description is extracted.
EARLY_LOGOFF_TM_ CD	Early Logoff Time Code		Note: This field is obsolete and is not be populated. The new bucket configurations based on the OUAF bucket configuration tables do not need this.
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 7Code
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/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.

Late Logon Time

Stores the time ranges (in minutes) indicating by how much time the crew is late to logon for their shift.

Properties

Property	Value
Target Table	CD_LATE_LOGON_TM
Table Type	Dimension
SCD Type	Type 1
Source System Driver Table	F1_BKT_CONFIG
Stage Table	STG_CD_LATE_LOGON_TM
ODI Package	B1_PKG_CD_LATE_LOGON_TM
ETL View	B1_D_LATE_LOGON_TM_VW

Fields

Target Field	Description	Source Field	Transformation Logic
Surrogate Key
LATE_LOGON_TM_KEY	Late Logon Time Dimension Surrogate Key		This field is populated from the OUBI_LATE_LOGON_TM_SEQ sequence.
Natural Keys
START_RANGE	Late Logon Time Start Range	F1_BKT_CONFIG_VAL.BKT_START_RANGE	The field is populated with the bucket start range based on bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for late logon time.
END_RANGE	Late Logon Time End Range	F1_BKT_CONFIG_VAL.BKT_END_RANGE	The field is populated with the bucket end range based on bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for late logon time.
Attributes
LATE_LOGON_TM_DESCR	Late Logon Time Description	F1_BKT_CONFIG_VAL_L.DESCR
CONSIDERED_ONTIME_CD	Considered On Time Code	F1_BKT_CONFIG_VAL.BKT_VAL_TYPE_CD
CONSIDERED_ONTIME_DESCR	Considered On Time 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 M1_CONSD_ON_TIME_FLG lookup field. If override description is not available, regular description is extracted.
LATE_LOGON_TM_CD	Late Logon Time Code		Note: This field is obsolete now and is not populated. The new bucket configurations based on the OUAF bucket configuration tables do not need this.
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 7Code
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/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.

Response Time Deviation

Stores the configurable ranges (in minutes) for the deviations in the response time of crews against the SLAs defined for various activities. It has an indicator to tell if the SLA is met or missed.

Properties

Property	Value
Target Table	CD_RESP_TM_DEV
Table Type	Dimension
SCD Type	Type 1
Source System Driver Table	F1_BKT_CONFIG
Stage Table	STG_CD_RESP_TM_DEV
ODI Package	B1_PKG_CD_RESP_TM_DEV
ETL View	B1_D_RESP_TM_DEV_VW

Fields

Target Field	Description	Source Field	Transformation Logic
Surrogate Key
RESP_TM_DEV_KEY	Response Time Deviation Dimension Surrogate Key		This field is populated from the OUBI_RESP_TM_DEV_SEQ sequence.
Natural Keys
START_RANGE	Response Time Deviation Start Range	F1_BKT_CONFIG_VAL.BKT_START_RANGE	The field is populated with the bucket start range based on bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for response time deviation.
END_RANGE	Response Time Deviation End Range	F1_BKT_CONFIG_VAL.BKT_END_RANGE	The field is populated with the bucket end range based on bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for response time deviation.
Attributes
RESP_TM_DEV_DESCR	Response Time Deviation Description	F1_BKT_CONFIG_VAL_L.DESCR
SLA_STATUS_DESCR	SLA Status 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 M1_SLA_STATUS_FLG lookup field. If override description is not available, regular description is extracted.
SLA_STATUS_CD	SLA Status Code	F1_BKT_CONFIG_VAL.BKT_VAL_TYPE_CD
RESP_TM_DEV_CD	Response Time Deviation Code		Note: This field is obsolete and is not populated. The new bucket configurations based on the OUAF bucket configuration tables do not need this.
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 7Code
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/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.

Shift BO Status

Holds valid combination of status and reason for shifts.

Properties

Property	Value
Target Table	CD_SHIFT_BO_STATUS
Table Type	Dimension
SCD Type	Type 1
Source System Driver Table	F1_BUS_OBJ F1_BUS_OBJ_STATUS_RSN
Stage Table	STG_CD_SHIFT_BO_STATUS
ODI Package	B1_PKG_CD_SHIFT_BO_STATUS
ETL View	B1_D_SHIFT_BO_STATUS_VW

Fields

Target Field	Description	Source Field	Transformation Logic
Surrogate Key
SHIFT_BO_STATUS_KEY	Shift BO Status Surrogate Key		This field is populated from the OUBI_SHIFT_BO_STAT_SEQ sequence.
Natural Keys
BUS_OBJ_CD	Business Object	F1_BUS_OBJ.BUS_OBJ_CD	This field extracts all business objects of the Crew Shift maintenance object only.
STATUS_CD	BO Status Code	F1_BUS_OBJ_STATUS.BO_STATUS_CD
REASON_CD	Status Reason Code	F1_BUS_OBJ_STATUS_RSN.BO_STATUS_REASON_CD
Attributes
BUS_OBJ_DESCR	Business Object Description	F1_BUS_OBJ_L.DESCR
STATUS_DESCR	Status Description	F1_BUS_OBJ_STATUS_L.DESCR
STATUS_COND_CD	Status Condition Code	F1_BUS_OBJ_STATUS.BO_STATUS_COND_FLG
STATUS_COND_DESCR	Status Condition Description	CI_LOOKUP_VAL_L.NVL(CI_LOOKUP_VAL_L.DESCR_OVRD,CI_LOOKUP_VAL_L.DESCR)	This field is populated with description from the Lookup Language table for the BO_STATUS_COND_FLG lookup field. If override description is not available, regular description is extracted.
REASON_DESCR	Status Reason Description	F1_BUS_OBJ_STATUS_RSN_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 7Code
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/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.

Task BO Status

Holds all valid combination of status and reasons for schedulable tasks.

Properties

Property	Value
Target Table	CD_TASK_BO_STATUS
Table Type	Dimension
SCD Type	Type 1
Source System Driver Table	F1_BUS_OBJ F1_BUS_OBJ_STATUS_RSN
Stage Table	STG_CD_TASK_BO_STATUS
ODI Package	B1_PKG_CD_TASK_BO_STATUS
ETL View	B1_D_TASK_BO_STATUS_VW

Fields

Target Field	Description	Source Field	Transformation Logic
Surrogate Key
TASK_BO_STATUS_KEY	Task BO Status Surrogate Key		This field is populated from the OUBI_TASK_BO_STAT_SEQ sequence.
Natural Keys
BUS_OBJ_CD	Business Object	F1_BUS_OBJ.BUS_OBJ_CD	This field extracts all business objects of the Device Event maintenance object only.
STATUS_CD	BO Status Code	F1_BUS_OBJ_STATUS.BO_STATUS_CD
REASON_CD	Status Reason Code	F1_BUS_OBJ_STATUS_RSN.BO_STATUS_REASON_CD
Attributes
BUS_OBJ_DESCR	Business Object Description	F1_BUS_OBJ_L.DESCR
STATUS_DESCR	Status Description	F1_BUS_OBJ_STATUS_L.DESCR
STATUS_COND_CD	Status Condition Code	F1_BUS_OBJ_STATUS.BO_STATUS_COND_FLG
STATUS_COND_DESCR	Status Condition Description	CI_LOOKUP_VAL_L.NVL(CI_LOOKUP_VAL_L.DESCR_OVRD,CI_LOOKUP_VAL_L.DESCR)	This field is populated with description from the Lookup Language table for the BO_STATUS_COND_FLG lookup field. If override description is not available, regular description is extracted.
REASON_DESCR	Status Reason Description	F1_BUS_OBJ_STATUS_RSN_L.DESCR
INCOMPLETE_IND	Incomplete Indicator	F1_BUS_OBJ_STATUS_OPT.BO_OPT_VAL	This field is populated based on the state condition defined on the business object status. If the status is ‘Postponed’, or ‘Completed’ with ‘Incomplete’ status reason, the indicator is populated as ‘1’, else ‘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 7Code
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/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.

Task Type

Holds all task types defined in the Oracle Utilities Extractors and Schema for Oracle Utilities Mobile Workforce Management system along with their class, priority, service type, and SLA details.

Properties

Property	Value
Target Table	CD_TASK_TYPE
Table Type	Dimension
SCD Type	Type 1
Source System Driver Table	M1_TASK_TYPE
Stage Table	STG_CD_TASK_TYPE
ODI Package	B1_PKG_CD_TASK_TYPE
ETL View	B1_D_TASK_TYPE_VW

Fields

Target Field	Description	Source Field	Transformation Logic
Surrogate Key
TASK_TYPE_KEY	Task Type Dimension Surrogate Key		This field is populated from the OUBI_TASK_TYPE_SEQ sequence.
Natural Keys
TASK_TYPE_CD	Activity Type Code	M1_TASK_TYPE.TASK_TYPE_CD
Attributes
TASK_TYPE_DESCR	Task Type Description	M1_TASK_TYPE_L.DESCR
TASK_CLASS_CD	Task Class Code	M1_TASK_TYPE.TASK_CLS_FLG
PRIORITY_PROF_CD	Priority Profile Code	M1_TASK_TYPE.PRI_PROF_CD
SVC_CATEGORY_CD	Service Category Code	M1_TASK_TYPE.BO_DATA_AREA	This field is populated with the service category code from the CLOB column.
TASK_CLASS_DESCR	Task Class 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 TASK_CLS_FLG lookup field. If override description is not available, regular description is extracted.
PRIORITY_PROF_DESCR	Priority Profile Description	M1_PRI_PROF_L.DESCR
SVC_CATEGORY_DESCR	Service Category Description	F1_EXT_LOOKUP_VAL_L.DESCR_OVRD F1_EXT_LOOKUP_VAL_L.DESCR	This field is populated with description from the Lookup Language table for the M1-ServiceCategoryLookup lookup business object. If override description is not available, regular description is extracted.
RESP_TM_SLA	Response Time SLA	M1_TASK_TYPE.BO_DATA_AREA	This field is populated with the response time SLA from the CLOB column.
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 7Code
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/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.

Travel Distance Deviation

Stores the percentage ranges for deviations of actual distance relative to estimated distance traveled by the crew.

Properties

Property	Value
Target Table	CD_TRAVEL_DIST_DEV
Table Type	Dimension
SCD Type	Type 1
Source System Driver Table	F1_BKT_CONFIG
Stage Table	STG_CD_TRAVEL_DIST_DEV
ODI Package	B1_PKG_CD_TRAVEL_DIST_DEV
ETL View	B1_D_TRAVEL_DIST_DEV_VW

Fields

Target Field	Description	Source Field	Transformation Logic
Surrogate Key
TRAVEL_DIST_DEV_ KEY	Travel Distance Deviation Dimension Surrogate Key		This field is populated from the OUBI_TRAVEL_DIST_DEV_SEQ sequence.
Natural Keys
START_RANGE	Travel Distance Deviation Start Range	F1_BKT_CONFIG_VAL.BKT_START_RANGE	This field is populated with the bucket start range based on bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for travel distance deviation.
END_RANGE	Travel Distance Deviation End Range	F1_BKT_CONFIG_VAL.BKT_END_RANGE	This field is populated with the bucket end range based on bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for travel distance deviation.
Attributes
TRAVEL_DIST_DEV_ DESCR	Travel Distance Deviation Description	F1_BKT_CONFIG_VAL_L.DESCR
TRAVEL_DIST_DEV_CD	Distance Deviation Code		Note: This field is obsolete and is not populated. The new bucket configurations based on the OUAF bucket configuration tables do not need this.
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 7Code
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/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.

Travel Duration Deviation

Stores the percentage ranges for deviations of actual travel duration relative to estimated travel duration of crews.

Properties

Property	Value
Target Table	CD_TRAVEL_DUR_DEV
Table Type	Dimension
SCD Type	Type 1
Source System Driver Table	F1_BKT_CONFIG
Stage Table	STG_CD_TRAVEL_DUR_DEV
ODI Package	B1_PKG_CD_TRAVEL_DUR_DEV
ETL View	B1_D_TRAVEL_DUR_DEV_VW

Fields

Target Field	Description	Source Field	Transformation Logic
Surrogate Key
TRAVEL_DUR_DEV_ KEY	Travel Duration Deviation Dimension Surrogate Key		This field is populated from the OUBI_TRAVEL_DUR_DEV_SEQ sequence.
Natural Keys
START_RANGE	Travel Duration Deviation Start Range	F1_BKT_CONFIG_VAL.BKT_START_RANGE	This field is populated with the bucket start range based on bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for travel duration deviation.
END_RANGE	Travel Duration Deviation End Range	F1_BKT_CONFIG_VAL.BKT_END_RANGE	The field is populated with the bucket end range based on bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for travel duration deviation.
Attributes
TRAVEL_DUR_DEV_ DESCR	Travel Duration Deviation	F1_BKT_CONFIG_VAL_L.DESCR
TRAVEL_DUR_DEV_CD	Travel Duration Deviation Code		Note: This field is obsolete and will not be populated. The new bucket configurations based on the OUAF bucket configuration tables do not need this.
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 7Code
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/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.

Note: This bucket dimension is configured as one time load only. For information about data reload, see the Reloading the Bucket Configuration section in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide.

Work Duration Deviation

Stores the percentage ranges for deviations in actual work duration relative to estimated work duration of activities.

Properties

Property	Value
Target Table	CD_WORK_DUR_DEV
Table Type	Dimension
SCD Type	Type 1
Source System Driver Table	F1_BKT_CONFIG
Stage Table	STG_CD_WORK_DUR_DEV
ODI Package	B1_PKG_CD_WORK_DUR_DEV
ETL View	B1_D_WORK_DUR_DEV_VW

Fields

Target Field	Description	Source Field	Transformation Logic
Surrogate Key
WORK_DUR_DEV_KEY	Work Duration Deviation Dimension Surrogate Key		This field is populated from the OUBI_WORK_DUR_DEV_SEQ sequence.
Natural Keys
START_RANGE	Work Duration Deviation Start Range	F1_BKT_CONFIG_VAL.BKT_START_RANGE	This field is populated with the bucket start range based on bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for work duration deviation.
END_RANGE	Work Duration Deviation End Range	F1_BKT_CONFIG_VAL.BKT_END_RANGE	The field is populated with the bucket end range based on bucket configuration code. The bucket configuration code from the Bucket Configuration table is retrieved based on the bucket configuration BO defined for work duration deviation.
Attributes
WORK_DUR_DEV_ DESCR	Work Duration Deviation Description	F1_BKT_CONFIG_VAL_L.DESCR
WORK_DUR_DEV_CD	Work Duration Deviation Code		Note: This field is obsolete and is not populated. The new bucket configurations based on the OUAF bucket configuration tables do not need this.
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 7Code
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/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.