Data Dictionary –Organization Structure

Table Name: dept_compy_tmp

Purpose:	Competency Codes temporary table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	GUID generated for the Session	Yes	HrGuid
compy_code	nvarchar(10)	NOT NULL	Compensation OU Code Interacting with ORGST OU Code (Found thru CIM)	Yes	hrcompcode

Table Name: empinou_tmp

Purpose:	Employment OU Code, Desc temporary table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	GUID generated for the Session	No	HrGuid
empin_ou_code	int	NOT NULL	EMPIN OU Code Interacting with ORGST OU Code (Found thru CIM)	No	HrOUInstance
empin_desc	nvarchar(40)	NULL	EMPIN OU Description Interacting with ORGST OU Code (Found thru CIM)	No	OUDesc

Table Name: hros_annual_elt_dtl

Purpose:	In this detail table we can store Work Location, Grade Set, Grade wise employee salary information with pay element breakup
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
empin_ou	int	NOT NULL	Empin OU as selected by the user in the EMPIN OU combo.	Yes	HrOUInstance
master_ou_code	int	NOT NULL	ORGST OU as selected by the user in the ORGST OU combo.	Yes
gset_code	nvarchar(5)	NOT NULL	Grade Set code as selected by the user in the Grade set combo.	Yes	HrCode
grade_code	nvarchar(5)	NOT NULL	Grade code as entered by the user in the grade combo.	Yes
wlocn_code	nvarchar(5)	NOT NULL	Work Location code as entered by the user in the Work Location combo.	Yes
effective_from_date	datetime	NOT NULL	Effective from date for history records	Yes	Datetime
element_code_qc	nvarchar(5)	NOT NULL	Pay element code for salary details	Yes	HrQuickCode
effective_to_date	datetime	NULL	Effective to date for history records	No	Datetime
annual_value	numeric(15,4)	NULL	Annual value for the pay element	No	HrSalary

Table Name: hros_annual_elt_dtl_tmp

Purpose:	Annual salary computation temp table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	ORGST OU as selected by the user in the ORGST OU combo.	Yes	HrOUInstance
empin_ou	INT	NOT NULL	Empin OU as selected by the user in the EMPIN OU combo.	Yes	HrOUId
gset_code	nvarchar(5)	NOT NULL	Grade Set code as selected by the user in the Grade set combo.	Yes	HrCode
grade_code	nvarchar(5)	NOT NULL	Grade code as entered by the user in the grade combo.	Yes
wlocn_code	nvarchar(5)	NOT NULL	Work Location code as entered by the user in the Work Location combo.	Yes
element_code_qc	nvarchar(5)	NOT NULL	Payelement Quick Code	Yes	HrQuickCode
guid	nvarchar(40)	NOT NULL	Guid that is generated for the session.	Yes	HrGuid
effective_from_date	datetime	NOT NULL	Effective from date for history records	No	Datetime
effective_to_date	datetime	NULL	Effective to date for history records	No
annual_value	numeric(15,4)	NULL	Annual value for the payelement	No	HrSalary

Table Name: hros_confnotice_dtl

Purpose:	Confirmation details table. In this table we can store the details of confirmation information grade set wise, grade wise, location wise, department wise and division wise
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_ou_code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
Department_Code	nvarchar(10)	NOT NULL	Department Code as entered by the user.	Yes	HrCd
Work_Location_Code	nvarchar(5)	NOT NULL	Work Location Code as entered by the user.	Yes	HrQuickCode
Division_Status_Code	nvarchar(5)	NOT NULL	Divisional Status as selected in the Divisional status combo.(Dept with the type_code as DIVS will be populated in the divisional Status combo)	Yes
Gset_Code	nvarchar(5)	NOT NULL	Gradeset Code as entered by the user.	Yes	HrCode
Grade_Code	nvarchar(5)	NOT NULL	Grade code as entered by the user.	Yes
Effective_From_Date	datetime	NOT NULL	Effective From Date as entered by the user.	Yes	Datetime
Sl_No	INT	NOT NULL	Generated automatically in increments of 1 when a new record is added in the multiline.	Yes	HrInt
Service_Type	nvarchar(5)	NULL	System defined quick code. BP = 'EPIN', PV = 'UNDN' For Eg> Days,Weeks,Months,Years,etc..	No	HrQuickCode
Service_From	INT	NULL	Service From as entered by the user.	No	HrInt
Service_To	INT	NULL	Service To as entered by the user.	No
Conf_Notice_Period	INT	NULL	Confirmation Notice as entered by the user.	No
Conf_Notice_Units	nvarchar(5)	NULL	System defined quick code. BP = 'EPIN', PV = 'UNDN' For Eg> Days,Weeks,Months,Years,etc..	No	HrQuickCode

Table Name: HROS_Dept_Compy_dtl

Purpose:	Department - EMPIN OU Code - Competency Code mapping details
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
dept_code	nvarchar(10)	NOT NULL	Department Code as entered by User (Stored in Upper Case)	Yes	HrCd
empin_ou_code	int	NOT NULL	EMPIN OU Code Interacting with ORGST OU Code (Found thru CIM)	Yes	HrOUInstance
competency_code	nvarchar(10)	NOT NULL	Competency Code as selected by the User for the Empin OU (available in Competency Component)	Yes	hrcompcode

Table Name: hros_dept_costcenter_dtl

