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.
|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.|
Note: Each school needs to have the Calendar Type populated.
|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