Property | Value |
Target Table | CD_ADDR |
Table Type | Dimension |
SCD Type | Type 2 |
Source System Driver Table | D1_SP |
Stage Table | STG_CD_ADDR |
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 | This field is populated from the SPL_ADDR_SEQ sequence. | |
Natural Keys | |||
SRC_ADDR_ID | Service Point ID | D1_SP.D1_SP_ID | |
Attributes | |||
ADDR_LINE1 | Address Line 1 | D1_SP.ADDRESS1 | |
ADDR_LINE2 | Address Line 2 | D1_SP.ADDRESS2 | |
ADDR_LINE3 | Address Line 3 | D1_SP.ADDRESS3 | |
ADDR_LINE4 | Address Line 4 | D1_SP.ADDRESS4 | |
ADDR_INFO | Address | D1_SP. ADDRESS1 D1_SP.CITY D1_SP.STATE D1_SP.POSTAL | This field is a concatenation of address, city, state, and postal code, separated by comma. |
CITY | City | D1_SP.CITY_UPPER | |
COUNTY | County | D1_SP.COUNTY | |
POSTAL | Postal Code | D1_SP. POSTAL | |
STATE_DESCR | State Description | CI_STATE_L.DESCR | |
COUNTRY_DESCR | Country Description | CI_COUNTRY_L.DESCR | |
GEO_CODE | Geographical Code | D1_SP.GEO_CODE | |
CROSS_STREET | Cross Street | Note: This field is populated only for the Oracle Utilities Mobile Workforce Management source product. | |
SUBURB | Suburb | Note: This field is populated only for the Oracle Utilities Mobile Workforce Management source product. | |
User Defined Attributes | |||
UDF1_CD | City Code | D1_SP.CITY_UPPER | |
UDF1_DESCR | City Description | D1_SP.CITY_UPPER | |
UDF2_CD | County Code | D1_SP.COUNTY | |
UDF2_DESCR | County Code | D1_SP.COUNTY | |
UDF3_CD | Postal Code | D1_SP.POSTAL | |
UDF3_DESCR | Postal Code | D1_SP.POSTAL | |
UDF4_CD | State Code | D1_SP.STATE | |
UDF4_DESCR | State Description | CI_STATE_L.DESCR | |
UDF5_CD | Country Code | D1_SP.COUNTRY | |
UDF5_DESCR | Country Description | CI_COUNTRY_L.DESCR | |
UDF6_CD | Geo Code Value | D1_SP.GEO_CODE | |
UDF6_DESCR | Geo Code Description | D1_SP.GEO_CODE | |
UDF7_CD | Premise Char 1 Code | ||
UDF7_DESCR | Premise Char 1 Description | ||
UDF8_CD | Premise Char 2 Code | ||
UDF8_DESCR | Premise Char 2 Description | ||
UDF9_CD | Premise Char 3 Code | ||
UDF9_DESCR | Premise Char 3 Description | ||
UDF10_CD | Premise Char 4 Code | ||
UDF10_DESCR | Premise Char 4 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 | |||
EFF_END_DTTM | Effective End Date/Time | ||
EFF_START_DTTM | Effective Start Date/Time | ||
DATA_LOAD_DTTM | Data Load Date/Time | This field is populated with the load timestamp value. | |
DATA_SOURCE_IND | Data Source Indicator | CI_INSTALLATION.ENV_ID | This field is populated with the DSI value on the source product instance configuration. The table is populated as part of the initial setup and the DSI value is extracted from the environment ID of the source system. |
JOB_NBR | Job Number | This field is populated with the ODI job execution session number. |