Purpose:	Department Master Information (Effective Date wise) for every ORGST OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
dept_code	nvarchar(10)	NOT NULL	Department Code as entered by User (Stored in Upper Case)	Yes	HrCd
empin_ou_code	int	NOT NULL	EMPIN OU Code Interacting with ORGST OU Code (Found thru CIM)	Yes	HrOUInstance
effective_from_date	datetime	NOT NULL	Department Cost Center detail Effective from date for history	Yes	Datetime
effective_to_date	datetime	NOT NULL	Department Cost Center detail Effective to date for history	No
cost_center_code	nvarchar(10)	NOT NULL	Cost Center Code as selected by User for the Empin OU (available in Cost Center Component)	No	CostCenterCode

Table Name: HROS_Dept_Eff_Dtl

Purpose:	Department Master Information for every ORGST OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
dept_code	nvarchar(10)	NOT NULL	Department Code as entered by User (Stored in Upper Case)	Yes	HrCd
Effective_From_Date	datetime	NOT NULL	Department Effective From Date as entered by User	Yes	Datetime
Effective_To_Date	datetime	NULL	Department Effective To Date as entered by User	No
active_inactive_flag	nvarchar(3)	NOT NULL	Y if Department Code is Active, N if Inactive	No	HrFlag
process_type_qc	nvarchar(5)	NULL		No	HrQuickCode

Table Name: HROS_Dept_Hdr

Purpose:	Department Master Information for every ORGST OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
dept_code	nvarchar(10)	NOT NULL	Department Code as entered by User (Stored in Upper Case)	Yes	HrCd
Type_Code	nvarchar(5)	NULL	Department Type (Division, Department, Section and SubSection)	No	HrQuickCode
Applicable_To_Flag	nvarchar(3)	NOT NULL	'A' for Applicable to all EMPIN OUs; 'L' for Applicable to Login OU; 'S' for Applicable to Selective EMPIN OUs;	No	HrFlag
Login_OU_Code	int	NOT NULL	OU Code where ORGST Component is deployed and from where this page is launched	No	HrOUInstance

Table Name: HROS_Dept_Lang_Dtl

Purpose:	Department Master Information (Effective Date/Language Codewise) for every ORGST OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes
dept_code	nvarchar(10)	NOT NULL	Department Code as entered by User (Stored in Upper Case)	Yes	HrCd
Effective_From_Date	datetime	NOT NULL	Department Effective From Date as entered by User	Yes	Datetime
Language_Code	INT	NOT NULL	Language Code (1 if English) as selected in Language Combo	Yes	HrLangCd
dept_sdescription	nvarchar(30)	NULL	Department Short Description as entered by User	No	hrshortdesc12
u_dept_sdescription	nvarchar(30)	NULL	Department Short Description in UpperCase as entered by User	No
dept_ldescription	nvarchar(80)	NULL	Department Long Description as entered by User	No	hrdesc40
u_dept_ldescription	nvarchar(80)	NULL	Department Long Description in UpperCase as entered by User	No
dept_comment	nvarchar(2000)	NULL	Department Comment as entered by User	No	hrnotes

Table Name: HROS_Dept_OU_Map

Purpose:	Applicable EMPIN OU Codes for every Department Code, ORGST OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
dept_code	nvarchar(10)	NOT NULL	Department Code as entered by User (Stored in Upper Case)	Yes	HrCd
empin_ou_code	int	NOT NULL	EMPIN OU Code Interacting with ORGST OU Code (Found thru CIM)	Yes	HrOUInstance

Table Name: hros_dhierarchy_dept_dtl

Purpose:	Department Hierarchy Breakup Information (Effectivedate Wise, Languagewise) for every ORGST OU Code, Dept Hierarchy Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes
dhierarchy_code	nvarchar(10)	NOT NULL	Department Hierarchy Code as entered by User (Stored in Upper Case)	Yes	HrCd
effective_from_date	datetime	NOT NULL	Departmenty Hierarchy Effective From Date as entered by User	Yes	Datetime
place_under_code	nvarchar(10)	NOT NULL	Department code as created in Master, considered as root for the Dept Hierarchy	Yes	HrCd
rep_department_code	nvarchar(10)	NOT NULL	Reporting Department Code in the Department Hierarchy	Yes

Table Name: hros_dhierarchy_eff_dtl

Purpose:	Department Hierarchy Information (Effectivedate Wise) for every ORGST OU Code, Dept Hierarchy Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
dhierarchy_code	nvarchar(10)	NOT NULL	Department Hierarchy Code as entered by User (Stored in Upper Case)	Yes	HrCd
effective_from_date	datetime	NOT NULL	Departmenty Hierarchy Effective From Date as entered by User	Yes	Datetime
effective_to_date	datetime	NULL	Departmenty Hierarchy Effective To Date as entered by User	No
apex_department_code	nvarchar(10)	NOT NULL	Apex Department Code as created in Department Master	No	HrCd

Table Name: hros_dhierarchy_hdr

Purpose:	Department Hierarchy Information for every ORGST OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
dhierarchy_code	nvarchar(10)	NOT NULL	Department Hierarchy Code as entered by User (Stored in Upper Case)	Yes	HrCd
Primary_Flag	nvarchar(3)	NOT NULL	'Y' if this Department Hierarchy is Primary else 'N'	No	HrFlag
login_ou_code	int	NOT NULL	OU Code where ORGST Component is deployed and from where this page is launched	No	HrOUInstance

Table Name: hros_dhierarchy_lang_dtl

