DROP TABLE app_functions$aud CASCADE CONSTRAINTS
/

CREATE TABLE APP_FUNCTIONS$AUD (
AFA_FUNCTION                       VARCHAR2(100),
AFA_DATE                           DATE,
AFA_GUID                           NUMBER (38,0),
AFA_COMMENT                        VARCHAR(4000))
/

DROP TABLE ussi_jobs_sign_reasons$aud CASCADE CONSTRAINTS
/

CREATE TABLE USSI_JOBS_SIGN_REASONS$AUD (                                       
UJR_JOBID                          NUMBER(38,0),                                
UJR_REASON                         VARCHAR2(4000),                              
aud_action CHAR(3),aud_timestamp DATE)                                          
/                                                                               

DROP TABLE ussi_jobs$aud CASCADE CONSTRAINTS
/
                                                                                                                                   
CREATE TABLE ussi_jobs$aud
    (ujb_jobid                      NUMBER NOT NULL,
    ujb_randomid                   VARCHAR2(80) NOT NULL,
    ujb_email_address              VARCHAR2(100),
    ujb_certificate                VARCHAR2(4000),
    ujb_signatureblock             VARCHAR2(100),
    ujb_signer_comment             VARCHAR2(4000),
    ujb_inputfile                  VARCHAR2(4000),
    ujb_outputfile                 VARCHAR2(4000),
    ujb_jobstatus                  VARCHAR2(20) NOT NULL,
    ujb_jobstatusdetail            VARCHAR2(80) NOT NULL,
    ujb_applogo                    VARCHAR2(4000),
    ujb_requestor                  VARCHAR2(100),
    ujb_requestor_comment          VARCHAR2(4000),
    ujb_ecopy                      VARCHAR2(5),
    ujb_ecopyoutputfile            VARCHAR2(4000),
    ujb_target_location            VARCHAR2(4000),
    ujb_newwindow_yn               VARCHAR2(1) DEFAULT 'Y'  NOT NULL,
    ujb_createdate                 DATE,
    ujb_modifydate                 DATE,
    ujb_joburl                     VARCHAR2(100),
    ujb_function                   VARCHAR2(10),
    aud_action                     CHAR(3),
    aud_timestamp                  DATE)
/                                                                              
