Aperture DESSA

The task produces a students.csv file that contains a row for every schedule students class.

Required Fields
Field Name Validation
Student ID At least one non-whitespace character, unique within the Program
Last Name At least one non-whitespace character
First Name At least one non-whitespace character
Gender M,F,T,U,N, or X
DOB Date Format: mm/dd/yyyy
Grade Level K,1,2,3,4,5,6,7,8,9,10,11, or 12
American Indian or Alaskan Native ‘Y’, ‘N’ or 'U'
Asian ‘Y’, ‘N’ or 'U'
Black or African American ‘Y’, ‘N’ or 'U'
Hispanic or Latinx ‘Y’, ‘N’ or 'U'
Native Hawaiian or Pacific Islander ‘Y’, ‘N’ or 'U'
White ‘Y’, ‘N’ or 'U'
Other ‘Y’, ‘N’ or 'U'
Staff Last Name At least one non-whitespace character
Staff First Name At least one non-whitespace character
Staff Email Address Email format, unique within the Org
Site Name At least one non-whitespace character
Class Name (1 of 3) One of these three fields must have non-whitespace content
Class Code (2 of 3) One of these three fields must have non-whitespace content
Class Period (3 of 3) One of these three fields must have non-whitespace content

Recommended Fields
Special Ed Blank, ‘Y’ or ‘N’
Section 504 Blank, ‘Y’ or ‘N’
English Learner Blank, ‘Y’ or ‘N’
Reduced Price Meals Blank, ‘Y’ or ‘N’
Economically Disadvantaged Blank, ‘Y’ or ‘N’
McKinney-Vento Blank, ‘Y’ or ‘N’
Migrant Blank, ‘Y’ or ‘N’
Gifted Blank, ‘Y’ or ‘N’
 Zip Code Blank or #####