Dimensions
This section lists all the dimension tables that belong to the Oracle Utilities Meter Data Management star schemas only and are populated only from the Oracle Utilities Meter Data Management source product.
Consumption Snapshot Type Dimension
The Consumption Snapshot Type dimension defines the granularity of aggregated consumptions of a service point. It stores the values from the Oracle Utilities Meter Data Management lookup for Consumption Snapshot Type.
Properties
Property
Value
Target Table
CD_CONS_TYPE
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
F1_EXT_LOOKUP_VAL_L
Stage Table
STG_CD_CONS_TYPE
ODI Package
B1_PKG_CD_CONS_TYPE
ETL View
B1_D_CONS_TYPE _VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
CONS_TYPE_KEY
Consumption Snapshot Type Key
 
This field is populated from the OUBI_CONS_TYPE_SEQ sequence.
Natural Keys
CONS_SNAPSHOT_TYPE_CD
Consumption Snapshot Type Code
F1_EXT_LOOKUP_VAL_L.F1_EXT_LOOKUP_VALUE
This field is populated with values defined for the D2-ConsumptionSnapshotTypeLkup lookup business object.
Attributes
CONS_SNAPSHOT_TYPE_DESCR
Usage Snapshot Type
F1_EXT_LOOKUP_VAL_L.DESCR_OVRD
 
F1_EXT_LOOKUP_VAL_L.DESCR
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
 
 
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.
 
Contact Dimension
The Contact dimension includes a record for every contact in the Oracle Utilities Meter Data Management system.
Properties
Property
Value
Target Table
CD_CONTACT
Table Type
Dimension
SCD Type
Type 2
Source System Driver Table
D1_CONTACT
Stage Table
STG_CD_CONTACT
ODI Package
B1_PKG_CD_CONTACT
ETL View
B1_D_CONTACT_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
CONTACT_KEY
Contact Dimension Surrogate Key
 
This field is populated from the OUBI_CONTACT_SEQ sequence.
Natural Keys
SRC_CONTACT_ID
Contact ID
D1_CONTACT.
CONTACT_ID
 
Attributes
CONTACT_INFO
Customer
D1_CONTACT_NAME.
NAME_VALUE
 
D1_CONTACT_PHONE. PHONE_VALUE
This field is a concatenation of contact’s primary name and home/business phone information.
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
EFF_START_DTTM
Effective Start Date/Time
 
 
EFF_END_DTTM
Effective End Date/Time
 
 
DATA_LOAD_DTTM
Data Load Date/Time
 
This field is populated with the load timestamp value.
DATA_SOURCE_IND
Data Source Indicator
CI_INSTALLATION.ENV_ID
This field is populated with the DSI value on the source product instance configuration. The table is populated as part of the initial setup and the DSI value is extracted from the environment ID of the source system.
JOB_NBR
Job Number
 
This field is populated with the ODI job execution session number.
Days Since Last Normal Measurement Dimension
The Days Since Last Normal Measurement dimension defines the age ranges for days since the last normal measurement was received. There is a record on the dimension for every Days Since Last Normal Measurement bucket defined in the Oracle Utilities Meter Data Management system.
Properties
Property
Value
Target Table
CD_DAYS_LAST_MSRMT
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
F1_EXT_LOOKUP_VAL_L
Stage Table
STG_CD_DAYS_LAST_MSRMT
ODI Package
B1_PKG_CD_DAYS_LAST_MSRMT
ETL View
B1_D_DAYS_LAST_MSRMT_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
DAYS_LAST_MSRMT_
KEY
Days Since Last Normal Measurement Dimension Surrogate Key
 
This field is populated from the OUBI_DAYS_LAST_MSRMT_SEQ sequence.
Natural Keys
DAY_LAST_MSRMT_CD
Days Since Last Normal Measurement Code
F1_EXT_LOOKUP_VAL_L.F1_EXT_LOOKUP_VALUE
This field is populated with values defined for the D1-DaysSinceLastNormalMsrmtLkp lookup business object.
Attributes
DAY_LAST_MSRMT_
DESCR
Days Since Last Normal Measurement
F1_EXT_LOOKUP_VAL_L.DESCR_OVRD
 
F1_EXT_LOOKUP_VAL_L.DESCR
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
 
 
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.
 
Days Since Last Usage Transaction Type Dimension
The Days Since Last Usage Transaction Type dimension defines the bucket definitions for the number of days since the last usage transaction was sent for the service point.
Properties
Property
Value
Target Table
CD_DAYS_LASTUT_TYPE
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
F1_EXT_LOOKUP_VAL_L
Stage Table
STG_CD_DAYS_LASTUT_TYPE
ODI Package
B1_PKG_CD_DAYS_LASTUT_TYPE
ETL View
B1_D_DAYS_LASTUT_TYPE_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
DAYS_LASTUT_TYPE_
KEY
Days Since Last UT Type Dimension Surrogate Key
 
This field is populated from the OUBI_DAYS_LASTUT_TYPE_SEQ sequence.
Natural Keys
DAYS_LASTUT_TYPE_
CD
Days Since Last UT Type Code
F1_EXT_LOOKUP_VAL_L.F1_EXT_LOOKUP_VALUE
This field is populated with values defined for the D2-DaysSinceLastUTLookup lookup business object.
Attributes
DAYS_LASTUT_TYPE_
DESCR
Days Since Last UT Type
F1_EXT_LOOKUP_VAL_L.DESCR_OVRD
 
F1_EXT_LOOKUP_VAL_L.DESCR
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
 
 
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.
 