Purpose:	Department Hierarchy Information (Effectivedate Wise, Languagewise) for every ORGST OU Code, Dept Hierarchy Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes
dhierarchy_code	nvarchar(10)	NOT NULL	Department Hierarchy Code as entered by User (Stored in Upper Case)	Yes	HrCd
effective_from_date	datetime	NOT NULL	Departmenty Hierarchy Effective From Date as entered by User	Yes	Datetime
Language_Code	INT	NOT NULL	Language Code (1 if English) as selected in Language Combo	Yes	HrLangCd
dhierarchy_sdescription	nvarchar(30)	NULL	Department Hierarchy Short Description as entered by User	No	hrshortdesc12
u_dhierarchy_sdescription	nvarchar(30)	NULL	Department Hierarchy Short Description in UpperCase as entered by User	No
dhierarchy_ldescription	nvarchar(80)	NULL	Department Hierarchy Long Description as entered by User	No	hrdesc40
u_dhierarchy_ldescription	nvarchar(80)	NULL	Department Hierarchy Long Description in UpperCase as entered by User	No
dhierarchy_comments	nvarchar(2000)	NULL	Department Hierarchy Comments as entered by User	No	hrnotes

Table Name: hros_dhierarchy_tree_tmp

Purpose:	Department Hierarchy Breakup Information Temporary Table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	GUID generated for the Session	No	HrGuid
serial_number	INT	NOT NULL	Running Serial Number generated every time	No	HrInt
master_ou_code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	No	HrOUInstance
dhierarchy_code	nvarchar(10)	NOT NULL	Department Hierarchy Code as entered by User (Stored in Upper Case)	No	HrCd
place_under_code	nvarchar(10)	NOT NULL	Department Code as entered by User (Stored in Upper Case)	No
rep_department_code	nvarchar(10)	NOT NULL	Department Code as entered by User (Stored in Upper Case)	No
place_dept_emp_count	INT	NULL	Employee Count for this Place Under Department Code	No	HrInt
rep_dept_emp_count	INT	NULL	Employee Count for this Reporting Department Code	No
empname_p	nvarchar(77)	NULL		No	HrEmpName
empname_c	nvarchar(77)	NULL		No
empphoto_p	nvarchar(255)	NULL		No	HrText255
empphoto_c	nvarchar(255)	NULL		No

Table Name: HROS_Grade_Eff_Dtl

Purpose:	Grade Master Information (EffectiveDate wise) for every ORGST OU Code, Grade Set Code, Grade Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Effective_From_Date	datetime	NOT NULL	Grade Effective From Date as entered by User	Yes	Datetime
Effective_To_Date	datetime	NULL	Grade Effective To Date as entered by User	No
Active_Inactive_Flag	nvarchar(3)	NOT NULL	Y if Grade Code is Active, N if Inactive	No	HrFlag
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
Grade_Code	nvarchar(5)	NOT NULL	Grade Code as entered by User (Stored in Upper Case)	Yes	HrCode
gset_code	nvarchar(5)	NOT NULL	Grade Set Code as entered by User (Stored in Upper Case)	Yes

Table Name: HROS_Grade_Hdr

Purpose:	Grade Master Information for every ORGST OU Code, Grade Set Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
gset_code	nvarchar(5)	NOT NULL	Grade Set Code as entered by User (Stored in Upper Case)	Yes	HrCode
Grade_Code	nvarchar(5)	NOT NULL	Grade Code as entered by User (Stored in Upper Case)	Yes
Applicable_To_Flag	nvarchar(3)	NOT NULL	'A' for Applicable to all EMPIN OUs; 'L' for Applicable to Login OU; 'S' for Applicable to Selective EMPIN OUs;	No	HrFlag
Login_OU_Code	int	NOT NULL	OU Code where ORGST Component is deployed and from where this page is launched	No	HrOUInstance

Table Name: HROS_Grade_Lang_Dtl

Purpose:	Grade Master Information (EffectiveDatewise, Languagewise ) for every ORGST OU Code, Grade Set Code, Grade Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes
gset_code	nvarchar(5)	NOT NULL	Grade Set Code as entered by User (Stored in Upper Case)	Yes	HrCode
Grade_Code	nvarchar(5)	NOT NULL	Grade Code as entered by User (Stored in Upper Case)	Yes
Effective_From_Date	datetime	NOT NULL	Grade Effective From Date as entered by User	Yes	Datetime
Language_Code	INT	NOT NULL	Language Code (1 if English) as selected in Language Combo	Yes	HrLangCd
grade_sdescription	nvarchar(30)	NULL	Grade Short Description as entered	No	hrshortdesc12
u_grade_sdescription	nvarchar(30)	NULL	Grade Short Description (In Upper Case)	No
grade_ldescription	nvarchar(80)	NULL	Grade Long Description as entered	No	hrdesc40
u_grade_ldescription	nvarchar(80)	NULL	Grade Long Description (In Upper Case)	No
Grade_Comment	nvarchar(2000)	NULL	Grade Comments as entered	No	hrnotes

Table Name: HROS_Grade_OU_Map

Purpose:	Applicable EMPIN OU Codes for every ORGST OU Code, Grade Set Code, Grade Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
gset_code	nvarchar(5)	NOT NULL	Grade Set Code as entered by User (Stored in Upper Case)	Yes	HrCode
Grade_Code	nvarchar(5)	NOT NULL	Grade Code as entered by User (Stored in Upper Case)	Yes
empin_ou_code	int	NOT NULL	EMPIN OU Code Interacting with ORGST OU Code (Found thru CIM)	Yes	HrOUInstance

Table Name: hros_grade_scale_map

