PowerSchool ERP Minnesota

Non-Licensed - File Layout and Data Mapping

The default file name for the Non-Licensed report is NA<district number><Report Date>.txt.

The following table shows the positions, field names, descriptions, and data sources or valid values for the Non-Licensed report.

Position

Field Name

Description

Data Sources or Valid Values

1-2

Record Type Indicator

A two-digit program code indicating the type of data being reported.

The valid value is NA.

3-6

Contracting District Number

The Minnesota Department of Education (MDE) district number of the employer.

The valid values are 0001 - 9999.

The value is retrieved from the MDE District Number field on the Human Resources Profile - State page.

7-8

Contracting District Type

The MDE district type of the employer.

The valid values are 01 - 99.

The value is retrieved from the MDE District Type field on the Human Resources Profile - State page.

9-11

School Number of Assignment

The school number provided by the state.

The value is retrieved from the Location field on the MN STAR Non-Licensed Employee Table Information form of the MN STAR - Non-Licensed Employee page.

12-20

Unique Identifier

The unique identifier number for the employee record.

The first four numbers of the unique identifier are the district number, and the last five can be any number.

Not applicable.

21-68

Staff Name

The employee’s name.

The format is last name, first name, middle name.

The value is retrieved from the Last Name, First Name, and Middle Name fields on the MN STAR Non-Licensed Employee Table Information form of the MN STAR - Non-Licensed Employee page.

69-69

Gender

The gender of the employee.

Valid values:

  • M - Male

  • F - Female

  • U - Undeclared

The value is retrieved from the Gender field on the MN STAR Non-Licensed Employee Table Information form of the MN STAR - Non-Licensed Employee page.

70-77

Birth Date

The date of birth of the employee.

The format is YYYYMMDD.

The value is retrieved from the Birth Date field on the MN STAR Non-Licensed Employee Table Information form of the MN STAR - Non-Licensed Employee page.

78-78

Race/Ethnicity

The race or ethnicity of the employee.

The valid value is 0.

79-80

Non-Licensed Staff Employment Status

The status code of a licensed or non-licensed staff.

Valid values:

  • 00 - Return From Previous Year

  • 20 - New Hire Non-Licensed

The value is retrieved from the Staff Employment Status field on the MN STAR Non-Licensed Employee Table Information form of the MN STAR - Non-Licensed Employee page.

81-86

Employee Classification

The six-digit employee classification number.

Not applicable

87-88

Hours Worked per Week

The number of hours worked per week.

The valid values are 01 - 60.

The value is retrieved from the Hours per Week field on the MN STAR Non-Licensed Employee Table Information form of the MN STAR - Non-Licensed Employee page.

89-90

Zero Fill

Fill with zeroes.

The valid value is 00.

91-91

Full-Time/Part-Time

Indicates whether the employee is employed full- or part-time.

Valid values:

  • F - Full Time

  • P - Part Time

The value is retrieved from the Full Time/Part Time field on the MN STAR Non-Licensed Employee Table Information form of the MN STAR - Non-Licensed Employee page.

92-101

District Use

Reserved for district use.

Not applicable

102-102

Hispanic

Indicates whether the employee’s race or ethnicity is Hispanic.

Valid values:

  • Y

  • N

The value is retrieved from the Hispanic field on the MN STAR Non-Licensed Employee Table Information form of the MN STAR - Non-Licensed Employee page.

103-103

American Indian or Alaskan Native

Indicates whether the employee’s race or ethnicity is American Indian or Alaskan Native.

Valid values:

  • Y

  • N

The value is retrieved from the American Indian or Alaskan Native field on the MN STAR Non-Licensed Employee Table Information form of the MN STAR - Non-Licensed Employee page.

104-104

Asian

Indicates whether the employee’s race or ethnicity is Asian.

Valid values:

  • Y

  • N

The value is retrieved from the Asian field on the MN STAR Non-Licensed Employee Table Information form of the MN STAR - Non-Licensed Employee page.

105-105

Native Hawaiian or Other Pacific Islander

Indicates whether the employee’s race or ethnicity is Hawaiian or Pacific Islander.

Valid values:

  • Y

  • N

The value is retrieved from the Hawaiian or Pacific Islander field on the MN STAR Non-Licensed Employee Table Information form of the MN STAR - Non-Licensed Employee page.

106-106

Black or African American

Indicates whether the employee’s race or ethnicity is Black or African American.

Valid values:

  • Y

  • N

The value is retrieved from the Black or African American field on the MN STAR Non-Licensed Employee Table Information form of the MN STAR - Non-Licensed Employee page.

107-107

White

Indicates whether the employee’s race or ethnicity is White.

Valid values:

  • Y

  • N

The value is retrieved from the White field on the MN STAR Non-Licensed Employee Table Information form of the MN STAR - Non-Licensed Employee page.

108-140

Filler

Leave blank

spaces