IDA identity-fraud case disposition reconstructionRisk & Fraud

Task prompt

Fraud ops handed me two person-application external ids to disposition against our warehouse before we reply to IDA — pull it from our books, not the mailbox. Primary case: apsn_11hcdakgtq32r7. Reconstruct the full lifecycle (application approval outcome, whether an account ever opened, close reason, any booked loss on that account). Also tell me how many distinct person applications share the same account-application, how many account-application rows exist for the opened account, and how many company-wide closed accounts mention the exact phrase "IDA Alert" in the closure reason — match that casing; do not fold case. Second case for the same reply packet: apsn_11gyajprjf20zd — confirm decline vs open and the KYC outcome field only (not the fraud-reason tags). Read KYC the same way for the primary case. Map each case to the standard IDA partner reply code as an integer 1–9 (not internal record ids, not prose labels): • 1 — approved, later closed for confirmed fraud, no booked loss • 2 — approved, later closed for confirmed fraud, with booked loss • 3 — approved, later closed for suspect fraud • 4 — approved, confirmed not fraud, account still open • 5 — declined for risk, never opened • 6 — declined for fraud, never opened • 8 — customer withdrew Partner codes follow the true disposition from approval/open/close narrative plus booked loss — do not key the code off a single stored flag in isolation when the closure story and loss picture say otherwise. Return one JSON object with these keys (names exact, no aliases): warehouse_external_id, person_application_id, secondary_person_application_id, account_application_id, account_id, user_id, account_application_status, account_status, account_ever_opened, kyc_outcome (verbatim from the warehouse KYC outcome field), co_person_applications_on_account_application, co_applicant_external_ids (all linked person-application external ids including the primary id, sorted A→Z), account_application_rows_on_account_id, loss_record_count, total_loss_cents, hours_open_to_close (float hours from account-application creation to account close), account_close_date (YYYY-MM-DD only), closure_reason (exact closure reason text), closure_reason_mentions_ida_alert (bool), warehouse_ida_alert_closure_accounts_count, ida_resolution_code (integer), comparison_external_id, comparison_account_application_status, comparison_account_ever_opened, comparison_kyc_outcome (verbatim KYC outcome field only), comparison_ida_resolution_code (integer).