Purpose:	Applicable EMPIN OU Codes mapping for Grade Set, Grade, Scale Code, ORGST OU Code combination
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes
gset_code	nvarchar(5)	NOT NULL	Grade Set Code as entered by User (Stored in Upper Case)	Yes	HrCode
Grade_Code	nvarchar(5)	NOT NULL	Grade Code as entered by User (Stored in Upper Case)	Yes
empin_ou_code	int	NOT NULL	EMPIN OU Code Interacting with ORGST OU Code (Found thru CIM)	Yes	HrOUInstance
effective_from_date	datetime	NOT NULL	Grade - Scale Mapping Effective From Date as entered by User	Yes	Datetime
Scale_Code	nvarchar(5)	NULL	Scale Code as entered (Stored in Upper Case)	No	HrCode
effective_to_date	datetime	NULL	Grade - Scale Mapping Effective To Date as entered by User	No	Datetime
default_currency_code	nvarchar(5)	NOT NULL	Currency Code from Enterprise Modeller (In Upper Case)	No	HrCode

Table Name: HROS_GradeSet_Eff_Dtl

Purpose:	Grade Set Master Information (EffectiveDate wise) for every ORGST OU Code, Grade Set Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
gset_code	nvarchar(5)	NOT NULL	Grade Set Code as entered by User (Stored in Upper Case)	Yes	HrCode
Effective_From_Date	datetime	NOT NULL	Grade Set Effective From Date as entered by User	Yes	Datetime
Effective_To_Date	datetime	NULL	Grade Set Effective To Date as entered by User	No
Active_Inactive_Flag	nvarchar(3)	NOT NULL	Y if Grade Set Code is Active, N if Inactive	No	HrFlag

Table Name: HROS_GradeSet_Hdr

Purpose:	Grade Set Master Information for every ORGST OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
gset_code	nvarchar(5)	NOT NULL	Grade Set Code as entered by User (Stored in Upper Case)	Yes	HrCode
Applicable_To_Flag	nvarchar(3)	NOT NULL	'A' for Applicable to all EMPIN OUs; 'L' for Applicable to Login OU; 'S' for Applicable to Selective EMPIN OUs;	No	HrFlag
Login_OU_Code	int	NOT NULL	OU Code where ORGST Component is deployed and from where this page is launched	No	HrOUInstance

Table Name: HROS_GradeSet_Lang_Dtl

Purpose:	Grade Set Master Information (EffectiveDatewise, Languagewise ) for every ORGST OU Code, Grade Set Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes
gset_code	nvarchar(5)	NOT NULL	Grade Set Code as entered by User (Stored in Upper Case)	Yes	HrCode
Effective_From_Date	datetime	NOT NULL	Grade Set Effective From Date as entered by User	Yes	Datetime
Language_Code	INT	NOT NULL	Language Code (1 if English) as selected in Language Combo	Yes	HrLangCd
gset_sdescription	nvarchar(30)	NULL	Grade Set Short Description as entered by User	No	hrshortdesc12
u_gset_sdescription	nvarchar(30)	NULL	Grade Set Short Description as entered by User (in Upper Case)	No
gset_ldescription	nvarchar(80)	NULL	Grade Set Long Description as entered by User	No	hrdesc40
u_gset_ldescription	nvarchar(80)	NULL	Grade Set Long Description as entered by User (in Upper Case)	No
gset_comment	nvarchar(2000)	NULL	Grade Set Comments as entered by User	No	hrnotes

Table Name: HROS_gradeset_OU_Map

Purpose:	Applicable EMPIN OU Codes for every Grade Set Code, ORGST OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
gset_code	nvarchar(5)	NOT NULL	Grade Set Code as entered by User (Stored in Upper Case)	Yes	HrCode
empin_ou_code	int	NOT NULL	EMPIN OU Code Interacting with ORGST OU Code (Found thru CIM)	Yes	HrOUInstance

Table Name: hros_grd_sal_hdr

Purpose:	In this header table we can store Work Location, Grade Set, Grade wise employee salary information
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	ORGST OU Code Selected in the ORGST OU Combo	Yes
empin_ou	int	NOT NULL	Empin OU Code Selected in the EMPIN OU Combo	Yes
gset_code	nvarchar(5)	NOT NULL	Gradeset code as selected in the Gradeset combo.	Yes	HrCode
grade_code	nvarchar(5)	NOT NULL	Grade code as selected in the Grade combo.(The values in the grade combo will get populated for the Gradeset selected in the Gradeset combo).	Yes
wlocn_code	nvarchar(5)	NOT NULL	Work Location Code as selected in the Work Location combo.	Yes
effective_from_date	datetime	NOT NULL	The New Effective From Date entered by the user will be updated in Effective From date.	Yes	Datetime
effective_to_date	datetime	NULL	The Effective To Date will be updated as null for the first entry.For the subsequent entries the New Effective From Date - 1 will be the Effective To Date.	No
min_ctc_value	numeric(15,4)	NULL	Minimum Annual CTC as entered by the user.	No	HrSalary
max_ctc_value	numeric(15,4)	NULL	Maximum Annual CTC as entered by the user.	No
sal_comment	nvarchar(2000)	NULL	Comments as entered by the user.	No	hrnotes
payroll_master_ou	int	NOT NULL	Payroll Master OU	No	HrOUInstance
payroll_code	nvarchar(5)	NOT NULL	Payroll Code	No	HrCode
payset_code	nvarchar(10)	NULL	Payset Code	No	HrCd
ctc_amount	Numeric(15,4)	NULL	The ctc value will be stored here	No	hrsalary