Meter Device Dimension
The Meter Device dimension stores the details of all the devices in the Oracle Utilities Meter Data Management system.
Properties
Property
Value
Target Table
CD_MTR_DEVICE
Table Type
Dimension
SCD Type
Type 2
Source System Driver Table
D1_DVC
Stage Table
STG_CD_MTR_DEVICE
ODI Package
B1_PKG_CD_MTR_DEVICE
ETL View
B1_D_MTR_DEVICE _VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
MTR_DEVICE_KEY
Meter Device Surrogate Key
 
This field is populated from the OUBI_MTR_DEVICE_SEQ sequence.
Natural Keys
SRC_MTR_DEVICE_ID
Device ID
D1_DVC.D1_DEVICE_ID
 
Attributes
MTR_DEVICE_TYPE_CD
Device Type Code
D1_DVC.DEVICE_TYPE_CD
 
MANUFACTURER_CD
Manufacturer Code
D1_DVC.MANUFACTURER_CD
 
MODEL_CD
Model Code
D1_DVC.D1_MODEL_CD
 
HEAD_END_CD
Head End System Code
D1_DVC.D1_SPR_CD
 
D1_DVC.D1_DVC_TYPE
 
D1_DVC.D1_SPR_CD
This field is populated with the override service provider stored on the device. If not found, it is populated with the fallback service provider on the device type.
DEVICE_CAT_CD
Device Category Code
F1_BUS_OBJ_OPT.BUS_OBJ_OPT_VAL
This field is populated with the device’s category defined on the business object’s option.
MTR_DEVICE_INFO
Device Information
 
This field is a concatenation of device comprising the device identifier, device type description, installation information, service provider, and device status.
MTR_DEVICE_TYPE_
DESCR
Device Type Description
D1_DVC_TYPE_L.DESCR100
 
MANUFACTURER_
DESCR
Manufacturer Description
D1_MANUFACTURER_L.DESCR100
 
MODEL_DESCR
Model Description
D1_MODEL_L.DESCR100
 
HEAD_END_DESCR
Head End System Description
D1_SPR_L.DESCR100
 
DEVICE_CAT_DESCR
Device Category Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
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
 
 
Data Load Attributes
EFF_START_DTTM
Effective Start Date/Time
 
 
EFF_ END_DTTM
Effective End Date/Time
 
 
DATA_LOAD_DTTM
Data Load Date/Time
 
This field is populated with the load timestamp value.
DATA_SOURCE_IND
Data Source Indicator
CI_INSTALLATION.ENV_ID
This field is populated with the DSI value on the source product instance configuration. The table is populated as part of the initial setup and the DSI value is extracted from the environment ID of the source system.
JOB_NBR
Job Number
 
This field is populated with the ODI job execution session number.
 
Device Event BO Status Dimension
The Device Event BO Status dimension stores the device event statuses for various device event business objects in the Oracle Utilities Meter Data Management system.
Properties
Property
Value
Target Table
CD_DEVICE_EVT_STATUS
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
F1_BUS_OBJ
F1_BUS_OBJ_STATUS_RSN
Stage Table
STG_CD_DEVICE_EVT_STATUS
ODI Package
B1_PKG_CD_DEVICE_EVT_STATUS
ETL View
B1_D_DEVICE_EVT_STATUS _VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
DEVICE_EVT_STATUS_KEY
Device Event Status Dimension Surrogate Key
 
This field is populated from the OUBI_DEVICE_EVT_STATUS_SEQ sequence.
Natural Keys
BUS_OBJ_CD
Business Object Code
F1_BUS_OBJ.BUS_OBJ_CD
All business objects of the device event maintenance object only are extracted.
STATUS_CD
Status Code
F1_BUS_OBJ_STATUS.BO_STATUS_CD
 
STATUS_RSN_CD
Status Reason Code
F1_BUS_OBJ_STATUS_RSN.BO_STATUS_REASON_CD
 
Attributes
STATUS_COND_CD
Status Condition Code
F1_BUS_OBJ_STATUS.BO_STATUS_COND_FLG
 
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
 
STATUS_COND_DESCR
Status Condition Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the status condition description from the Lookup Language table for the lookup field BO_STATUS_COND_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
 
 
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.
 
Device Activity Type Dimension
The Device Activity Type dimension table includes a record for every activity type in the Oracle Utilities Meter Data Management system.
Properties
Property
Value
Target Table
CD_DEVICE_ACTIVITY_TYPE
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
D1_ACTIVITY_TYPE
Stage Table
STG_CD_DEVICE_ACTIVITY_TYPE
ODI Package
B1_PKG_CD_DEVICE_ACTIVITY_TYPE
ETL View
B1_D_DEVICE_ACTIVITY_TYPE_VW
 
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
DEVICE_ACTIVITY_
TYPE_KEY
Device Activity Type Dimension Surrogate Key
 
This field is populated from the OUBI_DEVICE_ACTIVITY_TYPE_SEQ sequence.
Natural Keys
DEVICE_ACTIVITY_
TYPE_CD
Activity Type Code
D1_ACTIVITY_TYPE.ACTIVITY_TYPE_CD
 
Attributes
DEVICE_ACTIVITY_
TYPE_INFO
Activity Type Information
D1_ACTIVITY_TYPE_L.DESCR100
 
DEVICE_ACTIVITY_CAT_CD
Activity Category Code
D1_ACTIVITY_TYPE.ACTIVITY_TYPE_CAT_
FLG
 
EXT_DEVIC_ACT_TYPE_CD
External Device Activity Type Code
D1_ACTIVITY_TYPE.EXT_ACTIVITY_TYPE_
FLG
 
