WDE-534 School Health Report

Last Modified on 04/10/2024 12:57 pm 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

Screenshot of WDE534 Extract Editor.WDE534 Extract Editor  
 

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


Report Editor

FieldDescription
Start DateBeginning date used to return data. Dates can be entered in mmddyy format or use the calendar icon to select a date.
End DateLast date used to return data. Dates can be entered in mmddyy format or use the calendar icon to select a date.
FormatSelection determines whether the extract generates in the State Format (CSV) or HTML format. Both formats include subsection headers.
Ad hoc FilterWhen 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 SelectionAt 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 GenerationThe 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.


Generate the Report

  1. Enter the Start Date and End Date for the report.
  2. 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.
  3. Select an Ad hoc Filter if individuals included in the report should be limited.
  4. Select the Calendar(s) that should be included in the report.
  5. 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

Screenshot of WDE-534 in HTML Format.WDE-534 HTML Format

Screenshot of WDE-534 in State Format (CSV).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

System Admin > Resources > School > School Editor > School Detail > 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

System Administration > Resources > School > School Editor > School Detail > State School Number

WISER ID

State assigned Staff state identification number.



Numeric, 8 characters

Census > People > Demographics > Person Identifiers > Staff State ID


Person.stateID

First Name

Legal first name of nurse.

Do not use nicknames or preferred names.


Alpha

Census > People > Demographics > First Name


Last Name

Legal last name of nurse.


Alpha		Census > People > Demographics > Last Name
Education

