|
id
|
|
|
company_id
|
|
|
branch_id
|
|
|
employee_code
|
|
|
biometric_code
|
|
|
old_employee_code
|
|
|
salutation
|
|
|
first_name
|
|
|
middle_name
|
|
|
last_name
|
|
|
display_name
|
|
|
gender
|
|
|
date_of_birth
|
|
|
blood_group
|
|
|
marital_status
|
|
|
nationality
|
|
|
religion
|
|
|
caste_category
|
|
|
mobile_no
|
|
|
alternate_mobile_no
|
|
|
email
|
|
|
personal_email
|
|
|
current_address
|
|
|
current_city
|
|
|
current_state
|
|
|
current_pincode
|
|
|
permanent_address
|
|
|
permanent_city
|
|
|
permanent_state
|
|
|
permanent_pincode
|
|
|
joining_date
|
|
|
confirmation_date
|
|
|
probation_end_date
|
|
|
resignation_date
|
|
|
relieving_date
|
|
|
employee_type
|
|
|
employment_category
|
|
|
staff_category
|
|
|
department_name
|
|
|
designation_name
|
|
|
reporting_manager_id
|
|
|
work_location
|
|
|
shift_name
|
|
|
employee_status
|
|
|
attendance_applicable
|
|
|
payroll_applicable
|
|
|
portal_access
|
|
|
aadhaar_no
|
|
|
pan_no
|
|
|
passport_no
|
|
|
driving_license_no
|
|
|
emergency_contact_name
|
|
|
emergency_contact_relation
|
|
|
emergency_contact_mobile
|
|
|
photo_path
|
|
|
signature_path
|
|
|
notes
|
|
|
is_active
|
|
|
delete_status
|
|
|
created_by
|
|
|
updated_by
|
|
|
deleted_by
|
|
|
created_at
|
|
|
updated_at
|
|
|
deleted_at
|
|