September 30th Attendance and Enrollment (Maryland)

Classic View: MD State Reporting > September 30th Attendance and Enrollment

Search Terms: September 30th Attendance and Enrollment

The September 30th Attendance and Enrollment extract reports information about all primary enrollment records in regular day school, evening high school and part-time programs.  

September 30th Attendance and Enrollment Extract Editor


Report Logic

  • Reports all students enrolled from the beginning of the school year to the End Date entered on the extract editor (assumed to be the last school day of September).
    • All Primary and Special Ed Services enrollment types are reported.
  • Students who are state excluded or enrolled in state excluded calendars are not reported.
  • When students have multiple enrollments in the same calendar, a separate record reports for each enrollment in the calendar before the report end date.
  • June 1 YYYY of the beginning school year is the date used when calculating a 2 year threshold.

Absence Calculation

If the student....Then Campus...
HAS a value in the FTE override field
on the enrollment
  1. Finds the Student’s FTE on enrollment.
  2. Finds the number of student day minutes from the calendar.
  3. Multiplies the number of student day minutes by the FTE.
  4. Divides the number of minutes the student was absent by the product in number #3.
    1. Absences are defined by any attendance code tied to a state code of 1-21.
    2. The Table below outlines how values are converted 1, .5, or 0

      Percent Absent

      Absent Value

      Attendance Value

      0-33

      0

      1

      34-66

      .5

      .5

      67-100

      1

      0

has an FTE value of 1 or the FTE field is null

calculates the total number of absences for the reporting period based on the values found in System Administration > Calendar > whole day (absence) and half day (absence). Absences are defined by any attendance code tied to a state code of 1-21.

Reporting Data for AOP Students

The following enrollment data elements report from the most recent enrollment in the calendar(s) selected in the extract editor.

Data Element Number

Data Element Name

DE 100

Grade Level

DE 180

Migrant

DE 190

Foreign Exchange Student

DE 280

Entry Status

DE 290

Entry Code

DE 300        

Entry Date

DE 340

Exit Status

DE 350

Exit Code

DE 360

Exit Date

The following attendance data elements are calculated for each enrollment then summed for a total and reported as a single record.

Data Element Number

Data Element Name

DE 310

Days Attending

DE 320

Days Absent


Report Editor Fields

FieldDescription
Start DateEnrollment records on and after this date are eligible for reporting.
End DateEnrollment records on and before this date are eligible for reporting.
Run DateThis populates the Submission date field and is used for calculation in the State Eligibility field in the extract (default value is the current date). 
Special Services DateUsed to determine a student’s status in EL, Migrant, FARMS
EL Exempt Date

This date is used to determine what reports in the EL Exempt field. To report Y in the EL Exempt field, the student's most recent EL Identified date must be after the EL Exempt Date entered here.

Non-Public End Date

This field is used to help calculate the End Date field.

Non-Public End Status

This field is used to help calculate the Exit Status and Exit Code fields.

Ad Hoc FilterAd Hoc filters are available for narrowing report results.
Format
  • CSV
  • HTML
Select CalendarsSelect the schools to include in the report.
Generate Report
Submit to Batch
Users have the option of submitting the report request to the batch queue by clicking Submit to Batch instead of Generate Report. This process allows larger reports to generate in the background without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Report Elements

The following table describes each report element. 

Data ElementDescriptionLocation
LEA NumberThe two-digit state designation of the local education agency (LEA).


Numeric, 2 digits
System Administration > Resources > District Information > State District Number
School Number

Reports the home school number from the student’s enrollment. If the school number is null, the school number on the school tied to the enrollment reports.


Numeric, 4 digits

System Administration > Resources > School > State School Number
State Assigned Student ID (SASID)The student's state-assigned ID number.

Numeric, 10 digits
Census > People > Demographics > Student State ID
Local Student ID Number (LASID)The student's LEA-assigned ID number.

