Grade Level Codes and Rule

Extraction Rule

• Include Grade Level is lower than kindergarten then use rules for Pre-kindergarten students.

  • If the Grade Level is lower than kindergarten (< 0) and PreKindergarten is 1 then PKA.

  • If the Grade Level is lower than kindergarten (< 0) and PreKindergarten is 2 then PKP.

  • If the Grade Level is lower than kindergarten (< 0) and PreKindergarten is blank/null then PK.

• If Grade Level is kindergarten (= 0) then extract the Kindergarten Enrollment field.

  • If the Grade Level is kindergarten (= 0) and Kindergarten Enrollment is AM then extract KA.

  • If the Grade Level is kindergarten (= 0) and Kindergarten Enrollment is PM then extract KP.

  • If the Grade Level is kindergarten (= 0) and Kindergarten Enrollment is blank/null then extract K.

• If the Grade Level is higher than kindergarten (> 0) then extract the Grade Level as is.

  • Add leading zero for single-digit grade levels (1 - 9).