Data Dictionary – Personal Information and Employee Service

Table Name: class_elem_wt_temp

Purpose:	For calculating weightage in the screens where class and element weightage percentage need to be shown.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
sess_id	nvarchar(40)	NULL	Session id	No	HrGuid
competency	nvarchar(10)	NULL	Competency Code	No	hrcompcode
class_cd	nvarchar(10)	NULL	Competency Class code	No	hrclasscode
class_wt	numeric(5,2)	NULL	Competency Class Weightage	No	hrcompweight
elem_cd	nvarchar(10)	NULL	Competency element code	No	hrelementcode
compy_elmnt_mdl	INT	NULL	Competency element minimum desired level	No	hrelementmdl
elem_wt	numeric(5,2)	NULL	Element Weightage	No	hrcompweight

Table Name: einfo_emp_cert_dtl

Purpose:	Certificate and its validity and re-certification information for every employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	hrouinstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	hrempcode
cert_no	nvarchar(20)	NOT NULL	Certificate No is a unique code as defined in the certificate masters.	Yes	hrcertnum
restrictions	nvarchar(5)	NOT NULL	Restrictions as selected by the user in the Restrictions combo. User Defined Quick Code. BP = 'GEN' PV = 'ARST'	Yes	hrquickcode
valid_from_date	datetime	NOT NULL	Validity of the certificate. From when the certificate is valid.	Yes	Datetime
emp_cert_no	nvarchar(20)	NOT NULL	For Each Employee one Certificate No will be issued. This is one to one mapping. This has no relevance with Certificate Codes.	No	hrcertnum
sl_no	int	NULL	Serial Number	No	hrint
certified_date	datetime	NULL	The date on which the certificate was given to the employee.	No	Datetime
certified_by	nvarchar(20)	NULL	The person who certified the employee	No	hrempcode
valid_to_date	datetime	NULL	Till when the certificate is valid.	No	Datetime
cert_status_cd	nvarchar(5)	NULL	Indicates Certificate is Active or Inactive. 'Y' indicates Active and 'N' indicates Inactive.	No	hrquickcode
rev_sus_date	datetime	NULL	If revoked or suspended the date on which the certificate was revoked or suspended.	No	Datetime
remarks	nvarchar(255)	NULL	The comments related to re-certification.	No	hrtext255

Table Name: einfo_emp_curr_dtl

Purpose:	Employee - Certificate details and its due date information
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	HR Setup Unit OU	Yes	hrouinstance
employee_code	nvarchar(20)	NOT NULL	The unique code identifying the employee for whom you require to record the currency information.	Yes	hrempcode
cert_no	nvarchar(20)	NOT NULL	The unique number identifying the certificate.	Yes	hrcertnum
curr_due_on	datetime	NOT NULL	The date on which the currency check shall be due.	Yes	Datetime
fullfillment_date	datetime	NULL	The date on which the currency check was fulfilled.	No
observed_by	nvarchar(20)	NULL	The employee who have observed the currency fulfillment	No	hrempcode
observation	nvarchar(255)	NULL	The note about the observation of the currency fulfillment.	No	hrtext255
comments	nvarchar(2000)	NULL	The comments related to currency fulfillment.	No	hrnotes
reference	nvarchar(18)	NULL	Any reference # related to currency fulfillment	No	documentno

Table Name: einfo_emp_curr_pend_dtl

Purpose:	Employee - Certificate details and its due date information - Pending table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	HR Setup Unit OU	Yes	hrouinstance
employee_code	nvarchar(20)	NOT NULL	The unique code identifying the employee for whom you require to record the currency information.	Yes	hrempcode
cert_no	nvarchar(20)	NOT NULL	The unique number identifying the certificate.	Yes	hrcertnum
curr_due_on	datetime	NOT NULL	The date on which the currency check is due for the employee.	No	Datetime
fullfillment_date	datetime	NULL	The date on which the currency check was fulfilled.	No
observed_by	nvarchar(20)	NULL	The employee who have observed the currency fulfillment.	No	hrempcode
observation	nvarchar(255)	NULL	The note about the observation of the currency fulfillment.	No	hrtext255
comments	nvarchar(2000)	NULL	The comments related to currency fulfillment.	No	hrnotes
reference	nvarchar(18)	NULL	Any reference # related to currency fulfillment.	No	documentno

Table Name: einfo_emp_recert_dtl

Purpose:	Employee - Certificate details and its recertification information
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	HR Setup Unit OU	Yes	hrouinstance
employee_code	nvarchar(20)	NOT NULL	The unique code identifying the employee for whom you require to record the recertification requirements.	Yes	hrempcode
cert_no	nvarchar(20)	NOT NULL	The unique number identifying the certificate.	Yes	hrcertnum
recert_due_on	datetime	NOT NULL	The date on which the re-certification is due for the employee.	Yes	Datetime
recertified_date	datetime	NULL	The date on which the re-certification was done.	No
recertified_by	nvarchar(20)	NULL	The employee who has re-certified.	No	hrempcode
observation	nvarchar(255)	NULL	The note about the observation of the re-certification.	No	hrtext255
comments	nvarchar(2000)	NULL	The comments related to re-certification.	No	hrnotes
reference	nvarchar(18)	NULL	Any reference # related to re-certification.	No	documentno

Table Name: einfo_emp_recert_pend_dtl

Purpose:	Employee - Certificate details and its recertification information - Pending table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	HR Setup Unit OU	Yes	hrouinstance
employee_code	nvarchar(20)	NOT NULL	The unique code identifying the employee for whom you require to record the recertification requirements.	Yes	hrempcode
cert_no	nvarchar(20)	NOT NULL	The unique number identifying the certificate.	Yes	hrcertnum
recert_due_on	datetime	NULL	The date on which the re-certification is due for the employee.	No	Datetime
recertified_date	datetime	NULL	The date on which the re-certification was done.	No
recertified_by	nvarchar(20)	NULL	The employee who has re-certified.	No	hrempcode
observation	nvarchar(255)	NULL	The note about the observation of the re-certification.	No	hrtext255
comments	nvarchar(2000)	NULL	The comments related to re-certification.	No	hrnotes
reference	nvarchar(18)	NULL	Any reference # related to re-certification.	No	documentno

Table Name: einfo_lic_skill_dtl

Purpose:	Employee - License and its skill details mapped
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
sl_no	int	NOT NULL	Serial No	Yes	hrint
master_ou_code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	hrouinstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	hrempcode
license_no	nvarchar(15)	NOT NULL	License # is the number of employee license.	Yes	hrlicenseno
skill_code	nvarchar(10)	NOT NULL	The skills for which the license is issued.	Yes	hrcd
license_class	nvarchar(5)	NULL	Licence Class is a user defined quick code.	No	hrquickcode
object_type_cd	nvarchar(5)	NULL	Whether the license is for a Aircraft Model or Base Part #.	No
aircraft_bpart	nvarchar(20)	NULL	If Aircraft Model, the code of the Aircraft Model. If Base Part #, the code of the Base Part #.	No	hrmodel
ata_no	nvarchar(16)	NULL	The ATA to which the licenses is associated.	No	atanumber
reference	nvarchar(18)	NULL	Reference	No	documentno
remarks	nvarchar(255)	NULL	Comments on Employee Licence Information.	No	hrtext255

Table Name: einfo_licence_dtl

Purpose:	Employee - License and its validity details
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	hrouinstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	hrempcode
license_no	nvarchar(15)	NOT NULL	License No is the number of employee license.	Yes	hrlicenseno
sl_no	int	NOT NULL	Serial No	Yes	hrint
license_desc	nvarchar(25)	NULL	The description of the license No.	No	hrdescription
license_catg_code	nvarchar(5)	NULL	The category to which the license belongs.	No	hrquickcode
date_of_issue	datetime	NULL	The date on which the license was issued.	No	Datetime
iss_authority_cd	nvarchar(5)	NULL	The authority that has issued the license.	No	hrquickcode
perm_temporary_cd	nvarchar(5)	NULL	Whether the issued license is permanent or temporary.	No
valid_from_date	datetime	NULL	Validity of the license. The date from when the license is valid.	No	Datetime
valid_till_date	datetime	NULL	The date till the license is valid.	No
status_cd	nvarchar(5)	NULL	Status of the license, whether it was revoked or suspended.	No	Hrquickcode
rev_susp_date	datetime	NULL	If revoked or suspended, the date on which the license was revoked or suspended.	No	Datetime
remarks	nvarchar(255)	NULL	The comments related to currency fulfillment.	No	hrremarks

Table Name: einfo_skill_dtl

Purpose:	Skill Code and its possessed level details for every employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	hrouinstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	hrempcode
skill_code	nvarchar(10)	NOT NULL	The unique code with which the skill is identified.	Yes	hrcd
eff_from_date	datetime	NOT NULL	Date from which skill is effective	Yes	Datetime
eff_to_date	datetime	NULL	Skill effective to date	No
sl_no	int	NULL	Serial Number	No	hrint
posessed_level	int	NULL	The skill level possessed by the employee.	No	hrelementmdl
app_res_grp	nvarchar(5)	NULL	The skill belongs to which resource type, like mechanic, etc.	No	hrquickcode
pry_secdy_type	nvarchar(5)	NULL	Skill of the employee is identified as Primary or Secondary. An employee will have only one skill as primary.	No
remarks	nvarchar(255)	NULL	Remarks on Employee Skill Information	No	hrtext255

Table Name: EMSS_Competency

Purpose:	Stores detailed information about the Competency Information of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Competency_Code	nvarchar(10)	NOT NULL	Competency Code	Yes	hrcompcode
Compy_Class_Code	nvarchar(10)	NOT NULL	Competency Class Code	Yes	hrclasscode
Competency_Element_Code	nvarchar(10)	NOT NULL	Competency Element Code	Yes	hrelementcode
Data_Level_Flag	nvarchar(3)	NULL	Data Level Flag	No	hrflag
Possessed_Level	INT	NULL	Possessed Level	No	hremployeescore
Assessed_By_Flag	nvarchar(5)	NULL	Assessed By Flag	No	HrQuickCode
Assessed_Level	INT	NULL	Assessed Level	No	hremployeescore
Valid_From	nvarchar(11)	NULL	Valid From Date	No	HrDate
Valid_To	nvarchar(11)	NULL	Valid To Date	No
Internal_Assessor	nvarchar(20)	NULL	Internal Assessor Employee Code	No	HrEmpCode
Extern_Organisation	nvarchar(25)	NULL	External Organisation	No	HrDescription
assessed_on_date	nvarchar(11)	NULL	Date of assessment	No	HrDate
Extern_Assessor	nvarchar(77)	NULL	External Assessor	No	HrEmpName
Extern_Remarks	nvarchar(255)	NULL	External Remarks	No	hrremarks
Certification_Authority	nvarchar(50)	NULL	Certification Authority	No	hrcertauth
Certification_Number	nvarchar(20)	NULL	Certification Number	No	hrcertnum
Certification_Valid_From_date	datetime	NULL	Certification Valid From Date	No	Datetime
Certification_Valid_To_date	datetime	NULL	Certification Valid To Date	No
Certification_Remarks	nvarchar(255)	NULL	Certification Remarks	No	hrremarks
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance
Record_Status_Cd	nvarchar(5)	NULL	Status of Record used to know whether the record is added,modified or Deleted.	No	HrQuickCode

