SIT of 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)