System Administration Audit 1

NextGen® Enterprise EHR Help

System Administration Audit 2

Identify changes to user login credentials or deactivation status, by (modifying) end user for a given date range, based on NGAudit of the User Master table. [DB Fields] "user_mstr_au"."user_id" "user_mstr_au"."au_timestamp" "user_mstr_au"."password" "user_mstr_au"."deact_invalid_login_user_ind" "user_mstr_au"."first_name" "user_mstr_au"."last_name" "user_mstr_au"."modified_by" "user_mstr"."first_name" "user_mstr"."last_name"" [Report Fields] User ID = "user_mstr_au"."user_id" User Name = @UserName, (@ChangeTime – Underneath) Description = @ActionDescription Modified By = "user_mstr_au"."modified_by" Name = @ModifiedName, ("active_stations_au"."station_id" – Underneath) [Formula Fields] @ActionDescription = if ({user_mstr_au.deact_invalid_login_user_ind} <> Previous({user_mstr_au.deact_invalid_login_user_ind})) then if ({user_mstr_au.deact_invalid_login_user_ind} = "Y") then "User Deactivated" else "User Reactivated" else if ({user_mstr_au.password} <> Previous({user_mstr_au.password})

NextGen® Enterprise EHR Help

Chart Update

Identify chart updates, by user for a given date range, based on NGAudit of Active_Stations, Patient and Person. [Fields] @PatientName = [person] table: last_name, first_name (Patient last name, followed by a comma, then first name) @AccountID = [person] table: person_nbr (NextGen internal person number – Not medical record number) @UserName = [user_mstr] table: last_name, first_name) NextGen end user last name, followed by a comma, then end user first name) @UserID = [user_mstr] table: user_id (NextGen end user identifier) @ChangeTime = [active_stations_au] table: au_timestamp (Date and time of the actual record access from the Active Stations Audit table) @ModifyTimestamp = [person] table: modify_timestamp (Date and time that the person record was updated) WorkstationID = (subreport) [active_stations_au] table: station_id (Workstation where the update occurred) [Parameters] Start Date – date only: (for Active Stations Audit date/time) End Date – date only: (for Active Stations Audit

NextGen® Enterprise EHR Help

Password Criteria

Identify changes to password criteria, by user for a given date range, based on NGAudit of System Information. [DB Fields] "sys_info_au"."au_timestamp" "sys_info_au"."au_operation" "user_mstr"."last_name" "user_mstr"."first_name" "sys_info_au"."modified_by" "sys_info_au"."pwd_min_len" "sys_info_au"."password_expiration_days" "active_stations_au"."au_timestamp" "sys_info_au"."req_alphanum_password_ind" "sys_info_au"."password_repetition_limit" "active_stations_au"."user_id" "active_stations_au"."au_operation" "active_stations_au"."station_id" [Report Fields] User = @UserName Station = "active_stations_au"."station_id" Change Date = @ChangeDate Min Length = @MinpwdLength Expiration = "sys_info_au"."password_expiration_days" Alpha Numeric Required = @AlphaNum Repetition Limit = "sys_info_au"."password_repetition_limit" [Formula Fields] @AlphaNum = if {sys_info_au.req_alphanum_password_ind} = "Y" then "Yes" else "No" @ChangedDate = ToText(DateAdd("h", 5, {sys_info_au.au_timestamp}),"yyyy-M

NextGen® Enterprise EHR Help

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({use

NextGen® Enterprise EHR Help

Chart Access

Identify all accesses of person records, by user and workstation for a given date range, based on NGAudit of Active_Stations. [Fields] @PatientName = [person] table: last_name, first_name (Patient last name, followed by a comma, then first name) @AccountID = [person] table: person_nbr (NextGen internal person number – Not medical record number) @UserName = [user_mstr] table: last_name, first_name (NextGen end user last name, followed by a comma, then end user first name) @UserID = [user_mstr] table: user_id (NextGen end user identifier) Location_Name = [location_mstr] table: location_name (NextGen Location name where the encounter took place) @ChangeTime = [active_stations_au] table: au_timestamp (Date and time of the actual record access from the Active Stations Audit table) [Parameters] Start Date – date only: (for Active Stations Audit date/time) End Date – date only: (for Active Stations Audit date/time) Station ID – individual station or "All" (for Active Stations Workstation ID w

NextGen® Enterprise EHR Help

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" Parent topic: CCHIT Reports Field Descriptions

System Administration Audit 1

Recommendations

System Administration Audit 2

Chart Update

Password Criteria

Signoff Report

Chart Access

Signoff Report B

System Administration Audit 2

Chart Update

Password Criteria

Signoff Report

Chart Access

Signoff Report B