TMS

Tables (6)

TMS_DIVIDE_SCORE_TWO ((공통화면) 교육대상 과목별 배점등록)

  • ECODE (교육과목코드) — VARCHAR2(3) — Primary key — NOT NULL
  • YEAR (년도) — VARCHAR2(4) — Primary key — NOT NULL
  • TRANING_GUBUN (교육대상) — VARCHAR2(20) — Primary key — NOT NULL
  • ATTEND_COUNT (출석횟수 이수시간) — NUMBER(10)
  • USEYN (사용여부) — VARCHAR2(1)
  • DIVIDE_SCORE (배점(출석+평가)) — NUMBER(12, 2)
  • ATTEND_SCORE (출석점수) — NUMBER(12, 2)
  • EVALUTE_SCORE (평가점수) — NUMBER(12, 2)
  • PLUS_VALUE (가점(시간당/횟수당)) — NUMBER(12, 2)
  • MINUS_VALUE (감점(시간당/횟수당)) — NUMBER(12, 2)
  • BIGO (비고) — VARCHAR2(1000)
  • DEL_CHK (삭제구분) — VARCHAR2(1)
  • DEL_DATE (삭제일시) — VARCHAR2(20)
  • DEL_IDNO (삭제자 사원번호) — VARCHAR2(6)
  • DEL_NAME (삭제자 성명) — VARCHAR2(20)

TMS_LEGAL_EVALUTE_REGI ((법령(수정)) 법령평가등록_메인)

  • EVALUTE_YEAR (년도) — VARCHAR2(6) — Primary key — NOT NULL
  • IDNO (사원번호) — VARCHAR2(6) — Primary key — NOT NULL
  • TOTAL_ISU_COUNT (총 이수횟수) — NUMBER(12)
  • EVALUTE_JUMSU (평가점수) — NUMBER(12, 1)
  • BIGO (비고) — VARCHAR2(600)
  • TOTAL_ISU_JUMSU (총 이수점수) — NUMBER(12, 1)
  • FINAL_JUMSU (최종점수) — NUMBER(12, 1)

TMS_ZIPCHE_EVALUTE_REGI ((집체교육) 집체교육평가등록_메인)

  • EVALUTE_YEAR (년도) — VARCHAR2(6) — Primary key — NOT NULL
  • TRAIN_GUBUN (교육구분) — VARCHAR2(2) — Primary key — NOT NULL
  • IDNO (사원번호) — VARCHAR2(6) — Primary key — NOT NULL
  • ATTENDL_JUMSU (출석점수) — NUMBER(12, 1)
  • EVALUTE_JUMSU (평가점수) — NUMBER(12, 1)
  • FINAL_JUMSU (최종점수) — NUMBER(12, 1)
  • BIGO (비고) — VARCHAR2(600)

TMS_ZIPCHE_EVALUTE_REGI_SUB ((집체교육) 집체교육평가등록_SUB)

  • EVALUTE_YEAR (년도) — VARCHAR2(6) — Primary key — NOT NULL
  • TRAIN_GUBUN (교육구분) — VARCHAR2(2) — Primary key — NOT NULL
  • IDNO (사원번호) — VARCHAR2(6) — Primary key — NOT NULL
  • TRAIN_DATE (교육일자) — VARCHAR2(10) — Primary key — NOT NULL
  • TRAIN_NO (순번) — VARCHAR2(2) — Primary key — NOT NULL
  • DEPART_CODE (부서코드) — VARCHAR2(6) — Primary key — NOT NULL

TMS_ZIPCHE_TRAIN_ATTEND ((집체교육) 집체교육 출석이력)

  • TRAIN_GUBUN (교육구분) — VARCHAR2(2) — Primary key — NOT NULL
  • TRAIN_DATE (교육일자) — VARCHAR2(10) — Primary key — NOT NULL
  • TRAIN_NO (순번) — VARCHAR2(2) — Primary key — NOT NULL
  • IDNO (사원번호) — VARCHAR2(6) — Primary key — NOT NULL
  • ATTEND_YN (출석여부) — VARCHAR2(60)

TMS_ZIPCHE_TRAIN_INFO ((집체교육) 집체교육 정보등록)

  • TRAIN_GUBUN (교육구분) — VARCHAR2(2) — Primary key — NOT NULL
  • TRAIN_DATE (교육일자) — VARCHAR2(10) — Primary key — NOT NULL
  • TRAIN_NO (순번) — VARCHAR2(2) — Primary key — NOT NULL
  • TRAIN_NAME (교육명) — VARCHAR2(60)
  • MAIN_DEPART (주관부서) — VARCHAR2(60)
  • TRAIN_SPOT (교육장소) — VARCHAR2(60)
  • TRAIN_INWON (교육인원) — NUMBER(12)
  • TRAIN_TIME (교육시간) — NUMBER(12)
  • ATTENDL_JUMSU (출석배점) — NUMBER(12, 2)
  • BIGO (비고) — VARCHAR2(600)