DEVICE_ACTIVITY_CAT_DESCR
Activity Category Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the description from the Lookup Language table for ACTIVITY_TYPE_CAT_FLG lookup field.
 
If override description is not available, regular description is extracted.
EXT_DEVIC_ACT_TYPE_DESCR
External Device Activity Type Description
F1_EXT_LOOKUP_VAL_L.DESCR_OVRD
 
F1_EXT_LOOKUP_VAL_L.DESCR
This field is populated with the description from the Lookup Language table for the D1-ExternalActTypeIdentifier lookup business object.
 
If an override description is available, it will be extracted else the normal description will be extracted.
User Defined Attributes
UDF1_CD
User Defined Field 1 Code
 
 
UDF1_DESCR
User Defined Field 1 Description
 
 
UDF2_CD
User Defined Field 2 Code
 
 
UDF2_DESCR
User Defined Field 2 Description
 
 
UDF3_CD
User Defined Field 3 Code
 
 
UDF3_DESCR
User Defined Field 3 Description
 
 
UDF4_CD
User Defined Field 4 Code
 
 
UDF4_DESCR
User Defined Field 4 Description
 
 
UDF5_CD
User Defined Field 5 Code
 
 
UDF5_DESCR
User Defined Field 5 Description
 
 
UDF6_CD
User Defined Field 6 Code
 
 
UDF6_DESCR
User Defined Field 6 Description
 
 
UDF7_CD
User Defined Field 7 Code
 
 
UDF7_DESCR
User Defined Field 7 Description
 
 
UDF8_CD
User Defined Field 8 Code
 
 
UDF8_DESCR
User Defined Field 8 Description
 
 
UDF9_CD
User Defined Field 9 Code
 
 
UDF9_DESCR
User Defined Field 9 Description
 
 
UDF10_CD
User Defined Field 10 Code
 
 
UDF10_DESCR
User Defined Field 10 Description
 
 
Data Load Attributes
UPDATE_DTTM
Update Date and Time
 
 
DATA_LOAD_DTTM
Data Load Date/Time
 
This field is populated with the load timestamp value.
DATA_SOURCE_IND
Data Source Indicator
CI_INSTALLATION.ENV_ID
This field is populated with the DSI value on the source product instance configuration. The table is populated as part of the initial setup and the DSI value is extracted from the environment ID of the source system.
JOB_NBR
Job Number
 
This field is populated with the ODI job execution session number.
 
Device Activity BO Status Dimension
The Device Activity BO Status dimension holds all business objects defined for activities and their statuses, along with the status reasons for each of them.
Properties
Property
Value
Target Table
CD_DEVICE_ACTIVITY_STATUS
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
F1_BUS_OBJ
F1_BUS_OBJ_STATUS_RSN
Stage Table
STG_CD_DEVICE_ACTIVITY_STATUS
ODI Package
B1_PKG_CD_DEVICE_ACTIVITY_STATUS
ETL View
B1_D_DEVICE_ACTIVITY_STATUS_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
DEVICE_ACTIVITY_
STATUS_KEY
Device Activity Status Dimension Surrogate Key
 
This field is populated from the OUBI_DEV_ACT_STATUS_SEQ sequence.
Natural Keys
BUS_OBJ_CD
Business Object Code
F1_BUS_OBJ.BUS_OBJ_
CD
All business objects of the Activity maintenance object only are extracted.
STATUS_CD
Status Code
F1_BUS_OBJ_STATUS.
BO_STATUS_CD
 
STATUS_RSN_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_COND_CD
Status Condition Code
F1_BUS_OBJ_STATUS.
BO_STATUS_COND_
FLG
 
STATUS_DESCR
Status Description
F1_BUS_OBJ_STATUS_L.DESCR
 
STATUS_RSN_DESCR
Status Reason Description
F1_BUS_OBJ_STATUS_
RSN_L.DESCR
 
STATUS_COND_DESCR
Status Condition Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the status condition description from the Lookup Language table for the BO_STATUS_COND_FLG lookup field.
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.
 
Device Event Type Dimension
The Device Event Type dimension stores a record for every device event type in the Oracle Utilities Meter Data Management system.
Properties
Property
Value
Target Table
CD_DEVICE_EVT_TYPE
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
D1_DVC_EVT_TYPE
Stage Table
STG_CD_DEVICE_EVT_TYPE
ODI Package
B1_PKG_CD_DEVICE_EVT_TYPE
ETL View
B1_D_DEVICE_EVT_TYPE _VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
DEVICE_EVT_TYPE_
KEY
Device Event Type Dimension Surrogate Key
 
This field is populated from the OUBI_DEVICE_EVT_TYPE_SEQ sequence.
Natural Keys
DEVICE_EVT_TYPE_CD
Event Type Code
D1_DVC_EVT_TYPE.DVC_EVT_TYPE_CD
 
Attributes
DEVICE_EVT_CAT_CD
Event Category Code
D1_DVC_EVT_TYPE.DVC_EVT_CAT_FLG
 
RPT_CAT_CD
Reporting Category Code
D1_DVC_EVT_TYPE.D1_REPORTING_CAT_FLG
 
STD_ACT_TYPE_CD
Standard Activity Type Code
D1_DVC_EVT_TYPE.STD_EVT_NAME_FLG
 
DEVICE_EVT_TYPE_
INFO
Event Type Information
D1_DVC_EVT_TYPE_L.DESCR100
 
DEVICE_EVT_CAT_
DESCR
Event Category Description
F1_EXT_LOOKUP_VAL_L.DESCR_OVRD
 
F1_EXT_LOOKUP_VAL_L.DESCR
This field is populated with the description from Lookup Language table for the D1-DvcEventCategoryLookup lookup business object.
 
