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 where access occurred