Numeric, 10 digits
Census > People > Demographics > Student Number
Last NameThe student's last name.
  • Reports the last name from the current Identity record. Legal Last Name reports. If Legal Last Name is null, the Last Name reports.

Alphanumeric, 25 characters
Census > People > Identities > Current Identity > Legal Last Name or Last Name
First NameThe student's first name.
  • Reports the first name from the current Identity record. Legal First Name reports. If Legal First Name is null, the First Name reports.


Alphanumeric, 15 characters

Census > People > Identities > Current Identity >Legal First Name or First Name
Middle NameThe student's middle name.
  • Reports the middle name from the current Identity record. Legal Middle Name reports. If Legal Middle Name is null, the Middle Name reports.

Alphanumeric, 15 characters
Census > People > Identities > Current Identity > Legal Middle Name or Middle Name
Generational SuffixThe suffix tied to the student's name.
  • Reports the suffix from the current Identity record. If the Legal First Name and Legal Name are not null, Legal Suffix reports. If the Legal First Name and Legal Middle Name are null, Suffix reports.

Alphanumeric, 3 characters
Census > People > Identities > Current Identity > Legal Suffix or Suffix
Preferred NameAn alternative first name preferred by the student.


Alphanumeric, 15 characters
Census > People > Identities > Current Identity > Preferred Name
Date of BirthThe student's date of birth.

Date field, 8 characters

YYYYMMDD

Census > People > Identities > Current Identity > Date of Birth
Grade

The student's grade level.

  • When a 9th grade student's enrollment end date is before the term start date (the student has previous enrollments), grade 08 reports.


Numeric, 2 digits

Student Information> General > Enrollments > Grade
Gender

The student's gender.

M: Male

F: Female

X: Non-Binary


  • Reports the gender from the current Identity record. Legal Gender reports. If Legal Gender is null, Gender reports.


Alphanumeric, 1 character

Census > People > Identities > Current Identity > Legal Gender and Gender
Hispanic or Latino Ethnicity

An indication that the person traces their origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race.

If Is the individual Hispanic/Latino = Yes, Y  reports. Otherwise, N reports.


Alphanumeric, 1 character

Census > People > Demographics > Race Ethnicity > Is the individual Hispanic/Latino

American Indian or Alaska Native

Indicates the person has origins with any of the original peoples of North and South America (including Central America) and maintains cultural identification through tribal affiliation or community attachment.

  • If the American Indian or Alaska Native checkbox is marked, 1 reports. Otherwise, 0 reports.


Numeric, 1 digit

Census > People > Demographics > Race/Ethnicity > American Indian or Alaska Native

Asian

Indicates the person has origins in any of original peoples of the Far East, Southeast Asia, or the Indian Subcontinent. This area includes Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, Philippine Islands, Thailand, and Vietnam.

  • If the Asian checkbox is marked, 2 reports. Otherwise, 0 reports.


Numeric, 1 digit

Census > People > Demographics > Race/Ethnicity > Asian

Black or African American

Indicates the person has origins in any of the black racial groups of Africa.

  • If the Black or African American checkbox is marked, 3 reports. Otherwise, 0 reports.


Numeric, 1 digit

Census > People > Demographics > Race/Ethnicity > Black or African American

Native Hawaiian or Other Pacific Islander

Indicates the person has origins in any of original peoples of Hawaii, Guam, Samoa, or other Pacific Islands.

  • If the Native Hawaiian or Other Pacific Islander checkbox is marked, 4 reports. Otherwise, 0 reports.


Numeric, 1 digit

Census > People > Demographics > Race/Ethnicity > Native Hawaiian or Other Pacific Islander

White

Indicates the person has origins in any of the original peoples of Europe, Middle East, or North Africa.

  • If the Native Hawaiian or Other Pacific Islander checkbox is marked, 5 reports. Otherwise, 0 reports.


Numeric, 1 digit

Census > People > Demographics > Race Ethnicity > White
Homelessness Status

