Spreadsheet: 731146d1620209647-need-help-merging-info-from-two-tables-report-template-test3
Sheet: 12

 | PROGRAM Info (changes infrequently) |  |  |  |  |  |  | OVERALL STATUS |  |  |  |  |  |  | MILESTONES |  |  |  |  | RECENT ACCOMPLISHMENTS |  |  | KEY ISSUES / RISKS |  |  |  |  |  | NEXT STEPS
 | Project ID | Project Name | Department | Executive Sponsor | [NAME] | Project Manager | Parent Program | Target Completion Date | Status | Percent Complete | Overall Status | Scope | Schedule | Resources | Weekly Update Section | Name | Due Date | Status | Health | Weekly Update Section | Name | Due Date | Weekly Update Section | Name | Due Date | Priority (Impact & Probability) | Status | Mitigations | Weekly Update Section | Name | Due Date | Status
 | Numeric | Text | Text | Text | Text | Text | Text | Date | Status Dropdown | Numeric - Percentage | Health (current)  [NAME] | Scope RAG Status | Schedule  [NAME] | Resources [NAME] | <Milestones> | Text | Date | Status | [NAME] R- OffTrack A - At Risk G - On Track | <Recent Accomplishments> | Text | Date | <Key Issues / Risks> | Text | Date | Low /  Medium / High | Status Dropdown | Text | <Next Steps> | Text | Date | Status Dropdown
 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Initial high-level analysis on DRD has been completed by business and technology team | 2020-10-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Update AML Policy as per the feedback provided by Risk Committee | 2020-05-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Data Requirement discussion with Actimize | 2020-09-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Final evaluation before signing contract with Actimize | 2020-09-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Contract received from Actimize reviewed internally. Redline draft will be sent back Actimize. | 2020-09-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Data requirements document  session completed with Actimize. | 2020-09-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | New AML policy has been approved by risk committee. | 2020-08-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | New AML policy has been shared with editorial for review. | 2020-08-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Final price received from Actimize after negotiations. | 2020-08-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Steering committee was updated on AML project progress | 2020-08-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Development of Hub n Spoke 1 and 2 exception reports | 2020-07-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Development of Rapid Movement of Funds report | 2020-07-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Development of Large Deposit and Withdrawal report | 2020-07-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | [NAME] from AML vendors | 2020-02-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Submit vendor NDA request on COMM Ave | 2020-02-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Send out RFP to vendors once drafted and approved | 2020-03-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | RFP response has been received from all vendors. | 2020-04-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Review initial AML policy with [NAME] | 2020-01-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Finalize the [NAME] of Request for Proposal | 2020-03-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Review updated AML Policy with Risk Governance | 2020-04-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Review updated AML Policy with Risk Committee | 2020-04-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Get NDA in place with vendors selected after RFI before moving forward for RFP | 2020-03-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Planning and preparation for [NAME] | 2020-05-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Finalize steering committee members for AML project | 2020-04-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Confirm business requirements on Hub n Spoke 1 and 2 exception report | 2020-06-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Confirm business requirements on Rapid movement report | 2020-06-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Develop AML RAPID Decision matrix | 2020-05-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Demo with Risk Canvas was done on May 20th | 2020-05-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Demo with Actimize was done on May 14th | 2020-05-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Add high level user stories and acceptance criteria in AML RFP draft. | 2020-03-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Complete the initial draft of RFP document and review it with stakeholders | 2020-02-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Develop a method to evaluate RFP responses from vendors | 2020-04-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Estimation to develop exception reports internal CFN to support ongoing AML program | 2020-01-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Select and recommend AML vendor to steering committee | 2020-06-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Evaluate Demonstration and provide scorecards | 2020-06-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Evaluate vendor RFP responses | 2020-05-01 00:00:00