ALTER TABLE CIS.CIS_JOB_CONTROL MODIFY 
  CIS_JOB_CNTL_STAT_RSN_TYPE_ID NULL;

ALTER TABLE CIS.CIS_JOB_CONTROL MODIFY 
  CIS_JOB_CNTL_STAT_RSN_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_CONTROL MODIFY 
  CIS_JOB_CNTL_STATUS_TYPE_ID NULL;

ALTER TABLE CIS.CIS_JOB_CONTROL MODIFY 
  CIS_JOB_CNTL_STATUS_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_CONTROL MODIFY 
  CIS_JOB_RUN_TYPE_ID NULL;

ALTER TABLE CIS.CIS_JOB_CONTROL MODIFY 
  CIS_JOB_RUN_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_CONTROL MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_JOB_CONTROL MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_CONTROL MODIFY 
  JOB_RUN_START_DT NULL;

ALTER TABLE CIS.CIS_JOB_CONTROL MODIFY 
  JOB_RUN_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_CONTROL MODIFY 
  CIS_JOB_CONTROL_ID NULL;

ALTER TABLE CIS.CIS_JOB_CONTROL MODIFY 
  CIS_JOB_CONTROL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_CNTL_STAT_RSN_TYPE MODIFY 
  REC_MODF_DT NULL;

ALTER TABLE CIS.CIS_JOB_CNTL_STAT_RSN_TYPE MODIFY 
  REC_MODF_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_CNTL_STAT_RSN_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_JOB_CNTL_STAT_RSN_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_CNTL_STAT_RSN_TYPE MODIFY 
  JOB_CNTL_STAT_RSN_DESC_TX NULL;

ALTER TABLE CIS.CIS_JOB_CNTL_STAT_RSN_TYPE MODIFY 
  JOB_CNTL_STAT_RSN_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_CNTL_STAT_RSN_TYPE MODIFY 
  JOB_CNTL_STAT_RSN_NM NULL;

ALTER TABLE CIS.CIS_JOB_CNTL_STAT_RSN_TYPE MODIFY 
  JOB_CNTL_STAT_RSN_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_CNTL_STAT_RSN_TYPE MODIFY 
  CIS_JOB_CNTL_STAT_RSN_TYPE_ID NULL;

ALTER TABLE CIS.CIS_JOB_CNTL_STAT_RSN_TYPE MODIFY 
  CIS_JOB_CNTL_STAT_RSN_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_CNTL_STATUS_TYPE MODIFY 
  REC_MODF_DT NULL;

ALTER TABLE CIS.CIS_JOB_CNTL_STATUS_TYPE MODIFY 
  REC_MODF_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_CNTL_STATUS_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_JOB_CNTL_STATUS_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_CNTL_STATUS_TYPE MODIFY 
  JOB_CNTL_STATUS_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_JOB_CNTL_STATUS_TYPE MODIFY 
  JOB_CNTL_STATUS_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_CNTL_STATUS_TYPE MODIFY 
  JOB_CNTL_STATUS_TYPE_NM NULL;

ALTER TABLE CIS.CIS_JOB_CNTL_STATUS_TYPE MODIFY 
  JOB_CNTL_STATUS_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_CNTL_STATUS_TYPE MODIFY 
  CIS_JOB_CNTL_STATUS_TYPE_ID NULL;

ALTER TABLE CIS.CIS_JOB_CNTL_STATUS_TYPE MODIFY 
  CIS_JOB_CNTL_STATUS_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_RUN_TYPE MODIFY 
  REC_MODF_DT NULL;

ALTER TABLE CIS.CIS_JOB_RUN_TYPE MODIFY 
  REC_MODF_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_RUN_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_JOB_RUN_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_RUN_TYPE MODIFY 
  JOB_RUN_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_JOB_RUN_TYPE MODIFY 
  JOB_RUN_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_RUN_TYPE MODIFY 
  JOB_RUN_TYPE_NM NULL;

ALTER TABLE CIS.CIS_JOB_RUN_TYPE MODIFY 
  JOB_RUN_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_RUN_TYPE MODIFY 
  CIS_JOB_RUN_TYPE_ID NULL;

ALTER TABLE CIS.CIS_JOB_RUN_TYPE MODIFY 
  CIS_JOB_RUN_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_DATA_CLOB MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_INFLGHT_DATA_CLOB MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_DATA_CLOB MODIFY 
  REQUEST_DATA NULL;

ALTER TABLE CIS.CIS_INFLGHT_DATA_CLOB MODIFY 
  REQUEST_DATA NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_DATA_CLOB MODIFY 
  CIS_INFLGHT_DATA_ID NULL;

ALTER TABLE CIS.CIS_INFLGHT_DATA_CLOB MODIFY 
  CIS_INFLGHT_DATA_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  DMSTC_IND NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  DMSTC_IND NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE MODIFY 
  DMSTC_IND NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE MODIFY 
  DMSTC_IND NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  PROPAGATE_RQRD_IND NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  PROPAGATE_RQRD_IND NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  CIS_CONT_INFO_H_ID NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  CIS_CONT_INFO_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  CIS_PROPAGATE_EVENT_ID NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  CIS_PROPAGATE_EVENT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  CIS_PROPAGATE_EVENT_H_ID NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H MODIFY 
  CIS_PROPAGATE_EVENT_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK MODIFY 
  ACK_DATE NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK MODIFY 
  ACK_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK MODIFY 
  CIS_SUBSCRIBER_ID NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK MODIFY 
  CIS_SUBSCRIBER_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK MODIFY 
  CIS_PROPAGATE_EVENT_ID NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK MODIFY 
  CIS_PROPAGATE_EVENT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK MODIFY 
  CIS_PROPAGATE_EVENT_ACK_ID NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK MODIFY 
  CIS_PROPAGATE_EVENT_ACK_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT MODIFY 
  PROPAGATE_RQRD_IND NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT MODIFY 
  PROPAGATE_RQRD_IND NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT MODIFY 
  CIS_CONT_INFO_H_ID NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT MODIFY 
  CIS_CONT_INFO_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROPAGATE_EVENT MODIFY 
  CIS_PROPAGATE_EVENT_ID NULL;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT MODIFY 
  CIS_PROPAGATE_EVENT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_SUBSCRIBER MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_SUBSCRIBER MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_SUBSCRIBER MODIFY 
  CIS_PARTY_ID NULL;

ALTER TABLE CIS.CIS_SUBSCRIBER MODIFY 
  CIS_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_SUBSCRIBER MODIFY 
  CIS_SUBSCRIBER_ID NULL;

ALTER TABLE CIS.CIS_SUBSCRIBER MODIFY 
  CIS_SUBSCRIBER_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_DATA MODIFY 
  DATA_SRC_TXT NULL;

ALTER TABLE CIS.CIS_INFLGHT_DATA MODIFY 
  DATA_SRC_TXT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_DATA MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_INFLGHT_DATA MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_DATA MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_INFLGHT_DATA MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_DATA MODIFY 
  TRANSACTION_DATE NULL;

ALTER TABLE CIS.CIS_INFLGHT_DATA MODIFY 
  TRANSACTION_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_DATA MODIFY 
  TRANSACTION_ID_TX NULL;

ALTER TABLE CIS.CIS_INFLGHT_DATA MODIFY 
  TRANSACTION_ID_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_DATA MODIFY 
  ICN NULL;

ALTER TABLE CIS.CIS_INFLGHT_DATA MODIFY 
  ICN NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_DATA MODIFY 
  CIS_INFLGHT_DATA_ID NULL;

ALTER TABLE CIS.CIS_INFLGHT_DATA MODIFY 
  CIS_INFLGHT_DATA_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROVENANCE MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_PROVENANCE MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROVENANCE MODIFY 
  PROCESS_NM NULL;

ALTER TABLE CIS.CIS_PROVENANCE MODIFY 
  PROCESS_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROVENANCE MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PROVENANCE MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PROVENANCE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PROVENANCE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_AUDIT_LOG MODIFY 
  TRANSACTION_DT NULL;

ALTER TABLE CIS.CIS_AUDIT_LOG MODIFY 
  TRANSACTION_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_AUDIT_LOG MODIFY 
  TRANSACTION_ID_TX NULL;

ALTER TABLE CIS.CIS_AUDIT_LOG MODIFY 
  TRANSACTION_ID_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_AUDIT_LOG MODIFY 
  CIS_PROCESS_NM NULL;

ALTER TABLE CIS.CIS_AUDIT_LOG MODIFY 
  CIS_PROCESS_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_AUDIT_LOG MODIFY 
  CIS_AUDIT_LOG_ID NULL;

ALTER TABLE CIS.CIS_AUDIT_LOG MODIFY 
  CIS_AUDIT_LOG_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE MODIFY 
  VLDTN_STATUS_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE MODIFY 
  VLDTN_STATUS_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE MODIFY 
  VLDTN_STATUS_TYPE_NM NULL;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE MODIFY 
  VLDTN_STATUS_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE MODIFY 
  CIS_VLDTN_STATUS_TYPE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE MODIFY 
  CIS_VLDTN_STATUS_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB MODIFY 
  CIS_VLDTN_RSLT_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB MODIFY 
  CIS_VLDTN_RSLT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT MODIFY 
  CRCTD_STTS_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT MODIFY 
  CRCTD_STTS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT MODIFY 
  CRCTD_DLVRY_PNT_VLDTN_STTS_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT MODIFY 
  CRCTD_DLVRY_PNT_VLDTN_STTS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT MODIFY 
  CIS_CONT_INFO_DATA_QUAL_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT MODIFY 
  CIS_CONT_INFO_DATA_QUAL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT MODIFY 
  CIS_VLDTN_RSLT_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT MODIFY 
  CIS_VLDTN_RSLT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE MODIFY 
  VLDTN_PRBLM_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE MODIFY 
  VLDTN_PRBLM_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE MODIFY 
  VLDTN_PRBLM_TYPE_NM NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE MODIFY 
  VLDTN_PRBLM_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE MODIFY 
  CIS_VLDTN_PRBLM_TYPE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE MODIFY 
  CIS_VLDTN_PRBLM_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM MODIFY 
  CIS_VLDTN_PRBLM_TYPE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM MODIFY 
  CIS_VLDTN_PRBLM_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM MODIFY 
  CIS_VLDTN_RSLT_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM MODIFY 
  CIS_VLDTN_RSLT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM MODIFY 
  CIS_VLDTN_PRBLM_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM MODIFY 
  CIS_VLDTN_PRBLM_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_STAT_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_STAT_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_STAT_TYPE MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_STAT_TYPE MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_STAT_TYPE MODIFY 
  STAT_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_STAT_TYPE MODIFY 
  STAT_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_STAT_TYPE MODIFY 
  STAT_TYPE_NM NULL;

ALTER TABLE CIS.CIS_STAT_TYPE MODIFY 
  STAT_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_STAT_TYPE MODIFY 
  CIS_STAT_TYPE_ID NULL;

ALTER TABLE CIS.CIS_STAT_TYPE MODIFY 
  CIS_STAT_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_RULE_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_RULE_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_RULE_TYPE MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_RULE_TYPE MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_RULE_TYPE MODIFY 
  RULE_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_RULE_TYPE MODIFY 
  RULE_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_RULE_TYPE MODIFY 
  RULE_TYPE_NM NULL;

ALTER TABLE CIS.CIS_RULE_TYPE MODIFY 
  RULE_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_RULE_TYPE MODIFY 
  CIS_RULE_TYPE_ID NULL;

