NextGen Knowledge Center

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)