Order Tracking CCHIT

Identify patient orders, by (ordering) user for a given date range, based on the NextGen® Enterprise EHR Orders grid.

[DB Fields]

"person."person_nbr"

"order_"."actTextDisplay"

"order_"."orderedDate"

"order_"."orderedBy"

"order_"."orderedTime"

"order_"."create_timestamp"

"person"."last_name"

"person"."first_name"

"order_"."actClass"

"active_stations_au"."station_id"

"active_stations_au"."user_id"

"active_stations_au"."au_timestamp"

"active_stations_au"."au_operation"

[Report Fields]

Ordered By = "order_"."orderedBy"

Order = "order_"."actTextDisplay"

WorkstationID = "active_stations_au"."station_id"

Create Timestamp = @Createtime, Create Timestamp(Report Param)

Test Order Date/Time = @OrderedDate , "order_"."orderedTime"

[Formula Fields]

@Create Time = ToText(DateAdd("h", 5, {order_.create_timestamp}), "yyyy-MM-ddTHH:mm:ss") + " (" + ToText({order_.create_timestamp}) + ")"

@Ordered Date = {order_.orderedDate}[5 to 6]+"/"+{order_.orderedDate}[7 to 8]+"/"+{order_.orderedDate}[1 to 4]

@Patient Name = {person.last_name}+", "+{person.first_name}

[Report Parameters]

Create Timestamp, Class code

[Record Selection]

{order_.create_timestamp} = {?Create Timestamp} and

{order_.actClass} = {?Class Code}