Database
Payroll
Payroll Master
Common
HolidayMaster

HolidayMaster

Documentation for the HolidayMaster database schema.

Fields

FieldData TypeUsage
companyIdObjectIdUnique reference to company.
dateDateTimestamp/Date for date.
unitObjectIdStores the unit data.
yearObjectIdStores the year data.
holidayNameStringUnique reference to holiday Name.
isNationalHolidayBooleanUnique reference to is National Holiday.
createdByObjectIdTimestamp/Date for createdBy.
updatedByObjectIdTimestamp/Date for updatedBy.
createdDateDateTimestamp/Date for createdDate.
updatedDateDateTimestamp/Date for updatedDate.
isDeletedBooleanStores the is deleted data.
statusBooleanTimestamp/Date for status.
deletedByObjectIdStores the deleted by data.
deletedTimeDateTimestamp/Date for deletedTime.