NextGen Knowledge Center

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"