Data Dictionary – Employment Information

Table Name: epin_mtn_contract_dtl

Purpose:	Employee Contract details header table.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_ou_code	int	NOT NULL	Interacting EMPNG OU Code	Yes	Ctxt_OUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee code under EMPNG OU as entered by the user.	Yes	HrEmpCode
Contract_No	int	NOT NULL	The contract number of the employee.	Yes	hrcontractdet
Element	nvarchar(10)	NOT NULL	The code identifying the pay element.	Yes	hrcdmscs
Amount	numeric(15,4)	NULL	The amount to be paid against the pay element.	No	hrsalarymscs
From_Date	datetime	NULL	The starting date form which payment is made for the pay element.	No	Datetime
To_Date	datetime	NULL	The ending date within which payment is made for the pay element.	No
Remarks	nvarchar(255)	NULL	Any additional details pertaining to the contract details.	No	hrremarks

Table Name: epin_mtn_contract_hdr

Purpose:	Employee Contract details header table.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_ou_code	int	NOT NULL	Interacting EMPNG OU Code	Yes	Ctxt_OUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee code under EMPNG OU as entered by the user.	Yes	HrEmpCode
Contract_No	int	NOT NULL	The contract number of the employee.	Yes	hrcontractdet
Duration	int	NOT NULL	The duration of the employee s contract.	No	HrInt
Duration_Type	nvarchar(5)	NOT NULL	Unit of Measurement as selected by the user. System defined quick code. BP = 'EPIN' PV = 'UNDN' Eg> Hours,Days,etc	No	HrQuickCode
Start_Date	datetime	NOT NULL	The date on which the employee s contract began.	No	Datetime
End_date	datetime	NOT NULL	The date on which the employee s contract ended.	No
Contract_Type	nvarchar(5)	NOT NULL	Contract Type value as selected by the user in the Contract Type combo. System defined quick code. BP = 'HREI' PV = 'COTY' Eg> Local Contract,Overseas Contract,etc	No	HrQuickCode
Location_of_Hire	nvarchar(50)	NULL	The placed where the employee is hired.	No	hrcertauth
Agency_Fee	numeric(7,2)	NULL	The fees for the recruiting agency.	No	hrsalamtmscs
Total_Sec_Deposit	numeric(7,2)	NULL	The amount to be paid as a security deposit by the employee.	No
Up_Front_Deposit	numeric(7,2)	NULL	The amount to be paid up front as a deposit by the employee.	No
UFD_Received_Date	datetime	NULL	The date on which the up front deposited was received from the employee.	No	Datetime
Airfare_Employer	numeric(7,2)	NULL	The amount spent as airfare by the employer.	No	hrsalamtmscs
Airfare_Employee	numeric(7,2)	NULL	The amount spent as airfare by the employee.	No
Mid_Air_Fare	int	NULL	The number of months after which the employee is eligible for airfare.	No	hrint2
Remarks	nvarchar(255)	NULL	Any remarks pertaining to the airfare paid by the employee.	No	hrremarks
Breach_Quantum	numeric(7,2)	NULL	The multiples of the basic salary that is deducted when the employee breaches the contract.	No	hrsalamtmscs
Breach_Flag	varchar(5)	NULL	The action to be taken when the employee breaches the contract. System defined quick code. BP = 'HREI' PV = 'BRFG' Eg> Exclude Security Deposit,Include Security Deposit,etc	No	hrquickcode
Medical_Checkup	nvarchar(40)	NULL	The details pertaining to medical check-up.	No	HrMultiHead
Housing__Details	nvarchar(40)	NULL	The details pertaining to the accommodation provided to the employee.	No	address
Gratuity	numeric(15,4)	NULL	The amount paid as gratuity to the employee.	No	hrsalarymscs
Tax_Status	nvarchar(40)	NULL	The tax status of the employee.	No	taxcomputationtype
WP_Levy	numeric(15,4)	NULL	The amount levied for the work permit.	No	hrsalarymscs
other_details	nvarchar(255)	NULL	Any other details pertaining to the contract.	No	text255

Table Name: EPIN_Rec_AppointmentInfo

Purpose:	This tale stores the employee Appoinment information
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_Ou_Code	int	NOT NULL	Interatcing Master OU code	Yes	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
serial_no	int	NOT NULL	Serial Number	Yes	HrOUInstance
Appoinment_No	nvarchar(20)	NULL	Appoinment Number	No	HrEmpCode
Institute_Name	nvarchar(255)	NULL	Institute name	No	hrremarks
App_type	nvarchar(10)	NULL	Appoinment Type	No	hrcd
App_Start_Date	datetime	NULL	Appoinment start date	No	Datetime
App_End_Date	datetime	NULL	Appoinment end date	No
Remarks	nvarchar(255)	NULL	remarks	No	hrremarks

Table Name: hrei_addtnl_emplmt_info

Purpose:	This Table stores the additional information of an employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
empng_ou_code	int	NOT NULL	Interacting EMPNG ou code	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Emp_Asgn_No	int	NOT NULL	Assignment Number of an employee	Yes	HrAssgnNo
Effective_from	datetime	NOT NULL	Effective from date of an employee	Yes	Datetime
Effective_to	datetime	NULL	Effective todate of an employee	No
Employee_Type	nvarchar(5)	NULL	Employee type of an employee	No	HrQuickCode
Work_Type	nvarchar(5)	NULL	Work Type of an employee	No
Job_Type	nvarchar(5)	NULL	Job Type of an employee	No
Section_Code	nvarchar(10)	NULL	Section Code of an employee	No	HrCd
Recuritment_Status	nvarchar(5)	NULL	Recuritment Status	No	HrQuickCode
Job_Category	nvarchar(5)	NULL	Job Category of an employee	No
Contract_Status	nvarchar(5)	NULL	Contract Status	No
Product	nvarchar(5)	NULL	Product	No
Process	nvarchar(5)	NULL	Process	No
Commission_Agent	nvarchar(5)	NULL	Commission agent	No
Holder_Pub_Office	nvarchar(5)	NULL	Holder Public Office	No
Shift	nvarchar(5)	NULL	Shift of an employee	No
Schedule	nvarchar(5)	NULL	Schedule of an employee	No
Line	nvarchar(80)	NULL	Line	No	hrdesc40
Leave_Scheme	nvarchar(5)	NULL	Leave Scheme	No	HrQuickCode
Divisional_Status	nvarchar(5)	NULL	Divisional Status	No
Benefit_Scheme	nvarchar(5)	NULL	Benefit Scheme	No
Pension_Status	nvarchar(5)	NULL	Pension Status	No
Employment_Type	nvarchar(5)	NULL	Employment Type	No
User_Defined1	nvarchar(5)	NULL	User Defined 1	No
User_Defined2	nvarchar(5)	NULL	User Defined 2	No
User_Defined3	nvarchar(5)	NULL	User Defined 3	No
User_Defined4	nvarchar(5)	NULL	User Defined 4	No
Prof_Tax_Region_code	nvarchar(5)	NULL	Professional Tax region Code	No
Tax_Location_code	nvarchar(5)	NULL	Tax location Code	No
HRA_Location_code	nvarchar(5)	NULL	HRA location Code	No
ward_class	varchar(5)	NULL	Ward Class	No	hrquickcode
Funded	varchar(5)	NULL	Funded	No
Fund_gl_code	nvarchar(40)	NULL	Funded Code	No	HrQuickCodeDesc
exempt_nonexempt	varchar(5)	NULL	Exempt	No	hrquickcode
med_nonmed	varchar(5)	NULL	Med NonMed	No
std_days_per_wk	numeric(6,2)	NULL	Standard days per week	No	hrshours
physical_wrk_lcn	nvarchar(5)	NULL	Physical Work Location	No	HrCode
parttimer_bnft_sch	varchar(5)	NULL	Parttime benefits scheme	No	hrquickcode
posting_inst	varchar(5)	NULL	Posting Inst	No
FTE	numeric(6,2)	NULL	FTE	No	hrshours
std_hrs_per_wk	numeric(6,2)	NULL	Standard hours per week	No
std_hrs_per_mnth	numeric(6,2)	NULL	Standard Hours Per Month	No
hq_internal_order	nvarchar(40)	NULL	HQ internal order	No	HrQuickCodeDesc
Confi_staff	varchar(5)	NULL	Confidential Staff	No	hrquickcode
emp_group	nvarchar(5)	NULL	Employee Group	No	HrQuickCode
Staff_Category	varchar(5)	NULL	Staff Category	No	hrquickcode
Shift_NonShift	varchar(5)	NULL	Shift/Non-Shift	No
Team	nvarchar(5)	NULL	Team	No	HrQuickCode
percentage_funds	Numeric(5,2)	NULL	Percentage Funds	No	hrpercentage

Table Name: hrei_asgn_award_auth_dtl

Purpose:	Employee Assignment - Award Information for every EMPIN OU Code – Authorized
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Currency_Code	nvarchar(5)	NOT NULL	Currency Code as selected by user - From Enterprise Modeller	No	HrCode
Payable_Code	nvarchar(5)	NOT NULL	Payable Through Code is a System defined Quick Code BP: HREI PV: PMOD	No	HrQuickCode
Payroll_Status	nvarchar(3)	NULL	Status of Payroll w.r.t this award. Values: Will be NP when created. P,A,U based on payroll processing BP:GEN PV: PRC	No	hrflag
Award_Remarks	nvarchar(255)	NULL	Remarks for the Award as entered	No	hrremarks
Award_Effective_To_Date	datetime	NULL	Award - Effective to date. Date to be considered for Payroll. This is not mandatory	No	Datetime
Award_Effective_From_Date	datetime	NOT NULL	Award - Effective From date. Date to be considered for Payroll.	No
payroll_code	nvarchar(5)	NULL	Payroll Process Code	No	HrCode
payset_code	nvarchar(10)	NULL	Payset Mapped to the Employee Assignment in Payroll	No	HrCd
Payroll_Date	datetime	NULL	Payroll Processed Date	No	Datetime
payrollou	int	NULL	Payroll OU Instance Code	No	HrOuInstance
Payroll_Amount	numeric(15,4)	NULL	Amount considered for Payment thru Payroll	No	HrSalary
process_period_code	nvarchar(5)	NULL	Payroll Process Period Code	No	HrCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
Award_Number	int	NOT NULL	Award Number - System Generated	Yes	HrNumber
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Award_Amount	numeric(15,4)	NOT NULL	Award Amount as entered	No	HrSalary
Awarded_By	nvarchar(100)	NOT NULL	Name of the rewarding organization/institution/person as entered	No	Description
Award_Date	datetime	NOT NULL	Award Date as entered	No	Datetime
Award_Type	nvarchar(5)	NOT NULL	Values for Award Type (System Defined Quick Code) BP: HREI PV: AWTY	No	HrQuickCode
Award_Agency_Code	nvarchar(5)	NOT NULL	Values for Rewarding Agency Code (System Defined Quick Code) - Internal/External BP: HREI PV: AWAG	No
Award_Name	nvarchar(100)	NOT NULL	Name of the Award as entered	No	Description

Table Name: hrei_asgn_award_dtl

Purpose:	Employee Assignment - Award Information for every EMPIN OU Code - Pending for Authorization
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
Award_Number	int	NOT NULL	Award Number - System Generated	Yes	HrNumber
Award_Type	nvarchar(5)	NOT NULL	Values for Award Type (System Defined Quick Code) BP: HREI PV: AWTY	No	HrQuickCode
Award_Name	nvarchar(100)	NOT NULL	Name of the Award as entered	No	Description
Award_Agency_Code	nvarchar(5)	NOT NULL	Values for Rewarding Agency Code (System Defined Quick Code) - Internal/External BP: HREI PV: AWAG	No	HrQuickCode
Awarded_By	nvarchar(100)	NOT NULL	Name of the rewarding organization/institution/person as entered	No	Description
Award_Date	datetime	NOT NULL	Award Date as entered	No	Datetime
Award_Amount	numeric(15,4)	NOT NULL	Award Amount as entered	No	HrSalary
Award_Effective_From_Date	datetime	NOT NULL	Award - Effective From date. Date to be considered for Payroll.	No	Datetime
Award_Effective_To_Date	datetime	NULL	Award - Effective to date. Date to be considered for Payroll. This is not mandatory	No
Award_Remarks	nvarchar(255)	NULL	Remarks for the Award as entered	No	hrremarks
Currency_Code	nvarchar(5)	NOT NULL	Currency Code as selected by user - From Enterprise Modeller	No	HrCode
Payable_Code	nvarchar(5)	NOT NULL	Payable Through Code is a System defined Quick Code BP: HREI PV: PMOD	No	HrQuickCode
Mode_Flag	nvarchar(3)	NOT NULL	Mode Flag: Request for Addition, Modification, Deletion Values (A/M/D)	No	hrflag
Payroll_Status	nvarchar(3)	NULL	Status of Payroll w.r.t this award. Values: Will be NP when created. P,A,U based on payroll processing BP:GEN PV: PRC	No
Payroll_Date	datetime	NULL	Payroll Processed Date	No	Datetime
Payroll_Amount	numeric(15,4)	NULL	Amount considered for Payment thru Payroll	No	HrSalary
payrollou	int	NULL	Payroll OU Instance Code	No	HrOuInstance
payroll_code	nvarchar(5)	NULL	Payroll Process Code	No	HrCode
payset_code	nvarchar(10)	NULL	Payset Mapped to the Employee Assignment in Payroll	No	HrCd
process_period_code	nvarchar(5)	NULL	Payroll Process Period Code	No	HrCode

