SQL - Account to Access Report

 SELECT EP.DISPLAYNAME AS APPLICATION, ACC.NAME AS 'ACCOUNT NAME', ACC.ACCOUNTTYPE AS 'ACCOUNT TYPE', CASE WHEN ACC.STATUS IS NULL THEN '' WHEN ACC.STATUS = 1 THEN 'Active' WHEN ACC.STATUS = 2 THEN 'Inactive' ELSE ACC.STATUS END 'ACCOUNT STATUS', EV.ENTITLEMENT_VALUE AS 'ACCESS', EV.DISPLAYNAME AS 'ACCESS DISPLAY NAME', ET.DISPLAYNAME AS 'ACCESS TYPE', CASE WHEN EV.STATUS IS NULL THEN '' WHEN EV.STATUS = 1 THEN 'Active' WHEN EV.STATUS = 2 THEN 'Inactive' WHEN EV.STATUS = 3 THEN 'Decomission Active' WHEN EV.STATUS = 4 THEN 'Decommission Inactive' ELSE EV.STATUS END 'ACCESS STATUS', U.USERNAME AS USERNAME, U.FIRSTNAME AS 'USER FIRSTNAME', U.LASTNAME AS 'USER LASTNAME', U.EMAIL AS 'USER EMAIL', U.EMPLOYEETYPE AS 'USER TYPE', CASE WHEN U.STATUSKEY IS NULL THEN 'Not Available' WHEN U.STATUSKEY = 0 THEN 'Inactive' WHEN U.STATUSKEY = 1 THEN 'Active' ELSE U.STATUSKEY END 'USER STATUS', EP.CUSTOMPROPERTY1 AS 'TAG', EP.CUSTOMPROPERTY35 AS 'PROGRAM UUID', EP.CUSTOMPROPERTY36 AS 'PRODUCT UUID', EP.CUSTOMPROPERTY37 AS 'TECHNICAL ASSET UUID', EP.CUSTOMPROPERTY38 AS 'APPLICATION NAME' FROM ACCOUNTS ACC LEFT JOIN ACCOUNT_ENTITLEMENTS1 AE1 ON ACC.ACCOUNTKEY = AE1.ACCOUNTKEY LEFT JOIN ENTITLEMENT_VALUES EV ON AE1.ENTITLEMENT_VALUEKEY = EV.ENTITLEMENT_VALUEKEY LEFT JOIN ENTITLEMENT_TYPES ET ON EV.ENTITLEMENTTYPEKEY = ET.ENTITLEMENTTYPEKEY LEFT JOIN USER_ACCOUNTS UA ON UA.ACCOUNTKEY = ACC.ACCOUNTKEY LEFT JOIN USERS U ON U.USERKEY = UA.USERKEY LEFT JOIN ENDPOINTS EP ON ACC.ENDPOINTKEY = EP.ENDPOINTKEY LEFT JOIN SECURITYSYSTEMS SS ON EP.SECURITYSYSTEMKEY = SS.SYSTEMKEY WHERE EP.DISPLAYNAME IN (${Application}) AND ACC.STATUS IN ( '1', 'Manually Provisioned', 'Active' )