인사관리 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 — =