Table Name: hros_month_pyelt_dtl

Purpose:	In this detail table we can store Work Location, Grade Set, Grade wise employee salary information with pay element breakup
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
empin_ou	int	NOT NULL	Empin OU as selected by the user in the EMPIN OU combo.	Yes	HrOUInstance
master_ou_code	int	NOT NULL	ORGST OU as selected by the user in the ORGST OU combo.	Yes
gset_code	nvarchar(5)	NOT NULL	Grade Set code as selected by the user in the Grade set combo.	Yes	HrCode
grade_code	nvarchar(5)	NOT NULL	Grade code as entered by the user in the grade combo.	Yes
wlocn_code	nvarchar(5)	NOT NULL	Work Location code as entered by the user in the Work Location combo.	Yes
effective_from_date	datetime	NOT NULL	The New Effective From Date entered by the user will be updated in Effective From date.	Yes	Datetime
pay_element_code	nvarchar(10)	NOT NULL	Pay Element Code as entered by the user.	Yes	HrCd
effective_to_date	datetime	NULL	The Effective To Date will be updated as null for the first entry.For the subsequent entries the New Effective From Date - 1 will be the Effective To Date.	No	Datetime
periodicity	nvarchar(5)	NULL	To store daily / Hourly / Weekly	No	HrQuickCode
month_value	numeric(15,4)	NULL	The value(amount) as entered by the user.	No	HrSalary
emp_level_qc	nvarchar(5)	NULL	System defined quick code. BP = 'GEN' PV = 'ADM' Eg> Yes,No	No	HrQuickCode
remarks	nvarchar(255)	NULL	Remarks as entered by the user.	No	Hrremarks
Amount_or_perc	Varchar(10)	NULL	Amount or percentage need to be captured	No	Hrcd
Pay_element_rule	Varchar(30)	NULL	If element is going to be calculated based on rule, then rule should be stored	No	Hrformula
derived_type_qc	Varchar(5)	NULL	Element value is calculated based on other element or accumulator need to captured here	No	Hrquickcode
derived_type_code	Varchar(10)	NULL	The element name or accumulator name need to be given here	No	Hrcd
emp_option_qc	Varchar(5)	NULL	The element will be set as optional based on the input given here	No	Hrquickcode
derived_value	Numeric(15,4)	NULL	The computed value based on the criteria given will be populated here	No	Hrsalary
prorate_allowed	Varchar(5)	NULL	Element value in payroll need to be prorated or not.	No	hrquickcode
lop	Varchar(5)	NULL	Element value depends upon lop or not need to be entered	No	Hrquickcode
grace_period	Numeric(5,2)	NULL	Total days of grace period allowed	No	Hrpercentage
unit	Varchar(5)	NULL	The total grace periods unit need to be mentioned here.	No	Hrquickcode
Flexible	Varchar(5)	NULL	Element is going to be fixed or flexible will be opted here	No	hrquickcode
Seqno	Int	NULL	Sequence number in which element should be calculated will be captured	No	hrint

Table Name: hros_month_pyelt_dtl_tmp

Purpose:	In this temp table we can store monthly pay element process information.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	ORGST OU as selected by the user in the ORGST OU combo.	Yes	HrOUInstance
gset_code	nvarchar(5)	NOT NULL	Grade Set code as selected by the user in the Grade set combo.	Yes	HrCode
grade_code	nvarchar(5)	NOT NULL	Grade code as entered by the user in the grade combo.	Yes
wlocn_code	nvarchar(5)	NOT NULL	Work Location code as entered by the user in the Work Location combo.	Yes
pay_element_code	nvarchar(10)	NOT NULL	Pay Element Code as entered by the user.	Yes	HrCd
guid	nvarchar(40)	NOT NULL	Guid that is generated for the session.	Yes	HrGuid
empin_ou	int	NOT NULL	Empin OU as selected by the user in the EMPIN OU combo.	Yes	HROUINSTANCE
effective_from_date	datetime	NOT NULL	The New Effective From Date entered by the user will be updated in Effective From date.	No	Datetime
effective_to_date	datetime	NULL	The Effective To Date will be updated as null for the first entry.For the subsequent entries the New Effective From Date - 1 will be the Effective To Date.	No
month_value	numeric(15,4)	NULL	The value(amount) as entered by the user.	No	HrSalary
emp_level_qc	nvarchar(5)	NULL	System defined quick code. BP = 'GEN' PV = 'ADM' Eg> Yes,No	No	HrQuickCode
periodicity	nvarchar(5)	NULL	To store daily / Hourly / Weekly	No
remarks	nvarchar(255)	NULL	Remarks as entered by the user.	No	Hrremarks
amount_or_perc	Varchar(10)	NULL	Amount or percentage need to be captured	No	Hrcd
pay_element_rule	Varchar(30)	NULL	If element is going to be calculated based on rule, then rule should be stored	No	Hrformula
derived_type_qc	Varchar(5)	NULL	Element value is calculated based on other element or accumulator need to captured here	No	hrquickcode
derived_type_code	Varchar(10)	NULL	The element name or accumulator name need to be given here	No	Hrcd
emp_option_qc	Varchar(5)	NULL	The element will be set as optional based on the input given here	No	Hrquickcode
derived_value	Numeric(15,4)	NULL	The computed value based on the criteria given will be populated here	No	hrsalary
prorate_allowed	Varchar(5)	NULL	Element value in payroll need to be prorated or not.	No	Hrquickcode
lop	Varchar(5)	NULL	Element value depends upon lop or not need to be entered	No	Hrquickcode
grace_period	Numeric(5,2)	NULL	Total days of grace period allowed	No	Hrpercentage
unit	Varchar(5)	NULL	The total grace periods unit need to be mentioned here.	No	Hrquickcode
flexible	Varchar(5)	NULL	Element is going to be fixed or flexible will be opted here	No	Hrquickcode
ctc_value	Numeric(15,4)	NULL	Temp value will be stored during calculation	No	Hrsalary
seqno	Int	NULL	Sequence number in which element should be calculated will be captured	No	Hrint
orno	Int	NULL	Temp value will be stored during computation	No	Hrint

