F.4 AML Brokerage - Summary Datamaps
Summary Datamaps are used to calculate aggregations across various entities using the Trade, Transaction, Positions and Balances Tables.
These datamaps populate various profile tables for different entities like Account
Profile, Household Profile, Correspondent Bank Profile.The aggregation is done daily,
weekly or monthly depending on the business areas.
Table F-4 AML Brokerage - Summary Datamaps
| Datamap Number | Datamap Name | Predecessors |
|---|---|---|
| 50045 | ExternalEntityDailyProfile | 10390 10980 10990 11010 |
| 50046 | ExternalEntityProfile | 50045 |
| 50050 | CustomerDailyProfile_BOT | NA |
| 50060 | CustomerDailyProfile_FOTPS | NA |
| 50070 | InstitutionalAccountDailyProfile_DEAL | NA |
| 50080 | CustomerDailyProfile_DEAL | NA |
| 50090 | InstitutionalAccountDailyProfile_INST | NA |
| 50100 | CustomerDailyProfile_INST | NA |
| 50110 | InstitutionalAccountDailyProfile_CorpAction | NA |
| 50120 | CustomerDailyProfile_CorpAction | NA |
| 50130 | InstitutionalAccountDailyProfile_Trade | NA |
| 50140 | CustomerDailyProfile_Trade | NA |
| 11160 | AccountDailyProfile-Trade | NA |
| 11170 | AccountDailyProfile-Transaction | NA |
| 11180 | AccountProfile_Trade | 10940 11160 11170 |
| 11190 | AccountProfile_Transaction | 10940 11160 11170 |
| 11200 | AccountProfile_Stage | NA |
| 11210 | AccountProfile_Position | 11180 11190 11200 |
| 11220 | AccountProfile_Balance | 11180 11190 11200 11210 |
| 50150 | InstitutionalAccountProfile | 50070 50090 50110 50130 |
| 50160 | CustomerProfile | 50050 50060 50080 50100 50120 50140 |
| 11230 | ChangeLog_AcctProfileInactivity | 11180 11190 11200 11210 11220 |
| 11240 | AccountPeerGroupMonthlyTransactionProfile | 11180 11190 11200 11210 11220 |
| 11300 | AccountChangeLogSummary | The datamap should be executed once the change log processing is done. |
| 11310 | AccountToCustomerChangeLogSummary | The datamap should be executed once the change log processing is done. |
| 11320 | CustomerChangeLogSummary | The datamap should be executed once the change log processing is done. |
Note:
The AccountChangeLogSummary, AccountToCustomerChangeLogSummary, and CustomerChangeLogSummary datamaps must be run withexecute.sh from
8.0.2 onwards.