Query L Dxs w primary

From CCMDB Wiki
Jump to navigation Jump to search

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.