Table Name: hros_object_count

Purpose:	Object Count Table for Installation checklist
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
object_name	nvarchar(255)	NOT NULL	SP, ASP, DLL names	Yes	HrText255
object_type	nvarchar(5)	NOT NULL	SP, ASP, DLL	No	HrCode
base_or_ext_flag	nvarchar(3)	NOT NULL	Column base_or_ext_flag can have the following values only : 'B' when the objects are created internally, and 'E' when the objects are created externally.	No	HrFlag

Table Name: hros_probnotice_hdr

Purpose:	Probation Notice Definition Header table. In this table we can store the master details of Probation information grade set wise, grade wise, location wise, department wise and division wise
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_ou_code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
Department_Code	nvarchar(10)	NOT NULL	Department Code as entered by the user.	Yes	HrCd
Work_Location_Code	nvarchar(5)	NOT NULL	Work Location Code as entered by the user.	Yes	HrQuickCode
Division_Status_Code	nvarchar(5)	NOT NULL	Divisional Status as selected in the Divisional status combo.(Dept with the type_code as DIVS will be populated in the divisional Status combo)	Yes
Gset_Code	nvarchar(5)	NOT NULL	GradeSet Code as entered by the user.	Yes	HrCode
Grade_Code	nvarchar(5)	NOT NULL	Grade Code as entered by the user.	Yes
Effective_From_Date	datetime	NOT NULL	The New Effective From Date entered by the user will be updated in Effective From date.	Yes	Datetime
Effective_To_Date	datetime	NULL	The Effective To Date will be updated as null for the first entry.For the subsequent entries the New Effective From Date - 1 will be the Effective To Date.	No
Column1	nvarchar(25)	NULL	Value as entered by the user.Extra column provided for future enhancements.	No	HrDescription
Column2	nvarchar(25)	NULL	Value as entered by the user.Extra column provided for future enhancements.	No
Prob_Period	INT	NULL	Probation period as entered by the user.	No	HrInt
Prob_Period_Units	nvarchar(5)	NULL	System defined quick code. BP = 'EPIN', PV = 'UNDN' For Eg> Days,Weeks,Months,Years,etc..	No	HrQuickCode
Prob_Notice_Period	INT	NULL	Probation Notice Period as entered by the user.	No	HrInt
Prob_Notice_Units	nvarchar(5)	NULL	System defined quick code. BP = 'EPIN', PV = 'UNDN' For Eg> Days,Weeks,Months,Years,etc..	No	HrQuickCode

Table Name: HROS_Proj_Eff_Dtl

Purpose:	Department Master Information (Effective Date wise) for every ORGST OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Effective_To_Date	datetime	NULL	Project Effective To Date as entered by User	No	Datetime
active_inactive_flag	nvarchar(3)	NOT NULL	Y if Project Code is Active, N if Inactive	No	HrFlag
completion_date	datetime	NULL		No	Datetime
master_ou_code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
Effective_From_Date	datetime	NOT NULL	Project Effective From Date as entered by User	Yes	Datetime
proj_code	nvarchar(10)	NOT NULL	Project Code for Organisation Structure	Yes	HrCd

Table Name: HROS_Proj_Hdr

Purpose:	Department Master Information for every ORGST OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
proj_code	nvarchar(10)	NOT NULL	Project Code Definition Master	Yes	HrCd
Applicable_To_Flag	nvarchar(3)	NOT NULL	'A' for Applicable to all EMPIN OUs; 'L' for Applicable to Login OU; 'S' for Applicable to Selective EMPIN OUs;	No	HrFlag
Login_OU_Code	int	NOT NULL	OU Code where ORGST Component is deployed and from where this page is launched	No	HrOUInstance

Table Name: HROS_Proj_Lang_Dtl

Purpose:	Department Master Information (Effective Date/Language Codewise) for every ORGST OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
user_date2	datetime	NULL		No	Datetime
proj_director	nvarchar(20)	NULL		No	HrEmpCode
user_date1	datetime	NULL		No	Datetime
proj_comment	nvarchar(2000)	NULL		No	hrnotes
user_combo1	nvarchar(5)	NULL		No	HrQuickCode
user_text1	nvarchar(255)	NULL		No	HrText255
user_text2	nvarchar(255)	NULL		No
user_combo2	nvarchar(5)	NULL		No	HrQuickCode
proj_code	nvarchar(10)	NOT NULL		Yes	HrCd
Effective_From_Date	datetime	NOT NULL	Department Effective From Date as entered by User	Yes	Datetime
master_ou_code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
u_proj_ldescription	nvarchar(80)	NULL		No	hrdesc40
proj_ldescription	nvarchar(80)	NULL		No
Language_Code	INT	NOT NULL	Language Code (1 if English) as selected in Language Combo	Yes	HrLangCd
u_proj_sdescription	nvarchar(30)	NULL		No	hrshortdesc12
proj_sdescription	nvarchar(30)	NULL		No