ALTER TABLE CIS.CIS_RULE_TYPE MODIFY 
  CIS_RULE_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PURPOSE_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PURPOSE_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PURPOSE_TYPE MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_PURPOSE_TYPE MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PURPOSE_TYPE MODIFY 
  PURP_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_PURPOSE_TYPE MODIFY 
  PURP_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PURPOSE_TYPE MODIFY 
  PURP_TYPE_NM NULL;

ALTER TABLE CIS.CIS_PURPOSE_TYPE MODIFY 
  PURP_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PURPOSE_TYPE MODIFY 
  CIS_PURP_TYPE_ID NULL;

ALTER TABLE CIS.CIS_PURPOSE_TYPE MODIFY 
  CIS_PURP_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PREF_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PREF_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PREF_TYPE MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_PREF_TYPE MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PREF_TYPE MODIFY 
  PREF_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_PREF_TYPE MODIFY 
  PREF_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PREF_TYPE MODIFY 
  PREF_TYPE_NM NULL;

ALTER TABLE CIS.CIS_PREF_TYPE MODIFY 
  PREF_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PREF_TYPE MODIFY 
  CIS_PREF_TYPE_ID NULL;

ALTER TABLE CIS.CIS_PREF_TYPE MODIFY 
  CIS_PREF_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PHONE_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PHONE_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PHONE_TYPE MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_PHONE_TYPE MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PHONE_TYPE MODIFY 
  PHONE_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_PHONE_TYPE MODIFY 
  PHONE_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PHONE_TYPE MODIFY 
  PHONE_TYPE_NM NULL;

ALTER TABLE CIS.CIS_PHONE_TYPE MODIFY 
  PHONE_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PHONE_TYPE MODIFY 
  CIS_PHONE_TYPE_ID NULL;

ALTER TABLE CIS.CIS_PHONE_TYPE MODIFY 
  CIS_PHONE_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE MODIFY 
  PARTY_SRC_ID_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE MODIFY 
  PARTY_SRC_ID_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE MODIFY 
  PARTY_SRC_ID_TYPE_NM NULL;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE MODIFY 
  PARTY_SRC_ID_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE MODIFY 
  CIS_PARTY_SRC_ID_TYPE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE MODIFY 
  CIS_PARTY_SRC_ID_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE MODIFY 
  PARTY_RLNSHP_DESC_TX NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE MODIFY 
  PARTY_RLNSHP_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE MODIFY 
  PARTY_RLNSHP_NM NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE MODIFY 
  PARTY_RLNSHP_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE MODIFY 
  CIS_PARTY_RLNSHP_TYPE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE MODIFY 
  CIS_PARTY_RLNSHP_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP MODIFY 
  CIS_SEC_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP MODIFY 
  CIS_SEC_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP MODIFY 
  CIS_PRI_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP MODIFY 
  CIS_PRI_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP MODIFY 
  CIS_PARTY_RLNSHP_TYPE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP MODIFY 
  CIS_PARTY_RLNSHP_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP MODIFY 
  CIS_PARTY_RLNSHP_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP MODIFY 
  CIS_PARTY_RLNSHP_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_INFO MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_PARTY_INFO MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_PARTY_INFO MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO MODIFY 
  PARTY_SRC_ID NULL;

ALTER TABLE CIS.CIS_PARTY_INFO MODIFY 
  PARTY_SRC_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO MODIFY 
  CIS_PARTY_SRC_ID_TYPE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_INFO MODIFY 
  CIS_PARTY_SRC_ID_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO MODIFY 
  CIS_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PARTY_INFO MODIFY 
  CIS_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO MODIFY 
  CIS_PARTY_INFO_ID NULL;

ALTER TABLE CIS.CIS_PARTY_INFO MODIFY 
  CIS_PARTY_INFO_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_PARTY MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_PARTY MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY MODIFY 
  CIS_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PARTY MODIFY 
  CIS_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE MODIFY 
  INFLGHT_STATUS_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE MODIFY 
  INFLGHT_STATUS_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE MODIFY 
  INFLGHT_STATUS_TYPE_NM NULL;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE MODIFY 
  INFLGHT_STATUS_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE MODIFY 
  CIS_INFLGHT_STATUS_TYPE_ID NULL;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE MODIFY 
  CIS_INFLGHT_STATUS_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS MODIFY 
  CIS_INFLGHT_STATUS_TYPE_ID NULL;

ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS MODIFY 
  CIS_INFLGHT_STATUS_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS MODIFY 
  CIS_INFLGHT_DATA_STATUS_ID NULL;

ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS MODIFY 
  CIS_INFLGHT_DATA_STATUS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_EMAIL_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_EMAIL_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_EMAIL_TYPE MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_EMAIL_TYPE MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_EMAIL_TYPE MODIFY 
  EMAIL_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_EMAIL_TYPE MODIFY 
  EMAIL_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_EMAIL_TYPE MODIFY 
  EMAIL_TYPE_NM NULL;

ALTER TABLE CIS.CIS_EMAIL_TYPE MODIFY 
  EMAIL_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_EMAIL_TYPE MODIFY 
  CIS_EMAIL_TYPE_ID NULL;

ALTER TABLE CIS.CIS_EMAIL_TYPE MODIFY 
  CIS_EMAIL_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS MODIFY 
  CIS_CONT_INFO_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS MODIFY 
  CIS_CONT_INFO_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS MODIFY 
  CIS_PURP_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS MODIFY 
  CIS_PURP_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS MODIFY 
  CIS_CONT_INFO_TYPE_PRPS_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS MODIFY 
  CIS_CONT_INFO_TYPE_PRPS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE MODIFY 
  CONT_INFO_DESC_TX NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE MODIFY 
  CONT_INFO_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE MODIFY 
  CONT_INFO_TYPE_NM NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE MODIFY 
  CONT_INFO_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE MODIFY 
  CIS_CONT_INFO_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE MODIFY 
  CIS_CONT_INFO_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS MODIFY 
  CIS_INT_STAT_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS MODIFY 
  CIS_INT_STAT_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS MODIFY 
  CIS_EXT_STAT_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS MODIFY 
  CIS_EXT_STAT_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS MODIFY 
  CIS_CONT_INFO_DATA_QUAL_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS MODIFY 
  CIS_CONT_INFO_DATA_QUAL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS MODIFY 
  CIS_CONT_INFO_STATUS_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS MODIFY 
  CIS_CONT_INFO_STATUS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS MODIFY 
  CIS_STAT_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS MODIFY 
  CIS_STAT_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS MODIFY 
  CIS_RULE_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS MODIFY 
  CIS_RULE_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS MODIFY 
  CIS_CONT_INFO_STATUS_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS MODIFY 
  CIS_CONT_INFO_STATUS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS MODIFY 
  CIS_CONT_INFO_RULE_STATUS_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS MODIFY 
  CIS_CONT_INFO_RULE_STATUS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE MODIFY 
  CIS_PURP_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE MODIFY 
  CIS_PURP_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE MODIFY 
  CIS_CONT_INFO_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE MODIFY 
  CIS_CONT_INFO_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE MODIFY 
  CIS_CONT_INFO_PURPOSE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE MODIFY 
  CIS_CONT_INFO_PURPOSE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PROF MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PROF MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PROF MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PROF MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PROF MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PROF MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PROF MODIFY 
  CIS_PARTY_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PROF MODIFY 
  CIS_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PROF MODIFY 
  CIS_CONT_INFO_PROF_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PROF MODIFY 
  CIS_CONT_INFO_PROF_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF MODIFY 
  CIS_PREF_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF MODIFY 
  CIS_PREF_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF MODIFY 
  CIS_CONT_INFO_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF MODIFY 
  CIS_CONT_INFO_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF MODIFY 
  CIS_CONT_INFO_PREF_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF MODIFY 
  CIS_CONT_INFO_PREF_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE MODIFY 
  COUNTRY_CD NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE MODIFY 
  COUNTRY_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE MODIFY 
  CIS_PHONE_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE MODIFY 
  CIS_PHONE_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE MODIFY 
  CIS_CONT_INFO_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE MODIFY 
  CIS_CONT_INFO_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE MODIFY 
  CIS_CONT_INFO_PHONE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE MODIFY 
  CIS_CONT_INFO_PHONE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL MODIFY 
  EMAIL_ADDR_TX NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL MODIFY 
  EMAIL_ADDR_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL MODIFY 
  CIS_CONT_INFO_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL MODIFY 
  CIS_CONT_INFO_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL MODIFY 
  CIS_EMAIL_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL MODIFY 
  CIS_EMAIL_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL MODIFY 
  CIS_CONT_INFO_EMAIL_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL MODIFY 
  CIS_CONT_INFO_EMAIL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY MODIFY 
  CIS_INFLGHT_DATA_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY MODIFY 
  CIS_INFLGHT_DATA_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY MODIFY 
  CIS_CONT_INFO_DATA_QUAL_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY MODIFY 
  CIS_CONT_INFO_DATA_QUAL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  COUNTRY_CD_TX NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  COUNTRY_CD_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  CITY_TX NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  CITY_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  LINE_1 NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  LINE_1 NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  CIS_ADDRESS_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  CIS_ADDRESS_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  CIS_CONT_INFO_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  CIS_CONT_INFO_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  CIS_CONT_INFO_ADDR_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS MODIFY 
  CIS_CONT_INFO_ADDR_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO MODIFY 
  CIS_CONT_INFO_PROF_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO MODIFY 
  CIS_CONT_INFO_PROF_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO MODIFY 
  CIS_CONT_INFO_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO MODIFY 
  CIS_CONT_INFO_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO MODIFY 
  CIS_CONT_INFO_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO MODIFY 
  CIS_CONT_INFO_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_ADDRESS_TYPE MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_ADDRESS_TYPE MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_ADDRESS_TYPE MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_ADDRESS_TYPE MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_ADDRESS_TYPE MODIFY 
  ADDR_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_ADDRESS_TYPE MODIFY 
  ADDR_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_ADDRESS_TYPE MODIFY 
  ADDR_TYPE_NM NULL;

ALTER TABLE CIS.CIS_ADDRESS_TYPE MODIFY 
  ADDR_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_ADDRESS_TYPE MODIFY 
  CIS_ADDRESS_TYPE_ID NULL;

ALTER TABLE CIS.CIS_ADDRESS_TYPE MODIFY 
  CIS_ADDRESS_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  VLDTN_STATUS_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  VLDTN_STATUS_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  VLDTN_STATUS_TYPE_NM NULL;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  VLDTN_STATUS_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  CIS_VLDTN_STATUS_TYPE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  CIS_VLDTN_STATUS_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  CIS_VLDTN_STATUS_TYPE_H_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H MODIFY 
  CIS_VLDTN_STATUS_TYPE_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  CRCTD_STTS_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  CRCTD_STTS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  CRCTD_DLVRY_PNT_VLDTN_STTS_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  CRCTD_DLVRY_PNT_VLDTN_STTS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  CIS_CONT_INFO_DATA_QUAL_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  CIS_CONT_INFO_DATA_QUAL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  CIS_VLDTN_RSLT_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  CIS_VLDTN_RSLT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  CIS_VLDTN_RSLT_H_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_H MODIFY 
  CIS_VLDTN_RSLT_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB_H MODIFY 
  CIS_VLDTN_RSLT_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB_H MODIFY 
  CIS_VLDTN_RSLT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB_H MODIFY 
  CIS_VLDTN_RSLT_CLOB_H_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB_H MODIFY 
  CIS_VLDTN_RSLT_CLOB_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  VLDTN_PRBLM_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  VLDTN_PRBLM_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  VLDTN_PRBLM_TYPE_NM NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  VLDTN_PRBLM_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  CIS_VLDTN_PRBLM_TYPE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  CIS_VLDTN_PRBLM_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  CIS_VLDTN_PRBLM_TYPE_H_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H MODIFY 
  CIS_VLDTN_PRBLM_TYPE_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  CIS_VLDTN_PRBLM_TYPE_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  CIS_VLDTN_PRBLM_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  CIS_VLDTN_RSLT_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  CIS_VLDTN_RSLT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  CIS_VLDTN_PRBLM_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  CIS_VLDTN_PRBLM_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  CIS_VLDTN_PRBLM_H_ID NULL;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_H MODIFY 
  CIS_VLDTN_PRBLM_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  STAT_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  STAT_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  STAT_TYPE_NM NULL;

ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  STAT_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  CIS_STAT_TYPE_ID NULL;

ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  CIS_STAT_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  CIS_STAT_TYPE_H_ID NULL;