Table Name: hrei_asgn_award_hdr

Purpose:	Employee Assignment - Award Information for every EMPIN OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Award_Reject_Reason	nvarchar(100)	NULL	Rejection Reason as entered by Authorizer. In case of Mulitiple authorization, only last edited rejection reason will be stored.	No	Description
Award_Auth_Date	datetime	NULL	Authorization Date - System Date	No	Datetime
Award_Auth_Status	nvarchar(3)	NOT NULL	Flag Value: Y - Authorized asgn-award exist N - No Authorized asgn-award exist	No	hrflag
doc_id	nvarchar(128)	NULL	Unique ID generated by the system to supply info to Workflow	No	wfdockey
Award_Login_OU_Code	int	NOT NULL	Login Employment OU Code	No	HrOuInstance
Award_Language_Code	int	NOT NULL	Login Language	No	HrLangCd
doc_state	nvarchar(10)	NULL	Current State of the Document as returned from Workflow	No	wfstatename
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Award_Pend_Status	nvarchar(3)	NOT NULL	Flag Value: Y - Pending for Authorization records exists N - No Pending for Authorization records exists	No	Hrflag
Award_Number	int	NOT NULL	Award Number - System Generated	Yes	HrNumber
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance

Table Name: hrei_asgn_comp_auth_map

Purpose:	Employee Assignment - Competency Mapping Information for every EMPIN OU Code – Authorized
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Competency_MDL	int	NOT NULL	Competency Minimum Desired Level	No	hrelementmdl
Competency_Code	nvarchar(10)	NOT NULL	Competency Code as entered in Competency Component	Yes	hrcompcode
Competency_Weightage	numeric(5,2)	NOT NULL	Competency Weightage	No	HrCompWeight
Competency_Weightage_Per	numeric(5,2)	NOT NULL	Competency Weightage Percentage - Calculated column	No
Mandatory_Flag	nvarchar(3)	NOT NULL	Mandatory Flag: Values Yes / No (Y/N)	No	hrflag
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo

Table Name: hrei_asgn_comp_hdr

Purpose:	Employee Assignment - Competency Information for every EMPIN OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
Competency_Pend_Status	nvarchar(3)	NOT NULL	Flag Value: Y - Pending for Authorization records exists N - No Pending for Authorization records exists	No	hrflag
Competency_Auth_Status	nvarchar(3)	NULL	Flag Value: Y - Authorized asgn-competency exist N - No Authorized asgn-comptency exist	No
Competency_Auth_Date	datetime	NULL	Authorization Date - System Date	No	Datetime
Competency_Reject_Reason	nvarchar(100)	NULL	Rejection Reason as entered by Authorizer. In case of Mulitiple authorization, only last edited rejection reason will be stored.	No	Description
Supervisor_Remarks	nvarchar(255)	NULL	Supervisor remarks	No	HrText255
Competency_Login_OU_Code	int	NOT NULL	Login Employment OU Code	No	HrOuInstance
Competency_Language_Code	int	NOT NULL	Login Language	No	HrLangCd
doc_id	nvarchar(128)	NULL	Unique ID generated by the system to supply info to Workflow	No	wfdockey
doc_state	nvarchar(10)	NULL	Current State of the Document as returned from Workflow	No	wfstatename

Table Name: hrei_asgn_comp_map

Purpose:	Employee Assignment - Competency Mapping Information for every EMPIN OU Code - Pending for Authorization
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Competency_Weightage	numeric(5,2)	NOT NULL	Competency Weightage	No	HrCompWeight
Competency_MDL	int	NOT NULL	Competency Minimum Desired Level	No	hrelementmdl
Competency_Weightage_Per	numeric(5,2)	NOT NULL	Competency Weightage Percentage - Calculated column	No	HrCompWeight
Mandatory_Flag	nvarchar(3)	NOT NULL	Mandatory Flag: Values Yes / No (Y/N)	No	hrflag
Mode_Flag	nvarchar(3)	NOT NULL	Mode Flag: Request for Addition, Modification, Deletion Values (A/M/D)	No
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Competency_Code	nvarchar(10)	NOT NULL	Competency Code as entered in Competency Component	Yes	hrcompcode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance

Table Name: hrei_asgn_eff_auth_dtl

Purpose:	Employee Assignment Information (EffectiveDate Wise) – Authorized
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
Assignment_Effective_From_Date	datetime	NOT NULL	Effective From Date for that Assignment (History information)	Yes	Datetime
assignment_effective_to_date	datetime	NULL	Effective To Date for that Assignment (History information)	No
assignment_change_reason_code	nvarchar(5)	NULL	Reason for Change in Assignment Code	No	HrQuickCode
assignment_type	nvarchar(5)	NOT NULL	Assignment Type: New Hire Re-Hire Promotion Transfer Separated	No
employee_status	nvarchar(3)	NULL	Flag Value: C - Current S - Separated	No	hrflag
position_control_id	nvarchar(10)	NULL	Position Control ID (If position control is ON)	No	hrposncode
position_code	nvarchar(10)	NULL	Position Code created in UNSTR	No
position_id_or_code	nvarchar(10)	NULL	Position Control ID if present else Position Code	No
org_regltry_region_code	varchar(5)	NULL	Regulatory Region Code - Organizational Attribute	No	hrquickcode
org_work_locn_code	nvarchar(5)	NULL	Work Location Code - Organizational Attribute	No	HrCode
org_business_unit_code	nvarchar(20)	NULL	Business Unit Code - Organizational Attribute	No	buid
hyp_hrcy_code	nvarchar(10)	NULL	Hierarchy Code - Hierarchy Point Info	No	HrCd
hyp_hrcy_chain_code	nvarchar(10)	NULL	Hierarchy Chain Code - Hierarchy Point Info	No
dept_code	nvarchar(10)	NULL	Department Code as created in Organization Structure	No
job_code	nvarchar(10)	NULL	Job Code as created in Unit Structure	No
job_eeo_class	nvarchar(5)	NULL	EEO(Equal employment Opportunity Class Code) BP: UTST PV: EEOC	No	HrQuickCode
job_grade_set_code	nvarchar(5)	NULL	Grade Set Code of ORGST attached to the Job in UNSTR	No	HrCode
job_grade_code	nvarchar(5)	NULL	Grade Code for a Grade Set of ORGST attached to the Job in UNSTR	No
job_classification_code	varchar(5)	NULL	Job Classification code from UNSTR BP: UTST PV: JOBC	No	hrquickcode
job_work_condn_code	nvarchar(5)	NULL	Work Condition Code attached to the Job in UNSTR	No	HrQuickCode
job_work_compn_code	nvarchar(5)	NULL	Work Compensation Code attached to the Job in UNSTR	No
job_salary_hour_flag	nvarchar(5)	NULL	Salaried / Hourly Flag: for the Job BP: UTST PV: SALH	No
job_standard_hours	numeric(6,2)	NULL	Standard Hours of Working attached to the job in UNSTR	No	hrshours
job_standard_hours_uom	nvarchar(5)	NULL	Standard Hours unit of measure: BP: UTST PV: STDU	No	HrQuickCode
job_work_experience	int	NULL	Work Experience attached to the Job in UNSTR	No	hrmonthsexp
job_work_experience_uom	nvarchar(5)	NULL	Work Experience Unit of measure BP: UTST PV: WKEU	No	HrQuickCode
job_medical_chk_reqd	int	NULL	Medical Check Required Values 1 - Required 0 - Not Required	No	hrcheck
job_medical_chk_reqmt	nvarchar(255)	NULL	Medical Check Requirement - Remarks	No	hrremarks
job_tipped	int	NULL	Tip Enabled 1- Enabled 0 - Not Enabled	No	hrcheck
job_mobile	int	NULL	Mobile Present 1- Present 0 - Not Present	No
job_ud1_flsa_exempt	nvarchar(5)	NULL	Fair Labour Standards Act Exempt Y/N	No	HrQuickCode
job_ud2_sic_code	nvarchar(20)	NULL	SIC Code	No	hrsiccode
emp_fte_code	numeric(5,2)	NULL	Full Time Equivalent	No	hrratio
emp_reg_temp_flag	nvarchar(5)	NULL	Regular / Temporary	No	HrQuickCode
emp_fullpart_time_flag	nvarchar(5)	NULL	Full Time / Part Time	No
sup_employee_code	nvarchar(20)	NOT NULL	Supervisor Employee Code	No	HrEmpCode
sup_assignment_number	int	NOT NULL	Supervisor Assignment Number	No	HrAssgnNo
sup_assignment_defined_ou_code	int	NULL	Supervisor Assignment Defined ou code (EMPIN)	No	HrOuInstance
benefit_union_affiliation_code	nvarchar(5)	NULL	Union Code - Affiliated	No	HrQuickCode
benefit_union_group_id	int	NULL	Group Code under that Union Code	No	HrInt
benefit_description	nvarchar(100)	NULL	Description of Union Related Benefits	No	Description
assignment_auth_status	nvarchar(3)	NOT NULL	Authorization Status Possible Values: A,P A - Authorised P - Pending	No	hrflag
assignment_auth_date	datetime	NOT NULL	Authorization Date - System Date	No	Datetime
gnmas_ou_code	int	NOT NULL	EMPIN Interacting GNMAS OU Code	No	HrOuInstance
orgst_ou_code	int	NOT NULL	EMPIN Interacting ORGST OU Code	No
unstr_ou_code	int	NOT NULL	EMPIN Interacting UNSTR OU Code	No
hrchy_ou_code	int	NOT NULL	EMPIN Interacting HRCHY (Hierarchy) OU Code	No
sedef_ou_code	int	NULL	EMPIN Interacting SEDEF (Security Definition) OU Code	No	HrOUInstance
source_component_code	nvarchar(20)	NOT NULL	From Where the assignment is updated (HRMSEMPIN/HRMSEMPMV)	No	HrComponentCode
assignment_comments	nvarchar(2000)	NULL	Comments for the Assignment	No	hrnotes
voice_non_voice_qc	varchar(5)	NULL		No	hrquickcode
employee_group	varchar(5)	NULL		No
data_override_flag	nvarchar(3)	NULL	Date Override Flag value present at the time of transaction creation (Y/N)	No	hrflag
doc_id	nvarchar(128)	NULL	Unique ID generated by the system to supply info to Workflow	No	wfdockey
doc_state	nvarchar(10)	NULL	Current State of the Document as returned from Workflow	No	wfstatename
product	nvarchar(15)	NULL		No	hrchar15

Table Name: hrei_asgn_eff_dtl

