WDE-534 School Health Report
Last Modified on 07/01/2024 8:24 am CDT
Tool Search: WDE-534
The WDE-534 School Health Report provides information regarding school health statistics.
The report includes six sections:
- School Nurse Data
- School Nurse Education Information
- Nursing Activities/Acuity
- Screening Acuity
- Additional Acuity Questions
- Dispositions
WDE534 School Health Report
Report Logic
Logic for all sections of the report except School Nurse Education Information: - Reports one record per school from the calendar and year selections made on the extract editor.
- Reports only values associated with the calendar(s) selected on the extract editor when the school has more than one calendar in the year.
|
Logic for School Nurse Education Information:
Reports one record for each staff member belonging to the school associated with the calendar(s) selected on the extract editor who have the following: - District Assignment:
- Start Date on or before the extract End Date
AND - End Date of null or on / after the extract Start Date
AND - Health License Credential:
- NOT = null with the Credential Start Date on or before the extract End Date AND
- End Date of null or on / after the extract Start Date
|
| Field | Description |
| Start Date | Beginning date used to return data. Dates can be entered in mmddyy format or use the calendar icon to select a date. |
| End Date | Last date used to return data. Dates can be entered in mmddyy format or use the calendar icon to select a date. |
| Format | Selection determines whether the extract generates in the State Format (CSV) or HTML format. Both formats include subsection headers. |
| Ad hoc Filter | When chosen, only those students / staff included in the selected ad hoc filter are reported in the extract, if they meet the requirements of the extract. |
| Calendar Selection | At least one calendar needs to be selected in order to generate the report. Calendars can be selected by the active year, by school name or by year. |
| Report Generation | The extract can be generated immediately using the Generate Report button. Or, use the Submit to Batch button to select when the report is generated. See the Batch Queue article for more information on this functionality. |
- Enter the Start Date and End Date for the report.
- Select the Format in which the report should generate.
- Use HTML format for data review and verification.
- Use State Format (CSV) for submission to the state.
- Select an Ad hoc Filter if individuals included in the report should be limited.
- Select the Calendar(s) that should be included in the report.
- Click Generate Report to view the report in the selected format or Submit to Batch to schedule when the report will generate. Submit to Batch allows larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.
Example Reports
WDE-534 HTML Format
WDE-534 State Format (CSV)
WDE 534 Report Layout
The following sections describe the fields reported for each section of the report.
Click here to expand...
School Nurse Data
Data Element Name | Description
| Location |
|---|
School ID | Reports the State School Number
Numeric | School Information > State School Number
|
LPN FTEs with Caseload | Reports blank.
|
|
RN Supervising LPN | Reports blank.
|
|
Health Aid FTEs with Caseload | Reports blank.
|
|
RN Supervising Health Aid | Reports blank.
|
|
RN FTEs with Caseload | Reports blank.
|
|
RN in Administrative Role | Reports blank.
|
|
School Nurse Education Information
Data Element Name | Description
| Location |
|---|
| School ID | State School Number
Numeric | School Information > State School Number |
WISER ID | State assigned Staff state identification number.
Numeric, 8 characters | Demographics > Staff State ID
Person.stateID |
First Name | Legal first name of nurse. Do not use nicknames or preferred names.
Alpha | Demographics > First Name
|
| Last Name | Legal last name of nurse.
Alpha | Demographics > Last Name |
| Education | Health License Standard Code mapped to the Code selected in (Credentials > Licensure/Certification > Health License) from the latest Start-dated Credential with Health License NOT = null, when the Credential Start Date <= extract End Date, and End Date is null or >= extract Start Date.
Valid values are: - LPN
- ADN (RN)
- BSN (RN)
- MSN (RN)
- APRN
- Other
Alphanumeric | Credentials > Licensure/Certification > Health License |
| Certification | License / Certification Type Standard Code mapped to the Code in (Credentials > Licensure/Certification > License / Certification Type) from the latest Start-dated Credential with Health License NOT = null, when the Credential Start Date <= extract End Date, and End Date is null or >= extract Start Date, AND License / Certification has a Standard Code mapped to the Code selected.
Reports blank when no Standard Code exists, or when License / Certification = null.
Valid values are: - National Cert
- PIC (PTSB)
- Other
Alphanumeric | Credentials > Licensure/Certification > License / Certification Type |
Nursing Activities/Acuity
Data Element Name | Description
| Location |
|---|
School ID | State School Number
Numeric | School Information > State School Number
|
Screen for Vision
| Number of students screened for vision during the school year.
Report the sum of students with a screening on the Screenings tab where: Screenings > Vision > Screening Date is >= extract Start Date and <= extract End Date
Numeric | Screenings > Vision > Screening Date
|
Referrals for Vision
| Number of students referred for vision during the school year.
Report the sum of students with a screening on the Screenings tab wheret: Screenings > Vision > Follow-ups > Follow-up Type = R: Referral and follow-up Date >= extract Start Date and <= extract End Date
Numeric | Screenings > Vision > Follow-ups > Follow-up Type
Screenings > Vision > Follow-ups > Follow-up Date
|
Screened for Hearing
| Number of students screened for hearing during the school year.
Report the sum of students with a screening on the Screenings tab where: Screenings > Hearing > Screening Date is >= extract Start Date and <= extract End Date
Numeric | Screenings > Hearing > Screening Date
|
Referrals for Hearing
| Number of students referred for hearing during the school year.
Report the sum of students with a screening on the Screenings tab where: Screenings > Hearing > Follow-ups > Follow-up Type = R: Referral and follow-up Date >= extract Start Date and <= extract End Date
Numeric | Screenings > Vision > Follow-ups > Follow-up Type
Screenings > Vision > Follow-ups > Follow-up Date
|
Screening Acuity
Data Element Name | Description
| Location |
|---|
School ID | State School Number
Numeric | School Information > State School Number
|
Individual Healthcare Plans
| Reports blank.
|
|
Nursing Dependent Students
| Reports blank.
|
|
Life Threatening Allergies
| Reports blank.
|
|
| Type 1 Diabetes | Count of students with a specific active (Condition > Code) with a mapping to (Conditions > Group) with a Standard Code of '1'
Active condition:
Start Date <= extract End Date
End Date >= extract Start Date or is null
Numeric | Conditions > Group |
| Type 2 Diabetes | Count of students with a specific active (Condition > Code) with a mapping to (Conditions > Group) with a Standard Code of '2'.
Active condition:
Start Date <= extract End Date
End Date >= extract Start Date or is null
Numeric | Conditions > Group |
| Asthma | Count of students with a specific active (Condition > Code) with a mapping to (Conditions > Group) with a Standard Code of '3'.
Active condition:
Start Date <= extract End Date
End Date >= extract Start Date or is null
Numeric | Conditions > Group |
| Seizure Disorder | Count of students with a specific active (Condition > Code) with a mapping to (Conditions > Group) with a Standard Code of '4'.
Active condition:
Start Date <= extract End Date
End Date >= extract Start Date or is null
Numeric | Conditions > Group |
| Head Injury | Count of students with a specific active (Condition > Code) with a mapping to (Conditions > Group) with a Standard Code of '5'.
Active condition:
Start Date <= extract End Date
End Date >= extract Start Date or is null
Numeric | Conditions > Group |
| Chronic Fatigue Disorder | Count of students with a specific active (Condition > Code) with a mapping to (Student Info > Health > General > Conditions > Group) with a Standard Code of '6'.
Active condition:
Start Date <= extract End Date
End Date >= extract Start Date or is null
Numeric | SConditions > Group |
Mental Health Disorder
| Count of students with a specific active (Condition > Code) with a mapping to (Student Info > Health > General > Conditions > Group) with a Standard Code of "10"
Active condition:
Start Date <= extract End Date
End Date >= extract Start Date or is null
Numeric | Conditions > Group
|
| Medically Fragile | Count of students with a specific active (Condition > Code) with a mapping to (Student Info > Health > General > Conditions > Group) with a Standard Code of '7'.
Active condition:
Start Date <= extract End Date
End Date >= extract Start Date or is null
Numeric | Conditions > Group |
| ADD/ADHD | Count of students with a specific active (Condition > Code) with a mapping to (Student Info > Health > General > Conditions > Group) with a Standard Code of '8'.
Active condition:
Start Date <= extract End Date
End Date >= extract Start Date or is null
Numeric | Conditions > Group |
| Autism | Count of students with a specific active (Condition > Code) with a mapping to (Student Info > Health > General > Conditions > Group) with a Standard Code of '9'.
Active condition:
Start Date <= extract End Date
End Date >= extract Start Date or is null
Numeric | Conditions > Group |
Additional Acuity Questions
| Data Element Name | Description | Location |
| School ID | State School Number
Numeric | School Information > State School Number
|
| Daily Medication Orders | Count of students with an active medication record that has Status mapped to a Standard Code = 1.
Districts must map their daily medication order code to '1'. Numeric, 1 digit | Health > Medications > Status
Custom Attribute/Dictionary > Health Medication > Status > Standard Code |
| PRN Medication Orders | Count of students with an active medication record that has Status mapped to a Standard Code = 2.
Districts must map their PRN medication order code to '2'. Numeric, 1 digit | Health > Medications > Status
Custom Attribute/Dictionary > Health Medication > Status > Standard Code |
| Percentage Time Mental Health Per Day | Reports blank. |
|
| Technical Nursing Procedures | Reports blank. |
|
| School nurse provides staff training? | Reports blank. |
|
| If Yes, expand: | Reports blank. |
|
| School nurse provides education to students? | Reports blank. |
|
Dispositions
| Data Element Name | Description | Location |
| School ID | State School Number
Numeric | School Information > State School Number |
| RN - Student returned to class or stayed in school | Count of student health office visits where: - Administered by = 01
- Date is on or between the extract Start and End Date range
- Health Office Visit > Discharge(s) contain the following in the Name:
- 'back to'
- 'stayed'
- 'returned to'
Numeric | Health > Office Visits |
| RN - 911 called | Count of student health office visits where: - Administered by = 01
- Date is on or between the extract Start and End Date range
- Health office visit > Discharge(s) contain the following in the Name:
Numeric | Health > Office Visits |
| RN - Student sent home | Count of student health office visits where: - Administered by = 01
- Date is on or between the extract Start and End Date range
- Health office visit > Discharge(s) contain the following in the Name:
Numeric | Health > Office Visits |
| LPN - Student returned to class or stayed in school | Count of student health office visits where: - Administered by = 02
- Date is on or between the extract Start and End Date range
- Health office visit > Discharge(s) contain the following in the Name:
- 'back to'
- 'stayed'
- 'returned to'
Numeric | Health > Office Visits |
| LPN - 911 called | Count of student health office visits where: - Administered by = 02
- Date is on or between the extract Start and End Date range
- Health office visit > Discharge(s) contain the following in the Name:
Numeric | Health > Office Visits |
| LPN - Student sent home | Count of student health office visits where: - Administered by = 02
- Date is on or between the extract Start and End Date range
- Health office visit > Discharge(s) contain the following in the Name:
Numeric | Health > Office Visits |
| UAP - Student returned to class or stayed in school | Count of student health office visits where: - Administered by = 03
- Date is on or between the extract Start and End Date range
- Health office visit > Discharge(s) contain the following in the Name:
- 'back to'
- 'stayed'
- 'returned to'
Numeric | Health > Office Visits |
| UAP - 911 called | Count of student health office visits where: - Administered by = 03
- Date is on or between the extract Start and End Date range
- Health office visit > Discharge(s) contain the following in the Name:
Numeric | Health > Office Visits |
| UAP - Student sent home | Count of student health office visits where: - Administered by = 03
- Date is on or between the extract Start and End Date range
- Health office visit > Discharge(s) contain the following in the Name:
Numeric | Health > Office Visits |
Save
WDE534 School Health Report
WDE-534 HTML Format
WDE-534 State Format (CSV)
