Page History

Query SQL:

SELECT A.SRVC_IND_CD, A.SRVC_IND_REASON, B.LAST_NAME, B.FIRST_NAME, B.MIDDLE_NAME, A.EMPLID, A.AUDIT_ACTN, A.PLACED_METHOD, A.AUDIT_OPRID, TO_CHAR(CAST((A.AUDIT_STAMP) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), TO_CHAR(SYSDATE,'YYYY-MM-DD')
FROM PS_AUDIT_SRVC_IND A, PS_CU_BIO_VW B
WHERE A.INSTITUTION = :1
AND A.SRVC_IND_CD = :2
AND B.EMPLID = A.EMPLID
ORDER BY 3, 4, 5, 10