STAR LA File

Contents

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.

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.

Back to Top

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 "LA" 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	File Folder Number	File Folder Number from Start Page > Staff > Select a Staff Member > Information > STAR Information	[S_MN_USR_X]FILE_FOLDER	Numeric	7
5	Social Security Number	Report as all zeros		Numeric	9
6	Staff Name	Name from Start Page > Staff > Select a Staff Member > Information	[Users]LastFirst	Alpha	48
7	Gender	Gender from Start Page > Staff > Select a Staff Member > Information	[UsersCoreFields]Gender	Alpha	1
8	Birth Date	DOB from Start Page > Staff > Select a Staff Member > Information	[UsersCoreFields]DOB	Date Format YYYYMMDD	8
9	Race/Ethnicity	Reported as 0		Alpha	1
10	New Licensed Staff	New Licensed Staff from Start Page > Staff > Select a Staff Member > Information > STAR Information Click for a list of New Licensed Staff values.	[S_MN_USR_X]NEW_LIC_STAFF	Numeric	2
11	Inactive/Transfer/Termination	Inactive/Transfer/Termination from Start Page > Staff > Select a Staff Member > Information > STAR Information Click for a list of Inactive/Transfer/Termination codes.	[S_MN_USR_X]IN_TRA_TERM	Numeric	2
12	Contract Base Salary	Contract Base Salary from Start Page > Staff > Select a Staff Member > Information > STAR Information	[S_MN_USR_X]BASE_SALARY	Numeric	6
13	Highest Education Level	Highest Education Level from Start Page > Staff > Select a Staff Member > Information > STAR Information Click for a list of STAR Highest Education Level codes.	[S_MN_USR_X]High_Ed_Lvl	Numeric	2
14	Contract Days	Contract Days from Start Page > Staff > Select a Staff Member > Information > STAR Information. A maximum of 265 days	[S_MN_USR_X]CONTRACT_DAYS	Numeric	3
15	Years of Experience – Superintendent	Years of Experience – Superintendent from Start Page > Staff > Select a Staff Member > Information > STAR Information	[S_MN_USR_X]YOE_Superintendent	Numeric	2
16	Years of Experience – Principal	Years of Experience – Principal from Start Page > Staff > Select a Staff Member > Information > STAR Information	[S_MN_USR_X]YOE_Principal	Numeric	2
17	Years of Experience – Classroom Teacher	Years of Experience – Classroom Teacher from Start Page > Staff > Select a Staff Member > Information > STAR Information	[S_MN_USR_X]YOE_Teacher	Numeric	2
19	Years of Experience – Other	Years of Experience – Other from Start Page > Staff > Select a Staff Member > Information > STAR Information	[S_MN_USR_X]YOE_Other	Numeric	2
20	Out-of-District Assignment	Out-of-District Assignment from Start Page > Staff > Select a Staff Member > Information > STAR Information. Reported Values: Y – Yes N – No	[S_MN_USR_X]OUT_DST_ASSIGN	Alpha	1
21	Full Time/Part Time	Full Time/Part Time from Start Page > Staff > Select a Staff Member > Information > STAR Information. Reported Values: F - Full Time P - Part Time	[S_MN_USR_X]FULL_PART_TIME	Numeric	1
22	District Use	District Use from Start Page > Staff > Select a Staff Member > Information	[SchoolStaff]ID	Numeric	10
23	Hispanic	Full Time/Part Time from Start Page > Staff > Select a Staff Member > Information. Reported Values: Y – Yes N – No	[Users]FedEthnicity	Alpha	1
24	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
25	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
26	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
27	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
28	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
29	Filler			Alpha	17

Back to Top