Edu

Tables (3)

Untitled

    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