Licensed Assignment - File Layout and Data Mapping

The default file name for the Licensed Assignment report is LA<district number><Report Date>.txt.

The following table shows the positions, field names, descriptions, and data sources or valid values for the Licensed Assignment 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 LA.
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-15	File Folder Number	The demographic file folder number.	The valid values are 0000000 - 9999999. The value is retrieved from the File Folder Number field in the Demographic section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
16-24	Social Security Number	The employee’s social security number.	The valid value is 000000000.
25-72	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 in the Demographic section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
73-73	Gender	The gender of the employee.	Valid values: M - Male F - Female U - Undeclared The value is retrieved from the Gender field in the Demographic section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
74-81	Birth Date	The date of birth of the employee. The format is YYYYMMDD.	The value is retrieved from the Birth Date field in the Demographic section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
82-82	Race/Ethnicity	The race or ethnicity of the employee.	The valid value is 0.
83-84	Employment Status	The status code of a licensed or non-licensed staff.	Valid values: 00 - Return From Previous Year 01 - Newly Licensed MN Grad 02 - Return After Break In SRV 03 - Transfer - MN Pub. School 04 - Transfer - Non-MN Public 05 - New Licensed Non-MN Grad 06 - Long-Term Sub In State 07 = Employed less than one year can be used for an employee hired after October 1 of the previous year who did not return this year. This should only be used if the person's employment status is unknown or uncertain. 08 = Transferred from a Non-Licensed position to a Licensed assignment. 19 = Missed employment on the last report will be used if you have a staff member who was employed the previous year before October 1 and is returning the current year but was not reported on the last report’s employment. The value is retrieved from the Employment Status field in the Employment section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
85-86	Inactive/Transfer/Termination Status	The employee's inactive, termination, or transfer status code.	Valid values: 00 = default value indicating the staff is NOT inactive 21 = Maternity/ Paternity/ Adoption 22 = Illness 23 = Personal Obligations/ Other 24 = Travel 25 = Professional Growth 26 = Military Service 28 = Extended Leave/ Alternative Career Exploration/ Sabbatical 29 = Employed, but has no assignment at the time of reporting 30 = Intra-district transfer from a license position to a non-licensed position 46 = Staff Reduction 47 = Personal Reasons 49 = Retirement 50 = Death 51 = Educator in another district 52 = Educator in another state or outside of the United States 54 = Other Educational Occupation 57 = Not offered reemployment for reasons other than staff reduction 59 = Long-Term substitute (use only if the individual was reported as employed on the previous submission) 60 = Unknown/ Other The value is retrieved from the Inactive Status field in the Employment section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
87-92	Contract Salary	The contract base salary override amount.	The valid values are 000000 - 999999. The value is retrieved from the Contract Base Salary field in the Employment section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
93-94	Highest Education Level	The highest education attained by the employee.	The value is retrieved from the Highest Education Level field in the Employment section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
95-97	Contract Days	The total number of contract days.	The valid values are 000 - 265. The value is retrieved from the Contract Days field in the Employment section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
98-99	Years of Experience – Superintendent	The years of experience as a superintendent.	The valid values are 00 - 99. The value is retrieved from the Years of Experience - Superintendent field in the Employment section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
100-101	Years of Experience – Principal		The valid values are 00 - 99. The value is retrieved from the Years of Experience - Principal field in the Employment section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
102-103	Years of Experience – Classroom Teacher		The valid values are 00 - 99. The value is retrieved from the Years of Experience - Classroom Teacher field in the Employment section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
104-105	Years of Experience – Other		The valid values are 00 - 99. The value is retrieved from the Years of Experience - Other field in the Employment section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
106-106	Out-of-District Assignment	Indicates whether the employee provides licensed service in other districts.	Valid values: Y N The value is retrieved from the Out of District Assignment field in the Employment section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
107-107	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 in the Employment section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
108-117	District Use	Reserved for district use.	Not applicable
118-118	Hispanic	Indicates whether the employee’s race or ethnicity is Hispanic.	Valid values: Y N The value is retrieved from the Hispanic field in the Demographic section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
119-119	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 in the Demographic section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
120-120	Asian	Indicates whether the employee’s race or ethnicity is Asian.	Valid values: Y N The value is retrieved from the Asian field in the Demographic section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
121-121	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 in the Demographic section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
122-122	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 in the Demographic section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
123-123	White	Indicates whether the employee’s race or ethnicity is White.	Valid values: Y N The value is retrieved from the White field in the Demographic section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
124-129	Hire Date	The hire date of the employee. The format is YYYYMM.	The value is retrieved from the Hire Date field in the Employment section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
130-135	Termination Date	The termination date of the employee. The format is YYYYMM.	The value is retrieved from the Termination Date field in the Employment section of the General Information tab of the MN STAR Employee Table Information form on the MN STAR Staff Reporting page.
136-140	Filler	Leave blank	spaces