Database
Payroll
Payroll Master
Common
SalaryLeavetypeMaster

SalaryLeavetypeMaster

Documentation for the SalaryLeavetypeMaster database schema.

Fields

FieldData TypeUsage
companyIdObjectIdUnique reference to company.
leaveTypeStringStores the leave type data.
shortDescriptionStringDetailed notes or remarks.
leaveNatureStringTimestamp/Date for leaveNature.
remarksStringDetailed notes or remarks.
natureIdObjectIdUnique reference to nature.
maxPerYearNumberStores the max per year data.
calculateOnEarnedBooleanTimestamp/Date for calculateOnEarned.
isCarryForwardBooleanStores the is carry forward data.
carryForwardLeaveLimitNumberStores the carry forward leave limit data.
totalLeaveLimitNumberStores the total leave limit data.
leaveLimitPerInstanceNumberStores the leave limit per instance data.
isFixedTimesIssueBooleanTimestamp/Date for isFixedTimesIssue.
totalTimesIssueNumberTimestamp/Date for totalTimesIssue.
isCashableBooleanStores the is cashable data.
maxCashableAmountNumberMonetary or numeric value.
minLeaveBalanceToEncashNumberStores the min leave balance to encash data.
isConvertibleBooleanStores the is convertible data.
leaveProcessingTypeStringStores the leave processing type data.
leaveAmountNumberMonetary or numeric value.
formulaIdObjectIdUnique reference to formula.
isClubWeekluOffBooleanStores the is club weeklu off data.
isCoverWeeklyOffBooleanStores the is cover weekly off data.
isClubNationalHolidayBooleanUnique reference to is Club National Holiday.
isCoverNationalHolidayBooleanUnique reference to is Cover National Holiday.
isNegativeBalanceAllowedBooleanTimestamp/Date for isNegativeBalanceAllowed.
isPfDeductedBooleanStores the is pf deducted data.
maxHoldAmountNumberMonetary or numeric value.
maxLimitInMonthNumberStores the max limit in month data.
basedOnStringStores the based on data.
insertedUserIdObjectIdUnique reference to inserted User.
updatedUserIdObjectIdUnique reference to updated User.
insertedDateIdObjectIdUnique reference to inserted Date.
updatedDateIdObjectIdUnique reference to updated Date.
isDeletedBooleanStores the is deleted data.
statusBooleanTimestamp/Date for status.
deletedByObjectIdStores the deleted by data.
deletedTimeDateTimestamp/Date for deletedTime.