Table of Contents
Overview
district or school level. A summary totaling all schools selected will be available when the report is run at the district level for more than one school. Data entered on the Scoliosis page with a Test Date (SCO.TD) within the school year (based on the District calendar) will be included on this report.
Select Screening by grade or by age to run the report.
- Screening by grade: Includes the Scoliosis records for this school year in the grade categories for the report (G5F, G7F, or G8M).
- Screening by age: Includes the Scoliosis records for this school year in the age categories for the report (A10F, A12F, A13M, or A14M)
Configurations ↑
This report relies on the fixed codes being used for several fields on the Scoliosis page (SCO table). The Update Code Table may be used to add custom codes, however, these custom values will NOT appear on this report and any students coded with those values will not be counted on this report.
Fields and values used for this report:
| Field | Fixed Codes (Required Values) | Spinal Screening Report Column |
| Scrn(SCO.SCN) | CMT Current medical treatment RSC Rescreen UTS Unable to screen Any other Value other value not listed above | A Under Prior Treatment C Rescreened Not included on the report B Screened B Screened |
| Dr (SCO.DR) | Y Yes N No Blank | D Referred |
| Diagnosis (SCO.DG) | KYP Kyphosis NRM Normal OTH Other SCO Scoliosis Blank | G E H F Not included on the report |
| Treatment Plan (SCO.TP) | OB Orthosis Bracing OO Observation Only OS Operation/Surgery OTH Other RU Results Unavailable Blank | J I K L M Not included on the report |
Calculations ↑
Students with Scoliosis Test Dates (SCO.TD) for the current school year based on the district calendar will be included on the report as follows. The report will include inactive students if they were testing during the current school year.
| Report Column | Aeries Fields | Calculation |
| Grade(G)/ Age(A)/ Sex (F or M) | Grade (SCO.GR) + Age (SCO.AG) + Gender (STU.GN) | Screening by Grade:
|
| A Under Prior Treatment | Scr (SCO.SCN) | Count if SCO.SN = CMT |
| B Screened | Scr (SCO.SCN) | Count if SCO.SCN is blank or any value other than 'RSC' or 'CMT' |
| C Rescreened | Scr (SCO.SCN) | Count if SCO.SN = RSC |
| D Referred | Dr Refer (SCO.DR) | Count if SCO.DR = Y |
| E Normal | Diagnosis (SCO.DG) | Count if SCO.DG = NRM |
| F Scoliosis | Diagnosis (SCO.DG) | Count if SCO.DG = SCO |
| G Kyphosis | Diagnosis (SCO.DG) | Count if SCO.DG = KYP |
| H Other | Diagnosis (SCO.DG) | Count if SCO.DG = OTH |
| I Observation Only | Treatment Plan (SCO.TP) | Count if SCO.TP = OO |
| J Orthosis Bracing | Treatment Plan (SCO.TP) | Count if SCO.TP =OB |
| K Operation/Surgery | Treatment Plan (SCO.TP) | Count if SCO.TP =OS |
| L Other | Treatment Plan (SCO.TP) | Count if SCO.TP =OTH |
| M Results Unavailable | Treatment Plan (SCO.TP) | Count if SCO.TP =RU |
NOTE: Column D must equal the sum of the Diagnosis columns E,F,G,H and M (Results Unavailable).
Query to help find Referred students with missing Diagnosis or Treatment Plan indicating results unavailable:
LIST SCO SCO.DR SCO.DG SCO TP IF SCO.TD >= "08/19/2021" AND SCO.TD <= "05/25/2022" AND SCO.DR = "Y" AND SCO.DG = "" AND SCO.TP # "RU"
Students with a Diagnosis or Treatment Plan without Dr Refer set to "Y":
LIST SCO SCO.DR SCO.DG SCO TP IF SCO.TD >= "08/19/2021" AND SCO.TD <= "05/25/2022" AND ( SCO.DR # "Y" OR SCO.DR = "" ) AND ( SCO.DG # " " OR SCO.TP # " " OR SCO.TP = "RU" )
Queries to see a list of students counted on the report:
LIST STU HRN STU.SC STU.ID SCO.GR SCO.SN SCO.PF SCO.DR SCO.DG SCO.TP IF SCO.TD >= "08/19/2022" AND SCO.TD <= "06/30/2023"