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