graph_example.sql

--examples for project proposal

SELECT
	e.PAT_ID, 
	e.PAT_ENC_CSN_ID,
	e.CONTACT_DATE, 
	et.NAME ENC_TYPE, 
    cd.DEPARTMENT_NAME 
FROM pat_enc e 
LEFT JOIN ZC_DISP_ENC_TYPE et ON e.ENC_TYPE_C = et.DISP_ENC_TYPE_C -- Encounter type
LEFT JOIN CLARITY_DEP cd ON e.DEPARTMENT_ID = cd.DEPARTMENT_ID -- Visit department
WHERE e.pat_id in (SELECT PAT_ID FROM ##COHORT )
;