SELECT DISTINCT
          PATIENT.PAT_MRN_ID                      AS "PATIENTIDENTIFIER",  
        --IDENTITY_ID.IDENTITY_ID                 AS "PATIENTIDENTIFIER",     -- Jeremy's Found a Few Weird Missing PATIENT.PAT_MRN_ID (I'll match his Clarity Encounter Code Use, because this insurance pull is per Insurance)
          PAT_ENC.PAT_ENC_CSN_ID	              AS "ENCOUNTERIDENTIFIER",
        --PAT_ENC.CONTACT_DATE                    AS "VERBOSEDATE",
          COVERAGE_MEM_LIST.MEM_EFF_FROM_DATE     AS "STARTDATE",
          COVERAGE_MEM_LIST.MEM_EFF_TO_DATE       AS "ENDDATE",
          COALESCE( COVERAGE_MEM_LIST.MEM_NUMBER, 'Unknown' )  AS "POLICYNUMBER",
          V_COVERAGE_PAYOR_PLAN.BENEFIT_PLAN_ID   AS "PLANIDENTIFIER",
          V_COVERAGE_PAYOR_PLAN.BENEFIT_PLAN_NAME AS "PLANNAME",
          V_COVERAGE_PAYOR_PLAN.FIN_CLASS_C       AS "PLANTYPECODE",
          V_COVERAGE_PAYOR_PLAN.FIN_CLASS_NAME    AS "PLANTYPENAME"  

        FROM PAT_ENC
        LEFT OUTER JOIN PATIENT ON ( PAT_ENC.PAT_ID = PATIENT.PAT_ID )
        -- LEFT OUTER JOIN IDENTITY_ID ON ( ( PATIENT.PAT_ID = IDENTITY_ID.PAT_ID ) AND ( IDENTITY_ID.IDENTITY_TYPE_ID = 14 ) ) 
        LEFT OUTER JOIN COVERAGE_MEM_LIST ON ( PAT_ENC.PAT_ID = COVERAGE_MEM_LIST.PAT_ID )  
        LEFT OUTER JOIN V_COVERAGE_PAYOR_PLAN ON ( COVERAGE_MEM_LIST.COVERAGE_ID = V_COVERAGE_PAYOR_PLAN.COVERAGE_ID )

        WHERE ( PAT_ENC.CONTACT_DATE >= DATE '@STARTDATE' )   -- Date Range Start
        AND   ( PAT_ENC.CONTACT_DATE < DATE '@ENDDATE' )    -- Date Range End
        AND   ( COVERAGE_MEM_LIST.MEM_EFF_FROM_DATE <= PAT_ENC.CONTACT_DATE )   -- EFFECTIVE INSURANCE DURING CONTACT
        AND   ( ( COVERAGE_MEM_LIST.MEM_EFF_TO_DATE >= PAT_ENC.CONTACT_DATE ) OR ( COVERAGE_MEM_LIST.MEM_EFF_TO_DATE IS NULL ) )
        AND   ( PATIENT.PAT_MRN_ID IS NOT NULL )
        AND   ( PAT_ENC.PAT_ENC_CSN_ID IS NOT NULL )
        AND   ( COVERAGE_MEM_LIST.MEM_EFF_FROM_DATE IS NOT NULL )
        AND   ( V_COVERAGE_PAYOR_PLAN.BENEFIT_PLAN_ID IS NOT NULL )