일근태

테이블 (14)

T_COMMUTE (출퇴근 시각 마스터)

  • ID (PK) — INT(10) — 기본 키 — NOT NULL
  • stamp (PK.) — INT(11) — 기본 키 — NOT NULL
  • back_id (Field2) — INT(11)
  • back_stamp (Field3) — INT(11)
  • division (Field4) — VARCHAR(2)
  • type (Field5) — ENUM('1','2')
  • platform (Field6) — VARCHAR(2)
  • remark (Field7) — VARCHAR(1000)
  • status (Field8) — VARCHAR(1)
  • ip (Field9) — INT(11)
  • location (Field10) — POINT
  • gps_range (Field11) — INT(11)
  • address (Field12) — VARCHAR(300)

htm_daily_base (근태기준관리)

  • DAILY_BASE_ID (PK) — INT(11) — 기본 키 — NOT NULL
  • COMPANY_ORIGINAL_ID (Field) — INT(11)
  • WORK_CODE (Field2) — INT(11)
  • TYPE_CODE (Field3) — INT(11)
  • START_YMD (Field4) — DATETIME
  • END_YMD (Field5) — DATETIME
  • LIMIT_TYPE (Field6) — INT(11)
  • LIMIT_DAYS (Field7) — INT(11)
  • LIMIT_DAYS_AFTER (Field8) — INT(11)
  • HOLIDAY_APPLY_TYPE (Field9) — INT(11)
  • YEAR_LIMIT_NUM (Field10) — DECIMAL
  • PAY_YN (Field11) — CHAR(1)
  • UNPAID_DAYS (Field12) — INT(11)
  • OVERLAP_YN (Field13) — CHAR(1)
  • ATTEND_YN (Field14) — CHAR(1)
  • REQUEST_TYPE_ID (Field15) — INT(11)
  • REQUEST_UNIT_ID (Field16) — INT(11)
  • NOTE (Field17) — VARCHAR(200)
  • YY_MINUS_YN (Field18) — CHAR(1)
  • CHILDBIRTH_YN (Field19) — CHAR(1)
  • HOLDAY_PLAN_YN (Field20) — CHAR(1)
  • WORK_TIME_DISPLAY_YN (Field21) — CHAR(1)
  • WORK_PERIOD_YN (Field22) — CHAR(1)
  • HALF_USE_YN (Field23) — CHAR(1)
  • WORK_TIME_NUM (Field24) — DECIMAL(7,3)
  • MASKING (Field25) — VARCHAR(100)
  • DISPLAY_YN (Field26) — CHAR(1)
  • REQUEST_UNIT_TIME (Field27) — INT(4)
  • MONTH_LIMIT_NUM (Field28) — DECIMAL(7,3)
  • DAY_LIMIT_NUM (Field29) — DECIMAL(7,3)
  • YEAR_NUM (Field30) — DECIMAL(7,3)
  • YEAR_NUM_SATURDAY (Field31) — DECIMAL(7,3)
  • ATTACH_FILE_YN (Field32) — CHAR(1)
  • SUBSTITUDE_YN (Field33) — CHAR(1)
  • ATTRIBUTE_CATEGORY (Field34)
  • ATTRIBUTE01 ~ATTRIBUTE10 (Field35)
  • CREATION_DATE (Field36)
  • CREATED_BY (Field37)
  • LAST_UPDATE_DATE (Field38)
  • LAST_UPDATED_BY (Field39)
  • LAST_UPDATE_LOGIN (Field40)
  • default_start_time (Field41) — VARCHAR(5) — ..

htm_flexible_person_time_history (개인별 근무시간이력)

  • FLEXIBLE_WORK_PERSON_TIME_ID (PK) — 기본 키 — NOT NULL
  • FLEXIBLE_WORK_ORGANIZATION_ID (Field)
  • EMPLOYEE_ID (IDX1)
  • WORK_DAY (IDX1.)
  • TOTAL_TIME (Field4) — DECIMAL(10,1)
  • WORK_TIME (Field5) — DECIMAL(10,1)
  • OVER_TIME (Field6) — DECIMAL(10,1)
  • NIGHT_TIME (Field7) — DECIMAL(10,1)
  • HOLIDAY_TIME (Field8) — DECIMAL(10,1)

