HarbourVest PartnersEasySQL · PostgreSQL00:00Welcome to the SQL screen for the Operations Manager role at HarbourVest Partners.
The question is on your right: Flag Reporting Discrepancies in iLevel. Read through the requirements and the one table first.
Would you like to talk through your approach, or are you ready to start coding?
HarbourVest Partners wants a simple validation check for operational reporting in iLevel. One common control is comparing reported totals against source transaction totals before a report is published.
Write a SQL query to identify each report_date where the reported cash activity does not match the source cash activity total.
ilevel_cash_activity table.report_date, calculate:
source_amountreported_amountreported_amount - source_amountreport_date ascending.| Column | Type | Description |
|---|---|---|
| activity_idPK | INT | Unique row identifier |
| report_date | DATE | Reporting date used in the operational report |
| fund_code | VARCHAR(20) | HarbourVest fund code |
| source_amount | DECIMAL(12,2) | Amount from the source operational record |
| reported_amount | DECIMAL(12,2) | Amount included in the published report |
| status | VARCHAR(20) | Load status for the row |