Health License Standard Code mapped to the Code selected in (Census > People > 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		Census > People > Credentials > Licensure/Certification > Health License
Certification

License / Certification Type Standard Code mapped to the Code in (Census > People > 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		Census > People > Credentials > Licensure/Certification > License / Certification Type

Nursing Activities/Acuity

Data Element Name

Description

 Location

School ID

State School Number



Numeric

System Administration > Resources > School > School Editor > School Detail > 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:

Student Info > Health > General > Screenings > Vision > Screening Date is >= extract Start Date and <= extract End Date


Numeric

Student Information > Health > General > 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:

Student Info > Health > General > Screenings > Vision > Follow-ups > Follow-up Type = R: Referral and follow-up Date >= extract Start Date and <= extract End Date


Numeric

Student Information > Health > General > Screenings > Vision > Follow-ups > Follow-up Type

Student Information > Health > General > 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:

Student Info > Health > General > Screenings > Hearing > Screening Date is >= extract Start Date and <= extract End Date


Numeric

Student Information > Health > General > 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:

Student Info > Health > General > Screenings > Hearing > Follow-ups > Follow-up Type = R: Referral and follow-up Date >= extract Start Date and <= extract End Date


Numeric

Student Information > Health > General > Screenings > Vision > Follow-ups > Follow-up Type

Student Information > Health > General > Screenings > Vision > Follow-ups > Follow-up Date


Screening Acuity

Data Element Name

Description

Location

School ID

State School Number



Numeric

System Administration > Resources > School > School Editor > School Detail > 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 (Student Info > Health > General > Conditions > Group) with a Standard Code of '1'


Active condition:
Start Date <= extract End Date
End Date >= extract Start Date or is null


Numeric		Student Information > Health > General > Conditions > Group
Type 2  Diabetes

Count of students with a specific active (Condition > Code) with a mapping to (Student Info > Health > General > Conditions > Group) with a Standard Code of '2'.


Active condition:
Start Date <= extract End Date
End Date >= extract Start Date or is null


Numeric

Student Information > Health > General > Conditions > Group
Asthma

Count of students with a specific active (Condition > Code) with a mapping to (Student Info > Health > General > Conditions > Group) with a Standard Code of '3'.


Active condition:
Start Date <= extract End Date
End Date >= extract Start Date or is null


Numeric

Student Information > Health > General > Conditions > Group
Seizure 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 '4'.


Active condition:
Start Date <= extract End Date
End Date >= extract Start Date or is null


Numeric

Student Information > Health > General > Conditions > Group
Head Injury

Count of students with a specific active (Condition > Code) with a mapping to (Student Info > Health > General > Conditions > Group) with a Standard Code of '5'.


Active condition:
Start Date <= extract End Date
End Date >= extract Start Date or is null


Numeric

Student Information > Health > General > 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

Student Information > Health > General > Conditions > 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

Student Information > Health > General > 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

Student Information > Health > General > 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

Student Information > Health > General > 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

Student Information > Health > General > Conditions > Group


Additional Acuity Questions

Data Element NameDescription Location
School ID

State School Number



Numeric

System Administration > Resources > School > School Editor > School Detail > State School Number


Daily Medication OrdersCount 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		Student Information > Health > Medications > Status

System Admin > Custom > Attribute/Dictionary > Health Medication > Status > Standard Code
PRN Medication OrdersCount 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		Student Information > Health > Medications > Status

System Admin > Custom > Attribute/Dictionary > Health Medication > Status > Standard Code
Percentage Time Mental Health Per DayReports blank.
Technical Nursing ProceduresReports blank.
School nurse provides staff training?Reports blank.
If Yes, expand:Reports blank.
School nurse provides education to students?Reports blank.


Dispositions

Data Element NameDescription Location
School ID

State School Number



Numeric

System Administration > Resources > School > School Editor > School Detail > State School Number
RN - Student returned to class or stayed in school

Count of student health office visits where:

  1. Administered by = 01
  2. Date is on or between the extract Start and End Date range
  3. Health Office Visit > Discharge(s) contain the following in the Name:
    • 'back to'
    • 'stayed'
    • 'returned to'
Numeric		Student Information > Health > Health Office Visits
RN - 911 called

Count of student health office visits where:

  1. Administered by = 01
  2. Date is on or between the extract Start and End Date range
  3. Health office visit > Discharge(s) contain the following in the Name:
    • '911'
    • 'EMS'
    • 'emergency'
Numeric		Student Information > Health > Health Office Visits
RN - Student sent home

Count of student health office visits where:

  1. Administered by = 01
  2. Date is on or between the extract Start and End Date range
  3. Health office visit > Discharge(s) contain the following in the Name:
    • 'home'
Numeric		Student Information > Health > Health Office Visits
LPN - Student returned to class or stayed in school

Count of student health office visits where:

  1. Administered by = 02
  2. Date is on or between the extract Start and End Date range
  3. Health office visit > Discharge(s) contain the following in the Name:
    • 'back to'
    • 'stayed'
    • 'returned to'
Numeric		Student Information > Health > Health Office Visits
LPN - 911 called

Count of student health office visits where:

  1. Administered by = 02
  2. Date is on or between the extract Start and End Date range
  3. Health office visit > Discharge(s) contain the following in the Name:
    • '911'
    • 'EMS'
    • 'emergency'
Numeric		Student Information > Health > Health Office Visits
LPN - Student sent home

Count of student health office visits where:

  1. Administered by = 02
  2. Date is on or between the extract Start and End Date range
  3. Health office visit > Discharge(s) contain the following in the Name:
    • 'home'


Numeric		Student Information > Health > Health Office Visits
UAP - Student returned to class or stayed in school

Count of student health office visits where:

  1. Administered by = 03
  2. Date is on or between the extract Start and End Date range
  3. Health office visit > Discharge(s) contain the following in the Name:
    • 'back to'
    • 'stayed'
    • 'returned to'
Numeric		Student Information > Health > Health Office Visits
UAP - 911 called

Count of student health office visits where:

  1. Administered by = 03
  2. Date is on or between the extract Start and End Date range
  3. Health office visit > Discharge(s) contain the following in the Name:
    • '911'
    • 'EMS'
    • 'emergency'
Numeric		Student Information > Health > Health Office Visits
UAP - Student sent home

Count of student health office visits where:

  1. Administered by = 03
  2. Date is on or between the extract Start and End Date range
  3. Health office visit > Discharge(s) contain the following in the Name:
    • 'home'
Numeric		Student Information > Health > Health Office Visits

Save

Related Articles

Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Copyright ©️ 2010-2023 Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com