Query L Dxs w primary: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "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...."
 
mNo edit summary
 
Line 1: Line 1:
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.  
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.
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'''.
[[Category:Centralized data front end.accdb]]

Latest revision as of 16:32, 1 February 2019

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.