Property | Value |
Target Table | CD_ACCT_TYPE |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | CU_ACCOUNT_TYPE |
ODI Package | B1_PKG_CD_ACCT_TYPE |
ETL View | B1_D_ACCT_TYPE_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
ACCT_TYPE_KEY | Account Type Dimension | Populated with the B1_ACCT_TYPE_SEQ sequence. | |
Natural Keys | |||
SRC_ACCT_TYPE_CD | Account Type Code | CU_ACCOUNT_TYPE. ACCTYP_ACCOUNT_ TYPE | |
Attributes | |||
There are no attributes in this dimension. | |||
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | ||
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | ||
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | ||
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | ||
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | ||
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | ||
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | ||
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | ||
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | ||
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | ||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
UPDATE_DTTM | Update Date and Time | ||
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_ALARM_LOG |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | DDS_ALARM_LOG |
ODI Package | B1_PKG_CD_ALARM_LOG |
ETL View | B1_D_ALARM_LOG_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
ALARM_LOG_KEY | Alarm Log Dimension Surrogate Key | Populated with the sequence from B1_ALARM_LOG_SEQ. | |
Natural Keys | |||
SRC_ALARM_CLS | Alarm Class | DDS_ALARM_LOG. ALARM_CLS | |
SRC_ALARM_IDX | Alarm Index | DDS_ALARM_LOG.ALARM_IDX | |
Attributes | |||
ALARM_TYPE | Alarm Type | DDS_ALARM_LOG.ALARM_TYPE | |
DESCR | Description | DDS_ALARM_LOG.DESCRIPTION | |
PRIORITY | Priority | DDS_ALARM_LOG.ALARM_PRIORITY | |
SOURCE | Source | DDS_ALARM_LOG.SOURCE | |
PHASE | Phase | DDS_ALARM_LOG.PHASE | |
CURR_STATE | Current State | DDS_ALARM_LOG.STATE | |
NOMINAL_STATE | Nominal State | DDS_ALARM_LOG.NOMINAL | |
DEVICE | Device | DDS_ALARM_LOG.DEVICE | |
DEVICE_ATTRIBUTE | Device Attribute | DDS_ALARM_LOG.ATTRIBUTE | |
DEVICE_ATTRIBUTE_ UNIT | Device Attribute Unit | DDS_ALARM_LOG.ATTRIBUTE_UNIT | |
DEVICE_ATTRIBUTE_ DESCR | Device Attribute Description | DDS_ALARM_LOG.ATTRIBUTE_DESC | |
DEVICE_QUALITY | Device Quality | DDS_ALARM_LOG.QUALITY | |
TERM_STATION | Terminal Station | DDS_ALARM_LOG.TERM_STATION | |
ACTIVE_IND | Active Indicator | DDS_ALARM_LOG.ACTIVE | |
ALARM_IND | Alarm Indicator | DDS_ALARM_LOG.IS_ALARM | |
RTI_ALIAS | RTI Name | DDS_ALARM_LOG.RTI_ALIAS | |
EXTERNAL_ID | External ID | DDS_ALARM_LOG.EXTERNAL_ID | |
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | ||
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | ||
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | ||
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | ||
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | ||
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | ||
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | ||
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | ||
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | ||
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | ||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
UPDATE_DTTM | Update Date/Time | ||
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
|---|---|
Target Table | CD_CALL_INFO |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | INCIDENTS |
ODI Package | B1_PKG_CD_CALL_INFO |
ETL View | B1_D_CALL_INFO_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
CALL_INFO_KEY | Call Info Dimension Surrogate Key | Populated with the sequence from SPL_CALL_INFO_SEQ. | |
Natural Keys | |||
SRC_INCIDENT_ID | Call Number | INCIDENTS.NUMB | |
Attributes | |||
CALLER_NAME | Caller Name | INCIDENTS.CUSTOMER_NAME | |
PHONE_NBR | Phone Number | INCIDENTS.CUSTOMER_PHONE | |
COMPLAINT | Complaint Description | INCIDENTS. COMPLAINT | |
COMMENTS | Call Comments | INCIDENTS.OP_COMMENT | |
ADDRESS | Address | INCIDENTS.ADDRESS | |
ALTERNATE_PHONE | Alternate Phone | INCIDENTS. ALTERNATE_PHONE | |
APPT_RANGE | Appointment Range | INCIDENTS. APPT_RANGE | |
APPT_TYPE | Appointment Type | INCIDENTS. APPT_TYPE | |
BITMASK | Bit Mask | INCIDENTS. BITMASK | |
CANCEL_IND | Call Cancelled Indicator | INCIDENTS. CALL_CANCEL | |
CUSTOMER_TYPE | Customer Type | INCIDENTS. CUSTOMER_TYPE | |
CALLBACK_REQUEST | Callback Request | INCIDENTS. CALLBACK_REQUEST | |
CALLBACK_STATUS | Callback Status | INCIDENTS. CALLBACK_STATUS | |
CALLBACK_LATE_IND | Callback Late Indicator | INCIDENTS. CALLBACK_LATE | |
CALLBACK_CANC_ REASON | Callback Cancel Reason | INCIDENTS. CB_CANCEL_REASON | |
CALLBACK_TRANSF_ IND | Callback Transfer Indicator | INCIDENTS. CB_TRANSFERRED | |
CALLBACK_USERNAME | Callback Agent Name | INCIDENTS. CB_USERNAME | |
CLUE_IND | Clue | INCIDENTS. CLUE | |
EXTERNAL_ID | External Id | INCIDENTS. EXTERNAL_ID | |
LIFE_SUPPORT_IND | Life Support Indicator | INCIDENTS. LIFE_SUPPORT | |
MEET_CODE | Meet Code | INCIDENTS. MEET_CODE | |
MESSAGE_IND | Message Indicator | INCIDENTS. MESSAGES | |
ORDER_NBR | Order Number | INCIDENTS. ORDER_NUMBER | |
AFFECTED_PHASES | Affected Phases | INCIDENTS. PHASES | |
PRIORITY | Priority | INCIDENTS. PRIORITY | |
TOTAL_PRIORITY | Total Priority | INCIDENTS. TOTALPRIORITY | |
TROUBLE_LOC | Trouble Location | INCIDENTS. TROUBLE_LOC | |
TROUBLE_QUEUE | Trouble Queue | INCIDENTS. TROUBLE_QUEUE | |
USER_NAME | User Name | INCIDENTS. USER_NAME | |
ACTIVE_IND | Call Active Indicator | INCIDENTS.ACTIVE | |
COMPLETE_IND | Complete Indicator (Y/N) | INCIDENTS.COMPLETE | |
DESCRIPTION | Trouble Code Short Description | INCIDENTS.SHORT_ DESC | |
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | ||
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | ||
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | ||
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | ||
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | ||
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | ||
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | ||
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | ||
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | ||
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | ||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
UPDATE_DTTM | Update Date/Time | TE_STATUSES.JRN_UPDATE_DTTM TE_STATUS_GROUPS.JRN_UPDATE_DTTM | Populated with the updated timestamp value. |
DELETE_IND | INCIDENTS.JRN_FLAG | Populated with “1” for deleted records, and “0” for new/modified records. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_CITY |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | CU_SERVICE_LOCATIONS |
ODI Package | B1_PKG_CD_CITY |
ETL View | B1_D_CITY_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
CITY_KEY | City Dimension Surrogate Key | Populated with the sequence from SPL_CITY_SEQ.NEXTVAL. | |
Natural Keys | |||
There are no natural keys in this dimension. | |||
Attributes | |||
SRC_STATE | State | CU_SERVICE_LOCATIONS.SERV_STATE | |
SRC_CITY | City | CU_SERVICE_LOCATIONS.SERV_CITY | |
SRC_COUNTRY | Country | CU_SERVICE_LOCATIONS.SERV_COUNTRY | |
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 | ||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
UPDATE_DTTM | Update Date/Time | CU_SERVICE_LOCATIONS.LAST_UPDATE_TIME | Populated with the updated timestamp value. |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_CTRL_ZONE |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | CONTROL_ZONE_STRUCTURES CONTROL_ZONES |
ODI Package | B1_PKG_CD_CTRL_ZONE |
ETL View | B1_D_CTRL_ZONE_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
CTRL_ZONE_KEY | Control Zone Dimension Surrogate Key | Populated with the sequence from SPL_CTRL_ZONE_SEQ.NEXT VAL. | |
Natural Keys | |||
SRC_NCG_ID | CONTROL_ZONES.NCG_ID CONTROL_ZONE_STRUCTURES.CHILD_NCG_ID | ||
Attributes | |||
HIERARCHY_TYPE | Hierarchy Type | “CIR” | |
CTRL_ZONE_NAME | Control Zone Name | CONTROL_ZONES. NAME | |
PARENT_NCG_LVL1_ID | Parent NCG Level 1 ID | CONTROL_ZONES. NCG_ID | Primary hierarchy root NCG |
PARENT_NCG_LVL1_ NAME | Parent NCG Level 1 Name | CONTROL_ZONES. NAME | Name of primary hierarchy root NCG |
PARENT_NCG_LVL2_ID | Parent NCG Level 2 ID | CONTROL_ZONES. NCG_ID | Control zone one-level below the root NCG |
PARENT_NCG_LVL2_ NAME | Parent NCG Level 2 Name | CONTROL_ZONES. NAME | Name of the control zone one-level below root NCG |
PARENT_NCG_LVL3_ID | Parent NCG Level 3 ID | CONTROL_ZONES. NCG_ID | Control zone two-levels below the root NCG |
PARENT_NCG_LVL3_ NAME | Parent NCG Level 3 Name | CONTROL_ZONES. NAME | Name of the control zone two-levels below root NCG |
PARENT_NCG_LVL4_ID | Parent NCG Level 4 ID | CONTROL_ZONES. NCG_ID | Control zone three-levels below the root NCG |
PARENT_NCG_LVL4_ NAME | Parent NCG Level 4 Name | CONTROL_ZONES. NAME | Name of the control zone three-levels below root NCG |
PARENT_NCG_LVL5_ID | Parent NCG Level 5 ID | CONTROL_ZONES. NCG_ID | Control zone four-levels below the root NCG |
PARENT_NCG_LVL5_ NAME | Parent NCG Level 5 Name | CONTROL_ZONES. NAME | Name of the control zone four-levels below root NCG |
PARENT_NCG_LVL6_ID | Parent NCG Level 6 ID | CONTROL_ZONES. NCG_ID | Control zone five-levels below the root NCG |
PARENT_NCG_LVL6_ NAME | Parent NCG Level 6 Name | CONTROL_ZONES. NAME | Name of the control zone five-levels below root NCG |
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 | Populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_CTRL_ZONE_SEC |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | CONTROL_ZONE_STRUCTURES CONTROL_ZONES |
ODI Package | B1_PKG_CD_CTRL_ZONE_SEC |
ETL View | B1_ D_CTRL_ZONE_SEC_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
CTRL_ZONE_SEC_KEY | Control Zone (Secondary) Dimension Surrogate Key | Populated with the sequence from B1_CTRL_ZONE_SEC_ SEQ. | |
Natural Keys | |||
SRC_NCG_ID | Source NCG ID | CONTROL_ZONES.NCG_ID | All leaf level NCG (i.e. NCG's are not parent) and second parent hierarchy NCG's will be populated into this dimension. If an NCG has more than one parent NCG, then maximum parent NCG from CONTROL_ZONE_STRUCTURES table will be treated as second hierarchy. |
Attributes | |||
CTRL_ZONE_NAME | Control Zone Name | CONTROL_ZONES.NAME | |
PARENT_NCG_LVL1_ID | Parent NCG ID Level 1 | CONTROL_ZONES. NCG_ID | Second hierarchy root NCG |
PARENT_NCG_LVL1_ NAME | Parent NCG Name Level 1 | CONTROL_ZONES. NAME | Name of secondary hierarchy root NCG |
PARENT_NCG_LVL2_ID | Parent NCG ID Level 2 | CONTROL_ZONES. NCG_ID | Control zone one-level below the root NCG |
PARENT_NCG_LVL2_ NAME | Parent NCG Name Level 2 | CONTROL_ZONES. NAME | Name of the control zone one-level below root NCG |
PARENT_NCG_LVL3_ID | Parent NCG Level 3 ID | CONTROL_ZONES. NCG_ID | Control zone two-levels below the root NCG |
PARENT_NCG_LVL3_ NAME | Parent NCG Level 3 Name | CONTROL_ZONES. NAME | Name of the control zone two-levels below root NCG |
PARENT_NCG_LVL4_ID | Parent NCG Level 4 ID | CONTROL_ZONES. NCG_ID | Control zone three-levels below the root NCG |
PARENT_NCG_LVL4_ NAME | Parent NCG Level 4 Name | CONTROL_ZONES. NAME | Name of the control zone three-levels below root NCG |
PARENT_NCG_LVL5_ID | Parent NCG Level 5 ID | CONTROL_ZONES. NCG_ID | Control zone four-levels below the root NCG |
PARENT_NCG_LVL5_ NAME | Parent NCG Level 5 Name | CONTROL_ZONES. NAME | Name of the control zone four-levels below root NCG |
PARENT_NCG_LVL6_ID | Parent NCG Level 6 ID | CONTROL_ZONES. NCG_ID | Control zone five-levels below the root NCG |
PARENT_NCG_LVL6_ NAME | Parent NCG Level 6 Name | CONTROL_ZONES. NAME | Name of the control zone five-levels below root NCG |
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 | Populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_CREW |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | CREWS |
ODI Package | B1_PKG_CD_CREW |
ETL View | B1_D_CREW_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
CREW_KEY | Crew Dimension Surrogate Key | Populated with the sequence from SPL_CREW_SEQ. | |
Natural Keys | |||
SRC_CREW_ID | Crew ID | CREWS.CREW_KEY | |
Attributes | |||
ACTIVE | Active | ||
CREW_CD | Crew Code | CREWS.CREW_ID | |
CREW_DESCR | Crew Description | CREW_TYPES.CREW_ NAME | |
CREW_CENTER | Crew Center | ||
CREW_CONTACT | Crew Contact | CREWS.CONTACT | |
CREW_SIZE | Crew Size | CREWS.CREW_SIZE | |
CREW_TYPE_CD | Crew Type Code | CREWS.CREW_TYPE | |
CREW_TYPE_DESCR | Crew Type Description | CREW_TYPES.CREW_ TYPE | |
MOBILE_NUM | Mobile Number | CREWS.MOBILE_NUM | |
ORG_UNIT1_CD | Organization Unit 1 Code | ||
ORG_UNIT1_DESCR | Organization Unit 1 Description | ||
ORG_UNIT2_CD | Organization Unit 2 Code | ||
ORG_UNIT2_DESCR | Organization Unit 2 Description | ||
ORG_UNIT3_CD | Organization Unit 3 Code | ||
ORG_UNIT3_DESCR | Organization Unit 3 Description | ||
PAGER_NUM | Page Number | CREWS.PAGER_NUM | |
VEHICLE_ID | Vehicle ID | ||
VEHICLE_NBR | Vehicle Number | ||
VEHICLE_TYPE | Vehicle Type | ||
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 | Populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_CREW_TYPE |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | CREWS |
ODI Package | B1_PKG_CD_CREW_TYPE |
ETL View | B1_ D_CREW_TYPE_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
CREW_TYPE_KEY | Crew Type Dimension Surrogate Key | Populated with the sequence from B1_CREW_TYPE_SEQ. | |
Natural Keys | |||
SRC_CREW_TYPE_ID | Crew Type ID | CREW_TYPES.TYPE_ NUM | |
Attributes | |||
CREW_TYPE | Crew Type | CREW_TYPES.CREW_ TYPE | |
MDT_IND | MDT Type Indicator | CREW_TYPES.MDT_ TYPE | |
SKILL | Skills | CREW_TYPES.SKILLS | |
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/Time | ||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_CUST_OUT |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | B1_RANGE_LOOKUP |
ODI Package | B1_PKG_CD_CUST_OUT |
ETL View | B1_D_CUST_OUT_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
CUST_OUT_KEY | Customers Out Dimension Surrogate Key | Populated with the sequence from B1_CUST_OUT_SEQ. | |
Natural Keys | |||
RANGE_START | Customers Out Start Range | B1_RANGE_LOOKUP. START_RANGE | |
RANGE_END | Customers Out End Range | B1_RANGE_LOOKUP. END_RANGE | |
Attributes | |||
CUST_OUT_DESCR | Description | B1_RANGE_LOOKUP. DESCR | |
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | ||
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | ||
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | ||
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | ||
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | ||
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | ||
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | ||
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | ||
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | ||
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | ||
Data Load Attributes | |||
UPDATE_DTTM | Update Date/Time | ||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_DAMAGE_ASMT |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | DAMAGE_REPORT |
ODI Package | B1_PKG_CD_DAMAGE_ASMT |
ETL View | B1_ D_DAMAGE_ASMT_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
DAMAGE_ASMT_KEY | Damage Assessment Dimension Surrogate Key | Populated from the B1_DAMAGE_ASMT_SEQ sequence. | |
Natural Keys | |||
SRC_DAMAGE_ASMT_ID | Damage Assessment ID | DAMAGE_REPORT. REPORT_ID | |
Attributes | |||
SECTION | Affected Section Type | DAMAGE_REPORT. SECTION | |
PHASE | Affected Phase | DAMAGE_REPORT. PHASE | |
ASSESOR | Assessor | DAMAGE_REPORT. CREW_ID | |
MOBILE_NBR | Mobile Number | DAMAGE_REPORT. RADIO_NUM | |
ADDRESS | Address | DAMAGE_REPORT. ADDRESS | |
CITY | City | DAMAGE_REPORT.CITY | |
LATITUDE | Latitude | DAMAGE_REPORT. LATITUDE | |
LONGITUDE | Longitude | DAMAGE_REPORT. LONGITUDE | |
ZONE | Zone | DAMAGE_REPORT. ZONE | |
GRID | Grid | DAMAGE_REPORT. GRID | |
HAZARDOUS_IND | Hazardous Indicator | DAMAGE_REPORT. HAZARDOUS | |
LOAD | Load | DAMAGE_REPORT. LOAD | |
LOCATION | Location | DAMAGE_REPORT. LOCATION | |
ROAD_BLOCK_IND | Road Blocked Indicator | DAMAGE_REPORT. ROAD_BLOCKED | |
STREET_LIGHT_IND | Street Light Indicator | DAMAGE_REPORT. STREET_LIGHT | |
COMMENT1 | Comment1 | DAMAGE_REPORT. COMMENT1 | |
COMMENT2 | Comment2 | DAMAGE_REPORT. COMMENT2 | |
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | UDF1 | |
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | UDF2 | |
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | UDF3 | |
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | UDF4 | |
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | UDF5 | |
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | UDF6 | |
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | UDF7 | |
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | UDF8 | |
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | UDF9 | |
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | UDF10 | |
UDF11_CD | User Defined Field 11 Code | ||
UDF11_DESCR | User Defined Field 11 Description | UDF11 | |
UDF12_CD | User Defined Field 12 Code | ||
UDF12_DESCR | User Defined Field 12 Description | UDF12 | |
UDF13_CD | User Defined Field 13 Code | ||
UDF13_DESCR | User Defined Field 13 Description | UDF13 | |
UDF14_CD | User Defined Field 14 Code | ||
UDF14_DESCR | User Defined Field 14 Description | UDF14 | |
UDF15_CD | User Defined Field 15 Code | ||
UDF15_DESCR | User Defined Field 15 Description | UDF15 | |
UDF16_CD | User Defined Field 16 Code | ||
UDF16_DESCR | User Defined Field 16 Description | UDF16 | |
UDF17_CD | User Defined Field 17 Code | ||
UDF17_DESCR | User Defined Field 17 Description | UDF17 | |
UDF18_CD | User Defined Field 18 Code | ||
UDF18_DESCR | User Defined Field 18 Description | UDF18 | |
UDF19_CD | User Defined Field 19 Code | ||
UDF19_DESCR | User Defined Field 19 Description | UDF19 | |
UDF20_CD | User Defined Field 20 Code | ||
UDF20_DESCR | User Defined Field 20 Description | UDF20 | |
UDF21_CD | User Defined Field 21 Code | ||
UDF21_DESCR | User Defined Field 21 Description | MISC_TEXT1 | |
UDF22_CD | User Defined Field 22 Code | ||
UDF22_DESCR | User Defined Field 22 Description | MISC_TEXT2 | |
UDF23_CD | User Defined Field 23 Code | ||
UDF23_DESCR | User Defined Field 23 Description | MISC_TEXT3 | |
UDF24_CD | User Defined Field 24 Code | ||
UDF24_DESCR | User Defined Field 24 Description | MISC_TEXT4 | |
UDF25_CD | User Defined Field 25 Code | ||
UDF25_DESCR | User Defined Field 25 Description | MISC_TEXT5 | |
UDF26_CD | User Defined Field 26 Code | ||
UDF26_DESCR | User Defined Field 26 Description | MISC_OPTION1 | |
UDF27_CD | User Defined Field 27 Code | ||
UDF27_DESCR | User Defined Field 27 Description | MISC_OPTION2 | |
UDF28_CD | User Defined Field 28 Code | ||
UDF28_DESCR | User Defined Field 28 Description | MISC_OPTION3 | |
UDF29_CD | User Defined Field 29 Code | ||
UDF29_DESCR | User Defined Field 29 Description | MISC_OPTION4 | |
UDF30_CD | User Defined Field 30 Code | ||
UDF30_DESCR | User Defined Field 30 Description | MISC_OPTION5 | |
Data Load Attributes | |||
EFF_START_DTTM | Effective Start Date/Time | ||
EFF_END_DTTM | Effective End Date/Time | ||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_DAMAGE_ASMT_STATUS |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | TE_VALID_STATES |
ODI Package | B1_PKG_CD_DAMAGE_ASMT_STATUS |
ETL View | B1_ D_DAMAGE_ASMT_STATUS_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
DAMAGE_ASMT_ STATUS_KEY | Damage Assessment Status Dimension Surrogate Key | Populated from the B1_DAMAGE_ASMT_STATUS_SEQ sequence. | |
Natural Keys | |||
SRC_STATE_KEY | State Key | TE_VALID_STATES.STATE_KEY | |
Attributes | |||
STATE_NAME | State Name | TE_VALID_STATES.STATE_NAME | |
STATE_DESCR | State Description | TE_VALID_STATES.DESCRIPTION | |
ALARM_IND | Alarm | TE_VALID_STATES.ALARM | |
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/Time | ||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_DAMAGE_PART |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | DAMAGE_PARTS |
ODI Package | B1_PKG_CD_DAMAGE_PART |
ETL View | B1_ D_DAMAGE_PART_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
DAMAGE_PART_KEY | Damage Part Dimension Surrogate Key | Populated from the B1_DAMAGE_PART_SEQ sequence. | |
Natural Keys | |||
SRC_PART_ID | Damage Part ID | DAMAGE_PARTS.PART_ID | |
Attributes | |||
PART_CODE | Damage Part Code | DAMAGE_PARTS.CODE | |
PART_NAME | Damage Part Name | DAMAGE_PARTS.PART_NAME | |
PART_TYPE | Damage Part Type | DAMAGE_PARTS.TYPE | |
PART_PARENT | Damage Part Parent | DAMAGE_PARTS. PARENT | |
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 | Populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_DAMAGE_TYPE |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | DAMAGE_TYPES |
ODI Package | B1_PKG_CD_DAMAGE_TYPE |
ETL View | B1_ D_DAMAGE_TYPE_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
DAMAGE_TYPE_KEY | Damage Type Dimension Surrogate Key | Populated with the sequence from B1_DAMAGE_TYPE_SEQ. | |
Natural Keys | |||
SRC_DAMAGE_TYPE_ID | Damage Type ID | DAMAGE_TYPES.TYPE_ID | |
Attributes | |||
DAMAGE_TYPE_NAME | Damage Type Name | DAMAGE_TYPES.TYPE_NAME | |
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 | Populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_DEVICE |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | NETWORK_COMPONENTS |
ODI Package | B1_PKG_CD_DEVICE |
ETL View | B1_D_DEVICE_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
DEVICE_KEY | Device Dimension Surrogate Key | Populated with the sequence from SPL_DEVICE_SEQ.NEXT VAL. | |
Natural Keys | |||
SRC_DEVICE_CLS | Device Class | NETWORK_COMPONENTS.H_CLS | |
SRC_DEVICE_IDX | Device Index | NETWORK_COMPONENTS.H_IDX | |
Attributes | |||
DEVICE_NAME | Device Name | NETWORK_COMPONENTS.NAME | |
DEVICE_TYPE_CD | Device Type Code | CLASSES.C_TYPE | |
DEVICE_TYPE_DESCR | Device Type Description | CLASSES.C_TYPE | |
DEVICE_CLASS_CD | Device Class Code | CLASSES.C_NAME | |
DEVICE_CLASS_DESCR | Device Class Description | CLASSES.C_DESC | |
ACTIVE_IND | Active Indicator | NETWORK_COMPONENTS.ACTIVE | |
VOLTAGE | Voltage | NETWORK_COMPONENTS.VOLTAGE | |
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 | Populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_EST_RST_DUR |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | B1_RANGE_LOOKUP |
ODI Package | B1_PKG_CD_EST_RST_DUR |
ETL View | B1_D_EST_RST_DUR_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
EST_RST_DUR_KEY | Estimated Restoration Duration Dimension Surrogate Key | Populated with the sequence from B1_EST_RST_DUR_SEQ.NEXT_VAL. | |
Natural Keys | |||
RANGE_START | Estimated Restoration Duration Start Range | B1_RANGE_LOOKUP.START_RANGE | |
RANGE_END | Estimated Restoration Duration End Range | B1_RANGE_LOOKUP.END_RANGE | |
Attributes | |||
EST_RST_DUR_DESCR | Estimated Restoration Duration Description | B1_RANGE_LOOKUP.DESCR | |
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | ||
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | ||
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | ||
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | ||
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | ||
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | ||
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | ||
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | ||
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | ||
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | ||
Data Load Attributes | |||
UPDATE_DTTM | Update Date/Time | ||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_EVENT |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | JOBS |
ODI Package | B1_PKG_CD_EVENT |
ETL View | B1_D_EVENT_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
EVENT_KEY | Event Dimension Surrogate Key | Populated with the sequence from SPL_EVENT_SEQ.NEXT_ VAL. | |
Natural Keys | |||
SRC_NBR | Number (Natural Key) | JOBS.NUMB | |
Attributes | |||
EVENT_NBR | Event Number | JOBS.EVENT_IDX | |
DELETE_IND | Delete Indicator | Used for marking the event as deleted in the source. | |
EXCLUDE_REASON | Exclude Reason | PICKLIST_INFO_UPD_TR.DTR_TEXT | |
OPERATOR_COMMENT | Operator Comment | JOBS.OPERATOR_COMMENT | |
EVENT_STATE_CD | Event Status Code | JOBS.VALID_STATE_ KEY | |
EVENT_STATE_DESCR | Event Status Description | JOBS.ALARM_STATE TE_VALID_STATES.DESCRIPTION | NVL(TE_VALID_STATES.DESCRIPTION, JOBS.ALARM_STATE) |
X_COORDINATE | X Coordinate | JOBS.X_COORD | |
Y_COORDINATE | Y Coordinate | JOBS.Y_COORD | |
FIRST_CALL_ADDR | First Call Address | JOBS.ADDR_STREET JOBS.ADDR_CITY | JOBS.ADDR_STREET || ',' || JOBS.ADDR_CITY |
REMEDY_CD | Remedy | PICKLIST_INFO_UPD_TR.REMEDY_OM | |
TROUBLE_CD_LIST | Trouble Code | JOBS.TROUBLE_CODE | |
SCHEDULED_DEV_OM | Scheduled Device Code | PICKLIST_INFO_UPD_TR.SCHEDULED_DEV_OM | |
HUMAN_ELEM_OM | Human Element Code | PICKLIST_INFO_UPD_TR.HUMAN_ELEM_OM | |
OTHER_CAUSE_OM | Other Code | PICKLIST_INFO_UPD_TR.OTHER_CAUSE_OM | |
FOREIGN_INTERF_OM | Foreign Interference Code | PICKLIST_INFO_UPD_TR.FOREIGN_INTERF_OM | |
VEGETATION_OM | Vegetation Code | PICKLIST_INFO_UPD_TR.VEGETATION_OM | |
DEF_EQUIP_OM | Defense Equipment Code | PICKLIST_INFO_UPD_TR.DEF_EQUIP_OM | |
ADV_ENVIRON_OM | Adverse Environment Code | PICKLIST_INFO_UPD_TR.ADV_ENVIRON_OM | |
ADV_WEATHER_OM | Adverse Weather Code | PICKLIST_INFO_UPD_TR.ADV_WEATHER_OM | |
REMEDY_OM | Remedy Code | PICKLIST_INFO_UPD_TR.REMEDY_OM | |
KEY_EVENT_IDX | Key Event Index | RELATED_OUTAGES.KEY_EVENT_IDX | |
H_CLS | Device Class | JOBS.H_CLS | |
H_IDX | Device Index | JOBS.H_IDX | |
ACTIVE_IND | Active Indicator | JOBS.ACTIVE | |
CITY | City | JOBS.ADDR_CITY | |
CALL_TYPE | Call Type | JOBS.CALL_TYPE | |
DISPLAY_NAME | Display Name | JOBS.DISPLAY_NAME | |
ESTIMATION_SRC_CD | Estimation Source | JOBS.EST_SOURCE | |
EVENT_CLS | Event Class | JOBS.EVENT_CLS | |
EVENT_IDX | Event Index | JOBS.EVENT_IDX | |
EXT_ID | External ID | JOBS.EXTERNAL_ID | |
REFRL_GRP | Referral Group | JOBS.REFERRAL_GROUP | |
RULE_SET | Rule Set | JOBS.RULE_SET | |
TRBLE_QUEUE | Trouble Queue | JOBS.TROUBLE_QUEUE | |
COMPLETED_BY | Completed By | JOBS.WHO_COMPLETED | |
ABN_IND | ABN Flag | PICKLIST_INFO_UPD_TR .ABN_FLAG | |
ACTION_TXT | Action Text | PICKLIST_INFO_UPD_TR.ACTION_TEXT | |
CLEAR_IND | Clear Flag | PICKLIST_INFO_UPD_TR.CLEAR_FLAG | |
CTRL_ZONE_TXT | Control Zone Text | PICKLIST_INFO_UPD_TR.CONTROL_ZONE_TEXT | |
DEVICE_TXT | Device Text | PICKLIST_INFO_UPD_TR.DEVICE_TEXT | |
EXCP_IND | Exception Flag | PICKLIST_INFO_UPD_TR.EXCEPTION_FLAG | |
FAILURE_OM | Failure Cause | PICKLIST_INFO_UPD_TR.FAILURE_OM | |
FEEDER_TXT | Feeder Text | PICKLIST_INFO_UPD_TR.FEEDER_TEXT | |
INTERRUPT_DEV_OM | Interruption Dev OM | PICKLIST_INFO_UPD_TR.INTERRUPT_DEV_OM | |
SYSTEM_OM | System OM | PICKLIST_INFO_UPD_TR.SYSTEM_OM | |
TYPE_OM | Type OM | PICKLIST_INFO_UPD_TR.TYPE_OM | |
CAUSE_OM | Cause OM | PICKLIST_INFO_UPD_TR.CAUSE_OM | |
ESTIMATED_OUT_OM | Estimated Out OM | PICKLIST_INFO_UPD_TR.EST_OUT_OM | |
PRIMARY_CAUSE_OM | Primary Cause Category | PICKLIST_INFO_UPD_TR .PRIMARY_CAUSE_OM | |
STATUS_CD | Status | JOBS.STATUS | |
EVENT_STATE_NAME | Event State Name | TE_VALID_STATES.STATE_NAME | |
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | ||
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | ||
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | ||
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | ||
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | ||
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | ||
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | ||
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | ||
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | ||
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | ||
UDF11_CD | User Defined Field 11 Code | ||
UDF11_DESCR | User Defined Field 11 Description | ||
UDF12_CD | User Defined Field 12 Code | ||
UDF12_DESCR | User Defined Field 12 Description | ||
UDF13_CD | User Defined Field 13 Code | ||
UDF13_DESCR | User Defined Field 13 Description | ||
UDF14_CD | User Defined Field 14 Code | ||
UDF14_DESCR | User Defined Field 14 Description | ||
UDF15_CD | User Defined Field 15 Code | ||
UDF15_DESCR | User Defined Field 15 Description | ||
UDF16_CD | User Defined Field 16 Code | ||
UDF16_DESCR | User Defined Field 16 Description | ||
UDF17_CD | User Defined Field 17 Code | ||
UDF17_DESCR | User Defined Field 17 Description | ||
UDF18_CD | User Defined Field 18 Code | ||
UDF18_DESCR | User Defined Field 18 Description | ||
UDF19_CD | User Defined Field 19 Code | ||
UDF19_DESCR | User Defined Field 19 Description | ||
UDF20_CD | User Defined Field 20 Code | ||
UDF20_DESCR | User Defined Field 20 Description | ||
UDF21_CD | User Defined Field 21 Code | ||
UDF21_DESCR | User Defined Field 21 Description | ||
UDF22_CD | User Defined Field 22 Code | ||
UDF22_DESCR | User Defined Field 22 Description | ||
UDF23_CD | User Defined Field 23 Code | ||
UDF23_DESCR | User Defined Field 23 Description | ||
UDF24_CD | User Defined Field 24 Code | ||
UDF24_DESCR | User Defined Field 24 Description | ||
UDF25_CD | User Defined Field 25 Code | ||
UDF25_DESCR | User Defined Field 25 Description | ||
UDF26_CD | User Defined Field 26 Code | ||
UDF26_DESCR | User Defined Field 26 Description | ||
UDF27_CD | User Defined Field 27 Code | ||
UDF27_DESCR | User Defined Field 27 Description | ||
UDF28_CD | User Defined Field 28 Code | ||
UDF28_DESCR | User Defined Field 28 Description | ||
UDF29_CD | User Defined Field 29 Code | ||
UDF29_DESCR | User Defined Field 29 Description | ||
UDF30_CD | User Defined Field 30 Code | ||
UDF30_DESCR | User Defined Field 30 Description | ||
UDF31_CD | User Defined Field 31 Code | ||
UDF31_DESCR | User Defined Field 31 Description | ||
UDF32_CD | User Defined Field 32 Code | ||
UDF32_DESCR | User Defined Field 32 Description | ||
UDF33_CD | User Defined Field 33 Code | ||
UDF33_DESCR | User Defined Field 33 Description | ||
UDF34_CD | User Defined Field 34 Code | ||
UDF34_DESCR | User Defined Field 34 Description | ||
UDF35_CD | User Defined Field 35 Code | ||
UDF35_DESCR | User Defined Field 35 Description | ||
UDF36_CD | User Defined Field 36 Code | ||
UDF36_DESCR | User Defined Field 36 Description | ||
UDF37_CD | User Defined Field 37 Code | ||
UDF37_DESCR | User Defined Field 37 Description | ||
UDF38_CD | User Defined Field 38 Code | ||
UDF38_DESCR | User Defined Field 38 Description | ||
UDF39_CD | User Defined Field 39 Code | ||
UDF39_DESCR | User Defined Field 39 Description | ||
UDF40_CD | User Defined Field 40 Code | ||
UDF40_DESCR | User Defined Field 40 Description | ||
SORT_COL_1 | Sort Column 1 | JOBS.SORT_COL_1 | |
SORT_COL_2 | Sort Column 2 | JOBS.SORT_COL_2 | |
SORT_COL_3 | Sort Column 3 | JOBS.SORT_COL_3 | |
SORT_COL_4 | Sort Column 4 | JOBS.SORT_COL_4 | |
SORT_COL_5 | Sort Column 5 | JOBS.SORT_COL_5 | |
SORT_COL_6 | Sort Column 6 | JOBS.SORT_COL_6 | |
SORT_COL_7 | Sort Column 7 | JOBS.SORT_COL_7 | |
SORT_COL_8 | Sort Column 8 | JOBS.SORT_COL_8 | |
SORT_COL_9 | Sort Column 9 | JOBS.SORT_COL_9 | |
Data Load Attributes | |||
UPDATE_DTTM | Update Date/Time | ||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_EVENT_STATUS |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | TE_STATUSES A |
ODI Package | B1_PKG_CD_EVENT_STATUS |
ETL View | B1_D_EVENT_STATUS_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
EVENT_STATUS_KEY | Event Status Dimension Surrogate Key | Populated with the sequence from SPL_EVENT_STATUS_SEQ.NEXT_VAL | |
Natural Keys | |||
SRC_STATUS | Status (Natural Key) | TE_STATUSES.TRANS_STATUS | |
Attributes | |||
EVENT_STATUS_CD | Event Status Code | TE_STATUSES.DESCRIPTION | Populated with “-” if null. |
EVENT_STATUS_DESCR | Event Status Description | TE_STATUSES.DESCRIPTION | Populated with “-” if null. |
GROUP_CD | Group Code | TE_STATUS_GROUPS. GROUP_NAME | |
GROUP_DESCR | Group Description | TE_STATUS_GROUPS. 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 | |||
UPDATE_DTTM | Update Date/Time | TE_STATUSES.JRN_UPDATE_DTTM TE_STATUS_GROUPS.JRN_UPDATE_DTTM | Populated with the updated timestamp value. |
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_EXCL_DETAIL |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | STORMMAN_STORMS |
ODI Package | B1_PKG_CD_EXCL_DETAIL |
ETL View | B1_D_ EXCL_DETAIL_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
EXCL_DETAIL_KEY | Excludable Storm Dimension Surrogate Key | Populated from the B1_EXCL_DETAIL_SEQ sequence. | |
Natural Keys | |||
SRC_NCG_ID | Strom Level NCG | STORMMAN_STORMS.ZONE_IDX | |
SRC_STORM_NAME | Storm Name | STORMMAN_STORMS.STORM_NAME | |
Attributes | |||
SRC_STORM_NAME_SFX | Storm Name Suffix | STORMMAN_STORMS.STORM_DATE | |
EXCL_PERIOD_ COMMENTS | Exclusion Period Comments | STORMMAN_STORMS.EX_STORM_COMMENT | |
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/Time | Populated with the updated timestamp value. | |
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_FEEDER |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | FEEDERS |
ODI Package | B1_PKG_CD_FEEDER |
ETL View | B1_D_FEEDER_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
FEEDER_KEY | Feeder Duration Dimension Surrogate Key | Populated with the sequence from SPL_FEEDER_SEQ.NEXT_VAL. | |
Natural Keys | |||
SRC_FEEDER_IDX | Feeder Index | FEEDERS.H_IDX | |
SRC_FEEDER_CLS | Feeder Class | FEEDERS.H_CLS | |
Attributes | |||
FEEDER_NAME | Feeder Name | FEEDERS.FEEDER_NAME FEEDERS.H_CLS FEEDERS.H_IDX | Use the feeder name if available. Else, use the combination of class and index. |
SUBSTN_CD | Substation Code | FEEDERS.SUBSTATION_NAME | |
SUBSTN_DESCR | Substation Name | FEEDERS.SUBSTATION_NAME | |
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | ||
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | ||
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | ||
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | ||
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | ||
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | ||
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | ||
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | ||
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | ||
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | ||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
EFF_START_DTTM | Effective Start Date/Time | ||
EFF_END_DTTM | Effective End Date/Time | FEEDERS.DEATH | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_MAJ_ EVT _SNAP_TYPE |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | n/a |
ODI Package | n/a |
ETL View | n/a |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
SNAP_TYPE_CD | Snapshot Type Dimension Surrogate Key | Populated with one of the static values below: • BLUE_SKY - If the Begin DTTM falls outside the exclusion period of the STORM (storm does not have any impact). • MAJ_EVT - If the Begin DTTM falls within the exclusion period (storm has an impact). • ALL - MAJOR EVENT + BLUE SKY | |
Natural Keys | |||
There are no natural keys in this dimension. | |||
Attributes | |||
SNAP_TYPE_DESCR | Snapshot Type Description | Populated with one of the static values below: • BLUE_SKY - If the Begin DTTM falls outside the exclusion period of the STORM (storm does not have any impact). • MAJ_EVT - If the Begin DTTM falls within the exclusion period (storm has an impact). • ALL - MAJOR EVENT + BLUE SKY | |
User Defined Attributes | |||
There are no user defined attributes in this dimension. | |||
Data Load Attributes | |||
There are no data load attributes in this dimension. | |||
Property | Value |
Target Table | CD_METER |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | CU_METERS |
ODI Package | B1_PKG_CD_METER |
ETL View | B1_D_METER_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
METER_KEY | Meter Dimension Surrogate Key | Populated with the sequence from SPL_METER_SEQ.NEXT_VAL. | |
Natural Keys | |||
SRC_METER_ID | Meter ID | CU_METERS.METER_ID | |
Attributes | |||
METER_INFO | Meter Number | CU_METERS.METER_ NO | |
METER_TYPE_CD | Meter Type Code | CU_METERS. METER_TYPE | |
AMR_ENABLED_IND | AMR Enabled Indicator | CU_METERS. METER_AMR_ENABLED | |
MANUFACTURER_ NAME | Manufacturer Name | CU_METERS. METER_MANUFACTURER | |
METER_NBR | Meter Number | CU_METERS. METER_NO | |
NBR_PHASES | Number of Phases | CU_METERS. METER_PHASES | |
RATE_CD | Rate Code | CU_METERS. METER_RATE_CODE | |
SERIAL_NBR | Serial Number | CU_METERS. METER_SERIAL_NUMBER | |
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | ||
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | ||
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | ||
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | ||
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | ||
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | ||
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | ||
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | ||
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | ||
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | ||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
EFF_START_DTTM | Effective Start Date/Time | ||
EFF_END_DTTM | Effective End Date/Time | ||
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_NETWORK_PREM |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | CU_SERVICE_LOCATIONS |
ODI Package | B1_PKG_CD_NETWRORK_PREM |
ETL View | B1_D_NETWRORK_PREM_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
NETWORK_PREM_KEY | Network Premise Dimension Surrogate Key | Populated from the B1_NETWORK_PREM_SEQ sequence. | |
Natural Keys | |||
SRC_NETWORK_PREM_ ID | Source Network Premise ID | CU_SERVICE_LOCATIONS.SERV_LOC_ID | |
Attributes | |||
PRIORITY_A_IND | A Priority | CU_SERVICE_LOCATIONS.SERV_A_PRIORITY | |
PRIORITY_B_IND | B Priority | CU_SERVICE_LOCATIONS.SERV_B_PRIORITY | |
PRIORITY_C_IND | Critical Priority | CU_SERVICE_LOCATIONS.SERV_C_PRIORITY | |
PRIORITY_D_IND | Medical Priority | CU_SERVICE_LOCATIONS.SERV_D_PRIORITY | |
PRIORITY_E_IND | Entertainment Priority | CU_SERVICE_LOCATIONS.SERV_E_PRIORITY | |
PRIORITY_F_IND | Fire Priority | CU_SERVICE_LOCATIONS.SERV_F_PRIORITY | |
PRIORITY_G_IND | Government Priority | CU_SERVICE_LOCATIONS.SERV_G_PRIORITY | |
PRIORITY_H_IND | Hospital Priority | CU_SERVICE_LOCATIONS.SERV_H_PRIORITY | |
PRIORITY_I_IND | I Priority | CU_SERVICE_LOCATIONS.SERV_I_PRIORITY | |
PRIORITY_J_IND | J Priority | CU_SERVICE_LOCATIONS.SERV_J_PRIORITY | |
PRIORITY_K_IND | Key Priority | CU_SERVICE_LOCATIONS.SERV_K_PRIORITY | |
PRIORITY_L_IND | Life Support Priority | CU_SERVICE_LOCATIONS.SERV_L_PRIORITY | |
PRIORITY_M_IND | Manufacturing Priority | CU_SERVICE_LOCATIONS.SERV_M_PRIORITY | |
PRIORITY_N_IND | Nursing Home Priority | CU_SERVICE_LOCATIONS.SERV_N_PRIORITY | |
PRIORITY_O_IND | O Priority | CU_SERVICE_LOCATIONS.SERV_O_PRIORITY | |
PRIORITY_P_IND | Police Priority | CU_SERVICE_LOCATIONS.SERV_P_PRIORITY | |
PRIORITY_Q_IND | Q Priority | CU_SERVICE_LOCATIONS.SERV_Q_PRIORITY | |
PRIORITY_R_IND | R Priority | CU_SERVICE_LOCATIONS.SERV_R_PRIORITY | |
PRIORITY_S_IND | Sensitive Priority | CU_SERVICE_LOCATIONS.SERV_S_PRIORITY | |
PRIORITY_T_IND | Transportation Priority | CU_SERVICE_LOCATIONS.SERV_T_PRIORITY | |
PRIORITY_U_IND | U Priority | CU_SERVICE_LOCATIONS.SERV_U_PRIORITY | |
PRIORITY_V_IND | V Priority | CU_SERVICE_LOCATIONS.SERV_V_PRIORITY | |
PRIORITY_W_IND | W Priority | CU_SERVICE_LOCATIONS.SERV_W_PRIORITY | |
PRIORITY_X_IND | X Priority | CU_SERVICE_LOCATIONS.SERV_X_PRIORITY | |
PRIORITY_Y_IND | Y Priority | CU_SERVICE_LOCATIONS.SERV_Y_PRIORITY | |
PRIORITY_Z_IND | 911 Priority | CU_SERVICE_LOCATIONS.SERV_Z_PRIORITY | |
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | ||
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | ||
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | ||
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | ||
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | ||
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | ||
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | ||
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | ||
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | ||
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | ||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
EFF_START_DTTM | Effective Start Date/Time | ||
EFF_END_DTTM | Effective End Date/Time | ||
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_OUTG_DUR |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | |
ODI Package | B1_PKG_CD_OUTG_DUR |
ETL View | B1_D_OUTG_DUR_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
OUTG_DUR_KEY | Outage Duration Dimension Surrogate Key | Populated from the B1_OUTG_DUR_SEQ sequence. | |
Natural Keys | |||
RANGE_START | Start Range | B1_RANGE_LOOKUP. START_RANGE | |
RANGE_END | End Range | B1_RANGE_LOOKUP. END_RANGE | |
Attributes | |||
OUTG_DUR_DESCR | Outage Duration Description | B1_RANGE_LOOKUP. DESCR | |
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | ||
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | ||
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | ||
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | ||
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | ||
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | ||
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | ||
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | ||
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | ||
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | ||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
UPDATE_DTTM | Update Date/Time | ||
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_DURATION_DEVIATION |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | B1_RANGE_LOOKUP |
ODI Package | B1_PKG_CD_DURATION_DEVIATION |
ETL View | B1_D_DURATION_DEVIATION_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
DURATION_DEVIATION_KEY | Estimated VS Actual Duration Dimension Surrogate Key | Populated with the sequence from B1_DURATION_DEVIATION_SEQ.NEXT_VAL. | |
Natural Keys | |||
RANGE_START | Duration Deviation Start Range | B1_RANGE_LOOKUP.START_RANGE | |
RANGE_END | Outage Duration Deviation End Range | B1_RANGE_LOOKUP.END_RANGE | |
Attributes | |||
DURATION_DEVIATION_DESCR | Outage Duration Deviation Description | B1_RANGE_LOOKUP.DESCR | |
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | ||
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | ||
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | ||
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | ||
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | ||
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | ||
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | ||
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | ||
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | ||
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | ||
Data Load Attributes | |||
UPDATE_DTTM | Update Date/Time | ||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_PHASE |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | PHASE_BITMAP_LOOKUP |
ODI Package | B1_PKG_CD_PHASE |
ETL View | B1_D_PHASE_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
PHASE_KEY | Phase Dimension Surrogate Key | Populated with the sequence from SPL_PHASE_SEQ.NEXT_VAL. | |
Natural Keys | |||
SRC_PHASE_ID | Phase ID | PHASE_BITMAP_LOOKUP.PHASE_BITS | |
Attributes | |||
PHASE_CD | PHASE_BITMAP_LOOKUP.PHASE_STRING | ||
PHASE_DESCR | Phase | PHASE_BITMAP_LOOKUP.PHASE_STRING | |
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 | ||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
EFF_START_DTTM | Effective Start Date/Time | ||
EFF_END_DTTM | Effective End Date/Time | ||
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_STORM |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | STORMMAN_STORMS |
ODI Package | B1_PKG_CD_STORM |
ETL View | B1_D_STORM_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
STORM_KEY | Storm Dimension Surrogate Key | Populated with the sequence from SPL_STORM_SEQ. | |
Natural Keys | |||
SRC_STORM_NAME | Storm Name | STORMMAN_STORMS. STORM_NAME | |
SRC_STORM_NAME_SFX | Storm Name Suffix | STORMMAN_STORMS. STORM_DATE | |
SRC_NCG_ID | Storm Control Zone | STORMMAN_STORMS. ZONE_IDX | |
Attributes | |||
STORM_TYPE_CD | Storm Type Code | STORMMAN_STORMS. STORM_TYPE | |
STORM_TYPE_DESCR | Storm Type Description | STORMMAN_STORM_ TYPES.STORM_TYPE_ NAME | |
STORM_LEVEL_CD | Storm Level Code | STORMMAN_STORMS. STORM_LEVEL | |
STORM_LEVEL_DESCR | Storm Level Description | STORMMAN_STORMS.STORM_LEVEL | |
STORM_START_DTTM | Date/Time the Storm Started | STORMMAN_STORMS.STORM_START | |
STORM_END_DTTM | Date/Time the Storm Ended | STORMMAN_STORMS.STORM_END | |
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | ||
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | ||
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | ||
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | ||
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | ||
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | ||
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | ||
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | ||
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | ||
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | ||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
UPDATE_DTTM | Update Date/Time | ||
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER.VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_STORM_OUTAGE_TYPE |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | STORMMAN_OUTAGE_TYPES |
ODI Package | B1_PKG_CD_STORM_OUTAGE_TYPE |
ETL View | B1_D_STORM_OUTAGE_TYPE_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
STORM_OUTAGE_TYPE_KEY | Storm Outage Type Dimension Surrogate Key | Populated with the sequence from SPL_STORM_OUTAGE_TYPE_SEQ.NEXT_VAL. | |
Natural Keys | |||
SRC_OUTAGE_TYPE | Outage Type | STORMMAN_OUTAGE_TYPES.OUTAGE_TYPE | |
Attributes | |||
OUTAGE_TYPE_CD | Outage Type Code | STORMMAN_OUTAGE_TYPES.OUTAGE_TYPE | |
OUTAGE_TYPE_DESCR | Outage Type Description | STORMMAN_OUTAGE_TYPES.OUTAGE_TYPE_NAME | If null, this is populated with “-”. |
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 | ||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
UPDATE_DTTM | Update Date/Time | ||
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_SNL |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | CES_CUSTOMERS_HISTORY |
ODI Package | B1_PKG_CD_SNL |
ETL View | B1_D_SNL_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
SNL_KEY | Supply Node Lookup Dimension Surrogate Key | Populated with the sequence from SPL_SNL_SEQ.NEXT_VAL. | |
Natural Keys | |||
SRC_METER_ID | Meter ID (Natural Key) | CES_CUSTOMERS_HISTORY.METER_ID | |
SRC_PERSON_ID | Person ID (Natural Key) | CES_CUSTOMERS_HISTORY.CUST_ID | |
SRC_PREMISE_ID | Premise ID (Natural Key) | CES_CUSTOMERS_HISTORY.SERV_LOC_ID | |
SRC_ACCOUNT_ID | Account ID | CES_CUSTOMERS_HISTORY.ACCOUNT_NUMBER | |
SRC_ADDR_ID | Address | CES_CUSTOMERS_HISTORY.SERV_LOC_ID | |
Attributes | |||
DEVICE_ID | Device ID | CES_CUSTOMERS_HISTORY.NEW_DEVICE_ID | |
FEEDER_ID | Feeder ID | CES_CUSTOMERS_HISTORY.FEEDER_ID | |
NCG_ID | NCG ID | CES_CUSTOMERS_HISTORY.NEW_NCG | |
DEVICE_CLS | Device Class | CES_CUSTOMERS_HISTORY.NEW_H_CLS | |
DEVICE_IDX | Device Index | CES_CUSTOMERS_HISTORY.NEW_H_IDX | |
User Defined Attributes | |||
There are no user defined attributes in this dimension. | |||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
EFF_START_DTTM | Effective Start Date/Time | CES_CUSTOMERS_HISTORY.BIRTH | |
EFF_END_DTTM | Effective End Date/Time | CES_CUSTOMERS_HISTORY.DEATH | |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
Target Table | CD_SW_PLAN |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | SWMAN_SHEET |
ODI Package | B1_PKG_CD_SW_PLAN |
ETL View | B1_D_SW_PLAN_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
SW_PLAN_KEY | Switch Plan Dimension Surrogate Key | Populated with the sequence from SPL_SW_PLAN_SEQ. | |
Natural Keys | |||
SRC_SW_PLAN_CLS | Switch Plan Class | SWMAN_SHEET.SWITCH_SHEET_CLS | |
SRC_SW_PLAN_IDX | Switch Plan Index | SWMAN_SHEET.SWITCH_SHEET_IDX | |
Attributes | |||
CHARGE_NBR1 | Charge Number 1 | SWMAN_SHEET.CHARGENUMBER1 | |
CHARGE_NBR2 | Charge Number 2 | SWMAN_SHEET.CHARGENUMBER2 | |
CHARGE_NBR3 | Charge Number 3 | SWMAN_SHEET.CHARGENUMBER3 | |
DESCR | Description | SWMAN_SHEET.DESCRIPTION | |
DEVICE_ALIAS | Device Alias | SWMAN_SHEET. DEVICE_ALIAS | |
INS_USER | Inserted User | SWMAN_SHEET.INSERT_USER | |
LOCATION | Location | SWMAN_SHEET.LOCATION | |
OFFICE | Office | SWMAN_SHEET.OFFICE | |
REQUESTED_CUST_ NAME | Requested Customer Name | SWMAN_SHEET.CUSTOMERREQUESTEDNAME | |
REQUESTED_CUST_ PHONE_NBR | Requested Customer Phone Number | SWMAN_SHEET.CUSTOMERREQUESTEDPHONENUMBER | |
SW_SHEET_TYPE | Switch Sheet Type | SWMAN_SHEET_CLS. SWITCH_SHEET_TYPE | |
SW_SHEET_TYPE_ DESCR | Switch Sheet Type Description | SWMAN_SHEET_CLS.DESCRIPTION | |
OWNER | Owner | SWMAN_SHEET.OWNER | |
CREW_WILL_SWITCH_ IND | Crew Will Switch Indicator | SWMAN_SHEET. CREWWILLSWITCH | |
CREW_WILL_RST_IND | Crew Will Restore Indicator | SWMAN_SHEET.CREWWILLRESTORE | |
GROUNDS_REQUIRED_ IND | Grounds Required Indicator | SWMAN_SHEET.GROUNDSREQUIRED | |
SHEET_ID | Sheet ID | SWMAN_SHEET.SEQ_SHEET_ID | |
VERIFY_IND | Verify Indicator | SWMAN_SHEET.MB_EDIT | |
VOLTAGE | Voltage | SWMAN_SHEET.VOLTAGE | |
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | ||
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | ||
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | ||
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | ||
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | ||
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | ||
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | ||
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | ||
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | ||
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | ||
UDF11_CD | User Defined Field 11 Code | ||
UDF11_DESCR | User Defined Field 11 Description | ||
UDF12_CD | User Defined Field 12 Code | ||
UDF12_DESCR | User Defined Field 12 Description | ||
UDF13_CD | User Defined Field 13 Code | ||
UDF13_DESCR | User Defined Field 13 Description | ||
UDF14_CD | User Defined Field 14 Code | ||
UDF14_DESCR | User Defined Field 14 Description | ||
UDF15_CD | User Defined Field 15 Code | ||
UDF15_DESCR | User Defined Field 15 Description | ||
UDF16_CD | User Defined Field 16 Code | ||
UDF16_DESCR | User Defined Field 16 Description | ||
UDF17_CD | User Defined Field 17 Code | ||
UDF17_DESCR | User Defined Field 17 Description | ||
UDF18_CD | User Defined Field 18 Code | ||
UDF18_DESCR | User Defined Field 18 Description | ||
UDF19_CD | User Defined Field 19 Code | ||
UDF19_DESCR | User Defined Field 19 Description | ||
UDF20_CD | User Defined Field 20 Code | ||
UDF20_DESCR | User Defined Field 20 Description | ||
UDF21_CD | User Defined Field 21 Code | ||
UDF21_DESCR | User Defined Field 21 Description | ||
UDF22_CD | User Defined Field 22 Code | ||
UDF22_DESCR | User Defined Field 22 Description | ||
UDF23_CD | User Defined Field 23 Code | ||
UDF23_DESCR | User Defined Field 23 Description | ||
UDF24_CD | User Defined Field 24 Code | ||
UDF24_DESCR | User Defined Field 24 Description | ||
UDF25_CD | User Defined Field 25 Code | ||
UDF25_DESCR | User Defined Field 25 Description | ||
UDF26_CD | User Defined Field 26 Code | ||
UDF26_DESCR | User Defined Field 26 Description | ||
UDF27_CD | User Defined Field 27 Code | ||
UDF27_DESCR | User Defined Field 27 Description | ||
UDF28_CD | User Defined Field 28 Code | ||
UDF28_DESCR | User Defined Field 28 Description | ||
UDF29_CD | User Defined Field 29 Code | ||
UDF29_DESCR | User Defined Field 29 Description | ||
UDF30_CD | User Defined Field 30 Code | ||
UDF30_DESCR | User Defined Field 30 Description | ||
UDF31_CD | User Defined Field 31 Code | ||
UDF31_DESCR | User Defined Field 31 Description | ||
UDF32_CD | User Defined Field 32 Code | ||
UDF32_DESCR | User Defined Field 32 Description | ||
UDF33_CD | User Defined Field 33 Code | ||
UDF33_DESCR | User Defined Field 33 Description | ||
UDF34_CD | User Defined Field 34 Code | ||
UDF34_DESCR | User Defined Field 34 Description | ||
UDF35_CD | User Defined Field 35 Code | ||
UDF35_DESCR | User Defined Field 35 Description | ||
UDF36_CD | User Defined Field 36 Code | ||
UDF36_DESCR | User Defined Field 36 Description | ||
UDF37_CD | User Defined Field 37 Code | ||
UDF37_DESCR | User Defined Field 37 Description | ||
UDF38_CD | User Defined Field 38 Code | ||
UDF38_DESCR | User Defined Field 38 Description | ||
UDF39_CD | User Defined Field 39 Code | ||
UDF39_DESCR | User Defined Field 39 Description | ||
UDF40_CD | User Defined Field 40 Code | ||
UDF40_DESCR | User Defined Field 40 Description | ||
UDF41_CD | User Defined Field 41 Code | ||
UDF41_DESCR | User Defined Field 41 Description | ||
UDF42_CD | User Defined Field 42 Code | ||
UDF42_DESCR | User Defined Field 42 Description | ||
UDF43_CD | User Defined Field 43 Code | ||
UDF43_DESCR | User Defined Field 43 Description | ||
UDF44_CD | User Defined Field 44 Code | ||
UDF44_DESCR | User Defined Field 44 Description | ||
UDF45_CD | User Defined Field 45 Code | ||
UDF45_DESCR | User Defined Field 45 Description | ||
UDF46_CD | User Defined Field 46 Code | ||
UDF46_DESCR | User Defined Field 46 Description | ||
UDF47_CD | User Defined Field 47 Code | ||
UDF47_DESCR | User Defined Field 47 Description | ||
UDF48_CD | User Defined Field 48 Code | ||
UDF48_DESCR | User Defined Field 48 Description | ||
UDF49_CD | User Defined Field 49 Code | ||
UDF49_DESCR | User Defined Field 49 Description | ||
UDF50_CD | User Defined Field 50 Code | ||
UDF50_DESCR | User Defined Field 50 Description | ||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
UPDATE_DTTM | Update Date/Time | ||
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
|---|---|
Target Table | CD_SWP_JOBS |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | JOBS SWITCH_SHEET_OUTAGE_EVENTS |
ODI Package | n/a |
ETL View | B1_ D_SWP_JOBS_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
SWP_JOBS_KEY | Switch Plan Jobs Dimension Surrogate Key | Populated with the sequence from B1_SWP_JOBS_SEQ. | |
Natural Keys | |||
SWITCH_SHEET_CLS | Switch Sheet CLS | JOBS.SWSHEET_CLS SWITCH_SHEET_OUTAGE_EVENTS.SWITCH_SHEET_CLS | |
SWITCH_SHEET_IDX | Switch Sheet IDX | JOBS.SWSHEET_IDX SWITCH_SHEET_OUTAGE_EVENTS.SWITCH_SHEET_IDX | |
Attributes | |||
ASSOC_TYPE | Association Type | ||
ASSOC_NAME | Association Name | ||
User Defined Attributes | |||
There are no user defined attributes in this table. | |||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
UPDATE_DTTM | Update Date/Time | TE_VALID_STATES.UPDATE_DTTM | Populated with the updated timestamp value. |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |
Property | Value |
|---|---|
Target Table | CD_SW_PLAN_STATE |
Table Type | Dimension |
SCD Type | Type 1 |
Source System Driver Table | TE_VALID_STATES |
ODI Package | B1_PKG_CD_SW_PLAN_STATE |
ETL View | B1_D_SW_PLAN_STATE_VW |
Target Field | Description | Source Field | Transformation Logic |
|---|---|---|---|
Surrogate Key | |||
SW_PLAN_STATE_KEY | Switch Plan State Dimension Surrogate Key | Populated with the sequence from SPL_SW_PLAN_STATE_SEQ.NEXT_VAL. | |
Natural Keys | |||
SRC_STATE_KEY | Switch Plan State Key | TE_VALID_STATES.STATE_KEY | |
Attributes | |||
STATE_CD | Switch Plan State Code | TE_VALID_STATES.STATE_NAME | |
STATE_DESCR | Switch Plan State | TE_VALID_STATES.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 | ||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
UPDATE_DTTM | Update Date/Time | TE_VALID_STATES.UPDATE_DTTM | Populated with the updated timestamp value. |
DATA_SOURCE_IND | Data Source Indicator | CES_PARAMETER. VALUE | 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 source system. |
JOB_NBR | Job Number | Populated with the ODI job execution session number. | |