ㅁㅎㅇ

Tables (18)

HRIMASTER

  • EMP_CODE — VARCHAR(20) — Primary key — NOT NULL
  • COMPANY — VARCHAR(3) — Foreign key → ORGDEPTMASTER.COMPANY — NOT NULL
  • EMP_NAME — VARCHAR(30)
  • SOCIAL_NUM — VARCHAR(200)
  • GENDER — CHAR(1)
  • ENTER_DATE — DATE
  • POSITION_CODE — VARCHAR(10)
  • POSITION_DATE — DATE
  • DUTY_CODE — VARCHAR(3)
  • DUTY_DATE — DATE
  • EMP_STATE — VARCHAR(4)
  • DEPT_CODE — VARCHAR(10)
  • RETIRE_DATE — DATE
  • RETIRE_REASON — VARCHAR(4)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

HRTANNUALDETAIL

  • YYYY — VARCHAR(4) — Primary key — NOT NULL
  • COMPANY — VARCHAR(3) — Foreign key → ORGDEPTMASTER.COMPANY — NOT NULL
  • EMP_CODE — VARCHAR(20) — Foreign key → HRIMASTER.EMP_CODE — NOT NULL
  • DEPT_CODE — VARCHAR(10)
  • ANNUAL_START_DATE — DATE
  • ANNUAL_END_DATE — DATE
  • TOTAL_WORK_DAY — NUMERIC(19,5)
  • REAL_WORK_DAY — NUMERIC(19,5)
  • TOT_DAY — NUMERIC(19,5)
  • USE_DAY — NUMERIC(19,5)
  • BALANCE_DAY — NUMERIC(19,5)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

HRTATTENDANCEREQUEST

  • REQ_ID — VARCHAR(20) — Primary key — NOT NULL
  • COMPANY — VARCHAR(3) — Foreign key → ORGDEPTMASTER.COMPANY — NOT NULL
  • REQ_GROUP — VARCHAR(20)
  • REQ_TYPE — VARCHAR(20)
  • REQUESTER_EMP_CODE — VARCHAR(20)
  • TARGET_EMP_CODE — VARCHAR(20)
  • REQUESTER_DEPT_CODE — VARCHAR(10)
  • TARGET_DEPT_CODE — VARCHAR(10)
  • TARGET_DATE — DATE
  • TARGET_DATE_TO — DATE
  • REASON — VARCHAR(50)
  • REASON_DETAIL — VARCHAR(300)
  • STATUS — VARCHAR(20)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME
  • SUBMITTED_AT — DATETIME
  • APPROVED_AT — DATETIME
  • CANCELED_AT — DATETIME

HRTATTENDANCE_APPROVAL

  • COMPANY — VARCHAR(3) — Foreign key → HRIMASTER.COMPANY — NOT NULL
  • REQ_ID — VARCHAR(20) — Foreign key → HRTATTENDANCEREQUEST.REQ_ID — NOT NULL
  • STEP_NO — INTEGER
  • APPROVER_EMP_CODE — VARCHAR(20)
  • STATUS — VARCHAR(20)
  • DECISION_AT — DATETIME
  • REJECT_REASON — VARCHAR(300)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

HRTATTENDANCE_GENERAL

  • COMPANY — VARCHAR(3) — Foreign key → HRTATTENDANCEREQUEST.COMPANY — NOT NULL
  • REQ_ID — VARCHAR(20) — Foreign key → HRTATTENDANCEREQUEST.REQ_ID — NOT NULL
  • START_TIME — TIME
  • END_TIME — TIME
  • WORK_MIN — INTEGER
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

HRTATTENDANCE_OTHER

  • COMPANY — VARCHAR(3) — Foreign key → HRTSHIFTMASTER.COMPANY — NOT NULL
  • REQ_ID — VARCHAR(20) — Foreign key → HRTATTENDANCEREQUEST.REQ_ID — NOT NULL
  • CHANGE_SHIFT_CODE — VARCHAR(10)
  • START_DATE — DATE
  • END_DATE — DATE
  • APPLY_TYPE — VARCHAR(20)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

