Edu
Tables (3)
biscoerp_TPEDutyTime (연간교육훈련의무이수시간)
- CompanySeq (법인코드) — INT — Primary key — NOT NULL
- EduDutySeq (교육의무코드) — INT — Primary key — NOT NULL
- EduYear (연도) — NCHAR(4)
- UMPgSeq (직급코드) — INT
- DutyTime (의무이수시간) — INT
- DeptDutyTime (교육부서의무시간) — INT
- LastUserSeq (최종작업자) — INT
- LastDateTime (최종작업일시) — DATETIME
biscoerp_TPETypeTime (교육유형별인정시간기준표)
- CompanySeq (법인코드) — INT — Primary key — NOT NULL
- 교육유형코드 (EduTypeAppSeq) — INT — Primary key — NOT NULL
- EduYear (연도) — NCHAR(4)
- UMEduHighClass (대분류코드) — INT
- UMEduMidClass (중분류코드) — INT
- EduTypeAppName (교육유형명) — NVARCHAR(100)
- UMEduLicSeq (학력/자격증구분) — INT
- AppTime (인정시간) — INT
- AppTimeMax (연간최대인정시간) — INT
- AppRemark (인정근거) — NVARCHAR(200)
- LastUserSeq (최종작업자) — INT
- LastDateTime (최종작업일시) — DATETIME