Database
Payroll
Payroll Master
Employee
EmployeeHead

EmployeeHead

Documentation for the EmployeeHead database schema.

Fields

FieldData TypeUsage
employeeIdObjectIdUnique reference to employee.
companyHeadIdObjectIdUnique reference to company Head.
amountObjectIdMonetary or numeric value.
formulaIdObjectIdUnique reference to formula.
activeBooleanStores the active data.
salaryRegisterShowFlagBooleanStores the salary register show flag data.
blockSummationBooleanTimestamp/Date for blockSummation.
providentFundGrossPartBooleanUnique reference to provident Fund Gross Part.
employeeStateInsuranceGrossPartBooleanTimestamp/Date for employeeStateInsuranceGrossPart.
grossPartBooleanStores the gross part data.
OTRateHoursNumberTimestamp/Date for OTRateHours.
AttendBonusRateNumberTimestamp/Date for AttendBonusRate.
AttendBonusDaysLimitNumberTimestamp/Date for AttendBonusDaysLimit.
otGrossBooleanStores the ot gross data.
nfhgrossBooleanStores the nfhgross data.
presenceDependentBooleanStores the presence dependent data.
esiGrossPartBooleanStores the esi gross part data.
effectiveFromStringStores the effective from data.
remarksStringDetailed notes or remarks.
isDeletedBooleanStores the is deleted data.
statusBooleanTimestamp/Date for status.
deletedAtDateTimestamp/Date for deletedAt.