A_APPS

Tables (9)

PRJA_APP_COMMENT

  • COMMENTID(의견 아이디) (Key) — VARCHAR2 — Primary key — NOT NULL
  • APPID(결재아이디) (APPID) — VARCHAR2 — Foreign key → PRJA_APP_LEAVE.APPID(결재아이디) — NOT NULL
  • CONTENT(의견 내용) (CONTENT) — VARCHAR2
  • DEPTID(작성자부서아이디) (DEPTID) — VARCHAR2
  • POSITIONID(작성자직위아이디) (POSITIONID) — VARCHAR2
  • USERID(작성자아이디) (Field) — VARCHAR2
  • COMMENTDATE(작성일시) (Field2) — DATE

PRJA_APP_ENDLIST (.)

  • ENDLISTID(완료목록아이디) (Key) — VARCHAR2 — Primary key — NOT NULL
  • APPID(결재아이디) (APPID) — VARCHAR2 — Foreign key → PRJA_APP_LEAVE.APPID(결재아이디) — NOT NULL
  • REGUSERID(등록자아이디) (REGUSERID) — VARCHAR2
  • REGDATE(등록일시) (REGDATE) — DATE
  • TITLE(문서제목) (TITLE) — VARCHAR2
  • STATUS(기안서상태) (STATUS) — VARCHAR2
  • DOCTYPE(문서타입) (DOCTYPE) — VARCHAR2
  • DRAFTDATE(기안일시) (DRAFTDATE) — DATE
  • COMMENTCNT(의견수) (COMMENTCNT) — NUMBER(5)

PRJA_APP_INGLIST (..)

  • INGLISTID(진행목록아이디) (Key) — VARCHAR2 — Primary key — NOT NULL
  • APPID(결재아이디) (APPID) — VARCHAR2 — Foreign key → PRJA_APP_LEAVE.APPID(결재아이디) — NOT NULL
  • REGUSERID(등록자아이디) (REGUSERID) — VARCHAR2
  • REGDATE(등록일시) (REGDATE) — DATE
  • TITLE(문서제목) (TITLE) — VARCHAR2
  • STATUS(기안서상태) (STATUS) — VARCHAR2
  • DOCTYPE(문서타입) (DOCTYPE) — VARCHAR2
  • DRAFTDATE(기안일시) (DRAFTDATE) — DATE
  • COMMENTCNT(의견수) (COMMENTCNT) — NUMBER(5)

PRJA_APP_LEAVE

  • APPID(결재아이디) (APPID) — VARCHAR2 — Primary key — NOT NULL
  • DOCNO(문서번호) (DOCNO) — VARCHAR2(100)
  • USERID(기안자아이디) (USERID) — VARCHAR2
  • DEPTID(기안자부서아이디) (DEPTID) — VARCHAR2
  • POSITIONID(기안자직위아이디) (POSITIONID) — VARCHAR2
  • DRAFTDATE(기안일시) (DRAFTDATE) — DATE
  • TITLE(문서제목) (TITLE) — VARCHAR2
  • DOCSAVE(문서보존년한코드) (DOCSAVE) — VARCHAR2(20)
  • DOCGRDATE(문서등급) (DOCGRDATE) — DATE
  • FILEATTACHYN(파일첨부여부) (FILEATTACHYN) — CHAR
  • LVETYPE(휴가구분) (LVETYPE) — VARCHAR2(20)
  • LVESTART(휴가시작) (LVESTART) — DATE
  • LVEEND(휴가종료) (LVEEND) — DATE
  • LVEDATE(휴가일수) (LVEDATE) — NUMBER(5)
  • REASON(신청사유) (REASON) — VARCHAR2
  • PHONENUMBER(긴급연락처) (PHONENUMBER) — VARCHAR2
  • TASKAGENT(업무대행자) (TASKAGENT) — VARCHAR2
  • REMARK(특이사항) (REMARK) — VARCHAR2
  • LOCATION(기안서위치) (LOCATION) — NUMBER(5)
  • STATUS(기안서상태) (STATUS) — VARCHAR2
  • COMMENTCNT(의견수) (COMMENTCNT) — NUMBER(5)
  • DOCTYPE(문서구분) (DOCTYPE) — VARCHAR2
  • LVECNT(총일수) (LVECNT) — FLOAT(5)
  • USEDLVECNT(사용일수) (USEDLVECNT) — FLOAT(5)
  • LEFTLVECNT(남은일수) (LEFTLVECNT) — FLOAT(5)
  • REQLVECNT(결재중일수) (Field2) — FLOAT(5)
  • CONTENTFILEID(결재내용아이디) (Field3) — VARCHAR2