HRTDAILYATTENDANCE

  • YYYYMMDD — DATE — Primary key — NOT NULL
  • COMPANY — VARCHAR(3) — Foreign key → HRTSHIFTMASTER.COMPANY — NOT NULL
  • EMP_CODE — VARCHAR(20) — Foreign key → HRIMASTER.EMP_CODE — NOT NULL
  • DEPT_CODE — VARCHAR(10)
  • SHIFT_CODE — VARCHAR(10)
  • ACTUAL_SHIFT_CODE — VARCHAR(10)
  • CHECK_IN — TIME
  • CHECK_OUT — TIME
  • OVERNIGHT_YN — CHAR(1)
  • WORK_MIN — INTEGER
  • OVER_MIN — INTEGER
  • NIGHT_MIN — INTEGER
  • LATE_YN — CHAR(1)
  • EARLY_LEAVE_YN — CHAR(1)
  • ABSENT_YN — CHAR(1)
  • WEEK_NUM — VARCHAR(6)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

HRTDUTYINFO

  • COMPANY — VARCHAR(3) — Primary key — NOT NULL
  • DUTY_CODE — VARCHAR(3) — Primary key — NOT NULL
  • DUTY_NAME — VARCHAR(10)
  • USE_YN — CHAR(1)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

HRTGRADEINFO

  • COMPANY — VARCHAR(3) — Primary key — NOT NULL
  • POSITION_CODE — VARCHAR(10) — Primary key — NOT NULL
  • POSITION_NAME — NVARCHAR(30)
  • USE_YN — CHAR(1)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

HRTHOLIDAYMASTER

  • HOLIDAY_DATE — DATE — Primary key — NOT NULL
  • COMPANY — VARCHAR(3) — Foreign key → ORGDEPTMASTER.COMPANY — NOT NULL
  • HOLIDAY_NAME — NVARCHAR(50)
  • HOLIDAY_TYPE — VARCHAR(10)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

HRTSHIFTMASTER

  • SHIFT_CODE — VARCHAR(10) — Primary key — NOT NULL
  • COMPANY — VARCHAR(3) — Foreign key → HRTTIMEITEM.COMPANY — NOT NULL
  • SHIFT_NAME — VARCHAR(50)
  • NORMAL_TIME_ITEM_CODE — VARCHAR(10)
  • WORK_ON_DAY_TYPE — VARCHAR(2)
  • WORK_ON_TIME — TIME
  • WORK_OFF_DAY_TYPE — VARCHAR(2)
  • WORK_OFF_TIME — TIME
  • BREAK1_START_DAY_TYPE — VARCHAR(2)
  • BREAK1_START_TIME — TIME
  • BREAK1_END_DAY_TYPE — VARCHAR(2)
  • BREAK1_END_TIME — TIME
  • BREAK2_START_DAY_TYPE — VARCHAR(2)
  • BREAK2_START_TIME — TIME
  • BREAK2_END_DAY_TYPE — VARCHAR(2)
  • BREAK2_END_TIME — TIME
  • OVER_START_DAY_TYPE — VARCHAR(2)
  • OVER_START_TIME — TIME
  • OVER_END_DAY_TYPE — VARCHAR(2)
  • OVER_END_TIME — TIME
  • OVER2_START_DAY_TYPE — VARCHAR(2)
  • OVER2_START_TIME — TIME
  • OVER2_END_DAY_TYPE — VARCHAR(2)
  • OVER2_END_TIME — TIME
  • MEMO — VARCHAR(300)
  • USE_YN — CHAR(1)
  • FIVE_WEEK_YN — CHAR(1)
  • WORK_TYPE_CODE — VARCHAR(10)
  • WORK_DAY_TYPE — VARCHAR(10)
  • SORT_SEQ — INTEGER
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

HRTTIMEITEM

  • COMPANY — VARCHAR(3) — Primary key — NOT NULL
  • TIME_ITEM_CODE — VARCHAR(10) — Primary key — NOT NULL
  • TIME_ITEM_NAME — NVARCHAR(50)
  • TIME_ITEM_ABBR_NAME — NVARCHAR(50)
  • MEMO — NVARCHAR(300)
  • USE_YN — CHAR(1)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

