DW_EB_X_EBS_COMMON_W_USER_D

DW_EB_X_EBS_COMMON_W_USER_D dimension table contains information about users who created or modified records in the source system, from which the rows have been extracted. It has the contact and location information about the users. Since such a user can be potentially an Employee as well as Contractor, qualifying flags are also present in this table for informational purposes.The grain of this table is at a single 'User' level. This table is designed to be a slowly/moderately changing dimension that supports Type-2 changes out of the box

Details

Module: Common Tables (EBS_COMMON)

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
Name	Datatype	Length	Precision	Comments
DATASOURCE_NUM_ID	NUMBER		28	Source Identifier
EFFECTIVE_FROM_DT	TIMESTAMP		6	Effective From Date and Time
INTEGRATION_ID	VARCHAR2	80 CHAR		Unique Source Record Identifier
ACTIVE_FLG	VARCHAR2	1 CHAR		Active Flag
ADDRESS_LINE_1	VARCHAR2	240 CHAR		Street Address
ADDRESS_LINE_2	VARCHAR2	240 CHAR		Street Address
ADDRESS_LINE_3	VARCHAR2	240 CHAR		Street Address
ADDRESS_LINE_4	VARCHAR2	240 CHAR		Street Address
ADDR_EFF_DATE	TIMESTAMP		6	Address Effective Date
ALTERNATE_EMAIL_ADDR	VARCHAR2	255 CHAR		Alternate Email Address
AUX1_CHANGED_ON_DT	TIMESTAMP		6	Auxiliary Source Table Last Modified Date and Time1
AUX2_CHANGED_ON_DT	TIMESTAMP		6	Auxiliary Source Table Last Modified Date and Time2
AUX3_CHANGED_ON_DT	TIMESTAMP		6	Auxiliary Source Table Last Modified Date and Time3
AUX4_CHANGED_ON_DT	TIMESTAMP		6	Auxiliary Source Table Last Modified Date and Time4
AUX5_CHANGED_ON_DT	TIMESTAMP		6	Auxiliary Source Table Last Modified Date and Time5
AUX6_CHANGED_ON_DT	TIMESTAMP		6	Auxiliary Source Table Last Modified Date and Time6
AUX7_CHANGED_ON_DT	TIMESTAMP		6	Auxiliary Source Table Last Modified Date and Time7
CHANGED_BY_WID	NUMBER		38	Source Record Last Modified By User Surrogate Key
CHANGED_ON_DT	TIMESTAMP		6	Source Record Last Modified Date and Time
CITY_CODE	VARCHAR2	120 CHAR		City
CONTRACTOR_FLG	VARCHAR2	1 CHAR		Contractor Flag
COUNTRY_CODE	VARCHAR2	120 CHAR		Country
COUNTRY_REGION_CODE	VARCHAR2	120 CHAR		Country Region
COUNTY_CODE	VARCHAR2	120 CHAR		County
CREATED_BY_WID	NUMBER		38	Source Record Created By User Surrogate Key
CREATED_ON_DT	TIMESTAMP		6	Source Record Creation Date and Time
CURRENT_FLG	VARCHAR2	1 CHAR		Current Record Indicator
C_CITY_CODE	VARCHAR2	120 CHAR
C_COUNTRY_REGION_CODE	VARCHAR2	120 CHAR
C_COUNTY_CODE	VARCHAR2	120 CHAR
C_REGION_CODE	VARCHAR2	120 CHAR
C_STATE_PROV_CODE	VARCHAR2	120 CHAR
DELETE_FLG	VARCHAR2	1 CHAR		Deleted Record Indicator
DEPARTMENT_CODE	VARCHAR2	50 CHAR		Department
EFFECTIVE_TO_DT	TIMESTAMP		6	Effective To Date and Time
EMP_FLG	VARCHAR2	1 CHAR		Employee Flag
ETL_PROC_WID	NUMBER		38	ETL Process Identifier
FAX_NUM	VARCHAR2	60 CHAR		Fax Number
FIRST_NAME	VARCHAR2	255 CHAR		First Name
FULL_NAME	VARCHAR2	400 CHAR		Full Name
LAST_NAME	VARCHAR2	255 CHAR		Last Name
LOGIN	VARCHAR2	255 CHAR		Login
MID_NAME	VARCHAR2	255 CHAR		Middle Name
MOBILE_PHONE_NUM	VARCHAR2	60 CHAR		Mobile Number
NAME_EFF_DATE	TIMESTAMP		6	Name Effective Date
NAME_PREFIX	VARCHAR2	50 CHAR		Name Prefix
NAME_SUFFIX	VARCHAR2	50 CHAR		Name Suffix
PAGER_NUM	VARCHAR2	60 CHAR		Pager Number
POST_OFFICE_BOX	VARCHAR2	30 CHAR		Post Office Box
PRIMARY_EMAIL_ADDR	VARCHAR2	255 CHAR		Primary Email Address
REGION_CODE	VARCHAR2	120 CHAR		Region
ROW_WID	NUMBER		38	Surrogate Key of the Table.
SEX_MF_CODE	VARCHAR2	50 CHAR		Sex M/F Code
SRC_EFF_FROM_DT	TIMESTAMP		6	Source Supplied Effective From Date and Time
SRC_EFF_TO_DT	TIMESTAMP		6	Source Supplied Effective To Date and Time
STATE_PROV_CODE	VARCHAR2	120 CHAR		State
SUPERVISOR_NAME	VARCHAR2	255 CHAR		Supervisor Name
TENANT_ID	VARCHAR2	80 CHAR		Tenant Identifier
USER_FORMED_DT	TIMESTAMP		6	User Formed Date
WEB_ADDRESS	VARCHAR2	255 CHAR		Web Page Address
WORK_PHONE_NUM	VARCHAR2	60 CHAR		Work Phone
W_COUNTRY_CODE	VARCHAR2	120 CHAR
X_CUSTOM	VARCHAR2	10 CHAR		Generic Extension Column
ZIPCODE	VARCHAR2	50 CHAR		Zipcode
W$_INSERT_DT	TIMESTAMP		6
W$_UPDATE_DT	TIMESTAMP		6