인사관리 ERD
ERP 데이터베이스 스키마 정보와 human 데이터베이스 스키마 정보를 표기
테이블 (42)
Copy Of NEOE.NEOE.HR_WTMCALC (CopyOfNEOE.NEOE.HR_WTMCALC)
- CD_COMPANY — nvarchar(7) — 기본 키 — NOT NULL
- NO_EMP — nvarchar(10) — 기본 키 — NOT NULL
- DT_WORK — nvarchar(8) — 기본 키 — NOT NULL
- CD_BIZAREA — nvarchar(7) — NOT NULL
- CD_WEEK — nvarchar(3)
- CD_HOLY — nvarchar(3)
- CD_WORK — nvarchar(3)
- CD_WCODE — nvarchar(3)
- CD_PART — nvarchar(3)
- CD_TMCODE — nvarchar(3)
- TP_EMP — nvarchar(3)
- CD_EMP — nvarchar(3)
- CD_DEPT — nvarchar(12)
- CD_DUTY_RANK — nvarchar(3)
- CD_CC — nvarchar(12)
- CD_PJT — nvarchar(20)
- CD_PLANT — nvarchar(7)
- CD_WC — nvarchar(7)
- CD_START — nvarchar(3)
- TM_START — nvarchar(6)
- CD_CLOSE — nvarchar(3)
- TM_CLOSE — nvarchar(6)
- TM_LATE — numeric(6, 0)
- TM_EARLY — numeric(6, 0)
- TM_OUT — numeric(6, 0)
- TM_MOR — numeric(6, 0)
- TM_NORMAL — numeric(6, 0)
- TM_EVENING — numeric(6, 0)
- TM_NIGHT — numeric(6, 0)
- TM_MIDNIGHT — numeric(6, 0)
- TM_ALLNIG — numeric(6, 0)
- AM_DAY — numeric(17, 4)
- DC_RMK — nvarchar(200)
- DTS_INSERT — nvarchar(14)
- ID_INSERT — nvarchar(15)
- DTS_UPDATE — nvarchar(14)
- ID_UPDATE — nvarchar(15)
- CD_DUTY_RESP — nvarchar(3)
- CD_CHK — char(1)
- CD_ERR — varchar(3)
- CD_ERR_CHK — char(1)
- DY_WOCCUR — numeric(5, 2)
- DY_MOCCUR — numeric(5, 2)
- FG_CLOSE — nvarchar(1)
- TM_OUT_EX — numeric(6, 0)
- TM_BTWORK — numeric(6, 0)
- CD_START2 — nvarchar(3)
- TM_START2 — nvarchar(6)
- CD_CLOSE2 — nvarchar(3)
- TM_CLOSE2 — nvarchar(6)
- TM_NORMAL2 — numeric(6, 0)
- TM_NIGHT2 — numeric(6, 0)
- TM_ALLNIG2 — numeric(6, 0)
- YN_EAT — nvarchar(1)
- TM_BREAK — numeric(6, 0)
- DC_DELYI — nvarchar(3)
- AM_PAY100 — numeric(17, 4)
- AM_PAY200 — numeric(17, 4)
- AM_PAY300 — numeric(17, 4)
- AM_PAY400 — numeric(17, 4)
- … +18
ERPDB_DATACHKD
- C_CODE — char(4) — NOT NULL
- HCODE — varchar(4) — NOT NULL
- DCODE — varchar(6) — NOT NULL
- DNAME — varchar(100)
- DATAVAL — numeric(8, 3)
- ENAME — varchar(40)
FASOO_DZ_HUAN (VIEW) (FASOO_DZ_HUAN)
- NO_EMP
- NM_KOR
- NO_AN
HR_CAREER
- NO_EMP — nvarchar(10) — 기본 키 — NOT NULL
- NO_SEQ — numeric(7, 0) — 기본 키 — NOT NULL
- CD_COMPANY — nvarchar(7) — 기본 키 — NOT NULL
- NM_COMPANY — nvarchar(40)
- DT_ENTER — nchar(8)
- DT_RETIRE — nchar(8)
- NM_POST — nvarchar(20)
- NM_WORK — nvarchar(20)
- DC_RMK_RETIRE — nvarchar(50)
- DTS_INSERT — nvarchar(14)
- ID_INSERT — nvarchar(15)
- DTS_UPDATE — nvarchar(14)
- ID_UPDATE — nvarchar(15)
- RT_APPL — numeric(5, 2)
- CD_RECON — nvarchar(3)
- DT_CONYEAR — nvarchar(6)
- AM_GROSS — numeric(17, 4)
- DY_DAYSUM — numeric(17, 2)
- MEMO_CD — nvarchar(20)
- CHECK_PEN — nvarchar(20)
- NM_LAST_DUTY_RANK — nvarchar(20)
- DT_CONYEAR2 — nvarchar(6)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HR_FORELANG
- NO_EMP — nvarchar(10) — 기본 키 — NOT NULL
- CD_COMPANY — nvarchar(7) — 기본 키 — NOT NULL
- NO_SEQ — numeric(7, 0) — 기본 키 — NOT NULL
- CD_FLANG — nvarchar(3)
- NM_FLANG — nvarchar(40)
- NM_GRADE — nvarchar(40)
- DT_VALU — nvarchar(8)
- PT_EPI — numeric(5, 2)
- NM_ISSUE — nvarchar(40)
- DC_RMK — nvarchar(50)
- DTS_INSERT — nvarchar(14)
- ID_INSERT — nvarchar(15)
- DTS_UPDATE — nvarchar(14)
- ID_UPDATE — nvarchar(15)
- CD_ISSUE — nvarchar(3)
- MEMO_CD — nvarchar(20)
- CHECK_PEN — nvarchar(20)
- CD_FEDU — nvarchar(3)
- PT_FSCORE1 — numeric(7, 2)
- PT_FSCORE2 — numeric(7, 2)
- PT_FSCORE3 — numeric(7, 2)
- PT_TOT — numeric(7, 2)
- PT_AVER — numeric(7, 2)
- CD_QUALI_GRD — nvarchar(3)
- DC_GRD — nvarchar(20)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HR_HUANHEAD
- CD_COMPANY — nvarchar(7) — 기본 키 — NOT NULL
- NO_AN — nvarchar(20) — 기본 키 — NOT NULL
- DT_WRITE — nvarchar(8)
- NM_AN — nvarchar(40)
- CD_BIZAREA — nvarchar(7)
- CD_DEPT — nvarchar(12)
- NM_WRITER — nvarchar(40)
- DTS_INSERT — nvarchar(14)
- ID_INSERT — nvarchar(15)
- DTS_UPDATE — nvarchar(14)
- ID_UPDATE — nvarchar(15)
- MEMO_CD — nvarchar(20)
- CHECK_PEN — nvarchar(20)
- NM_BAL — nvarchar(40)
- NM_AN_L1 — nvarchar(40)
- NM_AN_L2 — nvarchar(40)
- NM_AN_L3 — nvarchar(40)
- NM_AN_L4 — nvarchar(40)
- NM_AN_L5 — nvarchar(40)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HR_HUEDUCODE
- CD_COMPANY — nvarchar(7) — 기본 키 — NOT NULL
- YY_EDU — nvarchar(4) — 기본 키 — NOT NULL
- CD_EDU — nvarchar(15) — 기본 키 — NOT NULL
- NM_EDU — nvarchar(100)
- DC_EDU — nvarchar(50)
- NM_EDUSER — nvarchar(40)
- NM_LOC — nvarchar(40)
- CD_INOUT — nvarchar(3)
- DT_FROM — nvarchar(8)
- DT_TO — nvarchar(8)
- DY_EDU — numeric(7, 0)
- DC_EDUTIME — nvarchar(10)
- DC_EDUTAR — nvarchar(20)
- DC_PER — nvarchar(10)
- NM_LEC — nvarchar(40)
- AM_EDU — numeric(17, 4)
- AM_EDUEMP — numeric(17, 4)
- AM_EDUSPL — numeric(17, 4)
- YN_EDU — nchar(1)
- CD_EPART — nvarchar(3)
- DC_RMK — nvarchar(200)
- CD_EDUPART — nvarchar(3)
- DTS_INSERT — nvarchar(14)
- ID_INSERT — nvarchar(15)
- DTS_UPDATE — nvarchar(14)
- ID_UPDATE — nvarchar(15)
- CD_EDU_H — nvarchar(15)
- ID_EDU_DOC — varchar(50)
- MEMO_CD — nvarchar(20)
- CHECK_PEN — nvarchar(20)
- NO_LEC — nvarchar(10)
- DC_LEC — nvarchar(250)
- PT_MILEAGE — numeric(5, 2)
- NO_EDUSER — nvarchar(3)
- NM_EDU_L1 — nvarchar(100)
- NM_EDU_L2 — nvarchar(100)
- NM_EDU_L3 — nvarchar(100)
- NM_EDU_L4 — nvarchar(100)
- NM_EDU_L5 — nvarchar(100)
- CD_EDUENTER — nvarchar(3)
- CD_ONOFF — nvarchar(3)
- CD_FREE — nvarchar(3)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HR_HUEDUPER
- CD_COMPANY — nvarchar(7) — 기본 키 — NOT NULL
- YY_EDU — nvarchar(4) — 기본 키 — NOT NULL
- CD_EDU — nvarchar(15) — 기본 키 — NOT NULL
- NO_EMP — nvarchar(10) — 기본 키 — NOT NULL
- CD_DEPT — nvarchar(12)
- AM_EDUEMP — numeric(17, 4)
- AM_EDUSPL — numeric(17, 4)
- CD_PASS — nvarchar(3)
- PT_ATTEND — numeric(5, 2)
- PT_ATTIT — numeric(5, 2)
- PT_ASSIGN — numeric(5, 2)
- DC_EUDASS — nvarchar(10)
- DTS_INSERT — nvarchar(14)
- ID_INSERT — nvarchar(15)
- DTS_UPDATE — nvarchar(14)
- ID_UPDATE — nvarchar(15)
- DC_RMK — nvarchar(200)
- MEMO_CD — nvarchar(20)
- CHECK_PEN — nvarchar(20)
- DC_EDUTIME_PER — nvarchar(10)
- PT_ADJ — numeric(5, 2)
- DC_RMK1 — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HR_HUPRIZE
- CD_COMPANY — nvarchar(7) — 기본 키 — NOT NULL
- CD_PRIZE — nvarchar(3) — 기본 키 — NOT NULL
- NO_EMP — nvarchar(10) — 기본 키 — NOT NULL
- DT_PRIZE — nvarchar(8) — 기본 키 — NOT NULL
- GRD_PRIZE — nvarchar(3) — 기본 키 — NOT NULL
- NO_SEQ — numeric(4, 0) — 기본 키 — NOT NULL
- TP_PRIZE — nvarchar(3)
- DC_ITEM — nvarchar(50)
- AM_PRIZE — numeric(17, 4)
- NO_COEMP — nvarchar(10)
- DC_RMK — nvarchar(100)
- DTS_INSERT — nvarchar(14)
- ID_INSERT — nvarchar(15)
- DTS_UPDATE — nvarchar(14)
- ID_UPDATE — nvarchar(15)
- MEMO_CD — nvarchar(20)
- CHECK_PEN — nvarchar(20)
- YM_PAY — nvarchar(6)
- DT_FROM — nvarchar(8)
- DT_TO — nvarchar(8)
- NO_DVS — numeric(2, 0)
- DT_BASIC — nvarchar(8)
- DY_CONYEAR — nvarchar(6)
- CD_WCODE — nvarchar(3)
- NUM_HOLY — numeric(5, 2)
- SEQ — numeric(5, 2)
- YN_HOLIDAY — nvarchar(3)
- DC_ITEM_L1 — nvarchar(50)
- DC_ITEM_L2 — nvarchar(50)
- DC_ITEM_L3 — nvarchar(50)
- DC_ITEM_L4 — nvarchar(50)
- DC_ITEM_L5 — nvarchar(50)
- PT_HUP — numeric(5, 2)
- NM_USERDEF1 — nvarchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HR_LICENSE
- NO_EMP — nvarchar(10) — 기본 키 — NOT NULL
- CD_COMPANY — nvarchar(7) — 기본 키 — NOT NULL
- NO_SEQ — numeric(7, 0) — 기본 키 — NOT NULL
- DT_ENTER — nchar(8) — 기본 키 — NOT NULL
- CD_QUALI — nvarchar(4)
- CD_QUALI_GRD — nvarchar(3)
- NO_QUALI — nvarchar(20)
- CD_CHECK — nvarchar(3)
- DT_VALIDITY — nchar(8)
- NM_ISSUE — nvarchar(40)
- DTS_INSERT — nvarchar(14)
- ID_INSERT — nvarchar(15)
- DTS_UPDATE — nvarchar(14)
- ID_UPDATE — nvarchar(15)
- CD_ISSUE — nvarchar(3)
- MEMO_CD — nvarchar(20)
- CHECK_PEN — nvarchar(20)
- NM_QUALI — nvarchar(100)
- YM_PAY_S — nvarchar(6)
- YM_PAY_E — nvarchar(6)
- DT_APPRV — nvarchar(8)
- DT_RESN — nvarchar(8)
- CD_JOB_LICENSE — nvarchar(3)
- NM_JOB_LICENSE — nvarchar(200)
- CD_SITE — nvarchar(12)
- NM_SITE — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HR_SCHOCARE
- NO_EMP — nvarchar(10) — 기본 키 — NOT NULL
- CD_COMPANY — nvarchar(7) — 기본 키 — NOT NULL
- NO_SEQ — numeric(7, 0) — 기본 키 — NOT NULL
- CD_SCH — nvarchar(3)
- NM_SCH — nvarchar(40)
- DT_ENTER — nchar(8)
- DT_GRADU — nchar(8)
- CD_CAREER — nvarchar(3)
- CD_SECTOR — nvarchar(3)
- CD_MAJOR — nvarchar(3)
- CD_SUB_MAJOR — nvarchar(3)
- CD_GRADU — nvarchar(3)
- CD_DEGREE — nvarchar(3)
- PT_EPI — numeric(5, 2)
- DC_SJ — nvarchar(40)
- DTS_INSERT — nvarchar(14)
- ID_INSERT — nvarchar(15)
- DTS_UPDATE — nvarchar(14)
- ID_UPDATE — nvarchar(15)
- CD_DC_SJ — nvarchar(3)
- TP_LASTSCH — nvarchar(3)
- NM_MAJOR — nvarchar(40)
- NM_SUB_MAJOR — nvarchar(40)
- CD_LOCATION — nvarchar(3)
- TP_SCH — nvarchar(3)
- CD_RECON — nvarchar(3)
- YN_JOINSCH — nvarchar(1)
- CD_DOB_MAJOR — nvarchar(3)
- NM_DOB_MAJOR — nvarchar(40)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HR_UNITMGR
- NO_EMP — nvarchar(10) — 기본 키 — NOT NULL
- CD_COMPANY — nvarchar(7) — 기본 키 — NOT NULL
- NO_SEQ — numeric(7, 0) — 기본 키 — NOT NULL
- CD_UNIT — nvarchar(3)
- DT_ENTER — nchar(8)
- DT_LEAVE — nchar(8)
- NO_TEL_UNIT — nvarchar(15)
- NM_RANK — nvarchar(20)
- DC_UNIT — nvarchar(50)
- DTS_INSERT — nvarchar(14)
- ID_INSERT — nvarchar(15)
- DTS_UPDATE — nvarchar(14)
- ID_UPDATE — nvarchar(15)
- MEMO_CD — nvarchar(20)
- NM_EMAIL — varchar(20)
- AM_ENTER — varchar(8)
- AM_LEAVE — varchar(8)
- AM_UNIT — numeric(17, 4)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HR_WYEAR
- CD_COMPANY — nvarchar(7) — 기본 키 — NOT NULL
- CD_BIZAREA — nvarchar(7) — 기본 키 — NOT NULL
- YY — nchar(4) — 기본 키 — NOT NULL
- NO_EMP — nvarchar(10) — 기본 키 — NOT NULL
- MM_YAD — nvarchar(2) — NOT NULL
- DT_BASIC — nvarchar(8)
- CD_DEPT — nvarchar(12)
- DT_GENTER — nvarchar(8)
- DT_ENTER — nvarchar(8)
- DY_ABSEN — numeric(7, 4)
- DY_YOCCUR — numeric(7, 4)
- DY_YLTRANS — numeric(7, 4)
- DY_YTOT — numeric(7, 4)
- DY_YUSE — numeric(7, 4)
- DY_YADJUST — numeric(7, 4)
- DY_YTRANS — numeric(7, 4)
- YM_YADJUST — nvarchar(6)
- DY_MOCCUR — numeric(7, 4)
- DY_MLTRANS — numeric(7, 4)
- DY_MTOT — numeric(7, 4)
- DY_MUSE — numeric(7, 4)
- DY_MADJUST — numeric(7, 4)
- DY_MTRANS — numeric(7, 4)
- YM_MADJUST — nvarchar(6)
- DY_POCCUR — numeric(7, 4)
- DY_PLTRANS — numeric(7, 4)
- DY_PTOT — numeric(7, 4)
- DY_PUSE — numeric(7, 4)
- DY_PADJUST — numeric(7, 4)
- DY_PTRANS — numeric(7, 4)
- YM_PADJUST — nvarchar(6)
- DTS_INSERT — nvarchar(14)
- ID_INSERT — nvarchar(15)
- DTS_UPDATE — nvarchar(14)
- ID_UPDATE — nvarchar(15)
- DY_YREQ — numeric(7, 4)
- DY_YLREQ — numeric(7, 4)
- DY_YOCCUR_ORG — numeric(7, 4)
- DY_YOCCUR_MOD — numeric(7, 4)
- DY_PRMT — numeric(7, 4)
- DT_BASEYEAR — nvarchar(8)
- ADDYEAR — numeric(5, 2)
- DC_RMK — nvarchar(200)
- NUM_USERDEF1 — numeric(7, 4)
- NUM_USERDEF2 — numeric(7, 4)
- DY_YPLUS — numeric(7, 4)
- DY_REST — numeric(7, 4)
- DY_PRE_YADJUST — numeric(7, 4)
- YM_PRE_YADJUST — nvarchar(6)
- DY_GDTOT — numeric(7, 4)
- DY_GDUSE — numeric(7, 4)
- DY_GDADJUST — numeric(7, 4)
- YM_GDADJUST — nvarchar(6)
- DY_WUYEAR — numeric(7, 4)
- DY_YPLUSUSE — numeric(7, 4)
- DY_REFUND — numeric(7, 4)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MASSRO 유저정보 (ERPDB_MEMBER)
- ID — varchar(50) — NOT NULL
- Password — varchar(20)
- Name — varchar(20)
- F_right — char(1)
- Grp_Name — varchar(255)
- idx — int
MA_CODEDTL
- CD_FIELD — nvarchar(10) — 기본 키 — NOT NULL
- CD_SYSDEF — nvarchar(4) — 기본 키 — NOT NULL
- CD_COMPANY — nvarchar(7) — 기본 키 — NOT NULL
- FG1_SYSCODE — nvarchar(1) — NOT NULL
- CD_USRDEF — nvarchar(3)
- NM_USRDEF — nvarchar(60)
- NM_SYSDEF — nvarchar(200)
- USE_YN — nchar(1)
- CD_FLAG1 — nvarchar(50)
- CD_FLAG2 — nvarchar(200)
- CD_FLAG3 — nvarchar(50)
- NM_SYSDEF_E — nvarchar(200)
- ID_INSERT — nvarchar(15)
- DTS_INSERT — nvarchar(14)
- ID_UPDATE — nvarchar(15)
- DTS_UPDATE — nvarchar(14)
- NM_SYSDEF_CH — nvarchar(200)
- NM_SYSDEF_JP — nvarchar(200)
- REMARK — nvarchar(100)
- NM_SYSDEF_L4 — nvarchar(200)
- NM_SYSDEF_L5 — nvarchar(200)
- NO_ORDER — nvarchar(10)
- NM_USERDEF_L1 — nvarchar(50)
- NM_USERDEF_L2 — nvarchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MA_DEPT
- CD_DEPT — nvarchar(12) — 기본 키 — NOT NULL
- CD_COMPANY — nvarchar(7) — 기본 키 — NOT NULL
- NM_DEPT — nvarchar(50) — NOT NULL
- CD_BIZAREA — nvarchar(7)
- CD_CC — nvarchar(12)
- TP_CAL — nvarchar(3)
- H_DEPT — nvarchar(12)
- NO_EMPMNG — nvarchar(10)
- SD_DEPT — nvarchar(4)
- ED_DEPT — nvarchar(4)
- DT_START — nchar(8)
- DT_END — nchar(8)
- TP_DEPT — nvarchar(3)
- LB_DEPT — numeric(3, 0)
- YN_REST — nchar(1)
- ID_INSERT — nvarchar(15)
- DTS_INSERT — nvarchar(14)
- ID_UPDATE — nvarchar(15)
- DTS_UPDATE — nvarchar(14)
- CD_DEPT_MAP — nvarchar(12)
- NM_DEPT_MAP — nvarchar(50)
- EN_DEPT — nvarchar(100)
- DC_RMK1 — nvarchar(500)
- DC_RMK2 — nvarchar(500)
- CD_ACCOUNT — nvarchar(3)
- CD_BGDEPT_MAP — nvarchar(20)
- CD_USER1 — nvarchar(3)
- CD_USER2 — nvarchar(3)
- NM_DEPT_L1 — nvarchar(50)
- NM_DEPT_L2 — nvarchar(50)
- NM_DEPT_L3 — nvarchar(50)
- NM_DEPT_L4 — nvarchar(50)
- NM_DEPT_L5 — nvarchar(50)
- CD_LEVEL — nvarchar(4)
- NO_SORT — nvarchar(20)
- NO_TEL — nvarchar(15)
- NO_FAX — nvarchar(15)
- CD_USERDEF3 — nvarchar(20)
- CD_USERDEF4 — nvarchar(20)
- NM_USERDEF2 — nvarchar(100)
- NM_USERDEF3 — nvarchar(100)
- NM_USERDEF4 — nvarchar(100)
- CD_AREA — nvarchar(7)
- NO_POST_RES — nvarchar(15)
- DC_ADDRESS_RES1 — nvarchar(500)
- DC_ADDRESS_RES2 — nvarchar(500)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MA_EMP
- NO_EMP — nvarchar(10) — 기본 키 — NOT NULL
- CD_COMPANY — nvarchar(7) — 기본 키 — NOT NULL
- NM_KOR — nvarchar(40)
- NM_ENG — nvarchar(40)
- NM_CHIN — nvarchar(40)
- CD_BIZAREA — nvarchar(7)
- CD_CC — nvarchar(12)
- CD_DEPT — nvarchar(12)
- CD_DDEPT — nvarchar(12)
- CD_PLANT — nvarchar(7)
- CD_WC — nvarchar(7)
- TP_EMP — nvarchar(3)
- CD_EMP — nvarchar(3)
- CD_DUTY_RANK — nvarchar(3)
- CD_DUTY_STEP — nvarchar(3)
- CD_PAY_STEP — nvarchar(6)
- CD_DUTY_RESP — nvarchar(3)
- CD_DUTY_WORK — nvarchar(3)
- CD_DUTY_TYPE — nvarchar(3)
- CD_JOB_SERIES — nvarchar(3)
- CD_SCH_CAREER — nvarchar(3)
- NO_RES — nvarchar(200)
- CD_SEX — nvarchar(3)
- DT_GENTER — nchar(8)
- DT_ENTER — nchar(8)
- DT_RETIRE — nchar(8)
- DT_BRETIRE — nchar(8)
- CD_INCOM — nvarchar(3)
- DT_PROBAT — nchar(8)
- NO_POST_RES — nvarchar(15)
- DC_ADDRESS_RES1 — nvarchar(400)
- DC_ADDRESS_RES2 — nvarchar(400)
- NO_POST_CUR — nvarchar(15)
- DC_ADDRESS_CUR1 — nvarchar(400)
- DC_ADDRESS_CUR2 — nvarchar(400)
- NO_POST_NAT — nvarchar(15)
- DC_ADDRESS_NAT1 — nvarchar(400)
- DC_ADDRESS_NAT2 — nvarchar(400)
- NO_TEL — nvarchar(20)
- NO_TEL_EMER — nvarchar(20)
- DT_BIRTH — nchar(8)
- CD_DAY — nvarchar(3)
- CD_PART — nvarchar(3)
- NO_EMAIL — nvarchar(100)
- CD_PJT — nvarchar(20)
- GRD_BOHUN — nvarchar(3)
- CD_BLOOD — nvarchar(3)
- CD_BOHUN — nvarchar(3)
- DC_NAT_COME — nvarchar(50)
- DC_HISTO_SICK — nvarchar(20)
- CD_MSERVICE — nvarchar(3)
- CD_YET_WHY — nvarchar(3)
- NM_FAMILY — nvarchar(20)
- CD_FAMILY_RELA — nvarchar(3)
- DT_DISCHAR — nchar(8)
- CD_BOHUN_RELA — nvarchar(3)
- CD_HANDI — nvarchar(3)
- CD_RES — nvarchar(3)
- DT_RECRUIT — nchar(8)
- NUM_WEIGHT — numeric(4, 0)
- … +206
Massro Member (member)
- ID — varchar(50) — 기본 키 — NOT NULL
- idx — int — NOT NULL
- Password — varchar(20)
- Name — varchar(20)
- F_right — char(1)
- Grp_Name — varchar(255)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
NEOE.NEOE.HR_WTMCALC
- CD_COMPANY — nvarchar(7) — 기본 키 — NOT NULL
- NO_EMP — nvarchar(10) — 기본 키 — NOT NULL
- DT_WORK — nvarchar(8) — 기본 키 — NOT NULL
- CD_BIZAREA — nvarchar(7) — NOT NULL
- CD_WEEK — nvarchar(3)
- CD_HOLY — nvarchar(3)
- CD_WORK — nvarchar(3)
- CD_WCODE — nvarchar(3)
- CD_PART — nvarchar(3)
- CD_TMCODE — nvarchar(3)
- TP_EMP — nvarchar(3)
- CD_EMP — nvarchar(3)
- CD_DEPT — nvarchar(12)
- CD_DUTY_RANK — nvarchar(3)
- CD_CC — nvarchar(12)
- CD_PJT — nvarchar(20)
- CD_PLANT — nvarchar(7)
- CD_WC — nvarchar(7)
- CD_START — nvarchar(3)
- TM_START — nvarchar(6)
- CD_CLOSE — nvarchar(3)
- TM_CLOSE — nvarchar(6)
- TM_LATE — numeric(6, 0)
- TM_EARLY — numeric(6, 0)
- TM_OUT — numeric(6, 0)
- TM_MOR — numeric(6, 0)
- TM_NORMAL — numeric(6, 0)
- TM_EVENING — numeric(6, 0)
- TM_NIGHT — numeric(6, 0)
- TM_MIDNIGHT — numeric(6, 0)
- TM_ALLNIG — numeric(6, 0)
- AM_DAY — numeric(17, 4)
- DC_RMK — nvarchar(200)
- DTS_INSERT — nvarchar(14)
- ID_INSERT — nvarchar(15)
- DTS_UPDATE — nvarchar(14)
- ID_UPDATE — nvarchar(15)
- CD_DUTY_RESP — nvarchar(3)
- CD_CHK — char(1)
- CD_ERR — varchar(3)
- CD_ERR_CHK — char(1)
- DY_WOCCUR — numeric(5, 2)
- DY_MOCCUR — numeric(5, 2)
- FG_CLOSE — nvarchar(1)
- TM_OUT_EX — numeric(6, 0)
- TM_BTWORK — numeric(6, 0)
- CD_START2 — nvarchar(3)
- TM_START2 — nvarchar(6)
- CD_CLOSE2 — nvarchar(3)
- TM_CLOSE2 — nvarchar(6)
- TM_NORMAL2 — numeric(6, 0)
- TM_NIGHT2 — numeric(6, 0)
- TM_ALLNIG2 — numeric(6, 0)
- YN_EAT — nvarchar(1)
- TM_BREAK — numeric(6, 0)
- DC_DELYI — nvarchar(3)
- AM_PAY100 — numeric(17, 4)
- AM_PAY200 — numeric(17, 4)
- AM_PAY300 — numeric(17, 4)
- AM_PAY400 — numeric(17, 4)
- … +18
Outcome
- OutcomeID — int — 기본 키 — NOT NULL
- Year — int — NOT NULL
- HalfYearly — tinyint — NOT NULL
- EmpNo — char(10) — NOT NULL
- EmpName — nvarchar(20) — NOT NULL
- DeptID — char(10) — NOT NULL
- DeptName — nvarchar(20) — NOT NULL
- PositionID — char(3) — NOT NULL
- PositionName — nvarchar(20) — NOT NULL
- PositionDegree — char(3) — NOT NULL
- IsDept — bit — NOT NULL
- RegDate — datetime
- GoalSubmitDate — datetime
- GoalApprovalDate — datetime
- EsatimationSubmitDate — datetime
- EsatimationApprovalDate — datetime
- LastAdjustmentDate — datetime
- LastGrade — char(1)
- LastScore — float
- LastComment — nvarchar(1000) — varchar(1000) NUL
- State — smallint — NOT NULL
- IsDelete — bit — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
OutcomeType
- Year — int — 기본 키 — NOT NULL
- HalfYearly — tinyint — 기본 키 — NOT NULL
- GoalStartDate — smalldatetime — NOT NULL
- GoalEndDate — smalldatetime — NOT NULL
- EsatimationStartDate — smalldatetime — NOT NULL
- EsatimationEndDate — smalldatetime — NOT NULL
- IsApply — bit — NOT NULL
- IsEndEsatimation — bit — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Outcome_New
- Year — int — 기본 키 — NOT NULL
- EmpNo — char(10) — 기본 키 — NOT NULL
- GoalSeq — int — 기본 키 — NOT NULL
- GoalTitle — nvarchar(500) — NOT NULL
- GoalWeight — int — NOT NULL
- FirstComment — nvarchar(1000) — varchar(1000) NUL
- FirstScore — float
- SecondComment — nvarchar(1000) — varchar(1000) NUL
- SecondScore — float
- IsSubmit — bit — NOT NULL
- CreateDate — datetime
- UpdateDate — datetime
- IsFCmtSubmit — bit — NOT NULL
- IsSCmtSubmit — bit — NOT NULL
- FirstEmp — nvarchar(10)
- SecondEmp — nvarchar(10)
- f_flag — bit
- GoalFigure — float
- ResultFigure — float
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TSS 유저정보 (ERPDB_CONSULTING_MEMBER)
- USERID — nvarchar(64) — 기본 키 — NOT NULL
- USERNAME — nvarchar(64)
- USEREMAIL — nvarchar(64)
- USERPWD — nvarchar(64)
- TSSLEVELCODE — nvarchar(16)
- EXTLEVELCODE — nvarchar(16)
- USEYN — nvarchar(1)
- ADINFO — nvarchar(1)
- AUTHID — nvarchar(64)
- AUTHDATE — datetime
- USERTELEPHONE — nvarchar(64)
- USERMOBILE — varchar(64)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
경력사항 (ERPDB_career)
- C_CODE — char(4) — NOT NULL
- SNO — varchar(10) — NOT NULL
- FDATE — char(8) — NOT NULL
- TDATE — char(8)
- COMPANY — nvarchar(50)
- JICNAME — nvarchar(50)
- JICMUNAME — nvarchar(80)
- RETIRE_GU — nvarchar(80)
- GROSS_AMT — numeric(13, 0)
- BON_RATE — numeric(10, 0)
- ECOMPANY — varchar(30)
- JICENAME — varchar(20)
- JICMUENAME — varchar(20)
- RETIRE_EGU — varchar(20)
- LAST_DUTY_RANK — varchar(20)
근태정보 (HR_WTMCALC)
- SNO — char(6) — 기본 키 — NOT NULL
- BASE_DATE — char(10) — 기본 키 — NOT NULL
- DEPT_CODE — char(7)
- FG_HOLY — varchar(10)
- FG_GUN — varchar(10)
- FG_DAY — varchar(2)
- GUN_CODE — varchar(20)
- REASON — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
내선번호 (office_tel_num)
- sno — varchar(6) — NOT NULL
- tel_num — varchar(20)
리프레시 휴가 (ERPDB_REFRESH)
- SNO — varchar(10) — 기본 키 — NOT NULL
- KNAME — varchar(20)
- DC_RMK3 — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
발자국 현황 (Fasoo_Commute)
- Idx — int — 기본 키 — NOT NULL
- ID — int — NOT NULL
- BusinessEmail — nvarchar(50) — NOT NULL
- Name — nvarchar(50)
- UserID — int
- CommuteType — int — NOT NULL
- CommuteOperation — nchar(10)
- DateAccessed — datetime
- DateCreated — datetime
- DateCustomized — datetime
- DateSynchronized — datetime
- DateUpdated — datetime
- UpdateSequenceNumber — int
- NoteID — int
- NoteActionType — int
- NoteStatus — int
- NoteType — int
- NoteBody — text
- NoteLatitude — float
- NoteLongitude — float
- LocationInlineTagGuid — nvarchar(50)
- LocationInlineTagLatitude — float
- LocationInlineTagLongitude — float
- LocationInlineTagName — nvarchar(50)
- LocationInlineTagAddress — nvarchar(200)
- INLINGUID — nvarchar(50)
- NoteUpdateLatitude — float
- NoteUpdateLongitude — float
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
본부 및 부서정보 (ERPDB_standard_dept)
- C_CODE — varchar(4) — NOT NULL
- NODE_CODE — varchar(4) — NOT NULL
- DEPT_CODE — varchar(12) — NOT NULL
- DEPT_NAME — varchar(300)
- BOSS_NAME — varchar(160)
- AGG_DEPT — varchar(12)
- CD_BUMUN — varchar(4)
- FDATE — varchar(8)
- TDATE — varchar(8)
- JOB_ID — varchar(10)
- JOB_DAY — varchar(8)
- JOB_TIME — varchar(8)
- DEPT_ENAME — varchar(40)
- DC_RMK — varchar(100)
사내 수상 정보 (ERPDB_PRIZE)
- C_CODE — char(4) — NOT NULL
- CD_PRIZE — varchar(3) — NOT NULL
- SNO — varchar(10) — NOT NULL
- FG_PRIZE — char(1) — NOT NULL
- NODE_CODE — varchar(4) — NOT NULL
- DEPT_CODE — varchar(12)
- DUTY_RANK — varchar(3)
- FDATE — char(8) — NOT NULL
- TDATE — char(8)
- CD_GRADE — varchar(3)
- YN_GRADE — varchar(3)
- DETAIL_PRIZE — varchar(30)
- AMT_PRIZE — numeric(13, 0)
- PAYFROM — char(6)
- PAYSEQ — char(1)
- PAYONE — numeric(13, 0)
- BAL_PRIZE — numeric(13, 0)
- AMT_DOWN — numeric(13, 0)
- POINT_INSA — numeric(4, 0)
- PROPOSE — varchar(20)
- NOMINAL — varchar(20)
- GIVENER — varchar(20)
- REASON — varchar(80)
- REMARK — varchar(40)
- AMT_STOCK — numeric(9, 0)
사내 동아리 (ERPDB_CLUB)
- CD_COMPANY — char(4) — NOT NULL
- NO_EMP — char(6) — NOT NULL
- NM_KOR — nvarchar(50) — NOT NULL
- CD_UNIT — nvarchar(20) — NOT NULL
- NM_UNIT — nvarchar(100) — NOT NULL
- IN_DATE — char(10)
- OUT_DATE — char(10)
시차출퇴근 신청 (Fasoo_Flexitime)
- SNO — nvarchar(30)
- EMP_NAME — nvarchar(50)
- DEPT_CODE — varchar(10)
- GUBUN — nvarchar(10)
- PUNCHIN — nvarchar(30)
- PUNCHOUT — nvarchar(30)
- POLICY — int
- date_from — nvarchar(30)
- date_to — nvarchar(30)
- rmk — nvarchar(1000)
- lastupdate — datetime
- updateUser — nvarchar(100)
- ok_yn — char(1)
- IDX — int — NOT NULL
연차 지급일 수 정보 (ERPDB_pyyhday)
- C_CODE — char(4) — NOT NULL
- P_YY — char(4) — NOT NULL
- SNO — varchar(10) — NOT NULL
- KIJUN_DATE — varchar(8)
- GULGUN_FROM — varchar(8)
- GULGUN_TO — varchar(8)
- GULGUN_IL — numeric(4, 1)
- HDAY_BAL — numeric(4, 1)
- HDAY_JOJ — numeric(4, 1)
- HDAY_CURR — numeric(4, 1)
- HDAY_JUCHI — numeric(4, 1)
- HDAY_JUNG — numeric(4, 1)
- JUNG_YYMM — varchar(6)
- FG_PAYBON — varchar(1)
- SEQ — numeric(1, 0)
- NODE_CODE — varchar(4)
- DEPT_CODE — varchar(12)
- DUTY_RANK — varchar(3)
- ENTER_DATE — varchar(8)
- IR_DATE — varchar(8)
- PRE_IWOL — numeric(4, 1)
- JUNG_GU — char(1)
- ADDYEAR — numeric(4, 1)
외국어 자격증 취득 정보 (ERPDB_FORELANG)
- NO_EMP — nvarchar(10) — NOT NULL
- CD_COMPANY — nvarchar(7) — NOT NULL
- NO_SEQ — numeric(7, 0) — NOT NULL
- CD_FLANG — nvarchar(3)
- NM_FLANG — nvarchar(40)
- NM_GRADE — nvarchar(40)
- DT_VALU — nvarchar(8)
- PT_EPI — numeric(5, 2)
- NM_ISSUE — nvarchar(40)
- DC_RMK — nvarchar(50)
- DTS_INSERT — nvarchar(14)
- ID_INSERT — nvarchar(15)
- DTS_UPDATE — nvarchar(14)
- ID_UPDATE — nvarchar(15)
- CD_ISSUE — nvarchar(3)
- MEMO_CD — nvarchar(20)
- CHECK_PEN — nvarchar(20)
- CD_FEDU — nvarchar(3)
- PT_FSCORE1 — numeric(7, 2)
- PT_FSCORE2 — numeric(7, 2)
- PT_FSCORE3 — numeric(7, 2)
- PT_TOT — numeric(7, 2)
- PT_AVER — numeric(7, 2)
- CD_QUALI_GRD — nvarchar(3)
- NM_SYSDEF — nvarchar(50)
- DC_GRD — nvarchar(20)
외부 교육 + 사외교육신청서 정보 (ERPDB_EDUCATION)
- C_CODE — char(4) — NOT NULL
- FG_EDUC — varchar(5) — NOT NULL
- CD_EDUC — varchar(3) — NOT NULL
- EDUC_YY — char(4) — NOT NULL
- SEQ_EDUC — varchar(3) — NOT NULL
- SNO — varchar(10) — NOT NULL
- FDATE — char(8)
- TDATE — char(8)
- EDUC_TIME — varchar(30)
- GRADE_EDUC — varchar(3)
- EDU_COST — numeric(13, 0)
- CD_ORG — varchar(40)
- FG_PASS — varchar(5)
- TOT_MARK — numeric(4, 0)
- NM_EDU — varchar(200)
- WF — bit
- WF_ID — int
인사발령 (ERPDB_INSABAL_D)
- C_CODE — char(4) — NOT NULL
- BAL_H — varchar(10) — NOT NULL
- SNO — char(12) — NOT NULL
- STATE — char(1)
- BAL_GUBUN — varchar(3)
- BAL_DATE — varchar(8)
- CANCEL_DATE — varchar(8)
- REFERENCE — varchar(100)
- PRE_BAN — varchar(8)
- PRE_NODE — varchar(4)
- PRE_DEPT — varchar(12)
- PRE_NODE2 — varchar(4)
- PRE_DEPT2 — varchar(12)
- PRE_POSITION — char(3)
- PRE_DUTY — char(3)
- PRE_DUTY_WORK — varchar(3)
- PRE_GRADE — char(3)
- PRE_HOBONG — char(3)
- PRE_MIMT — numeric(13, 0)
- PRE_DIMT — numeric(13, 0)
- PRE_IIMT — numeric(8, 2)
- PRE_YIMT — numeric(13, 0)
- AFTER_NODE — varchar(4)
- AFTER_DEPT — varchar(12)
- AFTER_NODE2 — varchar(4)
- AFTER_DEPT2 — varchar(12)
- AFTER_POSITION — char(3)
- AFTER_DUTY — char(3)
- AFTER_DUTY_WORK — varchar(3)
- AFTER_GRADE — char(3)
- AFTER_HOBONG — char(3)
- AFTER_MIMT — numeric(13, 0)
- AFTER_DIMT — numeric(13, 0)
- AFTER_IIMT — numeric(8, 2)
- AFTER_YIMT — numeric(13, 0)
- KIGAN1 — varchar(8)
- KIGAN2 — varchar(8)
- REASON — varchar(30)
- PAY_GUBUN — char(1)
- RETIRE_GUBUN — char(1)
- NEXT_BODATE — varchar(8)
- BO_GUBUN — varchar(2)
인사발령_신규테이블 (ERPDB_BAL_NEW)
- NM_ANCODE — varchar(100)
- NO_EMP — char(8)
- NO_AN — char(10)
- DT_WRITE — char(8)
- BEFAN_CD_BIZAREA — char(4)
- NM_AN — varchar(500)
- DT_AN — char(810)
인사평가 (ERPDB_ESTIMATE)
- C_CODE — char(4) — NOT NULL
- SNO — varchar(10) — NOT NULL
- YY — char(4) — NOT NULL
- GUBUN — char(1) — NOT NULL
- ESTSNO — varchar(10)
- ABILITY — varchar(5)
- UPJUCK — varchar(5)
- QUALITY — varchar(5)
- ESTHAP — numeric(5, 2)
- GRADE — varchar(10)
- JOCHI — nvarchar(2000)
- NUM_4 — varchar(5)
- NUM_5 — varchar(5)
임직원 정보 (ERPDB_perinfo)
- SNO — varchar(10) — 기본 키 — NOT NULL
- C_CODE — char(4) — NOT NULL
- KNAME — varchar(40)
- HNAME — varchar(40)
- ENAME — varchar(40)
- DUTY_RANK — varchar(6)
- DUTY_STEP — varchar(6)
- HOBONG — varchar(6)
- DUTY_RESP — varchar(6)
- DUTY_WORK — varchar(6)
- DEPT_CODE — nvarchar(12)
- NODE_CODE — varchar(8)
- DUTY_TYPE — varchar(6)
- DUTY_JONG — varchar(6)
- ENTER_YN — varchar(6)
- EMPLOY_GU — varchar(6)
- GISU — varchar(6)
- SCH_CAREER — varchar(6)
- JUMINO — char(13)
- SEX_GU — varchar(63)
- BIRTHDAY — char(16)
- BIRTH_YN — varchar(6)
- MARRY_DATE — char(16)
- G_IDATE — char(16)
- IDATE — char(16)
- RDATE — char(16)
- RSDATE — char(16)
- RETIRE_WHY — varchar(3)
- JAEJIK_GU — varchar(3)
- SSDATE — char(8)
- BALDATE — char(8)
- BODATE — char(8)
- PFDATE — char(8)
- PTDATE — char(8)
- HFDATE — char(8)
- HTDATE — char(8)
- HUJIK_WHY — varchar(6)
- HOME_SIDO — varchar(20)
- HOME_ORG — varchar(20)
- PERADDR — varchar(160)
- JUMINPOST — varchar(12)
- JUMINADDR — varchar(2000)
- CURPOST — varchar(12)
- CURADDR — varchar(2000)
- TEL_NO — varchar(36)
- SIGNET — varchar(36)
- HOJU_NAME — varchar(32)
- HOJU_RELA — varchar(6)
- SEDAE_NAME — varchar(32)
- SEDAE_RELA — varchar(6)
- ARM_DUTY — varchar(6)
- UN_WHY — varchar(6)
- MIDATE — char(16)
- MRDATE — char(16)
- ARM_KIND — varchar(6)
- DISCHARGE — varchar(6)
- BRANCH_ARM — varchar(6)
- RANK_CLASS — varchar(6)
- SOLDIER_NO — varchar(30)
- P_HEIGHT — float
- … +70
자격증 (ERPDB_LICENSE)
- C_CODE — nvarchar(7) — NOT NULL
- SNO — nvarchar(10) — NOT NULL
- LDATE — nchar(8) — NOT NULL
- QUALI_CODE — nvarchar(4)
- GRADE_CODE — nvarchar(3)
- QUALI_NO — nvarchar(20)
- CHECK_YN — nvarchar(3)
- TDATE — nchar(8)
- ORGAN — nvarchar(40)
- REMARK — varchar(20)
학위정보 (ERPDB_SCHOCARE)
- C_CODE — char(4) — NOT NULL
- SNO — varchar(10) — NOT NULL
- FDATE — char(8)
- TDATE — char(8)
- SCH_CODE — varchar(4)
- SCH_NAME — varchar(50)
- SCH_CAREER — varchar(4)
- SCH_SECTOR — varchar(4)
- MAJOR_CODE — varchar(4)
- MAJOR_NAME — varchar(60)
- SUB_MAJOR — varchar(4)
- SUB_NAME — varchar(60)
- GRADU_YN — varchar(4)
- DR_LEVEL — varchar(4)
- BON_GUBUN — varchar(4)
- REMARK — varchar(60)
- SCH_ENAME — varchar(20)
- GRADU_KOR — varchar(20)
- NM_DOB_MAJOR — varchar(60)
휴가신청 (req_holiday)
- noidx — int — 기본 키 — NOT NULL
- req_date — char(10) — NOT NULL
- req_emp — varchar(50) — NOT NULL
- day_from — char(10) — NOT NULL
- day_to — char(10) — NOT NULL
- gubn — varchar(2) — NOT NULL
- holiday — decimal(5, 1)
- reason — varchar(300)
- ok_yn — char(1)
- ok_date — char(10)
- ok_emp — varchar(50)
- ok_reason — varchar(300)
- mana_yn — char(1)
- mana_date — datetime
- ok_gubn — char(1)
- hu_reason — varchar(300)
- mail_list — varchar(2000)
- message — varchar(5000)
- can_date — char(10)
- can_emp — varchar(10)
- can_reason — varchar(1000)
- file_name — varchar(5000)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =