GRIMS

Tables (7)

MST_PGT01_STOP_CODE_KB (저해요인 코드 마스터)

  • CODE_TYPE (Key) — VARCHAR(01) — Primary key — NOT NULL — 데이터 유형
  • PG01K01 (Key2) — CHAR(1) — Primary key — NOT NULL — 레벨
  • PG01K05 (Key3) — VARCHAR(1) — Primary key — NOT NULL — 대분류코드
  • PG01K03 (Field2) — VARCHAR(2) — 중분류
  • PG01K04 (Field3) — VARCHAR(3) — 소분류 코드
  • PG01K05 (Field5) — VARCHAR(6) — 중단내역(재분류)
  • PG01K06 (Field6) — VARCHAR(30) — 중단내역(중분류)
  • PG01K07 (Field8) — VARCHAR(30) — 중단내역(중분류)
  • PG01K08 (Field9) — VARCHAR(30) — 중단내역(소분류)
  • PLAN_ADJ (Field10) — CHAR(1) — 계획조정 적용
  • YET_IN_ADJ (Field11) — CHAR(1) — 미투입 조정
  • OP_ADJ (Field12) — CHAR(1) — 미가동 적용
  • ACCEPT (Field13) — CHAR(1) — 인정중단 적용
  • EQU_ISSUE (Field14) — CHAR(1) — 장비공장 적용
  • ROW_ID (Field15) — NUMBER — 가동종합
  • ROW_SUM (Field16) — NUMBER — 가종종합 SUB
  • ROW_REC1 (Field17) — NUMBER
  • ROW_REC2 (Field18) — NUMBER
  • ROW_REC3 (Field19) — NUMBER
  • ROW_REC4 (Field20) — NUMBER
  • PG01K96 (Field) — VARCHAR(20) — 입력일자
  • PG01K97 (Field4) — CHAR(8) — 입력사번
  • PG01K98 (Field7) — VARCHAR(20) — 수정일자
  • PG01K99 (Field21) — CHAR(8) — 수정사번
  • PG01K09 (Field22) — CHAR(1) — 프레스 적용
  • PG01K10 (Field23) — CHAR(1) — 소재적용
  • PG01K11 (Field24) — VARCHAR(8) — 적용시작일
  • PG01K12 (Field25) — VARCHAR(8) — 적용완료일
  • PG01K13 (Field26) — CHAR(1) — 적용예비4

MST_PGT01_STOP_MAPPING (저해요인 코드 매핑)

  • CATEGORY (Key) — VARCHAR(05) — Primary key — 데이터 유형
  • VERSION (Key2) — CHAR(02) — Primary key — 레벨
  • CODE_TYPE (Key3) — VARCHAR(1) — Primary key — 대분류코드
  • PG01K01 (Key5) — CHAR(1) — Primary key — NOT NULL — 레벨
  • PG01K02 (Key6) — CHAR(1) — Primary key — NOT NULL — 대분류
  • PG01K03 (Key7) — VCHAR(2) — Primary key — NOT NULL — 중분류
  • PG01K04 (Key8) — VCHAR(3) — Primary key — NOT NULL — 소분류
  • CODE_TYPE (Key4) — VARCHAR(01) — Foreign key → MST_PGT01_STOP_CODE_KB.CODE_TYPE — NOT NULL — 데이터 유형
  • PG01K01 (Key22) — CHAR(1) — Foreign key → MST_PGT01_STOP_CODE_KB.PG01K01 — NOT NULL — 레벨
  • PG01K05 (Key32) — VARCHAR(1) — Foreign key → MST_PGT01_STOP_CODE_KB.PG01K05 — NOT NULL — 대분류코드
  • PG01K05 (Field6) — VARCHAR(02) — NOT NULL — 분류코드 (EX, 중단현황=A)
  • PG01K06 (Field8) — NUMBER — NOT NULL — 순서