Table Name: HROS_Proj_OU_Map

Purpose:	Applicable EMPIN OU Codes for every Department Code, ORGST OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
proj_code	nvarchar(10)	NOT NULL	Project Code for Organisation Structure	Yes	HrCd
empin_ou_code	int	NOT NULL	EMPIN OU Code Interacting with ORGST OU Code (Found thru CIM)	Yes	HrOUInstance

Table Name: hros_scale_currency_dtl

Purpose:	Scale Master Information for every ORGST OU Code, Scale Code, Currency Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes
Scale_Code	nvarchar(5)	NOT NULL	Scale Code as entered (Stored in Upper Case)	Yes	HrCode
currency_code	nvarchar(5)	NOT NULL	Currency Code from Enterprise Modeller (In Upper Case)	Yes
effective_from_date	datetime	NOT NULL	Scale Currency effective from date for history record	Yes	Datetime
effective_to_date	datetime	NULL	Scale Currency effective to date for history record	No
rated_freqency_code	nvarchar(5)	NOT NULL	Rated Frequency Code values from System Defined Quick Codes (BP: HROS, PV: RTFQ)	No	HrCode
increment_type	nvarchar(5)	NULL	Increment Type from System Defined Quick Codes (BP: HROS, PV: IRTP)	No	HrQuickCode
active_inactive_flag	nvarchar(3)	NOT NULL	Y if Scale Code is Active, N if Inactive	No	HrFlag
scale_currency_comment	nvarchar(2000)	NULL	Scale Currency Comment detail as entered	No	hrnotes

Table Name: hros_scale_currency_tmp

Purpose:	Scale Master Information for every ORGST OU Code, Scale Code, Currency Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NULL	GUID generated for the Session	No	HrGuid
scale_code	nvarchar(5)	NOT NULL	Scale Code as entered (Stored in Upper Case)	No	HrCode
currency_code	nvarchar(5)	NOT NULL	Currency Code from Enterprise Modeller (In Upper Case)	No

Table Name: HROS_Scale_Hdr

Purpose:	Scale Code, Currency Details Temporary Table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
Scale_Code	nvarchar(5)	NOT NULL	Scale Code as entered (Stored in Upper Case)	Yes	HrCode
Applicable_To_Flag	nvarchar(3)	NOT NULL	'A' for Applicable to all EMPIN OUs; 'L' for Applicable to Login OU; 'S' for Applicable to Selective EMPIN OUs;	No	HrFlag
Active_Inactive_Flag	nvarchar(3)	NOT NULL	Y if Scale Code is Active, N if Inactive	No
Login_OU_Code	int	NOT NULL	OU Code where ORGST Component is deployed and from where this page is launched	No	HrOUInstance

Table Name: HROS_Scale_Lang_Dtl

Purpose:	Scale Master Information for every ORGST OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes
Scale_Code	nvarchar(5)	NOT NULL	Scale Code as entered (Stored in Upper Case)	Yes	HrCode
Language_Code	INT	NOT NULL	Language Code (1 if English) as selected in Language Combo	Yes	HrLangCd
scale_sdescription	nvarchar(30)	NULL	Scale Short Description as entered	No	hrshortdesc12
u_scale_sdescription	nvarchar(30)	NULL	Scale Short Description as entered (In Upper Case)	No
scale_ldescription	nvarchar(80)	NULL	Scale Long Description as entered	No	hrdesc40
u_scale_ldescription	nvarchar(80)	NULL	Scale Long Description as entered (In Uppercase)	No
scale_comment	nvarchar(2000)	NULL	Scale Comments as entered	No	hrnotes

Table Name: HROS_Scale_Limit_Dtl

Purpose:	Scale Master Information (EffectiveDate wise, Languagewise ) for every ORGST OU Code, Scale Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Scale_Lower_Limit	numeric(15,4)	NOT NULL	Lower Limit amount (Rowwise)	Yes	HrSalary
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
Scale_Code	nvarchar(5)	NOT NULL	Scale Code as entered (Stored in Upper Case)	Yes	HrCode
currency_code	nvarchar(5)	NOT NULL	Currency Code from Enterprise Modeller (In Upper Case)	Yes
effective_from_date	datetime	NOT NULL	Scale Currency effective from date to join with parent table	Yes	Datetime
Increment_Amount	numeric(15,4)	NULL	Increment Amount from Lower to Upper	No	HrSalary
Scale_Upper_Limit	numeric(15,4)	NULL	Upper Limit amount (Rowwise)	No
Mid_Point	numeric(15,4)	NULL	Mid Point Amount for tracking	No
Comparison_Ratio	numeric(10,2)	NULL	Comparison Ratio when compared to other Companies in the Market	No	HrCompaRatio

Table Name: HROS_Scale_OU_Map

Purpose:	Applicable EMPIN OU Codes for every ORGST OU Code, Scale Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
Scale_Code	nvarchar(5)	NOT NULL	Scale Code as entered (Stored in Upper Case)	Yes	HrCode
empin_ou_code	int	NOT NULL	EMPIN OU Code Interacting with ORGST OU Code (Found thru CIM)	Yes	HrOUInstance

Table Name: hros_scale_tmp

Purpose:	Scale Code, Currency Code Temporary Table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	GUID generated for the Session	Yes	HrGuid
currency_code	nvarchar(5)	NOT NULL	Currency Code from Enterprise Modeller (In Upper Case)	Yes	HrCode

