Signoff Report B
Identify acceptance (signoff) of patient documents, by (signoff) user, based on NGAudit of the Patient Documents table.
[DB Fields] - Timestamp
"person"."first_name"
"person"."last_name"
"person"."person_id"
"patient_documents_au"."create_timestamp"
"patient_documents_au"."document_desc"
"patient_documents_au"."au_operation"
"patient_documents_au"."signoff_status"
[Report Fields]
Patient Name = @Patient
Document Name = @Document Name
User Name = @ User
Audit Timestamp = "patient_documents_au"."create_timestamp"
[Formula Fields]
@Document Name = REPLACE({patient_documents_au.document_desc},"_"," ")
@Patient = {user_mstr.last_name} + ", " + {user_mstr.first_name}
@User = RTRIM({user_mstr.first_name}) + " " + RTRIM({user_mstr.last_name})
[Report Parameters]
None
[Record Selection]
{patient_documents_au.au_operation} = "U" and
{patient_documents_au.signoff_status} = "A"