htm_flexible_time_emp (개인별 근무형태)

  • FLEXIBLE_TIME_EMP_ID (PK) — INT(11) — 기본 키 — NOT NULL
  • COMPANY_ORIGINAL_ID (Field) — INT(11)
  • EMPLOYEE_ID (IDX1.) — INT(11)
  • FLEXIBLE_WORK_GUBUN (Field3) — INT(11)
  • FLEXIBLE_WORK_CODE (Field4) — INT(11)
  • WEEK_BASELINE (Field5) — INT(11)
  • WORK_START_DAY (IDX1) — DATE
  • WORK_END_DAY (Field7) — DATE
  • TOTAL_WORK_TIME (Field8) — INT(11)
  • MONTH_WORK_TIME (Field9) — INT(11)
  • WEEK_WORK_TIME (Field10) — INT(11)
  • OVERTIME_TIME (Field11) — INT(11)
  • ASSIGNMENT_TRANSFER_YN (Field12) — CHAR(1)
  • OVERTIME_YN (Field13) — CHAR(1)
  • WORK_NOT_YN (Field14) — CHAR(1)
  • MIN_WORK_TIME_YN (Field15) — CHAR(1)
  • MIN_WORK_TIME (Field16) — INT(11)
  • MAX_WORK_TIME_YN (Field17) — CHAR(1)
  • MAX_WORK_TIME (Field18) — INT(11)
  • COWORK_TIME_YN (Field19) — CHAR(1)
  • COWORK_START_TIME (Field20) — VARCHAR(10)
  • COWORK_END_TIME (Field21) — VARCHAR(10)
  • PERSONAL_TIME_YN (Field22) — CHAR(1)
  • WORK_START_TIME (Field23) — VARCHAR(10)
  • WORK_START_TIME_ALLOW (Field24) — INT(11)
  • WORK_END_TIME (Field25) — VARCHAR(10)
  • WORK_END_TIME_ALLOW (Field26) — INT(11)
  • PERSONAL_MEAL_YN (Field27) — CHAR(1)
  • LUNCH_START_TIME (Field28) — INT(11)
  • LUNCH_END_TIME (Field29) — INT(11)
  • DINNER_START_TIME (Field30) — INT(11)
  • DINNER_END_TIME (Field31) — INT(11)
  • GPS_REQUIRED_YN (Field32) — VARCHAR(1)
  • MODIFY_TODAY_YN (Field33) — VARCHAR(1)
  • NOTE (Field34)
  • ATTRIBUTE_CATEGORY (Field35)
  • ATTRIBUTE01 (Field36)
  • ATTRIBUTE02 (Field37)
  • ATTRIBUTE03 (Field38)
  • ATTRIBUTE04 (Field39)
  • ATTRIBUTE05 (Field40)
  • ATTRIBUTE06 (Field41)
  • ATTRIBUTE07 (Field42)
  • ATTRIBUTE08 (Field43)
  • ATTRIBUTE09 (Field44)
  • ATTRIBUTE10 (Field45)
  • CREATION_DATE (Field46)
  • CREATED_BY (Field47)
  • LAST_UPDATE_DATE (Field48)
  • LAST_UPDATED_BY (Field49)
  • LAST_UPDATE_LOGIN (Field50)
  • MOBILE_USE_FLAG (Field51) — CHAR(1)
  • EXTENDED_WORK_DRAFT_USE_FLAG (Field52) — CHAR(1)
  • EXTENDED_WORK_START_TIME_USE_FLAG (Field53) — CHAR(1)
  • EXTENDED_WORK_START_TIME (Field54) — VARCHAR(10)
  • NIGHT_TAXI_USE_YN (Field55) — VARCHAR(1)
  • allow_chat_bot (Field56) — VARCHAR(1)