If override description is not available, regular description is extracted.
RPT_CAT_DESCR
Reporting Category Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the description from the Lookup Language table for D1_REPORTING_CAT_FLG lookup field.
 
If override description is not available, regular description is extracted.
STD_ACT_TYPE_DESCR
Standard Activity Type Description
F1_EXT_LOOKUP_VAL_L.DESCR_OVRD
 
F1_EXT_LOOKUP_VAL_L.DESCR
This field is populated with the description from the Lookup Language table for the D1-StdEventNameLookup lookup business object.
 
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
 
 
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.
 
Exception Severity Dimension
The Exception Severity dimension holds the severity levels for exceptions that arise during the VEE processing of raw measurement data.
Properties
Property
Value
Target Table
CD_EXCP_SEV
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
CI_LOOKUP_VAL_L
Stage Table
STG_CD_EXCP_SEV
ODI Package
B1_PKG_CD_EXCP_SEV
ETL View
B1_D_EXCP_SEV _VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
EXCP_SEV_KEY
Exception Severity Dimension Surrogate Key
 
This field is populated from the OUBI_EXCP_SEV_SEQ sequence.
Natural Keys
EXCP_SEV_CD
Exception Severity Code
CI_LOOKUP_VAL_L.FIELD_VALUE
This field is populated with values defined for the EXCP_SEVERITY_FLG lookup field.
Attributes
EXCP_SEV_DESCR
Exception Severity Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the description from Lookup Language table.
 
If override description is not available, regular description is extracted.
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.
Exception Type Dimension
The Exception Type dimension holds the exception types for the exceptions that arise during the VEE processing of the raw measurement data.
Properties
Property
Value
Target Table
CD_EXCP_TYPE
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
D1_EXCP_TYPE
Stage Table
STG_CD_EXCP_TYPE
ODI Package
B1_PKG_CD_EXCP_TYPE
ETL View
B1_D__EXCP_TYPE_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
EXCP_TYPE_KEY
Exception Type Dimension Surrogate Key
 
This field is populated from the OUBI_EXCP_TYPE_SEQ sequence.
Natural Keys
EXCP_TYPE_CD
Exception Type Code
D1_EXCP_TYPE.EXCP_TYPE_CD
 
Attributes
EXCP_TYPE_INFO
Exception Type Information
D1_EXCP_TYPE_L.DESCR100
 
RPT_CAT_CD
Reporting Category Code
D1_EXCP_TYPE.D1_REPORTING_CAT_FLG
 
RPT_CAT_DESCR
Exception Category Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the description from Lookup Language table for the D1_REPORTING_CAT_FLG lookup field.
 
If override description is not available, regular description is extracted.
User Defined Attributes
UDF1_CD
User Defined Field 1 Code
 
 
UDF1_DESCR
User Defined Field 1 Description
 
 
UDF2_CD
User Defined Field 2 Code
 
 
UDF2_DESCR
User Defined Field 2 Description
 
 
UDF3_CD
User Defined Field 3 Code
 
 
UDF3_DESCR
User Defined Field 3 Description
 
 
UDF4_CD
User Defined Field 4 Code
 
 
UDF4_DESCR
User Defined Field 4 Description
 
 
UDF5_CD
User Defined Field 5 Code
 
 
UDF5_DESCR
User Defined Field 5 Description
 
 
UDF6_CD
User Defined Field 6 Code
 
 
UDF6_DESCR
User Defined Field 6 Description
 
 
UDF7_CD
User Defined Field 7 Code
 
 
UDF7_DESCR
User Defined Field 7 Description
 
 
UDF8_CD
User Defined Field 8 Code
 
 
UDF8_DESCR
User Defined Field 8 Description
 
 
UDF9_CD
User Defined Field 9 Code
 
 
UDF9_DESCR
User Defined Field 9 Description
 
 
UDF10_CD
User Defined Field 10 Code
 
 
UDF10_DESCR
User Defined Field 10 Description
 
 
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.
 
IMD Type Dimension
The IMD Type dimension holds various types of raw initial measurement data.
Properties
Property
Value
Target Table
CD_IMD_TYPE
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
CI_LOOKUP_VAL_L
Stage Table
STG_CD_IMD_TYPE
ODI Package
B1_PKG_CD_IMD_TYPE
ETL View
B1_D_IMD_TYPE _VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
IMD_TYPE_KEY
IMD Type Dimension Surrogate Key
 
This field is populated from the OUBI_IMD_TYPE_SEQ sequence.
Natural Keys
IMD_TYPE_CD
Initial Measurement Type Code
CI_LOOKUP_VAL_L.FIELD_VALUE
This field is populated with values defined for the D1_IMD_TYPE_FLG lookup field.
Attributes
IMD_TYPE_DESCR
Initial Measurement Type Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the description from the Lookup Language table.
 
If override description is not available, regular description is extracted.
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 (CI_INSTALLATION.ENV_ID).
JOB_NBR
Job Number
 
This field is populated with the ODI job execution session number.
Installation Event BO Status Dimension
The Installation Event BO Status dimension holds all business objects defined for the install events and their statuses, along with the status reasons for each of them.
Properties
Property
Value
Target Table
CD_IE_STATUS
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
F1_BUS_OBJ
F1_BUS_OBJ_STATUS_RSN
Stage Table
STG_CD_IE_STATUS
ODI Package
B1_PKG_CD_IE_STATUS
ETL View
B1_D_IE_STATUS_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
IE_STATUS_KEY
Install Event Status Dimension Surrogate Key
 
