The information used to generate the SIF aggregates comes from different fields.  The following is a list of the fields processed and how they are used.


Table
 Field
 Description 
STU 
GR 
Student Grade should be populated.

SP 
Student Attendance Program meaning “Secondary Enrollment” for students with concurrent enrollments should be used.

TG 
Inactive Status Tags can be identified for the system to skip.  Only codes like “*” should normally be marked on the form as being skipped.

LD 
Leave Date should be populated for any student with a Summer Withdrawal Reason.  This date is used to determine if the student should be counted in this CBEDS count. If this field is empty, it will look at STU.DG

CID 
State ID should be populated for all students. This field is used to track students across schools so that a student is only counted once in this CBEDS count.

ID 
Permanent ID number must be populated for each student.  This field is used to track students across schools so that a student is only counted once in this CBEDS count.

SX 
Student Sex is used in various CBEDS counts.

HS 
CSIS Home School field can be used to identify students in a certain school who should actually be counted in a different school.  Do not use this field for concurrent enrollments, only for students in an Independent Study school or something similar.

SWR
Used if populated


ATT 
DT 
Attendance Enrollment is very important to be populated.  This information helps the system determine who to count on CBEDS day and other aggregates.

GR 
Grade Level in Attendance Enrollment should accurately indicate which grade level the student should be counted.

RS 
Exit Reasons are critical to the system to determine Dropouts and Mid-Year Graduates.  All Attendance Enrollment Leave Records need to have an Exit Reason.


ENR
All
Enrollment History table is used to determine the most recent enrollment for a student.  This data must be up-to-date and accurate.


Educational Calendar


DAY
 
The Calendar (DAY table) is used to determine the school’s start and end dates.


LOC
SCT
 
School Calendar Type needs to be populated on the School Information page in the Calendar Type field.  The School Information page is under School Info in the navigation.  Each school needs to have the Calendar Type populated.



Parental Exception Waiver from English-Language Classrooms


AUT 
DT 
Authorization date is used to determine if the waiver is between the valid date range of 10/06/2016 -06/30/2017.
Use the Authorizations page under Student Data, Other in the navigation.

TY 
This field is used to determine the authorization type. The extract will use only TY = “3”

ST
The extract uses this field to determine the status of the waiver (requested or granted)



Classified Staff


STF 
PSC 
Primary School needs to be identified for each Staff record so the system knows which school to count this employee in.

ID 
Every Staff member needs a unique District Staff ID Number.

HD 
Hire Date is needed to determine who was employed on CBEDS day.

LD 
Leave Date should be populated for all employees who are no longer working for the district.

TG 
Employment Status Tag should be populated for all employees who stopped working prior to CBEDS day.

SX 
Sex of the Staff member is important for SIF aggregates.

ETH & RC1-5 
Staff Ethnicity Flag and Race Code are necessary for various aggregates. If ETH and RC1 are not populated, then the Staff will be extracted as "Two or More Races."


STA 
PT
Staff Assignments - % Time for Each Staff Assignment needs to be populated for all Classified Assignments to determine full time or part time status.  Only records with a value greater than zero will be counted by the system. Anything greater than 96 will be considered full time and any value over 106 will be considered “Over 100”.

JC
Staff Assignments Job Classification needs to be populated for every Classified Assignment.  The following are the codes used for the various SIF aggregates:
• Paraprofessional – 23, 42, 52
• Office/Clerical – 19, 44, 53, 58
• Other – 24, 43, 45, 54, 55, 57, 59