STAR NA File

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
The report selects records based on the following criteria:

Staff members have Include in STAR LA File selected from the start page > Staff > Select a Staff Member > Information > STAR Information.
The Staff member must also have a Licensed Staff Assignments (LB) entry from start page > Staff > Select a Staff Member > Information > STAR Information > Licensed Staff Assignments (LB).
A Staff member will have one record for every Licensed Staff Assignments (LB) entry for a particular staff member.

Report Input

For help with report navigation and generation, see How to Find and Generate a Report.

Field	Description
Report Parameters	There are no Report Parameters for this report.
Processing Options	Use the pull-down menu to select a processing option. The default option is In Background Now. The option to override is available for this report. Use the options to indicate when you want the report to generate. Execute Now In Background Now ASAP At Night On Weekend On Specific Time
Specific Date/Time	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2017 @ 10 AM: 05.
Submit	Click Submit to run the report.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

The MCCC Staff Extract is a XML file.

Item	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	Record Type Indicator	File Identification Code	Set to "NA" by the report	Alpha	2
2	Contracting District Number	The Org Unit ID number of a district. This will be District Number from PowerSchool. From the District Office > District > District Info	[Prefs]DISTRICTNUMBER	Numeric	4
3	Contracting District Type	District Type from MDE-Org From the District Office > District > District Info.	[Prefs]DISTRICTTYPE	Numeric	2
4	School Number of Assignment	School Number of this Assignment from Start Page > Staff > Select a Staff Member > Information > STAR Information > Non-Licensed Staff Assignments (NA)	[MN_NonLicAssign]Schoolid	Numeric	3
5	Social Security Number	SSN from Start Page > Staff > Select a Staff Member > Information	[Teachers]SSN	Numeric	9
6	Staff Name	Name from Start Page > Staff > Select a Staff Member > Information	[Teachers]LastFirst	Alpha	48
7	Gender	Gender from Start Page > Staff > Select a Staff Member > Information	[Teachers]Gender	Alpha	1
8	Birth Date	DOB from Start Page > Staff > Select a Staff Member > Information Format: YYYYMMDD	[Teachers]DOB	Date	8
9	Race/Ethnicity	DOB from Start Page > Staff > Select a Staff Member > Information Reported Values: A – Asian B – African-America C – Caucasian I – American Indian H – Hispanic or Latino P – Pacific Islander	[Teachers]Ethnicity	Alpha	1
10	New Non-Licensed Staff	New Licensed Staff from Start Page > Staff > Select a Staff Member > Information > STAR Information > Non-Licensed Staff Assignments (NA) Reported Values: 00 – Default 20 – New Hire	[S_MN_SSF_NONLICASSIGN_C]New_Non_Lic_Staff	Numeric	2
11	Employee Classification	Six-digit code used to identify the general occupation of the employee from Start Page > Staff > Select a Staff Member > Information > STAR Information > Non-Licensed Staff Assignments (NA) See the Non-Licensed Classification Codes found in the STAR Manual: Section B.	[S_MN_SSF_NONLICASSIGN_C]Emp_Class	Numeric	6
12	Hours Worked per Week	Hours Worked per Week from Start Page > Staff > Select a Staff Member > Information > STAR Information > Non-Licensed Staff Assignments (NA)	[S_MN_SSF_NONLICASSIGN_C]Hrs_Per_Week	Numeric	2
13	Zero Fill	Set to "00" by the report		Numeric	2
14	Full Time/Part Time	Full Time/Part Time from Start Page > Staff > Select a Staff Member > Information > STAR Information > Non-Licensed Staff Assignments (NA) Reported Values: F - Full Time P - Part Time	[S_MN_SSF_NONLICASSIGN_C]Full_Part_Time	Numeric	2
15	District Use	District Use from Start Page > Staff > Select a Staff Member > Information	[Teachers]ID	Numeric	10
16	Hispanic	Full Time/Part Time from Start Page > Staff > Select a Staff Member > Information Reported Values: Y – Yes N – No	[Teachers]FedEthnicity	Alpha	1
17	American Indian or Alaskan Native	Full Time/Part Time from Start Page > Staff > Select a Staff Member > Information Reported Values: Y – Yes N – No	[TeacherRace]RaceCD If RaceCd = I	Alpha	1
18	Asian	Full Time/Part Time from Start Page > Staff > Select a Staff Member > Information Reported Values: Y – Yes N – No	[TeacherRace]RaceCD If RaceCd = A	Alpha	1
19	Native Hawaiian or Other Pacific Islander	Full Time/Part Time from Start Page > Staff > Select a Staff Member > Information Reported Values: Y – Yes N – No	[TeacherRace]RaceCD If RaceCd = P	Alpha	1
20	Black or African American	Full Time/Part Time from Start Page > Staff > Select a Staff Member > Information Reported Values: Y – Yes N – No	[TeacherRace]RaceCD If RaceCd = B	Alpha	1
21	White	Full Time/Part Time from Start Page > Staff > Select a Staff Member > Information Reported Values: Y – Yes N – No	[TeacherRace]RaceCD If RaceCd = W	Alpha	1
22	Filler			Alpha	33