true
true
textbox3
7
2pt
2pt
2pt
2pt
2
2
4.5cm
2.5cm
0.53333cm
true
true
=First(Fields!Patient.Value)
textbox2
1
2pt
2pt
2pt
2pt
Output
true
true
=First(Fields!Description.Value)
Description
2pt
2pt
2pt
2pt
Output
=Fields!Practitioner.Value
=Fields!Practitioner.Value
0.53333cm
true
true
=Fields!Practitioner.Value
Practitioner
6
#6e9eca
2pt
2pt
2pt
2pt
0.53333cm
true
true
Patient
textbox6
5
#6e9eca
2pt
2pt
2pt
2pt
true
0.53333cm
true
true
Status
textbox7
4
#6e9eca
2pt
2pt
2pt
2pt
true
Output
true
=Fields!Date.Value
=Fields!AppointStartDate.Value
2.53968cm
true
=Fields!Date.Value
Date
3
#6e9eca
2pt
2pt
2pt
2pt
=Fields!Time.Value
=Fields!Time.Value
2.53968cm
true
true
=Fields!Time.Value
textbox5
2
#6e9eca
2pt
2pt
2pt
2pt
Output
true
Output
true
true
MPNet
1cm
1.59999cm
12.07936cm
true
true
Appointments without Clinical Notes
textbox1
1cm
15cm
1
2.59999cm
16cm
29.7cm
21cm
11in
8.5in
2.5cm
2.5cm
2.5cm
2.5cm
1cm
0
MPNet
None
b0e48cf1-2fbd-42e3-90c1-f2a529961e89
MPNet
=Parameters!DaysBack.Value
SELECT CONVERT(VARCHAR(10), Appointment.AppointStartDate, 103) AS DATE
,CONVERT(VARCHAR(5), Appointment.AppointStartDate, 8) AS TIME
,Appointment.AppointStartDate
,Patient.FirstName + ' ' + Patient.LastName AS Patient
,Practitioner.FirstName + ' ' + Practitioner.LastName AS Practitioner
,Appointment.AppointStatusID
,zStaticData.Description
,zStaticData.StaticDataTypeID
FROM appointment
INNER JOIN Person AS Patient ON Appointment.RefGUID = Patient.PartyGUID
INNER JOIN Person AS Practitioner ON Appointment.WithGUID = Practitioner.PartyGUID
INNER JOIN lookupngnet.dbo.zStaticData AS zStaticData ON Appointment.AppointStatusID = zStaticData.StaticDataID
LEFT JOIN Encounter ON Appointment.AppointmentGuid = Encounter.AppointmentGuid
WHERE (ABS(DATEDIFF(DAY, Appointment.AppointStartDate, GETDATE())) < @daysback)
AND zStaticData.StaticDataTypeID = 100013
AND Encounter.EncounterGuid IS NULL
Patient
System.String
DATE
System.String
TIME
System.String
Practitioner
System.String
AppointStartDate
System.DateTime
Description
System.String
AppointStatusID
System.Int32
StaticDataTypeID
System.Int32
String
7
true
Number of days prior to today to include
en-US
true
Cm
7c1b9cc0-5b63-4cfd-95aa-9dd9925ee7e0