/
CAFW - CAFCASS Wales

CAFW - CAFCASS Wales

Owned by Owen Wright
Last updated: May 16, 2024

  • [CAFCASS_CASECLOSURE] links to [CAFCASS_INCIDENT] via [CASEID_PE] = [INCIDENTID_PE]

    [CAFCASS_CASECLOSURE] also links to [CAFCASS_CONTACT] via [CHILDID_PE] = [CONTACTID_PE] -- (although there were 2 records where [CHILDID_PE] had no corresponding records in [CONTACTID_PE]; there were also some NULL values in [CHILDID_PE])


    The other 3 tables ([CAFCASS_CASECLOSUREEXPERTS], [CAFCASS_CASECLOSUREORDERS] and [CAFCASS_CASECLOSURETOOLS]) all link to [CAFCASS_CASECLOSURE] via CASECLOSUREID_PE = CASECLOSUREID_PE

    and also to [CAFCASS_INCIDENT] via [CASEID_PE] = [INCIDENTID_PE]

Related content