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 date/time)