Indicates whether the student lacks a fixed, regular, and adequate nighttime residence.

  • If the Homeless checkbox is marked, Y reports. Otherwise, N reports.


Numeric, 1 digit

Student Information > General > Enrollments > State Reporting Fields > Homeless
Title 1 Indicator

Indicates if the student participated in a Title 1 program.

This field reports Y if:

  • The student has an active Title1 Flag with a state code of T1 and is marked as state reported as of the report end date report.
    OR
  • The student has a value in the home school field on their enrollment AND there is a school in the district with that state school code. Campus finds the school record that falls as of the end date in the extract editor and reports the value from the Title 1 field on that school.

Code in School

Description

Reports

TGELGBNOPROG

Targeted Assistance Eligible - No Program

N

TGELGBTGPROG

Targeted Assistance Program

If the student has an active Title1 Flag with a state code of T1 and is marked as state reported as of the report end date, Y reports. Otherwise, N reports.

SWELIGTGPROG

Schoolwide Eligible - Targeted Assistance

If the student has an active Title1 Flag with a state code of T1 and is marked as state reported as of the report end date, Y reports. Otherwise, N reports.

SWELIGNOPROG

Schoolwide Eligible- No Program

N

SWELIGSWPROG

Schoolwide Program

Y

NOTTITLE1ELIG

Not a Title I School

N


Otherwise, N reports.


Alphanumeric, 1 character

System Administration > Resources > School > Title 1 and Student Information > General > Enrollments > State Reporting Fields > Title 1

System Administration > Resources > School >Title 1 = School wide program

Student Information > General > Enrollment > State Reporting > Home School 

Free/Reduced Price Meals

Indicates if the student receives free/reduced price meals. If the Migrant element reports Y, then this field reports FOtherwise, the value reports from the FRAM record as of the end date entered on the extract editor.


If the eligibility status is N, the value as of the Special Services Date reports.

Eligibility

Reports

Free

F

Reduced

R

Non-Reimbursable

N

Paid

N


Alphanumeric, 1 character
FRAM > Eligibility > Eligibility
Migrant

Indicates if the student is a migrant as of the End Date on the extract editor.

If the Migrant record is N,  then the status as of the Special Services Date reports.


Alphanumeric, 1 character

Student Information > General > Enrollment > State Reporting Fields > Migrant
Foreign Exchange Student

Indicates whether the student is a foreign exchange student.

  • This field only reports for students in grades 9-12 as of the End Date on the extract editor.. If Foreign Exchange is null or the student is in grades PK-08, N reports.


Alphanumeric, 1 character

Student Information > General > Enrollment > State Reporting Fields > Foreign Exchange
Special Education Services

Indicates the students special education status.

  • To determine the status, Campus uses the student’s most recent IEP where the print format is MD SPED Data as of the end date entered on the extract editor.
  • If the Special Ed status is N,  Campus looks at the Special Ed services date and determines whether the student meets requirements for reporting a Y. Otherwise, N reports.
  • If the student’s most recent enrollment is end dated and the enrollment end date is prior to report end date, Campus reports the Special Ed status as of the enrollment end date.

The hierarchy for reporting status is Y, E, 3, 2,  N. 

CodeStatusDescription
YYes, student has an IEP and is receiving special education services

Y reports when the most recent IEP has a Special Ed Start Date that is prior to or equal to report extract editor End Date and the latest IEP Closed Date is less than or equal to the extract editor Run Date  AND meets one of the following:

  • Exit code is null OR
  • Exit code is not Null  and  is not  A or J OR
  • Exit code is  A or J AND Special Ed Exit date after the report end date
EExited the program, not currently receiving SE services.

E reports when

  • The student’s most recent IEP has a Special Ed Start Date that is prior to or equal to the report extract editor End Date and the latest IEP Closed Date is less than or equal to the extract editor Run Date AND
  • The Exit code is A or J AND
  • The student has no 504 record OR   the student has 504 record with a start date before the Special Ed Exit Date 