ALTER TABLE CIS.CIS_STAT_TYPE_H MODIFY 
  CIS_STAT_TYPE_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  RULE_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  RULE_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  RULE_TYPE_NM NULL;

ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  RULE_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  CIS_RULE_TYPE_ID NULL;

ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  CIS_RULE_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  CIS_RULE_TYPE_H_ID NULL;

ALTER TABLE CIS.CIS_RULE_TYPE_H MODIFY 
  CIS_RULE_TYPE_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  PURP_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  PURP_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  PURP_TYPE_NM NULL;

ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  PURP_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  CIS_PURP_TYPE_ID NULL;

ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  CIS_PURP_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  CIS_PURP_TYPE_H_ID NULL;

ALTER TABLE CIS.CIS_PURPOSE_TYPE_H MODIFY 
  CIS_PURP_TYPE_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  PREF_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  PREF_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  PREF_TYPE_NM NULL;

ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  PREF_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  CIS_PREF_TYPE_ID NULL;

ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  CIS_PREF_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  CIS_PREF_TYPE_H_ID NULL;

ALTER TABLE CIS.CIS_PREF_TYPE_H MODIFY 
  CIS_PREF_TYPE_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  PHONE_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  PHONE_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  PHONE_TYPE_NM NULL;

ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  PHONE_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  CIS_PHONE_TYPE_ID NULL;

ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  CIS_PHONE_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  CIS_PHONE_TYPE_H_ID NULL;

ALTER TABLE CIS.CIS_PHONE_TYPE_H MODIFY 
  CIS_PHONE_TYPE_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  PARTY_SRC_ID_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  PARTY_SRC_ID_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  PARTY_SRC_ID_TYPE_NM NULL;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  PARTY_SRC_ID_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  CIS_PARTY_SRC_ID_TYPE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  CIS_PARTY_SRC_ID_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  CIS_PARTY_SRC_ID_TYPE_H_ID NULL;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H MODIFY 
  CIS_PARTY_SRC_ID_TYPE_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  PARTY_RLNSHP_DESC_TX NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  PARTY_RLNSHP_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  PARTY_RLNSHP_NM NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  PARTY_RLNSHP_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  CIS_PARTY_RLNSHP_TYPE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  CIS_PARTY_RLNSHP_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  CIS_PARTY_RLNSHP_TYPE_H_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H MODIFY 
  CIS_PARTY_RLNSHP_TYPE_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  CIS_SEC_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  CIS_SEC_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  CIS_PRI_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  CIS_PRI_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  CIS_PARTY_RLNSHP_TYPE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  CIS_PARTY_RLNSHP_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  CIS_PARTY_RLNSHP_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  CIS_PARTY_RLNSHP_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  CIS_PARTY_RLNSHP_H_ID NULL;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_H MODIFY 
  CIS_PARTY_RLNSHP_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  PARTY_SRC_ID NULL;

ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  PARTY_SRC_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  CIS_PARTY_SRC_ID_TYPE_ID NULL;

ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  CIS_PARTY_SRC_ID_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  CIS_PARTY_ID NULL;

ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  CIS_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  CIS_PARTY_INFO_ID NULL;

ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  CIS_PARTY_INFO_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  CIS_PARTY_INFO_H_ID NULL;

ALTER TABLE CIS.CIS_PARTY_INFO_H MODIFY 
  CIS_PARTY_INFO_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  INFLGHT_STATUS_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  INFLGHT_STATUS_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  INFLGHT_STATUS_TYPE_NM NULL;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  INFLGHT_STATUS_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  CIS_INFLGHT_STATUS_TYPE_ID NULL;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  CIS_INFLGHT_STATUS_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  CIS_INFLGHT_STATUS_TYPE_H_ID NULL;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H MODIFY 
  CIS_INFLGHT_STATUS_TYPE_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  EMAIL_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  EMAIL_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  EMAIL_TYPE_NM NULL;

ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  EMAIL_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  CIS_EMAIL_TYPE_ID NULL;

ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  CIS_EMAIL_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  CIS_EMAIL_TYPE_H_ID NULL;

ALTER TABLE CIS.CIS_EMAIL_TYPE_H MODIFY 
  CIS_EMAIL_TYPE_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  CIS_CONT_INFO_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  CIS_CONT_INFO_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  CIS_PURP_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  CIS_PURP_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  CIS_CONT_INFO_TYPE_PRPS_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  CIS_CONT_INFO_TYPE_PRPS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  CIS_CONT_INFO_TYPE_PRPS_H_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H MODIFY 
  CIS_CONT_INFO_TYPE_PRPS_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  CONT_INFO_DESC_TX NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  CONT_INFO_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  CONT_INFO_TYPE_NM NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  CONT_INFO_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  CIS_CONT_INFO_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  CIS_CONT_INFO_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  CIS_CONT_INFO_TYPE_H_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H MODIFY 
  CIS_CONT_INFO_TYPE_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  CIS_INT_STAT_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  CIS_INT_STAT_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  CIS_EXT_STAT_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  CIS_EXT_STAT_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  CIS_CONT_INFO_DATA_QUAL_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  CIS_CONT_INFO_DATA_QUAL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  CIS_CONT_INFO_STATUS_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  CIS_CONT_INFO_STATUS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  CIS_CONT_INFO_STATUS_H_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H MODIFY 
  CIS_CONT_INFO_STATUS_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  CIS_STAT_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  CIS_STAT_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  CIS_RULE_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  CIS_RULE_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  CIS_CONT_INFO_STATUS_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  CIS_CONT_INFO_STATUS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  CIS_CONT_INFO_RULE_STATUS_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  CIS_CONT_INFO_RULE_STATUS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  CIS_CONT_INFO_RULE_STATUS_H_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H MODIFY 
  CIS_CONT_INFO_RULE_STATUS_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  CIS_PURP_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  CIS_PURP_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  CIS_CONT_INFO_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  CIS_CONT_INFO_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  CIS_CONT_INFO_PURPOSE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  CIS_CONT_INFO_PURPOSE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  CIS_CONT_INFO_PURPOSE_H_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H MODIFY 
  CIS_CONT_INFO_PURPOSE_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  CIS_PARTY_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  CIS_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  CIS_CONT_INFO_PROF_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  CIS_CONT_INFO_PROF_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  CIS_CONT_INFO_PROF_H_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PROF_H MODIFY 
  CIS_CONT_INFO_PROF_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  CIS_PREF_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  CIS_PREF_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  CIS_CONT_INFO_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  CIS_CONT_INFO_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  CIS_CONT_INFO_PREF_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  CIS_CONT_INFO_PREF_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  CIS_CONT_INFO_PREF_H_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PREF_H MODIFY 
  CIS_CONT_INFO_PREF_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  COUNTRY_CD NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  COUNTRY_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  CIS_PHONE_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  CIS_PHONE_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  CIS_CONT_INFO_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  CIS_CONT_INFO_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  CIS_CONT_INFO_PHONE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  CIS_CONT_INFO_PHONE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  CIS_CONT_INFO_PHONE_H_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H MODIFY 
  CIS_CONT_INFO_PHONE_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  CIS_CONT_INFO_PROF_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  CIS_CONT_INFO_PROF_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  CIS_CONT_INFO_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  CIS_CONT_INFO_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  CIS_CONT_INFO_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  CIS_CONT_INFO_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  CIS_CONT_INFO_H_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_H MODIFY 
  CIS_CONT_INFO_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  EMAIL_ADDR_TX NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  EMAIL_ADDR_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  CIS_CONT_INFO_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  CIS_CONT_INFO_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  CIS_EMAIL_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  CIS_EMAIL_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  CIS_CONT_INFO_EMAIL_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  CIS_CONT_INFO_EMAIL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  CIS_CONT_INFO_EMAIL_H_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H MODIFY 
  CIS_CONT_INFO_EMAIL_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  EFCTV_START_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  EFCTV_START_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  CIS_INFLGHT_DATA_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  CIS_INFLGHT_DATA_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  CIS_CONT_INFO_DATA_QUAL_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  CIS_CONT_INFO_DATA_QUAL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  CIS_CONT_INFO_DATA_QUAL_H_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H MODIFY 
  CIS_CONT_INFO_DATA_QUAL_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  COUNTRY_CD_TX NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  COUNTRY_CD_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  CITY_TX NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  CITY_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  LINE_1 NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  LINE_1 NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  CIS_ADDRESS_TYPE_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  CIS_ADDRESS_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  CIS_CONT_INFO_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  CIS_CONT_INFO_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  CIS_CONT_INFO_ADDR_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  CIS_CONT_INFO_ADDR_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  CIS_CONT_INFO_ADDR_H_ID NULL;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H MODIFY 
  CIS_CONT_INFO_ADDR_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NULL;

ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  CIS_PROVENANCE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  REC_CRTD_DT NULL;

ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  REC_CRTD_DT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NULL;

ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  REC_MDFD_TYPE_CD NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NULL;

ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  REC_CRTR_PARTY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  REC_MDFD_CNT NULL;

ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  REC_MDFD_CNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  ADDR_TYPE_DESC_TX NULL;

ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  ADDR_TYPE_DESC_TX NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  ADDR_TYPE_NM NULL;

ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  ADDR_TYPE_NM NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  CIS_ADDRESS_TYPE_ID NULL;

ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  CIS_ADDRESS_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  CIS_ADDRESS_TYPE_H_ID NULL;

ALTER TABLE CIS.CIS_ADDRESS_TYPE_H MODIFY 
  CIS_ADDRESS_TYPE_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE CIS.CIS_JOB_RUN_TYPE
  DROP CONSTRAINT JOBRUNTYPE_PROV_FK;


