Core Database Tables Reference
Entity Relationship Diagram
Table Interaction Map
| Table | Written By | Read By |
|---|---|---|
t_HR_BiometricAttendanceDetail | ImportAttendanceBO | AttendanceProcessingBO |
t_HR_MobileAttendance | Mobile App API | AttendanceProcessingBO, MobileAttendanceProcessing |
t_HR_EmpDailyAttendance | AttendanceProcessingBO | SalaryCalculationBO, Reports |
t_HR_CreditTracking | AttendanceProcessingBO | Reports, HR Dashboard |
t_HR_PermissionUtilized | AttendanceProcessingBO | AttendanceProcessingBO (monthly count) |
t_HR_MonthlySalary | SalaryCalculationBO | Payslip generation, Reports |
t_HR_LeaveForm | Employee portal / HR | AttendanceProcessingBO |
t_HR_LoansAndAdvances | HR portal | SalaryCalculationBO (fnGetLoanDeductionList) |
t_HR_Employee_Fine | HR portal | SalaryCalculationBO |
t_HR_LateFinePolicy | HR portal | PenaltyCalculationBO |
t_HR_CompanyHolidays | HR portal | AttendanceProcessingBO |
vw_HR_WeekOff | System view | AttendanceProcessingBO |