3Exited Special Education and placed in Code 504

3 reports when

  • The student has a 504 flag that meets all of the following requirements: Active as of extract editor end date AND the Start date is after special education exit date AND   
  • The most recent IEP meets ALL of the following requirements:
    • Special Ed Start Date that is prior to or equal to report extract editor end date
    • IEP Closed Date is less than or equal to the extract editor Run Date
    • Exit code is A or J
 2 Code 504

 2  reports when the student has an active 504 record with a start date before the extract editor End Date and meets one of the following requirements:

  • 504 end date is NULL  OR 
  • 504 End date is after the extract editor end date  AND  the student does not flag as E or 3.
NNo, student does NOT have an IEP and is not receiving services.N reports when the student does not meet any of the above values of Y, E, 3 , or 2. 

Alphanumeric, 1 character

Student Information > General > Enrollment > Special Ed Fields > Special Ed Status

Student Information > Special Ed>Documents > IEP > Print Format is MD SPED Date > Detail Editor > Start Date, IEP Closed Date, Exit Code

 Student Information > General > Flags > Flag (with a state code of 504 and marked as state reported) 

Special Ed End Date

When the Special Education Services field is E or 3, this field reports the special education Exit Date as of the Effective Date on the extract editor.


Date field, 8 characters

YYYYMMDD

Student Information > General > Enrollment > Special Ed Fields > Exit Date
Special Ed Certificate

Indicates whether the student is on track to receive a MD High School Certificate of Completion. This is required if Special Education Services = Y.

reports when

  • The student's most recent IEP has a Special Ed Start Date prior to or equal to the report's End Date, AND
  • The IEP Closed Date is less than or equal to the report Run Date, AND
  • The Special Ed Certificate checkbox is selected, AND
  • One of the following requirements is met:
    • Exit Reason is null, OR
    • Exit Reason is not Null and is not A or J, OR
    • Exit Code is A or J AND Special Ed Exit date equal to or after the report End Date.

Otherwise, N reports.


Alphanumeric, 1 character

Student Information > Special Ed > Documents > IEP > (Print Format is MD SPED Date) > Detail Editor > Start Date, IEP Closed Date, Exit Reason, Certificate
 English Learner (EL) Status 

Indicates whether the student has a primary or home language other than English and has been assessed as having limited or no ability to understand, speak or read English.

  • Reports the student's most recent EL record where the Identified Date is on or before the End Date on the extract editor.
  • If the EL record Program Status is N,  the EL status as of the Special Services date in the extract editor reports.

EL Status

Reports

EL

Y

Exited EL

 Y - (When the EL Exited Date is after the Report End Date)

Exited EL

E - (When EL Exited Date is before the Report End Date)

Not EL

N

Pending

N

No Record

N


Alphanumeric, 1 character

Student Information > Program Participation > English Learners (EL) > EL  > Program Status

EL Begin DateThe eight-digit date for when EL services started for a student.

Date field, 8 characters

YYYYMMDD

Student Information > Program Participation > English Learners (EL) > EL > Program Exit Date

English Learner Entry into the US Date

The date when the student began EL services or entered the U.S. for the first time. This field is required if EL Indicator = Y or E OR Immigrant = Y.

  • When EL Indicator = Y or E, the date the student entered the US reports.
  • If the EL Indicator is null, the identified date from the earliest EL Record reports.
  • Otherwise, this field reports blank.


Date field, 8 characters

YYYYMMDD

Census > People > Demographics > Date Entered US School

Student Information > Program Participation > English Learners (EL) > EL > Identified Date

EL End Date

The eight-digit date of when EL services ended for a student.

 The EL End Date reports blank when the EL Status is Y. 

 The Program End Date reports when EL Status is E; otherwise this field reports blank.


Date field, 8 characters

YYYYMMDD

Student Information > Program Participation > English Learners (EL) > EL > Program Exit Date

English Learner ELA Assessment Exempt Status