PGT05_PROD_HISTORY_BB (가동률 실적)

  • PG05B01 (Key) — CHAR(8) — Primary key — NOT NULL — 실적 조업일
  • PG05B03 (Key3) — CHAR(1) — Primary key — NOT NULL
  • ERP_KEY (Key2) — VARCHAR(27) — Primary key — NOT NULL — ERP KEY
  • SHOP (Field7) — VARCHAR(1) — SHOP
  • LINE (Field8) — VARCHAR(10) — 라인번호
  • PG05B04 (Field15) — NUMBER(3) — 작업시간(가동형태)
  • PG05B05 (Field16) — NUMBER(5) — 작업시간(정규)
  • PG05B06 (Field17) — NUMBER(5) — 작업시간(잔업)
  • PG05B07 (Field18) — NUMBER(5) — 휴식(1 SHIFT)
  • PG05B08 (Field19) — NUMBER(5) — 특근(1 SHIFT)
  • PG05B10 (Field20) — NUMBER(5) — 특근생산계획(1 SHIFT)
  • PG05B11 (Field21) — NUMBER(3) — 조업형태(2 SHIFT)
  • PG05B12 (Field22) — NUMBER(3) — 정규(2 SHIFT)
  • PG05B09 (Field23) — NUMBER(5) — 잔업(2 SHIFT)
  • PG05B13 (Field24) — NUMBER(5) — 휴식(2 SHIFT)
  • YET_IN_ADJ_REGULAR (Field25) — NUMBER(5) — 특근(2 SHIFT)
  • YET_IN_ADJ_OVER (Field26) — NUMBER(5) — 특근생산계획(2 SHIFT)
  • YET_IN_ADJ_EXTRA (Field27) — NUMBER(5) — 조업형태(3 SHIFT)
  • OP_ADJ_TTL (Field28) — NUMBER(5) — 정규(3 SHIFT)
  • OP_ADJ_REGUALR (Field29) — NUMBER(5) — 잔업(3 SHIFT)
  • OP_ADJ_OVER (Field30) — NUMBER(5) — 휴식(3 SHIFT)
  • OP_ADJ_EXTRA (Field31) — NUMBER(5) — 특근(3 SHIFT)
  • PG05B14 (Field32) — NUMBER(5) — 특근생산계획(3 SHIFT)
  • ACCEPT_STOP_NORMAL (Field) — NUMBER(5) — GROSS
  • ACCEPT_STOP_EXTRA (Field33) — NUMBER(5) — 총가동분
  • ACCEPT_STOP_EXTRA (Field34) — NUMBER(5) — 최대능력
  • PG05B15 (Field35) — NUMBER(5) — 운영능력(TTL)
  • PG05B16 (Field36) — NUMBER(5) — 운영능력(정규)
  • PG05B17 (Field37) — NUMBER(5) — 운영능력(잔업)
  • PROD_IN_REGULAR (Field38) — NUMBER(5) — 운영능력(특근)
  • PROD_IN_OVER (Field39) — NUMBER(5) — 운영능력(평일)
  • PROD_IN_EXTRA (Field40) — NUMBER(5) — 운영가동률
  • PROD_OUT_TTL (Field41) — NUMBER(5) — 목표가동률
  • PROD_OUT_REGULAR (Field42) — NUMBER(5) — T/T'
  • PROD_OUT_OVER (Field43) — NUMBER(5) — UPH
  • PROD_IN_EXTRA (Field44) — NUMBER(5) — 작업형태(1 SHFT)
  • PATTERN (Field45) — VARCHAR(5) — 작업형태(2 SHFT)
  • PG05B19 (Field46) — NUMBER(8,4) — 작업형태(3 SHFT)
  • PG05B20 (Field2) — NUMBER(8,4)
  • PG05B21 (Field3) — NUMBER(8,3)
  • PG05B22 (Field4) — NUMBER(8,3)
  • INS_USER (Field5) — VARCHAR(20)
  • INS_DATE (Field6) — CHAR(8)
  • UPD_USER (Field9) — VARCHAR(20)
  • UPD_DATE (Field10) — CHAR(8)
  • PLAN_REGULAR_TYPE (Field11) — VARCHAR(1)

