SELECT
	PEOPLE."COSTCODE",
	PEOPLE."EMPLOYEENAME",
	PEOPLE."EMPLOYMENTSTATUS",
	PEOPLE."FIRSTNAME",
	PEOPLE."LASTNAME",
	PEOPLE."L3_COSTCODE",
	PEOPLE."USERNAME",
	AD."SAM_ACCOUNT_NAME_UC",
	REPLACE(FSN."ATTRIBUTE_VALUE", '''', ''),
	FSN."VIEW_NAME"
FROM "ARM.MODEL.VIEW.PEOPLE::PEOPLE" AS PEOPLE
LEFT JOIN "ARM.MODEL.VIEW.ARM_AD::AD_USER_GRP" AS AD ON (PEOPLE."USERNAME" = AD."SAM_ACCOUNT_NAME_UC")
LEFT JOIN "ARM.MODEL.VIEW.FSN_SECURITY::FSN_SEC_COND" AS FSN ON (PEOPLE."USERNAME" = REPLACE(FSN."ATTRIBUTE_VALUE", '''', '') OR AD."GROUP_MEMBER" = FSN."ATTRIBUTE_VALUE")
WHERE PEOPLE."EMPLOYMENTSTATUS" = 'Active'
	AND PEOPLE."L3_COSTCODE" = 'DIVSDD'
	AND AD."GROUP_MEMBER" LIKE '%FSN%'
	AND PEOPLE."USERNAME" = 'BRAJAR01'