Shared Dimensions
Shared dimensions are used and populated in the star schemas of other source products as well. The data source indicator (DSI) column is used to identify which records are owned by which source product.
The list of shared dimensions in Oracle Utilities Network Management System is as follows:
• Fields
• User
Account
Contains the account data from service locations in the source system.
Properties
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
Fields
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.
 
Address
Retrieves data from service locations in the source system.
Properties
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
Fields
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.
 
Person
Extracts person data from the source system with all related attributes.
Properties
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
 
Fields
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.
 
Premise
Extracts premise information from CU_SERVICE_LOCATIONS table in the Network Management System source database.
Properties
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
 
 
Fields
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.
 
User
Extracts the details of all users from the Network Management System source database.
Properties
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
Fields
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.