htm_flexible_work_organization (부서별유연근무제)

  • FLEXIBLE_WORK_ORGANIZATION_ID (PK) — 기본 키 — NOT NULL
  • COMPANY_ORIGINAL_ID (Field) — INT(11)
  • ORGANIZATION_ID (IDX1.) — INT(11)
  • FLEXIBLE_WORK_GUBUN (Field3) — INT(11)
  • FLEXIBLE_WORK_CODE (Field4) — INT(11)
  • WEEK_BASELINE (Field5) — INT(11)
  • WORK_START_DAY (IDX1) — DATE
  • WORK_END_DAY (Field7) — DATE
  • TOTAL_WORK_TIME (Field8) — INT(11)
  • MONTH_WORK_TIME (Field9) — INT(11)
  • WEEK_WORK_TIME (Field10) — INT(11)
  • OVERTIME_TIME (Field11) — INT(11)
  • ASSIGNMENT_TRANSFER_YN (Field12) — CHAR(1)
  • OVERTIME_YN (Field13) — CHAR(1)
  • WORK_NOT_YN (Field14) — CHAR(1)
  • MIN_WORK_TIME_YN (Field15) — CHAR(1)
  • MIN_WORK_TIME (Field16) — INT(11)
  • MAX_WORK_TIME_YN (Field17) — CHAR(1)
  • MAX_WORK_TIME (Field18) — INT(11)
  • COWORK_TIME_YN (Field19) — CHAR(1)
  • COWORK_START_TIME (Field20) — VARCHAR(10)
  • COWORK_END_TIME (Field21) — VARCHAR(10)
  • PERSONAL_TIME_YN (Field22) — CHAR(1)
  • WORK_START_TIME (Field23) — VARCHAR(10)
  • WORK_START_TIME_ALLOW (Field24) — INT(11)
  • WORK_END_TIME (Field25) — VARCHAR(10)
  • WORK_END_TIME_ALLOW (Field26) — INT(11)
  • PERSONAL_MEAL_YN (Field27) — CHAR(1)
  • LUNCH_START_TIME (Field28) — INT(11)
  • LUNCH_END_TIME (Field29) — INT(11)
  • DINNER_START_TIME (Field30) — INT(11)
  • DINNER_END_TIME (Field31) — INT(11)
  • GPS_REQUIRED_YN (Field32) — VARCHAR(1)
  • MODIFY_TODAY_YN (Field33) — VARCHAR(1)
  • NOTE (Field34)
  • ATTRIBUTE_CATEGORY (Field35)
  • ATTRIBUTE01 (Field36)
  • ATTRIBUTE02 (Field37)
  • ATTRIBUTE03 (Field38)
  • ATTRIBUTE04 (Field39)
  • ATTRIBUTE05 (Field40)
  • ATTRIBUTE06 (Field41)
  • ATTRIBUTE07 (Field42)
  • ATTRIBUTE08 (Field43)
  • ATTRIBUTE09 (Field44)
  • ATTRIBUTE10 (Field45)
  • CREATION_DATE (Field46)
  • CREATED_BY (Field47)
  • LAST_UPDATE_DATE (Field48)
  • LAST_UPDATED_BY (Field49)
  • LAST_UPDATE_LOGIN (Field50)
  • MOBILE_USE_FLAG (Field51) — CHAR(1)
  • EXTENDED_WORK_DRAFT_USE_FLAG (Field52) — CHAR(1)
  • EXTENDED_WORK_START_TIME_USE_FLAG (Field53) — CHAR(1)
  • EXTENDED_WORK_START_TIME (Field54) — VARCHAR(10)
  • NIGHT_TAXI_USE_YN (Field55) — VARCHAR(1)
  • allow_chat_bot (Field56) — VARCHAR(1)
  • Field2
  • Field6

