3.2 Database Files

The list of updated/added files that impact the database is as follows:

  • Config Schema
    • USSAR_FFW_812.sql
    • RR_Sec_Lane_Params.sql
    • RR_EG_ViewRepP.sql
    • RR_EG_ViewRepG.sql
    • PLC_FN_JIT_CRR_SYNCH_ADHOC_BATCH.sql
    • PLC_CRRPURGE.sql
    • MESSAGES_EN_US_OJET_GOAML.sql
    • MESSAGES_EN_US_OJET_CASTR.sql
    • MESSAGES_EN_US.SQL
    • INSERT_INFODOM_PATCHES.sql
    • EXCEL_MAPPING_MASTER_LP.sql
    • EXCEL_MAPPING_MASTER_8128.sql
    • DB_Install.xml CRR_USSAR_PMF.sql
    • CRR_EG_TAB6_INVLPRTY.sql
    • CRR_EG_TAB6_ENTITY_60_62.sql
    • CRR_EG_TAB5_8128.sql
    • CRR_EG_TAB4_ENTITY44.sql
    • CRR_EG_TAB4_ENTITY43.sql
    • CRR_EG_TAB4_ENTITY42_81280.sql
    • CRR_EG_TAB4_ENTITY40_81280.sql
    • CRR_EG_TAB4_ENTITY40.sql
    • CRR_EG_TAB4_ENTITY30_81280.sql
    • CRR_EG_TAB4_ENTITY30.sql
    • CRR_EG_TAB4_ENTITY24_81280.sql
    • CRR_EG_TAB4_ENTITY23_81280.sql
    • CRR_EG_TAB4_ENTITY16_81280.sql
    • CRR_EG_TAB1_ENTITY7.sql
    • CRR_EG_PMFActApr.sql
    • CRR_EG_ListG.sql
    • CRR_EG_AutoDirAddG.sql
    • CRR_EG_AutoDirAdd.sql
    • CRR_EG_ActBtn.sql
    • AAI_PROV_JIT_RRS.sql
    • 37037279_MESSAGES_EN_US.sql
    • 36620743_MESSAGES_EN_US.sql
    • 35961988_MESSAGES_EN_US.SQL
    • 34802661_MESSAGES_EN_US.sql
    • 32787387_MESSAGES_EN_US_8111.sql
    • 28398616_MESSAGES_EN_US.SQL 81210_PMF_WORKFLOW.sql
    • 8128_OJET_FFW.sql
    • 8127_MESSAGES_EN_US_GOAML.sql
    • 8126_OJET_OldScreen_Removal.sql
    • 8126_OJET_FFW.sql
    • 8122_OJET_FFW.sql
    • Menu_611.sql
    • FrmCRRVadFormDtls.sql
    • FrmCRRVadDtls.sql
    • FrmCRRSrcTrg.sql
    • FrmCRRSrcData.sql
    • FrmCRRSRCAttr.sql
    • FrmCRROutputEntities.sql
    • FrmCRROutputData.sql
    • FrmCRROutputAttr.sql
    • FrmCRREntJoin.sql
    • FrmCRREntDtls.sql
    • FrmCRRConfigHDRG.sql
    • FrmCRRConfig_OPR.sql
    • FrmCRRConfig.sql
    • FrmCRRCompTypeData.sql
    • FrmCRRAckw.sql
    • FrmAckG.sql
    • FrmAckDtlsG.sql
    • FrmAck_OPR.sql
  • Application Scripts
    • CRR_PreInstallation_Script_81210.sql
    • CRR_PostInstallation_Script_81210.sql
    • USSAR_LP_Script.sql
    • SRC_TARGET_CONFIG_GOAML_NGECM.sql
    • SETUP_CRR_ACK_PATTERN.sql
    • OFSAACMPRR-12883.sql
    • OFSAACMPRR-11669.sql
    • GOAML_LP_Script.sql
    • FCT_CRR_VAD_FORMS_HIER_GOAMLSTR_81280.sql
    • FCT_CRR_VAD_FORMS_HIER_GOAMLSTR.sql
    • FCT_CRR_VAD_DTLS_GOAMLSTR_8128.sql
    • FCT_CRR_VAD_DTLS_GOAMLSTR.sql
    • FCT_CRR_CODE_SET_TRNLN_TL.sql
    • FCT_CRR_CODE_SET_TRNLN_B.sql
    • FCC_CRR_UIB_STDCONFIG.sql
    • FCC_CRR_UIB_FODEFN.sql
    • FCC_CRR_UIB_ENTITY.sql
    • FCC_CRR_UIB_ATTRIBUTE.sql
    • DIM_SUSPECT_ID_TYPE.sql
    • DIM_SUS_ACTIVITY.sql
    • DIM_RR_ACTION.sql
    • DIM_NAICS_CODE_2887.sql
    • DIM_NAICS_CODE.sql
    • DIM_FILING_TYPE.sql
    • DIM_CRRF_DOCTYPE.sql
    • DIM_CRR_SRC_APP.sql
    • DIM_CRR_REF_DETAIL.sql
    • DIM_CRR_DIMENSION_VALS.sql
    • DIM_CRR_DIMENSION_SETS.sql
    • CRRF_TEMP_DATACOPY.sql
    • CRRF_TEMP_DATA.sql
    • CASTR_LP_Script.sql
    • APPLN_PARAMS_8124.sql
    • APPLN_PARAMETERS_8122.sql
    • APPLN_PARAMETERS.SQL
    • 36449728_SRC_TARGET_CONFIG_GOAML_NGECM.sql
    • 36449728_DIM_CRRF_SUBENTITY.sql
    • 28398603_PSDM.sql
    • 81283_MAP_USERROLE_ACTIONCD.sql
    • 81280_MAP_USERROLE_ACTIONCD.sql
    • 81271_APPLN_PARAMETERS.sql
    • 81270_DIM_RR_ACTION.sql
    • 81260_MAP_USERROLE_ACTIONCD.sql
    • 81260_FCT_CRR_OUT_ATTRIBUTE.sql
    • 81254_DIM_RR_ACTION.sql
    • 81210_MAP_USERROLE_ACTIONCD.sql
    • 81210_MAP_TIN_TYPE_REPTYPE.sql
    • 81210_MAP_SUS_ROLE_REPTYPE.sql
    • 81210_MAP_GENDER_REPTYPE.sql
    • 81210_MAP_COMM_TYPE_REPTYPE.sql
    • 81210_DIM_RR_ACTION.sql
    • 8129_APPLN_PARAMETERS.sql
    • 8128_GOAML_INITIALIZE.sql
    • 8128_GOAML_FCT_CRR_TRG_SRC_TRG_MAP.sql
    • 8128_GOAML_FCT_CRR_OUT_DATA_FORMAT.sql
    • 8128_APPLN_PARAMETERS.sql
    • 8121_APPLN_PARAMETERS.sql
    • 4244_APPLN_PARAMETERS.sql
  • Functions
    • fn_purge_crr.sql
    • FN_USSAR_REL_FININST.sql
    • fn_seqid_info.sql
    • FN_JIT_CRR_SYNCH_ADHOC_BATCH.sql
    • FN_GOAML_GET_PARTY_ROLE.sql
    • fn_in_string_list.sql
  • Procedures
    • CRR_PURGE_TABLE_SCRIPT.sql
    • p_crr_compare_tables.sql
    • P_JIT_CRR_SYNCH_ADHOC_BATCH.sql
    • P_FCC_OFS_CRR_JIT_SEC_MAP.sql
    • PR_COPYCONFIGURATION.sql
  • Packages
    • pkg_sardi_addnewrep_body.sql
    • pkg_sardi_addnewrep.sql
    • PKG_RRSTD_SAVE_BODY.sql
    • PKG_RRSTD_SAVE.sql
    • pkg_rrsardi_save_body.sql
    • pkg_rrsardi_save.sql
    • pkg_rrsardi_del_body.sql
    • pkg_rrsardi_del.sql
    • PKG_RRRUS_SAVE_BODY.sql
    • PKG_RRRUS_SAVE.sql
    • PKG_RRIN_SAVE_BODY.sql
    • PKG_RRIN_SAVE.sql
    • PKG_RRCA_TRANSINFO_BODY.sql
    • PKG_RRCA_TRANSINFO.sql
    • PKG_RRCA_STARTACT_BODY.sql
    • PKG_RRCA_STARTACT.sql
    • PKG_RRCA_SAVE_BODY.sql
    • PKG_RRCA_SAVE.sql
    • pkg_rrca_revised_report_body.sql
    • pkg_rrca_revised_report.sql
    • PKG_RRCA_GENINFO_BODY.sql
    • PKG_RRCA_GENINFO.sql
    • PKG_RRCA_DETOFSUSP_BODY.sql
    • PKG_RRCA_DETOFSUSP.sql
    • PKG_RRCA_DEL_BODY.sql
    • PKG_RRCA_DEL.sql
    • PKG_RRCA_COMPLETEACT_BODY.sql
    • PKG_RRCA_COMPLETEACT.sql
    • pkg_rr_goaml_report_entity_body.sql
    • pkg_rr_goaml_report_entity.sql
    • PKG_RR_GOAML_REPORT_ACTION_BODY.sql
    • PKG_RR_GOAML_REPORT_ACTION.sql
    • PKG_RR_GOAML_INVLVD_PERSON_DTLS_BODY.sql
    • PKG_RR_GOAML_INVLVD_PERSON_DTLS.sql
    • PKG_RR_GOAML_INVLVD_ACCNT_DTLS_BODY.sql
    • PKG_RR_GOAML_INVLVD_ACCNT_DTLS.sql
    • PKG_GOAML_TXN_SAVE_BODY.sql
    • PKG_GOAML_TXN_SAVE.sql
    • PKG_CRR_PURGE_BODY.sql
    • PKG_CRR_PURGE.sql
    • PKG_CA_ADDNEWREP_BODY.sql
    • PKG_CA_ADDNEWREP.sql
    • PKG_AUTO_SPLIT_ORG_BODY.sql
    • PKG_AUTO_SPLIT_ORG.sql
  • Table Scripts
    • MAP_FININST_INFO_PE.sql
    • MAP_BRANCH_INFO_PE.sql
    • MAP_ADDITIONAL_ACTVTY_INFO_PE.sql
    • KDD_GTT_CRR_PURGE.sql
    • GTT_USSAR_INFO.sql
    • GTT_CRR_TRXN_INFO.sql
    • GTT_CASTR_INFO.sql
    • FCT_URL_PE.sql
    • FCT_TRANSACTION_PE.sql
    • FCT_SUSPECT_INFO_PE.sql
    • FCT_SUS_ACTIVITY_PE.sql
    • FCT_RR_XSD_VLDTN_DTLS_PE.sql
    • FCT_REPORT_ACTIONS_PE.sql
    • FCT_RELN_FININST_PE.sql
    • FCT_REGULATORY_REPORT_PE.sql
    • FCT_PHONE_PE.sql FCT_PERSON_PE.sql
    • FCT_IDENTIFICATION_PE.sql
    • FCT_EMAIL_PE.sql
    • FCT_EFILE_PE.sql
    • FCT_COMMENTS_PE.sql
    • FCT_ALTERNATE_NAME_PE.sql
    • FCT_ADDRESS_PE.sql
    • FCT_ACCOUNT_PE.sql
    • CRR_PURGE_TABLE_SCRIPT.sql
  • Views
    • VW_GOAML_ACCT_NMBR.sql
    • VW_GOAML_SUBJECT_NMS.sql
    • VW_GOAML_SUBJECT_LIST.sql
    • vw_fct_efile_ack.sql
    • 36449728_vw_dim_identification_type.sql

Note:

  • Take a backup of Atomic and Config Schema as a precautionary measure.
  • Take a backup of above mentioned files. If any customizations done to these files, they need to be re- applied.