Indicates that the student receiving ESOL services in their first year of enrollment in a U.S. school is exempt from the PARCC English/Language Arts assessment and may substitute the required state assessment with the English Language Proficiency Assessment (ACCESS for ELs 2.0).

  • When EL Status = Y, Y reports for student’s in their first year of enrollment in a U.S. School. Otherwise, N reports.
  • Students are exempt if they are within 1 calendar year (365 days) of their first day enrolled in a US school.


Alphanumeric, 1 character

Student Information > Program Participation > English Learners (EL) > EL > Program Status

Census > People > Demographics > Date Entered US School

Foster Care StatusIndicates whether the student is in foster care.
  • Y reports when the student has an active foster care record on the report End Date. Otherwise, N reports.


Alphanumeric, 1 character

Student Information > Program Participation > English Learners (EL) > EL Services > Foster Care
Military Connected Indicator

Indicates the student has a parent or guardian in the military.

  • Reports the value populated:
    • Reports for Yes.
    • Reports U for Unknown.
    • Reports N for No.
  • Otherwise, reports blank.


Alphanumeric, 1 character

Student Information > Enrollments > Military Connected Status
Gifted and Talented Student Indicator

Indicates whether the student is identified as gifted/talented.


Alphanumeric, 1 character

Y or N

Student Information > Program Participation > Gifted & Talented
 Filler N/AN/A
Submission DateThe date the file was submitted to the MSDE.

Date field, 8 characters

YYYYMMDD

Not dynamically stored
Entry Status

The student's entry status. 

  • Reports from the left most justified alpha value from the start status code.
ValueDescription
RFirst time entries in the current school year
EEnter by transfer from another school in the current school year
NRe-entry following a withdrawal in the current school year
0

Summer transaction; Entry Status not applicable

Also reports when the student's start date and end date are before the first instructional and attendance day of the calendar.


Alphanumeric, 1 character

Student Information > General > Enrollments > Start Status > Standard Code

System Administration > Calendar > Calendar > Days


Entry Code

The student's entry code that best describes their last school affiliation prior to entry into the current school. 

  • If the student has multiple entries, a record reports for each entry.
  • 00 reports when the student start date and end date is before the Term start date.


Alphanumeric, 2 characters

Student Information > General > Enrollments > Start Status > Standard Code

System Administration > Calendar > Calendar > Days

Entry DateThe enrollment start date. 
  • 00000000 reports when the student start date and end date are before the first instructional/attendance day in the calendar tied to the enrollment.

Date field, 8 characters

YYYYMMDD

Student Information > General > Enrollments > Start Date; End Date

System Administration > Calendar > Calendar > Days

Days Attending

The aggregate number of days the student was in attendance during the current school year, rounded to the nearest half-day.

  • Logic Calculation:
    • Days Enrolled - Days Absent as of the End Date entered on the report editor then multiplied by 10.

Example

10 days = 0100


  • If the  student's enrollment is tied to a school with a school type of 99, 0000 reports.

See the Report Logic for more information.


Numeric, 4 digits

Calculated
Days Absent

The aggregate number of days the student was absent during the current school year, rounded to the nearest half-day.

  • If the student's enrollment is tied to a school with a school type of 99, 0000 reports.

See the Report Logic for more information.


  • Numeric, 4 digits
Calculated based on System Administration > Calendar > Calendar > Student Whole Day Absence, Student Half Day Absence
 Filler N/AN/A
Exit Status

The student's exit status.

  • T: Transferred
  • W: Terminated
  • C: Completed
  • 0: Student has not exited; Exit Status not applicable

If the enrollment is tied to a school with a school type of 99:Non -public, the value reports from the Non-public End Status selected on the extract editor, using the following logic:

  • If the enrollment end date is null, 0 reports.
  • If Enrollment end date is within report generation Start and End Dates, the enrollment end status reports from the left most justified alpha in the End Status dictionary's Code (Attribute dictionary > Enrollments > End Status > Code).

