Query L Dxs w primary

Revision as of 15:32, 1 February 2019 by Ttenbergen (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Query L_Dxs_w_primary lists the contents of the table L_Dxs with an additional column "is_primary" that is true if a line is a Primary Admit Diagnosis for a patient.

The query is necessary because the priority for these patients is "lowest" but not necessarily a specific number.

This query is the only user of query Primary_admit.