eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: EDR.EDR_ESIGNATURES#

Source

View Text - Preformatted


select SIGNATURE_ID SIGNATURE_ID, EVENT_ID EVENT_ID, EVENT_NAME EVENT_NAME, EVIDENCE_STORE_ID EVIDENCE_STORE_ID, USER_NAME USER_NAME, SIGNATURE_SEQUENCE SIGNATURE_SEQUENCE, SIGNATURE_TYPE SIGNATURE_TYPE, SIGNATURE_TIMESTAMP SIGNATURE_TIMESTAMP, SIGNATURE_TIMEZONE SIGNATURE_TIMEZONE, SIGNATURE_STATUS SIGNATURE_STATUS, SIGNATURE_REASON_CODE SIGNATURE_REASON_CODE, SIGNER_COMMENTS SIGNER_COMMENTS, ORIGINAL_RECIPIENT ORIGINAL_RECIPIENT, SIGNATURE_OVERRIDING_COMMENTS SIGNATURE_OVERRIDING_COMMENTS, ADHOC_STATUS ADHOC_STATUS from "EDR"."EDR_ESIGNATURES"

View Text - HTML Formatted

SELECT SIGNATURE_ID SIGNATURE_ID
, EVENT_ID EVENT_ID
, EVENT_NAME EVENT_NAME
, EVIDENCE_STORE_ID EVIDENCE_STORE_ID
, USER_NAME USER_NAME
, SIGNATURE_SEQUENCE SIGNATURE_SEQUENCE
, SIGNATURE_TYPE SIGNATURE_TYPE
, SIGNATURE_TIMESTAMP SIGNATURE_TIMESTAMP
, SIGNATURE_TIMEZONE SIGNATURE_TIMEZONE
, SIGNATURE_STATUS SIGNATURE_STATUS
, SIGNATURE_REASON_CODE SIGNATURE_REASON_CODE
, SIGNER_COMMENTS SIGNER_COMMENTS
, ORIGINAL_RECIPIENT ORIGINAL_RECIPIENT
, SIGNATURE_OVERRIDING_COMMENTS SIGNATURE_OVERRIDING_COMMENTS
, ADHOC_STATUS ADHOC_STATUS
FROM "EDR"."EDR_ESIGNATURES"