Purpose:	Employee Assignment Information (EffectiveDate Wise) - Records Pending for Authorization
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
Assignment_Effective_From_Date	datetime	NOT NULL	Effective From Date for that Assignment (History information)	Yes	Datetime
assignment_effective_to_date	datetime	NULL	Effective To Date for that Assignment (History information)	No
assignment_change_reason_code	nvarchar(5)	NULL	Reason for Change in Assignment Code BP: HREI PV: CHAS	No	HrQuickCode
assignment_type	nvarchar(5)	NOT NULL	Assignment Type: New Hire Re-Hire Promotion Transfer Separated BP: HREI PV: ASTY	No
employee_status	nvarchar(3)	NULL	Flag Value: C - Current S - Separated BP: GEN PV: EMST	No	hrflag
position_control_id	nvarchar(10)	NULL	Position Control ID (If position control is ON)	No	hrposncode
position_code	nvarchar(10)	NULL	Position Code created in UNSTR	No
position_id_or_code	nvarchar(10)	NULL	Position Control ID if present else Position Code	No
org_regltry_region_code	varchar(5)	NULL	Regulatory Region Code - Organizational Attribute BP: UTST PV: RERE	No	hrquickcode
org_work_locn_code	nvarchar(5)	NULL	Work Location Code - Organizational Attribute	No	HrCode
org_business_unit_code	nvarchar(20)	NULL	Business Unit Code - Organizational Attribute	No	buid
hyp_hrcy_code	nvarchar(10)	NULL	Hierarchy Code - Hierarchy Point Info	No	HrCd
hyp_hrcy_chain_code	nvarchar(10)	NULL	Hierarchy Chain Code - Hierarchy Point Info	No
dept_code	nvarchar(10)	NULL	Department Code as created in Organization Structure	No
job_code	nvarchar(10)	NULL	Job Code as created in Unit Structure	No
job_eeo_class	nvarchar(5)	NULL	EEO(Equal employment Opportunity Class Code) BP: UTST PV: EEOC	No	HrQuickCode
job_grade_set_code	nvarchar(5)	NULL	Grade Set Code of ORGST attached to the Job in UNSTR	No	HrCode
job_grade_code	nvarchar(5)	NULL	Grade Code for a Grade Set of ORGST attached to the Job in UNSTR	No
job_classification_code	varchar(5)	NULL	Job Classification code from UNSTR BP: UTST PV: JOBC	No	hrquickcode
job_work_condn_code	nvarchar(5)	NULL	Work Condition Code attached to the Job in UNSTR BP: UTST PV: WCON	No	HrQuickCode
job_work_compn_code	nvarchar(5)	NULL	Work Compensation Code attached to the Job in UNSTR	No
job_salary_hour_flag	nvarchar(5)	NULL	Salaried / Hourly Flag: for the Job BP: UTST PV: SALH	No
job_standard_hours	numeric(6,2)	NULL	Standard Hours of Working attached to the job in UNSTR	No	hrshours
job_standard_hours_uom	nvarchar(5)	NULL	Standard Hours unit of measure: BP: UTST PV: STDU	No	HrQuickCode
job_work_experience	int	NULL	Work Experience attached to the Job in UNSTR	No	hrmonthsexp
job_work_experience_uom	nvarchar(5)	NULL	Work Experience Unit of measure BP: UTST PV: WKEU	No	HrQuickCode
job_medical_chk_reqd	int	NULL	Medical Check Required Values 1 - Required 0 - Not Required	No	hrcheck
job_medical_chk_reqmt	nvarchar(255)	NULL	Medical Check Requirement - Remarks	No	hrremarks
job_tipped	int	NULL	Tip Enabled 1- Enabled 0 - Not Enabled	No	hrcheck
job_mobile	int	NULL	Mobile Present 1- Present 0 - Not Present	No
job_ud1_flsa_exempt	nvarchar(5)	NULL	Fair Labour Standards Act Exempt Y/N	No	HrQuickCode
job_ud2_sic_code	nvarchar(20)	NULL	SIC Code	No	hrsiccode
emp_fte_code	numeric(5,2)	NULL	Full Time Equivalent	No	hrratio
emp_reg_temp_flag	nvarchar(5)	NULL	Regular / Temporary	No	HrQuickCode
emp_fullpart_time_flag	nvarchar(5)	NULL	Full Time / Part Time	No
sup_employee_code	nvarchar(20)	NOT NULL	Supervisor Employee Code	No	HrEmpCode
sup_assignment_number	int	NOT NULL	Supervisor Assignment Number	No	HrAssgnNo
sup_assignment_defined_ou_code	int	NULL	Supervisor Assignment Defined ou code (EMPIN)	No	HrOuInstance
benefit_union_affiliation_code	nvarchar(5)	NULL	Union Code - Affiliated	No	HrQuickCode
benefit_union_group_id	int	NULL	Group Code under that Union Code	No	HrInt
benefit_description	nvarchar(100)	NULL	Description of Union Related Benefits	No	Description
assignment_auth_status	nvarchar(3)	NOT NULL	Authorization Status Value: P	No	hrflag
assignment_auth_date	datetime	NOT NULL	Authorization Date - System Date	No	Datetime
assignment_reject_date	datetime	NULL	Rejection Date - System Date	No
assignment_reject_reason	nvarchar(255)	NULL	Rejection Reason as entered by Authorizer. In case of Mulitiple authorization, only last edited rejection reason will be stored.	No	hrremarks
assignment_activity_type	nvarchar(5)	NULL	Accessed from Which Activity: Values: A - From Create Assignment Page M - From Edit Assignment Page	No	HrQuickCode
gnmas_ou_code	int	NOT NULL	EMPIN Interacting GNMAS OU Code	No	HrOuInstance
orgst_ou_code	int	NOT NULL	EMPIN Interacting ORGST OU Code	No
unstr_ou_code	int	NOT NULL	EMPIN Interacting UNSTR OU Code	No
hrchy_ou_code	int	NOT NULL	EMPIN Interacting HRCHY (Hierarchy) OU Code	No
sedef_ou_code	int	NULL	EMPIN Interacting SEDEF (Security Definition) OU Code	No
source_component_code	nvarchar(20)	NOT NULL	From Where the assignment is updated (HRMSEMPIN/HRMSEMPMV)	No	HrComponentCode
assignment_comments	nvarchar(2000)	NULL	Comments for the Assignment	No	hrnotes
data_override_flag	nvarchar(3)	NULL	Date Override Flag value present at the time of transaction creation (Y/N)	No	hrflag
assignment_modify_option	nvarchar(5)	NULL	Modification Option: Update / Correct BP: GEN PV: MODI	No	HrQuickCode
new_effective_from_date	datetime	NULL	New Effective From Date if the Modify option is Update	No	Datetime
mode_flag	nvarchar(3)	NULL	Mode Flag: Request for Addition, Modification, Deletion Values (A/M/D)	No	hrflag
doc_id	nvarchar(128)	NULL	Unique ID generated by the system to supply info to Workflow	No	wfdockey
doc_state	nvarchar(10)	NULL	Current State of the Document as returned from Workflow	No	wfstatename
Product	nvarchar(15)	NULL		No	hrchar15

Table Name: hrei_asgn_eff_dtl_tmp

Purpose:	Employee Assignment - Effective Details temporary table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	Unique GUID generated on every session	Yes	HrGuid
Master_OU_Code	int	NOT NULL	Intracting Master OU Code	No	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	No	HrEmpCode
Assignment_Number	int	NOT NULL	Assignment Number Of an employee	No	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Assignment Defined OU Code an employee	No	HrOuInstance
Assignment_Effective_From_Date	datetime	NOT NULL	Assignment effective from date an employee	No	Datetime
assignment_effective_to_date	datetime	NULL	Assignment effective todate an employee	No
assignment_change_reason_code	nvarchar(5)	NULL	Assignment change reason code of an employee	No	HrQuickCode
assignment_type	nvarchar(5)	NOT NULL	Assignment type of an employee	No
employee_status	nvarchar(3)	NULL	Employee Status	No	hrflag
position_control_id	nvarchar(10)	NULL	Position Control ID ( on or off)	No	hrposncode
position_code	nvarchar(10)	NULL	Position code of an employee	No
position_id_or_code	nvarchar(10)	NULL	Position ID or code of an employee	No
org_regltry_region_code	varchar(5)	NULL	Organisation Region Code	No	hrquickcode
org_work_locn_code	nvarchar(10)	NULL	Organisation Worklocation Code	No	HrCd
org_business_unit_code	nvarchar(20)	NULL	Organisation Business Unit Code	No	buid
hyp_hrcy_code	nvarchar(10)	NULL	Hierarchy code	No	HrCd
hyp_hrcy_chain_code	nvarchar(10)	NULL	Hierarchy chain code	No
dept_code	nvarchar(10)	NULL	Department Code of an employee	No
job_code	nvarchar(10)	NULL	Job Code of an employee	No
job_eeo_class	nvarchar(5)	NULL	Job EEO class of an employee	No	HrQuickCode
job_grade_set_code	nvarchar(5)	NULL	Job grade set code	No	HrCode
job_grade_code	nvarchar(5)	NULL	Job grade code	No
job_classification_code	varchar(5)	NULL	Job classification code	No	hrquickcode
job_work_condn_code	nvarchar(5)	NULL	Job wor condition code	No	HrQuickCode
job_work_compn_code	nvarchar(5)	NULL	Job work compentation code	No
job_salary_hour_flag	nvarchar(5)	NULL	Job salary hour flag	No
job_standard_hours	numeric(6,2)	NULL	Standard hour of job	No	hrshours
job_standard_hours_uom	nvarchar(5)	NULL	Standard hour of job UOM	No	HrQuickCode
job_work_experience	int	NULL	Job work Experience	No	hrmonthsexp
job_work_experience_uom	nvarchar(5)	NULL	Job work Experience UOM	No	HrQuickCode
job_medical_chk_reqd	int	NULL	Job Medical check required	No	hrcheck
job_medical_chk_reqmt	nvarchar(255)	NULL	Job Medical check requirement	No	hrremarks
job_tipped	int	NULL	Job tipped	No	hrcheck
job_mobile	int	NULL	Job Mobile	No
job_ud1_flsa_exempt	nvarchar(5)	NULL		No	HrQuickCode
job_ud2_sic_code	nvarchar(20)	NULL		No	hrsiccode
emp_fte_code	numeric(15,4)	NULL	Employee full time equivalent code	No	HrSalary
emp_reg_temp_flag	nvarchar(5)	NULL		No	HrQuickCode
emp_fullpart_time_flag	nvarchar(5)	NULL	Full time/Part time flag	No
sup_employee_code	nvarchar(20)	NOT NULL	Supervisor employee code	No	HrEmpCode
sup_assignment_number	int	NOT NULL	Supervisor assignment number	No	HrAssgnNo
sup_assignment_defined_ou_code	int	NULL	Supervisor assignment defined ou code	No	HrOuInstance
benefit_union_affiliation_code	nvarchar(5)	NULL	Benefit union affliliation code	No	HrQuickCode
benefit_union_group_id	int	NULL	Benefit union group code	No	HrInt
benefit_description	nvarchar(100)	NULL	Benefits description	No	Description
assignment_auth_status	nvarchar(3)	NOT NULL	Assignment Authorisation status	No	hrflag
assignment_auth_date	datetime	NOT NULL	Assignment Authorisation date	No	Datetime
assignment_reject_date	datetime	NULL	Assignment Authorisation rejection date	No
assignment_reject_reason	nvarchar(255)	NULL	Assignment Authorisation rejection reason	No	hrremarks
assignment_activity_type	nvarchar(5)	NULL	Assignment Activity type	No	HrQuickCode
gnmas_ou_code	int	NOT NULL	GNMAS ou code	No	HrOuInstance
orgst_ou_code	int	NOT NULL	Organisational ou code	No
unstr_ou_code	int	NOT NULL	Unit structure ou code	No
hrchy_ou_code	int	NOT NULL	Hiererachy OU code	No
sedef_ou_code	int	NULL	Security Definition OU code	No
source_component_code	nvarchar(20)	NOT NULL	Source component code	No	HrComponentCode
assignment_comments	nvarchar(2000)	NULL	Assignment comments	No	hrnotes
data_override_flag	nvarchar(3)	NULL	Data override flag	No	hrflag
assignment_modify_option	nvarchar(5)	NULL	Assignment Modification option(update or correct)	No	HrQuickCode
new_effective_from_date	datetime	NULL	New effective from date when modification option is Update	No	Datetime
mode_flag	nvarchar(3)	NULL	Modification falg	No	hrflag
doc_id	nvarchar(128)	NULL	Documents ID	No	wfdockey
doc_state	nvarchar(10)	NULL	Documenst Status	No	wfstatename

Table Name: hrei_asgn_hdr

Purpose:	Employee Assignment Header Information
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
Assignment_Nature_Flag	nvarchar(3)	NOT NULL	Flag value: P - Primary Assignment S - Secondary Assignment N - Assignments for Non-Regular Employees	No	hrflag
Assignment_Auth_Status	nvarchar(3)	NULL	Flag Value: Y - Authorized assignment exist N - No Authorized assignment exist	No
Assignment_Pend_Status	nvarchar(3)	NULL	Flag Value: Y - Pending for Authorization records exists N - No Pending for Authorization records exists	No
Assignment_Login_OU_Code	int	NOT NULL	Login Employment OU Code	No	HrOuInstance
Assignment_Language_Code	int	NOT NULL	Login Language	No	HrLangCd

Table Name: hrei_asgn_pend_tmp

Purpose:	Employee Assignment Pending Details temporary table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	Unique GUID generated on every session	No	HrGuid
master_ou_code	int	NULL	Interacting Master OU Code	No	HrOuInstance
employee_code	nvarchar(20)	NULL	Employee Code	No	HrEmpCode
assignment_number	int	NULL	Assignment Number of an employee	No	HrAssgnNo
assignment_defined_ou_code	int	NULL	Assignment Defined OU of an employee	No	HrOuInstance
assignment_effective_from_date	datetime	NULL	Assignment effective from of an employee	No	Datetime
employee_type	nvarchar(5)	NULL	Employee Type	No	HrQuickCode
date_of_joining	datetime	NULL	Date of joining of an employee	No	Datetime
time_of_joining	nvarchar(11)	NULL	Time of joining of an employee	No	Hrtime
employee_name	nvarchar(77)	NULL	Name of an Employee	No	HrEmpName
u_employee_name	nvarchar(500)	NULL	Uppercase Name of an Employee	No	hrtext500
position_title	nvarchar(25)	NULL	Position Title of an emplyee	No	hrpositiontitle
u_position_title	nvarchar(25)	NULL	Uppercase Position Title of an emplyee	No
dept_desc	nvarchar(30)	NULL	Department description of an emplyee	No	hrshortdesc12
u_dept_desc	nvarchar(30)	NULL	Uppercase Department description of an emplyee	No
job_title	nvarchar(25)	NULL	Job Title of an employee	No	hrjobtitle
u_job_title	nvarchar(25)	NULL	Uppercase Job Title of an employee	No
doc_id	nvarchar(128)	NULL	Document ID	No	wfdockey
asgn_status	nvarchar(3)	NULL	Assignment Status	No	hrflag
position_id_or_code	nvarchar(10)	NULL	Position ID or Code	No	hrposncode
job_code	nvarchar(10)	NULL	Job Code of an employee	No	HrCd
dept_code	nvarchar(10)	NULL	Department Code of an employee	No
asgn_dup_flag	nvarchar(3)	NULL	Assignment Duplicate Flag	No	hrflag
assignment_auth_status	varchar(5)	NULL	Assignment Authrisation Status	No	hrquickcode