PGT05_STOP_HISTORY_AB (저해요인 관리)

  • PG05A01 (Key) — VARCHAR(08) — Primary key — NOT NULL — 해당일
  • PG05A03 (Key2) — VARCHAR(1) — Primary key — NOT NULL — 주야구분
  • PG05A04 (Key3) — VARCHAR(6) — Primary key — NOT NULL — 저해요인 코드
  • PG05A05 (Key4) — NUMBER(3) — Primary key — NOT NULL — 회차1
  • PG05A06 (Key5) — NUMBER(3) — Primary key — NOT NULL — 회차2
  • ERP_KEY (Key6) — VARCHAR(27) — Primary key — NOT NULL — ERP KEY
  • CODE_TYPE (Key7) — VARCHAR(01) — Foreign key → MST_PGT01_STOP_CODE_KB.CODE_TYPE — NOT NULL — 데이터 유형
  • PG01K01 (Key22) — CHAR(1) — Foreign key → MST_PGT01_STOP_CODE_KB.PG01K01 — NOT NULL — 레벨
  • PG01K05 (Key32) — VARCHAR(1) — Foreign key → MST_PGT01_STOP_CODE_KB.PG01K05 — NOT NULL — 대분류코드
  • SHOP (Field) — VARCHAR(1) — SHOP
  • LINE (Field2) — VARCHAR(10) — LINE
  • PG05A07 (Field3) — VARCHAR(1) — 계산형태
  • PG05A08 (Field4) — VARCHAR(3) — 차종
  • PG05A09 (Field5) — VARCHAR(4) — 중단시각(FROM)
  • PG05A10 (Field6) — VARCHAR(4) — 중단시각(TO)
  • PG05A11 (Field7) — NUMBER(5) — 중단분
  • PG05A12 (Field8) — NUMBER(3) — 회수
  • PG05A13 (Field9) — NUMBER(12,4)
  • PG05A14 (Field10) — VARCHAR(20)
  • PG05A15 (Field11) — VARCHAR(4000)
  • PG05A16 (Field12) — VARCHAR(210)
  • PG05A17 (Field13) — VARCHAR(210)
  • PG05A18 (Field14) — VARCHAR(1)
  • PG05A19 (Field15) — VARCHAR(1)
  • PG05A20 (Field16) — VARCHAR(1)
  • PG05A21 (Field17) — VARCHAR(3)
  • PG05A22 (Field18) — VARCHAR(3)
  • PG05A23 (Field19) — VARCHAR(2)
  • PG05A24 (Field20) — NUMBER(10,3)
  • PG05A25 (Field21) — VARCHAR(20)
  • PG05A30 (Field22) — VARCHAR(100)
  • PG05A31 (Field23) — VARCHAR(1)
  • INS_USER (Field24) — VARCHAR(20)
  • INS_DATE (Field25) — CHAR(8)
  • UPD_USER (Field26) — VARCHAR(20)
  • UPD_DATE (Field27) — CHAR(8)
  • FIL1 (Field28) — VARCHAR(20)
  • FIL2 (Field29) — VARCHAR(20)
  • CATEGORY (Field30) — VARCHAR(1)
  • APMS_SEQ (Field31) — NUMBER(6)
  • APMS_LINE (Field32) — VARCHAR(20)

