NextGen Knowledge Center

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)