ALTER TABLE VOA.VOA_RESUBMISSION MODIFY 
  VOA_RESUBMISSION_ID NULL;

ALTER TABLE VOA.VOA_RESUBMISSION MODIFY 
  VOA_RESUBMISSION_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_RESUBMISSION MODIFY 
  VOA_ENROLLMENT_APP_ID NULL;

ALTER TABLE VOA.VOA_RESUBMISSION MODIFY 
  VOA_ENROLLMENT_APP_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_RESUBMISSION MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE VOA.VOA_RESUBMISSION MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_RESUBMISSION MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE VOA.VOA_RESUBMISSION MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_RESUBMISSION MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE VOA.VOA_RESUBMISSION MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_RESUBMISSION MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE VOA.VOA_RESUBMISSION MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_RESUBMISSION MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE VOA.VOA_RESUBMISSION MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_RESUBMISSION
  DROP CONSTRAINT VOARSB_VOAENRAPP_FK;


ALTER TABLE VOA.VOA_RESUBMISSION ADD (
  CONSTRAINT VOARSB_VOAENRAPP_FK 
  FOREIGN KEY (VOA_ENROLLMENT_APP_ID) 
  REFERENCES VOA.VOA_ENROLLMENT_APPLICATION (VOA_ENROLLMENT_APP_ID)
  DEFERRABLE INITIALLY DEFERRED
  ENABLE VALIDATE);
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  VOA_ENROLLMENT_APP_ID NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  VOA_ENROLLMENT_APP_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  VOA_ENROLLMENT_APP_STATUS_ID NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  VOA_ENROLLMENT_APP_STATUS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  ENROLLMENT_FORM_TYPE_ID NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  ENROLLMENT_FORM_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  AUTHENTICATION_LEVEL_ID NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  AUTHENTICATION_LEVEL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  APPLICANT_LAST_NAME NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  APPLICANT_LAST_NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  APPLICANT_DOB NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  APPLICANT_DOB NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  APPLICANT_SSN NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  APPLICANT_SSN NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  HISTORY_CREATED_DATE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  HISTORY_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  TRANSACTION_TYPE_CODE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  TRANSACTION_TYPE_CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  VOA_ENROLLMENT_APP_H_ID NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H MODIFY 
  VOA_ENROLLMENT_APP_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  VOA_ENROLLMENT_APP_ID NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  VOA_ENROLLMENT_APP_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  VOA_ENROLLMENT_APP_STATUS_ID NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  VOA_ENROLLMENT_APP_STATUS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  ENROLLMENT_FORM_TYPE_ID NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  ENROLLMENT_FORM_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  AUTHENTICATION_LEVEL_ID NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  AUTHENTICATION_LEVEL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  APPLICANT_LAST_NAME NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  APPLICANT_LAST_NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  APPLICANT_DOB NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  APPLICANT_DOB NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  APPLICANT_SSN NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION MODIFY 
  APPLICANT_SSN NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION
  DROP CONSTRAINT VOAENRAPP_ATHLVL_FK;


ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION ADD (
  CONSTRAINT VOAENRAPP_ATHLVL_FK 
  FOREIGN KEY (AUTHENTICATION_LEVEL_ID) 
  REFERENCES VOA.AUTHENTICATION_LEVEL (AUTHENTICATION_LEVEL_ID)
  ENABLE VALIDATE);
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION
  DROP CONSTRAINT VOAENRAPP_ENRFRMTYP_FK;


ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION ADD (
  CONSTRAINT VOAENRAPP_ENRFRMTYP_FK 
  FOREIGN KEY (ENROLLMENT_FORM_TYPE_ID) 
  REFERENCES VOA.ENROLLMENT_FORM_TYPE (ENROLLMENT_FORM_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION
  DROP CONSTRAINT VOAENRAPP_PRSN_FK;


ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION ADD (
  CONSTRAINT VOAENRAPP_PRSN_FK 
  FOREIGN KEY (PERSON_ID) 
  REFERENCES ADR.PERSON (PERSON_ID)
  ON DELETE SET NULL
  ENABLE VALIDATE);
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION
  DROP CONSTRAINT VOAENRAPP_VOAENRAPPSTA_FK;


ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION ADD (
  CONSTRAINT VOAENRAPP_VOAENRAPPSTA_FK 
  FOREIGN KEY (VOA_ENROLLMENT_APP_STATUS_ID) 
  REFERENCES VOA.VOA_ENROLLMENT_APP_STATUS (VOA_ENROLLMENT_APP_STATUS_ID)
  ENABLE VALIDATE);
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION
  DROP CONSTRAINT VOAENRAPP_VETIDTYP_FK;


ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION ADD (
  CONSTRAINT VOAENRAPP_VETIDTYP_FK 
  FOREIGN KEY (VETERAN_IDENTIFIER_TYPE_ID) 
  REFERENCES VBR.VETERAN_IDENTIFIER_TYPE (VETERAN_IDENTIFIER_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  VOA_ENROLLMENT_APP_STATUS_ID NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  VOA_ENROLLMENT_APP_STATUS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  DESCRIPTION NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  DESCRIPTION NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  NAME NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  CODE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  HISTORY_CREATED_DATE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  HISTORY_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  TRANSACTION_TYPE_CODE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  TRANSACTION_TYPE_CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  VOA_ENROLLMENT_APP_STAT_H_ID NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H MODIFY 
  VOA_ENROLLMENT_APP_STAT_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  VOA_ENROLLMENT_APP_STATUS_ID NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  VOA_ENROLLMENT_APP_STATUS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  DESCRIPTION NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  DESCRIPTION NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  NAME NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  CODE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  VOA_ENROLLMENT_APP_DATA_ID NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  VOA_ENROLLMENT_APP_DATA_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  APPLICATION_DATA NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  APPLICATION_DATA NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  VOA_ENROLLMENT_APP_ID NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  VOA_ENROLLMENT_APP_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA
  DROP CONSTRAINT VOAENRAPPDAT_VOAENRAPP_FK;


ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA ADD (
  CONSTRAINT VOAENRAPPDAT_VOAENRAPP_FK 
  FOREIGN KEY (VOA_ENROLLMENT_APP_ID) 
  REFERENCES VOA.VOA_ENROLLMENT_APPLICATION (VOA_ENROLLMENT_APP_ID)
  ENABLE VALIDATE);
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  CODE NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  NAME NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  DESCRIPTION NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  DESCRIPTION NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  HISTORY_CREATED_DATE NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  HISTORY_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  TRANSACTION_TYPE_CODE NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  TRANSACTION_TYPE_CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  ENROLLMENT_FORM_TYP_H_ID NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  ENROLLMENT_FORM_TYP_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  ENROLLMENT_FORM_TYPE_ID NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H MODIFY 
  ENROLLMENT_FORM_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  ENROLLMENT_FORM_TYPE_ID NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  ENROLLMENT_FORM_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  CODE NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  NAME NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  DESCRIPTION NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  DESCRIPTION NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  CODE NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  NAME NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  DESCRIPTION NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  DESCRIPTION NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  AUTHENTICATION_LEVEL_ID NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  AUTHENTICATION_LEVEL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  HISTORY_CREATED_DATE NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  HISTORY_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  TRANSACTION_TYPE_CODE NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  TRANSACTION_TYPE_CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  AUTHENTICATION_LVL_H_ID NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL_H MODIFY 
  AUTHENTICATION_LVL_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  CODE NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  NAME NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  DESCRIPTION NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  DESCRIPTION NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  AUTHENTICATION_LEVEL_ID NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  AUTHENTICATION_LEVEL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE VOA.AUTHENTICATION_LEVEL MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VOA.AUTHENTICATION_LEVEL
  DROP CONSTRAINT ATHLVL_PK;

ALTER TABLE VOA.AUTHENTICATION_LEVEL ADD (
  CONSTRAINT ATHLVL_PK
  PRIMARY KEY
  (AUTHENTICATION_LEVEL_ID)
  ENABLE VALIDATE);
ALTER TABLE VOA.AUTHENTICATION_LEVEL
  DROP CONSTRAINT ATHLVLCOD_UK;

ALTER TABLE VOA.AUTHENTICATION_LEVEL ADD (
  CONSTRAINT ATHLVLCOD_UK
  UNIQUE (CODE)
  ENABLE VALIDATE);
ALTER TABLE VOA.AUTHENTICATION_LEVEL
  DROP CONSTRAINT ATHLVLNAM_UK;

ALTER TABLE VOA.AUTHENTICATION_LEVEL ADD (
  CONSTRAINT ATHLVLNAM_UK
  UNIQUE (NAME)
  ENABLE VALIDATE);
ALTER TABLE VOA.AUTHENTICATION_LEVEL_H
  DROP CONSTRAINT ATHLVL_H_PK;

ALTER TABLE VOA.AUTHENTICATION_LEVEL_H ADD (
  CONSTRAINT ATHLVL_H_PK
  PRIMARY KEY
  (AUTHENTICATION_LVL_H_ID)
  ENABLE VALIDATE);
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE
  DROP CONSTRAINT ENRFRMTYP_PK;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE ADD (
  CONSTRAINT ENRFRMTYP_PK
  PRIMARY KEY
  (ENROLLMENT_FORM_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE
  DROP CONSTRAINT ENRFRMTYPCOD_UK;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE ADD (
  CONSTRAINT ENRFRMTYPCOD_UK
  UNIQUE (CODE)
  ENABLE VALIDATE);
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE
  DROP CONSTRAINT ENRFRMTYPNAM_UK;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE ADD (
  CONSTRAINT ENRFRMTYPNAM_UK
  UNIQUE (NAME)
  ENABLE VALIDATE);
ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H
  DROP CONSTRAINT ENRFRMTYP_H_PK;

ALTER TABLE VOA.ENROLLMENT_FORM_TYPE_H ADD (
  CONSTRAINT ENRFRMTYP_H_PK
  PRIMARY KEY
  (ENROLLMENT_FORM_TYP_H_ID)
  ENABLE VALIDATE);
ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA
  DROP CONSTRAINT VOAENRAPPDATA_PK;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_DATA ADD (
  CONSTRAINT VOAENRAPPDATA_PK
  PRIMARY KEY
  (VOA_ENROLLMENT_APP_DATA_ID)
  ENABLE VALIDATE);
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS
  DROP CONSTRAINT VOAENRAPPSTAT_PK;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS ADD (
  CONSTRAINT VOAENRAPPSTAT_PK
  PRIMARY KEY
  (VOA_ENROLLMENT_APP_STATUS_ID)
  ENABLE VALIDATE);
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS
  DROP CONSTRAINT VOAENRAPPSTATCOD_UK;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS ADD (
  CONSTRAINT VOAENRAPPSTATCOD_UK
  UNIQUE (CODE)
  ENABLE VALIDATE);
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS
  DROP CONSTRAINT VOAENRAPPSTATNAM_UK;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS ADD (
  CONSTRAINT VOAENRAPPSTATNAM_UK
  UNIQUE (NAME)
  ENABLE VALIDATE);
ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H
  DROP CONSTRAINT VOAENRAPPSTAT_H_PK;

ALTER TABLE VOA.VOA_ENROLLMENT_APP_STATUS_H ADD (
  CONSTRAINT VOAENRAPPSTAT_H_PK
  PRIMARY KEY
  (VOA_ENROLLMENT_APP_STAT_H_ID)
  ENABLE VALIDATE);
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION
  DROP CONSTRAINT VOAENRAPP_PK;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION ADD (
  CONSTRAINT VOAENRAPP_PK
  PRIMARY KEY
  (VOA_ENROLLMENT_APP_ID)
  ENABLE VALIDATE);
ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H
  DROP CONSTRAINT VOAENRAPP_H_PK;

ALTER TABLE VOA.VOA_ENROLLMENT_APPLICATION_H ADD (
  CONSTRAINT VOAENRAPP_H_PK
  PRIMARY KEY
  (VOA_ENROLLMENT_APP_H_ID)
  ENABLE VALIDATE);
ALTER TABLE VOA.VOA_RESUBMISSION
  DROP CONSTRAINT VOARSB_PK;

ALTER TABLE VOA.VOA_RESUBMISSION ADD (
  CONSTRAINT VOARSB_PK
  PRIMARY KEY
  (VOA_RESUBMISSION_ID)
  ENABLE VALIDATE);