ALTER TABLE CIS.CIS_JOB_RUN_TYPE ADD (
  CONSTRAINT JOBRUNTYPE_PROV_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_JOB_CONTROL
  DROP CONSTRAINT JOBCONTROL_CIS_PROV_FK;


ALTER TABLE CIS.CIS_JOB_CONTROL ADD (
  CONSTRAINT JOBCONTROL_CIS_PROV_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_JOB_CONTROL
  DROP CONSTRAINT JOBCONTROL_CIS_JOBRUNTYPE_FK;


ALTER TABLE CIS.CIS_JOB_CONTROL ADD (
  CONSTRAINT JOBCONTROL_CIS_JOBRUNTYPE_FK 
  FOREIGN KEY (CIS_JOB_RUN_TYPE_ID) 
  REFERENCES CIS.CIS_JOB_RUN_TYPE (CIS_JOB_RUN_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_JOB_CONTROL
  DROP CONSTRAINT JOBCNTL_JOBCNTLSTATRSNTYPE_FK;


ALTER TABLE CIS.CIS_JOB_CONTROL ADD (
  CONSTRAINT JOBCNTL_JOBCNTLSTATRSNTYPE_FK 
  FOREIGN KEY (CIS_JOB_CNTL_STAT_RSN_TYPE_ID) 
  REFERENCES CIS.CIS_JOB_CNTL_STAT_RSN_TYPE (CIS_JOB_CNTL_STAT_RSN_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_JOB_CONTROL
  DROP CONSTRAINT JOBCNTL_JOBCNTLSTASTYPE_FK;


ALTER TABLE CIS.CIS_JOB_CONTROL ADD (
  CONSTRAINT JOBCNTL_JOBCNTLSTASTYPE_FK 
  FOREIGN KEY (CIS_JOB_CNTL_STATUS_TYPE_ID) 
  REFERENCES CIS.CIS_JOB_CNTL_STATUS_TYPE (CIS_JOB_CNTL_STATUS_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_JOB_CNTL_STATUS_TYPE
  DROP CONSTRAINT JOBCNTLSTATUSTYPE_PROV_FK_I;


ALTER TABLE CIS.CIS_JOB_CNTL_STATUS_TYPE ADD (
  CONSTRAINT JOBCNTLSTATUSTYPE_PROV_FK_I 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_JOB_CNTL_STAT_RSN_TYPE
  DROP CONSTRAINT JOBCNTLSTATRSNTYPE_PROV_FK;


ALTER TABLE CIS.CIS_JOB_CNTL_STAT_RSN_TYPE ADD (
  CONSTRAINT JOBCNTLSTATRSNTYPE_PROV_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE
  DROP CONSTRAINT CIS_VLDTN_STATUS_TYPE_PK;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE ADD (
  CONSTRAINT CIS_VLDTN_STATUS_TYPE_PK
  PRIMARY KEY
  (CIS_VLDTN_STATUS_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE
  DROP CONSTRAINT CIS_VLDTN_STATUS_TYPE_NM_UK;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE ADD (
  CONSTRAINT CIS_VLDTN_STATUS_TYPE_NM_UK
  UNIQUE (VLDTN_STATUS_TYPE_NM)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H
  DROP CONSTRAINT CIS_VLDTN_STATUS_TYPE_H_PK;

ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE_H ADD (
  CONSTRAINT CIS_VLDTN_STATUS_TYPE_H_PK
  PRIMARY KEY
  (CIS_VLDTN_STATUS_TYPE_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_RSLT
  DROP CONSTRAINT CIS_VLDTN_RSLT_PK;

ALTER TABLE CIS.CIS_VLDTN_RSLT ADD (
  CONSTRAINT CIS_VLDTN_RSLT_PK
  PRIMARY KEY
  (CIS_VLDTN_RSLT_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_RSLT_H
  DROP CONSTRAINT CIS_VLDTN_RSLT_H_PK;

ALTER TABLE CIS.CIS_VLDTN_RSLT_H ADD (
  CONSTRAINT CIS_VLDTN_RSLT_H_PK
  PRIMARY KEY
  (CIS_VLDTN_RSLT_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB
  DROP CONSTRAINT CIS_VLDTN_RSLT_CLOB_PFK;

ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB ADD (
  CONSTRAINT CIS_VLDTN_RSLT_CLOB_PFK
  PRIMARY KEY
  (CIS_VLDTN_RSLT_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB_H
  DROP CONSTRAINT CIS_VLDTN_RSLT_CLOB_H_PK;

ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB_H ADD (
  CONSTRAINT CIS_VLDTN_RSLT_CLOB_H_PK
  PRIMARY KEY
  (CIS_VLDTN_RSLT_CLOB_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB
  DROP CONSTRAINT CIS_VLDTN_RSLT_CLOB_FK;


ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB ADD (
  CONSTRAINT CIS_VLDTN_RSLT_CLOB_FK 
  FOREIGN KEY (CIS_VLDTN_RSLT_ID) 
  REFERENCES CIS.CIS_VLDTN_RSLT (CIS_VLDTN_RSLT_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_PRBLM
  DROP CONSTRAINT CIS_VLDTN_PRBLM_TY_PRBLM_FK;


ALTER TABLE CIS.CIS_VLDTN_PRBLM ADD (
  CONSTRAINT CIS_VLDTN_PRBLM_TY_PRBLM_FK 
  FOREIGN KEY (CIS_VLDTN_PRBLM_TYPE_ID) 
  REFERENCES CIS.CIS_VLDTN_PRBLM_TYPE (CIS_VLDTN_PRBLM_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE
  DROP CONSTRAINT CIS_VLDTN_PRBLM_TYPE_PK;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE ADD (
  CONSTRAINT CIS_VLDTN_PRBLM_TYPE_PK
  PRIMARY KEY
  (CIS_VLDTN_PRBLM_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE
  DROP CONSTRAINT CIS_VLDTN_PRBLM_TYPE_NM_UK;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE ADD (
  CONSTRAINT CIS_VLDTN_PRBLM_TYPE_NM_UK
  UNIQUE (VLDTN_PRBLM_TYPE_NM)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H
  DROP CONSTRAINT CIS_VLDTN_PRBLM_TYPE_H_PK;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE_H ADD (
  CONSTRAINT CIS_VLDTN_PRBLM_TYPE_H_PK
  PRIMARY KEY
  (CIS_VLDTN_PRBLM_TYPE_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_PRBLM
  DROP CONSTRAINT CIS_VLDTN_PRBLM_PK;

ALTER TABLE CIS.CIS_VLDTN_PRBLM ADD (
  CONSTRAINT CIS_VLDTN_PRBLM_PK
  PRIMARY KEY
  (CIS_VLDTN_PRBLM_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_PRBLM_H
  DROP CONSTRAINT CIS_VLDTN_PRBLM_H_PK;

ALTER TABLE CIS.CIS_VLDTN_PRBLM_H ADD (
  CONSTRAINT CIS_VLDTN_PRBLM_H_PK
  PRIMARY KEY
  (CIS_VLDTN_PRBLM_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_INFLGHT_DATA
  DROP CONSTRAINT CIS_VLDTN_OVERRIDE_FLG_CHK;

ALTER TABLE CIS.CIS_INFLGHT_DATA ADD (
  CONSTRAINT CIS_VLDTN_OVERRIDE_FLG_CHK
  CHECK (VLDTN_OVERRIDE_FLG IN ('Y','N'))
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_RSLT
  DROP CONSTRAINT CIS_VLDTNSTTS_RSLT_DLVRYPNT_FK;


ALTER TABLE CIS.CIS_VLDTN_RSLT ADD (
  CONSTRAINT CIS_VLDTNSTTS_RSLT_DLVRYPNT_FK 
  FOREIGN KEY (CRCTD_DLVRY_PNT_VLDTN_STTS_ID) 
  REFERENCES CIS.CIS_VLDTN_STATUS_TYPE (CIS_VLDTN_STATUS_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_RSLT
  DROP CONSTRAINT CIS_VLDTNSTTS_RSLT_CRCTDSTS_FK;


ALTER TABLE CIS.CIS_VLDTN_RSLT ADD (
  CONSTRAINT CIS_VLDTNSTTS_RSLT_CRCTDSTS_FK 
  FOREIGN KEY (CRCTD_STTS_ID) 
  REFERENCES CIS.CIS_VLDTN_STATUS_TYPE (CIS_VLDTN_STATUS_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_PRBLM
  DROP CONSTRAINT CIS_VLDTNRSLT_VLDTNPROBLEM_FK;


ALTER TABLE CIS.CIS_VLDTN_PRBLM ADD (
  CONSTRAINT CIS_VLDTNRSLT_VLDTNPROBLEM_FK 
  FOREIGN KEY (CIS_VLDTN_RSLT_ID) 
  REFERENCES CIS.CIS_VLDTN_RSLT (CIS_VLDTN_RSLT_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_SUBSCRIBER
  DROP CONSTRAINT CIS_SUBSRIBER_PROVENANCID_FK;


ALTER TABLE CIS.CIS_SUBSCRIBER ADD (
  CONSTRAINT CIS_SUBSRIBER_PROVENANCID_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_SUBSCRIBER
  DROP CONSTRAINT CIS_SUBSCRIBER_PK;

ALTER TABLE CIS.CIS_SUBSCRIBER ADD (
  CONSTRAINT CIS_SUBSCRIBER_PK
  PRIMARY KEY
  (CIS_SUBSCRIBER_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_SUBSCRIBER
  DROP CONSTRAINT CIS_SUBSCRIBER_PARTYID_FK;


ALTER TABLE CIS.CIS_SUBSCRIBER ADD (
  CONSTRAINT CIS_SUBSCRIBER_PARTYID_FK 
  FOREIGN KEY (CIS_PARTY_ID) 
  REFERENCES CIS.CIS_PARTY (CIS_PARTY_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_STAT_TYPE
  DROP CONSTRAINT CIS_STATTYPE_PK;

ALTER TABLE CIS.CIS_STAT_TYPE ADD (
  CONSTRAINT CIS_STATTYPE_PK
  PRIMARY KEY
  (CIS_STAT_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_STAT_TYPE
  DROP CONSTRAINT CIS_STATTYPE_NM_UK;

ALTER TABLE CIS.CIS_STAT_TYPE ADD (
  CONSTRAINT CIS_STATTYPE_NM_UK
  UNIQUE (STAT_TYPE_NM)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS
  DROP CONSTRAINT CIS_STATTYPE_INFORULESTAT_FK;


ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS ADD (
  CONSTRAINT CIS_STATTYPE_INFORULESTAT_FK 
  FOREIGN KEY (CIS_STAT_TYPE_ID) 
  REFERENCES CIS.CIS_STAT_TYPE (CIS_STAT_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_STAT_TYPE_H
  DROP CONSTRAINT CIS_STATTYPE_H_PK;

ALTER TABLE CIS.CIS_STAT_TYPE_H ADD (
  CONSTRAINT CIS_STATTYPE_H_PK
  PRIMARY KEY
  (CIS_STAT_TYPE_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_STATUS
  DROP CONSTRAINT CIS_STATTYPE_CISINTSTAT_FK;


ALTER TABLE CIS.CIS_CONT_INFO_STATUS ADD (
  CONSTRAINT CIS_STATTYPE_CISINTSTAT_FK 
  FOREIGN KEY (CIS_INT_STAT_TYPE_ID) 
  REFERENCES CIS.CIS_STAT_TYPE (CIS_STAT_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_STATUS
  DROP CONSTRAINT CIS_STATTYPE_CISEXTSTAT_FK;


ALTER TABLE CIS.CIS_CONT_INFO_STATUS ADD (
  CONSTRAINT CIS_STATTYPE_CISEXTSTAT_FK 
  FOREIGN KEY (CIS_EXT_STAT_TYPE_ID) 
  REFERENCES CIS.CIS_STAT_TYPE (CIS_STAT_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_RULE_TYPE
  DROP CONSTRAINT CIS_RULETYPE_PK;

ALTER TABLE CIS.CIS_RULE_TYPE ADD (
  CONSTRAINT CIS_RULETYPE_PK
  PRIMARY KEY
  (CIS_RULE_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_RULE_TYPE
  DROP CONSTRAINT CIS_RULETYPE_NM_UK;

ALTER TABLE CIS.CIS_RULE_TYPE ADD (
  CONSTRAINT CIS_RULETYPE_NM_UK
  UNIQUE (RULE_TYPE_NM)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS
  DROP CONSTRAINT CIS_RULETYPE_INFORULESTAT_FK;


ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS ADD (
  CONSTRAINT CIS_RULETYPE_INFORULESTAT_FK 
  FOREIGN KEY (CIS_RULE_TYPE_ID) 
  REFERENCES CIS.CIS_RULE_TYPE (CIS_RULE_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_RULE_TYPE_H
  DROP CONSTRAINT CIS_RULETYPE_H_PK;

ALTER TABLE CIS.CIS_RULE_TYPE_H ADD (
  CONSTRAINT CIS_RULETYPE_H_PK
  PRIMARY KEY
  (CIS_RULE_TYPE_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE
  DROP CONSTRAINT CIS_PURPTYP_CONTINFOPRPS_FK;


ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE ADD (
  CONSTRAINT CIS_PURPTYP_CONTINFOPRPS_FK 
  FOREIGN KEY (CIS_PURP_TYPE_ID) 
  REFERENCES CIS.CIS_PURPOSE_TYPE (CIS_PURP_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PURPOSE_TYPE
  DROP CONSTRAINT CIS_PURPOSEYPE_NM_UK;

ALTER TABLE CIS.CIS_PURPOSE_TYPE ADD (
  CONSTRAINT CIS_PURPOSEYPE_NM_UK
  UNIQUE (PURP_TYPE_NM)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PURPOSE_TYPE
  DROP CONSTRAINT CIS_PURPOSETYPE_PK;

ALTER TABLE CIS.CIS_PURPOSE_TYPE ADD (
  CONSTRAINT CIS_PURPOSETYPE_PK
  PRIMARY KEY
  (CIS_PURP_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PURPOSE_TYPE_H
  DROP CONSTRAINT CIS_PURPOSETYPE_H_PK;

ALTER TABLE CIS.CIS_PURPOSE_TYPE_H ADD (
  CONSTRAINT CIS_PURPOSETYPE_H_PK
  PRIMARY KEY
  (CIS_PURP_TYPE_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE
  DROP CONSTRAINT CIS_PRVNC_VLDTNSTTSTY_FK;


ALTER TABLE CIS.CIS_VLDTN_STATUS_TYPE ADD (
  CONSTRAINT CIS_PRVNC_VLDTNSTTSTY_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_RSLT
  DROP CONSTRAINT CIS_PRVNC_VLDTNRSLT_FK;


ALTER TABLE CIS.CIS_VLDTN_RSLT ADD (
  CONSTRAINT CIS_PRVNC_VLDTNRSLT_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB
  DROP CONSTRAINT CIS_PRVNC_VLDTNRSLTCLOB_FK;


ALTER TABLE CIS.CIS_VLDTN_RSLT_CLOB ADD (
  CONSTRAINT CIS_PRVNC_VLDTNRSLTCLOB_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_PRBLM
  DROP CONSTRAINT CIS_PRVNC_VLDTNPRBLM_FK;


ALTER TABLE CIS.CIS_VLDTN_PRBLM ADD (
  CONSTRAINT CIS_PRVNC_VLDTNPRBLM_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE
  DROP CONSTRAINT CIS_PRVNC_VLDTNPRBLMTY_FK;


ALTER TABLE CIS.CIS_VLDTN_PRBLM_TYPE ADD (
  CONSTRAINT CIS_PRVNC_VLDTNPRBLMTY_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS
  DROP CONSTRAINT CIS_PRVNC_TYPE_PRPS_RLN_FK;


ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS ADD (
  CONSTRAINT CIS_PRVNC_TYPE_PRPS_RLN_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_STAT_TYPE
  DROP CONSTRAINT CIS_PRVNC_STATTY_FK;


ALTER TABLE CIS.CIS_STAT_TYPE ADD (
  CONSTRAINT CIS_PRVNC_STATTY_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_RULE_TYPE
  DROP CONSTRAINT CIS_PRVNC_RULETY_FK;


ALTER TABLE CIS.CIS_RULE_TYPE ADD (
  CONSTRAINT CIS_PRVNC_RULETY_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PURPOSE_TYPE
  DROP CONSTRAINT CIS_PRVNC_PRPSTY_FK;


ALTER TABLE CIS.CIS_PURPOSE_TYPE ADD (
  CONSTRAINT CIS_PRVNC_PRPSTY_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PREF_TYPE
  DROP CONSTRAINT CIS_PRVNC_PREFTY_FK;


ALTER TABLE CIS.CIS_PREF_TYPE ADD (
  CONSTRAINT CIS_PRVNC_PREFTY_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY
  DROP CONSTRAINT CIS_PRVNC_PARTY_FK;


ALTER TABLE CIS.CIS_PARTY ADD (
  CONSTRAINT CIS_PRVNC_PARTY_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE
  DROP CONSTRAINT CIS_PRVNC_PARTYSRCIDTY_FK;


ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE ADD (
  CONSTRAINT CIS_PRVNC_PARTYSRCIDTY_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_RLNSHP
  DROP CONSTRAINT CIS_PRVNC_PARTYRLNSHP_FK;


ALTER TABLE CIS.CIS_PARTY_RLNSHP ADD (
  CONSTRAINT CIS_PRVNC_PARTYRLNSHP_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE
  DROP CONSTRAINT CIS_PRVNC_PARTYRLNSHPTY_FK;


ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE ADD (
  CONSTRAINT CIS_PRVNC_PARTYRLNSHPTY_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PHONE_TYPE
  DROP CONSTRAINT CIS_PRVNC_PARTYPHNTY_FK;


ALTER TABLE CIS.CIS_PHONE_TYPE ADD (
  CONSTRAINT CIS_PRVNC_PARTYPHNTY_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_INFO
  DROP CONSTRAINT CIS_PRVNC_PARTYINFO_FK;


ALTER TABLE CIS.CIS_PARTY_INFO ADD (
  CONSTRAINT CIS_PRVNC_PARTYINFO_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_INFLGHT_DATA
  DROP CONSTRAINT CIS_PRVNC_INFLGHT_FK;


ALTER TABLE CIS.CIS_INFLGHT_DATA ADD (
  CONSTRAINT CIS_PRVNC_INFLGHT_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE
  DROP CONSTRAINT CIS_PRVNC_INFLGHTSTTY_FK;


ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE ADD (
  CONSTRAINT CIS_PRVNC_INFLGHTSTTY_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS
  DROP CONSTRAINT CIS_PRVNC_INFLGHTDTST_FK;


ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS ADD (
  CONSTRAINT CIS_PRVNC_INFLGHTDTST_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO
  DROP CONSTRAINT CIS_PRVNC_CONTINFO_FK;


ALTER TABLE CIS.CIS_CONT_INFO ADD (
  CONSTRAINT CIS_PRVNC_CONTINFO_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_TYPE
  DROP CONSTRAINT CIS_PRVNC_CONTINFOTYP_FK;


ALTER TABLE CIS.CIS_CONT_INFO_TYPE ADD (
  CONSTRAINT CIS_PRVNC_CONTINFOTYP_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_STATUS
  DROP CONSTRAINT CIS_PRVNC_CONTINFOSTTS_FK;


ALTER TABLE CIS.CIS_CONT_INFO_STATUS ADD (
  CONSTRAINT CIS_PRVNC_CONTINFOSTTS_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS
  DROP CONSTRAINT CIS_PRVNC_CONTINFORLST_FK;


ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS ADD (
  CONSTRAINT CIS_PRVNC_CONTINFORLST_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE
  DROP CONSTRAINT CIS_PRVNC_CONTINFOPRPS_FK;


ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE ADD (
  CONSTRAINT CIS_PRVNC_CONTINFOPRPS_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PROF
  DROP CONSTRAINT CIS_PRVNC_CONTINFOPRFL_FK;


ALTER TABLE CIS.CIS_CONT_INFO_PROF ADD (
  CONSTRAINT CIS_PRVNC_CONTINFOPRFL_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PREF
  DROP CONSTRAINT CIS_PRVNC_CONTINFOPREF_FK;


ALTER TABLE CIS.CIS_CONT_INFO_PREF ADD (
  CONSTRAINT CIS_PRVNC_CONTINFOPREF_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PHONE
  DROP CONSTRAINT CIS_PRVNC_CONTINFOPHN_FK;


ALTER TABLE CIS.CIS_CONT_INFO_PHONE ADD (
  CONSTRAINT CIS_PRVNC_CONTINFOPHN_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL
  DROP CONSTRAINT CIS_PRVNC_CONTINFOEMAIL_FK;


ALTER TABLE CIS.CIS_CONT_INFO_EMAIL ADD (
  CONSTRAINT CIS_PRVNC_CONTINFOEMAIL_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_EMAIL_TYPE
  DROP CONSTRAINT CIS_PRVNC_CONTINFOEMAILTY_FK;


ALTER TABLE CIS.CIS_EMAIL_TYPE ADD (
  CONSTRAINT CIS_PRVNC_CONTINFOEMAILTY_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY
  DROP CONSTRAINT CIS_PRVNC_CONTINFODQ_FK;


ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY ADD (
  CONSTRAINT CIS_PRVNC_CONTINFODQ_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS
  DROP CONSTRAINT CIS_PRVNC_CONTINFOADR_FK;


ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS ADD (
  CONSTRAINT CIS_PRVNC_CONTINFOADR_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_ADDRESS_TYPE
  DROP CONSTRAINT CIS_PRVNC_ADDR_TYPE_FK;


ALTER TABLE CIS.CIS_ADDRESS_TYPE ADD (
  CONSTRAINT CIS_PRVNC_ADDR_TYPE_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_INFO
  DROP CONSTRAINT CIS_PRTYSRCIDTY_PRTYINFO_FK;


ALTER TABLE CIS.CIS_PARTY_INFO ADD (
  CONSTRAINT CIS_PRTYSRCIDTY_PRTYINFO_FK 
  FOREIGN KEY (CIS_PARTY_SRC_ID_TYPE_ID) 
  REFERENCES CIS.CIS_PARTY_SRC_ID_TYPE (CIS_PARTY_SRC_ID_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS
  DROP CONSTRAINT CIS_PRPS_TYPE_PRPS_FK;


ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS ADD (
  CONSTRAINT CIS_PRPS_TYPE_PRPS_FK 
  FOREIGN KEY (CIS_PURP_TYPE_ID) 
  REFERENCES CIS.CIS_PURPOSE_TYPE (CIS_PURP_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PROPAGATE_EVENT
  DROP CONSTRAINT CIS_PRPGTEVNT_CONTINFOHID_FK;


ALTER TABLE CIS.CIS_PROPAGATE_EVENT ADD (
  CONSTRAINT CIS_PRPGTEVNT_CONTINFOHID_FK 
  FOREIGN KEY (CIS_CONT_INFO_H_ID) 
  REFERENCES CIS.CIS_CONT_INFO_H (CIS_CONT_INFO_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK
  DROP CONSTRAINT CIS_PRPGTEVNTACK_PROVNID_FK;


ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK ADD (
  CONSTRAINT CIS_PRPGTEVNTACK_PROVNID_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PROPAGATE_EVENT
  DROP CONSTRAINT CIS_PRPGTEVENT_PROVNANCID_FK;


ALTER TABLE CIS.CIS_PROPAGATE_EVENT ADD (
  CONSTRAINT CIS_PRPGTEVENT_PROVNANCID_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK
  DROP CONSTRAINT CIS_PRPGTEVENTACK_SUBSID_FK_I;


ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK ADD (
  CONSTRAINT CIS_PRPGTEVENTACK_SUBSID_FK_I 
  FOREIGN KEY (CIS_SUBSCRIBER_ID) 
  REFERENCES CIS.CIS_SUBSCRIBER (CIS_SUBSCRIBER_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK
  DROP CONSTRAINT CIS_PRPGTEVENTACK_EVENTID_FK;


ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK ADD (
  CONSTRAINT CIS_PRPGTEVENTACK_EVENTID_FK 
  FOREIGN KEY (CIS_PROPAGATE_EVENT_ID) 
  REFERENCES CIS.CIS_PROPAGATE_EVENT (CIS_PROPAGATE_EVENT_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PROVENANCE
  DROP CONSTRAINT CIS_PROVENANCE_PK;

ALTER TABLE CIS.CIS_PROVENANCE ADD (
  CONSTRAINT CIS_PROVENANCE_PK
  PRIMARY KEY
  (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PROPAGATE_EVENT
  DROP CONSTRAINT CIS_PROPAGATE_RQRD_IND_CHK;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT ADD (
  CONSTRAINT CIS_PROPAGATE_RQRD_IND_CHK
  CHECK (PROPAGATE_RQRD_IND in ('Y','N','A'))
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PROPAGATE_EVENT
  DROP CONSTRAINT CIS_PROPAGATE_EVENT_PK;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT ADD (
  CONSTRAINT CIS_PROPAGATE_EVENT_PK
  PRIMARY KEY
  (CIS_PROPAGATE_EVENT_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H
  DROP CONSTRAINT CIS_PROPAGATE_EVENT_H_PK;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT_H ADD (
  CONSTRAINT CIS_PROPAGATE_EVENT_H_PK
  PRIMARY KEY
  (CIS_PROPAGATE_EVENT_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK
  DROP CONSTRAINT CIS_PROPAGATE_EVENT_ACK_PK;

ALTER TABLE CIS.CIS_PROPAGATE_EVENT_ACK ADD (
  CONSTRAINT CIS_PROPAGATE_EVENT_ACK_PK
  PRIMARY KEY
  (CIS_PROPAGATE_EVENT_ACK_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PREF_TYPE
  DROP CONSTRAINT CIS_PREFTYPE_NM_UK;

ALTER TABLE CIS.CIS_PREF_TYPE ADD (
  CONSTRAINT CIS_PREFTYPE_NM_UK
  UNIQUE (PREF_TYPE_NM)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PREF
  DROP CONSTRAINT CIS_PREFTYPE_INFOPREF_FK;


ALTER TABLE CIS.CIS_CONT_INFO_PREF ADD (
  CONSTRAINT CIS_PREFTYPE_INFOPREF_FK 
  FOREIGN KEY (CIS_PREF_TYPE_ID) 
  REFERENCES CIS.CIS_PREF_TYPE (CIS_PREF_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PREF_TYPE
  DROP CONSTRAINT CIS_PREFTYPECD_PK;

ALTER TABLE CIS.CIS_PREF_TYPE ADD (
  CONSTRAINT CIS_PREFTYPECD_PK
  PRIMARY KEY
  (CIS_PREF_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PREF_TYPE_H
  DROP CONSTRAINT CIS_PREFTYPECD_H_PK;

ALTER TABLE CIS.CIS_PREF_TYPE_H ADD (
  CONSTRAINT CIS_PREFTYPECD_H_PK
  PRIMARY KEY
  (CIS_PREF_TYPE_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PHONE
  DROP CONSTRAINT CIS_PHONE_ORDLTY_CHK;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE ADD (
  CONSTRAINT CIS_PHONE_ORDLTY_CHK
  CHECK (PHONE_ORDLTY IN ('Primary','Secondary','Tertiary'))
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PHONE_TYPE
  DROP CONSTRAINT CIS_PHONETYPE_PK;

ALTER TABLE CIS.CIS_PHONE_TYPE ADD (
  CONSTRAINT CIS_PHONETYPE_PK
  PRIMARY KEY
  (CIS_PHONE_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PHONE_TYPE
  DROP CONSTRAINT CIS_PHONETYPE_NM_UK;

ALTER TABLE CIS.CIS_PHONE_TYPE ADD (
  CONSTRAINT CIS_PHONETYPE_NM_UK
  UNIQUE (PHONE_TYPE_NM)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PHONE_TYPE_H
  DROP CONSTRAINT CIS_PHONETYPE_H_PK;

ALTER TABLE CIS.CIS_PHONE_TYPE_H ADD (
  CONSTRAINT CIS_PHONETYPE_H_PK
  PRIMARY KEY
  (CIS_PHONE_TYPE_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PHONE
  DROP CONSTRAINT CIS_PHONETYPE_CONTINFOPH_FK;


ALTER TABLE CIS.CIS_CONT_INFO_PHONE ADD (
  CONSTRAINT CIS_PHONETYPE_CONTINFOPH_FK 
  FOREIGN KEY (CIS_PHONE_TYPE_ID) 
  REFERENCES CIS.CIS_PHONE_TYPE (CIS_PHONE_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H
  DROP CONSTRAINT CIS_PARTY_SRCID_TYPE_H_PK;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE_H ADD (
  CONSTRAINT CIS_PARTY_SRCID_TYPE_H_PK
  PRIMARY KEY
  (CIS_PARTY_SRC_ID_TYPE_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_RLNSHP
  DROP CONSTRAINT CIS_PARTY_RELATETYPE_RELSHP_FK;


ALTER TABLE CIS.CIS_PARTY_RLNSHP ADD (
  CONSTRAINT CIS_PARTY_RELATETYPE_RELSHP_FK 
  FOREIGN KEY (CIS_PARTY_RLNSHP_TYPE_ID) 
  REFERENCES CIS.CIS_PARTY_RLNSHP_TYPE (CIS_PARTY_RLNSHP_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PROVENANCE
  DROP CONSTRAINT CIS_PARTY_PRVNNCE_CRTR_FK;


ALTER TABLE CIS.CIS_PROVENANCE ADD (
  CONSTRAINT CIS_PARTY_PRVNNCE_CRTR_FK 
  FOREIGN KEY (REC_CRTR_PARTY_ID) 
  REFERENCES CIS.CIS_PARTY (CIS_PARTY_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PROVENANCE
  DROP CONSTRAINT CIS_PARTY_PRVNNCE_APLCTN_FK;


ALTER TABLE CIS.CIS_PROVENANCE ADD (
  CONSTRAINT CIS_PARTY_PRVNNCE_APLCTN_FK 
  FOREIGN KEY (SRC_APLCTN_PARTY_ID) 
  REFERENCES CIS.CIS_PARTY (CIS_PARTY_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY
  DROP CONSTRAINT CIS_PARTY_PK;

ALTER TABLE CIS.CIS_PARTY ADD (
  CONSTRAINT CIS_PARTY_PK
  PRIMARY KEY
  (CIS_PARTY_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_RLNSHP
  DROP CONSTRAINT CIS_PARTY_PARTYRELSHPSEC_FK;


ALTER TABLE CIS.CIS_PARTY_RLNSHP ADD (
  CONSTRAINT CIS_PARTY_PARTYRELSHPSEC_FK 
  FOREIGN KEY (CIS_SEC_PARTY_ID) 
  REFERENCES CIS.CIS_PARTY (CIS_PARTY_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_RLNSHP
  DROP CONSTRAINT CIS_PARTY_PARTYRELSHPPRI_FK;


ALTER TABLE CIS.CIS_PARTY_RLNSHP ADD (
  CONSTRAINT CIS_PARTY_PARTYRELSHPPRI_FK 
  FOREIGN KEY (CIS_PRI_PARTY_ID) 
  REFERENCES CIS.CIS_PARTY (CIS_PARTY_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_INFO
  DROP CONSTRAINT CIS_PARTY_PARTYHISTORY_FK;


ALTER TABLE CIS.CIS_PARTY_INFO ADD (
  CONSTRAINT CIS_PARTY_PARTYHISTORY_FK 
  FOREIGN KEY (CIS_PARTY_ID) 
  REFERENCES CIS.CIS_PARTY (CIS_PARTY_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_INFO_H
  DROP CONSTRAINT CIS_PARTY_INFO_H_PK;

ALTER TABLE CIS.CIS_PARTY_INFO_H ADD (
  CONSTRAINT CIS_PARTY_INFO_H_PK
  PRIMARY KEY
  (CIS_PARTY_INFO_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PROF
  DROP CONSTRAINT CIS_PARTY_CONTINFOPROF_FK;


ALTER TABLE CIS.CIS_CONT_INFO_PROF ADD (
  CONSTRAINT CIS_PARTY_CONTINFOPROF_FK 
  FOREIGN KEY (CIS_PARTY_ID) 
  REFERENCES CIS.CIS_PARTY (CIS_PARTY_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE
  DROP CONSTRAINT CIS_PARTYSRCIDTYPE_PK;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE ADD (
  CONSTRAINT CIS_PARTYSRCIDTYPE_PK
  PRIMARY KEY
  (CIS_PARTY_SRC_ID_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE
  DROP CONSTRAINT CIS_PARTYSRCIDTYPE_NM_UK;

ALTER TABLE CIS.CIS_PARTY_SRC_ID_TYPE ADD (
  CONSTRAINT CIS_PARTYSRCIDTYPE_NM_UK
  UNIQUE (PARTY_SRC_ID_TYPE_NM)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO
  DROP CONSTRAINT CIS_PARTYRLNSHP_CONTINFO_FK;


ALTER TABLE CIS.CIS_CONT_INFO ADD (
  CONSTRAINT CIS_PARTYRLNSHP_CONTINFO_FK 
  FOREIGN KEY (CIS_PARTY_RLNSHP_ID) 
  REFERENCES CIS.CIS_PARTY_RLNSHP (CIS_PARTY_RLNSHP_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE
  DROP CONSTRAINT CIS_PARTYRLNSHPTYPE_PK;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE ADD (
  CONSTRAINT CIS_PARTYRLNSHPTYPE_PK
  PRIMARY KEY
  (CIS_PARTY_RLNSHP_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE
  DROP CONSTRAINT CIS_PARTYRLNSHPTYPE_NM_UK;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE ADD (
  CONSTRAINT CIS_PARTYRLNSHPTYPE_NM_UK
  UNIQUE (PARTY_RLNSHP_NM)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_RLNSHP
  DROP CONSTRAINT CIS_PARTYRELSHP_PK;

ALTER TABLE CIS.CIS_PARTY_RLNSHP ADD (
  CONSTRAINT CIS_PARTYRELSHP_PK
  PRIMARY KEY
  (CIS_PARTY_RLNSHP_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_RLNSHP_H
  DROP CONSTRAINT CIS_PARTYRELSHP_H_PK;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_H ADD (
  CONSTRAINT CIS_PARTYRELSHP_H_PK
  PRIMARY KEY
  (CIS_PARTY_RLNSHP_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H
  DROP CONSTRAINT CIS_PARTYRELATEDTYPE_H_PK;

ALTER TABLE CIS.CIS_PARTY_RLNSHP_TYPE_H ADD (
  CONSTRAINT CIS_PARTYRELATEDTYPE_H_PK
  PRIMARY KEY
  (CIS_PARTY_RLNSHP_TYPE_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_INFO
  DROP CONSTRAINT CIS_PARTYINFO_UK;

ALTER TABLE CIS.CIS_PARTY_INFO ADD (
  CONSTRAINT CIS_PARTYINFO_UK
  UNIQUE (CIS_PARTY_SRC_ID_TYPE_ID, CIS_PARTY_ID, EFCTV_START_DT)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_PARTY_INFO
  DROP CONSTRAINT CIS_PARTYINFO_PK;

ALTER TABLE CIS.CIS_PARTY_INFO ADD (
  CONSTRAINT CIS_PARTYINFO_PK
  PRIMARY KEY
  (CIS_PARTY_INFO_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO
  DROP CONSTRAINT CIS_PARTYINFO_CONTINFO_FK;


ALTER TABLE CIS.CIS_CONT_INFO ADD (
  CONSTRAINT CIS_PARTYINFO_CONTINFO_FK 
  FOREIGN KEY (SRC_PARTY_INFO_ID) 
  REFERENCES CIS.CIS_PARTY_INFO (CIS_PARTY_INFO_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_JOB_RUN_TYPE
  DROP CONSTRAINT CIS_JOB_RUN_TYPE_PK;

ALTER TABLE CIS.CIS_JOB_RUN_TYPE ADD (
  CONSTRAINT CIS_JOB_RUN_TYPE_PK
  PRIMARY KEY
  (CIS_JOB_RUN_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_JOB_CONTROL
  DROP CONSTRAINT CIS_JOB_CONTROL_PK;

ALTER TABLE CIS.CIS_JOB_CONTROL ADD (
  CONSTRAINT CIS_JOB_CONTROL_PK
  PRIMARY KEY
  (CIS_JOB_CONTROL_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_JOB_CNTL_STAT_RSN_TYPE
  DROP CONSTRAINT CIS_JOB_CNTL_STAT_RSN_TYPE_PK;

ALTER TABLE CIS.CIS_JOB_CNTL_STAT_RSN_TYPE ADD (
  CONSTRAINT CIS_JOB_CNTL_STAT_RSN_TYPE_PK
  PRIMARY KEY
  (CIS_JOB_CNTL_STAT_RSN_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_JOB_CNTL_STATUS_TYPE
  DROP CONSTRAINT CIS_JOB_CNTL_STATUS_TYPE_PK;

ALTER TABLE CIS.CIS_JOB_CNTL_STATUS_TYPE ADD (
  CONSTRAINT CIS_JOB_CNTL_STATUS_TYPE_PK
  PRIMARY KEY
  (CIS_JOB_CNTL_STATUS_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS
  DROP CONSTRAINT CIS_INFLGHT_STTS_TY_DATA_FK;


ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS ADD (
  CONSTRAINT CIS_INFLGHT_STTS_TY_DATA_FK 
  FOREIGN KEY (CIS_INFLGHT_STATUS_TYPE_ID) 
  REFERENCES CIS.CIS_INFLGHT_STATUS_TYPE (CIS_INFLGHT_STATUS_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE
  DROP CONSTRAINT CIS_INFLGHT_STATUS_TYPE_PK;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE ADD (
  CONSTRAINT CIS_INFLGHT_STATUS_TYPE_PK
  PRIMARY KEY
  (CIS_INFLGHT_STATUS_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE
  DROP CONSTRAINT CIS_INFLGHT_STATUS_TYPE_NM_UK;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE ADD (
  CONSTRAINT CIS_INFLGHT_STATUS_TYPE_NM_UK
  UNIQUE (INFLGHT_STATUS_TYPE_NM)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H
  DROP CONSTRAINT CIS_INFLGHT_STATUS_TYPE_H_PK;

ALTER TABLE CIS.CIS_INFLGHT_STATUS_TYPE_H ADD (
  CONSTRAINT CIS_INFLGHT_STATUS_TYPE_H_PK
  PRIMARY KEY
  (CIS_INFLGHT_STATUS_TYPE_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS
  DROP CONSTRAINT CIS_INFLGHT_DATA_STATUS_PK;

ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS ADD (
  CONSTRAINT CIS_INFLGHT_DATA_STATUS_PK
  PRIMARY KEY
  (CIS_INFLGHT_DATA_STATUS_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_INFLGHT_DATA
  DROP CONSTRAINT CIS_INFLGHT_DATA_PK;

ALTER TABLE CIS.CIS_INFLGHT_DATA ADD (
  CONSTRAINT CIS_INFLGHT_DATA_PK
  PRIMARY KEY
  (CIS_INFLGHT_DATA_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY
  DROP CONSTRAINT CIS_INFLGHT_CI_DQ_FK;


ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY ADD (
  CONSTRAINT CIS_INFLGHT_CI_DQ_FK 
  FOREIGN KEY (CIS_INFLGHT_DATA_ID) 
  REFERENCES CIS.CIS_INFLGHT_DATA (CIS_INFLGHT_DATA_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS
  DROP CONSTRAINT CIS_INFLGHTDATA_STATUS_DATA_FK;


ALTER TABLE CIS.CIS_INFLGHT_DATA_STATUS ADD (
  CONSTRAINT CIS_INFLGHTDATA_STATUS_DATA_FK 
  FOREIGN KEY (CIS_INFLGHT_DATA_ID) 
  REFERENCES CIS.CIS_INFLGHT_DATA (CIS_INFLGHT_DATA_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_INFLGHT_DATA_CLOB
  DROP CONSTRAINT CIS_INFLGHTDATACLOBPROV_FK;


ALTER TABLE CIS.CIS_INFLGHT_DATA_CLOB ADD (
  CONSTRAINT CIS_INFLGHTDATACLOBPROV_FK 
  FOREIGN KEY (CIS_PROVENANCE_ID) 
  REFERENCES CIS.CIS_PROVENANCE (CIS_PROVENANCE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL
  DROP CONSTRAINT CIS_EMAILTYP_CONTINFEMAIL_FK;


ALTER TABLE CIS.CIS_CONT_INFO_EMAIL ADD (
  CONSTRAINT CIS_EMAILTYP_CONTINFEMAIL_FK 
  FOREIGN KEY (CIS_EMAIL_TYPE_ID) 
  REFERENCES CIS.CIS_EMAIL_TYPE (CIS_EMAIL_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_EMAIL_TYPE
  DROP CONSTRAINT CIS_EMAILTYPE_PK;

ALTER TABLE CIS.CIS_EMAIL_TYPE ADD (
  CONSTRAINT CIS_EMAILTYPE_PK
  PRIMARY KEY
  (CIS_EMAIL_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_EMAIL_TYPE
  DROP CONSTRAINT CIS_EMAILTYPE_NM_UK;

ALTER TABLE CIS.CIS_EMAIL_TYPE ADD (
  CONSTRAINT CIS_EMAILTYPE_NM_UK
  UNIQUE (EMAIL_TYPE_NM)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_EMAIL_TYPE_H
  DROP CONSTRAINT CIS_EMAILTYPE_H_PK;

ALTER TABLE CIS.CIS_EMAIL_TYPE_H ADD (
  CONSTRAINT CIS_EMAILTYPE_H_PK
  PRIMARY KEY
  (CIS_EMAIL_TYPE_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_INFLGHT_DATA
  DROP CONSTRAINT CIS_DATA_SRC_TXT_CHK;

ALTER TABLE CIS.CIS_INFLGHT_DATA ADD (
  CONSTRAINT CIS_DATA_SRC_TXT_CHK
  CHECK (DATA_SRC_TXT IN ('SEED-1','SEED-2', 'SEED-3', 'SEED-4','SERVICE'))
  ENABLE NOVALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS
  DROP CONSTRAINT CIS_CONT_INFO_TYPE_PRPS_PK;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS ADD (
  CONSTRAINT CIS_CONT_INFO_TYPE_PRPS_PK
  PRIMARY KEY
  (CIS_CONT_INFO_TYPE_PRPS_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H
  DROP CONSTRAINT CIS_CONT_INFO_TYPE_PRPS_H_PK;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS_H ADD (
  CONSTRAINT CIS_CONT_INFO_TYPE_PRPS_H_PK
  PRIMARY KEY
  (CIS_CONT_INFO_TYPE_PRPS_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO
  DROP CONSTRAINT CIS_CONT_INFO_ID_PK;

ALTER TABLE CIS.CIS_CONT_INFO ADD (
  CONSTRAINT CIS_CONT_INFO_ID_PK
  PRIMARY KEY
  (CIS_CONT_INFO_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_H
  DROP CONSTRAINT CIS_CONT_INFO_H_ID_PK;

ALTER TABLE CIS.CIS_CONT_INFO_H ADD (
  CONSTRAINT CIS_CONT_INFO_H_ID_PK
  PRIMARY KEY
  (CIS_CONT_INFO_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PHONE
  DROP CONSTRAINT CIS_CONTINF_CONTINFPHONE_FK;


ALTER TABLE CIS.CIS_CONT_INFO_PHONE ADD (
  CONSTRAINT CIS_CONTINF_CONTINFPHONE_FK 
  FOREIGN KEY (CIS_CONT_INFO_ID) 
  REFERENCES CIS.CIS_CONT_INFO (CIS_CONT_INFO_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL
  DROP CONSTRAINT CIS_CONTINF_CONTINFEMAIL_FK;


ALTER TABLE CIS.CIS_CONT_INFO_EMAIL ADD (
  CONSTRAINT CIS_CONTINF_CONTINFEMAIL_FK 
  FOREIGN KEY (CIS_CONT_INFO_ID) 
  REFERENCES CIS.CIS_CONT_INFO (CIS_CONT_INFO_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS
  DROP CONSTRAINT CIS_CONTINFSTAT_RULESTAT_FK;


ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS ADD (
  CONSTRAINT CIS_CONTINFSTAT_RULESTAT_FK 
  FOREIGN KEY (CIS_CONT_INFO_STATUS_ID) 
  REFERENCES CIS.CIS_CONT_INFO_STATUS (CIS_CONT_INFO_STATUS_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE
  DROP CONSTRAINT CIS_CONTINFO_PURP_FK;


ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE ADD (
  CONSTRAINT CIS_CONTINFO_PURP_FK 
  FOREIGN KEY (CIS_CONT_INFO_ID) 
  REFERENCES CIS.CIS_CONT_INFO (CIS_CONT_INFO_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PREF
  DROP CONSTRAINT CIS_CONTINFO_INFOPREF_FK;


ALTER TABLE CIS.CIS_CONT_INFO_PREF ADD (
  CONSTRAINT CIS_CONTINFO_INFOPREF_FK 
  FOREIGN KEY (CIS_CONT_INFO_ID) 
  REFERENCES CIS.CIS_CONT_INFO (CIS_CONT_INFO_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO
  DROP CONSTRAINT CIS_CONTINFO_HOMELESSIND_CHK;

ALTER TABLE CIS.CIS_CONT_INFO ADD (
  CONSTRAINT CIS_CONTINFO_HOMELESSIND_CHK
  CHECK (HOMELESS_IND IS NULL OR
HOMELESS_IND IN ('Y','N'))
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PHONE
  DROP CONSTRAINT CIS_CONTINFO_DMSTCIND_CHK;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE ADD (
  CONSTRAINT CIS_CONTINFO_DMSTCIND_CHK
  CHECK (DMSTC_IND  IN ('Y','N'))
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY
  DROP CONSTRAINT CIS_CONTINFO_DATAQUAL_FK;


ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY ADD (
  CONSTRAINT CIS_CONTINFO_DATAQUAL_FK 
  FOREIGN KEY (CIS_CONT_INFO_ID) 
  REFERENCES CIS.CIS_CONT_INFO (CIS_CONT_INFO_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS
  DROP CONSTRAINT CIS_CONTINFO_CONTINFOADDR_FK;


ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS ADD (
  CONSTRAINT CIS_CONTINFO_CONTINFOADDR_FK 
  FOREIGN KEY (CIS_CONT_INFO_ID) 
  REFERENCES CIS.CIS_CONT_INFO (CIS_CONT_INFO_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO
  DROP CONSTRAINT CIS_CONTINFOTYP_CONTINFO_FK;


ALTER TABLE CIS.CIS_CONT_INFO ADD (
  CONSTRAINT CIS_CONTINFOTYP_CONTINFO_FK 
  FOREIGN KEY (CIS_CONT_INFO_TYPE_ID) 
  REFERENCES CIS.CIS_CONT_INFO_TYPE (CIS_CONT_INFO_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_TYPE
  DROP CONSTRAINT CIS_CONTINFOTYPE_NM_UK;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE ADD (
  CONSTRAINT CIS_CONTINFOTYPE_NM_UK
  UNIQUE (CONT_INFO_TYPE_NM)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H
  DROP CONSTRAINT CIS_CONTINFOTYPE_H_PK;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE_H ADD (
  CONSTRAINT CIS_CONTINFOTYPE_H_PK
  PRIMARY KEY
  (CIS_CONT_INFO_TYPE_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_TYPE
  DROP CONSTRAINT CIS_CONTINFOTYPEID_PK;

ALTER TABLE CIS.CIS_CONT_INFO_TYPE ADD (
  CONSTRAINT CIS_CONTINFOTYPEID_PK
  PRIMARY KEY
  (CIS_CONT_INFO_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_STATUS
  DROP CONSTRAINT CIS_CONTINFOSTATUS_PK;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS ADD (
  CONSTRAINT CIS_CONTINFOSTATUS_PK
  PRIMARY KEY
  (CIS_CONT_INFO_STATUS_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H
  DROP CONSTRAINT CIS_CONTINFOSTATUS_H_PK;

ALTER TABLE CIS.CIS_CONT_INFO_STATUS_H ADD (
  CONSTRAINT CIS_CONTINFOSTATUS_H_PK
  PRIMARY KEY
  (CIS_CONT_INFO_STATUS_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS
  DROP CONSTRAINT CIS_CONTINFORULESTATUS_PK;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS ADD (
  CONSTRAINT CIS_CONTINFORULESTATUS_PK
  PRIMARY KEY
  (CIS_CONT_INFO_RULE_STATUS_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H
  DROP CONSTRAINT CIS_CONTINFORULESTATUS_H_PK;

ALTER TABLE CIS.CIS_CONT_INFO_RULE_STATUS_H ADD (
  CONSTRAINT CIS_CONTINFORULESTATUS_H_PK
  PRIMARY KEY
  (CIS_CONT_INFO_RULE_STATUS_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE
  DROP CONSTRAINT CIS_CONTINFOPURPOSE_PK;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE ADD (
  CONSTRAINT CIS_CONTINFOPURPOSE_PK
  PRIMARY KEY
  (CIS_CONT_INFO_PURPOSE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H
  DROP CONSTRAINT CIS_CONTINFOPURPOSE_H_PK;

ALTER TABLE CIS.CIS_CONT_INFO_PURPOSE_H ADD (
  CONSTRAINT CIS_CONTINFOPURPOSE_H_PK
  PRIMARY KEY
  (CIS_CONT_INFO_PURPOSE_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PROF
  DROP CONSTRAINT CIS_CONTINFOPROF_PK;

ALTER TABLE CIS.CIS_CONT_INFO_PROF ADD (
  CONSTRAINT CIS_CONTINFOPROF_PK
  PRIMARY KEY
  (CIS_CONT_INFO_PROF_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PROF_H
  DROP CONSTRAINT CIS_CONTINFOPROF_H_PK;

ALTER TABLE CIS.CIS_CONT_INFO_PROF_H ADD (
  CONSTRAINT CIS_CONTINFOPROF_H_PK
  PRIMARY KEY
  (CIS_CONT_INFO_PROF_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO
  DROP CONSTRAINT CIS_CONTINFOPROF_CONTINFO_FK;


ALTER TABLE CIS.CIS_CONT_INFO ADD (
  CONSTRAINT CIS_CONTINFOPROF_CONTINFO_FK 
  FOREIGN KEY (CIS_CONT_INFO_PROF_ID) 
  REFERENCES CIS.CIS_CONT_INFO_PROF (CIS_CONT_INFO_PROF_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PREF
  DROP CONSTRAINT CIS_CONTINFOPREF_UK;

ALTER TABLE CIS.CIS_CONT_INFO_PREF ADD (
  CONSTRAINT CIS_CONTINFOPREF_UK
  UNIQUE (CIS_CONT_INFO_ID, CIS_PREF_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PREF
  DROP CONSTRAINT CIS_CONTINFOPREF_PK;

ALTER TABLE CIS.CIS_CONT_INFO_PREF ADD (
  CONSTRAINT CIS_CONTINFOPREF_PK
  PRIMARY KEY
  (CIS_CONT_INFO_PREF_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PREF_H
  DROP CONSTRAINT CIS_CONTINFOPREF_H_PK;

ALTER TABLE CIS.CIS_CONT_INFO_PREF_H ADD (
  CONSTRAINT CIS_CONTINFOPREF_H_PK
  PRIMARY KEY
  (CIS_CONT_INFO_PREF_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PHONE
  DROP CONSTRAINT CIS_CONTINFOPHONE_PK;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE ADD (
  CONSTRAINT CIS_CONTINFOPHONE_PK
  PRIMARY KEY
  (CIS_CONT_INFO_PHONE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H
  DROP CONSTRAINT CIS_CONTINFOPHONE_H_PK;

ALTER TABLE CIS.CIS_CONT_INFO_PHONE_H ADD (
  CONSTRAINT CIS_CONTINFOPHONE_H_PK
  PRIMARY KEY
  (CIS_CONT_INFO_PHONE_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL
  DROP CONSTRAINT CIS_CONTINFOEMAIL_PK;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL ADD (
  CONSTRAINT CIS_CONTINFOEMAIL_PK
  PRIMARY KEY
  (CIS_CONT_INFO_EMAIL_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H
  DROP CONSTRAINT CIS_CONTINFOEMAIL_H_PK;

ALTER TABLE CIS.CIS_CONT_INFO_EMAIL_H ADD (
  CONSTRAINT CIS_CONTINFOEMAIL_H_PK
  PRIMARY KEY
  (CIS_CONT_INFO_EMAIL_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY
  DROP CONSTRAINT CIS_CONTINFODATAQUAL_PK;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY ADD (
  CONSTRAINT CIS_CONTINFODATAQUAL_PK
  PRIMARY KEY
  (CIS_CONT_INFO_DATA_QUAL_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H
  DROP CONSTRAINT CIS_CONTINFODATAQUAL_H_PK;

ALTER TABLE CIS.CIS_CONT_INFO_DATA_QUALITY_H ADD (
  CONSTRAINT CIS_CONTINFODATAQUAL_H_PK
  PRIMARY KEY
  (CIS_CONT_INFO_DATA_QUAL_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS
  DROP CONSTRAINT CIS_CONTINFOADDR_PK;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS ADD (
  CONSTRAINT CIS_CONTINFOADDR_PK
  PRIMARY KEY
  (CIS_CONT_INFO_ADDR_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H
  DROP CONSTRAINT CIS_CONTINFOADDR_H_PK;

ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS_H ADD (
  CONSTRAINT CIS_CONTINFOADDR_H_PK
  PRIMARY KEY
  (CIS_CONT_INFO_ADDR_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_STATUS
  DROP CONSTRAINT CIS_CONINFDATQUAL_INFSTAT_FK;


ALTER TABLE CIS.CIS_CONT_INFO_STATUS ADD (
  CONSTRAINT CIS_CONINFDATQUAL_INFSTAT_FK 
  FOREIGN KEY (CIS_CONT_INFO_DATA_QUAL_ID) 
  REFERENCES CIS.CIS_CONT_INFO_DATA_QUALITY (CIS_CONT_INFO_DATA_QUAL_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS
  DROP CONSTRAINT CIS_CI_TYPE_TYPEPRPS_FK;


ALTER TABLE CIS.CIS_CONT_INFO_TYPE_PRPS ADD (
  CONSTRAINT CIS_CI_TYPE_TYPEPRPS_FK 
  FOREIGN KEY (CIS_CONT_INFO_TYPE_ID) 
  REFERENCES CIS.CIS_CONT_INFO_TYPE (CIS_CONT_INFO_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_VLDTN_RSLT
  DROP CONSTRAINT CIS_CI_DQ_VLDTN_RSLT_FK;


ALTER TABLE CIS.CIS_VLDTN_RSLT ADD (
  CONSTRAINT CIS_CI_DQ_VLDTN_RSLT_FK 
  FOREIGN KEY (CIS_CONT_INFO_DATA_QUAL_ID) 
  REFERENCES CIS.CIS_CONT_INFO_DATA_QUALITY (CIS_CONT_INFO_DATA_QUAL_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_AUDIT_LOG
  DROP CONSTRAINT CIS_AUDIT_PK;

ALTER TABLE CIS.CIS_AUDIT_LOG ADD (
  CONSTRAINT CIS_AUDIT_PK
  PRIMARY KEY
  (CIS_AUDIT_LOG_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_ADDRESS_TYPE
  DROP CONSTRAINT CIS_ADDRTYPE_PK;

ALTER TABLE CIS.CIS_ADDRESS_TYPE ADD (
  CONSTRAINT CIS_ADDRTYPE_PK
  PRIMARY KEY
  (CIS_ADDRESS_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_ADDRESS_TYPE
  DROP CONSTRAINT CIS_ADDRTYPE_NM_UK;

ALTER TABLE CIS.CIS_ADDRESS_TYPE ADD (
  CONSTRAINT CIS_ADDRTYPE_NM_UK
  UNIQUE (ADDR_TYPE_NM)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_ADDRESS_TYPE_H
  DROP CONSTRAINT CIS_ADDRTYPE_H_PK;

ALTER TABLE CIS.CIS_ADDRESS_TYPE_H ADD (
  CONSTRAINT CIS_ADDRTYPE_H_PK
  PRIMARY KEY
  (CIS_ADDRESS_TYPE_H_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS
  DROP CONSTRAINT CIS_ADDRTYPE_CONTINFOADDR_FK;


ALTER TABLE CIS.CIS_CONT_INFO_ADDRESS ADD (
  CONSTRAINT CIS_ADDRTYPE_CONTINFOADDR_FK 
  FOREIGN KEY (CIS_ADDRESS_TYPE_ID) 
  REFERENCES CIS.CIS_ADDRESS_TYPE (CIS_ADDRESS_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_INFLGHT_DATA_CLOB
  DROP CONSTRAINT CISINFGHTDATACLOB_PK;

ALTER TABLE CIS.CIS_INFLGHT_DATA_CLOB ADD (
  CONSTRAINT CISINFGHTDATACLOB_PK
  PRIMARY KEY
  (CIS_INFLGHT_DATA_ID)
  ENABLE VALIDATE);
ALTER TABLE CIS.CIS_INFLGHT_DATA_CLOB
  DROP CONSTRAINT CISINFGHTDATACLOBID_FK;


ALTER TABLE CIS.CIS_INFLGHT_DATA_CLOB ADD (
  CONSTRAINT CISINFGHTDATACLOBID_FK 
  FOREIGN KEY (CIS_INFLGHT_DATA_ID) 
  REFERENCES CIS.CIS_INFLGHT_DATA (CIS_INFLGHT_DATA_ID)
  ENABLE VALIDATE);