Table Name: hrei_asgn_qual_auth_map

Purpose:	Employee Assignment - Qualification Mapping Information for every EMPIN OU Code - Pending for Authorization
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
qualification_code	nvarchar(5)	NOT NULL	Qualification Code as created in General Masters Component	Yes	HrCode
Mandatory_Flag	nvarchar(3)	NOT NULL	Mandatory Flag: Values Yes / No (Y/N)	No	hrflag
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode

Table Name: hrei_asgn_qual_hdr

Purpose:	Employee Assignment - Qualification Information for every EMPIN OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
qualification_Login_OU_Code	int	NOT NULL	Login Employment OU Code	No	HrOuInstance
qualification_Reject_Reason	nvarchar(100)	NULL	Rejection Reason as entered by Authorizer. In case of Mulitiple authorization, only last edited rejection reason will be stored.	No	Description
qualification_Auth_Date	datetime	NULL	Authorization Date - System Date	No	Datetime
qualification_Language_Code	int	NOT NULL	Login Language	No	HrLangCd
doc_id	nvarchar(128)	NULL	Unique ID generated by the system to supply info to Workflow	No	wfdockey
doc_state	nvarchar(10)	NULL	Current State of the Document as returned from Workflow	No	wfstatename
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
qualification_Auth_Status	nvarchar(3)	NOT NULL	Flag Value: Y - Authorized asgn-qualification exist N - No Authorized asgn-qualification exist	No	hrflag
qualification_Pend_Status	nvarchar(3)	NOT NULL	Flag Value: Y - Pending for Authorization records exists N - No Pending for Authorization records exists	No
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance

Table Name: hrei_asgn_qual_map

Purpose:	Employee Assignment - Qualification Mapping Information for every EMPIN OU Code – Authorized
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
qualification_Code	nvarchar(5)	NOT NULL	Qualification Code as created in General Masters Component	Yes	HrCode
Mandatory_Flag	nvarchar(3)	NOT NULL	Mandatory Flag: Values Yes / No (Y/N)	No	hrflag
Mode_Flag	nvarchar(3)	NOT NULL	Mode Flag: Request for Addition, Modification, Deletion Values (A/M/D)	No

Table Name: hrei_asgn_qual_tmp

Purpose:	Assignment Qualification temporary table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
GUId	nvarchar(40)	NOT NULL	Unique GUID is generated on every session	Yes	HrGuid
qualification_code	nvarchar(5)	NOT NULL	Qualification Code	Yes	HrCode
Mandatory_Flag	nvarchar(3)	NULL	Mandatory Falg (Y or N)	No	hrflag
MODE_Flag	nvarchar(3)	NULL	Mode flag	No
Login_OU_Code	INT	NULL	Interacting Login OU code	No	HrOuInstance

Table Name: hrei_asgn_reward_auth_dtl

Purpose:	Employee Assignment - Reward Information for every EMPIN OU Code - Pending for Authorization
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Reward_Effective_From_Date	datetime	NOT NULL	Reward - Effective from date for Payment of Reward Installments	No	Datetime
Reward_Effective_To_Date	datetime	NULL	Reward - Effective to date for Payment of Reward Installments - This is not mandatory	No
Reward_Amount	numeric(15,4)	NOT NULL	Reward amount as entered	No	HrSalary
Reward_Date	datetime	NOT NULL	Reward date as entered	No	Datetime
Reward_Remarks	nvarchar(255)	NULL	Reward Remarks as entered	No	hrremarks
Currency_Code	nvarchar(5)	NOT NULL	Currency Code as selected by user - From Enterprise Modeller	No	HrCode
Number_of_Instalments	int	NOT NULL	Number of Instalments as entered	No	HrNumber
Payable_Code	nvarchar(5)	NOT NULL	Payable Through Code is a System defined Quick Code BP: HREI PV: PMOD	No	HrQuickCode
Progression_Code	nvarchar(5)	NOT NULL	Progression Code is a System Defined Quick Code: BP: HREI PV: PROG	No
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Rewarded_By	nvarchar(100)	NOT NULL	Name of the rewarding organization/institution/person as entered	No	Description
Reward_Agency_Code	nvarchar(5)	NOT NULL	Values for Rewarding Agency Code (System Defined Quick Code) - Internal/External BP: HREI PV: RWAG	No	HrQuickCode
Reward_Number	int	NOT NULL	Reward Number - System Generated Number	Yes	HrNumber
Reward_Name	nvarchar(100)	NOT NULL	Name of the Reward as entered	No	Description
Reward_Type	nvarchar(5)	NOT NULL	Values for Reward Type (System Defined Quick Code) BP: HREI PV: RWTY	No	HrQuickCode

Table Name: hrei_asgn_reward_dtl

Purpose:	Employee Assignment - Reward Information for every EMPIN OU Code – Authorized
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
Reward_Number	int	NOT NULL	Reward Number - System Generated Number	Yes	HrNumber
Reward_Type	nvarchar(5)	NOT NULL	Values for Reward Type (System Defined Quick Code) BP: HREI PV: RWTY	No	HrQuickCode
Reward_Name	nvarchar(100)	NOT NULL	Name of the Reward as entered	No	Description
Reward_Agency_Code	nvarchar(5)	NOT NULL	Values for Rewarding Agency Code (System Defined Quick Code) - Internal/External BP: HREI PV: RWAG	No	HrQuickCode
Rewarded_By	nvarchar(100)	NOT NULL	Name of the rewarding organization/institution/person as entered	No	Description
Reward_Date	datetime	NOT NULL	Reward date as entered	No	Datetime
Reward_Amount	numeric(15,4)	NOT NULL	Reward amount as entered	No	HrSalary
Reward_Effective_From_Date	datetime	NOT NULL	Reward - Effective from date for Payment of Reward Installments	No	Datetime
Reward_Effective_To_Date	datetime	NULL	Reward - Effective to date for Payment of Reward Installments - This is not mandatory	No
Currency_Code	nvarchar(5)	NOT NULL	Currency Code as selected by user - From Enterprise Modeller	No	HrCode
Payable_Code	nvarchar(5)	NOT NULL	Payable Through Code is a System defined Quick Code BP: HREI PV: PMOD	No	HrQuickCode
Number_of_Instalments	int	NOT NULL	Number of Instalments as entered	No	HrNumber
Reward_Remarks	nvarchar(255)	NULL	Reward Remarks as entered	No	hrremarks
Progression_Code	nvarchar(5)	NOT NULL	Progression Code is a System Defined Quick Code: BP: HREI PV: PROG	No	HrQuickCode
Mode_Flag	nvarchar(3)	NOT NULL	Mode Flag: Request for Addition, Modification, Deletion Values (A/M/D)	No	hrflag

Table Name: hrei_asgn_reward_hdr

Purpose:	Employee Assignment - Reward Information for every EMPIN OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Reward_Rejection_Reason	nvarchar(100)	NULL	Rejection Reason as entered by Authorizer. In case of Mulitiple authorization, only last edited rejection reason will be stored.	No	Description
Reward_Auth_Date	datetime	NULL	Authorization Date - System Date	No	Datetime
Reward_Auth_Status	nvarchar(3)	NOT NULL	Flag Value: Y - Authorized asgn-reward exist N - No Authorized asgn-reward exist	No	hrflag
doc_id	nvarchar(128)	NULL	Unique ID generated by the system to supply info to Workflow	No	wfdockey
Reward_Login_OU_Code	int	NOT NULL	Login Employment OU Code	No	HrOuInstance
Reward_Language_Code	int	NOT NULL	Login Language	No	HrLangCd
doc_state	nvarchar(10)	NULL	Current State of the Document as returned from Workflow	No	wfstatename
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Reward_Pend_Status	nvarchar(3)	NOT NULL	Flag Value: Y - Pending for Authorization records exists N - No Pending for Authorization records exists	No	hrflag
Reward_Number	int	NOT NULL	Reward Number - System Generated Number	Yes	HrNumber
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance

Table Name: hrei_asgn_reward_pyau_dtl

Purpose:	Employee Assignment - Reward frequency Breakup Information for every EMPIN OU Code - Pending for Authorization
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Payroll_Amount	numeric(15,4)	NULL	Amount considered for Payment thru Payroll	No	HrSalary
Payroll_Date	datetime	NULL	Payroll Processed Date	No	Datetime
Payroll_Status	nvarchar(3)	NULL	Status of Payroll w.r.t this reward. Values: Will be NP when created. P,A,U based on payroll processing BP:GEN PV: PRC	No	hrflag
payset_code	nvarchar(10)	NULL	Payset Mapped to the Employee Assignment in Payroll	No	HrCd
payrollou	int	NULL	Payroll OU Instance Code	No	HrOuInstance
payroll_code	nvarchar(5)	NULL	Payroll Process Code	No	HrCode
process_period_code	nvarchar(5)	NULL	Payroll Process Period Code	No
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Reward_Payment_Amount	numeric(15,4)	NOT NULL	Reward Instalment Amount - Calculated. Can be modified by user	No	HrSalary
Reward_Payment_Date	datetime	NOT NULL	Reward Payment Date - Calculated based on Effective From date and number of instalments, can be modified by user	Yes	Datetime
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
Reward_Number	int	NOT NULL	Reward Number - System Generated	Yes	HrNumber

Table Name: hrei_asgn_reward_pymt_dtl

Purpose:	Employee Assignment - Reward frequency Breakup Information for every EMPIN OU Code – Authorized
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Payroll_Amount	numeric(15,4)	NULL	Amount considered for Payment thru Payroll	No	HrSalary
Payroll_Date	datetime	NULL	Payroll Processed Date	No	Datetime
Payroll_Status	nvarchar(3)	NULL	Status of Payroll w.r.t this reward. Values: Will be NP when created. P,A,U based on payroll processing BP:GEN PV: PRC	No	hrflag
payset_code	nvarchar(10)	NULL	Payset Mapped to the Employee Assignment in Payroll	No	HrCd
payrollou	int	NULL	Payroll OU Instance Code	No	HrOuInstance
payroll_code	nvarchar(5)	NULL	Payroll Process Code	No	HrCode
process_period_code	nvarchar(5)	NULL	Payroll Process Period Code	No
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Reward_Payment_Amount	numeric(15,4)	NOT NULL	Reward Instalment Amount - Calculated. Can be modified by user	No	HrSalary
Reward_Payment_Date	datetime	NOT NULL	Reward Payment Date - Calculated based on Effective From date and number of instalments, can be modified by user	Yes	Datetime
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
Reward_Number	int	NOT NULL	Reward Number - System Generated	Yes	HrNumber

Table Name: hrei_asgn_tmp

Purpose:	Employee Assignment Information - Temporary Table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	Unique GUID generated on every session	No	HrGuid
master_ou_code	int	NULL	Interacting Master OU Code	No	HrOuInstance
employee_code	nvarchar(20)	NULL	Employee Code	No	HrEmpCode
assignment_number	int	NULL	Assignment Number of an employee	No	HrAssgnNo
assignment_defined_ou_code	int	NULL	Assignment Defined OU of an employee	No	HrOuInstance
assignment_effective_from_date	datetime	NULL	Assignment effective from of an employee	No	Datetime
assignment_effective_to_date	datetime	NULL	Assignment effective toof an employee	No
assignment_auth_status	varchar(5)	NULL	Assignement Authorisation status	No	hrquickcode
employee_type	nvarchar(5)	NULL	Employement Type	No	HrQuickCode
date_of_joining	datetime	NULL	Date of Joining Of an employee	No	Datetime
time_of_joining	nvarchar(11)	NULL	Time of Joining	No	Hrtime
employee_name	nvarchar(77)	NULL	Name of an employee	No	HrEmpName
u_employee_name	nvarchar(500)	NULL	Upper case Name of an employee	No	hrtext500
position_title	nvarchar(25)	NULL	Position title of an employee	No	hrpositiontitle
u_position_title	nvarchar(25)	NULL	Uppercase Position title of an employee	No
dept_desc	nvarchar(30)	NULL	Department description of an employee	No	hrshortdesc12
u_dept_desc	nvarchar(30)	NULL	upper case Department description of an employee	No
job_title	nvarchar(25)	NULL	Job title of an employee	No	hrjobtitle
u_job_title	nvarchar(25)	NULL	Uppercase Djob title of an employee	No
doc_id	nvarchar(128)	NULL	Document Id	No	wfdockey
asgn_status	nvarchar(3)	NULL	Assignment status	No	hrflag
position_id_or_code	nvarchar(10)	NULL	Position ID or Code	No	hrposncode
job_code	nvarchar(10)	NULL	Job Code of an employee	No	HrCd
dept_code	nvarchar(10)	NULL	Department Code of an employee	No
gnmas_ou_code	int	NULL	Interacting GNMAS OU code	No	hrouinstance
orgst_ou_code	int	NULL	Organisational Unit Code	No
unstr_ou_code	int	NULL	Unit Structure OU code	No
hrchy_ou_code	int	NULL	Hirerachy OU code	No
sedef_ou_code	int	NULL	Security Definition OU Code	No