Table Name: EMSS_Compy_HDR

Purpose:	Stores Header information about the Competency Information of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Document_ID	int	NOT NULL	Unique Id across the component used for Work flow	No	hrint
Request_Status_Code	nvarchar(10)	NULL	This Column is used to store the Workflow status of the Request.	No	wfstatename
Employee_Remarks	nvarchar(255)	NULL	Employee Remarks	No	hrremarks
Request_Date	datetime	NULL	Date of Request	No	Datetime
Auth_Emp_Code	nvarchar(20)	NULL	Authoriser Employee Code	No	HrEmpCode
Authoriser_Remarks	nvarchar(255)	NULL	Authoriser Remarks	No	hrremarks
Authorisation_Date	datetime	NULL	Date of Authorisation	No	Datetime
Modify_Option_Cd	nvarchar(5)	NULL	Tells that given request is new request or corrections to the existing record.Quick code values are Correct and Update	No	HrQuickCode
New_Eff_From_Date	datetime	NULL	If the request is corrected New Effective From Date is given	No	Datetime
Auth_Rej_Flag	nvarchar(5)	NULL		No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU Code	No	HrOUInstance

Table Name: EMSS_Contact

Purpose:	Stores detailed information about the Contact Information of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Valid_To	datetime	NULL	Valid To date	No	Datetime
Valid_from	datetime	NULL	Valid From Date	No
Record_Status_Cd	nvarchar(5)	NULL	Record Status Code	No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance
county	nvarchar(5)	NULL	Country	No	HrQuickCode
Comments	nvarchar(2000)	NULL	Comments	No	hrnotes
city	nvarchar(5)	NULL	City	No	hrquickcode
school	nvarchar(5)	NULL	School	No
Home_Page	nvarchar(80)	NULL	Home Page	No	hrdesc40
Authorisation_Date	datetime	NULL	Authorisation date	No	Datetime
Authoriser_Remarks	nvarchar(255)	NULL	Authoriser remarks	No	hrremarks
Auth_Rej_Flag	nvarchar(5)	NULL	Authorised/Reject flag	No	HrQuickCode
Document_id	INT	NULL	Workflow document id	No	HrInt
Request_Status_code	nvarchar(10)	NULL	Request status code Pending/Authorized	No	wfstatename
Auth_Emp_Code	nvarchar(20)	NULL	Authorised employee code	No	HrEmpCode
Employee_Remarks	nvarchar(255)	NULL	Employee remark for his changes	No	hrremarks
Request_Date	datetime	NULL	Change requested date	No	Datetime
Guid	nvarchar(40)	NULL	Sequence flag	No	HrGuid
Address_1	nvarchar(40)	NOT NULL	Address 1	No	HrAddress
new_eff_from_date	datetime	NULL	If the request is corrected New Effective From Date is given	No	Datetime
Address_2	nvarchar(40)	NULL	Address 2	No	HrAddress
Address_3	nvarchar(40)	NULL	Address 3	No
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
modify_option_cd	nvarchar(5)	NULL	Tells that given request is new request or corrections to the existing record.Quick code values are Correct and Update	No	hrquickcode
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Contact_Type_Code	nvarchar(5)	NOT NULL	Contact Type	Yes	HrQuickCode
Email_Code	nvarchar(40)	NULL	Email address	No	HrEmailId
Phone_number_2	nvarchar(20)	NULL	Phone Number 2	No	hrphone
Phone_number_1	nvarchar(20)	NULL	Phone Number 1	No
Fax_number	nvarchar(40)	NULL	Fax Number	No	HrEmailId
Mobile_Number	nvarchar(20)	NULL	Mobile Number	No	HrMobile
Country_Code	nvarchar(5)	NOT NULL	Country code	No	CountryCode
State_Code	nvarchar(10)	NOT NULL	State Code	No	hrstatecode
active_inactive	nvarchar(3)	NULL	Active/Inactive	No	hrflag
Zip	nvarchar(40)	NULL	Zip	No	HrZip
primary_address	nvarchar(3)	NULL	Priamry Address	No	hrflag

Table Name: EMSS_Contact_HDR

Purpose:	Stores Header information about the Contact Information of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Document_ID	INT	NOT NULL	Unique Id across the component used for Work flow	No	HrInt
Request_Status_Code	nvarchar(10)	NULL	This Column is used to store the Workflow status of the Request.	No	wfstatename
Employee_Remarks	nvarchar(255)	NULL	Employee Remarks	No	hrremarks
Request_Date	datetime	NULL	Date of Request	No	Datetime
Auth_Emp_Code	nvarchar(20)	NULL	Authoriser Employee Code	No	HrEmpCode
Authoriser_Remarks	nvarchar(255)	NULL	Authoriser Remarks	No	hrremarks
Authorisation_Date	datetime	NULL	Date of Authorisation	No	Datetime
Auth_Rej_Flag	nvarchar(5)	NULL	Authorise/Reject flag.	No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance

Table Name: EMSS_Disability

Purpose:	Stores detailed information about the Disability Information of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Assessed_Flag	nvarchar(3)	NOT NULL	Assessed (Yes or No)	No	hrflag
Temporary_Code	nvarchar(5)	NOT NULL	Temporary Code(Values stored are Yes and No)	No	HrQuickCode
Extent_Code	nvarchar(5)	NOT NULL	Extent Type	No
Concessions	nvarchar(255)	NULL	Concessions	No	HrText255
Record_Status_Cd	nvarchar(5)	NULL	Status of Record used to know whether the record is added,modified or Deleted.	No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Disability_To	datetime	NULL	Disability To Date	No	Datetime
Disability	nvarchar(25)	NOT NULL	Type of Disability	Yes	HrDisability
Disability_From	datetime	NOT NULL	Disability From Date	Yes	Datetime

Table Name: EMSS_Disability_HDR

Purpose:	Stores header information about the Disability Information of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Document_ID	INT	NOT NULL	Unique Id across the component used for Work flow	No	HrInt
Request_Status_Code	nvarchar(10)	NULL	This Column is used to store the Workflow status of the Request.	No	wfstatename
Employee_Remarks	nvarchar(255)	NULL	Employee Remarks	No	hrremarks
Request_Date	datetime	NULL	Date of Request	No	Datetime
Auth_Emp_Code	nvarchar(20)	NULL	Authoriser Employee Code	No	HrEmpCode
Authoriser_Remarks	nvarchar(255)	NULL	Authoriser Remarks	No	hrremarks
Authorisation_Date	datetime	NULL	Date of Authorisation	No	Datetime
Modify_Option_Cd	nvarchar(5)	NULL	Tells that given request is new request or corrections to the existing record.Quick code values are Correct and Update	No	HrQuickCode
New_Eff_From_Date	datetime	NULL	If the request is corrected New Effective From Date is given	No	Datetime
Auth_Rej_Flag	nvarchar(5)	NULL	Authorise/Reject flag	No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance

Table Name: EMSS_Document_ID_Gen

Purpose:

Document id for self service components

Column Name

Column Datatype

Column Null Option

Column Comment

Column Is PK

Column Domain Name

Document_id

INT

NOT NULL

Document id

Yes

HrInt

Table Name: EMSS_EEA1_declaration

Purpose:	This table stores the pending for authorization records of the employee EEA1 declaration.
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	hrouid
Employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	hrempcode
effective_from_date	datetime	NOT NULL	Effective from date of an employee	Yes	Datetime
effective_to_date	datetime	NULL	Effective to date of an employee	No
emp_gender	nvarchar(5)	NULL	Employee gender	No	hrquickcode
emp_race	nvarchar(5)	NULL	Employee Race	No
emp_disability	nvarchar(5)	NULL	Employee disability	No
Nature_of_disability	nvarchar(80)	NULL		No	hrdesc40
record_status	nvarchar(7)	NULL	Record status	No	hrstatus
comments	nvarchar(255)	NULL	Comment	No	hrtext255
rejection_reason	nvarchar(255)	NULL	Reason for rejection	No	hrremarks
login_ou_code	int	NULL	Login Ou code	No	hrouid
doc_id	nvarchar(30)	NULL	Documents ID	No	hrdocid
new_effective_from_date	datetime	NULL	New effective from date	No	Datetime
request_for_deletion	INT	NULL	deletion reason	No	Hrcheck
modification_option	nvarchar(5)	NULL	Modification option ( update or correct)	No	hrquickcode

Table Name: EMSS_Family_HDR

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Document_ID	INT	NOT NULL	Unique Id across the component used for Work flow	No	HrInt
Request_Status_Code	nvarchar(10)	NULL	This Column is used to store the Workflow status of the Request.	No	wfstatename
Employee_Remarks	nvarchar(255)	NULL	Employee Remarks	No	hrremarks
Request_Date	datetime	NULL	Date of Request	No	Datetime
Auth_Emp_Code	nvarchar(20)	NULL	Authoriser Employee Code	No	HrEmpCode
Authoriser_Remarks	nvarchar(255)	NULL	Authoriser Remarks	No	hrremarks
Authorisation_Date	datetime	NULL	Date of Authorisation	No	Datetime
Modify_Option_Cd	nvarchar(5)	NULL	Tells that given request is new request or corrections to the existing record.Quick code values are Correct and Update	No	HrQuickCode
New_Eff_From_Date	datetime	NULL	If the request is corrected New Effective From Date is given	No	Datetime
Auth_Rej_Flag	nvarchar(5)	NULL		No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance

