NameDescriptionTypeAdditional information
EmployeeId

integer

Required

EmployeeFName

string

Required

Max length: 50

EmployeeMName

string

Required

Max length: 50

EmployeeLName

string

Required

Max length: 50

EmployeeCode

integer

None.

EmployeeFullName

string

Max length: 152

EmployeeGender

string

Required

Max length: 1

EmployeeBirthDate

date

None.

EmployeeNationality

string

Max length: 50

SocialInsuranceNo

string

Max length: 50

EmployeeSSN

string

Max length: 14

BankAccountNo

string

Max length: 50

MartialStatus

string

Max length: 20

MilitaryStatus

string

Max length: 20

DirectManagerId

integer

None.

EmployeePhotoPath

string

Max length: 250

EmployeeHomePhone

string

Max length: 20

EmployeeMobile

string

Max length: 20

EmployeeOtherPhone

string

Max length: 20

EmployeeAddress

string

Max length: 100

EmployeeAddress2

string

Max length: 100

EmployeeEmail

string

Max length: 50

EmployeeLinkedinAccount

string

Max length: 50

EmployeeFacebookAccount

string

Max length: 50

EmployeeBusinessEmail

string

Max length: 50

EmployeeTitle

string

Max length: 50

EmployeeTraining

string

Max length: 100

EmployeeBenifits

string

Max length: 150

JobDescription

string

Max length: 250

OfficeId

integer

None.

DepartmentId

integer

None.

AttendancePlanId

integer

None.

EmployeeHiringDate

date

None.

VacationStartOn

date

None.

ExceedTenYearsInsurance

boolean

None.

ExceedSixMonthsHiring

string

Max length: 5

EmployeeContractStart

date

None.

EmployeeContractRenewal

date

None.

EmployeeEvaluation

string

Max length: 250

EmployeeNextEvaluation

date

None.

IsActive

boolean

Required

CreatedBy

integer

Required

CreationDate

date

Required

InsuranceNumber

string

Max length: 50

InsuranceSalary

decimal number

None.

InsuranceStartDate

date

None.

InsuranceEndDate

date

None.

EmployeeLeavingDate

date

None.

WorkSchedules

string

Max length: 50

NationalIDAdreess

string

Max length: 100

NationalIDGovermentId

integer

None.

RecommendedBy

string

Max length: 100

AcademicQualification

string

Max length: 250

OtherCompany

string

Max length: 100

WorkLocation

string

Max length: 100

InsuranceOffice

string

Max length: 100

Department

Department

None.

AspNetUsers

Collection of AspNetUser

None.

EmployeesPayrolls

Collection of EmployeesPayroll

None.

EmployeesPayrollsHistorys

Collection of EmployeesPayrollsHistory

None.

BonusDeductions

Collection of BonusDeduction

None.

Payroll_Vs

Collection of Payroll_V

None.

Awards

Collection of Award

None.

Custodies

Collection of Custody

None.

OfficeName

string

None.

EmployeeBenefitDeductionJson

string

None.

InsuranceValue

integer

None.

SystemLanguage

string

None.