Table Name: hrei_assgn_competency_tmp

Purpose:	Assignment Competency temporary table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
GUId	nvarchar(40)	NOT NULL	Unique GUID generated on every session	No	HrGuid
master_ou_code	int	NOT NULL	Interacting EMPNG OU Code	No	hrouinstance
employee_code	nvarchar(20)	NULL	Employee Code	No	HrEmpCode
assignment_number	int	NULL	Assignment Number	No	HrAssgnNo
empin_ou_code	int	NULL	Employee OU code	No	hrouinstance
Competency_Code	nvarchar(10)	NOT NULL	Competency Code	No	hrcompcode
Competency_mdl	INT	NULL	Competency minimum desired level	No	hrelementmdl
Competency_Weightage	numeric(5,2)	NULL	Competency Weightage	No	HrCompWeight
Competency_Weightage_Per	numeric(5,2)	NULL	Competency Weightage percentage	No
position_code	nvarchar(10)	NULL	Position code	No	hrposncode
job_code	nvarchar(10)	NULL	Job Code	No	hrcd
dept_code	nvarchar(10)	NULL	Department code	No
orgst_ou_code	int	NULL	Organisational OU code	No	hrouinstance
unstr_ou_code	int	NULL	Unit structure OU code	No
mandatory_flag	nvarchar(3)	NULL	Mandatory Flag	No	hrflag
mode_flag	nvarchar(3)	NULL	Mode Flag	No

Table Name: hrei_award_srch_tmp

Purpose:	Employee Assignment - Award Details For Search - temporary table
Column Name	Column Datatype		Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL		Unique GUID is generated on every session	No	HrGuid
master_ou_code	int	NULL		Interacting Master OU code	No	HrOuInstance
employee_code	nvarchar(20)	NULL		Employee Code	No	HrEmpCode
assignment_number	int	NULL		Assignment Number of an employee	No	HrAssgnNo
assignment_defined_ou_code	int	NULL		Assignment defined OU code	No	HrOuInstance
effective_from_date	datetime	NULL		Effective from date of an employee	No	Datetime
employee_type	nvarchar(5)	NULL		Employee type	No	HrQuickCode
employee_name	nvarchar(77)	NULL		Name of the employee	No	HrEmpName
position_title	nvarchar(25)	NULL		Position title of an employee	No	hrpositiontitle
u_position_title	nvarchar(25)	NULL		Uppercase Position title of an employee	No
dept_desc	nvarchar(30)	NULL		Department description	No	hrshortdesc12
u_dept_desc	nvarchar(30)	NULL		Uppercase Department description	No
job_title	nvarchar(25)	NULL		Job title of an employee	No	hrjobtitle
u_job_title	nvarchar(25)	NULL		Uppercase Job title of an employee	No
position_id_or_code	nvarchar(10)	NULL		Position ID or code	No	hrposncode
job_code	nvarchar(10)	NULL		Job Code of an employee	No	HrCd
dept_code	nvarchar(10)	NULL		Department Code of an employee	No
record_status	varchar(5)	NULL		Record Status	No	hrquickcode
record_desc	nvarchar(40)	NULL		Record status description	No	HrQuickCodeDesc
u_search_name	nvarchar(500)	NULL		Alias name of an employee	No	hrtext500
orgst_ou_code	int	NULL		Organisational OU code	No	hrouinstance
unstr_ou_code	int	NULL		Unit structure OU code	No

Table Name: HREI_COMP_WT_CAL_TMP

Purpose:	Assignment Competency Calculation temporary table
Column Name	Column Datatype		Column Null Option	Column Comment	Column Is PK	Column Domain Name
GUId	nvarchar(40)	NOT NULL		Unique GUID generated on every session	Yes	HrGuid
slno	int	NOT NULL		Serial Number	Yes	HrInt
Competency_Code	nvarchar(10)	NOT NULL		Competency Code	Yes	hrcompcode
Competency_Description	nvarchar(100)	NULL		Competency Description	No	HrDescription100
Competency_Min_Desired_Level	INT	NULL		Competency minimun desired level	No	hrelementmdl
Competency_Weightage	numeric(5,2)	NULL		Competency weighatege	No	HrCompWeight
Competency_Weightage_Per	numeric(5,2)	NULL		Competency weighatge percentage	No
Mandatory_Flag	nvarchar(3)	NULL		Mandatory Flag	No	hrflag
Login_OU_Code	INT	NULL		Interacting Login OU code	No	HrOuInstance
Mode_Flag	nvarchar(3)	NULL		Modification Flag	No	hrflag

Table Name: hrei_compy_srch_tmp

Purpose:	Employee Assignment - Competency Details For Search - temporary table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	Unique GUID generated on every session	No	HrGuid
master_ou_code	int	NULL	Intracting Master OU Code	No	HrOuInstance
employee_code	nvarchar(20)	NULL	Employee Code	No	HrEmpCode
assignment_number	int	NULL	Assignment Number of an employee	No	HrAssgnNo
assignment_defined_ou_code	int	NULL	Assignment defined ou code	No	HrOuInstance
effective_from_date	datetime	NULL	Effective from date of an employee	No	Datetime
employee_type	nvarchar(5)	NULL	Employee Type	No	HrQuickCode
employee_name	nvarchar(77)	NULL	Employee Name	No	HrEmpName
position_title	nvarchar(25)	NULL	Position title of an employee	No	hrpositiontitle
u_position_title	nvarchar(25)	NULL	Uppercase Position title of an employee	No
dept_desc	nvarchar(30)	NULL	department description of an employee	No	hrshortdesc12
u_dept_desc	nvarchar(30)	NULL	Uppercase department description of an employee	No
job_title	nvarchar(25)	NULL	Job Title of an employee	No	hrjobtitle
u_job_title	nvarchar(25)	NULL	Uppercase Job Title of an employee	No
position_id_or_code	nvarchar(10)	NULL	Position Code of an employee	No	hrposncode
job_code	nvarchar(10)	NULL	Job Code of an employee	No	HrCd
dept_code	nvarchar(10)	NULL	Department Code	No
record_status	varchar(5)	NULL	Record status	No	hrquickcode
record_desc	nvarchar(40)	NULL	Record Description	No	HrQuickCodeDesc
u_search_name	nvarchar(500)	NULL	Alias Name	No	Hrtext500
orgst_ou_code	int	NULL	Organisational OU Code	No	hrouinstance
unstr_ou_code	int	NULL	Unit Structure OU Code	No

Table Name: hrei_emp_mgr_dtls

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_ou_code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Employee code under EMPNG OU as entered by the user.	Yes	HrEmpCode
asgn_no	int	NOT NULL	The assignment number of the employee.	Yes	HrAssgnNo
eff_from_date	datetime	NOT NULL	The date from which the manager details are effective.	Yes	effectivedate
func_sup1_cd	nvarchar(20)	NOT NULL	The code identifying the first functional superior of the employee.	Yes	HrEmpCode
eff_to_date	datetime	NULL	The date till which the manager details are effective.	No	effectivedate
func_sup2_cd	nvarchar(20)	NULL	The code identifying the second functional superior of the employee.	No	HrEmpCode
admin_sup_cd	nvarchar(20)	NULL	The code identifying the HR administrative superior of the employee.	No
remarks	nvarchar(255)	NULL	Any additional remarks pertaining to the manager details.	No	text255

Table Name: hrei_emp_nspec_award_dtl

Purpose:	Employee Award Detail Information Non-Specific to Assignments for every EMPIN OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOUInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
empin_ou_code	int	NOT NULL	Employment Information OU Code	Yes	HrOuInstance
award_number	int	NOT NULL	System Generated Number for every non-assignment specific award detail	Yes	HrNumber
award_name	nvarchar(100)	NULL	Award Name - non specific to assignments	No	Description
awarded_by	nvarchar(100)	NULL	Awarding Agency Code	No
award_date	datetime	NULL	Awarded Date	No	Datetime
award_amount	nvarchar(40)	NULL	Awarded Amount	No	HrBusinessProcess
currency_code	nvarchar(5)	NULL	Awarded Amount Currency Code	No	HrCode

Table Name: hrei_emp_nspec_award_hdr

Purpose:	Employee Award Header Information Non-Specific to Assignments
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOUInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
empin_ou_code	int	NOT NULL	Employment Information OU Code	Yes	HrOuInstance

Table Name: hrei_emp_nspec_mship_dtl

Purpose:	Employee Membership Detail Information Non-Specific to Assignments
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Interacting EMPNG OU Code	Yes	hrouinstance
employee_code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
empin_ou_code	int	NOT NULL	Employment Information OU Code	Yes	hrouinstance
serial_number	int	NOT NULL	System Generated Number for every Non-assignment specific Membership detail	Yes	HrInt
association_name	nvarchar(40)	NOT NULL	Association Name in which the employee is a member	No	HrQuickCodeDesc
legal_status_code	nvarchar(5)	NULL	Legal status of the association	No	HrQuickCode
currency_code	nvarchar(5)	NOT NULL	Currency code for Registration charges and Subscription amount	No	HrCode
registration_charges	numeric(15,4)	NULL	Association Registration charges	No	HrSalary
total_subscription_amount	numeric(15,4)	NOT NULL	Total	No
mship_date	datetime	NOT NULL	Membership Date of the Employee	No	Datetime
mship_enddate	datetime	NULL	Membership End Date	No

Table Name: hrei_emp_nspec_mship_hdr

Purpose:	Employee Membership Header Information Non-Specific to Assignments
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Interacting EMPNG OU Code	Yes	hrouinstance
employee_code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
empin_ou_code	int	NOT NULL	Employment Information OU Code	Yes	hrouinstance

Table Name: hrei_emp_nspec_reward_dtl

Purpose:	Employee Reward Detail Information Non-Specific to Assignments for every EMPIN OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOUInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
empin_ou_code	int	NOT NULL	Employment Information OU Code	Yes	HrOuInstance
reward_number	int	NOT NULL	System Generated Number for every non-assignment specific reward detail	Yes	HrNumber
reward_name	nvarchar(100)	NULL	Reward Name - non specific to assignments	No	Description
rewarded_by	nvarchar(100)	NULL	Rewarding Agency Code	No
reward_date	datetime	NULL	Rewarded Date	No	Datetime
reward_amount	nvarchar(40)	NULL	Rewarded Amount	No	HrBusinessProcess
currency_code	nvarchar(5)	NULL	Rewarded Amount Currency Code	No	HrCode

Table Name: hrei_emp_nspec_reward_hdr

Purpose:	Employee Reward Header Information Non-Specific to Assignments
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOUInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
empin_ou_code	int	NOT NULL	Employment Information OU Code	Yes	HrOuInstance

Table Name: hrei_emp_pension_hhdr

Purpose:	This table stores the details of the pension
Column Name	Column Datatype		Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL		Interacting Master OU code	Yes	HrOUInstance
employee_code	nvarchar(20)	NOT NULL		Employee Code	Yes	HrEmpCode
pensionf_code	nvarchar(10)	NOT NULL		Pension code of an employee	Yes	HrCd
effective_from	datetime	NOT NULL		Effective from date of an employee	Yes	Datetime
pensionf_no	nvarchar(10)	NULL		Pension Number	No	HrCd
pension_doj	datetime	NULL		Joining date of the pension	No	Datetime
effective_to	datetime	NULL		Effective to date	No

Table Name: hrei_emp_pf_dtl

Purpose:	This table stores the Employee PF
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Interacting Master OU code	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
pf_trust	nvarchar(10)	NOT NULL	PF trust number	Yes	HrCd
pf_no	nvarchar(10)	NOT NULL	PF number	Yes	hrchar10
doj_pf	datetime	NOT NULL	Date of joining of PF	Yes	Datetime
eps_applicable	nvarchar(5)	NULL		No	HrQuickCode
eps_no	nvarchar(11)	NULL		No	HrDtFmt
inactive_flag	nvarchar(5)	NULL	Active Flag ( y or n)	No	HrQuickCode
settlement_status	nvarchar(40)	NULL	Settlements status	No	HrQuickCodeDesc
contrib_termination_dt	datetime	NULL	Contribution termination date	No	Datetime
pf_settlement_dt	datetime	NULL	PF settlement date	No
remarks	nvarchar(255)	NULL	remarks	No	HrText255
payroll_unit_code	nvarchar(10)	NULL	Payroll unit code	No	HrCd

