-- create_approval_table.sql     CREATE TABLE APPROVAL  for Approval Notices email
--**Use this information and these scripts at your own risk. As a condition of using these scripts and information from this site, you agree to hold harmless both the University of Arkansas Cooperative Extension Service and Bruce Knox for any problems that they may cause or other situations that may arise from their use, and that neither the Extension Service nor I will be held liable for those consequences. The scripts and information are provided "as is" without warranty, implied or otherwise. Limitation of liability will be the amount paid to the University of Arkansas specifically for this information. (It was free:) 
-- created by bknox 2/16/2003

DROP TABLE APPROVAL

CREATE TABLE APPROVAL
(APPROVAL_TYPE              VARCHAR2(1),
 APPROVAL_SEQ_NUM           NUMBER(2),
 APPROVAL_DOC_CODE          VARCHAR2(15),
 APPROVAL_ACTIVITY_DATE     DATE,
 APPROVAL_CHG_SEQ_NUM       NUMBER(3),
 APPROVAL_SUBMISSION_NUMBER NUMBER(2),
 APPROVAL_STATUS_IND        VARCHAR2(1),
 APPROVAL_SENT              VARCHAR2(1)
 APPROVAL_QUEUE_ID          VARCHAR2(4)
 APPROVAL_LEVEL             NUMBER(4)
 APPROVAL_APPROVAL_SEQUENCE NUMBER(6)
 APPROVAL_USER_ID_APPR      VARCHAR2(30)
);

--grant SELECT,insert,update,delete on APPROVAL to user_that_sends_notices; 
--create public synonym APPROVAL for owner.APPROVAL;

-- create_approval_table.sql end
