Colorado state reporting in PowerSchool requires a value in the field S_CO_STU_X.StateLunchStatus. The accepted values for S_CO_STU_X.StateLunchStatus are 00 (Not Eligible), 01 (Free Lunch Eligible), and 02 (Reduced Lunch Eligible). However, this field is updated independently of the native LunchStatus field in PowerSchool, with values P (Full Pay), F (Free), and R (Reduced).
Could Level Data create a validation rule that flags any student that has a mismatch between the LunchStatus field and the StateLunchStatus field? This is not a hard and fast state reporting rule, but could indicate a problem with data management that needs to be reviewed.
Broadly, the fields should align like this:
S_CO_STU_X.StateLunchStatus = LunchStatus
00 = P
01 = F
02 = R