Grade Level Codes and Rule
Code | Description |
---|---|
PK | Pre-Kindergarten |
PKA | Pre-Kindergarten AM |
PKP | Pre-Kindergarten PM |
K | Kindergarten |
KA | Kindergarten AM |
KP | Kindergarten PM |
01 | First Grade |
02 | Second Grade |
03 | Third Grade |
04 | Fourth Grade |
05 | Fifth Grade |
06 | Sixth Grade |
07 | Seventh Grade |
08 | Eighth Grade |
09 | Ninth Grade |
10 | Tenth Grade |
11 | Eleventh Grade |
12 | Twelfth Grade |
Extraction Rule
Include Grade Level is < 0 then use rules for Pre-kindergarten students.
If the Grade Level is < 0 and PreKindergarten is 1 then PKA.
If the Grade Level is < 0 and PreKindergarten is 2 then PKP.
If the Grade Level is < 0 and PreKindergarten is blank/null then PK.
If Grade Level = 0 then extract the Kindergarten Enrollment field.
If the Grade Level is = 0 and Kindergarten Enrollment is AM then extract KA.
If the Grade Level is = 0 and Kindergarten Enrollment is PM then extract KP.
If the Grade Level is = 0 and Kindergarten Enrollment is blank/null then extract K.
If the Grade Level is > 0 then extract the Grade Level as is.
Add leading zero for single-digit grade levels (1 - 9).