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)