NextGen Knowledge Center

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)