PGT06_ACTION_PLAN_CB (기동률 계획)

  • SHOP_DATE (Key) — CHAR(8) — Primary key — NOT NULL — 계획 조업일
  • ERP_KEY (Key2) — VARCHAR(27) — Primary key — NOT NULL — ERP KEY
  • ERP_CODE (Field6) — VARCHAR(5) — ERP CODE
  • SHOP (Field7) — VARCHAR(1) — SHOP
  • LINE (Field8) — VARCHAR(10) — 라인번호
  • RF_PT (Field9) — CHAR(6) — RF_PT
  • PROD_TYPE (Field10) — CHAR(1) — 가동구분
  • WORK_TYPE_1_HOUR (Field15) — NUMBER(7,3) — 조업형태(1 SHIFT)
  • WORK_TYPE_1_REGULAR_MIN (Field16) — NUMBER(7,3) — 정규(1 SHIFT)
  • WORK_TYPE_1_OVER_MIN (Field17) — NUMBER(7,3) — 잔업(1 SHIFT)
  • WORK_TYPE_1_BREAK_MIN (Field18) — NUMBER(7,3) — 휴식(1 SHIFT)
  • WORK_TYPE_1_EXTRA_MIN (Field19) — NUMBER(7,3) — 특근(1 SHIFT)
  • WORK_TYPE_1_EXTRA_PLAN (Field20) — NUMBER(7,3) — 특근생산계획(1 SHIFT)
  • WORK_TYPE_2_HOUR (Field21) — NUMBER(7,3) — 조업형태(2 SHIFT)
  • WORK_TYPE_2_REGULAR_MIN (Field22) — NUMBER(7,3) — 정규(2 SHIFT)
  • WORK_TYPE_2_OVER_MIN (Field23) — NUMBER(7,3) — 잔업(2 SHIFT)
  • WORK_TYPE_2_BREAK_MIN (Field24) — NUMBER(7,3) — 휴식(2 SHIFT)
  • WORK_TYPE_2_EXTRA_MIN (Field25) — NUMBER(7,3) — 특근(2 SHIFT)
  • WORK_TYPE_2_EXTRA_PLAN (Field26) — NUMBER(7,3) — 특근생산계획(2 SHIFT)
  • WORK_TYPE_3_HOUR (Field27) — NUMBER(7,3) — 조업형태(3 SHIFT)
  • WORK_TYPE_3_REGULAR_MIN (Field28) — NUMBER(7,3) — 정규(3 SHIFT)
  • WORK_TYPE_3_OVER_MIN (Field29) — NUMBER(7,3) — 잔업(3 SHIFT)
  • WORK_TYPE_3_BREAK_MIN (Field30) — NUMBER(7,3) — 휴식(3 SHIFT)
  • WORK_TYPE_3_EXTRA_MIN (Field31) — NUMBER(7,3) — 특근(3 SHIFT)
  • WORK_TYPE_3_EXTRA_PLAN (Field32) — NUMBER(7,3) — 특근생산계획(3 SHIFT)
  • GROSS_MIN (Field) — NUMBER(7,3) — GROSS
  • TOTAL_WORK_MIN (Field33) — NUMBER(10,3) — 총가동분
  • MAX_CAPA (Field34) — NUMBER(7,3) — 최대능력
  • OP_CAPA_TTL (Field35) — NUMBER(7,3) — 운영능력(TTL)
  • OP_CAPA_REGULAR (Field36) — NUMBER(7,3) — 운영능력(정규)
  • OP_CAPA_OVER (Field37) — NUMBER(7,3) — 운영능력(잔업)
  • OP_CAPA_EXTRA (Field38) — NUMBER(7,3) — 운영능력(특근)
  • OP_CAPA_NORMAL (Field39) — NUMBER(7,3) — 운영능력(평일)
  • OP_RATE (Field40) — NUMBER(7,3) — 운영가동률
  • TARGET (Field41) — NUMBER(7,3) — 목표가동률
  • TT (Field42) — NUMBER(8,4) — T/T'
  • UPH (Field43) — NUMBER(8,4) — UPH
  • PLAN_REGULAR_TYPE_1 (Field44) — VARCHAR(1) — 작업형태(1 SHFT)
  • PLAN_REGULAR_TYPE_2 (Field45) — VARCHAR(1) — 작업형태(2 SHFT)
  • PLAN_REGULAR_TYPE_3 (Field46) — VARCHAR(1) — 작업형태(3 SHFT)