This field is populated from the OUBI_IE_STATUS_SEQ sequence.
Natural Keys
BUS_OBJ_CD
Business Object
F1_BUS_OBJ.BUS_OBJ_
CD
All business objects of the Install Event maintenance object only are extracted.
STATUS_CD
Status Code
F1_BUS_OBJ_STATUS.
BO_STATUS_CD
 
STATUS_RSN_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_COND_CD
Status Condition Code
F1_BUS_OBJ_STATUS.
BO_STATUS_COND_
FLG
 
STATUS_DESCR
Status Description
F1_BUS_OBJ_STATUS_L.DESCR
 
STATUS_RSN_DESCR
Status Reason Description
F1_BUS_OBJ_STATUS_
RSN_L.DESCR
 
STATUS_COND_DESCR
Status Condition Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the description from Lookup Language table for the BO_STATUS_COND_FLG lookup field.
 
If override description is not available, regular description is extracted.
User Defined Attributes
UDF1_CD
User Defined Field 1 Code
 
 
UDF1_DESCR
User Defined Field 1 Description
 
 
UDF2_CD
User Defined Field 2 Code
 
 
UDF2_DESCR
User Defined Field 2 Description
 
 
UDF3_CD
User Defined Field 3 Code
 
 
UDF3_DESCR
User Defined Field 3 Description
 
 
UDF4_CD
User Defined Field 4 Code
 
 
UDF4_DESCR
User Defined Field 4 Description
 
 
UDF5_CD
User Defined Field 5 Code
 
 
UDF5_DESCR
User Defined Field 5 Description
 
 
UDF6_CD
User Defined Field 6 Code
 
 
UDF6_DESCR
User Defined Field 6 Description
 
 
UDF7_CD
User Defined Field 7 Code
 
 
UDF7_DESCR
User Defined Field 7 Description
 
 
UDF8_CD
User Defined Field 8 Code
 
 
UDF8_DESCR
User Defined Field 8 Description
 
 
UDF9_CD
User Defined Field 9 Code
 
 
UDF9_DESCR
User Defined Field 9 Description
 
 
UDF10_CD
User Defined Field 10 Code
 
 
UDF10_DESCR
User Defined Field 10 Description
 
 
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.
 
Measurement Condition Code Dimension
The Measurement Condition Code dimension holds all valid values for measurement conditions that can be mapped to consumption.
Properties
Property
Value
Target Table
CD_MSRMT_COND
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
F1_EXT_LOOKUP_VAL
Stage Table
STG_CD_MSRMT_COND
ODI Package
B1_PKG_CD_MSRMT_COND
ETL View
B1_D_MSRMT_COND _VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
MSRMT_COND_KEY
Measurement Condition Dimension Surrogate Key
 
This field is populated from the OUBI_MSRMT_COND_SEQ sequence.
Natural Keys
MSRMT_COND_CD
Measurement Condition Code
F1_EXT_LOOKUP_VAL.F1_EXT_LOOKUP_VALUE
 
Attributes
MSRMT_COND_DESCR
Measurement Condition Description
F1_EXT_LOOKUP_VAL_L.DESCR_OVRD
 
F1_EXT_LOOKUP_VAL_L.DESCR
This field is populated with the description from Lookup Language table for the D1-MeasurementConditionLookup lookup business object.
 
If override description is not available, regular description is extracted.
MSRMT_COND_CAT_CD
Measurement Condition Category Code
F1_EXT_LOOKUP_VAL.BO_DATA_AREA
 
MSRMT_COND_CAT_
DESCR
Measurement Condition Category Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the description from Lookup Language table for the MSRMT_COND_CAT_FLG lookup field.
 
If override description is not available, regular description is extracted.
User Defined Attributes
UDF1_CD
User Defined Field 1 Code
 
 
UDF1_DESCR
User Defined Field 1 Description
 
 
UDF2_CD
User Defined Field 2 Code
 
 
UDF2_DESCR
User Defined Field 2 Description
 
 
UDF3_CD
User Defined Field 3 Code
 
 
UDF3_DESCR
User Defined Field 3 Description
 
 
UDF4_CD
User Defined Field 4 Code
 
 
UDF4_DESCR
User Defined Field 4 Description
 
 
UDF5_CD
User Defined Field 5 Code
 
 
UDF5_DESCR
User Defined Field 5 Description
 
 
UDF6_CD
User Defined Field 6 Code
 
 
UDF6_DESCR
User Defined Field 6 Description
 
 
UDF7_CD
User Defined Field 7 Code
 
 
UDF7_DESCR
User Defined Field 7 Description
 
 
UDF8_CD
User Defined Field 8 Code
 
 
UDF8_DESCR
User Defined Field 8 Description
 
 
UDF9_CD
User Defined Field 9 Code
 
 
UDF9_DESCR
User Defined Field 9 Description
 
 
UDF10_CD
User Defined Field 10 Code
 
 
UDF10_DESCR
User Defined Field 10 Description
 
 
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.
 
Measuring Component Dimension
The Measuring Component dimension holds the details of all measuring components in the Oracle Utilities Meter Data Management system.
Properties
Property
Value
Target Table
CD_MC
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
D1_MEASR_COMP
Stage Table
STG_CD_MC
ODI Package
B1_PKG_CD_MC
ETL View
B1_D_MC_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
MC_KEY
Measuring Component Key
 
This field is populated from the OUBI_MC_SEQ sequence.
Natural Keys
SRC_MC_ID
Measuring Component ID
D1_MEASR_COMP.MEASR_COMP_ID
 
Attributes
MC_INFO
Measuring Component Information
 
