Your question is Flag Reporting Discrepancies in iLevel. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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 |