Otherwise, 0 reports.


Numeric, 1 digit

Student Information > General > Enrollments > End Status > Standard Code
Exit Code

The reason the student is exiting. If a student has multiple exits, a record reports for each exit code.

  • If an enrollment is tied to a school with a school type of 99:Non-public   , the value reports from the Non-public End Status selected on the extract editor, using the following logic:
    • If the enrollment end date is null, 00 reports.
    • If Enrollment end date is within report generation Start and End Dates, the enrollment end status reports from the left most justified alpha in the End Status dictionary's Code (Attribute dictionary > Enrollments > End Status > Code).
  • Otherwise, 00 reports.


Numeric, 2 digit

Student Information > General > Enrollments > End Status
Exit Date

The date the student exited.

  • If an enrollment is tied to a school with a school type of 99:Non -public, the end date reports from the Non Public End Date field selected on the extract editor.
  • If an enrollment end date is prior to the start of the first instructional and attendance day, YYYY/07/01 reports.
  • If an enrollment end date is null, 00000000 reports.
  • If an enrollment end date is not null and is after the first instructional and attendance day in the calendar tied to the enrollment, the next instructional day’s date after enrollment end date reports. The exit date only reports when the enrollment end date is prior to the End Date and after the Start Date entered on the extract editor.
  • Otherwise, 00000000 reports.

Date field, 8 characters

YYYYMMDD

Student Information > General > Enrollments > End Date
 Filler N/AN/A
Pre-K Full-Time Status

Indicates if the student is in Pre-Kindergarten.

  • Y – Prekindergarten student who attends school for a full day and have an active enrollment as of the report End Date tied to a state grade of 92.
  • N – Prekindergarten student who attends school for less than a full day and enrolled in state grades of 93-96.
  • All other students report a blank.


Alphanumeric, 1 character

Student Information > General > Enrollments > Grade
 Filler N/AN/A
State Aid Eligibility

Indicates the student's eligibility for State Financial Assistance under the Foundation Program.

  • Reported values:
    • 00: Withdrawn
    • 01: Eligible for State Aid
    • 02: Ineligible - Age 21 and Over
    • 03: Ineligible - Age less than 5
    • 04: Ineligible - No attendance in September
    • 05: Non-resident
    • 06: Ineligible - Enrolled in PK
    • 07: Ineligible - Documentation of immunization unavailable
    • 09: Ineligible - Nonpublic Placement
  • 08 is not valid and reports a value of 00.


Numeric, 2 digits

Student Information > General > Enrollment > State Reporting Fields > State Aid Eligibility
Evening High School Student

Indicates whether the student is attending an evening high school program.

  • This field will only report for students in grades 09-12.
Reports...When...
Y
  • the FTE is less than 1 AND
  • the student is scheduled into at least one course section where the section class type is marked as E: Evening AND
  • the student is is scheduled into fewer than four course sections marked as college OR courses without the student being enrolled in an associated evening sections as of the end date entered on the extract editor.
N
  • the student’s FTE is 1 OR
  • the student has no evening sections OR
  • the sum of college courses plus part time courses is 4.

Alphanumeric, 1 character

Course > Section > Class Type is E:Evening

EH Number of Courses

The number of courses the Evening High school student is enrolled in as of September 30th. 

  • This value cannot exceed 4.

If Part Time+ College Course Count 

Evening Course Count

Reports

3

1 or more

1

2

2 or more

2

2

1

1

1

3 or more

3

1

1 or 2

Total number of courses


Numeric, 1 digit
Calculated
Part-Time Student

Indicates whether the student is considered a part-time student.

Reports...When...OR When...
Y
  • FTE is 1 AND
  • Student is scheduled into at least one but no more than 3 courses flagged as college as of the extract editor end date AND
  • Student has at least 1 course NOT marked as evening.
  • FTE is less than 1 AND
  • Student has fewer than 4 college courses AND
  • Student must have at least 1 course without an associated evening section.