HRTWEEKLYATTENDANCE

  • WEEK_START_DATE — DATE — Primary key — NOT NULL
  • COMPANY — VARCHAR(3) — Foreign key → ORGDEPTMASTER.COMPANY — NOT NULL
  • DEPT_CODE — VARCHAR(10) — Foreign key → ORGDEPTMASTER.DEPT_CODE — NOT NULL
  • EMP_CODE — VARCHAR(20) — Foreign key → HRIMASTER.EMP_CODE — NOT NULL
  • WORK_DAY_CNT — NUMERIC(19,5)
  • TOTAL_WORK_MIN — INTEGER
  • TOTAL_OVER_MIN — INTEGER
  • TOTAL_NIGHT_MIN — INTEGER
  • LATE_CNT — INTEGER
  • ABSENT_CNT — INTEGER
  • ANNUAL_USE_CNT — INTEGER
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

HRTWORKEMPCALENDAR

  • YYYYMMDD — DATE — Primary key — NOT NULL
  • COMPANY — VARCHAR(3) — Foreign key → HRTWORKPATTERNMASTER.COMPANY — NOT NULL
  • EMP_CODE — VARCHAR(20) — Foreign key → HRIMASTER.EMP_CODE — NOT NULL
  • TXN_ID — INT
  • SHIFT_CODE — VARCHAR(10)
  • WORK_PATTERN_CODE — VARCHAR(10)
  • DEPT_CODE — VARCHAR(10)
  • SHIFT_CODE_ORIG — VARCHAR(10)
  • HOLIDAY_YN — CHAR(1)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

HRTWORKPATTERNDETAIL

  • SEQ — INTEGER — Primary key — NOT NULL
  • COMPANY — VARCHAR(3) — Foreign key → HRTSHIFTMASTER.COMPANY — NOT NULL
  • WORK_PATTERN_CODE — VARCHAR(10) — Foreign key → HRTWORKPATTERNMASTER.WORK_PATTERN_CODE — NOT NULL
  • DAY_TYPE — VARCHAR(2)
  • SHIFT_CODE — VARCHAR(10)
  • WORK_TYPE_CODE — VARCHAR(10)
  • WORK_DAY_TYPE — VARCHAR(10)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

HRTWORKPATTERNMASTER

  • COMPANY — VARCHAR(3) — Primary key — NOT NULL
  • WORK_PATTERN_CODE — VARCHAR(10) — Primary key — NOT NULL
  • WORK_PATTERN_NAME — VARCHAR(50)
  • PATTERN_TYPE — VARCHAR(10)
  • CYCLE_UNIT — VARCHAR(2)
  • CYCLE_COUNT — INTEGER
  • START_DATE — DATE
  • END_DATE — DATE
  • USE_YN — CHAR(1)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

ORGDEPTMASTER

  • DEPT_CODE — VARCHAR(10) — Primary key — NOT NULL
  • COMPANY — VARCHAR(3) — Foreign key → HRTWORKPATTERNMASTER.COMPANY — NOT NULL
  • DEPT_NAME — VARCHAR(50)
  • PARENT_DEPT — VARCHAR(10)
  • DEPT_LEADER — VARCHAR(20)
  • DEPT_CATEGORY — VARCHAR(10)
  • START_DATE — DATE
  • END_DATE — DATE
  • USE_YN — CHAR(1)
  • OLD_DEPT_LEADER — VARCHAR(20)
  • WORK_PATTERN_CODE — VARCHAR(10)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME

USER_ACCOUNT

  • COMPANY — VARCHAR(3) — Foreign key → HRIMASTER.COMPANY — NOT NULL
  • USER_ID — VARCHAR(20) — Foreign key → HRIMASTER.EMP_CODE — NOT NULL
  • PASSWORD_HASH — VARCHAR(256)
  • ROLE_CODE — VARCHAR(20)
  • LAST_LOGIN_AT — DATETIME
  • PWD_CHANGED_AT — DATETIME
  • USE_YN — CHAR(1)
  • CREATED_AT — DATETIME
  • UPDATED_AT — DATETIME