Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'medical_bmi'

Medical Body Mass Index (MB)

[medical_bmi]

ID Element Name Type Size Values Cycle

Key

MB0010

Fiscal Year - The fiscal year that this reporting represents:
For the 2020-2021 reporting year fy must be = 31

fy Num 2 Table 7
MB0020

Cycle - The reporting cycle for which the data is submitted:

7 = June 15th
cycle Num 1 Table 7
MB0030

LEA, School -Local Education Agency, the unique seven-digit number assigned by the ADE to identify individual county, district, schools, cooperatives, and vocational institutions. The first two digits represent the county, the second two digits represent the district, and the last three digits represent the individual school, for example:

6001002
60 = Pulaski County
01 = Little Rock School District
002 = Hall High School
lea Alpha 7 Appendix C 7
MB0040

SSN, Student - The nine-digit Social Security number of the student. If a student's SSN cannot be obtained, then the ADE assigned number as required by Arkansas Code Ann. 6-18-208 should be used. This number should remain the same throughout the student's school career.

ssn Alpha 9 ######### 7
MB0045

State Reporting ID - The unique 10-digit Triand identifier generated for the student by the state

uniq_stu_id Alpha 10 ########## 7

BMI Data

MB0050

Age - Age of the student

age Num 2 ## 7
MB0060

Location - Where the exam was conducted (this replaces the previously used Station Form)

location Alphanum 25 ## 7
MB0070

Height - Measurement in decimal format

height Dec 4,2 ##.## 7
MB0080

Weight - Measurement in decimal format

weight Dec 6,3 ###.### 7
MB0090

BMI - The Body Mass Index for the student.

bmi Dec 6,4 ##.#### 7
MB0100

BMI Status - The BMI status of the student

HW - Healthy Weight
OB - Obese
OW - Overweight
UW - Under weight
bmi_status Alpha 2 Table 7
MB0110

AN (Acanthosis Nicricans) Reading - The student had an AN reading because the student BMI status is overweight or obese.

an_val Alpha 1 P/N 7
MB0120

Exam Date - The date of the exam

exam_date Date 10 MMDDYYYY 7
MB0130

Reason Not Tested - Two-letter code to indicate the reason for "Unable to Assess":

  • AB – Absent
  • CR – Child Refused
  • PR – Parent Refused
  • PT – Pregnant
  • PD – Physically Disabled
  • HT – 2nd Height Measure not within 1 inch
  • WT – Weight Exceeded Scale
  • OT – Other
reason_not_tested Alpha 2 ## 7
MB0140

Referral Code - Referred to whom because of failed BMI screening:

G - Guardian
NA - Not Applicable
referral_code Alpha 2 ## 7
No change Added Modified Deleted

Back to List