htm_flexible_work_person (개인별유연근무제)

  • FLEXIBLE_WORK_EMPLOYEE_ID (PK) — INT(11) — 기본 키 — NOT NULL
  • COMPANY_ORIGINAL_ID (Field) — INT(11)
  • EMPLOYEE_ID (Field2) — INT(11)
  • FLEXIBLE_WORK_CODE (Field3) — INT(11)
  • WEEK_BASELINE (Field4) — INT(11)
  • WORK_START_DAY (Field5) — DATE
  • WORK_END_DAY (Field6) — DATE
  • COWORK_START_TIME (Field7) — VARCHAR(10)
  • COWORK_END_TIME (Field8) — VARCHAR(10)
  • WORK_START_TIME (Field9) — VARCHAR(10)
  • WORK_START_TIME_ALLOW (Field10) — INT(11)
  • WORK_END_TIME (Field11) — VARCHAR(10)
  • WORK_END_TIME_ALLOW (Field12) — INT(11)
  • LUNCH_START_TIME (Field13) — INT(11)
  • LUNCH_END_TIME (Field14) — INT(11)
  • DINNER_START_TIME (Field15) — INT(11)
  • DINNER_END_TIME (Field16) — INT(11)
  • WRITE_EMPLOYEE_ID (Field17) — INT(11)
  • APPLICATION_YMD (Field18) — DATE
  • DRAFT_ID (Field19) — INT(11)
  • REASON (Field20) — VARCHAR(1000)
  • REQUEST_STATUS_CODE (Field21) — INT(11)
  • CANCEL_DRAFT_ID (Field22) — INT(11)
  • CANCEL_REQ_YMD (Field23) — DATE
  • CANCEL_NOTE (Field24) — VARCHAR(200)
  • CANCEL_EMPLOYEE_ID (Field25) — INT(11)
  • ATTACH_GROUP_ID (Field26) — INT(11)
  • NOTE (Field27)
  • ATTRIBUTE_CATEGORY (Field28)
  • ATTRIBUTE01. (Field29)
  • ATTRIBUTE02 (Field30)
  • ATTRIBUTE03 (Field31)
  • ATTRIBUTE04 (Field32)
  • ATTRIBUTE05 (Field33)
  • ATTRIBUTE06 (Field34)
  • ATTRIBUTE07 (Field35)
  • ATTRIBUTE08 (Field36)
  • ATTRIBUTE09 (Field37)
  • ATTRIBUTE10 (Field38)

htm_work_base (근무유형관리)

  • WORK_BASE_ID (PK) — INT(11) — 기본 키 — NOT NULL
  • COMPANY_ORIGINAL_ID (Field) — INT(11)
  • Field2
  • Field3 — VARCHAR(1)
  • Field4
  • Field5
  • Field6
  • Field7
  • Field8
  • Field9
  • Field10
  • Field11
  • Field12
  • Field13
  • Field14
  • Field15
  • Field16
  • Field17
  • Field18
  • Field19
  • Field20
  • Field21
  • Field22
  • Field23
  • Field24 — DATETIME

htm_work_day_detail (24시간 상세설정)

  • WORK_DAY_DETAIL_ID (PK) — INT(11) — 기본 키 — NOT NULL
  • WORK_TIME_TABLE_ID (PK2) — INT(11) — 외래 키 → htm_work_time_table.WORK_TIME_TABLE_ID — NOT NULL
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7
  • Field — DECIMAL(10,1)

htm_work_time_pattern (근무패턴)

  • WORK_TIME_PATTERN_ID (PK) — INT(11) — 기본 키 — NOT NULL
  • WORK_BASE_ID (PK2) — INT(11) — 외래 키 → htm_work_base.WORK_BASE_ID — NOT NULL
  • Field — VARCHAR(100)
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7
  • Field8
  • Field9 — INT(11).

htm_work_time_table (근무시간표)

  • WORK_TIME_TABLE_ID (PK) — INT(11) — 기본 키 — NOT NULL
  • Field — VARCHAR(100)
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7 — VARCHAR(1)
  • Field8 — VARCHAR(1)
  • Field9 — VARCHAR(1)
  • Field10 — VARCHAR(1)
  • Field11

t_commute_ip_white_list (출퇴근 IP 허용 정보)

  • COMPANY_ID (Field)
  • IP (Field2)

t_commute_master (Untitled)

  • ID (PK) — INT(10) — 기본 키 — NOT NULL
  • PID (Field) — INT(10)
  • draft_id (Field2) — INT(11)
  • draft_type (Field3) — VARCHAR(1)
  • ymd (Field4) — DATE
  • employee_id (Field5) — INT(11)
  • status (Field6) — VARCHAR(1)

t_commute_reports (출퇴근위치 히스토리)

  • report_id (PK) — INT(11) — 기본 키 — NOT NULL
  • user_id (Field) — INT(11)
  • created_at (Field2) — DATETIME
  • current_lat (Field3) — DOUBLE(9,7)
  • current_lon (Field4) — DOUBLE(9,7)
  • target_lat (Field5) — DOUBLE(9,7)
  • target_lon (Field6) — DOUBLE(9,7)
  • radius (Field7) — VARCHAR(20)
  • distance (Field8) — VARCHAR(20)

t_commute_standard (출퇴근 유형 (법정휴게 기준시간, 휴게시간, 절상/절사 단위).)

  • type (PK) — CHAR(1) — 기본 키 — NOT NULL
  • stamp (Field2) — INT(11)
  • remark (Field3) — VARCHAR(100)