HRIS
Tables (43)
ATTENDANCE (TB_ATTENDANCE)
- ATTENDANCE MANAGE ID (ATTENDANCE_ID) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- SALARY MANAGE ID (SALARY_ID) — VARCHAR(500) — Foreign key → BASIC SALARY.SALARY MANAGE ID — NOT NULL
- DATE — DATE
- SCHEDULED IN (EXPECTED_DATE_TIME_IN) — TIME
- SCHEDULED OUT (EXPECTED_DATE_TIME_OUT) — TIME
- CLOCK IN (CLOCK_DATE_TIME_IN) — DATETIME
- CLOCK OUT (CLOCK_DATE_TIME_OUT) — DATETIME
- LATE MINUTES (LATE_MINUTES) — INT
- LATE PENALTY AMOUNT (LATE_PENALTY_AMOUNT) — DECIMAL(15,2)
- UNDERTIME MINUTES (UNDERTIME_MINUTES) — INT
- UNDERTIME PENALTY AMOUNT (UNDERTIME_PENALTY_AMOUNT) — DECIMAL(15,2)
- (IS_SYS) — CHAR(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
ATTENDANCE AMMENDMENT (TB_ATTENDANCE_AMMENDMENT)
- ATTENDANCE AMENDMENT MANAGE ID (ATTENDANCE_AMENDMENT_ID) — VARCHAR(500) — Primary key — NOT NULL
- ATTENDANCE MANAGE ID (ATTENDANCE_ID) — VARCHAR(500) — Foreign key → ATTENDANCE.ATTENDANCE MANAGE ID — NOT NULL
- DATE (CLOCK_DATE_TIME_IN) — DATETIME(6)
- ORIGINAL CLOCK IN TIME (CLOCK_DATE_TIME_OUT) — DATETIME(6)
- AMENDED CLOCK IN TIME (AMENDMENT_DATE_TIME_IN) — DATETIME(6)
- AMENDED CLOCK OUT TIME (AMENDMENT_DATE_TIME_OUT) — DATETIME(6)
- REASON — TEXT
- STATUS — VARCHAR(20)
- APPROVED BY (APPROVED_BY) — VARCHAR(500)
- APPROVED DATE (APPROVED_DATE) — DATETIME(6)
- CREATED BY (CREATED_DATE) — VARCHAR(500)
- CREATED DT (CREATED_DT) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DT (UPDATED_DATE) — DATETIME(6)
BASIC SALARY (TB_SALARY)
- SALARY MANAGE ID (SALARY_ID) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- AMOUNT — DECIMAL(15,2)
- SALARY TYPE (SALARY_TYPE) — VARCHAR(20)
- EFFECTIVE DATE (EFFECTIVE_DATE) — DATE
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
BRANCH (TB_BR)
- BRANCH MANAGE ID (BR_MNG_ID) — VARCHAR(500) — Primary key — NOT NULL
- COMPANY MANAGE ID (CO_MNG_ID) — VARCHAR(500) — Foreign key → COMPANY.COMPANY MANAGE ID — NOT NULL
- KEY (COUNTRY_MNG_ID) — VARCHAR(500) — Foreign key → COUNTRY.COUNTRY ID — NOT NULL
- BRANCH NAME (NM) — VARCHAR(100)
- ADDRESS (ADDR) — VARCHAR(255)
- TELEPHONE NUMBER (TELNO) — VARCHAR(20)
- STATUS (STAT) — VARCHAR(100)
- SOFT DELETE FLAG (DEL_YN) — CHAR(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DT) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DT) — DATETIME(6)
- DELETED BY (DELETED_BY) — VARCHAR(500)
- DELETED DATE (DELETED_DT) — DATETIME(6)
BRANCH PAYROLL SETTINGS (TB_BR_PAY_SET)
- BRANCH PAYROLL SETTING MANAGE ID (BR_PAY_SET_MNG_ID) — VARCHAR(500) — Primary key — NOT NULL
- BRANCH MANAGE ID (BR_MNG_ID) — VARCHAR(500) — Foreign key → BRANCH.BRANCH MANAGE ID — NOT NULL
- FREQUENCY (FREQ)
- TAX CUTOFF FLAG (TAX_CUTOFF_YN) — CHAR(1)
- FIELD (MONTHLY_LATEST_YN)
- FIELD (MONTHLY_DEDUCT_SPECIAL_HOLIDAY_REST_YN)
- FIELD (MONTHLY_DEDUCT_SPECIAL_HOLIDAY_NON_REST_YN)
- FIELD (MONTHLY_PAY_REGULAR_HOLIDAY_REST_YN)
- FIELD (DAILY_PAY_REGULAR_HOLIDAY_REST_YN)
- FIELD (CURRENCY)
COMPANY (TB_CO)
- COMPANY MANAGE ID (CO_MNG_ID) — VARCHAR(500) — Primary key — NOT NULL
- KEY (COUNTRY_MNG_ID) — VARCHAR(500) — Foreign key → COUNTRY.COUNTRY ID — NOT NULL
- COMPANY NAME (NM) — VARCHAR(100) — NOT NULL
- ADDRESS (ADDR) — VARCHAR(255)
- TELEPHONE NUMBER (TELNO) — VARCHAR(20)
- EMAIL (EML_ADDR) — VARCHAR(100)
- STATUS (STAT) — VARCHAR(100)
- SOFT DELETE FLAG (DEL_YN) — CHAR(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DT) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DT) — DATETIME(6)
- DELETED BY (DELETED_BY) — VARCHAR(500)
- DELETED DATE (DELETED_DT) — DATETIME(6)
COUNTRY (TB_COUNTRY)
- COUNTRY ID (COUNTRY_ID) — VARCHAR(500) — Primary key — NOT NULL
- COUNTRY NAME (NAME) — VARCHAR(100)
- COUNTRY CURRENCY (CURRENCY)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
Copy Of Copy Of MANDATORY BENEFITS (TB_EMP_GOV_CONTRIB)
- MANDATORY BENEFITS MANAGE ID (EMP_GOV_CONTRIB) — Primary key — NOT NULL
- SSS NUMBER (EMP_MNG_ID) — VARCHAR(20)
- SSS TYPE FLAG (GOV_CONTRIB_TYPE_MNG_ID) — CHAR(1)
- SSS FIXED AMOUNT (ID_NO) — DECIMAL
- PAGIBIG TYPE FLAG (OVERRIDE_AMT) — CHAR(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DT) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DT) — DATETIME(6)
Copy Of HOLIDAY (TB_HOLIDAY_TYPE)
- HOLIDAY MANAGE ID (HOLIDAY_TYPE_ID) — VARCHAR(500) — Primary key — NOT NULL
- HOLIDAY NAME (NAME) — VARCHAR(100)
- RATE — VARCHAR(100)
- IS DELETE (IS_DELETED) — TINYINT(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
DEDUCTION TYPE (TB_DEDUCTION)
- DEDUCTION TYPE MANAGE ID (DEDUCTION_ID) — VARCHAR(500) — Primary key — NOT NULL
- BRANCH MANAGE ID (BRANCH_ID) — VARCHAR(500) — Foreign key → BRANCH.BRANCH MANAGE ID — NOT NULL
- DEDUCTION TYPE NAME (NAME) — VARCHAR(100)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
DEDUCTION_RATES (TB_RATES)
- RATES ID (RATES_ID) — Primary key — NOT NULL
- MANDATORY BENEFITS MANAGE ID (MANDATORY_DEDUCTION_ID) — Foreign key → TB_MANDATORY_DEDUCTION_RATE.MANDATORY BENEFITS MANAGE ID — NOT NULL
- DEDUCTION CODE (DEDUCTION_CODE)
- SALARY MINIMUM (SALARY_MINIMUM) — DECIMAL(15,2)
- SALARAY MAXIMUM (SALARY_MAX) — DECIMAL(15,2)
- EMPLOYEE BASE (EMPLOYEE_BASE)
- EMPLOYER BASE (EMPLOYER_BASE)
- EMPLOYEE PERCENTAGE (EMPLOYEE_PERCENTAGE)
- PERCENTAGE (EMPLOYER_PERCENTAGE) — DECIMAL(10,6)
- EMPLOYEE SHARE (EMPLOYEE_SHARE) — DECIMAL(15,2)
- EMPLOYER SHARE (EMPLOYER_SHARE) — DECIMAL(15,2)
- EFFECTIVE DATE (EFFECTIVE_DATE) — DATE — NOT NULL
- UPDATED AT (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
DEPARTMENT (TB_DEPARTMENT)
- DEPARTMENT MANAGE ID (DEPARTMENT_ID) — VARCHAR(500) — Primary key — NOT NULL
- BRANCH MANAGE ID (BRANCH_ID) — VARCHAR(500) — Foreign key → BRANCH.BRANCH MANAGE ID — NOT NULL
- DEPARTMENT NAME (NAME) — VARCHAR(100)
- ADDRESS — VARCHAR(255)
- TELEPHONE NUMBER (TELEPHONE_NUMBER) — VARCHAR(20)
- SOFT DELETE FLAG (IS_DELETED) — TINYINT(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
- DELETED BY (DELETED_BY) — VARCHAR(500)
- DELETED DATE (DELETED_DATE) — DATETIME(6)
DESIGNATION (TB_DESIGNATION)
- DESIGNATION MANAGE ID (DESIGNATION_ID) — VARCHAR(500) — Primary key — NOT NULL
- DEPARTMENT MANAGE ID (DEPARTMENT_ID) — VARCHAR(500) — Foreign key → DEPARTMENT.DEPARTMENT MANAGE ID — NOT NULL
- SUB DEPARTMENT MANAGE ID (SUB_DEPARTMENT_ID) — VARCHAR(500) — Foreign key → SUB DEPARTMENT.SUB DEPARTMENT MANAGE ID — NOT NULL
- DESIGNATION NAME (NAME) — VARCHAR(100)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
EARNING (TB_EARN)
- EARNING MANAGE ID (EARNING_ID) — VARCHAR(500) — Primary key — NOT NULL
- BRANCH MANAGE ID (BRANCH_ID) — VARCHAR(500) — Foreign key → BRANCH.BRANCH MANAGE ID — NOT NULL
- TYPE
- NAME — VARCHAR(100)
- MONTHLY THRESHOLD (MONTHLY_THRESHOLD) — DECIMAL
- YEARLY THRESHOLD (YEARLY_THRESHOLD) — DECIMAL
- TAXABLE FLAG (IS_TAXABLE) — CHAR(1)
- OCCASIONAL FLAG (IS_BONUS) — CHAR(1) — AUTOMATIC TYPE WILL BE BONUS IF OCC_YN IS Y OCCASIONAKL
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATE DATE (UPDATED_DATE) — DATETIME(6)
EARNING CONDITION (TB_EARN_CONDITION)
- EARNING CONDITION MANAGE ID (EARNING_CONDITION_ID) — VARCHAR(500) — Primary key — NOT NULL
- EARNING MANAGE ID (EARNING_ID) — VARCHAR(500) — Foreign key → EARNING.EARNING MANAGE ID — NOT NULL
- START DAY (START_DAY)
- START OFFSET MONTH (START_OFFSET_MONTH)
- END DAY (END_DAY)
- END OFFSET MONTH (END_OFFSET_MONTH)
- MAX ABSENT COUNT (MAX_ABSENT_COUNT) — TINYINT
- MAX LATE COUNT (MAX_LATE_COUNT) — MEDIUMINT
- MAX UNDERTIME COUNT (MAX_UNDERTIME_COUNT) — MEDIUMINT
- ACTIVE FLAG (IS_ACTIVE) — TINYINT(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATE DATE (UPDATED_DATE) — DATETIME(6)
EMPLOYEE (TB_EMPLOYEE)
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Primary key — NOT NULL
- COMPANY MANAGE ID (COMPANY_ID) — VARCHAR(500) — Foreign key → COMPANY.COMPANY MANAGE ID — NOT NULL
- BRANCH MANAGE ID (BRANCH_ID) — VARCHAR(500) — Foreign key → BRANCH.BRANCH MANAGE ID — NOT NULL
- DEPARTMENT MANAGE ID (DEPARTMENT_ID) — VARCHAR(500) — Foreign key → DEPARTMENT.DEPARTMENT MANAGE ID — NOT NULL
- SUB DEPARTMENT MANAGE ID (SUB_DEPARTMENT_ID) — VARCHAR(500) — Foreign key → SUB DEPARTMENT.SUB DEPARTMENT MANAGE ID — NOT NULL
- DESIGNATION MANAGE ID (DESIGNATION_ID) — VARCHAR(500) — Foreign key → DESIGNATION.DESIGNATION MANAGE ID — NOT NULL
- EMPLOYEE NUMBER (EMPLOYEE_NUMBER) — VARCHAR(500)
- START DATE (START_DATE) — DATE
- END DATE (END_DATE) — DATE
- REGULARIZATION DATE (REGULAR_DATE) — DATE
- STATUS — VARCHAR(20)
- EMPLOYMENT TYPE (EMPLOYEE_TYPE) — VARCHAR(20)
- FIELD (IS_GRANTED) — TINYINT
- SOFT DELETE FLAG (IS_DELETED) — CHAR(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
- DELETED BY (DELETED_BY) — VARCHAR(500)
- DELETED DATE (DELETED_DATE) — DATETIME(6)
EMPLOYEE ABSENT (TB_EMPLOYEE_ABSENT)
- ATTENDANCE MANAGE ID (EMPLOYEE_ABSENT_ID) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- COMPANY SHIFT MANAGE ID (SHIFT_ID) — VARCHAR(500) — Foreign key → SHIFTS.SHIFT MANAGE ID — NOT NULL
- COMPANY SHIFT MANAGE ID (SHIFT_CHANGE_ID) — VARCHAR(500) — Foreign key → SHIFT CHANGE.COMPANY SHIFT MANAGE ID — NOT NULL
- DATE (ABSENT_DATE) — DATE
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
EMPLOYEE BANK ACNT (TB_EMPLOYEE_BANK_ACCOUNT)
- EMPLOYEE BANK ACCOUNT MANAGE ID (EMPLOYEE_BANK_ACCOUNT_ID) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- BANK NAME (BANK_NUMBER) — VARCHAR(100)
- ACCOUNT NUMBER (ACCOUNT_NUMBER) — VARCHAR(100)
- ACCOUNT NAME (ACCOUNT_NAME) — VARCHAR(100)
- PRIMARY BANK ACCOUNT FLAG (IS_PRIMARY) — TINYINT(1)
- SOFT DELETE FLAG (IS_DELETED) — TINYINT
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
- FIELD (DELETED_BY) — VARCHAR(500)
- FIELD (DELETED_DATE) — DATETIME(6)
EMPLOYEE DAILY SHIFT (TB_EMPLOYEE_DAY_SHIFT)
- EMPLOYEE DAY SHIFT MANAGEMENT ID (EMPLOYEE_DAY_SHIFT) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- DATE — DATE
- START TIME (START_TIME) — CHAR(5)
- END TIME (END_TIME) — CHAR(5)
- NEXT DAY FLAG (IS_NEXT_DAY) — TINYINT(1)
- FIELD (IS_FLEXIBLE) — TINYINT(1)
- FIELD2 (REGULAR_HOURS) — TINYINT
- FIELD (HAS_LUNCH_BREAK) — TINYINT(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
EMPLOYEE DEDUCTION (TB_EMPLOYEE_DEDUCTION)
- EMPLOYEE DEDUCTION MANAGE ID (EMPLOYEE_DEDUCTION_ID) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- DEDUCTION TYPE MANAGE ID (DEDUCTION_ID) — VARCHAR(500) — Foreign key → DEDUCTION TYPE.DEDUCTION TYPE MANAGE ID — NOT NULL
- CUSTOM AMOUNT (AMOUNT) — DECIMAL(15,2) — Used for Fixed computation type
- FIELD (TYPE) — VARCHAR(20)
- FIELD (CUTOFF_PERIOD) — TINYINT
- EFFECTIVE DATE (EFFECTIVE_DATE) — DATE
- SOFT DELETE FLAG (IS_DELETED) — TINYINT(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
- DELETED BY (DELETED_BY) — VARHAR(500)
- DELETED DATE (DELETED_DATE) — DATETIME(6)
EMPLOYEE EARNINGS (TB_EMPLOYEE_EARNING)
- EMPLOYEE EARNING MANAGE ID (EMPOYEE_EARNING_ID) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- EARNING MANAGE ID (EARNING_ID) — VARCHAR(500) — Foreign key → EARNING.EARNING MANAGE ID — NOT NULL
- AMOUNT — DECIMAL(15,2) — MONTH = GIVEN AS WHOLE DAILY, HOURLY = MULTIPLIED BY DAILY ATTENDANCE
- TYPE — VARCHAR(20)
- CUTOFF PERIOD (CUTOFF_PERIOD) — TINYINT — IF EMPTY, THEN PAID ON BOTH CUTOFFS, WHEN FREQUENCY OF COMPANY IS SEMI MONTLYH IF NOT, THEN PAID ON SELECTED CUTOFF (FI…
- EFFECTIVE DATE (EFFECTIVE_DATE) — DATE
- SOFT DELETE FLAG (IS_DELETED) — TINYINT(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
- DELETED BY (DELETED_BY) — VARCHAR(500)
- DELETED DATE (DELETED_DATE) — DATETIME(6)
EMPLOYEE EMERGENCY CONTACTS (TB_EMPLOYEE_EMERGENCY_CONTACT)
- EMPLOYEE EMERGENCY CONTACT MANAGE ID (EMPLOYEE_EMERGENCY_CONTACT_ID) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- EMERGENCY CONTACT NAME (NAME) — VARCHAR(100)
- EMERGENCY CONTACT RELATIONSHIP (RELATIONSHIP) — VARCHAR(100)
- PRIMARY CONTACT NUMBER (PRIMARY_CONTACT_NUMBER) — VARCHAR(20)
- SECONDARY CONTACT NUMBER (SECONDARY_CONTACT_NUMBER) — VARCHAR(20)
- PRIMARY EMERGENCY CONTACT FLAG (IS_PRIMARY) — BOOLEAN
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
EMPLOYEE LEAVE BALANCE (TB_EMPLOYEE_LEAVE_HISTORY)
- EMPLOYEE LEAVE BALANCE MANAGE ID (EMPLOYEE_LEAVE_HISTORY_ID) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE LEAVE BALANCE ID (EMPLOYEE_LEAVE_BALANCE_ID) — VARCHAR(500) — Foreign key → Untitled.Key — NOT NULL
- YEAR (PREVIOUS_BALANCE) — INT
- USED DAYS (USED_DAYS) — INT
- TOTAL DAYS (NEW_BALANCE) — DECIMAL(5,2)
- IS INCOMPLETE (IS_INCOMPLETE) — TINYINT(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
EMPLOYEE LEAVE REQUEST (TB_EMPLOYEE_LEAVE)
- EMPLOYEE LEAVE MANAGE ID (EMPLOYEE_LEAVE_ID) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- EMPLOYEE LEAVE BALANCE ID (EMPLOYEE_LEAVE_BALANCE_ID) — VARCHAR(500) — Foreign key → Untitled.Key — NOT NULL
- START DATE (START_DATE) — DATE
- END DATE (END_DATE) — DATE
- TOTAL DAYS (TOTAL_DAYS) — DECIMAL(5,2)
- REASON — TEXT
- STATUS — VARCHAR(20)
- SOFT DELETE FLAG (IS_DELETED) — TINYINT(1)
- APPROVED BY (APPROVED_BY) — VARCHAR(500)
- APPROVED DATE (APPROVED_DATE) — DATETIME(6)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
HOLIDAY (TB_HLDY)
- HOLIDAY MANAGE ID (HOLIDAY_ID) — VARCHAR(500) — Primary key — NOT NULL
- COMPANY MANAGE ID (COMPANY_ID) — VARCHAR(500) — Foreign key → COMPANY.COMPANY MANAGE ID — NOT NULL
- BRANCH MANAGE ID (BRANCH_ID) — VARCHAR(500) — Foreign key → BRANCH.BRANCH MANAGE ID — NOT NULL
- HOLIDAY MANAGE ID (HOLIDAY_TYPE_ID) — VARCHAR(500) — Foreign key → Copy Of HOLIDAY.HOLIDAY MANAGE ID — NOT NULL
- HOLIDAY NAME (HOLIDAY_NAME) — VARCHAR(100)
- HOLIDAY DATE (HOLIDAY_DATE) — DATE
- HOLIDAY TYPE (HOLIDAY_TYPE) — VARCHAR(30)
- ACTIVE FLAG (IS_ACTIVE) — TINYINT(1)
- SOFT DELETE FLAG (IS_DELETED) — TINYINT(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
- DELETED BY (DELETED_BY) — VARCHAR(500)
- DELETED DATE (DELETED_DATE) — DATETIME(6)
LEAVE TYPE (TB_LEAVE_TYPE)
- LEAVE TYPE MANAGE ID (LEAVE_TYPE_ID) — VARCHAR(500) — Primary key — NOT NULL
- BRANCH MANAGE ID (BRANCH_ID) — VARCHAR(500) — Foreign key → BRANCH.BRANCH MANAGE ID — NOT NULL
- LEAVE NAME (LEAVE_NAME) — VARCHAR(100)
- DESCRIPTION — VARCHAR(255)
- DEFAULT DAYS (DEFAULT_DAYS) — DECIMAL(5,2)
- FIELD (LAW_YN) — TINYINT(1)
- SOFT DELETE FLAG (IS_DELETED) — TINYINT(1)
- SEX — TINYINT(1)
- FIELD (IS_SINGLE) — TINYINT(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
OVERTIME REQUEST (TB_EMPLOYEE_OVERTIME)
- OVERTIME REQUEST MANAGE ID (EMPLOYEE_OVERTIME_ID) — VARCHAR(500) — Primary key — NOT NULL
- KEY (ATTENDANCE_DETAIL_ID) — VARCHAR(500) — Foreign key → Untitled.KEY — NOT NULL
- START TIME (START_DATE_TIME) — DATETIME
- END TIME (END_DATE_TIME) — TIME
- FIELD (REQUIRMENT_MINUTES) — INT
- REQUESTED HOURS (OVERTIME_MINUTES) — INT — For overnight OTs
- FIELD (OVERTIME_AMOUNT) — DECIMAL(15,2)
- FIELD (HOLIDAY_PAY_AMOUNT) — DECIMAL(15,2)
- FIELD (REST_DAY_PAY_AMOUNT) — DECIMAL(15,2)
- REASON — TEXT
- STATUS — VARCHAR(20)
- APPROVED HOURS (APPROVE_MINUTES) — DECIMAL(5,2)
- APPROVED BY (SUPER_VISOR_APPROVED_BY) — VARCHAR(500)
- APPROVED DATE (SUPER_VISOR_APPROVED_DATE) — DATETIME(6)
- FIELD (HUMAN_RESOURCE_APPROVED_BY) — VARCHAR(500)
- FIELD (HUMAN_RESOURCE_APPROVED_DATE) — DATETIME(6)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
PENDING (TB_EMPLOYEE_EARN_PENDING)
- EMPLOYEE PENDING (EMPLOYEE_EARNING_PENDING_ID) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE INCENTIVE MANAGE ID (EMPLOYEE_EARNING_ID) — VARCHAR(500) — Foreign key → EMPLOYEE EARNINGS.EMPLOYEE EARNING MANAGE ID — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- ATTENDANCE DETAIL ID (ATTENDANCE_DETAIL_ID) — VARCHAR(500) — Foreign key → Untitled.KEY — NOT NULL
- AMOUNT — DECIMAL(15,2)
- DATE — DATE
- CUTOFF PERIOD (CUTOFF_PERIOD) — TINYINT
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATE(6)
- UPDATED BY (UPDATED _BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATE(6)
PENDING DEDUCTION (TB_EMPLOYEE_DEDUCTION_PENDING)
- PENDING DEDUCTION (EMPLOYEE_PENDING_DEDUCT_ID) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE DEDUCTION MANAGE ID (EMPLOYEE_DEDUCTION_ID) — VARCHAR(500) — Foreign key → EMPLOYEE DEDUCTION.EMPLOYEE DEDUCTION MANAGE ID — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- ATTENDANCE DETAIL ID (ATTENDANCE_DETAIL_ID) — VARCHAR(500) — Foreign key → Untitled.KEY — NOT NULL
- AMOUNT — DECIMAL(15,2)
- DATE — DATE
- CUTOFF PERIOD (CUTOFF_PERIOD) — TINYINT
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED _BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
ROLE (TB_ROLE)
- ROLE MANAGE ID (ROLE_ID) — VARCHAR(500) — Primary key — NOT NULL
- COMPANY MANAGE ID (COMPANY_ID) — VARCHAR(500) — Foreign key → COMPANY.COMPANY MANAGE ID — NOT NULL
- ROLE NAME (NAME) — VARCHAR(100)
- DESCRIPTION — TEXT
- PERMISSIONS (PERMISSION) — LONGTEXT
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
SHIFT CHANGE (TB_SHIFT_CHANGE)
- COMPANY SHIFT MANAGE ID (SHIFT_CHANGE_ID) — VARCHAR(500) — Primary key — NOT NULL
- COMPANY SHIFT MANAGE ID (SHIFT_ID) — VARCHAR(500) — Foreign key → SHIFTS.SHIFT MANAGE ID — NOT NULL
- START TIME (FROM_DATE) — DATE
- END TIME (TO_DATE) — DATE
- START TIME (START_TIME) — CHAR(5)
- END TIME (END_TIME) — CHAR(5)
- IS NEXT DAY (IS_NEXT_DAY) — TINYINT(1)
- IS FLEXIBLE (IS_FLEXIBLE) — TINYINT(1)
- REGULAR HOURS (REGULAR_HOURS) — TINYINT
- HAS LUNCH BREAK (HAS_LUNCH_BREAK) — TINYINT(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
SHIFTS (TB_SHIFT)
- SHIFT MANAGE ID (SHIFT_ID) — VARCHAR(500) — Primary key — NOT NULL
- COMPANY MANAGE ID (COMPANY_ID) — VARCHAR(500) — Foreign key → COMPANY.COMPANY MANAGE ID — NOT NULL
- BRANCH MANAGE ID (BRANCH_ID) — VARCHAR(500) — Foreign key → BRANCH.BRANCH MANAGE ID — NOT NULL
- DEPARTMENT MANAGE ID (DEPARTMENT_ID) — VARCHAR(500) — Foreign key → DEPARTMENT.DEPARTMENT MANAGE ID — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- DAY — TINYINT(1)
- START TIME (START_TIME) — CHAR(5)
- END TIME (END_TIME) — CHAR(5)
- NEXT DAY FLAG (IS_NEXT_DAY) — TINYINT(1)
- FIELD (IS_FLEXIBLE) — TINYINT(1)
- FIELD (REGULAR_HOURS) — TINYINT(1)
- FIELD (HAS_LUNCH_BREAK) — TINYINT(1)
- FIELD (IS_MODIFIED) — TINYINT(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
SUB DEPARTMENT (TB_SUB_DEPARTMENT)
- SUB DEPARTMENT MANAGE ID (SUB_DEPARTMENT_ID) — VARCHAR(500) — Primary key — NOT NULL
- DEPARTMENT MANAGE ID (DEPARTMENT_ID) — VARCHAR(500) — Foreign key → DEPARTMENT.DEPARTMENT MANAGE ID — NOT NULL
- SUB DEPARTMENT NAME (NAME) — VARCHAR(100)
- SOFT DELETE FLAG (IS_DELETED) — TINYINT(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
- DELETED BY (DELETED_BY) — VARCHAR(500)
- DELETED DATE (DELETED_DATE) — DATETIME(6)
TB_MANDATORY_DEDUCTION_RATE (TB_MANDATORY_DEDUCTION)
- MANDATORY BENEFITS MANAGE ID (GOV_CD) — Primary key — NOT NULL
- SSS NUMBER (CONTRY_CD) — VARCHAR(20)
- SSS TYPE FLAG (NAME) — CHAR(1)
- Field (BASE_FORMULA) — USES A COMBINATION OF THESE POSSIBLE VALUES: BASIC, ALLOWANCE, OT, MAN_DDCT, OTHER_DDCT, BONUS, INCENTIVES TO CREATE FO…
- Field (EE_COMP_TYPE)
- Field (ER_COMP_TYPE)
- Field (EE_COMP_FORMULA)
- Field2 (ER_COMP_FORMULA)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DT) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DT) — DATETIME(6)
TB_PAYROLL
- PAY_MNG_ID (PAYMENT_ID) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- YEAR — INT — NOT NULL
- MONTH — INT — NOT NULL
- CUTOFF PERIOD (CUTOFF_PERIOD) — TINYINT — NOT NULL
- PER START DATE (PERIOD_START_DATE) — DATE
- PER END DATE (PERIOD_END_DATE) — DATE
- PAYOUT DATE (PAYOUT_DATE) — DATE
- REGULAR DAYS WORKED (REG_DAYS_WORKED) — DECIMAL(5,2)
- ABSENT DAYS (ABSENT_DAYS) — DECIMAL(5,2)
- LATE MINUTES (LATE_MINUS) — INT
- UNDERTIME MINUTES (UNDERTIME_MINUS) — INT
- REGULAR OT HOURS (REGULAR_OVERTIME_HOURS) — DECIMAL(5,2)
- REST_OT_HRS (REST_OVERTIME_HOURS) — DECIMAL(5,2)
- RS (HOLIDAY_OVERTIME_HOURS) — DECIMAL(5,2)
- ND_DIFF_HRS (NIGHT_DIFFERENTIAL_HOURS) — DECIMAL(5,2)
- TTL_OT_PAY (TOTAL_OVERTIME_PAY) — DECIMAL(15,2)
- TTL_HLDY_PAY (TOTAL_HOLIDAY_PAY) — DECIMAL(15,2)
- TTL_TAXABLE_ALLOWANCE (TOTAL_TAXABLE_ALLOWANCE) — DECIMAL(15,2)
- TTL_NON_TAXABLE_ALLOWANCE (TOTAL_NON_TAXABLE_ALLOWANCE) — DECIMAL(15,2)
- BASIC_PAY_EARNED (BASIC_PAY) — DECIMAL(15,2)
- GROSS_PAY — DECIMAL(15,2)
- ABSENT_DEDUCT_AMT (ABSENT_DEDUCT_AMOUNT) — DECIMAL(15,2)
- LATE_DEDUCT_AMT (LATE_DEDUCT_AMOUNT) — DECIMAL(15,2)
- UNDRTM_DEDUCT_AMT (UNDERTIME_DEDUCT_AMT) — DECIMAL(15,2)
- SSS_EE (SSS_EMPLOYEE) — DECIMAL(15,2)
- SSS_ER (SSS_EMPLOYER) — DECIMAL(15,2)
- SSS_EC — DECIMAL(15,2)
- PHILHEALTH_EE (PHILHEALTH_EMPLOYEE) — DECIMAL(15,2)
- PHILHEALTH_ER (PHILHEALTH_EMPLOYER) — DECIMAL(15,2)
- PAGIBIG_EE (PAGIBIG_EMPLOYEE) — DECIMAL(15,2)
- PAGIBIG_ER (PAGIBIG_EMPLOYER) — DECIMAL(15,2)
- WITHHOLDING_TAX — DECIMAL(15,2)
- TTL_DEDUCT (TOTAL_MAN_DEDUCT) — DECIMAL(15,2)
- TTL_OTHER_DEDUCT (TOTAL_OTHER_DEDUCT) — DECIMAL(15,2)
- FIELD (TOTAL_DEDUCT) — DECIMAL(15,2)
- NET_PAY — DECIMAL(15,2)
- STATUS — VARCHAR(20)
- REMARKS — TEXT
- CREATED_BY — VARCHAR(500)
- CREATED_DT (CREATED_DATE) — DATETIME(6)
- UPDATED_BY — VARCHAR(500)
- UPDATED_DT (UPDATED_DATE) — DATETIME(6)
TB_PAYROLL_BASIC_SPLIT (TB_PAYROLL_DETAIL)
- PAYROLL BASIC SPLIT ID (PAYROLL_BASIC_SPLIT_ID) — VARCHAR(500) — Primary key — NOT NULL
- PAYROLL ID (PAYROLL_ID) — VARCHAR(500) — Foreign key → TB_PAYROLL.PAY_MNG_ID — NOT NULL
- SALARY ID (SALARY_ID) — VARCHAR(500) — Foreign key → BASIC SALARY.SALARY MANAGE ID — NOT NULL
- START DATE (START_DATE) — DATE — NOT NULL
- END DATE (END_DATE) — DATE — NOT NULL
- WORK DAYS (WORK_DAYS) — DECIMAL(5,2) — NOT NULL
- SEGMENT PAY (TOTAL_AMOUNT) — DECIMAL(15,2) — NOT NULL
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
TB_PAYROLL_DDCT_DTL (TB_PAYROLL_DEDUCTION_DETAIL)
- PAY_DDCT_DTL_ID (PAYROLL_DEDUCTION_ID) — VARCHAR(500) — Primary key — NOT NULL
- PAY_MNG_ID (PAYMENT_ID) — VARCHAR(500) — Foreign key → TB_PAYROLL.PAY_MNG_ID — NOT NULL
- DEDUCTION TYPE MANAGE ID (DEDUCTION_ID) — VARCHAR(500) — Foreign key → DEDUCTION TYPE.DEDUCTION TYPE MANAGE ID — NOT NULL
- NAME — VARCHAR(100) — NOT NULL
- AMOUNT — DECIMAL(15,2) — NOT NULL
TB_PAYROLL_INC_DTL (TB_PAYROLL_INCREMENT_DETAIL)
- PAYROLL INCREMENT DETAIL ID (PAYROLL_INCREMENT_DETAIL_ID) — VARCHAR(500) — Primary key — NOT NULL
- PAYMENT ID (PAYMENT_ID) — VARCHAR(500) — Foreign key → TB_PAYROLL.PAY_MNG_ID — NOT NULL
- EARNING MANAGE ID (EARNING_ID) — VARCHAR(500) — Foreign key → EARNING.EARNING MANAGE ID — NOT NULL
- NAME — VARCHAR(100) — NOT NULL
- AMOUNT — DECIMAL(15,2) — NOT NULL
- IS TAXABLE (IS_TAXABLE) — TINYINT(1)
USER (TB_USER)
- USER MANAGE ID (USER_ID) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- ROLE MANAGE ID (ROLE_ID) — VARCHAR(500) — Foreign key → ROLE.ROLE MANAGE ID — NOT NULL
- USERNAME — VARCHAR(100)
- EMAIL ADDRESS (EMAIL_ADDRESS) — VARCHAR(100)
- MOBILE NUMBER (CONTACT_NUMBER) — VARCHAR(20)
- ACTIVE FLAG (IS_ACTIVE) — TINYINT
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
USER INFORMATION (TB_USER_INFORMATION)
- USER INFORMATION MANAGE ID (USER_INFORMATION_ID) — Primary key — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- FIRST NAME (FIRST_NAME) — VARCHAR(100)
- MIDDLE NAME (MIDDLE_NAME) — VARCHAR(100)
- LAST NAME (LAST_NAME) — VARCHAR(100)
- SUFFIX — VARCHAR(10)
- EMAIL ADDRESS (EMAIL_ADDRESS) — VARCHAR(100)
- BIRTH DATE (BIRTH_DATE) — DATE
- GENDER (SEX) — VARCHAR(10)
- CIVIL STATUS (CIVIL_STATUS) — VARCHAR(20)
- NATIONALITY — VARCHAR(20)
- PERMANENT ADDRESS (PERMANENT_ADDRESS) — VARCHAR(100)
- PRESENT ADDRESS (PRESENT_ADDRESS) — VARCHAR(100)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
Untitled (TB_EMPLOYEE_LEAVE_BALANCE)
- Key (EMPLOYEE_LEAVE_BALANCE_ID) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- LEAVE TYPE MANAGE ID (LEAVE_TYPE_ID) — VARCHAR(500) — Foreign key → LEAVE TYPE.LEAVE TYPE MANAGE ID — NOT NULL
- BALANCE — INT
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)
Untitled (TB_ATTENDANCE_DETAIL)
- KEY (ATTENDANCE_DETAIL_ID) — VARCHAR(500) — Primary key — NOT NULL
- ATTENDANCE MANAGE ID (ATTENDANCE_ID) — VARCHAR(500) — Foreign key → ATTENDANCE.ATTENDANCE MANAGE ID — NOT NULL
- HOLIDAY MANAGE ID (HOLIDAY_ID) — VARCHAR(500) — Foreign key → HOLIDAY.HOLIDAY MANAGE ID — NOT NULL
- FIELD (HOLIDAY_PAY_RATE) — DECIMAL(15,2)
- FIELD (START_DATE_TIME) — DATETIME
- FIELD (END_DATE_TIME) — DATETIME
- FIELD (IS_REST_DAY) — TINYINT
- FIELD (CREATED_BY) — VARCHAR(500)
- FIELD (CREATED_DATE) — DATETIME(6)
- FIELD (UPDATED_BY) — VARCHAR(500)
- FIELD (UPDATED_DATE) — DATETIME(6)
WFH REQUEST (TB_WORK_FROM_HOME_REQUEST)
- WFH REQUEST MANAGE ID (WORK_FROM_HOME_REQUEST_ID) — VARCHAR(500) — Primary key — NOT NULL
- EMPLOYEE MANAGE ID (EMPLOYEE_ID) — VARCHAR(500) — Foreign key → EMPLOYEE.EMPLOYEE MANAGE ID — NOT NULL
- DATE — DATE
- REASON — TEXT
- STATUS — VARCHAR(20)
- APPROVED BY (APPROVED_BY) — VARCHAR(500)
- APPROVED DATE (APPROVED_DATE) — DATETIME(6)
- ACTIVE FLAG (IS_ACTIVE) — TINYINT(1)
- SOFT DELETE FLAG (IS_DELETED) — TINYINT(1)
- CREATED BY (CREATED_BY) — VARCHAR(500)
- CREATED DATE (CREATED_DATE) — DATETIME(6)
- UPDATED BY (UPDATED_BY) — VARCHAR(500)
- UPDATED DATE (UPDATED_DATE) — DATETIME(6)