Advanced Directives Review History

NextGen® Enterprise EHR Help

Chart Creation

Identify the creation of patient charts, by user for a given date range, based on NGAudit of Active_Stations and Patient. [Fields] @PatientName = [person] table: last_name, first_name (Patient last name, followed by a comma, then first name) @UserName = [user_mstr] table: last_name, first_name (NextGen end user last name, followed by a comma, then end user first name) @ChangeTime = [active_stations_au] table: au_timestamp (Date and time of the actual record access from the Active Stations Audit table) Person_Nbr = [person] table: person_nbr (NextGen internal person number – Not medical record number) User_Id = [user_mstr] table: user_id (NextGen end user identifier) [Parameters] Start Date – date only: (for Active Stations Audit date/time) End Date – date only: (for Active Stations Audit date/time) Parent topic: CCHIT Reports Field Descriptions

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

Patient Alerts

Listing of Patients with Rx canceled during Drug Utilization Review, as well as listing of critical range lab results by Provider. DUR Alerts Criteria Description: Patients with a record in the dur_audit table Data Reference: {dur_audit.event_text} <> "Rx Cancelled in DUR" DUR Cancelled Criteria Description: Patients with a record in the dur_audit table Data Reference: {dur_audit.event_text} = "Rx Cancelled in DUR LAB Alerts Data Reference: Record in the lab_critical_range audit table [DB Fields] user_mstr.first_name user_mstr.last_name, dur_audit user_mstr.user_id=dur_audit.created_by dur_audit.event_text user_mstr.last_name, lab_critical_range_audit lab_critical_range_audit user_mstr.user_id=lab_critical_range_audit.created_by [Formula Fields] SELECT user_mstr.first_name, user_mstr.last_name, dur_audit.* FROM dur_audit JOIN user_mstr ON user_mstr.user_id=dur_audit.created_by WHERE dur_audit.event_text = 'Rx Cancelled in DUR' Then, via a subreport, show the data from the lab critical

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

Demographic Audit Report

Identify changes to person demographic records, by user for a given date range, based on NextGen Significant Events and Active Stations Audit. [Fields] @ChangeTime = [sig_events] table: create_timestamp (Date and time that the person demographics were modified) @UserName = [user_mstr] table: last_name, first_name (NextGen end user last name, followed by a comma, then end user first name) Person_Nbr = [person] table: person_nbr (NextGen internal person number – Not medical record number) StationName = (subreport) [active_stations_au] table: station_id (Workstation where the update occurred) Sig_Msg = [sig_events] table: sig_msg (Significant Events message – that is, "Last name changed") Pre_Mod = [sig_events] table: pre_mod (Value prior to the change) Post_Mod = [sig_events] table: pre_mod (Value after the change) [Parameters] Start Date – date only: (for Significant Events date/time) End Date – date only: (for Significant Events date/time) Parent topic: CCHIT Reports Field Descriptions

NextGen® Enterprise EHR Help

Patient Lookup

Identify all attempts to lookup a patient in NextGen, by user for a given date range, based on NGAudit of Active Stations and NextGen Significant Events. [Fields] @UserName = [user_mstr] table: last_name, first_name (NextGen end user last name, followed by a comma, then end user first name) @LookupTime = [sig_events] table: create_timestamp (Date and time that the patient lookup occurred) StationName = (subreport) [active_stations_au] table: station_id (Workstation where the update occurred) Post_Mod = [sig_events] table: post_mod (Patient lookup parameters searched – that is, last name, first name, expired, and so on.) [Parameters] Start Date – date only: (for Sig Events date/time) End Date – date only: (for Sig Events date/time) Parent topic: CCHIT Reports Field Descriptions

Advanced Directives Review History

Recommendations

Chart Creation

Chart Update

Patient Alerts

Chart Access

Demographic Audit Report

Patient Lookup

Chart Creation

Chart Update

Patient Alerts

Chart Access

Demographic Audit Report

Patient Lookup