This is the concatenated information of measuring component, containing the device identifier, measuring component identifier, and measuring component type description from the device configuration, measuring component, and measuring component type tables respectively.
MC_TYPE_CD
Measuring Component Type Code
D1_MEASR_COMP.MEASR_COMP_TYPE_CD
 
SERVICE_TYPE_CD
Service Type Code
D1_MEASR_COMP_TYPE.D1_SVC_TYPE_CD
 
DEVICE_CONFIG_TYPE_CD
Device Configuration Type Code
D1_DVC_CFG.DEVICE_CONFIG_TYPE_CD
This field is populated with the device configuration type of the measuring component’s device configuration.
VEE_GRP_CD
VEE Group Code
D1_MEASR_COMP_VEE_GROUP.VEE_GRP_CD
 
D1_MEASR_COMP_TYP_FBK_VEE_GRP.VEE_GRP_CD
This is the override initial load VEE group of the measuring component.
 
If not found, it is populated with the fallback initial load VEE group of the measuring component type.
MC_TYPE_DESCR
Measuring Component Type Description
D1_MEASR_COMP_TYPE_L.DESCR100
 
SERVICE_TYPE_DESCR
Service Type Description
D1_SVC_TYPE_L.DESCR100
 
DEVICE_CONFIG_TYPE_DESCR
Device Configuration Type Description
D1_DVC_CFG_TYPE_L.DESCR100
 
VEE_GRP_DESCR
VEE Group Description
D1_VEE_GRP_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
EFF_START_DTTM
Effective Start Date/Time
 
 
EFF_END_DTTM
Effective End Date/Time
 
 
DATA_LOAD_DTTM
Data Load Date/Time
 
This field is populated with the load timestamp value.
DATA_SOURCE_IND
Data Source Indicator
CI_INSTALLATION.ENV_ID
This field is populated with the DSI value on the source product instance configuration. The table is populated as part of the initial setup and the DSI value is extracted from the environment ID of the source system.
JOB_NBR
Job Number
 
This field is populated with the ODI job execution session number.
 
Service Point BO Status Dimension
The Service Point BO Status dimension holds all business objects defined for service points and their statuses, along with the status reasons for each of them.
Properties
Property
Value
Target Table
CD_SP_STATUS
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
F1_BUS_OBJ
F1_BUS_OBJ_STATUS_RSN
Stage Table
STG_CD_SP_STATUS
ODI Package
B1_PKG_CD_SP_STATUS
ETL View
B1_D_SP_STATUS_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
SP_STATUS_KEY
Service Point Status Dimension Surrogate Key
 
This field is populated from the OUBI_SP_STATUS_SEQ sequence.
Natural Keys
BUS_OBJ_CD
Business Object Code
F1_BUS_OBJ.BUS_OBJ_CD
All business objects of the Service Point maintenance object only are extracted.
STATUS_CD
Status Code
F1_BUS_OBJ_STATUS.BO_STATUS_CD
 
STATUS_RSN_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_COND_CD
Status Condition Code
F1_BUS_OBJ_STATUS.BO_STATUS_COND_FLG
 
STATUS_DESCR
Status Description
F1_BUS_OBJ_STATUS_L.DESCR
 
STATUS_RSN_DESCR
Status Reason Description
F1_BUS_OBJ_STATUS_RSN_L.DESCR
 
STATUS_COND_DESCR
Status Condition Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the description from Lookup Language table for the BO_STATUS_COND_FLG lookup field.
 
If override description is not available, regular description is extracted.
User Defined Attributes
UDF1_CD
User Defined Field 1 Code
 
 
UDF1_DESCR
User Defined Field 1 Description
 
 
UDF2_CD
User Defined Field 2 Code
 
 
UDF2_DESCR
User Defined Field 2 Description
 
 
UDF3_CD
User Defined Field 3 Code
 
 
UDF3_DESCR
User Defined Field 3 Description
 
 
UDF4_CD
User Defined Field 4 Code
 
 
UDF4_DESCR
User Defined Field 4 Description
 
 
UDF5_CD
User Defined Field 5 Code
 
 
UDF5_DESCR
User Defined Field 5 Description
 
 
UDF6_CD
User Defined Field 6 Code
 
 
UDF6_DESCR
User Defined Field 6 Description
 
 
UDF7_CD
User Defined Field 7 Code
 
 
UDF7_DESCR
User Defined Field 7 Description
 
 
UDF8_CD
User Defined Field 8 Code
 
 
UDF8_DESCR
User Defined Field 8 Description
 
 
UDF9_CD
User Defined Field 9 Code
 
 
UDF9_DESCR
User Defined Field 9 Description
 
 
UDF10_CD
User Defined Field 10 Code
 
 
UDF10_DESCR
User Defined Field 10 Description
 
 
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.
 
Service Point Dimension
The Service Point dimension stores the details of all service points in the Oracle Utilities Meter Data Management system.
Properties
Property
Value
Target Table
CD_SP
Table Type
Dimension
SCD Type
Type 2
Source System Driver Table
D1_SP
Stage Table
STG_CD_SP
ODI Package
B1_PKG_CD_SP
ETL View
B1_D_SP_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
SP_KEY
Service Point Dimension Surrogate Key
 
This field is populated from the OUBI_SP_SEQ sequence.
Natural Keys
SRC_SP_ID
Service Point ID
D1_SP.D1_SP_ID
 
Attributes
SERVICE_TYPE_DESCR
Service Type Description
D1_SVC_TYPE_L.DESCR100
 
SERVICE_TYPE_CD
Service Type Code
D1_SP_TYPE.D1_SVC_TYPE_CD
 
SP_TYPE_CD
Service Point Type Code
D1_SP.D1_SP_TYPE_CD
 
