Property | Value |
Target Table | CD_ACCT |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | NMS_ACCOUNTS_HISTORY |
ODI Package | B1_PKG_CD_ACCT |
ETL View | B1_D_ACCT_VW |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
ACCT_KEY | Account Dimension | Populated with the SPL_ACCT_SEQ.NEXTVAL sequence. | |
Natural Keys | |||
SRC_ACCT_ID | Account ID | NMS_ACCOUNTS_HISTORY.SERV_ACCOUNT_NUMBER | |
Attributes | |||
ACCT_INFO | Account Information | NMS_ACCOUNTS_HISTORY.SERV_LOC_ID | |
REVENUE_CLASS_CD | Service Revenue Class Code | NMS_ACCOUNTS_HISTORY.SERV_REVENUE_CLASS | |
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | ||
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | ||
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | ||
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | ||
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | ||
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | ||
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | ||
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | ||
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | ||
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | ||
UDF11_CD | User Defined Field 11 Code | ||
UDF11_DESCR | User Defined Field 11 Description | ||
UDF12_CD | User Defined Field 12 Code | ||
UDF12_DESCR | User Defined Field 12 Description | ||
UDF13_CD | User Defined Field 13 Code | ||
UDF13_DESCR | User Defined Field 13 Description | ||
UDF14_CD | User Defined Field 14 Code | ||
UDF14_DESCR | User Defined Field 14 Description | ||
UDF15_CD | User Defined Field 15 Code | ||
UDF15_DESCR | User Defined Field 15 Description | ||
UDF1_NUM | User Defined Field 1 Number | ||
UDF2_NUM | User Defined Field 2 Number | ||
UDF3_NUM | User Defined Field 3 Number | ||
UDF4_NUM | User Defined Field 4 Number | ||
UDF5_NUM | User Defined Field 5 Number | ||
UDF6_NUM | User Defined Field 6 Number | ||
UDF7_NUM | User Defined Field 7 Number | ||
UDF8_NUM | User Defined Field 8 Number | ||
UDF9_NUM | User Defined Field 9 Number | ||
UDF10_NUM | User Defined Field 10 Number | ||
UDF1_DATE | User Defined Field 1 Date | ||
UDF2_DATE | User Defined Field 2 Date | ||
UDF3_DATE | User Defined Field 3 Date | ||
UDF4_DATE | User Defined Field 4 Date | ||
UDF5_DATE | User Defined Field 5 Date | ||
UDF6_DATE | User Defined Field 6 Date | ||
UDF7_DATE | User Defined Field 7 Date | ||
UDF8_DATE | User Defined Field 8 Date | ||
UDF9_DATE | User Defined Field 9 Date | ||
UDF10_DATE | User Defined Field 10 Date | ||
FLEXFIELD1 | Flex Field 1 | ||
FLEXFIELD2 | Flex Field 2 | ||
FLEXFIELD3 | Flex Field 3 | ||
FLEXFIELD4 | Flex Field 4 | ||
FLEXFIELD5 | Flex Field 5 | ||
FLEXFIELD6 | Flex Field 6 | ||
FLEXFIELD7 | Flex Field 7 | ||
FLEXFIELD8 | Flex Field 8 | ||
FLEXFIELD9 | Flex Field 9 | ||
FLEXFIELD10 | Flex Field 10 | ||
Data Load Attributes | |||
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_ADDR |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | CU_SERVICE_LOCATIONS |
ODI Package | B1_PKG_CD_ADDR |
ETL View | B1_D_ADDR_VW |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
ADDR_KEY | Address Dimension Surrogate Key | Populated with the sequence from SPL_ADDR_SEQ. NEXTVAL. | |
Natural Keys | |||
SRC_ADDR_ID | Premise ID | CU_SERVICE_LOCATIONS.SERV_LOC_ID | |
Attributes | |||
ADDR_INFO | Address | Concatenated string of SERV_ADDR_1, SERV_CITY, SERV_STATE, and SERV_POSTCODE_1, separated by a comma. | |
ADDR_LINE1 | Address Line 1 | CU_SERVICE_LOCATIONS.SERV_ADDR_1 | |
ADDR_LINE2 | Address Line 2 | CU_SERVICE_LOCATIONS.SERV_ADDR_2 | |
ADDR_LINE3 | Address Line 3 | CU_SERVICE_LOCATIONS.SERV_ADDR_3 | |
ADDR_LINE4 | Address Line 4 | CU_SERVICE_LOCATIONS.SERV_ADDR_4 | |
CITY | City | CU_SERVICE_LOCATIONS.SERV_CITY | |
COUNTY | County | ||
POSTAL | Postal Code | CU_SERVICE_LOCATIONS.SERV_POSTCODE_1 | |
STATE_CD | State Code | CU_SERVICE_LOCATIONS.SERV_STATE | |
STATE_DESCR | State | CU_SERVICE_LOCATIONS.SERV_STATE | |
COUNTRY_CD | Country Code | ||
COUNTRY_DESCR | Country | ||
GEO_CODE | Geographical Code | ||
CROSS_STREET | Cross Street | ||
SUBURB | Suburb | ||
APARTMENT_NBR | Apartment Number | CU_SERVICE_LOCATIONS.SERV_APT | |
LOT_NBR | Lot Number | CU_SERVICE_LOCATIONS.SERV_LOT | |
BLOCK | Block | CU_SERVICE_LOCATIONS.SERV_STR_BLOCK | |
BUILDING_ADDR | Building Address | CU_SERVICE_LOCATIONS.SERV_STR_STRUC | |
STREET_NAME | Street Name | CU_SERVICE_LOCATIONS.SERV_STR_NAME | |
STREET_PREFIX | Street Prefix | CU_SERVICE_LOCATIONS.SERV_STR_PFIX | |
STREET_SUFFIX | Street Suffix | CU_SERVICE_LOCATIONS.SERV_STR_SFIX | |
CDL_DIRECTION | Cardinal Direction | CU_SERVICE_LOCATIONS.SERV_STR_CDL_DIR | |
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 | ||
UDF1_NUM | User Defined Field 1 Number | ||
UDF2_NUM | User Defined Field 2 Number | ||
UDF3_NUM | User Defined Field 3 Number | ||
UDF4_NUM | User Defined Field 4 Number | ||
UDF5_NUM | User Defined Field 5 Number | ||
UDF6_NUM | User Defined Field 6 Number | ||
UDF7_NUM | User Defined Field 7 Number | ||
UDF8_NUM | User Defined Field 8 Number | ||
UDF9_NUM | User Defined Field 9 Number | ||
UDF10_NUM | User Defined Field 10 Number | ||
UDF1_DATE | User Defined Field 1 Date | ||
UDF2_DATE | User Defined Field 2 Date | ||
UDF3_DATE | User Defined Field 3 Date | ||
UDF4_DATE | User Defined Field 4 Date | ||
UDF5_DATE | User Defined Field 5 Date | ||
UDF6_DATE | User Defined Field 6 Date | ||
UDF7_DATE | User Defined Field 7 Date | ||
UDF8_DATE | User Defined Field 8 Date | ||
UDF9_DATE | User Defined Field 9 Date | ||
UDF10_DATE | User Defined Field 10 Date | ||
FLEXFIELD1 | Flex Field 1 | ||
FLEXFIELD2 | Flex Field 2 | ||
FLEXFIELD3 | Flex Field 3 | ||
FLEXFIELD4 | Flex Field 4 | ||
FLEXFIELD5 | Flex Field 5 | ||
FLEXFIELD6 | Flex Field 6 | ||
FLEXFIELD7 | Flex Field 7 | ||
FLEXFIELD8 | Flex Field 8 | ||
FLEXFIELD9 | Flex Field 9 | ||
FLEXFIELD10 | Flex Field 10 | ||
Data Load Attributes | |||
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_PER |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | CU_CUSTOMERS |
ODI Package | B1_PKG_CD_PER |
ETL View | B1_D_PER_VW |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
PER_KEY | Person Dimension Surrogate Key | Populated with the sequence from SPL_PER_SEQ.NEXT_VAL. | |
Natural Keys | |||
SRC_PER_ID | Person ID (Natural Key) | CU_CUSTOMERS.CUST_ID | |
Attributes | |||
BUSINESS_IND | Business Indicator Flag | ||
PER_INFO | Person Info String | CU_CUSTOMERS.CUST_NAME | |
PER_NAME | Person Name | CU_CUSTOMERS.CUST_NAME | |
PER_PHONE_NBR | Person Phone Number | CU_CUSTOMERS.CUST_HOME_PHONE CU_CUSTOMERS.CUST_HOME_AC | Populated with phone number in the (XXX) XXX-XXXX format. For example: (001) 775-0125) |
DAY_PHONE_NBR | Day Phone Number | CU_CUSTOMERS.CUST_DAY_AC CU_CUSTOMERS.CUST_DAY_PHONE CU_CUSTOMERS. CUST_DAY_PHONE_EX | Populated with phone number in the (YYY) YYY-YYYYxY format. For example: (330) 201-4858x1) |
User Defined Attributes | |||
UDF1_CD | User Defined Field 1 Code | ||
UDF1_DESCR | User Defined Field 1 Description | ||
UDF2_CD | User Defined Field 2 Code | ||
UDF2_DESCR | User Defined Field 2 Description | ||
UDF3_CD | User Defined Field 3 Code | ||
UDF3_DESCR | User Defined Field 3 Description | ||
UDF4_CD | User Defined Field 4 Code | ||
UDF4_DESCR | User Defined Field 4 Description | ||
UDF5_CD | User Defined Field 5 Code | ||
UDF5_DESCR | User Defined Field 5 Description | ||
UDF6_CD | User Defined Field 6 Code | ||
UDF6_DESCR | User Defined Field 6 Description | ||
UDF7_CD | User Defined Field 7 Code | ||
UDF7_DESCR | User Defined Field 7 Description | ||
UDF8_CD | User Defined Field 8 Code | ||
UDF8_DESCR | User Defined Field 8 Description | ||
UDF9_CD | User Defined Field 9 Code | ||
UDF9_DESCR | User Defined Field 9 Description | ||
UDF10_CD | User Defined Field 10 Code | ||
UDF10_DESCR | User Defined Field 10 Description | ||
UDF11_CD | User Defined Field 11 Code | ||
UDF11_DESCR | User Defined Field 11 Description | ||
UDF12_CD | User Defined Field 12 Code | ||
UDF12_DESCR | User Defined Field 12 Description | ||
UDF13_CD | User Defined Field 13 Code | ||
UDF13_DESCR | User Defined Field 13 Description | ||
UDF14_CD | User Defined Field 14 Code | ||
UDF14_DESCR | User Defined Field 14 Description | ||
UDF15_CD | User Defined Field 15 Code | ||
UDF15_DESCR | User Defined Field 15 Description | ||
UDF1_NUM | User Defined Field 1 Number | ||
UDF2_NUM | User Defined Field 2 Number | ||
UDF3_NUM | User Defined Field 3 Number | ||
UDF4_NUM | User Defined Field 4 Number | ||
UDF5_NUM | User Defined Field 5 Number | ||
UDF6_NUM | User Defined Field 6 Number | ||
UDF7_NUM | User Defined Field 7 Number | ||
UDF8_NUM | User Defined Field 8 Number | ||
UDF9_NUM | User Defined Field 9 Number | ||
UDF10_NUM | User Defined Field 10 Number | ||
UDF1_DATE | User Defined Field 1 Date | ||
UDF2_DATE | User Defined Field 2 Date | ||
UDF3_DATE | User Defined Field 3 Date | ||
UDF4_DATE | User Defined Field 4 Date | ||
UDF5_DATE | User Defined Field 5 Date | ||
UDF6_DATE | User Defined Field 6 Date | ||
UDF7_DATE | User Defined Field 7 Date | ||
UDF8_DATE | User Defined Field 8 Date | ||
UDF9_DATE | User Defined Field 9 Date | ||
UDF10_DATE | User Defined Field 10 Date | ||
FLEXFIELD1 | Flex Field 1 | ||
FLEXFIELD2 | Flex Field 2 | ||
FLEXFIELD3 | Flex Field 3 | ||
FLEXFIELD4 | Flex Field 4 | ||
FLEXFIELD5 | Flex Field 5 | ||
FLEXFIELD6 | Flex Field 6 | ||
FLEXFIELD7 | Flex Field 7 | ||
FLEXFIELD8 | Flex Field 8 | ||
FLEXFIELD9 | Flex Field 9 | ||
FLEXFIELD10 | Flex Field 10 | ||
Data Load Attributes | |||
DATA_LOAD_DTTM | Data Load Date/Time | Populated with the load timestamp value. | |
EFF_START_DTTM | Effective Start Date/Time | CU_CUSTOMERS.LAST_UPDATE_TIME | |
EFF_END_DTTM | Effective End Date/Time | CU_CUSTOMERS.LAST_UPDATE_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_PREM |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | CU_SERVICE_LOCATIONS |
ODI Package | B1_PKG_CD_PREM |
ETL View | B1_D_PREM_VW |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
PREM_KEY | Premise Dimension Surrogate Key | Populated with the sequence from SPL_PREM_SEQ.NEX T_VAL. | |
Natural Keys | |||
SRC_PREM_ID | Premise ID | CU_SERVICE_LOCATIONS.SERV_LOC_ID | |
Attributes | |||
PREM_INFO | Premise Info String | CU_SERVICE_LOCATIONS.SERV_LOC_ID | |
SERVICE_PRIORITY_ LVL | Service Priority Code | CU_SERVICE_LOCATIONS.SERV_PRIORITY | |
SERVICE_STATUS_CD | Service Status Code | CU_SERVICE_LOCATIONS. SERV_STATUS | |
COMMENTS | Comments | CU_SERVICE_LOCATIONS. SERV_COMMENT | |
MAP_LOC_X | Map Location X | CU_SERVICE_LOCATIONS. SERV_MAP_LOC_X | |
MAP_LOC_Y | Map Location Y | CU_SERVICE_LOCATIONS. SERV_MAP_LOC_Y | |
SERVICE_TYPE_CD | Service Type Code | CU_SERVICE_LOCATIONS. SERV_TYPE | |
LIFE_SUPPORT_CD | Life Support Code | CU_SERVICE_LOCATIONS.SERV_LIFE_SUPPORT | |
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 13Code | ||
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 15Code | ||
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 17Code | ||
UDF17_DESCR | User Defined Field 17 Description | ||
UDF18_CD | User Defined Field 18 Code | ||
UDF18_DESCR | User Defined Field 18 Description | ||
UDF1_NUM | User Defined Field 1 Number | ||
UDF2_NUM | User Defined Field 2 Number | ||
UDF3_NUM | User Defined Field 3 Number | ||
UDF4_NUM | User Defined Field 4 Number | ||
UDF5_NUM | User Defined Field 5 Number | ||
UDF6_NUM | User Defined Field 6 Number | ||
UDF7_NUM | User Defined Field 7 Number | ||
UDF8_NUM | User Defined Field 8 Number | ||
UDF9_NUM | User Defined Field 9 Number | ||
UDF10_NUM | User Defined Field 10 Number | ||
UDF1_DATE | User Defined Field 1 Date | ||
UDF2_DATE | User Defined Field 2 Date | ||
UDF3_DATE | User Defined Field 3 Date | ||
UDF4_DATE | User Defined Field 4 Date | ||
UDF5_DATE | User Defined Field 5 Date | ||
UDF6_DATE | User Defined Field 6 Date | ||
UDF7_DATE | User Defined Field 7 Date | ||
UDF8_DATE | User Defined Field 8 Date | ||
UDF9_DATE | User Defined Field 9 Date | ||
UDF10_DATE | User Defined Field 10 Date | ||
FLEXFIELD1 | Flex Field 1 | ||
FLEXFIELD2 | Flex Field 2 | ||
FLEXFIELD3 | Flex Field 3 | ||
FLEXFIELD4 | Flex Field 4 | ||
FLEXFIELD5 | Flex Field 5 | ||
FLEXFIELD6 | Flex Field 6 | ||
FLEXFIELD7 | Flex Field 7 | ||
FLEXFIELD8 | Flex Field 8 | ||
FLEXFIELD9 | Flex Field 9 | ||
FLEXFIELD10 | Flex Field 10 | ||
Data Load Attributes | |||
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_USER |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | CES_USER |
ODI Package | B1_PKG_CD_USER |
ETL View | B1_D_USER_VW |
Target Field | Description | Source Field | Transformation Logic |
---|---|---|---|
Surrogate Key | |||
USER_KEY | User Dimension Surrogate Key | Populated with the sequence from SPL_USER_SEQ.NEXT_ VAL. | |
Natural Keys | |||
There are no natural keys in this dimension. | |||
Attributes | |||
USER_CD | User Code (Natural Key) | CES_USER.USER_NAME | |
USER_DESCR | User Description | CES_USER.FULL_NAME | If null, this field 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. | |
EFF_START_DTTM | Effective Start Date/Time | CES_USER.LAST_UPDATE_TIME | |
EFF_END_DTTM | Effective End Date/Time | CES_USER.LAST_UPDATE_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. |