Contents Show
The Upcoming High Risk Appointments Report CLN018 (Output) allows the user to print a report of the upcoming appointments with clients who are classified as high risk. The report is generated when the OK button is clicked on the Generate Upcoming High Risk Appointments Report screen.
This section describes the data elements that print on the system output. Because of space constraints, the layout may be slightly different and/or all characters may not print within the space allotted.
Origin of Data Element
The user records the from and to dates when the report is submitted.
Format
The dates will print in MM/DD/CCYY format.
Origin of Data Element
The code value is the AgencyID column of the Member table for the selected records. The associated name value is the Name column of the Agency table for the corresponding code.
Format
The code is a three-character value and the name is a fifty-character value.
Origin of Data Element
The code value is the ServiceSiteID column of the Member table for the selected records. The associated name value is the ServiceSiteName column of the ServiceSite table for the corresponding code.
Format
The code is a three-character value and the name is a fifty-character value.
Origin of Data Element
This value is the resource and will be taken from the Name column of the AppointmentResource table for the AppointmentResourceID associated with the appointment.
Format
This is a fifty-character value.
Origin of Data Element
This value is the date of the appointment and will be taken from the AppointmentDate column of the Appointment.
Format
The value will print in MM/DD/CCYY format.
Origin of Data Element
The value will be taken from the AppointmentTime column of the Appointment table.
Format
The value will print in HH:MM {AM/PM} format.
Origin of Data Element
The value will be taken from the StateWICID column of the Member table.
Format
This is an eight-character value.
Origin of Data Element
The value will be taken from the HouseholdID column of the Member table.
Format
This is an eight-character value.
Origin of Data Element
The value will be taken from the FirstName, MiddleInitial and LastName columns of the Member table.
Format
The value will print in {first name} {middle initial}. {last name} format.
Origin of Data Element
The value will be taken from the Telephone1 column of the Household table.
Format
This is a ten-character value formatted XXX-XXX-XXXX.
Origin of Data Element
The value will be taken from the Household.InterpreterNeeded.
Format
The value will print as its literal value.
A grand total has not been defined for this report.
High risk participants with Individual Nutrition Education/Check Pickup appointments scheduled at the specified clinic(s) between the starting and ending dates, inclusive, are included in the report. Participants must meet the following selection criteria.
The AppointmentDate column of the Appointment table is between the selected from and to dates, inclusive.
The AgencyID column of the Appointment table is the agency signed on as.
The ServiceSite column of the Appointment table is one of the selected clinics.
If a Resource was specified on the Generate Upcoming High Risk Appointments Report screen, the AppointmentResourceID column of the Appointment table must equal the selected resource. If a Resource was not selected, all appointments for all resources that meet the rest of the selection criteria will be included.
The HighRisk column of the Member table equals "Y".
The ShortDescription column of the AppointmentType table for the associated appointment equals "IND PICKUP".
The report will be sorted first by clinic ID.
The report will be sorted first by resource within clinic ID.
The report will be sorted by appointment date within resource.
The report will be sorted by appointment time within appointment date.
On a change of clinic, a page break will occur.
On a change of resource name, a page break will occur.
On a change of appointment date, a count of upcoming high risk appointments will print.
|
Software Version: 2.40.00