Table Name: hros_wlocn_eff_dtl

Purpose:	Work Location Master Information (EffectiveDatewise) for every ORGST OU Code, Work Location Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
wlocn_code	nvarchar(5)	NOT NULL	Work Location Code as entered (Stored in Upper Case)	Yes	HrCode
effective_from_date	datetime	NOT NULL	Work Location Effective From Date as entered	Yes	Datetime
effective_to_date	datetime	NULL	Work Location Effective To Date as entered	No
country_code	nvarchar(5)	NULL	Country Code from Enterprise Modeller	No	countrycode
state_code	nvarchar(10)	NULL	State Code (In Upper Case) as in State Master	No	hrstatecode
local_type1_code	nvarchar(5)	NULL	One of the Local Code (For Type1) applicable for the Country + State Code combination - County, District ...	No	HrQuickCode
local_type2_code	nvarchar(5)	NULL	One of the Local Code (For Type2) applicable for the Country + State Code combination - City/Town	No
local_type3_code	nvarchar(5)	NULL	One of the Local Code (For Type3) applicable for the Country + State Code combination - School County	No
postal_code	nvarchar(40)	NULL	Postal Code as entered	No	HrZip
phone_no1	nvarchar(20)	NULL	Phone Number 1 as entered	No	HrPhone
phone_no2	nvarchar(20)	NULL	Phone Number 2 as entered	No
phone_no3	nvarchar(20)	NULL	Phone Number 3 as entered	No
fax_no1	nvarchar(20)	NULL	Fax Number 1 as entered	No
fax_no2	nvarchar(20)	NULL	Fax Number 2 as entered	No
e_mail	nvarchar(40)	NULL	E Mail ID as entered	No	HrEmailId
web_site	nvarchar(80)	NULL	Web Site information as entered	No	hrdesc40
cp_phone_no	nvarchar(20)	NULL	Contact Person - Phone number as entered	No	HrPhone
cp_mobile_no	nvarchar(20)	NULL	Contact Person - Mobile number as entered	No	HrMobile
cp_fax_no	nvarchar(20)	NULL	Contact Person - Fax number as entered	No	HrPhone
cp_e_mail	nvarchar(40)	NULL	Contact Person - EMail ID as entered	No	HrEmailId

Table Name: hros_wlocn_hdr

Purpose:	Work Location Master Information for every ORGST OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
wlocn_code	nvarchar(5)	NOT NULL	Work Location Code as entered (Stored in Upper Case)	Yes	HrCode
Applicable_To_Flag	nvarchar(3)	NOT NULL	'A' for Applicable to all EMPIN OUs; 'L' for Applicable to Login OU; 'S' for Applicable to Selective EMPIN OUs;	No	HrFlag
Active_Inactive_Flag	nvarchar(3)	NOT NULL	Y if Work Location Code is Active, N if Inactive	No
Login_OU_Code	int	NOT NULL	OU Code where ORGST Component is deployed and from where this page is launched	No	HrOUInstance

Table Name: hros_wlocn_lang_dtl

Purpose:	Work Location Master Information (EffectiveDatewise, Languagewise) for every ORGST OU Code, Work Location Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes
wlocn_code	nvarchar(5)	NOT NULL	Work Location Code as entered (Stored in Upper Case)	Yes	HrCode
effective_from_date	datetime	NOT NULL	Work Location Effective From Date as entered	Yes	Datetime
Language_Code	INT	NOT NULL	Language Code (1 if English) as selected in Language Combo	Yes	HrLangCd
address_line1	nvarchar(40)	NULL	Address line 1 as entered	No	HrAddress
u_address_line_1	nvarchar(40)	NULL	Address line 1 as entered (In Upper Case)	No
address_line2	nvarchar(40)	NULL	Address line 2 as entered	No
address_line3	nvarchar(40)	NULL	Address line 3 as entered	No
contact_person_name	nvarchar(40)	NULL	Contact Person Name as entered	No	HrContactPerson
wlocn_sdescription	nvarchar(30)	NULL	Work Location Short Description as entered	No	hrshortdesc12
u_wlocn_sdescription	nvarchar(30)	NULL	Work Location Short Description as entered (In Upper Case)	No
wlocn_ldescription	nvarchar(80)	NULL	Work Location Long Description as entered	No	hrdesc40
u_wlocn_ldescription	nvarchar(80)	NULL	Work Location Long Description as entered (In Upper Case)	No
wlocn_comments	nvarchar(2000)	NULL	Work Location Comments as entered	No	hrnotes

Table Name: hros_wlocn_ou_map

Purpose:	Applicable EMPIN OU Codes for every ORGST OU Code, Work Location Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	Yes	HrOUInstance
wlocn_code	nvarchar(5)	NOT NULL	Work Location Code as entered (Stored in Upper Case)	Yes	HrCode
empin_ou_code	int	NOT NULL	EMPIN OU Code Interacting with ORGST OU Code (Found thru CIM)	Yes	HrOUInstance

Table Name: orgst_emp_tmp

Purpose:	Department Temporary Table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	GUID generated for the Session	No	HrGuid
dept_code	nvarchar(10)	NULL	Department Code as entered by User (Stored in Upper Case)	No	HrCd
employment_unit_code	int	NOT NULL	EMPIN OU Code Interacting with ORGST OU Code (Found thru CIM)	No	HrOUInstance
master_ou_code	int	NOT NULL	ORGST OU Code Selected in the OU Combo	No