MARKET_CD
Market Code
D1_SP.MKT_CD
 
FAC_LVL1_CD
Facility Level 1 Code
 
 
FAC_LVL2_CD
Facility Level 2 Code
 
 
FAC_LVL3_CD
Facility Level 3 Code
 
 
SP_INFO
Service Point Information
 
This field is the concatenation of service point, containing the address, service point type description, measurement cycle description, measurement route description, and service point status.
SP_TYPE_DESCR
Service Point Type Description
D1_SP_TYPE_L.DESCR100
 
MARKET_DESCR
Market Description
D1_MKT_L.DESCR100
 
FAC_LVL1_DESCR
Facility Level 1 Description
 
 
FAC_LVL2_DESCR
Facility Level 2 Description
 
 
FAC_LVL3_DESCR
Facility Level 3 Description
 
 
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
EFF_START_DTTM
Effective Start Date/Time
 
 
EFF_END_DTTM
Effective End Date/Time
 
 
DATA_LOAD_DTTM
Data Load Date/Time
 
This field is populated with the load timestamp value.
DATA_SOURCE_IND
Data Source Indicator
CI_INSTALLATION.ENV_ID
This field is populated with the DSI value on the source product instance configuration. The table is populated as part of the initial setup and the DSI value is extracted from the environment ID of the source system.
JOB_NBR
Job Number
 
This field is populated with the ODI job execution session number.
 
Service Provider Dimension
The Service Provider dimension holds all the service providers defined in the Oracle Utilities Meter Data Management system.
Properties
Property
Value
Target Table
CD_SPR
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
D1_SPR
Stage Table
STG_CD_SPR
ODI Package
B1_PKG_CD_SPR
ETL View
B1_D_SPR_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
SPR_KEY
Service Provider Dimension Surrogate Key
 
This field is populated from the OUBI_SPR_SEQ sequence.
Natural Keys
SPR_CD
Service Provider Code
D1_SPR.D1_SPR_CD
 
Attributes
SPR_INFO
Service Provider Information
D1_SPR_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
 
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.
 
Unreported Usage Analysis Snapshot Type Dimension
The Unreported Usage Analysis Snapshot dimension holds various types of unreported usage snapshots that can be extracted.
Properties
Property
Value
Target Table
CD_SP_UT_AGE_TYPE
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
F1_EXT_LOOKUP_VAL_L
Stage Table
STG_CD_SP_UT_AGE_TYPE
ODI Package
B1_PKG_CD_SP_UT_AGE_TYPE
ETL View
B1_D_SP_UT_AGE_TYPE_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
SP_UT_AGE_TYPE_KEY
Unreported Usage Aging Type Dimension Surrogate Key
 
This field is populated from the OUBI_SP_UT_AGE_SEQ sequence.
Natural Keys
SP_UT_AGE_TYPE_CD
Unreported Usage Aging Type Code
F1_EXT_LOOKUP_VAL_L.F1_EXT_LOOKUP_VALUE
This field extracts the values defined for D2-SPUTAgingSnapshotTypeLookup lookup business object.
Attributes
SP_UT_AGE_TYPE_
DESC
Unreported Usage Aging Type Description
F1_EXT_LOOKUP_VAL_L.DESCR_OVRD
 
F1_EXT_LOOKUP_VAL_L.DESCR
This field is populated with the description from the Lookup Language table.
 
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
 
 
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.
 
UOM/ TOU Dimension
UOM/ TOU dimension holds all valid combinations of unit of measure and time of use values based on every consumption snapshot type on the service point types from the Oracle Utilities Meter Data Management system.
Properties
Property
Value
Target Table
CD_UOM_TOU
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
D1_SP_TYPE
Stage Table
STG_CD_UOM_TOU
ODI Package
B1_PKG_CD_UOM_TOU
ETL View
B1_D_UOM_TOU _VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
UOM_TOU_KEY
UOM TOU Dimension Surrogate Key
 
This field is populated from the OUBI_UOM_TOU_SEQ sequence.
Natural Keys
UOM_CD
Unit of Measure Code
F1_EXT_LOOKUP_VAL.BO_DATA_AREA
This field is populated with all target unit of measures configured on the consumption snapshot type.
TOU_CD
Time of Use Code
D1_TOU_GRP_TOU.D1_TOU_CD
This field is populated with the time of use.
 
The time of use codes are from the TOU codes on the TOU map template referenced on the TOU map in the consumption snapshot type.
Attributes
UOM_INFO
Unit of Measure Information
D1_UOM_L.DESCR100
 
TOU_INFO
Time of Use Information
D1_TOU_L.DESCR100
 
SERVICE_TYPE_CD
Service Type Code
D1_UOM.D1_SVC_TYPE_CD
 
SERVICE_TYPE_DESCR
Service Type Description
D1_SVC_TYPE_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
 
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.
 
UOM/ TOU/ SQI Dimension
UOM/ TOU/ SQI dimension holds all valid combinations of unit of measure, time of use, and service quantity identifier values based on every unreported usage snapshot rules configured on the service point types in the Oracle Utilities Meter Data Management system.
Properties
Property
Value
Target Table
CD_UOM_TOU_SQI
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
D1_SP_TYPE
Stage Table
STG_CD_UOM_TOU_SQI
ODI Package
B1_PKG_CD_UOM_TOU_SQI
ETL View
B1_D_UOM_TOU_SQI_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
UOM_TOU_SQI_KEY
UOM TOU SQI Dimension Surrogate Key
 
