STAR NA Extract (Human Resources) (Minnesota)

Tool Search: STAR NA

The STAR NA Extract collects data for all staff member in positions not requiring licensure by the State Board of Teaching or the Minnesota Board of School Administrators.

Screenshot of the STAR NA Extract Editor.

STAR NA Extract Editor


Report Logic

  • Reports all staff not requiring licensure employed in the district as of the Snapshot Date. 
  • A separate record reports for each employee classification and a separate record for each school per classification. 
  • District-wide staff report with a School Number of 000. 
  • Non-licensed staff who are contracted are not included in the report. 
  • Staff serving in multiple districts are only reported by the District of Employment. 
  • Active reportable employees without an active Work Assignment do report but with zero for Hours Worked Per Week.

In order for a record to report, the following must be true:

  • The Work Assignment must be active on the Snapshot Date entered in the Extract Editor. Multiple Work Assignments can be reported.
  • The Work Assignment must have a State Position Code/Title entered.
  • Work Assignment will report based on the assigned Work Location. Multiple Work Locations will report multiple records.
  • Staff that have at least one or more active Work Assignments where Human Resources > Administration > Position Code > STAR Extract = NA on the Snapshot Date of the extract editor report. Staff who only have Work Assignments marked as LA or Do not report are not included.
  • Staff can report on the LA and NA extract if they have one or more Work Assignments marked as LA and one or more Work Assignments marked as NA.
  • Fields reporting from the HR General Information section will report based on the most recent record prior to or on the Snapshot Date.

Generating the Extract

  1. Select STAR NA as the Extract Type.
  2. Enter a Snapshot Date in mmddyyyyformat or by clicking the calendar icon and selecting a date. Only data active as of this date will be included in the report.
  3. Enter a Previous Snapshot Date in mmddyyyy format or by clicking the calendar icon and selecting a date. This date indicates the last time the report was run.
  4. Select the Format in which the report should generate. Use State Format (Fixed Width) for submission to the state and CSV or HTML for data review and verification.
  5. Click Generate Extract to view the report in the selected format.

Extract Layout

Element Name

Description

Location

Record Type Indicator

The record type. Reports as "NA."


Alphanumeric, 2 characters

Not dynamically stored

Contracting District Number

The identification number of the reporting school district.


Numeric, 4 digits

System Administration > Resources > District Information > Number


District.number

Contracting District Type

The type of school district submitting the report.


Numeric, 2 digits

System Administration > Resources > District Information > Type


District.type

School Number of Assignment

The identification number of the reporting school.


Numeric, 3 digits

System Administration > Resources > School > Number


School.number

Unique Identifier

The staff person's District Number and Personnel Number.


Numeric, 9 digits

System Administration > Resources > District Information > State District Number


and


Human Resources > Personnel > Personnel Master > HR General Information > Personnel Number



Person.staffNumber

Staff Name

The name of the staff member.


Alphanumeric, 48 characters

Human Resources > Personnel > Personnel Master > HR General Information > Last Name, First Name, Middle Name


Identity.lastName
Identity.firstName
Identity.middleName

Gender

Identification of the individual as (M)ale or (F)emale.


Alphanumeric, 1 character

Human Resources > Personnel > Personnel Master > HR General Information > Gender


Identity.gender

Birth Date

The date of birth of the individual.


Date field, 8 digits
YYYYMMDD

Human Resources > Personnel > Personnel Master > HR General Information > Birth Date


Identity.birthDate

Race Ethnicity

The State Race/Ethnicity code of the individual. See the following Race/Ethnicity Options table for values.


Numeric, 1 digit

Human Resources > Personnel > Personnel Master > HR General Information > Race/Ethnicity


Identity.raceEthnicity

Non Licensed Staff Employment Status

Indicates the employment status of staff members in positions no requiring licensure, hired since the last report date. Reports Hiring Status if Hire Date is between the Previous Snapshot Date and the Snapshot Date. Otherwise, reports as 00.


Numeric, 2 digits

Human Resources > Personnel > Personnel Master > HR General Information > Hiring Status, Hire Date


Employment.hireStatus

Employment.startDate

Employment Classification

Identifies the general occupation of the employee. Values are set by the district.


Numeric, 6 digits

