We need to insert audit actions in role reports according to cons sec. Wich table is appropriate?

User_1DP7W

This is SQL code


--**FUNCIONARIOS ATIVOS PARA A------------------------------------
SELECT DISTINCT
PU.USERNAME AS "USUARIO"
,PPNF.FULL_NAME AS "NOME COMPLETO"
--,ROLL.END_DATE "END DATA"
,PR.ROLE_NAME AS "NOME DAS ROLES"
, ROLL.LAST_UPDATED_BY AS "USUÁRIO QUE REALIZOU A ATUALIZAÇÃO"
,TO_CHAR (FROM_TZ(CAST(ROLL.LAST_UPDATE_DATE AS TIMESTAMP), 'UTC' ) AT TIME ZONE 'America/Sao_Paulo', 'DD/MM/YYYY HH24:MI:SS') AS "DATA DA ULTIMA ATUALIZAÇÃO"

	   ,CASE 

		   WHEN (PU.SUSPENDED = 'N') THEN 'ATIVO'  

		   WHEN  (PU.SUSPENDED = 'Y') THEN 'INATIVO' 



	  END AS "STATUS DO USUÁRIO"

	  

	   ,CASE 

		   WHEN (ROLL.METHOD_CODE  = 'M') THEN 'MANUAL'  

		   WHEN  (ROLL.METHOD_CODE  = 'E') THEN 'EXTERNO' 

           WHEN  (ROLL.METHOD_CODE  = 'A') THEN 'AUTOMATICO' 

		   

		   ELSE ''

	  END AS "ROLES APLICADAS POR:"

	  

	  

	   

	

	

FROM

PER_USERS PU
,PER_PERSON_NAMES_F PPNF
,PER_USERS PU2
--,PER_PERSON_NAMES_F PPNF2
,PER_USER_ROLES ROLL
,PER_ROLES_DN_VL PR

WHERE PPNF.PERSON_ID = PU.PERSON_ID
AND ROLL.METHOD_CODE = 'M'
AND ROLL.END_DATE IS NULL
AND PU.PERSON_ID = PPNF.PERSON_ID
AND PU.USER_ID = ROLL.USER_ID
AND PR.ROLE_ID = ROLL.ROLE_ID

	AND ROLL.LAST_UPDATED_BY = PU2.USERNAME

	--AND PU2.PERSON_ID = PPNF2.PERSON_ID

	

	

	UNION

	

--**FUNCIONARIOS ATIVOS PARA E------------------------------------
SELECT DISTINCT
PU.USERNAME AS "USUARIO"
,PPNF.FULL_NAME AS "NOME COMPLETO"
--,ROLL.END_DATE "END DATA"
,PR.ROLE_NAME AS "NOME DAS ROLES"

, ROLL.LAST_UPDATED_BY AS "USUÁRIO QUE REALIZOU A ATUALIZAÇÃO"

,TO_CHAR (FROM_TZ(CAST(ROLL.LAST_UPDATE_DATE AS TIMESTAMP), 'UTC' ) AT TIME ZONE 'America/Sao_Paulo', 'DD/MM/YYYY HH24:MI:SS') AS  "DATA DA ULTIMA ATUALIZAÇÃO" 

	  

	   ,CASE 

		   WHEN (PU.SUSPENDED = 'N') THEN 'ATIVO'  

		   WHEN  (PU.SUSPENDED = 'Y') THEN 'INATIVO' 



	  END AS "STATUS DO USUÁRIO"

	  

	   ,CASE 

		   WHEN (ROLL.METHOD_CODE  = 'M') THEN 'MANUAL'  

		   WHEN  (ROLL.METHOD_CODE  = 'E') THEN 'EXTERNO' 

           WHEN  (ROLL.METHOD_CODE  = 'A') THEN 'AUTOMATICO' 

		   

		   ELSE ''

	  END AS "ROLES APLICADAS POR:"

    --  ,CASE 

    --	WHEN PPNF2.FULL_NAME IS NULL THEN ''

	--	ELSE PPNF2.FULL_NAME 

	--  END AS "NOME DA PESSOA QUE FEZ A ATUALIZAÇÃO"

	

	

FROM

PER_USERS PU
,PER_PERSON_NAMES_F PPNF
,PER_USER_ROLES ROLL
,PER_ROLES_DN_VL PR
,PER_USERS PU2
--,PER_PERSON_NAMES_F PPNF2

WHERE PPNF.PERSON_ID = PU.PERSON_ID
AND ROLL.METHOD_CODE = 'E'
AND ROLL.END_DATE IS NULL
AND PU.PERSON_ID = PPNF.PERSON_ID
AND PU.USER_ID = ROLL.USER_ID
AND PR.ROLE_ID = ROLL.ROLE_ID

		AND ROLL.LAST_UPDATED_BY = PU2.USERNAME

	--AND PU2.PERSON_ID = PPNF2.PERSON_ID

	

	

	UNION

	

	

	

	--**FUNCIONARIOS ATIVOS PARA A------------------------------------

SELECT DISTINCT
PU.USERNAME AS "USUARIO"
,PPNF.FULL_NAME AS "NOME COMPLETO"
--,ROLL.END_DATE "END DATA"
,PR.ROLE_NAME AS "NOME DAS ROLES"
, ROLL.LAST_UPDATED_BY AS "USUÁRIO QUE REALIZOU A ATUALIZAÇÃO"
,TO_CHAR (FROM_TZ(CAST(ROLL.LAST_UPDATE_DATE AS TIMESTAMP), 'UTC' ) AT TIME ZONE 'America/Sao_Paulo', 'DD/MM/YYYY HH24:MI:SS') AS "DATA DA ULTIMA ATUALIZAÇÃO"

	   ,CASE 

		   WHEN (PU.SUSPENDED = 'N') THEN 'ATIVO'  

		   WHEN  (PU.SUSPENDED = 'Y') THEN 'INATIVO' 



	  END AS "STATUS DO USUÁRIO"

	  

	   ,CASE 

		   WHEN (ROLL.METHOD_CODE  = 'M') THEN 'MANUAL'  

		   WHEN  (ROLL.METHOD_CODE  = 'E') THEN 'EXTERNO' 

           WHEN  (ROLL.METHOD_CODE  = 'A') THEN 'AUTOMATICO' 

		   

		   ELSE ''

	  END AS "ROLES APLICADAS POR:"

	   

	

FROM

PER_USERS PU
,PER_PERSON_NAMES_F PPNF
,PER_USER_ROLES ROLL
,PER_ROLES_DN_VL PR
, PER_USERS PU2
-- ,PER_PERSON_NAMES_F PPNF2

WHERE PPNF.PERSON_ID = PU.PERSON_ID
AND ROLL.METHOD_CODE = 'A'
AND ROLL.END_DATE IS NULL
AND PU.PERSON_ID = PPNF.PERSON_ID
AND PU.USER_ID = ROLL.USER_ID
AND PR.ROLE_ID = ROLL.ROLE_ID

	AND ROLL.LAST_UPDATED_BY = PU2.USERNAME

--AND PU2.PERSON_ID = PPNF2.PERSON_ID





Please! Could you help me?