Table Name: hrei_emp_pf_hdr

Purpose:	This table stores the Employee PF details
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Interacting Master OU code	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
doj_prev_pf	datetime	NULL	Date of joining of Previous PF	No	Datetime
remarks	nvarchar(1000)	NULL	Remarks	No	hrText1000

Table Name: hrei_emp_pf_pn_nomination_dtl

Purpose:	This table stores the employee PF nomination details
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Interacting Master OU code	Yes	hrouinstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
effective_from	datetime	NOT NULL	Effective from date	Yes	Datetime
sl_no	int	NOT NULL	Serial Number	Yes	HrInt
fund_no	nvarchar(10)	NOT NULL	Fund Number	Yes	hrchar10
fund_name_cd	nvarchar(10)	NOT NULL	Funcd Name code	Yes	HrCd
effective_to	datetime	NULL	Effective to date	No	Datetime
nominee_name	nvarchar(77)	NULL	Nominee Name	No	HrEmpName
relationship	nvarchar(5)	NULL	Relation ship	No	HrQuickCode
dob	datetime	NULL	Date of birht of an employee	No	Datetime
percent_of_share	numeric(6,2)	NULL	Percentage of share	No	hrapprrating
dependant	nvarchar(5)	NULL	Dependant of an employee	No	HrQuickCode
address1	nvarchar(40)	NULL	Address of an employee	No	HrAddress
address2	nvarchar(40)	NULL	Address of an employee	No
address3	nvarchar(40)	NULL	Address of an employee	No
state	nvarchar(10)	NULL	State	No	hrstatecode
country	nvarchar(5)	NULL	Country	No	HrQuickCode
pincode	nvarchar(40)	NULL	c	No	HrZip
phone_no	nvarchar(20)	NULL	Phone Number	No	HrPhone
guardian_name	nvarchar(255)	NULL	Guardian Name	No	hrremarks
remarks	nvarchar(255)	NULL	Remarks	No

Table Name: hrei_emp_pf_pn_nomination_hdr

Purpose:	This table stores the employee PF nomination details
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Interating master ou code	Yes	hrouinstance
employee_code	nvarchar(20)	NOT NULL	employee code	Yes	HrEmpCode
effective_from	datetime	NOT NULL	Effective from date	Yes	Datetime
fund_no	nvarchar(10)	NOT NULL	Fund number	Yes	hrchar10
fund_name_cd	nvarchar(10)	NOT NULL	Fund Name Code	Yes	HrCd
spouse_name	nvarchar(77)	NULL	Spouse name	No	HrEmpName
spouse_dob	datetime	NULL	Spouse Date of joining	No	Datetime
remarks	nvarchar(1000)	NULL	Remarks	No	hrText1000

Table Name: hrei_last_doc_id

Purpose:	Last Document Number table with Parameter value for Asignment, Award, Reward, Membership
Column Name	Column Datatype	Column Null Option	Column Comment		Column Is PK	Column Domain Name
doc_type	nvarchar(5)	NOT NULL		Document Type Values: AC - Assignment Competency AQ - Assignment Qualification AW - Assignment - Award N - Non-regular Assignment OMD - Official Membership P - Primary Assignment RW - Assignment Reward S - Secondary Assignment TAC - Terms and Conditions	Yes	HrQuickCode
last_doc_id	int	NULL		Last Document Number - For the system to generate	No	HrInt

Table Name: hrei_mgr_dtls

Purpose:	This table stores the manager details for a department and we can store he is HOD of the department also.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
dept_code	nvarchar(10)	NOT NULL	The department to which the manager belongs.	Yes	HrCd
mgr_cd	nvarchar(20)	NOT NULL	The employee code of the manager.	Yes	HrEmpCode
eff_from_date	datetime	NOT NULL	The date from which the manager s administration was effective.	Yes	effectivedate
eff_to_date	datetime	NULL	The date till which the manager s administration was effective.	No
deleg_user	nvarchar(20)	NULL	The code identifying the user who is delegated by the manager on his/her behalf.	No	HrEmpCode
is_hod	nvarchar(40)	NULL	Is HOD value as selected by the user in the Is HOD combo. System defined quick code. BP = 'EPIN' PV = 'DEPN' Eg> Yes,No,etc	No	HrYesNo
remarks	nvarchar(255)	NULL	Any additional details pertaining to manager details.	No	text255

Table Name: hrei_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)	NULL	SP, ASP, DLL	No	HrCode
base_or_ext_flag	nvarchar(3)	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: hrei_off_mship_auth_dtl

Purpose:	Employee Assignment - Membership Information for every EMPIN OU Code – Authorized
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
Official_Mship_Number	int	NOT NULL	Official Membership Number - System Generated	Yes	HrNumber
Association_Code	nvarchar(10)	NOT NULL	Association Code is User Defined Quick Code. BP: HREI PV: ASSN	No	HrOrgCode
legal_status_code	nvarchar(5)	NULL	Legal Status Code is User Defined Quick Code. BP: HREI PV: LEGS	No	HrQuickCode
internal_flag	nvarchar(5)	NULL	Internal Flag: Values: Yes/No [Y/N]	No
Member_Group_Code	nvarchar(5)	NOT NULL	Type of Member group Code is User Defined Quick Code. BP: HREI PV: MGTY	No
Currency_Code	nvarchar(5)	NOT NULL	Currency code as selected by user. This is from Enterprise Modeller	No	HrCode
Registration_Charges	numeric(15,4)	NOT NULL	Registration Charges as entered	No	HrSalary
Total_Subscription_Amount	numeric(15,4)	NOT NULL	Total Subscription amount as entered	No
Mship_Date	datetime	NOT NULL	Membership Date	No	Datetime
Mship_Period_Number	int	NULL	Membership Period as entered by user	No	HrNumber
Mship_Period_Code	nvarchar(5)	NULL	Unit Duration for Membership period - System defined quick code BP: EPIN PV: UNDN	No	HrQuickCode
Official_Mship_Remarks	nvarchar(255)	NULL	Membership remarks as entered	No	hrremarks

Table Name: hrei_off_mship_dtl

Purpose:	Employee Assignment - Membership Information for every EMPIN OU Code - Pending Authorized
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
Official_Mship_Number	int	NOT NULL	Official Membership Number - System Generated	Yes	HrNumber
Association_Code	nvarchar(10)	NOT NULL	Association Code is User Defined Quick Code. BP: HREI PV: ASSN	No	HrOrgCode
legal_status_code	nvarchar(5)	NULL	Legal Status Code is User Defined Quick Code. BP: HREI PV: LEGS	No	HrQuickCode
internal_flag	nvarchar(5)	NULL	Internal Flag: Values: Yes/No [Y/N]	No
Member_Group_Code	nvarchar(5)	NOT NULL	Type of Member group Code is User Defined Quick Code. BP: HREI PV: MGTY	No
Currency_Code	nvarchar(5)	NOT NULL	Currency code as selected by user. This is from Enterprise Modeller	No	HrCode
Registration_Charges	numeric(15,4)	NULL	Registration Charges as entered	No	HrSalary
Total_Subscription_Amount	numeric(15,4)	NOT NULL	Total Subscription amount as entered	No
Mship_Date	datetime	NOT NULL	Membership Date	No	Datetime
Mship_Period_Number	int	NULL	Membership Period as entered by user	No	HrNumber
Mship_Period_Code	nvarchar(5)	NULL	Unit Duration for Membership period - System defined quick code BP: EPIN PV: UNDN	No	HrQuickCode
Official_Mship_Remarks	nvarchar(255)	NULL	Membership remarks as entered	No	hrremarks
Mode_Flag	nvarchar(3)	NOT NULL	Mode Flag: Request for Addition, Modification, Deletion Values (A/M/D)	No	hrflag

Table Name: hrei_off_mship_hdr

Purpose:	Employee Assignment - Membership Information for every EMPIN OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
Official_Mship_Number	int	NOT NULL	Official Membership Number - System Generated	Yes	HrNumber
Official_Mship_Pend_Status	nvarchar(3)	NOT NULL	Flag Value: Y - Pending for Authorization records exists N - No Pending for Authorization records exists	No	hrflag
Official_Mship_Auth_Status	nvarchar(3)	NOT NULL	Flag Value: Y - Authorized asgn-off-membership exist N - No Authorized asgn-off-membership exist	No
Official_Mship_Auth_Date	datetime	NULL	Authorization Date - System Date	No	Datetime
Official_Mship_Reject_Reason	nvarchar(100)	NULL	Rejection Reason as entered by Authorizer. In case of Mulitiple authorization, only last edited rejection reason will be stored.	No	Description
Official_Mship_Login_OU_Code	int	NOT NULL	Login Employment OU Code	No	HrOuInstance
Official_Mship_Language_Code	int	NOT NULL	Login Language	No	HrLangCd
doc_id	nvarchar(128)	NULL	Unique ID generated by the system to supply info to Workflow	No	wfdockey
doc_state	nvarchar(10)	NULL	Current State of the Document as returned from Workflow	No	wfstatename

Table Name: hrei_prob_excep_dtl

Purpose:
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.	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	The code identifying the employee.	Yes	HrEmpCode
prob_period	int	NULL	Probation Duration of the employee.	No	HrInt
prob_period_units	nvarchar(5)	NULL	Probation Period Units as selected by the user. System Defined Quick Code BP = 'EPIN' PV = 'UNDN' Eg> Days,Months,etc	No	HrQuickCode
prob_extn_period	int	NULL	Extended Probation Duration of the employee.	No	HrInt
prob_extn_period_units	nvarchar(5)	NULL	Probation Extended Period Units as selected by the user. System Defined Quick Code BP = 'EPIN' PV = 'UNDN' Eg> Days,Months,etc	No	HrQuickCode
medical_checkup_date	datetime	NULL	The date on which Medical Check Up has to be done.	No	Datetime
remarks	nvarchar(255)	NULL	Any additional remarks pertaining to the employee s probation.	No	hrremarks

Table Name: hrei_qual_srch_tmp

Purpose:	Employee Assignment - Qualification Details For Search - temporary table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	Unique GUID code generated on every session	No	HrGuid
master_ou_code	int	NULL	Interacting Master OU code	No	HrOuInstance
employee_code	nvarchar(20)	NULL	Employee Code	No	HrEmpCode
assignment_number	int	NULL	Assignment Number of an employee	No	HrAssgnNo
assignment_defined_ou_code	int	NULL	Assignment defined OU code	No	HrOuInstance
effective_from_date	datetime	NULL	Effective from date of an employee	No	Datetime
employee_type	nvarchar(5)	NULL	Employee Type	No	HrQuickCode
employee_name	nvarchar(77)	NULL	Name of the employee	No	HrEmpName
position_title	nvarchar(25)	NULL	Position title	No	hrpositiontitle
u_position_title	nvarchar(25)	NULL	Uppercase of Position title	No
dept_desc	nvarchar(30)	NULL	Department description	No	hrshortdesc12
u_dept_desc	nvarchar(30)	NULL	Uppercase of Department description	No
job_title	nvarchar(25)	NULL	job title	No	hrjobtitle
u_job_title	nvarchar(25)	NULL	Uppercase of job title	No
position_id_or_code	nvarchar(10)	NULL	Position Code	No	hrposncode
job_code	nvarchar(10)	NULL	Job Code	No	HrCd
dept_code	nvarchar(10)	NULL	Department code	No
record_status	varchar(5)	NULL	Record status	No	hrquickcode
record_desc	nvarchar(40)	NULL	Record description	No	HrQuickCodeDesc
u_search_name	nvarchar(500)	NULL	Alias Name	No	hrtext500
orgst_ou_code	int	NULL	Organisational OU code	No	hrouinstance
unstr_ou_code	int	NULL	Unit structure OU code	No

Table Name: HREI_REWARD_COMPUTE_TMP

Purpose:	Assignment - Reward calculation temporary table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
GUID	nvarchar(40)	NOT NULL	Unique GUID generated on every session	Yes	HrGuid
rownum	INT	NOT NULL	h / # # $	Yes	HrInt
MASTER_OU_CODE	INT	NULL	Interacting Master OU code	No	HrOuInstance
REWARD_VALUE	FLOAT	NULL	Rewqrd Value	No	HrSalary
NO_OF_INSTALMENT	INT	NULL	Number of installments	No	HrInt
EFF_FROM_DATE	datetime	NULL	Effective from date	No	Datetime
EFF_TO_DATE	datetime	NULL	Effective to date	No
PROGRESSION_CODE	nvarchar(5)	NULL	Progression Code	No	HrQuickCode
DATE_OF_PAY	datetime	NULL	Date of Pay	No	Datetime
INSTAL_AMOUNT	FLOAT	NULL	Install Amount	No	HrSalary
PROCESS_DETAIL	nvarchar(25)	NULL	Process Details	No	HrDescription
HDN_DATE_OF_PAY	datetime	NULL	HDN Date of pay	No	Datetime
HDN_INSTAL_AMOUNT	FLOAT	NULL	HDN install amount	No	HrSalary
HDN_PROCESS_FLAG	nvarchar(3)	NULL	HDN process falg	No	hrflag

