How do you ensure data integrity in your analyses?
Demonstrate your approach by writing a SQL query that identifies claims requiring review because of missing member records, missing or negative billed amounts, or payments exceeding the billed amount.
claim_id, member_id, billed_amount, payment_total, and issue_reason.claim_id ascending.| Column | Type | Description |
|---|---|---|
| member_idPK | INT | Unique member identifier |
| member_name | VARCHAR(100) | Member display name |
| member_status | VARCHAR(20) | Current enrollment status |
| Column | Type | Description |
|---|---|---|
| claim_idPK | INT | Unique claim identifier |
| member_id | INT | Member associated with the claim |
| service_date | DATE | Date services were provided |
| billed_amount | NUMERIC(12,2) | Amount billed for the claim |
| Column | Type | Description |
|---|---|---|
| payment_idPK | INT | Unique payment identifier |
| claim_id | INT | Claim associated with the payment |
| payment_reference | VARCHAR(30) | External payment reference |
| payment_amount | NUMERIC(12,2) | Amount paid toward the claim |