PGT10_OP_RT_DB (기동률 집계(계획_실적))

  • PG10DYYYY (Key) — CHAR(4) — Primary key — NOT NULL — 해당일
  • PG10DMM (Key2) — CHAR(2) — Primary key — NOT NULL
  • PG10DRECDAY (Key3) — NUMBER — Primary key — NOT NULL — 저해요인 코드
  • PG10DTYPE (Key4) — CHAR(2) — Primary key — NOT NULL — 회차1
  • PG10DLEVEL (Key5) — NUMBER — Primary key — NOT NULL — 회차2
  • PG10DVER (Key6) — NUMBER — Primary key — NOT NULL — 생성버전
  • PG10DSEQ (Key7) — NUMBER — Primary key — NOT NULL — SEQ
  • PG05A01 (Key8) — VARCHAR(08) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A01 — NOT NULL — 해당일
  • PG05A03 (Key22) — VARCHAR(1) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A03 — NOT NULL — 주야구분
  • PG05A04 (Key32) — VARCHAR(6) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A04 — NOT NULL — 저해요인 코드
  • PG05A05 (Key42) — NUMBER(3) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A05 — NOT NULL — 회차1
  • PG05A06 (Key52) — NUMBER(3) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A06 — NOT NULL — 회차2
  • ERP_KEY (Key62) — VARCHAR(27) — Foreign key → PGT05_STOP_HISTORY_AB.ERP_KEY — NOT NULL — ERP KEY
  • CODE_TYPE (Key72) — VARCHAR(01) — Foreign key → PGT05_STOP_HISTORY_AB.CODE_TYPE — NOT NULL — 데이터 유형
  • PG01K01 (Key222) — CHAR(1) — Foreign key → PGT05_STOP_HISTORY_AB.PG01K01 — NOT NULL — 레벨
  • PG01K05 (Key322) — VARCHAR(1) — Foreign key → PGT05_STOP_HISTORY_AB.PG01K05 — NOT NULL — 대분류코드
  • SHOP_DATE (Key9) — CHAR(8) — Foreign key → PGT06_ACTION_PLAN_CB.SHOP_DATE — NOT NULL — 계획 조업일
  • ERP_KEY (Key23) — VARCHAR(27) — Foreign key → PGT06_ACTION_PLAN_CB.ERP_KEY — NOT NULL — ERP KEY
  • PG05B01 (Key10) — CHAR(8) — Foreign key → PGT05_PROD_HISTORY_BB.PG05B01 — NOT NULL — 실적 조업일
  • PG05B03 (Key33) — Foreign key → PGT05_PROD_HISTORY_BB.PG05B03 — NOT NULL
  • ERP_KEY (Key24) — VARCHAR(27) — Foreign key → PGT05_PROD_HISTORY_BB.ERP_KEY — NOT NULL — ERP KEY
  • SHOP_DATE (Key34) — CHAR(8) — Foreign key → PGT10__OP_STOP_DB.SHOP_DATE — NOT NULL — 조업일자
  • CATEGORY (Key43) — VARCHAR(1) — Foreign key → PGT10__OP_STOP_DB.CATEGORY — NOT NULL — 계열
  • LOCATION (Key11) — VARCHAR(1) — Foreign key → PGT10__OP_STOP_DB.LOCATION — NOT NULL — 지역
  • COMPANY (Key25) — VARCHAR(10) — Foreign key → PGT10__OP_STOP_DB.COMPANY — NOT NULL — 법인
  • AREA (Key53) — VARCHAR(10) — Foreign key → PGT10__OP_STOP_DB.AREA — NOT NULL — 지역
  • PLANT (Key63) — VARCHAR(5) — Foreign key → PGT10__OP_STOP_DB.PLANT — NOT NULL — 공장번호
  • ERP_CODE (Key73) — VARCHAR(5) — Foreign key → PGT10__OP_STOP_DB.ERP_CODE — NOT NULL — ERP CODE
  • SHOP (Key82) — VARCHAR(1) — Foreign key → PGT10__OP_STOP_DB.SHOP — NOT NULL — SHOP
  • LINE (Key92) — VARCHAR(10) — Foreign key → PGT10__OP_STOP_DB.LINE — NOT NULL — LINE
  • DG (Key102) — CHAR(2) — Foreign key → PGT10__OP_STOP_DB.DG — NOT NULL — DG
  • LEVEL (Key112) — NUMBER — Foreign key → PGT10__OP_STOP_DB.LEVEL — NOT NULL — LEVEL
  • PG05A19 (Key12) — VARCHAR(30) — Foreign key → PGT10__OP_STOP_DB.PG05A19 — NOT NULL — 자타공정 구분
  • PG05A23 (Key13) — VARCHAR(5) — Foreign key → PGT10__OP_STOP_DB.PG05A23 — NOT NULL — 저해요인 코드_중분류
  • PG05A04 (Key14) — VARCHAR(10) — Foreign key → PGT10__OP_STOP_DB.PG05A04 — NOT NULL — 저해요인 코드_소분류
  • PG05A01 (Key15) — VARCHAR(08) — Foreign key → PGT10__OP_STOP_DB.PG05A01 — NOT NULL — 해당일
  • PG05A03 (Key223) — VARCHAR(1) — Foreign key → PGT10__OP_STOP_DB.PG05A03 — NOT NULL — 주야구분
  • PG05A04 (Key323) — VARCHAR(6) — Foreign key → PGT10__OP_STOP_DB.PG05A04 — NOT NULL — 저해요인 코드
  • PG05A05 (Key422) — NUMBER(3) — Foreign key → PGT10__OP_STOP_DB.PG05A05 — NOT NULL — 회차1
  • PG05A06 (Key522) — NUMBER(3) — Foreign key → PGT10__OP_STOP_DB.PG05A06 — NOT NULL — 회차2
  • ERP_KEY (Key622) — VARCHAR(27) — Foreign key → PGT10__OP_STOP_DB.ERP_KEY — NOT NULL — ERP KEY
  • CODE_TYPE (Key722) — VARCHAR(01) — Foreign key → PGT10__OP_STOP_DB.CODE_TYPE — NOT NULL — 데이터 유형
  • PG01K01 (Key2222) — CHAR(1) — Foreign key → PGT10__OP_STOP_DB.PG01K01 — NOT NULL — 레벨
  • PG01K05 (Key3222) — VARCHAR(1) — Foreign key → PGT10__OP_STOP_DB.PG01K05 — NOT NULL — 대분류코드
  • CATEGORY (Field2) — VARCHAR(1) — 계열
  • LOCATION (Field3) — VARCHAR(1) — 지역
  • COMPANY (Field71) — VARCHAR(10) — 법인
  • AREA (Field4) — VARCHAR(10) — 차종
  • PLANT (Field5) — VARCHAR(5) — 공장번호
  • ERP_CODE (Field6) — VARCHAR(5) — ERP CODE
  • SHOP (Field7) — VARCHAR(1) — SHOP
  • LINE (Field8) — VARCHAR(10) — 라인번호
  • PG10DDISPLAY (Field9) — CHAR(1) — 사용여부
  • PG10DEA (Field10) — CHAR(2) — 시간계(TI),대수계(EA),개수계(NO)구분
  • PG10DRECSUB (Field11) — NUMBER — 서브코드
  • PG10DMODEL (Field12) — CHAR(3) — 차종
  • PG10DKFL1 (Field13) — NUMBER — 여유1
  • PG10DKFL2 (Field14) — VARCHAR(30) — 여유2
  • WORK_TYPE1_1 (Field15) — NUMBER(12,4) — 가동계획_조업형태(1SH)
  • WORK_TYPE2_1 (Field16) — NUMBER(12,4) — 가동계획_조업형태(2SH)
  • … +55