PRJA_APP_LEAVECNT

  • USERID(사용자아이디) (Key) — VARCHAR2 — Primary key — NOT NULL
  • LVECNT(총휴가일수) (LVECNT) — FLOAT(5)
  • USEDLVECNT(사용휴가일수) (USEDLVECNT) — FLOAT(5)
  • LEFTLVECNT(남은휴가일수) (LEFTLVECNT) — FLOAT(5)
  • REQLVECNT(결재중일수) (REQLVECNT) — FLOAT(5)
  • DEPTID(부서아이디) (DEPTID) — VARCHAR2
  • POSITIONID(직위아이디) (POSITIONID) — VARCHAR2
  • YEAR(년도) (YEAR) — NUMBER(5)

PRJA_APP_LINE

  • LINEID(결재라인아이디) (LINEID) — VARCHAR2 — Primary key — NOT NULL
  • APPID(결재아이디) (APPID) — VARCHAR2 — Foreign key → PRJA_APP_LEAVE.APPID(결재아이디) — NOT NULL
  • STATUS(라인상태) (STATUS) — VARCHAR2
  • APPUSERID(결재자아이디) (APPUSERID) — VARCHAR2
  • POSITIONID(직위아이디) (POSITIONID) — VARCHAR2
  • DEPTID(라인상태) (DEPTID) — VARCHAR2
  • READYN(열람여부) (READYN) — CHAR
  • READDATE(열람일시) (READDATE) — DATE
  • RGUSERID(등록자[기안자]아이디) (RGUSERID) — VARCHAR2
  • REGDATE(등록일시) (REGDATE) — DATE
  • SORTNO(순서) (SORTNO) — NUMBER(5)
  • JOINAPPYN(결재참여여부(Y/N)) (JOINAPPYN) — CHAR
  • CONSENSUSYN(합의자구분(Y/N)) (CONSENSUSYN) — CHAR
  • FINALYN(최종결재자여부(Y/N)) (FINALYN) — CHAR
  • DRAFTDATE(결재일시) (DRAFTDATE) — DATE

PRJA_APP_RCVINFO

  • RCVINFOID(수신처아아디) (RCVINFOID) — VARCHAR2 — Primary key — NOT NULL
  • APPID(결재아이디) (APPID) — VARCHAR2 — Foreign key → PRJA_APP_LEAVE.APPID(결재아이디) — NOT NULL
  • SUBINCLUDEYN(하위수신처여부) (SUBINCLUDEYN) — CHAR
  • REGDATE(등록일시) (REGDATE) — DATE
  • RGUSERID(등록자아이디) (RGUSERID) — VARCHAR2
  • RCVYN(열람여부) (RCVYN) — CHAR
  • RCVDATE(열람일시) (RCVDATE) — DATE

PRJA_APP_TEMPLIST (....)

  • TEMPLISTID(임시목록아이디) (Key) — VARCHAR2 — Primary key — NOT NULL
  • APPID(결재아이디) (APPID) — VARCHAR2 — Foreign key → PRJA_APP_LEAVE.APPID(결재아이디) — NOT NULL
  • REGUSERID(등록자아이디) (REGUSERID) — VARCHAR2
  • REGDATE(등록일시) (REGDATE) — DATE
  • TITLE(문서제목) (TITLE) — VARCHAR2
  • STATUS(기안서상태) (STATUS) — VARCHAR2
  • DOCTYPE(문서타입) (DOCTYPE) — VARCHAR2

PRJA_APP_TODOLIST (...)

  • TODOLISTID(대기목록아이디) (Key) — VARCHAR2 — Primary key — NOT NULL
  • APPID(결재아이디) (APPID) — VARCHAR2 — Foreign key → PRJA_APP_LEAVE.APPID(결재아이디) — NOT NULL
  • REGUSERID(등록자아이디) (REGUSERID) — VARCHAR2
  • REGDATE(등록일시) (REGDATE) — DATE
  • TITLE(문서제목) (TITLE) — VARCHAR2
  • STATUS(기안서상태) (STATUS) — VARCHAR2
  • DOCTYPE(문서타입) (DOCTYPE) — VARCHAR2
  • DRAFTDATE(기안일시) (DRAFTDATE) — DATE
  • COMMENTCNT(의견수) (COMMENTCNT) — NUMBER(5)