Table Name: hrei_reward_srch_tmp

Purpose:	Employee Assignment - Reward Details For Search - temporary table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	Unique GUID is generated on every session	No	HrGuid
master_ou_code	int	NULL	Interacting Master OU code	No	HrOuInstance
employee_code	nvarchar(20)	NULL	Employee Code	No	HrEmpCode
assignment_number	int	NULL	Assignment Number of an employee	No	HrAssgnNo
assignment_defined_ou_code	int	NULL	Assignment defined OU Code	No	HrOuInstance
effective_from_date	datetime	NULL	Effective from date of an employee	No	Datetime
employee_type	nvarchar(5)	NULL	Employee Type	No	HrQuickCode
employee_name	nvarchar(77)	NULL	Employee Name	No	HrEmpName
position_title	nvarchar(25)	NULL	Position Title	No	hrpositiontitle
u_position_title	nvarchar(25)	NULL	Uppercase of Position Title	No
dept_desc	nvarchar(30)	NULL	Department Description	No	hrshortdesc12
u_dept_desc	nvarchar(30)	NULL	Uppercase of Department Description	No
job_title	nvarchar(25)	NULL	Job Title	No	hrjobtitle
u_job_title	nvarchar(25)	NULL	Uppercase of Job Title	No
position_id_or_code	nvarchar(10)	NULL	Position ID	No	hrposncode
job_code	nvarchar(10)	NULL	Job Code	No	HrCd
dept_code	nvarchar(10)	NULL	Department code	No
record_status	varchar(5)	NULL	7 rd status	No	hrquickcode
record_desc	nvarchar(40)	NULL	Record Description	No	HrQuickCodeDesc
u_search_name	nvarchar(500)	NULL	Alias Name of Employee	No	hrtext500
orgst_ou_code	int	NULL	Organisational OU code	No	hrouinstance
unstr_ou_code	int	NULL	Unit Structure OU code	No

Table Name: hrei_rmed_srch_tmp

Purpose:	Employee Assignment - Membership Details For Search - temporary table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	Unique GUID generated on every session	No	HrGuid
master_ou_code	int	NULL	Interacting Master OU Code	No	HrOuInstance
employee_code	nvarchar(20)	NULL	Employee Code	No	HrEmpCode
assignment_number	int	NULL	Assignment Number of an employee	No	HrAssgnNo
assignment_defined_ou_code	int	NULL	Assignment OU code	No	HrOuInstance
effective_from_date	datetime	NULL	Effective from date	No	Datetime
employee_type	nvarchar(5)	NULL	Employee Type	No	HrQuickCode
employee_name	nvarchar(77)	NULL	Employee Name	No	HrEmpName
position_title	nvarchar(25)	NULL	Position Title	No	hrpositiontitle
u_position_title	nvarchar(25)	NULL	Uppercase of Position Title	No
dept_desc	nvarchar(30)	NULL	Department Description	No	hrshortdesc12
u_dept_desc	nvarchar(30)	NULL	Uppercase of Department Description	No
job_title	nvarchar(25)	NULL	Job title	No	hrjobtitle
u_job_title	nvarchar(25)	NULL	Uppercase of Job title	No
position_id_or_code	nvarchar(10)	NULL	Position ID	No	hrposncode
job_code	nvarchar(10)	NULL	Job Code	No	HrCd
dept_code	nvarchar(10)	NULL	Dept Code	No
record_status	varchar(5)	NULL	Record status	No	hrquickcode
record_desc	nvarchar(40)	NULL	Record description	No	HrQuickCodeDesc
u_search_name	nvarchar(500)	NULL	Upper case of Search name for index purpose	No	hrtext500
orgst_ou_code	int	NULL	Organisational OU code	No	hrouinstance
unstr_ou_code	int	NULL	Unit Structure OU code	No

Table Name: hrei_terms_condn_auth_dtl

Purpose:	Employee Assignment - Terms & Conditions Information for every EMPIN OU Code - Pending for Authorization
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
terms_condn_id	int	NOT NULL	System Generated Number	Yes	HrInt
Terms_Condn_Code	nvarchar(5)	NOT NULL	Terms & Condn Codes are User defined Quick Codes. BP: HREI PV: TERM Values: Bond & Notice Period (In Days) alone cannot be modified by User	No	HrQuickCode
terms_condn_period	nvarchar(25)	NULL	Terms & Condn Period as entered. Should be an integer value for Notice Period (In Days)	No	HrDescription
Terms_Condn_From_Date	datetime	NOT NULL	Terms & Condn From Date as entered. Should be the Separation Request Date (For Notice Period - In days)	No	Datetime
Terms_Condn_To_Date	datetime	NULL	Terms & Condn From Date as entered. Should be the Separation Request Date + terms_condn_period (days) (For Notice Period - In days)	No
Currency_Code	nvarchar(5)	NULL	Currency Code as selected by user. This is from Enterprise Modeller	No	HrCode
Terms_Condn_Amount	numeric(15,4)	NULL	Terms & Condition Amount as entered	No	HrSalary
Security_Deposit	numeric(15,4)	NULL	Security Deposit amount as entered	No
Terms_Condn_Remarks	nvarchar(255)	NULL	Terms & Condition Remarks as entered	No	hrremarks

Table Name: hrei_terms_condn_dtl

Purpose:	Employee Assignment - Terms & Conditions Information for every EMPIN OU Code – Authorized
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance
terms_condn_id	int	NOT NULL	System Generated Number	Yes	HrInt
Terms_Condn_Code	nvarchar(5)	NOT NULL	Terms & Condn Codes are User defined Quick Codes. BP: HREI PV: TERM Values: Bond & Notice Period (In Days) alone cannot be modified by User	No	HrQuickCode
terms_condn_period	nvarchar(25)	NULL	Terms & Condn Period as entered. Should be an integer value for Notice Period (In Days)	No	HrDescription
Terms_Condn_From_Date	datetime	NOT NULL	Terms & Condn From Date as entered. Should be the Separation Request Date (For Notice Period - In days)	No	Datetime
Terms_Condn_To_Date	datetime	NULL	Terms & Condn From Date as entered. Should be the Separation Request Date + terms_condn_period (days) (For Notice Period - In days)	No
Currency_Code	nvarchar(5)	NULL	Currency Code as selected by user. This is from Enterprise Modeller	No	HrCode
Terms_Condn_Amount	numeric(15,4)	NULL	Terms & Condition Amount as entered	No	HrSalary
Security_Deposit	numeric(15,4)	NULL	Security Deposit amount as entered	No
Terms_Condn_Remarks	nvarchar(255)	NULL	Terms & Condition Remarks as entered	No	hrremarks
Mode_Flag	nvarchar(3)	NOT NULL	Mode Flag: Request for Addition, Modification, Deletion Values (A/M/D)	No	hrflag

Table Name: hrei_terms_condn_hdr

Purpose:	Employee Assignment - Terms & Conditions Information for every EMPIN OU Code
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Terms_Condn_Login_OU_Code	int	NOT NULL	Login Employment OU Code	No	HrOuInstance
Terms_Condn_Reject_Reason	nvarchar(100)	NULL	Rejection Reason as entered by Authorizer. In case of Mulitiple authorization, only last edited rejection reason will be stored.	No	Description
Terms_Condn_Auth_Date	datetime	NULL	Authorization Date - System Date	No	Datetime
Term_Condn_Language_Code	int	NOT NULL	Login Language	No	HrLangCd
doc_id	nvarchar(128)	NULL	Unique ID generated by the system to supply info to Workflow	No	wfdockey
doc_state	nvarchar(10)	NULL	Current State of the Document as returned from Workflow	No	wfstatename
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Terms_Condn_Auth_Status	nvarchar(3)	NOT NULL	Flag Value: Y - Authorized asgn-terms-condns exist N - No Authorized asgn-terms-condns exist	No	hrflag
Terms_Condn_Pend_Status	nvarchar(3)	NOT NULL	Flag Value: Y - Pending for Authorization records exists N - No Pending for Authorization records exists	No
Assignment_Number	int	NOT NULL	System Generated Number starting from 1. No: 1 is identified as Primary Assignment number for Regular Employees and Secondary Assignment numbers starts from 2. For Non-regular employees no specific identification is given in numbers and the number starts from 1 itself.	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	Employment Information OU Code in which this assignment is defined for the employee	Yes	HrOuInstance

Table Name: hrei_terms_condn_srch_tmp

Purpose:	Employee Assignment - Terms & Conditions Details For Search - temporary table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	Position Title	No	HrGuid
master_ou_code	int	NULL	Interactinf Master OU Code	No	HrOuInstance
employee_code	nvarchar(20)	NULL	Employee Code	No	HrEmpCode
assignment_number	int	NULL	Assignment Number	No	HrAssgnNo
assignment_defined_ou_code	int	NULL	Assignment defined OU code	No	HrOuInstance
effective_from_date	datetime	NULL	Effective from date of an employee	No	Datetime
employee_type	nvarchar(5)	NULL	Employee Type	No	HrQuickCode
employee_name	nvarchar(77)	NULL	Name of an employee	No	HrEmpName
position_title	nvarchar(25)	NULL	0t tion Title	No	hrpositiontitle
u_position_title	nvarchar(25)	NULL	Uppercase of position title	No
dept_desc	nvarchar(30)	NULL	Department Description	No	hrshortdesc12
u_dept_desc	nvarchar(30)	NULL	Upper case of Department Description	No
job_title	nvarchar(25)	NULL	Job title	No	hrjobtitle
u_job_title	nvarchar(25)	NULL	Upper case of Job title	No
position_id_or_code	nvarchar(10)	NULL	Position ID	No	hrposncode
job_code	nvarchar(10)	NULL	Job Code of an employee	No	HrCd
dept_code	nvarchar(10)	NULL	Department Code of an employee	No
record_status	varchar(5)	NULL	Record status	No	hrquickcode
record_desc	nvarchar(40)	NULL	Record description	No	HrQuickCodeDesc
u_search_name	nvarchar(500)	NULL	Alais Name	No	hrtext500
orgst_ou_code	int	NULL	Organisation OU Code	No	hrouinstance
unstr_ou_code	int	NULL	Unit structure OU Code	No

Table Name: hrei_view_asgn_srch_tmp

Purpose:	Employee Assignment - View Details For Search - temporary table
Column Name	Column Datatype		Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL		Unique GUID generated on every session	No	HrGuid
master_ou_code	int	NULL		Interacting Master OU Code	No	HrOuInstance
employee_code	nvarchar(20)	NULL		Employee Code	No	HrEmpCode
assignment_number	int	NULL		Assignment Number	No	HrAssgnNo
assignment_defined_ou_code	int	NULL		Assignment Defined OU code	No	HrOuInstance
effective_from_date	datetime	NULL		Effective from date	No	Datetime
employee_type	nvarchar(5)	NULL		Employee Type	No	HrQuickCode
employee_name	nvarchar(77)	NULL		Name of the employee	No	HrEmpName
position_title	nvarchar(25)	NULL		Position title	No	hrpositiontitle
u_position_title	nvarchar(25)	NULL		Upper case of Position title	No
dept_desc	nvarchar(30)	NULL		Department description	No	hrshortdesc12
u_dept_desc	nvarchar(30)	NULL		Upper case of Department description	No
job_title	nvarchar(25)	NULL		Job Title	No	hrjobtitle
u_job_title	nvarchar(25)	NULL		Upper case of Job Title	No
position_id_or_code	nvarchar(10)	NULL		Position ID	No	hrposncode
job_code	nvarchar(10)	NULL		Job Code of an employee	No	HrCd
dept_code	nvarchar(10)	NULL		Department Code of an employee	No
record_status	varchar(5)	NULL		Record status	No	hrquickcode
record_desc	nvarchar(40)	NULL		Record description	No	HrQuickCodeDesc
u_search_name	nvarchar(500)	NULL		h$ # # $	No	hrtext500
orgst_ou_code	int	NULL		Organisational OU code	No	hrouinstance
unstr_ou_code	int	NULL		Unit Structure OU code	No

Table Name: hrei_vwemhrcy_tmp