PGT10__OP_STOP_DB (가동률 집계(저해요인))

  • SHOP_DATE (Key3) — CHAR(8) — Primary key — NOT NULL — 조업일자
  • CATEGORY (Key4) — VARCHAR(1) — Primary key — NOT NULL — 계열
  • LOCATION (Key) — VARCHAR(1) — Primary key — NOT NULL — 지역
  • COMPANY (Key2) — VARCHAR(10) — Primary key — NOT NULL — 법인
  • AREA (Key5) — VARCHAR(10) — Primary key — NOT NULL — 지역
  • PLANT (Key6) — VARCHAR(5) — Primary key — NOT NULL — 공장번호
  • ERP_CODE (Key7) — VARCHAR(5) — Primary key — NOT NULL — ERP CODE
  • SHOP (Key8) — VARCHAR(1) — Primary key — NOT NULL — SHOP
  • LINE (Key9) — VARCHAR(10) — Primary key — NOT NULL — LINE
  • DG (Key10) — CHAR(2) — Primary key — NOT NULL — DG
  • LEVEL (Key11) — NUMBER — Primary key — NOT NULL — LEVEL
  • PG05A19 (Key12) — VARCHAR(30) — Primary key — NOT NULL — 자타공정 구분
  • PG05A23 (Key13) — VARCHAR(5) — Primary key — NOT NULL — 저해요인 코드_중분류
  • PG05A04 (Key14) — VARCHAR(10) — Primary key — NOT NULL — 저해요인 코드_소분류
  • PG05A01 (Key15) — VARCHAR(08) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A01 — NOT NULL — 해당일
  • PG05A03 (Key22) — VARCHAR(1) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A03 — NOT NULL — 주야구분
  • PG05A04 (Key32) — VARCHAR(6) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A04 — NOT NULL — 저해요인 코드
  • PG05A05 (Key42) — NUMBER(3) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A05 — NOT NULL — 회차1
  • PG05A06 (Key52) — NUMBER(3) — Foreign key → PGT05_STOP_HISTORY_AB.PG05A06 — NOT NULL — 회차2
  • ERP_KEY (Key62) — VARCHAR(27) — Foreign key → PGT05_STOP_HISTORY_AB.ERP_KEY — NOT NULL — ERP KEY
  • CODE_TYPE (Key72) — VARCHAR(01) — Foreign key → PGT05_STOP_HISTORY_AB.CODE_TYPE — NOT NULL — 데이터 유형
  • PG01K01 (Key222) — CHAR(1) — Foreign key → PGT05_STOP_HISTORY_AB.PG01K01 — NOT NULL — 레벨
  • PG01K05 (Key322) — VARCHAR(1) — Foreign key → PGT05_STOP_HISTORY_AB.PG01K05 — NOT NULL — 대분류코드
  • TI (Field4) — NUMBER(12,4) — TI
  • EA (Field5) — NUMBER(12,4) — EA
  • NO (Field6) — NUMBER(12,4) — NO