Table Name: EMSS_Family_Member_Hist

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Family_member_Id	INT	NOT NULL	Family Member Id	Yes	HrNumber
First_Name	nvarchar(25)	NOT NULL	First Name	No	HrEmpFirstName
U_First_Name	nvarchar(25)	NULL	First Name in Upper Case	No
Date_Of_Birth	datetime	NOT NULL	Date of Birth	No	Datetime
Middle_Name	nvarchar(25)	NULL	Middle Name	No	HrEmpMiddleName
U_Middle_Name	nvarchar(25)	NULL	Middle Name in Upper Case	No
Last_Name	nvarchar(25)	NULL	Last Name	No	HrEmpLastName
U_Last_Name	nvarchar(25)	NULL	Last Name in Upper Case	No
SIN	nvarchar(20)	NULL	Social Identification Number	No	HrPersonalIDCode
SSN	nvarchar(20)	NULL	Social Security Number	No
Relationship_Code	nvarchar(5)	NOT NULL	Relationship with Employee	No	HrQuickCode
Gender_Code	nvarchar(5)	NOT NULL	Gender	No
Dependent_Flag	nvarchar(3)	NOT NULL	Dependent Flag (Yes/No)	No	hrflag
Occupation_Code	nvarchar(150)	NULL	Occupation Code	No	hrchar150
Family_member_Emp_Code	nvarchar(20)	NULL	Family Member Employee Code	No	HrEmpCode
Relationship_current_Flag	nvarchar(3)	NULL	Relationship Current Flag (Yes/No)	No	hrflag
Relationship_End_Date	datetime	NULL	Relationship End Date	No	Datetime
Reason_Code	nvarchar(5)	NULL	Reason	No	HrQuickCode
Other_Reason	nvarchar(255)	NULL	Other Reason	No	hrremarks
Marital_Status_Code	nvarchar(5)	NULL	Marital Status	No	hrquickcode
Military_Status_Code	nvarchar(5)	NULL	Military Status	No
Disability_Code	nvarchar(5)	NULL	Disability Type	No
Citizenship_ID_Number	nvarchar(80)	NULL	Citizenship ID Number	No	hrdesc40
Record_Status_Cd	nvarchar(5)	NULL	Status of Record used to know whether the record is added, modified or Deleted.	No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance
Relatioship_start_date	datetime	NULL	Relation ship from date For example Marriage date for wife/husband. Date of birth for son/daughter.	No	Datetime
Dependent_Pass_Start_Dt	nvarchar(25)	NULL	Dependent's Pass Expiry Start Date.	No	datetime
Dependent_Pass_End_Dt	nvarchar(25)	NULL	Dependent's Pass Expiry End Date.	No	datetime
Occupation_status	nvarchar(300	NULL	Occupation status of the family member of an employee	No	hrchar150

Table Name: EMSS_Hobby

Purpose:	Stores detailed information about the Hobby Information of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Achievements	nvarchar(255)	NULL	Achievements	No	HrText255
Level_Of_Representation_Code	nvarchar(5)	NULL	Level of Representation	No	HrQuickCode
Currently_pursuing_Flag	nvarchar(3)	NULL	Currently Pursuing (Yes Or No)	No	hrflag
Record_Status_Cd	nvarchar(5)	NULL	Status of Record used to know whether the record is added,modified or Deleted.	No	hrquickcode
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Category_Code	nvarchar(5)	NULL	Category Code	No	HrQuickCode
Hobby_Type_Code	nvarchar(5)	NOT NULL	Type of Hobby	Yes
Hobby_Name	nvarchar(100)	NOT NULL	Hobby Name	Yes	Description

Table Name: EMSS_Hobby_HDR

Purpose:	Stores Header information about the Hobby Information of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes
Document_ID	INT	NOT NULL	Unique Id across the component used for Work flow	No
Request_Status_Code	nvarchar(10)	NULL	This Column is used to store the Workflow status of the Request.	No
Employee_Remarks	nvarchar(255)	NULL	Employee Remarks	No
Request_Date	datetime	NULL	Date of Request	No
Auth_Emp_Code	nvarchar(20)	NULL	Authoriser Employee Code	No
Authoriser_Remarks	nvarchar(255)	NULL	Authoriser Remarks	No
Authorisation_Date	datetime	NULL	Date of Authorisation	No
Modify_Option_Cd	nvarchar(5)	NULL	Tells that given request is new request or corrections to the existing record.Quick code values are Correct and Update	No
New_Eff_From_Date	datetime	NULL	If the request is corrected New Effective From Date is given	No
Auth_Rej_Flag	nvarchar(5)	NULL	Authorise/Reject Flag	No
Login_OU_Code	int	NOT NULL	Self Service OU Code	No

Table Name: EMSS_Identification

Purpose:	Stores detailed information about the Identification Information of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Identification_type	nvarchar(5)	NOT NULL	Type of Identification	Yes	HrQuickCode
Document_number	nvarchar(25)	NOT NULL	Unique Number	Yes	HrDescription
Place_Of_issue	nvarchar(25)	NOT NULL	Place of Issue	No
Issuing_Authority	nvarchar(25)	NOT NULL	Issuing Authority	No
Date_Of_issue	datetime	NOT NULL	Date of Issue	No	Datetime
Valid_From	datetime	NULL	Valid From Date	No
Valid_Till	datetime	NOT NULL	Valid Till Date	No
Remarks	nvarchar(255)	NOT NULL	Remarks	No	HrText255
Record_Status_Cd	nvarchar(5)	NULL	Status of Record used to know whether the record is added,modified or Deleted.	No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance

Table Name: EMSS_Identification_HDR

Purpose:	Stores Header information about the Identification information of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Document_ID	INT	NOT NULL	Unique Id across the component used for Work flow	No	HrInt
Request_Status_Code	nvarchar(10)	NULL	This Column is used to store the Workflow status of the Request.	No	wfstatename
Employee_Remarks	nvarchar(255)	NULL	Employee Remarks	No	hrremarks
Request_Date	datetime	NULL	Date of Request	No	Datetime
Auth_Emp_Code	nvarchar(20)	NULL	Authoriser Employee Code	No	HrEmpCode
Authoriser_Remarks	nvarchar(255)	NULL	Authoriser Remarks	No	hrremarks
Authorisation_Date	datetime	NULL	Date of Authorisation	No	Datetime
Modify_Option_Cd	nvarchar(5)	NULL	Tells that given request is new request or corrections to the existing record.Quick code values are Correct and Update	No	HrQuickCode
New_Eff_From_Date	datetime	NULL	If the request is corrected New Effective From Date is given	No	Datetime
Auth_Rej_Flag	nvarchar(5)	NULL		No	HrQuickCode
Blood_Group_Code	nvarchar(5)	NULL	Blood Group Code of Employee	No
Smoker_Flag	nvarchar(5)	NULL	Employee is Smoker or not.Values are Yes or No	No
Height	numeric(10,2)	NULL	Height of Employee	No	HrCompaRatio
Height_Unit_Code	nvarchar(5)	NULL	Height Unit of Measurment	No	HrQuickCode
Weight	numeric(10,2)	NULL	Weight of Employee	No	HrCompaRatio
Weight_Unit_Code	nvarchar(5)	NULL	Weight Unit of Measurment	No	HrQuickCode
Birth_Marks	nvarchar(255)	NULL	Birth Marks of Employee	No	HrText255
Attached_Photo_Path	nvarchar(255)	NULL	Attached Phot Path of Employee	No
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance

Table Name: emss_image_path

Purpose:	Physical and Virtual path will be stored. This table must fill thru meta data. This table will be used for Photo upload from Personal Information or Identification Pages thru self services.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
physical_image_path	nvarchar(255)	NULL	Physical path from Server. All image files are stored in this path	No	hrtext255
virtual_image_path	nvarchar(255)	NULL	Virtual path from Server (iis virtual directory path).	No

Table Name: EMSS_LANG_TEMP

Purpose:	This table stores the employee self service language details temporarily
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
HRGUID	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
Language_Code	nvarchar(5)	NULL	Language Code	No	HrQuickCode
Proficiency_Code	nvarchar(5)	NULL	Proficiency Code	No
Conduct_Business_Flag	nvarchar(5)	NULL	Business Flag	No
Mother_Tongue_Flag	nvarchar(5)	NULL	Mother Tongue flag	No

Table Name: EMSS_Language

Purpose:	Stores detailed information about the Language Information of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Conduct_Business_Flag	nvarchar(5)	NULL	Can Conduct Business (Values are Yes/No)	No
Record_Status_Cd	nvarchar(5)	NULL	Status of Record used to know whether the record is added, modified or Deleted.	No
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes
Proficiency_Code	nvarchar(5)	NULL	Proficiency Code. Quick Code values are (Read,Write,Read & Write..)	No	HrQuickCode
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Language_Code	nvarchar(5)	NOT NULL	Language Code	Yes	HrQuickCode

Table Name: EMSS_Language_HDR

Purpose:	Stores Header information about the Language Information of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Document_ID	INT	NOT NULL	Unique Id across the component used for Work flow	No	HrInt
Request_Status_Code	nvarchar(10)	NULL	This Column is used to store the Workflow status of the Request.	No	wfstatename
Employee_Remarks	nvarchar(255)	NULL	Employee Remarks	No	hrremarks
Request_Date	datetime	NULL	Date of Request	No	Datetime
Auth_Emp_Code	nvarchar(20)	NULL	Authoriser Employee Code	No	HrEmpCode
Authoriser_Remarks	nvarchar(255)	NULL	Authoriser Remarks	No	hrremarks
Authorisation_Date	datetime	NULL	Date of Authorisation	No	Datetime
Modify_Option_Cd	nvarchar(5)	NULL	Tells that given request is new request or corrections to the existing record.Quick code values are Correct and Update	No	HrQuickCode
New_Eff_From_Date	datetime	NULL	If the request is corrected New Effective From Date is given	No	Datetime
Auth_Rej_Flag	nvarchar(5)	NULL	Authorize/Reject Flag	No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance

Table Name: EMSS_Military_Assignments

Purpose:	Stores detailed information about the Assignments of the Employee at the time of Military Service
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Service_Number	nvarchar(25)	NOT NULL	Service Number	Yes	HrDescription
Service_Entry_Date	datetime	NOT NULL	Date of Entry into Service	Yes	Datetime
Assignment	nvarchar(25)	NOT NULL	Assignment	Yes	HrDescription
Assignment_Start_date	datetime	NOT NULL	Start Date of Assignment	Yes	Datetime
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Assignment_End_date	datetime	NULL	End Date of Assignment	No	Datetime
Service_Type_Code	nvarchar(5)	NULL	Type of Service	No	HrQuickCode
Category_Code	nvarchar(5)	NULL	Category Type	No
Remarks	nvarchar(255)	NULL	Remarks	No	HrText255
Record_Status_Cd	nvarchar(5)	NULL	Status of Record used to know whether the record is added,modified or Deleted.	No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance

Table Name: EMSS_Military_HDR

Purpose:	Stores Header information about the Military Service of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Document_ID	INT	NOT NULL	Unique Id across the component used for Work flow	No	HrInt
Request_Status_Code	nvarchar(10)	NULL	This Column is used to store the Workflow status of the Request.	No	wfstatename
Employee_Remarks	nvarchar(255)	NULL	Employee Remarks	No	hrremarks
Request_Date	datetime	NULL	Date of Request	No	Datetime
Auth_Emp_Code	nvarchar(20)	NULL	Authoriser Emloyee Code	No	HrEmpCode
Authoriser_Remarks	nvarchar(255)	NULL	Authoriser Remarks	No	hrremarks
Auth_Rej_Flag	nvarchar(5)	NULL		No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance
Record_Status_Code	nvarchar(5)	NULL	Record Status Code used to know whether the record is added, modified or Deleted.	No	HrQuickCode
Authorisation_Date	datetime	NULL	Date of Authorisation	No	Datetime

Table Name: EMSS_Military_Service

Purpose:	Stores detailed information about the Military Service of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Service_Number	nvarchar(25)	NOT NULL	Service Number	Yes	HrDescription
Service_Entry_Date	datetime	NOT NULL	Date of Entry into Service	Yes	Datetime
Service_Release_Date	datetime	NOT NULL	Date of Release from Service	No
Service_Field_Code	nvarchar(5)	NOT NULL	Service Field Type	No	HrQuickCode
Trade	nvarchar(25)	NULL	Trade	No	HrDescription
Rank_at_Discharge	nvarchar(25)	NULL	Rank at the time of Discharge	No
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance

Table Name: EMSS_MLTRY_ASSIGN_TEMP

Purpose:	This table stores employee self service military Assignment temporarily
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	NOT NULL	Interacting Master OU code	No	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	No	HrEmpCode
Service_Number	nvarchar(25)	NULL	Service Number	No	HrDescription
Service_Entry_Date	datetime	NOT NULL	Service Entry Date	No	Datetime
Assignment	nvarchar(25)	NOT NULL	Assignment	No	HrDescription
Assignment_Start_date	datetime	NOT NULL	Assignment start date	No	Datetime

Table Name: emss_object_count

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
object_name	nvarchar(255)	NOT NULL	Object Name	Yes	hrtext255
object_type	nvarchar(5)	NULL	Object Type (Table, View, SP etc..)	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: EMSS_Personal_Hist

Purpose:	Stores detailed information about the Personal History of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Title_Code	nvarchar(5)	NULL	Title Code	No	HrQuickCode
First_Name	nvarchar(25)	NOT NULL	First Name of Employee	No	HrEmpFirstName
U_First_Name	nvarchar(25)	NULL	First Name of Employee in Upper Case	No
Middle_Name	nvarchar(25)	NULL	Middle Name of Employee	No	HrEmpMiddleName
U_Middle_Name	nvarchar(25)	NULL	Middle Name of Employee in Upper Case	No
Last_Name	nvarchar(25)	NULL	Last Name of Employee	No	HrEmpLastName
U_Last_Name	nvarchar(25)	NULL	Last Name of Employee in Upper Case	No
Known_As	nvarchar(25)	NULL	Employee Known as	No	HrEmpKnownAs
U_Known_As	nvarchar(25)	NULL	Employee Known as in Upper Case	No
Date_Of_Birth	nvarchar(11)	NULL	Date of Birth of Employee	No	HrDate
SSN	nvarchar(20)	NULL	Social Security Number	No	HrPersonalIDCode
NINoapp_date	datetime	NULL	Social Identification Number	No	Datetime
Confirm_Due_Date	datetime	NULL	Confirm Due Date	No
Confirm_Time	datetime	NULL	Confirm Time	No
Actl_Confirm_date	datetime	NULL	Actual Confirm Date	No
Actl_Confirm_Time	datetime	NULL	Actual Confirm Time	No
Gender_Code	nvarchar(5)	NULL	Gender type	No	HrQuickCode
Marital_Status_Code	nvarchar(5)	NULL	Marital Status	No
Ethnicity_Code	nvarchar(5)	NULL	Ethnicity Type	No
Nationality_Code	nvarchar(5)	NULL	Nationality of the Employee.	No
Religion_Code	nvarchar(5)	NULL	Religion of the employee	No
Country_Code	nvarchar(5)	NULL	Country Code	No	CountryCode
State_Code	nvarchar(10)	NULL	State Code	No	hrstatecode
Citizenship_Code	nvarchar(5)	NULL	Employee's Citizenship Code	No	hrquickcode
Service_Ref_Date	nvarchar(25)	NULL	Service Reference Date	No	datetime
Emergency_Contact_Name_1	nvarchar(40)	NULL	Emergency Contact Name	No	HrName40
Emergency_Relationship_Code_1	nvarchar(5)	NULL	Emergency Relationship type	No	HrQuickCode
Emergency_Phone_number_1	nvarchar(20)	NULL	Emergency Phone Number	No	hrphone
Emergency_Mobile_Number_1	nvarchar(20)	NULL	Emergency Phone Number	No	HrMobile
Emergency_Contact_Name_2	nvarchar(40)	NULL	Emergency Contact Name	No	HrName40
Emergency_Relationship_Code_2	nvarchar(5)	NULL	Emergency Relationship Code	No	HrQuickCode
Emergency_Phone_number_2	nvarchar(20)	NULL	Emergency Phone Number	No	hrphone
Emergency_mobile_Number_2	nvarchar(20)	NULL	Emergency Mobile Number	No	HrMobile
Comments	nvarchar(2000)	NULL	Remarks	No	hrnotes
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance
sin	nvarchar(20)	NULL		No	hrpersonalidcode

Table Name: EMSS_Personal_Hist_HDR

Purpose:	Stores Header information about the Personal History of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Document_ID	INT	NOT NULL	Unique Id across the component used for Work flow	No	HrInt
Request_Status_Code	nvarchar(10)	NULL	This Column is used to store the Workflow status of the Request.	No	wfstatename
Employee_Remarks	nvarchar(255)	NULL	Employee Remarks	No	hrremarks
Request_Date	datetime	NULL	Date of Request	No	Datetime
Auth_Emp_Code	nvarchar(20)	NULL	Authoriser Employee Code	No	HrEmpCode
Authoriser_Remarks	nvarchar(255)	NULL	Authoriser Remarks	No	hrremarks
Authorisation_Date	datetime	NULL	Date of Authorisation	No	Datetime
Modify_Option_Cd	nvarchar(5)	NULL	Tells that given request is new request or corrections to the existing record.Quick code values are Correct and Update	No	HrQuickCode
New_Eff_From_Date	datetime	NULL	If the request is corrected New Effective From Date is given	No	Datetime
Auth_Rej_Flag	nvarchar(5)	NULL	Authorise/Reject flag.	No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU.	No	HrOUInstance

Table Name: EMSS_Primary_Achievement

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Achievement_Id	INT	NOT NULL	Achievement Id	Yes	HrNumber
Achievement_Code	nvarchar(10)	NOT NULL	Achievement Code	No	HrAchCode
Relative_Importance	INT	NOT NULL	Relative Importance	No	HrRelativeImpt
Institution	nvarchar(25)	NULL	Institution	No	HrDescription
Major_Code	nvarchar(5)	NULL	Major Code	No	HrQuickCode
Minor_Code	nvarchar(5)	NULL	Minor Code	No
Passing_Month_Code	nvarchar(5)	NULL	Passing Month	No
Passing_year	INT	NULL	Passing Year	No	HrYr
Duration	INT	NULL	Duration	No	HrInt
Unit_Code	nvarchar(5)	NULL	Unit Code	No	HrQuickCode
Nature_Code	nvarchar(5)	NULL	Nature of Education	No
GPA_Percentage	numeric(5,2)	NULL	GPA Percentage	No	HrPercentage
Start_Date	datetime	NULL	Start Dtate	No	Datetime
Maximum	numeric(5,2)	NULL	Maximum Score for the qualification	No	HrPercentage
Sponsored_Flag	nvarchar(3)	NULL	Sponsered Flag	No	hrflag
Rank	INT	NULL	Rank	No	HrRank
Class_Code	nvarchar(5)	NULL	Class Code	No	HrQuickCode
Valid_Till	datetime	NULL	Valid Till	No	Datetime
Record_Status_Cd	nvarchar(5)	NULL	Status of Record used to know whether the record is added,modified or Deleted.	No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance
highest_qual_qc	nvarchar(40)	NULL	Highest qualification for this employee Y/N flag	No	HrYesNo
Country_Conf_Deg	nvarchar(5)	NULL	Employee's Country of Conferring Degree.	No	hrquickcode
Trained_In	nvarchar(5)	NULL	Employee is Locally trained or Foreign trained. Quick Code: BP - EPIN PV - LTFT	No
Remarks	nvarchar(255)	NULL	Remarks about the qualification	No	HrText255

Table Name: EMSS_Primary_Achmt_HDR

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Document_ID	INT	NOT NULL	Unique Id across the component used for Work flow	No	HrInt
Request_Status_Code	nvarchar(10)	NULL	This Column is used to store the Workflow status of the Request.	No	wfstatename
Employee_Remarks	nvarchar(255)	NULL	Employee Remarks	No	hrremarks
Request_Date	datetime	NULL	Date of Request	No	Datetime
Auth_Emp_Code	nvarchar(20)	NULL	Authoriser Employee Code	No	HrEmpCode
Authoriser_Remarks	nvarchar(255)	NULL	Authoriser Remarks	No	hrremarks
Authorisation_Date	datetime	NULL	Date of Authorisation	No	Datetime
Modify_Option_Cd	nvarchar(5)	NULL	Tells that given request is new request or corrections to the existing record.Quick code values are Correct and Update	No	HrQuickCode
New_Eff_From_Date	datetime	NULL	If the request is corrected New Effective From Date is given	No	Datetime
Auth_Rej_Flag	nvarchar(5)	NULL		No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance

Table Name: EMSS_Reference

Purpose:	Stores detailed information about the Reference Information of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Reference_remarks	nvarchar(255)	NULL	Reference Remarks	No	HrText255
Date_Of_Reference	datetime	NULL	Date of Reference	No	Datetime
Contact_Information	nvarchar(25)	NULL	Contact Information	No	HrDescription
HR_remarks	nvarchar(255)	NULL	HR Remarks	No	HrText255
Reference_Check_Status	nvarchar(3)	NULL	Reference Check Status	No	hrflag
Login_OU_Code	INT	NOT NULL	Self Service OU	No	HrOuInstance
Name_Of_Reference	nvarchar(40)	NOT NULL	Name of Reference	Yes	HrName40
Reference_Type_Code	nvarchar(5)	NOT NULL	Type of Reference	Yes	HrQuickCode
position_Description	nvarchar(25)	NOT NULL	Position Description	No	HrDescription
Organisation_Description	nvarchar(25)	NOT NULL	Organisation Description	No
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode

Table Name: EMSS_Reference_HDR

Purpose:	Stores Header information about the Reference information of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Document_ID	INT	NOT NULL	Unique Id across the component used for Work flow	No	HrInt
Request_Status_Code	nvarchar(10)	NULL	This Column is used to store the Workflow status of the Request.	No	wfstatename
Employee_Remarks	nvarchar(255)	NULL	Employee Remarks	No	hrremarks
Request_Date	datetime	NULL	Date of Request	No	Datetime
Auth_Emp_Code	nvarchar(20)	NULL	Authoriser Employee Code	No	HrEmpCode
Authoriser_Remarks	nvarchar(255)	NULL	Authoriser Remarks	No	hrremarks
Authorisation_Date	datetime	NULL	Date of Authorisation	No	Datetime
Modify_Option_Cd	nvarchar(5)	NULL	Tells that given request is new request or corrections to the existing record.Quick code values are Correct and Update	No	HrQuickCode
New_Eff_From_Date	datetime	NULL	If the request is corrected New Effective From Date is given	No	Datetime
Auth_Rej_Flag	nvarchar(5)	NULL	Authorise/Reject Flag	No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU Code	No	HrOUInstance

Table Name: EMSS_Work_Experience

Purpose:	Stores detailed information about the work experience of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
End_Date	datetime	NULL	End Date	No	Datetime
Gross_Annual_Income	FLOAT	NULL	Gross Annual Income	No	HrSalary
From_date	datetime	NULL	From Date	No	Datetime
Equivalent_Job_Code	nvarchar(10)	NULL	Equivalent Job in the Organisation	No	hrcd
Record_Status_Cd	nvarchar(5)	NULL	Status of Record used to know whether the record is added,modified or Deleted.	No	HrQuickCode
Currency_Code	nvarchar(5)	NULL	Currency type	No	HrCode
Remarks	nvarchar(255)	NULL	Remarks	No	HrText255
Change_Reason	nvarchar(255)	NULL	Reason for Change	No
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance
Work_Experience_Id	INT	NOT NULL	Uniqe Id	Yes	HrNumber
Organisation_Description	nvarchar(25)	NOT NULL	Organisation Description	No	HrDescription
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Dept_Description	nvarchar(30)	NULL	Department Description	No	hrshortdesc12
Job_Description	nvarchar(25)	NULL	Job Description	No	hrjobtitle
Relative_Importance	INT	NOT NULL	Relative Importance of Work Experience	No	HrRelativeImpt
Industry_Type_Code	nvarchar(5)	NOT NULL	Industry Type	No	HrQuickCode
Organisation_Type_Code	nvarchar(5)	NOT NULL	Organistion Type	No

Table Name: EMSS_Work_Experience_HDR

Purpose:	Stores Header information about the work experience of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Employee Code Setup (EMPNG) OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Document_ID	INT	NOT NULL	Unique Id across the component used for Work flow	No	HrInt
Request_Status_Code	nvarchar(10)	NULL	This Column is used to store the Workflow status of the Request.	No	wfstatename
Employee_Remarks	nvarchar(255)	NULL	Remarks	No	hrremarks
Request_Date	datetime	NULL	Date of Request	No	Datetime
Auth_Emp_Code	nvarchar(20)	NULL	Authorizer Employee Code	No	HrEmpCode
Authoriser_Remarks	nvarchar(255)	NULL	Authoriser Remarks	No	hrremarks
Authorisation_Date	datetime	NULL	Date of Authorisation	No	Datetime
Modify_Option_Cd	nvarchar(5)	NULL	Tells that given request is new request or corrections to the existing record.Quick code values are Correct and Update	No	HrQuickCode
New_Eff_From_Date	datetime	NULL	If the request is corrected New Effective From Date is given	No	Datetime
Auth_Rej_Flag	nvarchar(5)	NULL	Authorise/Reject Flag	No	HrQuickCode
Login_OU_Code	int	NOT NULL	Self Service OU	No	HrOUInstance

Table Name: epin_air_passage_dtls

Purpose:	This table stores the employee air passage details
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Inretacting Master OU code	Yes
employee_code	VARCHAR(10)	NOT NULL	Employee Code	Yes
effective_from_date	datetime	NOT NULL	Effective from date	Yes
effective_to_date	datetime	NOT NULL	Effective to date	No
eligibility_code	VARCHAR(5)	NOT NULL	Eligibilty Code	No
class_of_travel_code	VARCHAR(5)	NOT NULL	Class of Travel	No
country_code	VARCHAR(5)	NOT NULL	Country Code	No
airport_code	VARCHAR(5)	NOT NULL	Airport Code	No
comments	VARCHAR(255)	NOT NULL	Comments	No

Table Name: Epin_Asset

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	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	The code identifying the employee.	Yes	HrEmpCode
Serial_Number	int	NOT NULL	Generated automatically in increments of 1 when a new record is added in the multiline.(For an employee).	Yes	hrint
Asset_Type	nvarchar(5)	NULL	Asset value as selected by the user in the Asset combo. User Defined Quick Code. BP = 'EPIN' PV = 'ASTS' Eg> Shoe,Lock,etc	No	HrQuickCode
Asset_Status	nvarchar(5)	NULL	Status as selected by the user in the Status combo. System Defined Quick Code. BP = 'EPIN' PV = 'STAT' Eg> Issued,Returned.	No
ImpactOnPayroll	nvarchar(5)	NULL	Indicates that the asset allocated to the employee has an impact on the employee s payroll. System Defined Quick Code. BP = 'EPIN' PV = 'IMPY' Eg> Yes,No.	No
Asset_Details	nvarchar(40)	NULL	Any details regarding the asset allocated to the employee.	No	HrQuickCodeDesc
Size	nvarchar(10)	NULL	The size of the asset allocated to the employee.	No	HrCd
Quantity	INT	NULL	The quantity of asset allocated to the employee.	No	HrInt
Date_of_Issue	nvarchar(11)	NULL	The date on which the asset is allocated to the employee.	No	HrDate
Date_of_Return	nvarchar(11)	NULL	The date on which the employee returns the asset.	No
Reference_Number1	nvarchar(25)	NULL	The first reference number for the asset allocated to the employee.	No	hrdesc
Reference_Number2	nvarchar(25)	NULL	The second reference number for the asset allocated to the employee.	No
Remarks	nvarchar(255)	NULL	Any additional remarks regarding the asset allocated to the employee.	No	hrremarks

Table Name: EPIN_CHKRELATIVEIMP_TEMP

Purpose:	Temporary Table for Checking Relative Importance rules
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	No	HrGuid
Master_Ou_Code	INT	NULL	Interacting Master OU code	No	HrOuInstance
Employee_Code	nvarchar(20)	NULL	Employee Code	No	HrEmpCode
Relative_Importance	INT	NULL	Relative Importance	No	HrRelativeImpt
User_Code	nvarchar(10)	NULL	User Code	No	HrUserCode
HrDateTime	nvarchar(21)	NULL	Datetime	No	HrDateTime
Relative_Importance_id	INT	NULL	Relative ID	No	HrRelativeImpt
Time_Stamp	INT	NULL	Timestamp	No	HrTimeStamp

Table Name: EPIN_Competency

Purpose:	Stores Competency information about the employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Competency_Code	nvarchar(10)	NOT NULL	Competency Code	Yes	hrcompcode
Effective_From	datetime	NOT NULL	From date for the history information	Yes	Datetime
Compy_Class_Code	nvarchar(10)	NOT NULL	Competency Class Code	Yes	hrclasscode
Competency_Element_Code	nvarchar(10)	NOT NULL	Competency Element Code	Yes	hrelementcode
Effective_To	datetime	NULL	To date for the history information	No	Datetime
Data_level_Flag	nvarchar(3)	NULL	C - At Competency Level E - At Data Level	No	hrflag
Possessed_Level	INT	NULL	Possed Level	No	hremployeescore
Assessed_By_Flag	nvarchar(5)	NULL	Flag to Indicate whether assessed by Internal or External Assessor	No	HrQuickCode
Assessed_Level	INT	NULL	Assessed Level	No	hremployeescore
Valid_From	nvarchar(11)	NULL	Valid From	No	HrDate
Valid_To	nvarchar(11)	NULL	Valid To	No
Internal_Assessor	nvarchar(20)	NULL	Internal Assessor Code	No	HrEmpCode
Internal_Remarks	nvarchar(255)	NULL	Internal assessor remarks	No	hrremarks
Extern_Organisation	nvarchar(25)	NULL	External Organisation	No	HrDescription
assessed_on_date	nvarchar(11)	NULL	Date of Assessment	No	HrDate
Extern_Assessor	nvarchar(77)	NULL	External assessor Name	No	HrEmpName
Extern_Remarks	nvarchar(255)	NULL	External assessor remarks	No	hrremarks
Certification_Authority	nvarchar(50)	NULL	Certification Authority	No	hrcertauth
Certification_Number	nvarchar(20)	NULL	Certification Number	No	hrcertnum
Certification_Valid_From_date	datetime	NULL	Certification valid from	No	Datetime
Certification_Valid_To_date	datetime	NULL	Certification Valid To	No
Certification_Remarks	nvarchar(255)	NULL	Certification Remarks	No	hrremarks
Login_OU_Code	int	NOT NULL	PERIN OU	No	HrOUInstance
Source_Component	nvarchar(20)	NULL	The name of the component which modifies the data	No	ctxt_component

Table Name: EPIN_CompScores_Temp

Purpose:	Temporary Table for calculating competency scores
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
EmployeeCode	nvarchar(20)	NOT NULL	Employee Code	No	HrEmpCode
CompetencyCode	nvarchar(10)	NOT NULL	Competency Code	No	hrcompcode
CompetencyWt	INT	NOT NULL	Competency weight	No	hrcompwt
CompetencyMDL	INT	NOT NULL	Competency Minimum desired level	No	hrcompmdl
ClassCode	nvarchar(10)	NOT NULL	Class Code	No	hrclasscode
ClassWt	INT	NOT NULL	Class Weight	No	hrclasswt
ElementCode	nvarchar(10)	NOT NULL	Element Code	No	hrelementcode
ElementWt	numeric(5,0)	NOT NULL	Element Weight	No	hrelementwt
ElementMDL	INT	NULL	Element Minimum desired level	No	hrelementmdl
ElementScore	INT	NOT NULL	Element Score	No	hremployeescore

Table Name: EPIN_Contact

Purpose:	Stores contact information about the employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Contact_Type_Code	nvarchar(5)	NOT NULL	Contact Type	Yes	HrQuickCode
Effective_From	datetime	NOT NULL	From date of the history information	Yes	Datetime
Primary_address	INT	NULL	Primary address flag	No	Hrcheck
act_inact_flag	nvarchar(3)	NULL		No	hrflag
Effective_To	datetime	NULL	To Date of history information	No	Datetime
Address_1	nvarchar(40)	NOT NULL	Address	No	HrAddress
Address_2	nvarchar(40)	NULL	Address	No
Address_3	nvarchar(40)	NULL	Address	No
Country_Code	nvarchar(5)	NOT NULL	Country Code	No	CountryCode
State_Code	nvarchar(10)	NOT NULL	State Code	No	hrstatecode
County	nvarchar(5)	NULL	Country	No	hrquickcode
city	nvarchar(5)	NULL	City	No
other_city	nvarchar(40)	NULL	User specified city	No	hraddress
school	nvarchar(5)	NULL	School	No	hrquickcode
Zip	nvarchar(40)	NULL	Zip Number	No	HrZip
Phone_number_1	nvarchar(20)	NULL	Phone Number	No	hrphone
Phone_number_2	nvarchar(20)	NULL	Phone Number	No
Fax_number	nvarchar(40)	NULL	Fax Number	No	HrEmailId
Mobile_Number	nvarchar(20)	NULL	Mobile Number	No	HrMobile
Email_Code	nvarchar(40)	NULL	Email Id	No	HrEmailId
Home_Page	nvarchar(80)	NULL	Home Page URL	No	hrdesc40
Comments	nvarchar(2000)	NULL	Comments	No	hrnotes
Login_OU_Code	int	NOT NULL	PERIN OU	No	HrOUInstance
Source_Component	nvarchar(20)	NULL	Name of component modifying the data	No	ctxt_component

Table Name: EPIN_Disability

Purpose:	Stores Disability information about the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Disability	nvarchar(5)	NOT NULL	Nature of Disability	Yes	hrquickcode
Disability_From	datetime	NOT NULL	Start date of disability	Yes	Datetime
Disability_To	datetime	NULL	End Date of Disability	No
Extent_Code	nvarchar(5)	NOT NULL	Extent of Disability	No	HrQuickCode
Temporary_Code	nvarchar(5)	NOT NULL	Whether the disability is temporary	No
Assessed_Flag	nvarchar(3)	NOT NULL	Whether the disability has been assessed	No	hrflag
Concessions	nvarchar(255)	NULL	Concessions due to disability	No	HrText255
Login_OU_Code	int	NOT NULL	PERIN OU	No	HrOUInstance
Source_Component	nvarchar(20)	NULL	Name of the component modifying the data	No	ctxt_component

Table Name: epin_doc_attach_dtl

Purpose:	Table for Storing Employee Document Attachments.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Master OU Code	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Source_Component	nvarchar(20)	NOT NULL	Source Component Code	Yes	Ctxt_Component
Doc_Line_No	INT	NOT NULL	Document Line No	Yes	HrNumber
Document_Type	nvarchar(5)	NOT NULL	Document Type Code	No	HrQuickCode
Document_Id	nvarchar(10)	NOT NULL	Document ID	No	HrCd
Doc_File_Name	nvarchar(50)	NOT NULL	Physical File Name	No	filename

Table Name: EPIN_EEA1_declaration

Purpose:	This table stores the authorized records of the employee EEA1 declaration.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_ou_code	int	NOT NULL	Unique GUID generated on every session	Yes	hrouid
Employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	hrempcode
effective_from_date	datetime	NOT NULL	Effective from date of an employee	Yes	Datetime
effective_to_date	datetime	NULL	Effective to date of an employee	No
emp_gender	nvarchar(5)	NULL	Employee gender details	No	hrquickcode
emp_race	nvarchar(5)	NULL		No
emp_disability	nvarchar(5)	NULL	Employee disability	No
Nature_of_disability	nvarchar(80)	NULL	Nature disability	No	hrdesc40
record_status	nvarchar(7)	NULL	Record status	No	hrstatus
comments	nvarchar(255)	NULL	Comments	No	hrtext255
rejection_reason	nvarchar(255)	NULL	Reason for rejection	No	hrremarks
login_ou_code	int	NULL	Login ou Code	No	hrouid
doc_id	nvarchar(30)	NULL	Document ID	No	hrdocid
doc_status	nvarchar(10)	NULL	Documents status	No	wfstatename

Table Name: EPIN_Employee

Purpose:	Stores information about the employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Employee_Type	nvarchar(5)	NOT NULL	Type of Employee	No	HrQuickCode
Employment_start_date	datetime	NOT NULL	Employment start date	No	Datetime
Employment_Status_Code	nvarchar(5)	NULL	Employement status	No	HrQuickCode
Application_Ref_Number	VARCHAR(20)	NULL	Application Reference Number	No	HrAppNumber
Recruited_For_Company_Code	nvarchar(10)	NULL	Code of the Company, recruited for	No	hrcompcode
Date_Of_Birth	datetime	NULL	Date of Birth	No	Datetime
Auth_Init_Flag	nvarchar(3)	NULL	Authorization Initiated	No	hrflag
Authorize_Flag	nvarchar(3)	NULL	Authorization Flag	No
Rejection_Reason	nvarchar(255)	NULL	Rejection Reason	No	hrremarks
Comments	nvarchar(2000)	NULL	Comments	No	hrnotes
Document_Id	nvarchar(30)	NULL	Document Id - for workflow	No	hrdocid
Convicted_Felony_Flag	nvarchar(3)	NULL	Convicted in Felony	No	hrflag
Felony_Details	nvarchar(255)	NULL	Details of Felony	No	HrText255
Military_service_Flag	nvarchar(3)	NULL	Military Service	No	hrflag
Blood_group_Code	nvarchar(5)	NULL	Blood Group	No	HrQuickCode
Smoker_Flag	nvarchar(5)	NULL	Smoker Flag	No
Height	numeric(10,2)	NULL	Height	No	HrCompaRatio
Height_Unit_Code	nvarchar(5)	NULL	UOM of Height	No	HrQuickCode
Weight	numeric(10,2)	NULL	Weight	No	HrCompaRatio
Weight_unit_code	nvarchar(5)	NULL	UOM of Weight	No	HrQuickCode
Birth_Marks	nvarchar(255)	NULL	Birth marks	No	HrText255
Request_For_Deletion	int	NULL	Request for deletion flag	No	hrcheck
Image_Name	nvarchar(255)	NULL	Name of the employee photo	No	hrtext255
Doc_Status	nvarchar(10)	NULL	Document Status - workflow	No	wfstatename
Login_Language_Code	INT	NULL	Login Language	No	HrLangCd
Login_OU_Code	int	NOT NULL	PERIN OU	No	HrOUInstance
Source_Component	nvarchar(20)	NULL	Name of the Component modifying data	No	ctxt_component

Table Name: EPIN_Employee_Pend

Purpose:	Stores information about employee before authorization. For Comments on columns refer EPIN_Employee
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 of an organisation	Yes	hrempcode
Employee_Type	nvarchar(5)	NULL	Employee Type (Contract, Temporary etc...)	No	hrquickcode
Recruited_For_Company_Code	nvarchar(10)	NULL	Company code recruited	No	hrcompcode
Title_Code	nvarchar(5)	NULL	Title code	No	hrquickcode
First_Name	nvarchar(25)	NULL	Employee First Name	No	hrempfirstname
Middle_Name	nvarchar(25)	NULL	Employee MiddleName	No	hrempmiddlename
Last_Name	nvarchar(25)	NULL	Employee Last Name	No	hremplastname
Known_As	nvarchar(25)	NULL	Employee Alias Name	No	hrempknownas
Employment_Start_Date	datetime	NULL	Start Date of an employment	No	Datetime
Application_Ref_Number	nvarchar(26)	NULL	Appliaction reference number	No	hrappnumber
Request_For_Deletion	int	NULL	Deletion request	No	hrcheck
Authorize_flag	nvarchar(3)	NULL	Flag for authorisation	No	hrflag
Rejection_reason	nvarchar(255)	NULL	Reason for the rejection	No	hrremarks
Comments	nvarchar(2000)	NULL	Comments	No	hrnotes
Doc_Status	nvarchar(10)	NULL	Document Status	No	wfstatename
timestamp	int	NULL	Timestamp	No	hrtimestamp

Table Name: Epin_Employee_Singapore_Statutory

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
CPF_Type_Code	nvarchar(5)	NULL	Employee CPF Type Code	No	hrquickcode
Pensionable_code	nvarchar(5)	NULL	Pensionable code for Singapore Statutory	No
Emp_tax_Code	nvarchar(5)	NULL	Employee Unique Tax Code	No
User1_code	nvarchar(5)	NULL	User Defined Code	No
User2_Code	nvarchar(5)	NULL	User Defined Code	No
User3_Code	nvarchar(5)	NULL	User Defined Code	No
User4_Code	nvarchar(5)	NULL	User Defined Code	No

Table Name: EPIN_Family_Member_Hist

Purpose:	Stores information about employees family member
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Family_member_Id	INT	NOT NULL	Family Member	Yes	HrNumber
Effective_From_date	datetime	NOT NULL	From date of history information	Yes	Datetime
Family_Member_Code	int	NULL	Family member code	No	hrint
First_Name	nvarchar(25)	NOT NULL	Family member First Name	No	HrEmpFirstName
U_First_Name	nvarchar(25)	NULL	For Indexing	No
Date_Of_Birth	datetime	NOT NULL	Family member date of birth	No	Datetime
Effective_To_Date	datetime	NULL	To date of history information	No
Middle_Name	nvarchar(25)	NULL	Family Member Middle Name	No	HrEmpMiddleName
U_Middle_Name	nvarchar(25)	NULL	For indexing	No
Last_Name	nvarchar(25)	NULL	Family member Last Name	No	HrEmpLastName
U_Last_Name	nvarchar(25)	NULL	For Indexing	No
SIN	nvarchar(20)	NULL	Social Insurance Number	No	HrPersonalIDCode
SSN	nvarchar(20)	NULL	Social Security Number	No
Relationship_Code	nvarchar(5)	NOT NULL	Relationship with the employee	No	HrQuickCode
Gender_Code	nvarchar(5)	NOT NULL	Gender of the Family Member	No
Dependent_Flag	nvarchar(3)	NOT NULL	Whether dependant	No	hrflag
Occupation_Code	nvarchar(150)	NULL	Occupation Code	No	hrchar150
Family_member_Emp_Code	nvarchar(20)	NULL	Employee Code of the Family Member if applicable	No	HrEmpCode
Relationship_current_Flag	nvarchar(3)	NULL	Whether the relationship is current	No	hrflag
Relationship_End_Date	datetime	NULL	Relationship end date	No	Datetime
Reason_Code	nvarchar(5)	NULL	Reason code	No	HrQuickCode
Other_Reason	nvarchar(255)	NULL	Other reason if any	No	hrremarks
Marital_Status_Code	nvarchar(5)	NULL	Marital Status	No	hrquickcode
Military_Status_Code	nvarchar(5)	NULL	Military Status	No
Disability_Code	nvarchar(5)	NULL	Disability Code	No
Citizenship_ID_Number	nvarchar(80)	NULL	Citizenship ID Number	No	hrdesc40
Comments	nvarchar(2000)	NULL	Comments	No	hrnotes
Login_OU_Code	int	NOT NULL	PERIN OU	No	HrOUInstance
Source_Component	nvarchar(20)	NULL	Name of the component updating data	No	ctxt_component
Relationship_start_date	datetime	NULL	Relationship start date of the family member of a n employee.	No	Datetime
empr_r_school	nvarchar(80)	NULL		No	hrdesc40
Dependent_Pass_Start_Dt	nvarchar(25)	NULL	Dependent's Pass Expiry Start Date.	No	datetime
Dependent_Pass_End_Dt	nvarchar(25)	NULL	Dependent's Pass Expiry End Date.	No	datetime
Occupation_status	nvarchar(300	NULL	Occupation status of the family member of an employee	No	hrchar150

Table Name: EPIN_Hobby

Purpose:	Stores information about Employee Hobbies
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Hobby_Type_Code	nvarchar(5)	NOT NULL	Hobby Type Code	Yes	HrQuickCode
Hobby_Name	nvarchar(100)	NOT NULL	Hobby Name	Yes	Description
Category_Code	nvarchar(5)	NULL	Hobby Category Code	No	HrQuickCode
Level_Of_Representation_Code	nvarchar(5)	NULL	Level of Representation	No
Achievements	nvarchar(255)	NULL	Achievement If any	No	HrText255
Currently_pursuing_Flag	nvarchar(3)	NULL	Currenly Pursuing	No	hrflag
Login_OU_Code	int	NOT NULL	PERIN OU	No	HrOUInstance
Source_Component	nvarchar(20)	NULL	Name of the component modifying the data	No	ctxt_component

Table Name: EPIN_Identification

Purpose:	Stores identification information about the employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Identification_type	nvarchar(5)	NOT NULL	Identification Type	Yes	HrQuickCode
Document_number	nvarchar(25)	NOT NULL	Document Number	Yes	HrDescription
Place_Of_issue	nvarchar(25)	NOT NULL	Place of Issue	No
Issuing_Authority	nvarchar(25)	NOT NULL	Issuing Authority	No
Date_Of_issue	datetime	NOT NULL	Date of Issue	No	Datetime
Valid_From	datetime	NULL	Valid From	No
Valid_Till	datetime	NOT NULL	Valid To	No
Remarks	nvarchar(255)	NOT NULL	Remarks	No	HrText255
Login_OU_Code	int	NOT NULL	PERIN OU	No	HrOUInstance
Source_Component	nvarchar(20)	NULL	Name of the component modifying data	No	ctxt_component

Table Name: EPIN_Image_Path

Purpose:	Stores Information about where the Employee Photos are stored
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Physical_Image_Path	nvarchar(255)	NULL	Physical path where the employee photo is stored	No	hrtext255
Virtual_Image_Path	nvarchar(255)	NULL	Equivalent Virtual path of the physical path	No

Table Name: epin_info_arabic_dtl

Purpose:	The Arabic literal for the corresponding field value in English will be stored employee wise in this table.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
field_code	VARCHAR(10)	NOT NULL	Field Code of English Field Name	Yes	HrCd
employee_code	VARCHAR(10)	NOT NULL	Employee Code	Yes	HrEmpCode
arabic_equivalent	VARCHAR(255)	NULL	Arabic Equivalent of English field	No	HrText255

Table Name: epin_info_arabic_hdr

Purpose:	The Arabic literal for the corresponding field value in English will be stored in this master table.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
field_code	VARCHAR(10)	NOT NULL	The field code for which the employee has to enter the details in Arabic.	Yes	HrCd
field_name	VARCHAR(40)	NULL	The name of the field for which the employee has to enter the details in Arabic.	No	HrQuickCodeDesc
field_size	INT	NULL	The size or width of the field.	No	HrInt
system_defined	VARCHAR(1)	NULL	System Defined	No	hrflag

Table Name: EPIN_Language

Purpose:	Stores Detailed information about the Languages known by the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Language_Code	nvarchar(5)	NOT NULL	Language Code	Yes	HrQuickCode
Proficiency_Code	nvarchar(5)	NULL	Proficiency Code	No
Conduct_Business_Flag	nvarchar(5)	NULL	Can Conduct Business in a language	No
Mother_Tongue_Flag	nvarchar(5)	NULL	Whether the language is Mother Tongue	No
Login_OU_Code	int	NOT NULL	PERIN OU	No	HrOUInstance
Source_Component	nvarchar(20)	NULL	Name of the component modifying the data	No	ctxt_component

Table Name: EPIN_Language_HDR

Purpose:	Stores Header information about the Languages known to the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Comments	nvarchar(2000)	NULL	Comments	No	hrnotes

Table Name: EPIN_Military_Assignments

Purpose:	Stores information about the Military Assignments of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Assignment	nvarchar(25)	NOT NULL	Military Assignment	Yes	HrDescription
Assignment_Start_date	datetime	NOT NULL	Start date of military assignment	Yes	Datetime
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Service_Number	nvarchar(25)	NOT NULL	Service Number	Yes	HrDescription
Service_Entry_Date	datetime	NOT NULL	Service Entry date	Yes	Datetime
Assignment_End_date	datetime	NULL	Assignment End Date	No
Service_Type_Code	nvarchar(5)	NULL	Type of Military Service	No	HrQuickCode
Category_Code	nvarchar(5)	NULL	Category of Military Service	No
Remarks	nvarchar(255)	NULL	Remarks	No	HrText255
Login_OU_Code	int	NOT NULL	PERIN OU	No	HrOUInstance
Source_Component	nvarchar(20)	NULL	Name of the Component modifying the data	No	ctxt_component

Table Name: EPIN_Military_Service

Purpose:	Stores Information about Military Service of The Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Service_Number	nvarchar(25)	NOT NULL	Service Number	Yes	HrDescription
Service_Entry_Date	datetime	NOT NULL	Service Entry Date	Yes	Datetime
Service_Release_Date	datetime	NOT NULL	Service Release Date	No
Service_Field_Code	nvarchar(5)	NOT NULL	Field of Service	No	HrQuickCode
Trade	nvarchar(25)	NULL	Trade	No	HrDescription
Comments	nvarchar(2000)	NULL	Comments	No	hrnotes
Rank_at_Discharge	nvarchar(25)	NULL	Rank at discharge	No	HrDescription
Login_OU_Code	int	NOT NULL	PERIN OU	No	HrOUInstance
Source_Component	nvarchar(20)	NULL	Name of the Component modifying the data	No	ctxt_component

Table Name: EPIN_Military_Service_hdr

Purpose:	Stores header information about the Military Service of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Comments	nvarchar(2000)	NULL	Comments	No	hrnotes
Login_OU_Code	int	NOT NULL	PERIN OU	No	HrOUInstance
Source_Component	nvarchar(20)	NULL	Name of the Component modifying the data	No	ctxt_component

Table Name: EPIN_MLTRY_ASSIGN_TEMP

Purpose:	Temporary table for Military Assignment
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 Master OU code	No	HrOuInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	No	HrEmpCode
Service_Number	nvarchar(25)	NULL	Service Number	No	HrDescription
Service_Entry_Date	datetime	NOT NULL	Service entry date	No	Datetime
Assignment	nvarchar(25)	NOT NULL	Assignment of an employee	No	HrDescription
Assignment_Start_date	datetime	NOT NULL	Assignment start date of an employee	No	Datetime

Table Name: EPIN_object_count

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Object_Name	nvarchar(255)	NOT NULL	Object Name	Yes	hrtext255
Object_Type	nvarchar(5)	NULL	Object Type (Table, View, SP etc..)	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: EPIN_OldEmpcodeMap

Purpose:	If ex-employee re-joined in company, Organization wants to consider his previous service. This can be done thru Employee - Old Employee mapping page. This table will store the mapping information of New employee code and old employee 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.	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	The unique code to identify the employee for whom mapping must be done.	Yes	HrEmpCode
Old_Employee_Code	nvarchar(20)	NOT NULL	The unique code to identify the employee who was separated from the organization.	Yes
Consider_Service	nvarchar(5)	NULL	System Defined Quick Code. BP = 'GEN' PV = 'ADM' Eg> Yes,No	No	HrQuickCode

Table Name: EPIN_Personal_Hist

Purpose:	Stores information about Employee Personal History
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Effective_From_Date	datetime	NOT NULL	From date of history information	Yes	Datetime
Effective_To_date	datetime	NOT NULL	To date of history information	No
Title_Code	nvarchar(5)	NULL	Title Code	No	HrQuickCode
First_Name	nvarchar(25)	NOT NULL	First Name	No	HrEmpFirstName
U_First_Name	nvarchar(25)	NULL	Upper case of First name for Indexing	No
Middle_Name	nvarchar(25)	NULL	Middle Name	No	HrEmpMiddleName
U_Middle_Name	nvarchar(25)	NULL	Upper case of Middle name for Indexing	No
Last_Name	nvarchar(25)	NULL	Last Name	No	HrEmpLastName
U_Last_Name	nvarchar(25)	NULL	Upper case of Last name for Indexing	No
Known_As	nvarchar(25)	NULL	Employee Known as	No	HrEmpKnownAs
U_Known_As	nvarchar(25)	NULL	Upper case of Known as for Indexing	No
SSN	nvarchar(20)	NULL	Social Security Number	No	HrPersonalIDCode
SIN	nvarchar(20)	NULL	Social Insurance Number	No
NINoApp_Date	datetime	NULL		No	Datetime
Confirm_Due_Date	datetime	NULL	Confirmtion Due Date	No
Confirm_Time	datetime	NULL	Confirmation Time	No
Actl_Confirm_date	datetime	NULL	Actual Confirmation Date	No
Actl_Confirm_Time	datetime	NULL	Actual Confirmation Time	No
Gender_Code	nvarchar(5)	NULL	Gender Code	No	HrQuickCode
Marital_Status_Code	nvarchar(5)	NULL	Marital Status Code	No
Ethnicity_Code	nvarchar(5)	NULL	Etnicity Code	No
Nationality_code	nvarchar(5)	NULL	Nationality of the employee.	No	hrquickcode
Religion_Code	nvarchar(5)	NULL	Religion of the employee.	No	HrQuickCode
Country_Code	nvarchar(5)	NULL	Country Code of the employee.	No	CountryCode
State_Code	nvarchar(10)	NULL	State Code of the employee.	No	hrstatecode
Citizenship_Code	nvarchar(5)	NULL	Employee's Citizenship Code	No	hrquickcode
Service_Ref_Date	nvarchar(25)	NULL	Service Reference Date.	No	datetime
Emergency_Contact_Name_1	nvarchar(40)	NULL	Emergency Contact name	No	HrName40
Emergency_Relationship_Code_1	nvarchar(5)	NULL	Emergency Relationship Code	No	HrQuickCode
Emergency_Phone_number_1	nvarchar(20)	NULL	Emergency Phone Number	No	hrphone
Emergency_Mobile_Number_1	nvarchar(20)	NULL	Emergency Mobile Number	No	HrMobile
Emergency_Contact_Name_2	nvarchar(40)	NULL	Emergency Contact Name	No	HrName40
Emergency_Relationship_Code_2	nvarchar(5)	NULL	Emergency Relationship Code	No	HrQuickCode
Emergency_Phone_number_2	nvarchar(20)	NULL	Emergency Phone Number	No	hrphone
Emergency_mobile_Number_2	nvarchar(20)	NULL	Emergency Mobile Number	No	HrMobile
Comments	nvarchar(2000)	NULL	Comments	No	hrnotes
Login_OU_Code	int	NOT NULL	PERIN OU	No	HrOUInstance
Source_Component	nvarchar(20)	NULL	Name of the component modifying the data	No	ctxt_component

Table Name: EPIN_Primary_Achievement

Purpose:	Stores information about the qualification of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Achievement_Id	INT	NOT NULL	Achievement ID - Running Number	Yes	HrNumber
Effective_From	datetime	NOT NULL	From date of history information	Yes	Datetime
Effective_To	datetime	NULL	To date of History Information	No
Achievement_Code	nvarchar(10)	NOT NULL	Achievement Code	No	HrAchCode
Relative_Importance	INT	NOT NULL	Relative Importance	No	HrRelativeImpt
Institution	nvarchar(500)	NULL	Institution	No	hrtext500
Major_Code	nvarchar(5)	NULL	Major Code	No	HrQuickCode
Minor_Code	nvarchar(5)	NULL	Minor Code	No
Passing_Month_Code	nvarchar(5)	NULL	Passing Month Code	No
Passing_year	INT	NULL	Passing Year	No	HrYr
Duration	INT	NULL	Duration	No	HrInt
Unit_Code	nvarchar(5)	NULL	UOM of Duration	No	HrQuickCode
Nature_Code	nvarchar(5)	NULL	Nature Code	No
GPA_Percentage	numeric(5,2)	NULL	GPA Percentage	No	HrPercentage
Start_Date	datetime	NULL	Qualification Start Date	No	Datetime
Maximum	numeric(5,2)	NULL	Maximum Percentage	No	HrPercentage
Sponsored_Flag	nvarchar(3)	NULL	Sponsored	No	hrflag
Rank	INT	NULL	Rank	No	HrRank
Class_Code	nvarchar(5)	NULL	Class Obtained	No	HrQuickCode
Valid_From	datetime	NULL	Qualification Valid From	No	Datetime
Valid_Till	datetime	NULL	Qualification Valid To	No
Login_OU_Code	int	NOT NULL	PERIN OU	No	HrOUInstance
Source_Component	nvarchar(20)	NULL	Name of the component modifying the data	No	ctxt_component
highest_qual_qc	nvarchar(5)	NULL		No	HrQuickCode
Country_Conf_Deg	nvarchar(5)	NULL	Employee's Country of Conferring Degree.	No	hrquickcode
Trained_In	nvarchar(5)	NULL	Employee is Locally trained or Foreign trained. Quick Code: BP - EPIN PV - LTFT	No
remarks	nvarchar(255)	NULL		No	hrtext255

Table Name: Epin_Rec_HealthCheck

Purpose:	Employee health detail table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Master ou code	Yes	hrouinstance
Employee_code	nvarchar(20)	NOT NULL	Employee code of the record	Yes	HrEmpCode
Effective_From_Date	datetime	NOT NULL	Effective from date for the record	Yes	Datetime
Serial_No	int	NOT NULL	Serial No for each record employee wise	Yes	HrOUInstance
Health_Check_Startdate	datetime	NULL	Health check start date	No	Datetime
Effective_To_Date	datetime	NULL	Effective to date for the record	No
Pre_Employment_Checkup_Date	datetime	NULL	Pre employment health checkup date	No
Pre_Existing_Illness	nvarchar(255)	NULL	Pre existing illness detail	No	hrremarks
Hepatitis_B_Status	nvarchar(5)	NULL	Hepatitile B Status	No	HrQuickCode
Health_Check_Types	nvarchar(5)	NULL	Health check type	No
Health_Check_Date	datetime	NULL	Health Check date	No	Datetime
Health_Check_End_Date	datetime	NULL	Health check end date	No
Remarks	nvarchar(255)	NULL	Remarks about the employee records	No	hrremarks

Table Name: epin_recognition_dtl

Purpose:	This table stores the employee recognition 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
nomination_serial_no	int	NOT NULL	Nomination serial Number	Yes	hrint
nomination_by_code	nvarchar(5)	NULL	Nomination code	No	hrquickcode
nom_guest_name	nvarchar(77)	NULL	Nomination guest name	No	HrEmpName
nomination_date	datetime	NULL	Nomination date	No	Datetime
attitude_flag	int	NULL	Employee attitude flag	No	hrcheck
openess_flag	int	NULL	Openess flag	No
competence_flag	int	NULL	Competence flag	No
courage_flag	int	NULL	Courage flag	No
integrity_flag	int	NULL	Integrity flag	No
challenge_flag	int	NULL	Challenge flag	No
balance_flag	int	NULL	Balance flag	No
additional_value1_flag	int	NULL	Additional user defined values	No
additional_value2_flag	int	NULL	Additional user defined values	No
additional_value3_flag	int	NULL	Additional user defined values	No
colleague_satis_flag	INT	NULL	Colleague satisfaction flag	No	Hrcheck
guest_satis_flag	INT	NULL	Guest satisfaction flag	No
pos_cash_flow_flag	INT	NULL	Cash flow flag	No
recog_status_flag	nvarchar(5)	NULL	Reorganization status flag	No	hrquickcode
source_component	nvarchar(20)	NULL	Source interacting component name	No	Ctxt_Component
login_ou_code	int	NULL	Employee Login OU code	No	hrouinstance
comments	nvarchar(2000)	NULL	Comments	No	hrnotes
recognition_reason	nvarchar(1000)	NULL	recognition reason	No	hrtext1000

Table Name: EPIN_Reference

Purpose:	Stores information about reference information of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Reference_Type_Code	nvarchar(5)	NOT NULL	Reference Type Code	Yes	HrQuickCode
Name_Of_Reference	nvarchar(40)	NOT NULL	Name of Reference	Yes	HrName40
Organisation_Description	nvarchar(25)	NOT NULL	Name of the Organization	No	HrDescription
position_Description	nvarchar(25)	NOT NULL	Position Description	No
Contact_Information	nvarchar(25)	NULL	Contact Information	No
Date_Of_Reference	datetime	NULL	Date of Reference	No	Datetime
Reference_remarks	nvarchar(255)	NULL	Reference Remarks	No	HrText255
HR_remarks	nvarchar(255)	NULL	HR Remarks	No
Reference_Check_Status	nvarchar(3)	NULL	Reference Check Completed	No	hrflag
Login_OU_Code	INT	NOT NULL	PERIN OU	No	HrOuInstance
Source_Component	nvarchar(20)	NULL	Name of the Component modifying the data	No	ctxt_component

Table Name: EPIN_Temp

Purpose:	Temporary Table for Storing Language Information
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
HRGUID	nvarchar(40)	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
Language_Code	nvarchar(5)	NULL	Language Code ( 1 for English)	No	hrquickcode
Proficiency_Code	nvarchar(5)	NULL	Proficiency Code	No
Conduct_Business_Flag	nvarchar(5)	NULL	Conduct Business Flag	No
Mother_Tongue_Flag	nvarchar(5)	NULL	Mother Tongue flag	No

Table Name: EPIN_Work_Experience

Purpose:	Stores detailed information about the work experience of the Employee
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Work_Experience_Id	INT	NOT NULL	Work Experience	Yes	HrNumber
Organisation_Description	nvarchar(25)	NOT NULL	Name of the Organization	No	HrDescription
Relative_Importance	INT	NOT NULL	Relative Importance	No	HrRelativeImpt
Organisation_Type_Code	nvarchar(5)	NOT NULL	Organization Type	No	HrQuickCode
Industry_Type_Code	nvarchar(5)	NOT NULL	Industry Type	No
Job_Description	nvarchar(25)	NULL	Job Description	No	hrjobtitle
Dept_Description	nvarchar(30)	NULL	Department Description	No	hrshortdesc12
EQUIVALENT_JOB_Code	nvarchar(10)	NULL	Equivalent Job Code within the organization	No	hrcd
From_date	datetime	NULL	From Date	No	Datetime
End_Date	datetime	NULL	End Date	No
Gross_Annual_Income	FLOAT	NULL	Gross Annual Income	No	HrSalary
Currency_Code	nvarchar(5)	NULL	Currency Code	No	HrCode
Change_Reason	nvarchar(255)	NULL	Change Reason	No	HrText255
Login_OU_Code	int	NOT NULL	PERIN OU	No	HrOUInstance
Source_Component	nvarchar(20)	NULL	Name of the component modifying the data	No	ctxt_component
address	nvarchar(40)	NULL	Address of the previous company	No	HrAddress
phone	nvarchar(20)	NULL		No	HrPhone
basic_sal	FLOAT	NULL		No	HrSalary
Job_Responsibility	nvarchar(255)	NULL		No	hrtext255
employment_type	nvarchar(5)	NULL	Employment type (Permanent,Casual etc..)	No	hrquickcode
Designation	nvarchar(80)	NULL	Designation	No	hrdesc40
Last_Mnth_Sal	FLOAT	NULL	Last Drawn Monthly Salary	No	HrSalary

Table Name: EPIN_Work_Experience_HDR

Purpose:	Stores information about Work Experience
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	EMPNG OU	Yes	HrOUInstance
Employee_Code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
Login_OU_Code	int	NOT NULL	PERIN OU	No	HrOUInstance
Source_Component	nvarchar(20)	NULL	Name of the Component modifying the data	No	ctxt_component
Comments	nvarchar(2000)	NULL	Comments	No	hrnotes

Table Name: perin_mail_send

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
cert_no	nvarchar(20)	NULL	Certification Number	No	hrcertnum
employee_code	nvarchar(20)	NULL	employee code	No	hrempcode
mail_date	nvarchar(25)	NULL	mail date-workflow mail sent date	No	datetime
remarks	nvarchar(255)	NULL	Remarks for the PERIN mail	No	hrremarks
sno	int	NULL	serial no	No	hrint

Table Name: perin_notify_workflow_tmp

Purpose:	This table store the employee details for workflow mail notification
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
oucode	int	NULL	Interacting master OU code	No	hrouinstance
empcode	nvarchar(20)	NULL	Employee Code	No	hrempcode
empname	nvarchar(77)	NULL	name of the employee	No	hrempname
date	datetime	NULL	Date	No	Datetime
department	nvarchar(25)	NULL	Department	No	hrdescription
routeduser	nvarchar(25)	NULL	Document routed user name	No
guid	nvarchar(40)	NULL	Unique GUID is generated on every session	No	hrguid

Table Name: perin_sch_notify_temp

Purpose:	This table store the employee schedule details for mail notification
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
msg_type	nvarchar(40)	NULL	Message Type	No	HrQuickCodeDesc
area_code	nvarchar(10)	NULL	Area Code	No	wfareacode
doc_key	nvarchar(128)	NULL	Documents Key	No	wfdockey
user_ou	int	NULL	User OU	No	hrouid
user_name	nvarchar(25)	NULL	User Name of the employee	No	hrusername
email_id	nvarchar(40)	NULL	Email ID of an employee	No	hremailid
doc_path	nvarchar(128)	NULL	Documents Path	No	wfdockey
createdby	nvarchar(30)	NULL	Created by	No	ctxt_user
createddate	datetime	NULL	Date on which the data is created	No	Datetime
modifiedby	nvarchar(30)	NULL	Modified By	No	ctxt_user
modifieddate	datetime	NULL	Modified Date	No	Datetime

Table Name: perin_send_details_temp

Purpose:	This table store the employee send details
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
username	nvarchar(25)	NULL	UserName of the employee	No	hrusername
emp_code	nvarchar(20)	NULL	Employee Code	No	hrempcode
description	nvarchar(255)	NULL	Description	No	hrtext255
senddate	datetime	NULL	Send date	No	Datetime

Table Name: perin_wfnotify_tmp

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	GUID	No	hrguid
area_code	nvarchar(10)	NULL	area code for workflow	No	wfareacode
doc_key	nvarchar(128)	NULL	doc key column	No	wfdockey
user_ou	int	NULL	user ou is the master ou cod	No	hrouid
user_name	nvarchar(25)	NULL	user name	No	hrusername
timestamp	int	NULL	timestamp	No	hrint
email_id	nvarchar(40)	NULL	email id	No	hremailid
doc_path	nvarchar(128)	NULL	document path	No	wfdockey