Purpose:	Temp table for employee hierarchy chart prepration
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	Session based unique number	No	HrGuid
sl_no	int	NULL	Sequence number for the record	No	HrInt
empng_ou_code	int	NULL	Employee code setup ou	No	HrOUInstance
empin_ou_code	int	NULL	Employment ou code	No	HrOuInstance
hierarchy_date	datetime	NULL	Hierarchy date	No	Datetime
HdnEmpCode_p	nvarchar(20)	NOT NULL	Hidden employee code	No	HrEmpCode
HEmpCode_c	nvarchar(20)	NOT NULL	Employee code	No
EmpCodeFlt_p	nvarchar(20)	NULL	Employee code of Header	No
EmpCodeMlt_c	nvarchar(20)	NULL	Employee code of Multiline	No
HrEmployeeName_p	nvarchar(77)	NULL	Parent Employee Name	No	HrEmpName
HrEmpName_c	nvarchar(77)	NULL	Child Employee Name	No
HrText255_p	nvarchar(255)	NULL	Parent Remarks	No	HrText255
HrPeriod255_c	nvarchar(255)	NULL	Child Remarks	No
HrAssgnNo1_p	int	NULL	Parent Assignment Number	No	HrAssgnNo
HrAssgnNo2_c	int	NULL	Child Assignment Number	No
HrNoOfRec_p	int	NULL	Child Number of record	No	HrInt
HrNoOfReq_c	int	NULL	Parent Number of record	No
HrDeptLgdesc_p	nvarchar(80)	NULL	Parent Department Long description	No	hrdesc40
HrDeptLgdesc1_c	nvarchar(80)	NULL	Child Department Long description	No
HrJobTitle1_p	nvarchar(25)	NULL	Parent Job Title	No	hrjobtitle
HrJobTitle2_c	nvarchar(25)	NULL	Child Job Title	No
HrPositionTitle1_p	nvarchar(25)	NULL	Parent Position Title	No	hrpositiontitle
HrPositionTitle2_c	nvarchar(25)	NULL	Child Position Title	No
HrWorkLocnLgdesc1_p	nvarchar(80)	NULL	Parent Work location description	No	hrdesc40
HrWorkLocnLgdesc2_c	nvarchar(80)	NULL	Child Work location description	No
desc1_p	nvarchar(80)	NULL	Parent Description	No	wfleveldesc
desc2_c	nvarchar(80)	NULL	Child Description	No
Hrcontactphone_p	nvarchar(20)	NULL	Parent Contact phone number	No	HrPhone
Hrcontactphone_c	nvarchar(20)	NULL	Child Contact phone number	No
hremailid_p	nvarchar(40)	NULL	Parent Email id	No	HrEmailId
hremailid_c	nvarchar(40)	NULL	Child Email Id	No

Table Name: hreis_emp_accident_dtl

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Interacting EMPNG OU Code	Yes	hrouinstance
Employee_Code	nvarchar(20)	NOT NULL	Employee code under EMPNG OU as entered by the user.	Yes	HrEmpCode
Date_of_Injury	datetime	NOT NULL	The date on which the employee was injured.	Yes	Datetime
Seriousness_of_Injury	nvarchar(5)	NULL	Indicates the seriousness of the employee s injury. User defined quick code. BP = 'HREI' PV = 'SRIN' For eg> Very serious,Normal,etc	No	HrQuickCode
Injury_Type	nvarchar(5)	NULL	Injury Type as selected by the user. User defined quick code. BP = 'HREI' PV = 'INJT'	No
TimeLost	nvarchar(11)	NULL	The work time lost because of the injury.	No	Hrtime
DurationType	nvarchar(5)	NULL	Unit of Measurement (for time lost) as selected by the user. System defined quick code. BP = 'EPIN' PV = 'UNDN' Eg> Hours,Days,etc	No	HrQuickCode
WorkArea	nvarchar(100)	NULL	The specific area in the company or department where the injury occurred.	No	HrDescription100
Expected_Date_Return	datetime	NULL	The date on which the employee is expected to return for work after recovery.	No	Datetime
Actual_Date_Return	datetime	NULL	The date on which the employee actually returns for work after recovery.	No
Cause_of_Injury	nvarchar(100)	NULL	Cause of injury.	No	HrDescription100
Action_Taken	nvarchar(100)	NULL	The remedial action taken / treatment given to the injured employee.	No	dynqrytext100
Detailed_Description	nvarchar(1000)	NULL	The detailed description of the treatment given to the injured employee.	No	hrtext1000
Body_Affected	nvarchar(100)	NULL	The part of the body that was affected due to the accident.	No	HrDescription100
Remarks	nvarchar(255)	NULL	Any additional remarks pertaining to the employee s accident.	No	hrremarks
Cost_Incurred	nvarchar(40)	NULL	The total cost incurred due to the employee s accident.	No	HrQuickCodeDesc
Job_Training_Provided	nvarchar(5)	NULL	Job Training Provided as selected by the user. User defined quick code. BP = 'HREI' PV = 'JOBT' Eg> Yes,No.	No	HrQuickCode

Table Name: hreis_proj_resource_dtl

Purpose:	Project Resource Allocation Details – Authorized
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Assignment_Number	int	NOT NULL	Treated as a secondary assignment	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	%AttDef	Yes	HrOuInstance
project_code	nvarchar(10)	NOT NULL	Project Code (Department code as created in Organization Structure)	Yes	HrCd
assignment_effective_from_date	datetime	NOT NULL	Assignment Start Date	No	Datetime
stage_code	nvarchar(5)	NOT NULL	User Defined Quick Code :- BP : EIS PV : STG	No	HrQuickCode
assignment_effective_to_date	datetime	NULL	Assignment End Date	No	Datetime
assignment_change_reason_code	nvarchar(5)	NULL	Reason for Change in Assignment Code	No	HrQuickCode
assignment_type	nvarchar(5)	NOT NULL	Assignment Type: New Hire Re-Hire Promotion Transfer Separated	No
employee_status	nvarchar(3)	NULL	Flag Value: C - Current S - Separated	No	hrflag
prim_asgn_dept_code	nvarchar(10)	NULL	Primary Assignment department code	No	hrcd
position_control_id	nvarchar(10)	NULL	Position Control ID (If position control is ON)	No	hrposncode
position_code	nvarchar(10)	NULL	Position Code created in UNSTR	No
position_id_or_code	nvarchar(10)	NULL	Position Control ID if present else Position Code	No
org_regltry_region_code	varchar(5)	NULL	Regulatory Region Code - Organizational Attribute	No	hrquickcode
org_work_locn_code	nvarchar(5)	NULL	Work Location Code - Organizational Attribute	No	HrCode
org_business_unit_code	nvarchar(20)	NULL	Business Unit Code - Organizational Attribute	No	buid
hyp_hrcy_code	nvarchar(10)	NULL	Hierarchy Code - Hierarchy Point Info	No	HrCd
hyp_hrcy_chain_code	nvarchar(10)	NULL	Hierarchy Chain Code - Hierarchy Point Info	No
job_code	nvarchar(10)	NULL	Job Code as created in Unit Structure	No
job_eeo_class	nvarchar(5)	NULL	EEO(Equal employment Opportunity Class Code) BP: UTST PV: EEOC	No	HrQuickCode
job_grade_set_code	nvarchar(5)	NULL	Grade Set Code of ORGST attached to the Job in UNSTR	No	HrCode
job_grade_code	nvarchar(5)	NULL	Grade Code for a Grade Set of ORGST attached to the Job in UNSTR	No
job_classification_code	varchar(5)	NULL	Job Classification code from UNSTR BP: UTST PV: JOBC	No	hrquickcode
job_work_condn_code	nvarchar(5)	NULL	Work Condition Code attached to the Job in UNSTR	No	HrQuickCode
job_work_compn_code	nvarchar(5)	NULL	Work Compensation Code attached to the Job in UNSTR	No
job_salary_hour_flag	nvarchar(5)	NULL	Salaried / Hourly Flag: for the Job BP: UTST PV: SALH	No
job_standard_hours	numeric(6,2)	NULL	Standard Hours of Working attached to the job in UNSTR	No	hrshours
job_standard_hours_uom	nvarchar(5)	NULL	Standard Hours unit of measure: BP: UTST PV: STDU	No	HrQuickCode
job_work_experience	int	NULL	Work Experience attached to the Job in UNSTR	No	hrmonthsexp
job_work_experience_uom	nvarchar(5)	NULL	Work Experience Unit of measure BP: UTST PV: WKEU	No	HrQuickCode
job_medical_chk_reqd	int	NULL	Medical Check Required Values 1 - Required 0 - Not Required	No	hrcheck
job_medical_chk_reqmt	nvarchar(255)	NULL	Medical Check Requirement - Remarks	No	hrremarks
job_tipped	int	NULL	Tip Enabled 1- Enabled 0 - Not Enabled	No	hrcheck
job_mobile	int	NULL	Mobile Present 1- Present 0 - Not Present	No
job_ud1_flsa_exempt	nvarchar(5)	NULL	Fair Labour Standards Act Exempt Y/N	No	HrQuickCode
job_ud2_sic_code	nvarchar(20)	NULL	SIC Code	No	hrsiccode
emp_fte_code	numeric(5,2)	NULL	Full Time Equivalent	No	hrratio
emp_reg_temp_flag	nvarchar(5)	NULL	Regular / Temporary	No	HrQuickCode
emp_fullpart_time_flag	nvarchar(5)	NULL	Full Time / Part Time	No
sup_employee_code	nvarchar(20)	NOT NULL	Supervisor Employee Code	No	HrEmpCode
sup_assignment_number	int	NOT NULL	Supervisor Assignment Number	No	HrAssgnNo
sup_assignment_defined_ou_code	int	NULL	%AttDef	No	HrOuInstance
benefit_union_affiliation_code	nvarchar(5)	NULL	Union Code - Affiliated	No	HrQuickCode
benefit_union_group_id	int	NULL	Group Code under that Union Code	No	HrInt
benefit_description	nvarchar(100)	NULL	Description of Union Related Benefits	No	Description
assignment_auth_status	nvarchar(3)	NOT NULL	Authorization Status Value: P	No	hrflag
assignment_auth_date	datetime	NOT NULL	Authorization Date - System Date	No	Datetime
gnmas_ou_code	int	NOT NULL	%AttDef	No	HrOuInstance
orgst_ou_code	int	NOT NULL	%AttDef	No
unstr_ou_code	int	NOT NULL	%AttDef	No
hrchy_ou_code	int	NOT NULL	%AttDef	No
sedef_ou_code	int	NULL	EMPIN Interacting SEDEF (Security Definition) OU Code	No	HrOUInstance
source_component_code	nvarchar(20)	NOT NULL	From Where the assignment is updated (HRMSEMPIN/HRMSEMPMV)	No	HrComponentCode
assignment_comments	nvarchar(2000)	NULL	Comments for the Assignment	No	hrnotes
data_override_flag	nvarchar(3)	NULL	Date Override Flag value present at the time of transaction creation (Y/N)	No	hrflag
doc_id	nvarchar(128)	NULL	Unique ID generated by the system to supply info to Workflow	No	wfdockey
doc_state	nvarchar(10)	NULL	Current State of the Document as returned from Workflow	No	wfstatename

Table Name: hreis_relation_map_tmp

Purpose:	Reporting Relationship Mapping Details
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
hrguid	nvarchar(40)	NOT NULL	Unique GUID generated on every session	Yes	HrGuid
master_ou_code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
assignment_number	int	NOT NULL	Treated as a secondary assignment	Yes	HrAssgnNo
assignment_defined_ou_code	int	NOT NULL	%AttDef	Yes	HrOuInstance
project_code	nvarchar(10)	NOT NULL		Yes	HrCd
sup_empin_ou_code	int	NOT NULL	%AttDef	Yes	HrOuInstance
sup_employee_code	nvarchar(20)	NOT NULL	Supervisor Employee Code	Yes	HrEmpCode
sup_assignment_number	int	NOT NULL	Supervisor Assignment Number	Yes	HrAssgnNo
map_start_date	datetime	NOT NULL	Project Start Date	Yes	Datetime
map_end_date	datetime	NULL	Project End Date	No

Table Name: hreis_report_relation_map

Purpose:	Reporting Relationship Mapping Details
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
sup_employee_code	nvarchar(20)	NOT NULL	Supervisor Employee Code	Yes	HrEmpCode
sup_empin_ou_code	int	NOT NULL	%AttDef	Yes	HrOuInstance
sup_assignment_number	int	NOT NULL	Supervisor Assignment Number	Yes	HrAssgnNo
map_start_date	datetime	NOT NULL	Project Start Date	Yes	Datetime
map_end_date	datetime	NULL	Project End Date	No
Employee_Code	nvarchar(20)	NOT NULL	Employee Code under the EMPNG OU Code	Yes	HrEmpCode
Master_OU_Code	int	NOT NULL	Interacting EMPNG OU Code	Yes	HrOuInstance
project_code	nvarchar(10)	NOT NULL	Project Code (Department code as created in Organization Structure)	Yes	HrCd
Assignment_Number	int	NOT NULL	Treated as a secondary assignment	Yes	HrAssgnNo
Assignment_Defined_OU_Code	int	NOT NULL	%AttDef	Yes	HrOuInstance