This field is populated from the OUBI_UOM_TOU_SQI_SEQ sequence.
Natural Keys
UOM_CD
Unit of Measure Code
D1_SP_TYPE.BO_DATA_AREA
This field is populated with unit of measure code from the Service Point Type table. The value is configured as part of the Unreported Usage Analysis Snapshot Type configuration on the service point type.
 
If not found, it is populated with ‘***’.
TOU_CD
Time of Use Code
D1_SP_TYPE.BO_DATA_AREA
This field is populated with time of use code from the Service Point Type table. The value is configured as part of the Unreported Usage Analysis Snapshot Type configuration on the service point type.
 
If not found, it is populated with ‘***’.
SQI_CD
Service Quantity Identifier Code
D1_SP_TYPE.BO_DATA_AREA
This field is populated with service quantity identifier code from the Service Point Type table. The value is configured as part of the Unreported Usage Analysis Snapshot Type configuration on the service point type.
 
If not found, it is populated with ‘***’.
Attributes
UOM_INFO
Unit of Measure Information
D1_UOM _L.DESCR100
 
TOU_INFO
Time of Use Information
D1_TOU _L.DESCR100
This field is populated with the description of the TOU.
SQI_INFO
Service Quantity Identifier Information
D1_SQI_L.DESCR100
 
SERVICE_TYPE_CD
Service Type Code
D1_UOM.D1_SVC_TYPE_CD
 
SERVICE_TYPE_DESCR
Service Type Description
D1_SVC_TYPE_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
 
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.
 
Usage Calculation Group Dimension
The Usage Calculation Group dimension holds all usage groups in the Oracle Utilities Meter Data Management system.
Properties
Property
Value
Target Table
CD_USAGE_GROUP
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
D1_USG_GRP_L
Stage Table
STG_CD_USAGE_GROUP
ODI Package
B1_PKG_CD_USAGE_GROUP
ETL View
B1_D_USAGE_GROUP_VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
USAGE_GROUP_KEY
Usage Group Dimension Surrogate Key
 
This field is populated from the OUBI_USAGE_GROUP_SEQ sequence.
Natural Keys
USAGE_GROUP_CD
Usage Group Code
D1_USG_GRP_L.USG_GRP_CD
 
Attributes
USAGE_GROUP_INFO
Usage Group Description
D1_USG_GRP_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
 
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.
 
Usage Subscription Dimension
The Usage Subscription dimension stores the details of all usage subscriptions in the Oracle Utilities Meter Data Management system.
Properties
Property
Value
Target Table
CD_US
Table Type
Dimension
SCD Type
Type 2
Source System Driver Table
D1_US
Stage Table
STG_CD_US
ODI Package
B1_PKG_CD_US
ETL View
B1_D_US _VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
US_KEY
Usage Subscription Dimension Surrogate Key
 
This field is populated from the OUBI_US_SEQ sequence.
Natural Keys
SRC_US_ID
Usage Subscription ID
D1_US.US_ID
 
Attributes
US_INFO
Usage Subscription Information
 
This field contains the concatenated information of the usage subscription, containing the contact name, contact number, usage subscription type description, start date, end date, and status.
US_TYPE_DESCR
Usage Subscription Type Description
D1_US_TYPE_L.DESCR100
 
US_TYPE_CD
Usage Subscription Type Code
D1_US.US_TYPE_CD
 
EXT_ID
External ID
D1_US_IDENTIFIER.ID_VALUE
 
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
EFF_START_DTTM
Effective Start Date/Time
 
 
EFF_END_DTTM
Effective End Date/Time
 
 
DATA_LOAD_DTTM
Data Load Date/Time
 
This field is populated with the load timestamp value.
DATA_SOURCE_IND
Data Source Indicator
CI_INSTALLATION.ENV_ID
This field is populated with the DSI value on the source product instance configuration. The table is populated as part of the initial setup and the DSI value is extracted from the environment ID of the source system.
JOB_NBR
Job Number
 
This field is populated with the ODI job execution session number.
 
VEE Rule Dimension
The VEE Rule dimension stores details of all VEE rules defined in the Oracle Utilities Meter Data Management system.
Properties
Property
Value
Target Table
CD_VEE_RULE
Table Type
Dimension
SCD Type
Type 1
Source System Driver Table
D1_VEE_RULE
Stage Table
STG_CD_VEE_RULE
ODI Package
B1_PKG_CD_VEE_RULE
ETL View
B1_D_VEE_RULE _VW
Fields
Target Field
Description
Source Field
Transformation Logic
Surrogate Key
VEE_RULE_KEY
VEE Rule Dimension Surrogate Key
 
This field is populated from the OUBI_VEE_RULE_SEQ sequence.
Natural Keys
VEE_GRP_CD
VEE Group Code
D1_VEE_RULE.VEE_GRP_CD
 
VEE_RULE_CD
VEE Rule Code
D1_VEE_RULE.VEE_RULE_CD
 
Attributes
VEE_GRP_INFO
VEE Group Information
VEE_RULE_CD.DESCR100
 
VEE_RULE_INFO
VEE Rule Information
D1_VEE_RULE_L.DESCR100
 
D1_VEE_RULE.START_DT
 
D1_VEE_RULE.END_DT
This field is populated with concatenated information of the VEE rule including its description, start date, and end date.
VEE_RULE_CAT_DESCR
VEE Rule Category Description
CI_LOOKUP_VAL_L.DESCR_OVRD
 
CI_LOOKUP_VAL_L.DESCR
This field is populated with the description from Lookup Language table for VEE_RULE_CAT_FLG lookup field.
 
If override description is not available, regular description is extracted.
VEE_RULE_CAT_CD
VEE Rule Category Code
D1_VEE_RULE.VEE_RULE_CAT_FLG
 
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.