Report Layout and Field Match (O=Optional, R=Required)
1. exploreSiteCode- R. Explore site code number. Match to a field or default value as required.
2. lastName- - R. Matched to the Student_Last_Name field in demographics.
3. firstName- - R. Matched to the Student_First_Name field in demographics.
4. middleName - O. Matched to the Student_Middle_Name field in demographics.
5. dateOfBirth- R. Matched to the Birth_Date field in demographics.
6. gender - O. Matched to the Sex field in demographics.
7. grade - O. Matched to the Grade_Year field in demographics.
8. hisp/ lat - O. Match to field with value “1” or blank.
9. am ind/ak - O. Match to field with value “1” or blank.
10. asian - O. Match to field with value “1” or blank.
11. bl/afr am - O. Match to field with value “1” or blank.
12. h/pacif - O. Match to field with value “1” or blank.
13. white - O. Match to field with value “1” or blank.
14. no resp - O. Match to field with value “1” or blank.
15. idNumber - O. Matched to the id_number field in demographics.
16. sortCode - O. Range of 000-999 or blank
17. address1 – O. Match to appropriate demographics field(s).
18. city – O. Matched to the city field in demographics.
19. state – O. Matched to the state field in demographics.
20. postalCode – O. Matched to the Zip_Code_Postal_Code field in demographics.
21. HB (Homebound) – O. Blank or field with value of “1”.
22. SE (Special Ed program) – O. Blank or field with value of “1”.
23. LEP (Limited English Prof) – O. Blank or field with value of “1”.
24. FL (Free/Reduced lunch eligible) – O. Blank or field with value of “1”.
25. M (Title I Math) – O. Blank or field with value of “1”.
26. R (Title I English) – O. Blank or field with value of “1”.
27. X (Locally defined) – O. Blank or field with value of “1”.
28. Y (Locally defined) – O. Blank or field with value of “1”.
29. Z (Locally defined) – O. Blank or field with value of “1”.
30. labelPrintGroup – O. Can be blank. Used to create label sets within schools (e.g. Rm 101, Sec 11, Grade 8).
31. user-defined 1 – O. Can be blank. Check with ACT for values.
32. user-defined 2 – O. Can be blank. Check with ACT for values.
33. user-defined 3 – O. Can be blank. Check with ACT for values.