DW_EB_X_EBS_COMMON_W_EMPLOYEE_D

DW_EB_X_EBS_COMMON_W_EMPLOYEE_D stores information about employees belonging to this organization as well as its extended organization. The concept of the extended organization would take care of contractors, third party organizations and other non-employees who help us to run our business. The grain of this table is at an employee" level. This table is designed to be a slowly/moderately changing dimension that supports Type-2 changes out of the box. In other words, this is the employee master list. Actual employees are differentiated from others by the EMP_FLG column with possible values 'Y' or 'N'. Each of the employees (of our organization or the extended one) can play various roles while helping us run business. Out of the box, we support the following roles: Service Rep, Sales Rep, Account Rep, Purchase Rep, Buyer, Requestor, Contact Rep. Each of these roles are identified by their corresponding flags, with possible values 'Y' or 'N'

Details

Module: Common Tables (EBS_COMMON)

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
Name	Datatype	Length	Precision	Not Null	Comments	Referred Table
ROW_WID	NUMBER		38	True	Surrogate Key of the Table
ACCOUNT_REP_FLG	VARCHAR2	1 CHAR			Employee Account Representative Flag
ADDRESS_LINE_1	VARCHAR2	240 CHAR			Permanent Street Address Line 1
ADDRESS_LINE_2	VARCHAR2	240 CHAR			Permanent Street Address Line 2
ADDRESS_LINE_3	VARCHAR2	240 CHAR			Permanent Street Address Line 3
ADDRESS_LINE_4	VARCHAR2	240 CHAR			Permanent Street Address Line 4
ADDR_EFF_DATE	TIMESTAMP		6		Permanent address effective date.
ADJ_SERVICE_DT	TIMESTAMP		6		Adjusted Service Date
ADJ_SERVICE_DT_WID	NUMBER		38		Adjusted Service Date Surrogate Key
ALTERNATE_EMAIL_ADDR	VARCHAR2	240 CHAR			Alternate Email Address
ALT_EMP_NUM	VARCHAR2	80 CHAR			Alternate Employee Number
APPLICANT_FLG	VARCHAR2	1 CHAR			Applicant flag
APPLICANT_NUM	VARCHAR2	80 CHAR			Employee Applicant Number
APPR_AUTH	NUMBER		28,10		Approval Authority Amount
APPR_AUTH_CAT_CODE	VARCHAR2	50 CHAR			Approval Authority Category Code
APPR_CURCY_CD	VARCHAR2	30 CHAR			Approval Currency Code
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
AUX6_CHANGED_ON_DT	TIMESTAMP		6
BUYER_FLG	VARCHAR2	1 CHAR			Buyer Flag
BUYER_ID	VARCHAR2	34 CHAR
CASHIER_FLG	VARCHAR2	1 CHAR			Casher flag
CHANGED_BY_WID	NUMBER		38		Source Record Last Modified By User Surrogate Key. It comes from User model on the source systems
CHANGED_ON_DT	TIMESTAMP		6		Source Record Last Modified Date and Time
CITY	VARCHAR2	120 CHAR			Permanent City Code
CONTACT_REP_FLG	VARCHAR2	1 CHAR			Contact Representative Flag
CONTACT_TYPE_CODE	VARCHAR2	30 CHAR
CONTINGENT_WORKER_NUM	VARCHAR2	80 CHAR			Worker number for contingent workers or contractors assigned by the deploying company.
CONTRACT_END_DT	TIMESTAMP		6		Contract End Date
CONTRACT_END_DT_WID	NUMBER		38		Contract End Date Surrogate Key
CONTRACT_ST_DT	TIMESTAMP		6		Contract Start Date
CONTRACT_ST_DT_WID	NUMBER		38		Contract Start Date Surrogate Key
COUNTRY	VARCHAR2	120 CHAR			Permanent Country Code
COUNTRY_REGION_CODE	VARCHAR2	120 CHAR			Permanent country region code.
COUNTY	VARCHAR2	150 CHAR			Permanent County Code
CREATED_BY_WID	NUMBER		38		Source record created by user surrogate key. It comes from User model on the source systems
CREATED_ON_DT	TIMESTAMP		6		Source Record Creation Date and Time
CURRENT_FLG	VARCHAR2	1 CHAR			Current Record Indicator
C_APPR_AUTH_CAT_CODE	VARCHAR2	50 CHAR			customer defined Approval Authority Category Code
C_CITY_CODE	VARCHAR2	120 CHAR			Customer defined code for Permanent City
C_COUNTRY_REGION_CODE	VARCHAR2	120 CHAR			Customer defined code for Permanent country region.
C_COUNTY_CODE	VARCHAR2	120 CHAR			Customer defined code for Permanent County
C_MAIL_CITY_CODE	VARCHAR2	120 CHAR			customer defined mail city code
C_MAIL_COUNTRY_REGION_CODE	VARCHAR2	120 CHAR			customer defined mail country region code
C_MAIL_COUNTY_CODE	VARCHAR2	120 CHAR			customer defined mail county code
C_MAIL_REGION_CODE	VARCHAR2	120 CHAR			customer defined mail region code
C_MAIL_STATE_PROV_CODE	VARCHAR2	120 CHAR			customer defined mail state province code
C_REGION_CODE	VARCHAR2	120 CHAR			Customer defined code for Permanent Region.
C_STATE_PROV_CODE	VARCHAR2	120 CHAR			Customer defined code for permanent state or provience.
C_WORK_CITY_CODE	VARCHAR2	120 CHAR			Customer defined work city code
C_WORK_COUNTRY_REGION_CODE	VARCHAR2	120 CHAR			customer defined work country region code
C_WORK_COUNTY_CODE	VARCHAR2	120 CHAR			customer defined work county code
C_WORK_REGION_CODE	VARCHAR2	120 CHAR			Customer defined wrok region code
C_WORK_STATE_PROV_CODE	VARCHAR2	120 CHAR			customer defined work state province code
DATASOURCE_NUM_ID	NUMBER		10		Source Identifier	DW_EB_X_EBS_COMMON_W_POSITION_D
DELETE_FLG	VARCHAR2	1 CHAR			Deleted Record Indicator
DEPARTMENT_CODE	VARCHAR2	50 CHAR			Employee's department Code
EFFECTIVE_FROM_DT	TIMESTAMP		6		Effective From Date and Time
EFFECTIVE_TO_DT	TIMESTAMP		6		Effective To Date and Time with a default value
EMAIL_ADDR	VARCHAR2	240 CHAR			Email Address
EMPLOYEE_NUM	VARCHAR2	80 CHAR			Employee Number
EMP_ACCNT	VARCHAR2	100 CHAR			Employee Account
EMP_ACCNT_BU	VARCHAR2	100 CHAR			Employee Account Business Unit Name. The business unit to which the employee belongs.
EMP_ACCNT_LOC	VARCHAR2	50 CHAR			Employee Account Location. The location of the business entity with which the employee is associated.
EMP_ACTIVE_FLG	VARCHAR2	1 CHAR			Employee Active Flag
EMP_FLG	VARCHAR2	1 CHAR			Employee Flag
EMP_FORMED_DT	TIMESTAMP		6		Employee record Formed on Date
EMP_HIRE_DT	TIMESTAMP		6		Employee Hire Date
EMP_HIRE_DT_WID	NUMBER		38		Employee Hire Date Surrogate Key
ETL_PROC_WID	NUMBER		38		ETL Process Identifier
FAX_PH_NUM	VARCHAR2	60 CHAR			Fax Phone Number
FST_NAME	VARCHAR2	150 CHAR			First Name
FULL_NAME	VARCHAR2	400 CHAR			Employee's Full Name
HELD_POSTN	VARCHAR2	50 CHAR			Held Position
INDV_TITLE	VARCHAR2	30 CHAR			Employee's individual title
INTEGRATION_ID	VARCHAR2	80 CHAR			Unique Source Record Identifier	DW_EB_X_EBS_COMMON_W_POSITION_D
JOB_CATEGORY_CODE	VARCHAR2	50 CHAR			Employee job Category Code
JOB_TITLE	VARCHAR2	700 CHAR			Employee job Title
LAST_NAME	VARCHAR2	150 CHAR			Employee Last Name
LAST_WORKED_DT	TIMESTAMP		6
LEGISLATION_CODE	VARCHAR2	150 CHAR			Employee Legislation Code
LOGIN	VARCHAR2	100 CHAR			Employee Login
LOW_EFFECTIVE_FROM_DT	TIMESTAMP		6
MAIL_ADDRESS_LINE_1	VARCHAR2	240 CHAR			Mail Street Address Line 1
MAIL_ADDRESS_LINE_2	VARCHAR2	240 CHAR			Mail Street Address Line 2
MAIL_ADDRESS_LINE_3	VARCHAR2	240 CHAR			Mail Street Address Line 3
MAIL_ADDRESS_LINE_4	VARCHAR2	240 CHAR			Mail Street Address Line 4
MAIL_ADDR_EFF_DATE	TIMESTAMP		6		mail address effective date
MAIL_CITY_CODE	VARCHAR2	120 CHAR			Employee mail city code
MAIL_COUNTRY	VARCHAR2	120 CHAR			mail country code
MAIL_COUNTRY_REGION_CODE	VARCHAR2	120 CHAR			mail country region code
MAIL_COUNTY	VARCHAR2	120 CHAR			Employee mail county code
MAIL_POST_OFFICE_BOX	VARCHAR2	30 CHAR			Employee mail post office box
MAIL_REGION_CODE	VARCHAR2	120 CHAR			Employee mail region code
MAIL_STATE_PROV_CODE	VARCHAR2	120 CHAR			mail state province code
MAIL_ZIPCODE	VARCHAR2	50 CHAR			Employee mail zipcode
MANAGER_FLG	VARCHAR2	1 CHAR			Manager flag
MID_NAME	VARCHAR2	80 CHAR			Middle Name
MOBILE_NUM	VARCHAR2	60 CHAR			Mobile Number
NAME_EFF_DATE	TIMESTAMP		6		Name Effective Date
NAME_PREFIX	VARCHAR2	150 CHAR			Employee Name Prefix
NAME_SUFFIX	VARCHAR2	80 CHAR			Employee Name Suffix
NATIVE_LANG_CODE	VARCHAR2	50 CHAR			Native Language Code
ORIG_HIRE_DT	TIMESTAMP		6		Original Hire Date
ORIG_HIRE_DT_WID	NUMBER		38		Original Hire Date Surrogate Key
PAGER_NUM	VARCHAR2	60 CHAR			Pager Number
PARTNER_FLG	VARCHAR2	1 CHAR			Partner relationship indicator
PARTY_ID	VARCHAR2	18 CHAR			A unique identiifer that uniquely identifies each person. This ID comes from the party model on the source systems.
PAR_HELD_POSTN	VARCHAR2	50 CHAR			Parent Held Position
PAR_INTEGRATION_ID	VARCHAR2	80 CHAR			Parent Integration Identifier
POSITION_TYPE_CODE	VARCHAR2	50 CHAR			Employee position Type Code
POST_OFFICE_BOX	VARCHAR2	30 CHAR			Permanent Post office box no.
PREV_LAST_NAME	VARCHAR2	150 CHAR			Employee's previous last name.
PROJ_MGR_FLG	VARCHAR2	1 CHAR
PR_POSTN	VARCHAR2	50 CHAR			Primary Position
PURCHASE_REP_FLG	VARCHAR2	1 CHAR			Purchase Representative Flag
REGION_CODE	VARCHAR2	120 CHAR			Permanent Region Code.
REQUESTOR_FLG	VARCHAR2	1 CHAR			Requestor Flag
REQUESTOR_ID	VARCHAR2	34 CHAR
RES_PRI_ORGANIZATION_CODE	VARCHAR2	255 CHAR			This is the organization code representing the primary organization of a CRM resource.
SALES_REP_FLG	VARCHAR2	1 CHAR			Sales Representative Flag
SCD1_WID	NUMBER		38
SEC_FLU_LANG_CODE	VARCHAR2	50 CHAR			Second Proficient Language Code
SERVICE_REP_FLG	VARCHAR2	1 CHAR			Service Representative Flag
SPOUSE_NAME	VARCHAR2	80 CHAR			Employee's Spouse Name
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	150 CHAR			Permanent state or provience code.
SUPERVISOR_NAME	VARCHAR2	255 CHAR			Supervisor's Name
SUPERVISOR_NUM	VARCHAR2	80 CHAR			Supervisor's Employee Number
TENANT_ID	VARCHAR2	80 CHAR			Tenant Identifier
THR_FLU_LANG_CODE	VARCHAR2	50 CHAR			Other Proficient Language Code
USER_FLG	VARCHAR2	1 CHAR			Employee User Flag
VIS_PR_BU_ID	VARCHAR2	15 CHAR			Primary Buisness Unit Id for Visibility(For internal use only.)
VIS_PR_POSTN_DH_WID	NUMBER		38		Position Hierarchy Surrogate Key This column is a foreign key to DW_EB_X_EBS_COMMON_W_POSITION_DH and stores the ROW_WID of DW_EB_X_EBS_COMMON_W_POSITION_DH. It is for security implementation.	DW_EB_X_EBS_COMMON_W_POSITION_DH
VIS_PR_POS_ID	VARCHAR2	80 CHAR			Primary Postition Id For Visibility(For internal use only.)
WEB_ADDRESS	VARCHAR2	255 CHAR			Web Page Address
WORK_ADDRESS_LINE_1	VARCHAR2	240 CHAR			Employee work address line 1
WORK_ADDRESS_LINE_2	VARCHAR2	240 CHAR			Employee work address line 2
WORK_ADDRESS_LINE_3	VARCHAR2	240 CHAR			Employee work address line 3
WORK_ADDRESS_LINE_4	VARCHAR2	240 CHAR			Employee work address line 4
WORK_ADDR_EFF_DATE	TIMESTAMP		6		Employee work address effective date
WORK_CITY	VARCHAR2	120 CHAR			Employee work city
WORK_COUNTRY	VARCHAR2	120 CHAR			Employee work country
WORK_COUNTRY_REGION_CODE	VARCHAR2	120 CHAR			Employee work country region code
WORK_COUNTY	VARCHAR2	120 CHAR			Employee work county
WORK_PHONE	VARCHAR2	60 CHAR			Work Phone Number
WORK_POST_OFFICE_BOX	VARCHAR2	30 CHAR			Employee work post office box
WORK_REGION_CODE	VARCHAR2	120 CHAR			Employee work region code
WORK_STATE_PROV_CODE	VARCHAR2	120 CHAR			Employee work state province code
WORK_ZIPCODE	VARCHAR2	50 CHAR			Employee work zipcode
W_COUNTRY_CODE	VARCHAR2	120 CHAR			Warehouse code for Permanent Country.
X_CUSTOM	VARCHAR2	10 CHAR			Generic Extension Column
ZIPCODE	VARCHAR2	50 CHAR			Permanent zipcode.
W$_INSERT_DT	TIMESTAMP		6
W$_UPDATE_DT	TIMESTAMP		6