G Datamaps Matrix
This appendix provides a single window view of datamaps required for each solution set.
'X' denotes mandatory datamaps for each solution set.
'NA' denotes not applicable datamaps for the same solution set.
Table G-1 BD Datamaps
| Datamap Number | Datamap Name | AML | Fraud | Insurance | AML Brokerage |
|---|---|---|---|---|---|
| 10010 | EmployeeControlledAccount | X | X | X | X |
| 60010 | PortfolioManagerPosition | NA | NA | NA | NA |
| 60020 | AccountGroupProductAllocation | NA | NA | NA | NA |
| 60030 | AccountProductAllocation | NA | NA | NA | NA |
| 60040 | UncoveredOptionExposureDaily | NA | NA | NA | NA |
| 60050 | InvestmentAdvisorProfile | NA | NA | NA | NA |
| 60060 | RegisteredRepresentativeProfile | NA | NA | NA | NA |
| 60070 | RegOToBorrower | NA | NA | NA | NA |
| 60080 | InterestedPartyToEmployee | NA | NA | NA | NA |
| 50010 | Customer_TotAcctUpd | NA | NA | NA | X |
| 10015 | FrontOfficeTransactionParty_SecondaryNames | X | X | NA | X |
| 10020 | FinancialInstitution_ThomsonDataInstitutionInsert | X | X | X | X |
| 10030 | AccountToClientBank_ThomsonDataInstitutionInsert | X | X | X | X |
| 10040 | FinancialInstitution_AIIMSPopulation | X | X | X | X |
| 10050 | AccountToClientBank_AIIMSInstitutionInsert | X | X | X | X |
| 10060 | AccountToClientBank_InstitutionInsert | X | X | X | X |
| 10070 | AccountToClientBank_InstitutionUpd | X | X | X | X |
| 10080 | FinancialInstitution_FOTPSPopulation | X | X | X | X |
| 10090 | AccountToClientBank_FOTPSInstitutionInsert | X | X | X | X |
| 10095 | AccountCustomerRole | X | X | X | X |
| 10096 | AccountToCustomer | X | X | X | X |
| Existing 10100 | AccountManagementStage | X | X | X | X |
| 10110 | LoanProfile_LoanProfileStage | X | NA | NA | X |
| 10112 | ServiceTeam_SprvsncdUpd | NA | NA | NA | NA |
| 10113 | InvestmentAdvisor_MangdAcctUpd | NA | NA | NA | NA |
| 10114 | Security_CIRRatingUpd | X | X | X | X |
| 10116 | BackOfficeTransaction_CollateralUpd | X | X | X | X |
| 10120 | BackOfficeTransaction_OriginalTransactionReversalUpd | X | X | NA | X |
| 10130 | BackOfficeTransaction_CancelledTransactionReversalCre ditUpd | X | X | NA | X |
| 10140 | BackOfficeTransaction_CancelledTransactionReversalDeb itUpd | X | X | NA | X |
| 10150 | FrontOfficeTransactionParty_InstnSeqID | X | X | X | X |
| 10160 | FrontOfficeTransactionParty_HoldingInstnSeqID | X | X | X | X |
| 10170 | FinancialInstitution_AnticipatoryProfile | NA | X | X | X |
| 10180 | AccountToClientBank_AnticipatoryProfile | NA | X | X | X |
| 10190 | AnticipatoryProfile_AccountToClientBank | NA | X | X | X |
| 50020 | DailyAggregateStage | NA | NA | NA | X |
| 50030 | OffsettingAccountPairStage | NA | NA | NA | X |
| 50040 | TradeDailyTotalCountStage | NA | NA | NA | X |
| 10200 | CustomerAccountStage_FrontOfficeTransactionParty | X | X | NA | X |
| 10210 | FrontOfficeTransaction_UnrelatedPartyUpd | X | X | NA | X |
| 10220 | FinancialInstitution_SettlementInstruction | NA | X | X | X |
| 10230 | AccountToClientBank_SettlementInstruction | NA | X | X | X |
| 10240 | SettlementInstruction_AccountToClientBank | NA | X | X | X |
| 40010 | FinancialInstitution_InsuranceTransaction | NA | NA | X | NA |
| 40020 | AccountToClientBank_InsuranceTransaction | NA | NA | X | NA |
| 40030 | InsuranceTransaction_AccountToClientBank | NA | NA | X | NA |
| 10245 | WLMProcessingLock | X | X | X | X |
| 10250 | WatchListEntry_WatchListEntryCurrDayInsert | X | X | X | X |
| 10260 | WatchListAudit_StatusUpd | X | X | X | X |
| 10270 | WatchList_WatchListSourceAuditInsert | X | X | X | X |
| 10280 | WatchList_WatchListSourceAuditUpd | X | X | X | X |
| 10290 | WatchList_WatchListSourceUpd | X | X | X | X |
| 10300 | WatchListEntry_WatchListAuditUpd | X | X | X | X |
| 10310 | WatchListEntryAudit_WatchListEntryUpdate | X | X | X | X |
| 10320 | Customer_KYCRiskUpd | X | X | X | X |
| 60090 | CorrespondentBankToPeerGroup | NA | NA | NA | NA |
| 10330 | DerivedAddress_SettlementInstructionInsert | NA | X | NA | X |
| 10340 | DerivedAddress_SettlementInstructionUpd | NA | X | NA | X |
| 10350 | SettlementInstruction_PhysicalDlvryAddrUpd | NA | X | NA | X |
| 10360 | DerivedAddress_FrontOfficeTransactioPartyStageInsert | X | X | X | X |
| 10370 | DerivedAddress_FrontOfficeTransactioPartyStageUpd | X | X | X | X |
| 10380 | FrontOfficeTransactionParty_DerivedAddress | X | X | X | X |
| 40040 | DerivedAddress_InsuranceTransactionInsert | NA | NA | X | NA |
| 40050 | DerivedAddress_InsuranceTransactionUpd | NA | NA | X | NA |
| 40060 | InsuranceTransaction_InstitutionAddrUpd | NA | NA | X | NA |
| 40070 | DerivedEntity_InsuranceTransactionInsert | NA | NA | X | NA |
| 40080 | DerivedEntity_InsuranceTransactionUpd | NA | NA | X | NA |
| 10390 | DerivedEntity_FrontOfficeTransactionPartyInsert | X | X | X | X |
| 10400 | DerivedEntity_FrontOfficeTransactionPartyUpd | X | X | X | X |
| 10410 | DerivedEntity_SettlementInstructionInsert | X | X | X | X |
| 10420 | DerivedEntity_SettlementInstructionUpd | X | X | X | X |
| 10430 | CorrespondentBank_FrontOfficeTransactionPartyStageIn sert | X | X | X | X |
| 10440 | CorrespondentBank_FrontOfficeTransactionPartyStageU pd | X | X | X | X |
| 10450 | WatchListStagingTable_WatchList | X | X | X | X |
| 10460 | WatchListStagingTable_WatchListInstnIDUpd | X | X | X | X |
| 10470 | PreviousWatchList_WatchList | X | X | X | X |
| 10480 | DerivedAddress_WatchListNewCountries | X | X | X | X |
| 10485 | WLMProcessingUnlock | X | X | X | X |
| 10490 | LinkStaging_FrontOfficeTransactionParty | X | X | X | X |
| 40090 | LinkStaging_InsTrxnDerivedEntDerivedAdd | NA | NA | X | NA |
| 10500 | LinkStaging_InstructionDerivedEntDerivedAdd | X | X | X | X |
| 10510 | NameMatchStaging | X | X | X | X |
| 10520 | WatchListStagingTable_NameMatchStageInsert | X | X | X | X |
| 10530 | DerivedEntityLink_LinkStage | X | X | X | X |
| 10540 | DerivedEntitytoDerivedAddress_LinkStage | X | X | X | X |
| 10550 | DerivedEntitytoInternalAccount_LinkStage | X | X | X | X |
| 10560 | DerivedAddresstoInternalAccount_LinkStage | X | X | X | X |
| 10570 | WatchListStagingTable2_WatchListStage2AcctExistence | X | X | X | X |
| 10580 | WatchListStagingTable2_WatchListStage2CBExistence | X | X | X | X |
| 10590 | WatchListStagingTable2_WatchListStage2CustExistence | X | X | X | X |
| 10600 | WatchListStagingTable2_WatchListStage2DAExistence | X | X | X | X |
| 10610 | WatchListStagingTable2_WatchListStage2EEExistence | X | X | X | X |
| 10620 | WatchListStagingTable2_WatchListStage | X | X | X | X |
| 10630 | WatchListStagingTable2_AcctListMembershipUpd | X | X | X | X |
| 10640 | WatchListStagingTable2_CBListMembershipUpd | X | X | X | X |
| 10650 | WatchListStagingTable2_CustListMembershipUpd | X | X | X | X |
| 10660 | WatchListStagingTable2_EEListMembershipUpd | X | X | X | X |
| 10670 | WatchListStagingTable2_EEListMembershipStatusUpd | X | X | X | X |
| 10680 | WatchListStagingTable2_DAListMembershipUpd | X | X | X | X |
| 10690 | WatchListStagingTable2_DAListMembershipStatusUpd | X | X | X | X |
| 10700 | WatchListStagingTable2_WatchListStage2SeqIdUpd | X | X | X | X |
| 10710 | WatchListStagingTable2_WatchListStage2IntrlIdUpd | X | X | X | X |
| 10720 | Customer_WatchListStage2ListRisk | X | X | X | X |
| 10730 | CorrespondentBank_WatchListStage2EffectiveRisk | X | X | X | X |
| 10740 | Customer_WatchListStage2EffectiveRisk | X | X | X | X |
| 10750 | DerivedAddress_WatchListStage2EffectiveRisk | X | X | X | X |
| 10760 | DerivedEntity_WatchListStage2EffectiveRisk | X | X | X | X |
| 10770 | WatchListStagingTable2_WatchListStage2SeqId | X | X | X | X |
| 10780 | AccountListMembership_WatchListStage2Insert | X | X | X | X |
| 10790 | AccountListMembership_WatchListStage2Upd | X | X | X | X |
| 10800 | CorrespondentBankListMembership_WatchListStage2Ins ert | X | X | X | X |
| 10810 | CorrespondentBankListMembership_WatchListStage2Up d | X | X | X | X |
| 10820 | CustomerListMembership_WatchListStage2Insert | X | X | X | X |
| 10830 | CustomerListMembership_WatchListStage2Upd | X | X | X | X |
| 10840 | DerivedAddressListMembership_WatchListStage2Insert | X | X | X | X |
| 10850 | DerivedAddressListMembership_WatchListStage2Upd | X | X | X | X |
| 10860 | DerivedEntityListMembership_WatchListStage2Insert | X | X | X | X |
| 10870 | DerivedEntityListMembership_WatchListStage2Upd | X | X | X | X |
| 10875 | Account_EffectiveRiskFactorTxtUpd | X | X | X | X |
| 10880 | Account_OverallEffectiveRiskUpd | X | X | X | X |
| 10881 | Account_AccountCustRiskUpd | X | X | X | X |
| 10890 | Account_EffRiskUpdAfterWLRiskRemoval | X | X | X | X |
| 10900 | Account_WatchListStage2EffectiveRisk | X | X | X | X |
| 10910 | WatchListStagingTable2_WatchListStage2IntrlId | X | X | X | X |
| 10920 | BackOfficeTransaction_EffectiveAcctivityRiskUpd | X | X | NA | X |
| 10930 | SettlementInstruction_EntityAcctivityRiskUpd | NA | X | NA | X |
| 10940 | FrontOfficeTransactionPartyRiskStage_EntityActivityRiskI nsert | X | X | X | X |
| 10955 | AccountGroup_InvestmentObjectiveUpd | NA | NA | NA | NA |
| 40100 | InsuranceTransaction_EntityAcctivityRiskUpd | NA | NA | X | NA |
| 20010 | CorrespondentBank_JurisdictionUpd | X | NA | NA | NA |
| 20020 | CorrespondentBank_AcctJurisdictionReUpd | X | NA | NA | NA |
| 20030 | FinancialInstitution_InstNameUpd | X | NA | NA | NA |
| 10960 | AccountGroup_JurisdictionUpd | X | X | NA | X |
| 10970 | TransactionPartyCrossReference_BackOfficeTransaction | X | X | NA | X |
| 10980 | CashTransaction_FrontOfficeTransaction | X | X | NA | X |
| 10990 | MonetaryInstrumentTransaction_FrontOfficeTransaction | X | X | NA | X |
| 11000 | TransactionPartyCrossReference_FrontOfficeTransaction | X | X | NA | X |
| 11010 | WireTransaction_FrontOfficeTransaction | X | X | NA | X |
| 11020 | WireTransactionInstitutionLeg_FrontOfficeTransaction | X | X | NA | X |
| 11030 | CashTransaction_FrontOfficeTransactionRevAdj | X | X | NA | X |
| 11040 | MonetaryInstrumentTransaction_FrontOfficeTransaction RevAdj | X | X | NA | X |
| 11050 | WireTransaction_FrontOfficeTransactionRevAdj | X | X | NA | X |
| 11060 | TrustedPair_StatusEXPUpd | X | X | X | X |
| 11070 | TrustedPairMember_AcctExtEntEffecRiskUpd | X | X | X | X |
| 11080 | TrustedPair_StatusRRCInsert | X | X | X | X |
| 11090 | TrustedPair_StatusRRCUpd | X | X | X | X |
| 11100 | ApprovalActionsAudit_TrustedPair | X | X | X | X |
| 11110 | TrustedPairMember_StatusRRCInsert | X | X | X | X |
| 11120 | BackOfficeTransaction_TrustedFlagsUpd | X | X | X | X |
| 11130 | InsuranceTransaction_TrustedFlagsUpd | NA | NA | X | NA |
| 11140 | MonetaryInstrumentTransaction_TrustedFlagsUpd | X | X | X | X |
| 11150 | WireTransaction_TrustedFlagsUpd | X | X | X | X |
| 50050 | CustomerDailyProfile_BOT | NA | NA | NA | X |
| 50060 | CustomerDailyProfile_FOTPS | NA | NA | NA | X |
| 50070 | InstitutionalAccountDailyProfile_DEAL | NA | NA | NA | X |
| 50080 | CustomerDailyProfile_DEAL | NA | NA | NA | X |
| 50090 | InstitutionalAccountDailyProfile_INST | NA | NA | NA | X |
| 50100 | CustomerDailyProfile_INST | NA | NA | NA | X |
| 50110 | InstitutionalAccountDailyProfile_CorpAction | NA | NA | NA | X |
| 50120 | CustomerDailyProfile_CorpAction | NA | NA | NA | X |
| 50130 | InstitutionalAccountDailyProfile_Trade | NA | NA | NA | X |
| 50140 | CustomerDailyProfile_Trade | NA | NA | NA | X |
| 60100 | ManagedAccountDailyProfile_SameDayTrade | NA | NA | NA | NA |
| 60110 | ManagedAccountDailyProfile_Trade | NA | NA | NA | NA |
| 60120 | ManagedAccountDailyProfile_BOT | NA | NA | NA | NA |
| 11160 | AccountDailyProfile-Trade | X | X | NA | X |
| 11170 | AccountDailyProfile-Transaction | X | X | NA | X |
| 11180 | AccountProfile_Trade | X | X | NA | X |
| 11190 | AccountProfile_Transaction | X | X | NA | X |
| 11200 | AccountProfile_Stage | X | X | NA | X |
| 11210 | AccountProfile_Position | X | X | NA | X |
| 11220 | AccountProfile_Balance | X | X | NA | X |
| 60130 | HouseholdProfile | NA | NA | NA | NA |
| 50150 | InstitutionalAccountProfile | NA | NA | NA | X |
| 50160 | CustomerProfile | NA | NA | NA | X |
| 60140 | ManagedAccountProfile | NA | NA | NA | NA |
| 60145 | AccountPosition_PercentofPortfolioUpd | NA | NA | NA | NA |
| 20040 | CorrespondentBankProfile | X | NA | NA | NA |
| 20050 | AccountATMDailyProfile | X | NA | NA | NA |
| 11230 | ChangeLog_AcctProfileInactivity | X | X | NA | X |
| 11240 | AccountPeerGroupMonthlyTransactionProfile | X | X | NA | X |
| 20060 | CorrespondentBankPeerGroupTransactionProfile | X | NA | NA | NA |
| 20070 | AccountChannelWeeklyProfile | X | NA | NA | NA |
| 40110 | InsurancePolicyDailyProfile_InsTrxnInsPolicyBal | NA | NA | X | NA |
| 40120 | InsurancePolicyProfile_InsurancePolicyDailyProfile | NA | NA | X | NA |
| 50170 | CustomerBalance_ActiveOTCTradeCtUpd | NA | NA | NA | X |
| 60150 | AccountPositionDerived | NA | NA | NA | NA |
| 60160 | AccountBalance_AcctPosnPair | NA | NA | NA | NA |
| 60170 | AccountBalance_Acctposn | NA | NA | NA | NA |
| 60180 | HouseholdBalance | NA | NA | NA | NA |
| 60190 | AccountManagementStage | * | * | * | * |
| 11300 | AccountChangeLogSummary | X | X | X | X |
| 11310 | AccountToCustomerChangeLogSummary | X | X | X | X |
| 11320 | CustomerChangeLogSummary | X | X | X | X |
Note:
- The AccountChangeLogSummary, AccountToCustomerChangeLogSummary, and
CustomerChangeLogSummary datamaps must be run with
execute.shfrom 8.0.2 onwards. - BackOfficeTransaction must be loaded after the AccountManagementStage utility has been executed.