Signoff Report

Identify both preliminary and final acceptance (signoff) of patient documents, by (signoff) user(s) – preliminary and final, based on the Patient Documents table and the Lock Date contained therein.

[DB Fields] – Timestamp

"person"."first_name"

"person"."last_name"

"user_mstr"."first_name"

"user_mstr"."last_name"

"patient_documents"."document_desc"

"user_mstr_1"."first_name"

"user_mstr_1"."last_name"

"patient_documents"."create_timestamp"

"patient_encounter"."modify_timestamp"

"patient_encounter"."lock_timestamp"

"patient_encounter"."lock_ind"

[Report Fields]

Patient Name = @Patient

Document Name = @Document Name

Preliminary Signoff = @User

Preliminary Date = @CreateDate

Final Signoff = @FinalUser

Final Date = @LockDate

[Formula Fields]

@CreateDate = ToText(DateAdd("h", 5, {patient_documents.create_timestamp}), "yyyy-MM-ddThh:mm:ss") + " (" + ToText({patient_documents.create_timestamp}) + ")"

@Document Name = REPLACE({patient_documents_au.document_desc},"_"," ")

@FinalUser = RTRIM({user_mstr_1.first_name}) + " " + RTRIM({user_mstr_1.last_name})

@LockDate = ToText(DateAdd("h", 5, {patient_encounter.lock_timestamp}), "yyyy-MM-ddThh:mm:ss") + " (" + ToText( {patient_encounter.lock_timestamp}) + ")"

@Patient = {user_mstr.last_name} + ", " + {user_mstr.first_name}

@User = RTRIM({user_mstr.first_name}) + " " + RTRIM({user_mstr.last_name})

[Report Parameters]

{?StartDate} = Date

[Record Selection]

{patient_documents.create_timestamp}={?StartDate} and

{patient_documents.document_desc} = "Master_Im" and

{patient_encounter.lock_ind} = "Y"