| Idx | Field Name | Data Type |
|---|---|---|
| allottedLeaveID | int IDENTITY (1, 1) | |
| employeeID | int | |
| leaveTypeID | int | |
| leaveCount | decimal(18,2) | |
| leavesTaken | decimal(18,2) | |
| year | int | |
| createdDate | datetimeoffset(7) | |
| Indexes | ||
| pk_AllottedLeaves | ON allottedLeaveID | |
| unq_AllottedLeaves_employeeID | ON employeeID | |
| unq_AllottedLeaves_leaveTypeID | ON leaveTypeID | |
| Referring Foreign Keys | ||
| fk_BasicInfo_AllottedLeaves | (employeeID) ← BasicInfo | |
| fk_Leave_AllottedLeaves | (leaveTypeID) ← Leave | |
| Idx | Field Name | Data Type |
|---|---|---|
| templateAllowanceDeductionID | int IDENTITY (1, 1) | |
| allowanceDeductionID | int | |
| allowanceOrDeduction | varchar(20) | |
| amountPercentageManual | varchar(20) | |
| amountPercentage | decimal(18,2) | |
| considerInESI | varchar(20) | |
| templateID | int | |
| Indexes | ||
| pk_AllowanceDeduction | ON templateAllowanceDeductionID | |
| unq_AllowanceDeduction_templateID | ON templateID | |
| unq_AllowanceDeduction_allowanceDeductionID | ON allowanceDeductionID | |
| Referring Foreign Keys | ||
| fk_BasicInfo_AllowanceDeduction | (templateID) ← BasicInfo | |
| fk_AllowanceDeduction_AllowanceDeduction | (allowanceDeductionID) ← AllowanceDeduction | |
| Idx | Field Name | Data Type |
|---|---|---|
| allowanceDeductionID | int IDENTITY (1, 1) | |
| allowanceDeductionTypeName | varchar(100) | |
| regularOrSpecial | varchar(20) | |
| allowanceDeductionStatus | varchar(20) | |
| Indexes | ||
| pk_AllowanceDeduction | ON allowanceDeductionID | |
| Foreign Keys | ||
| fk_AllowanceDeduction_AllowanceDeduction | (allowanceDeductionID) → AllowanceDeduction | |
| fk_AllowanceDeduction_SpecialAllowanceDeduction | (allowanceDeductionID) → SpecialAllowanceDeduction | |
| Idx | Field Name | Data Type |
|---|---|---|
| attendanceID | int IDENTITY (1, 1) | |
| employeeID | int | |
| locationID | int | |
| loginTime | datetimeoffset(7) | |
| attendanceDate | date | |
| logoutTime | datetimeoffset(7) | |
| totalHours | decimal(18,2) | |
| loginStatus | varchar(20) | |
| Indexes | ||
| pk_Attendance | ON attendanceID | |
| unq_Attendance_employeeID | ON employeeID | |
| unq_Attendance_locationID | ON locationID | |
| Referring Foreign Keys | ||
| fk_BasicInfo_Attendance | (employeeID) ← BasicInfo | |
| fk_Location_Attendance | (locationID) ← Location | |
| Idx | Field Name | Data Type |
|---|---|---|
| templateID | int IDENTITY (1, 1) | |
| templateName | varchar(100) | |
| leaveWageAllowed | varchar(20) | |
| pfAllowed | varchar(20) | |
| otAllowed | varchar(20) | |
| esiAllowed | varchar(20) | |
| basic | money | |
| da | money | |
| sAAndOthers | money | |
| basicDAAmountPerDay | money | |
| calculateAllowanceDeductionFromBasic | varchar(20) | |
| calculateAllowanceDeductionFromBasicDA | varchar(20) | |
| calculateAllowanceDeductionFromBasicDASA | varchar(20) | |
| Indexes | ||
| pk_BasicInfo | ON templateID | |
| Foreign Keys | ||
| fk_BasicInfo_AllowanceDeduction | (templateID) → AllowanceDeduction | |
| fk_BasicInfo_SpecialAllowanceDeduction | (templateID) → SpecialAllowanceDeduction | |
| Idx | Field Name | Data Type |
|---|---|---|
| employeeID | int IDENTITY (1, 1) | |
| employeeName | varchar(100) | |
| contactNumber | varchar(20) | |
| employeeCode | varchar(20) | |
| address | varchar(200) | |
| OTHERINFO | varchar(400) | |
| shiftID | int | |
| Indexes | ||
| pk_BasicInfo | ON employeeID | |
| unq_BasicInfo_shiftID | ON shiftID | |
| Foreign Keys | ||
| fk_BasicInfo_Attendance | (employeeID) → Attendance | |
| fk_BasicInfo_Holiday | (employeeID) → Holiday | |
| fk_BasicInfo_Leave | (employeeID) → Leave | |
| fk_BasicInfo_AllottedLeaves | (employeeID) → AllottedLeaves | |
| fk_BasicInfo_SalaryAdvance | (employeeID) → SalaryAdvance | |
| fk_BasicInfo_SalaryAdvanceRepayment | (employeeID) → SalaryAdvanceRepayment | |
| fk_BasicInfo_Finalized | (employeeID) → Finalized | |
| fk_BasicInfo_Settings | (employeeID) → Settings | |
| Referring Foreign Keys | ||
| fk_Shift_BasicInfo | (shiftID) ← Shift | |
| Idx | Field Name | Data Type |
|---|---|---|
| designationID | int IDENTITY (1, 1) | |
| designationName | varchar(50) | |
| designationStatus | varchar(20) | |
| Indexes | ||
| pk_Designation | ON designationID | |
| Idx | Field Name | Data Type |
|---|---|---|
| salaryFinalizedID | int IDENTITY (1, 1) | |
| employeeID | int | |
| basicPay | money | |
| grossAllowance | money | |
| grossDeductions | money | |
| lop | money | |
| netPaid | money | |
| month | int | |
| year | int | |
| createDate | datetimeoffset(7) | |
| userID | int | |
| da | money | |
| sa | money | |
| overTime | money | |
| grossPayable | money | |
| totalAttendance | decimal(18,2) | |
| Indexes | ||
| pk_Finalized | ON salaryFinalizedID | |
| unq_Finalized_employeeID | ON employeeID | |
| Referring Foreign Keys | ||
| fk_BasicInfo_Finalized | (employeeID) ← BasicInfo | |
| Idx | Field Name | Data Type |
|---|---|---|
| generatedSalaryID | int IDENTITY (1, 1) | |
| year | int | |
| month | int | |
| salaryDataJSON | nvarchar(max) | |
| createdUserID | int | |
| createdDateTime | datetimeoffset(7) | |
| Indexes | ||
| pk_Generated | ON generatedSalaryID | |
| Idx | Field Name | Data Type |
|---|---|---|
| holidayCalendarID | int IDENTITY (1, 1) | |
| holidayName | varchar(100) | |
| holidayDate | date | |
| locationID | int | |
| Indexes | ||
| pk_Holiday | ON holidayCalendarID | |
| unq_Holiday_locationID | ON locationID | |
| Referring Foreign Keys | ||
| fk_Location_Holiday | (locationID) ← Location | |
| Idx | Field Name | Data Type |
|---|---|---|
| employeeHolidayID | int IDENTITY (1, 1) | |
| employeeID | int | |
| holidayName | varchar(200) | |
| holidayDate | date | |
| holidayStatus | varchar(20) | |
| Indexes | ||
| pk_Holiday | ON employeeHolidayID | |
| unq_Holiday_employeeID | ON employeeID | |
| Referring Foreign Keys | ||
| fk_BasicInfo_Holiday | (employeeID) ← BasicInfo | |
| Idx | Field Name | Data Type |
|---|---|---|
| employeeLeaveID | int IDENTITY (1, 1) | |
| employeeID | int | |
| leaveFrom | datetimeoffset(7) | |
| leaveTo | datetimeoffset(7) | |
| reason | varchar(200) | |
| leaveStatus | varchar(20) | |
| leaveApproveUserID | int | |
| leaveApprovedDate | datetimeoffset(7) | |
| userID | int | |
| createdDateime | datetimeoffset(7) | |
| rejectedReason | varchar(200) | |
| leaveMode | varchar(30) | |
| numberOfLeaves | decimal(18,2) | |
| Indexes | ||
| pk_Leave | ON employeeLeaveID | |
| unq_Leave_employeeID | ON employeeID | |
| Foreign Keys | ||
| fk_Leave_LeaveDetail | (employeeLeaveID) → LeaveDetail | |
| Referring Foreign Keys | ||
| fk_BasicInfo_Leave | (employeeID) ← BasicInfo | |
| Idx | Field Name | Data Type |
|---|---|---|
| leaveTypeID | int IDENTITY (1, 1) | |
| leaveTypeName | varchar(50) | |
| leaveTypeStatus | varchar(20) | |
| Indexes | ||
| pk_Leave | ON leaveTypeID | |
| Foreign Keys | ||
| fk_Leave_AllottedLeaves | (leaveTypeID) → AllottedLeaves | |
| Idx | Field Name | Data Type |
|---|---|---|
| employeeLeaveDetailID | int IDENTITY (1, 1) | |
| employeeLeaveID | int | |
| leaveDate | date | |
| approveStatus | varchar(20) | |
| createdUserID | int | |
| createdDateTime | datetimeoffset(7) | |
| leaveMode | varchar(20) | |
| leave | decimal(18,2) | |
| Indexes | ||
| pk_LeaveDetail | ON employeeLeaveDetailID | |
| unq_LeaveDetail_employeeLeaveID | ON employeeLeaveID | |
| Referring Foreign Keys | ||
| fk_Leave_LeaveDetail | (employeeLeaveID) ← Leave | |
| Idx | Field Name | Data Type |
|---|---|---|
| locationID | int IDENTITY (1, 1) | |
| locationName | varchar(50) | |
| country | varchar(100) | |
| Indexes | ||
| pk_Location | ON locationID | |
| Foreign Keys | ||
| fk_Location_Shift | (locationID) → Shift | |
| fk_Location_Holiday | (locationID) → Holiday | |
| fk_Location_Attendance | (locationID) → Attendance | |
| Idx | Field Name | Data Type |
|---|---|---|
| salaryAdvanceID | int IDENTITY (1, 1) | |
| employeeID | int | |
| paymentDate | datetimeoffset(7) | |
| advanceAmount | money | |
| createdUserID | int | |
| createdDate | datetimeoffset(7) | |
| outstandingAmount | money | |
| salaryAdvanceStatus | varchar(20) | |
| repaymentCompletedDate | datetimeoffset(7) | |
| repayinMonths | int | |
| perMonthAmount | money | |
| Indexes | ||
| pk_SalaryAdvance | ON salaryAdvanceID | |
| unq_SalaryAdvance_employeeID | ON employeeID | |
| Foreign Keys | ||
| fk_SalaryAdvance_SalaryAdvanceRepayment | (salaryAdvanceID) → SalaryAdvanceRepayment | |
| Referring Foreign Keys | ||
| fk_BasicInfo_SalaryAdvance | (employeeID) ← BasicInfo | |
| Idx | Field Name | Data Type |
|---|---|---|
| salaryAdvanceRepaymentID | int IDENTITY (1, 1) | |
| salaryAdvanceID | int | |
| employeeID | int | |
| month | int | |
| year | int | |
| repaymentAmount | money | |
| createdUserID | int | |
| createdDate | datetimeoffset(7) | |
| Indexes | ||
| pk_SalaryAdvanceRepayment | ON salaryAdvanceRepaymentID | |
| unq_SalaryAdvanceRepayment_employeeID | ON employeeID | |
| unq_SalaryAdvanceRepayment_salaryAdvanceID | ON salaryAdvanceID | |
| Referring Foreign Keys | ||
| fk_BasicInfo_SalaryAdvanceRepayment | (employeeID) ← BasicInfo | |
| fk_SalaryAdvance_SalaryAdvanceRepayment | (salaryAdvanceID) ← SalaryAdvance | |
| Idx | Field Name | Data Type |
|---|---|---|
| salarySettingsID | int IDENTITY (1, 1) | |
| basicSalary | money | |
| da | money | |
| overtimeAllowed | varchar(20) | |
| holidayWageAllowed | varchar(20) | |
| esiAllowed | varchar(20) | |
| calculateAllowanceDeductionFromBasic | varchar(20) | |
| calculateAllowanceDeductionFromBasicDA | varchar(20) | |
| employeeID | int | |
| remarks | varchar(500) | |
| offType | varchar | |
| calculateAllowanceDeductionFromBasicDASA | varchar(20) | |
| basicDAAmountPerDay | varchar(20) | |
| pfAllowed | varchar(20) | |
| Indexes | ||
| pk_Settings | ON salarySettingsID | |
| unq_Settings_employeeID | ON employeeID | |
| Referring Foreign Keys | ||
| fk_BasicInfo_Settings | (employeeID) ← BasicInfo | |
| Idx | Field Name | Data Type |
|---|---|---|
| shiftID | int IDENTITY (1, 1) | |
| shiftCode | varchar(20) | |
| shiftStartTime | time(7) | |
| shiftEndTime | time(7) | |
| shiftHours | int | |
| locationID | int | |
| Indexes | ||
| pk_Shift | ON shiftID | |
| unq_Shift_locationID | ON locationID | |
| Foreign Keys | ||
| fk_Shift_BasicInfo | (shiftID) → BasicInfo | |
| Referring Foreign Keys | ||
| fk_Location_Shift | (locationID) ← Location | |
| Idx | Field Name | Data Type |
|---|---|---|
| specialAllowanceDeductionID | int IDENTITY (1, 1) | |
| templateID | int | |
| allowanceOrDeduction | varchar(20) | |
| amountOrPercentage | varchar(20) | |
| amountPercentageValue | decimal(18,2) | |
| month | int | |
| year | int | |
| recurring | varchar(10) | |
| considerInESI | varchar(10) | |
| allowanceDeductionID | int | |
| Indexes | ||
| pk_SpeicalAllowanceDeduction | ON specialAllowanceDeductionID | |
| unq_SpecialAllowanceDeduction_templateID | ON templateID | |
| unq_SpecialAllowanceDeduction_allowanceDeductionID | ON allowanceDeductionID | |
| Referring Foreign Keys | ||
| fk_BasicInfo_SpecialAllowanceDeduction | (templateID) ← BasicInfo | |
| fk_AllowanceDeduction_SpecialAllowanceDeduction | (allowanceDeductionID) ← AllowanceDeduction | |