N
  • FTE is and the requirements for Y are not met OR
  • FTE is less than 1 AND 
  • College Courses is 0 AND 
  • Student is scheduled into 4 or more course/sections that do not have a section type of Evening.
  • FTE is less than 1 AND
  • Student is registered into 4 or less courses AND
  • All those courses are flagged as college or are courses with an associated evening section.

Alphanumeric, 1 character
Student Information > General > Enrollment > State Reporting > FTE
PT Number of Courses

The number of courses the part time student is enrolled in.

  • If the student reports N in the Part-Time Student field, then 0 reports.
  • If the student reports Y in the Part-Time Student field, then Campus completes the following tasks:
  1. Finds the number of courses the student is registered into as of the extract editor End Date that are flagged as college.
  2. Finds the number of courses flagged as evening as of the extract editor End Date.
    Any remaining courses are considered part time.
  3. Sums the part time courses and reports according to the following table.

College Courses

Courses Rostered into
not flagged as evening  

Reports

4

0-4

0

3

1 or above

1

3

0

0

2

2 or above

2

2

Less than 2

The number of part time courses in which the student is enrolled.

1

3 or above

3

1

Below 3

The number of part time courses in which the student is enrolled.

0

4 or above

4

0

3 or below

The number of part time courses in which the student is enrolled.


Numeric, 1 digit

Course > Level

Course > Type > Evening

Opt-OutIndicates the student's legal guardian has chosen to opt-out of the release of directory information.

Alphanumeric, 1 character

Y or N

Student Information > General > Enrollments > State Reporting Fields > Opt-Out
Number of College Courses

The sum of unique courses into which the student is enrolled as of the extract editor End Date when the student is scheduled into a course marked as college (DE is selected in SCED Course Level) in the selected calendars).

  • The number must not be greater than 4. If there are more than 4, 4 reports.


Numeric, 1 digit

Scheduling > Courses > Course > SCED Course Level

Dual Enrollment

Indicates whether the student is taking both high school and college level courses and receiving credit in both.


Alphanumeric, 1 character

Y or N

Course > SCED Level > DE
Direct Certification

Indicates whether the student’s eligibility for the National School Lunch Program was determined through direct certification.

  • reports if the FRAM record's Source is Direct or the Migrant element reports Y.
  • Otherwise, N reports.


Alphanumeric, 1 character

Y or N

FRAM > Eligibility > Eligibility > Source
Pre-K Tier Status
Indicates the Pre-K tier that best identifies the student’s federal poverty level eligibility for State Financial Assistance. 
  • Calculated based on value from Federal Poverty Level
    • 0 – N/A 
    • 1 – Tier 1 - Federal Poverty Level is less than or equal to 300%.
    • 2– Tier 2 - Federal Poverty Level is more than 300% but not more than 600%.
    • 3– Tier 3 - Federal Poverty Level is more than 600%.
  • Report ‘0' when the Federal Poverty Level % cannot be calculated OR the student is not in State Grade Level 92-96 as of the report End Date in extract editor.


The Early Learning Program record must be active as of the Report End Date.
Student Information > Program Participation > Early Learning > Gross Income AND 
Number of People in 
Household

Federal Poverty LevelIndicates the percentage of Federal Poverty Level (FPL).
  • Calculated value:
    • Gross Income / 100% FPL for the # of Household Members x 100
    • Round to 3 digits before the decimal point.
    • Include leading zeros.
  • Report ‘000’ when FPL % cannot be calculated OR the student is not in State Grade Level 92-96 as of the report End Date in extract editor.
2022 Federal Poverty Guidelines
Household Members100% FPL
1$13,590
2$18,310
3$23,030
4$27,750
5$32,470
6$37,190
7$41,910
8$46,630
Each additional member+$4,720


The Early Learning Program record must be active as of the Report End Date.
Student Information > Program Participation > Early Learning > Gross Income AND 
Number of People in 
Household