Human Resources > Personnel > Personnel Master > Work Assignments > Assignment Code


EmploymentAssignment.
assignmentCode

Hours Worked Per Week

The typical number of hours the non-licensed staff member works per week, not including overtime.


Campus calculates the value by multiplying Hours Per Day x Days Per Week.
  1. Campus first looks at the most current Wage Detail Record. 
  2. If the Wage Detail Record is blank or NULL, Campus uses values from Employee Payroll Information and Position Override.
  3. If Employee Payroll Information and Position Override are blank or NULL, then
    • When only one Work Location exists 
      • From the Wage Detail FTE,
        Campus multiplies the value by 40.
        (The state defines a 1.0 FTE as 40 hours per week.)
      • If the Wage Detail FTE is blank or NULL, then, Campus uses the Work Assignment > Payroll Information and Position Override > Position FTE and multiplies the value by 40. This value is reported.
    • When multiple Work Locations exist
      • and the Percent > 0, Campus multiplies the decimal equivalent by 40.
      • and the Percent is blank or NULL,  the value is disregarded.
  4. When multiple Work Assignments exist and multiple Assignment Codes exist but only one work location exists, Campus reports the  corresponding values for each Assignment Code.
  5. When multiple Work Assignments exist with only one Assignment Code and one work location, Campus reports a summed value.
  6. When multiple Work Assignments, multiple Assignment Codes and multiple Work Locations exist, Campus calculates and reports values for each Assignment Code and Work Location, appropriately prorated.


Numeric, 2 digits

Human Resources > Personnel > Personnel Master > Work Assignments > current Wage Detail Record > Hours Per Day, Days Per Week


Human Resources > Personnel > Personnel Master > Work Assignment > current Wage Detail Record > FTE


OR


Human Resources > Personnel > Personnel Master > Work Assignment > Payroll Information and Position Override > Position FTE


OR


Human Resources > Personnel > Personnel Master > Work Assignment > Work Locations > Percent

ZeroFill

Reports as 00.

 

Full Time/Part Time

Indicates whether the employee in a position not requiring licensure is employed on a full-time or part-time basis. 

Indicates the employee's FTE.

Full-Time F is >=.8 FTE. Otherwise, P reports.


Alphanumeric, 1 character

Human Resources > Personnel > Personnel Master > Work Assignments > Wage Detail > FTE


OR


Human Resources > Personnel > Personnel Master > Work Assignments > Position FTE

District Use

Reports Personnel Number for district use. Not required by the state.


Numeric, 10 digits

Human Resources > Personnel > Personnel Master > HR General Information > Personnel Number


Person.staffNumber

Hispanic

Indicates if the individual is of Hispanic/Latino origin.


Alphanumeric, 1 character
Y or N

Human Resources > Personnel > Personnel Master > HR General Information > Hispanic/Latino?


Identity.hispanicEthnicity

American Indian or Alaska Native

Indicates if the individual is of American Indian or Alaska Native origin.


Alphanumeric, 1 character
Y or N

Human Resources > Personnel > Personnel Master > HR General Information > American Indian or Alaska Native


Identity.raceEthnicity

Asian

Indicates if the individual is of Asian origin.


Alphanumeric, 1 character
Y or N

Human Resources > Personnel > Personnel Master > HR General Information > Asian


Identity.raceEthnicity

Native Hawaiian or Other Pacific Islander

Indicates if the individual is of Native Hawaiian or Other Pacific Islander origin.


Alphanumeric, 1 character
Y or N

Human Resources > Personnel > Personnel Master > HR General Information > Native Hawaiian or Other Pacific Islander


Identity.raceEthnicity

Black or African American

Indicates if the individual is of Black or African American origin.


Alphanumeric, 1 character
Y or N

Human Resources > Personnel > Personnel Master > HR General Information > Black or African American


Identity.raceEthnicity

White

Indicates if the individual is of White origin.


Alphanumeric, 1 character
Y or N

Human Resources > Personnel > Personnel Master > HR General Information > White


Identity.raceEthnicity

Filler

 

 

Race/Ethnicity Options

Code

Description

1

American Indian or Alaskan Native

2

Asian or Pacific Islander

3

Hispanic

4

Black, not Hispanic

5

White, not Hispanic