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. |
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. |
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 "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. | [Prefs]DISTRICTNUMBER | Numeric | 4 |
3 | Contracting District Type | District Type from MDE-Org | [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 | 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 | [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 | [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. | [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. | [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 | 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 | Alpha | 1 |
26 | Native Hawaiian or Other Pacific Islander | Full Time/Part Time from Start Page > Staff > Select a Staff Member > Information | [TeacherRace]RaceCD | Alpha | 1 |
27 | Black or African American | Full Time/Part Time from Start Page > Staff > Select a Staff Member > Information | [TeacherRace]RaceCD | Alpha | 1 |
28 | White | Full Time/Part Time from Start Page > Staff > Select a Staff Member > Information | [TeacherRace]RaceCD | Alpha | 1 |
29 | Hire or Return from Leave Date | Beginning with the 2023-2024 school year, the LA Files will contain a list of all staff who were employed for a position requiring a PELSB license in your district or charter school since the previous report (October 1 of the previous year). Start Page > Staff > Select a Staff Member > Staff Profile > STAR Information. | [S_MN_USR_X]HireReturnfromLeaveDate | Date (YYYYMM) | 6 |
30 | Termination or Leave Effective Date | Beginning with the 2023-2024 school year, the LA Files will contain a list of all staff who were employed for a position requiring a PELSB license in your district or charter school since the previous report (October 1 of the previous year). Start Page > Staff > Select a Staff Member > Staff Profile > STAR Information. | [S_MN_USR_X]TerminationEffectiveDa | Date (YYYYMM) | 6 |
31 | Filler | Alpha | 17 |