Skip to main content
Skip table of contents

MI Request for UIC

Introduction

This will create the MI Request for UIC export file. Use this to obtain or validate Unique Identification Codes (UICs) for students.

Refer to the following link for additional information on the Request for UIC Collection: http://www.mi.gov/cepi/0,1607,7-113-986_50502_52376---,00.html

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.

Student Selection

Student records are selected based on the following criteria:

  • The student is included in state reporting. ([Students]State_ExcludeFromReporting=0)

  • The student's school is included in state reporting. ([Schools]State_ExcludeFromReporting=0)

  • The student's exit date is greater than the Previous Count Date entered in the report parameters.([Students]ExitDate>Previous Count Date)

  • The student does not have the same date selected for the Entry Date and Exit Date.

  • If selecting the option to run for only Students Without UICs, then the Michigan Unique Identification Code must be blank.([Students]State_StudentNumber= )

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Current Selection Students

Select whether to run the export file for the selected number of students or for all students.

Entity Type Code

Select the entity type code.

Entity Code

Enter the entity code.

Reporting District's State Assigned 5-digit District Number

Enter the reporting district's state assigned 5-digit district number.

First Day of School

Enter the date of the first day of school.

Previous Count Date

Enter the previous count date.

Current Count Date

Enter the current count date.

Select schools to export.

Select which schools to export if applicable.

Run For

Select whether to run for students without a UIC or for all students.

Schema Version Minor

Enter the schema version minor. This parameter is pre-filled with the latest known correct schema version minor value from the state. Only change this value if necessary.

Schema Version Major

Enter the schema version major. This parameter is pre-filled with the latest known correct schema version major value from the state. Only change this value if necessary.

Collection ID

Enter the collection ID. This parameter is pre-filled with the latest known correct collection ID value from the state. Only change this value if necessary.

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.

Item #

Data Element

Description

[Table]FieldName

<SubmittingEntity>

1

<SubmittingEntityTypeCode>

This contains the submitting entity type code value selected on the report interface.

N/A

2

<SubmittingEntityCode>

This contains the submitting entity code value entered on the report interface.

N/A

<PersonalCore>

3

<UIC>

This contains the student's Unique Identification Code (UIC).

[Students]State_StudentNumber

4

<LastName>

This contains the student's last name.

[Students]Last_Name

5

<FirstName>

This contains the student's first name.

[Students]First_Name

6

<MiddleName>

This contains the student's middle name.

[Students]Middle_Name

7

<StudentSuffix>

This contains the student's suffix.

[S_MI_STU_GC_X]stuNameSuffix

8

<DateOfBirth>

This contains the student's date of birth.

[Students]DOB

9

<MultipleBirthOrder>

This identifies the birth order of the student if the student is part of a multiple birth.

[S_MI_STU_GC_X]multipleBirth

10

<Gender>

This contains the student's gender code.

Note: If the student's preferred gender is not M or F, the legal gender is reported.

[Students]Gender

[STUDENTCOREFIELDS]PSCore_Legal_Gender

<SchoolDemographics>

11

<OperatingDistrictNumber>

This contains the operating district number value entered on the report interface.

N/A

12

<SchoolFacilityNumber>

This contains the school or facility number for the student's school.

If the student’s MSDS School Facility Number Override field is populated, the report displays the value of this field as school facility number.

[S_MI_SCH_TSDL_X]adminUnit

[S_MI_STU_GC_X]adminUnit

[S_MI_REN_GC_X]adminUnit

13

<StudentIdNumber>

This contains the PowerSchool student ID number.

[Students]Student_Number

14

<GradeOrSetting>

This contains the grade level in which the student is enrolled.

[Students]Grade_Level

[ReEnrollments]Grade_Level

[S_MI_STU_GC_X]educSetting

15

<S2E2Code>

This contains the school or relationship code (Educational Entity Master S2E2 code) for the student.

[S_MI_STU_GC_X]S2E2code

16

<BldgOtherwiseAttend>

This is the five-digit code that represents the school or facility building where the student would otherwise attend as specified in Sec. 104b (16).

[S_MI_STU_GC_X]bldgOtherwiseAttend

<PersonalDemographics>

17

<ResidentLEANumber>

This contains the student's resident LEA number.

[S_MI_STU_GC_X]residentLEA

18

<StudentResidentCounty>

This contains the student's resident county code.

[S_MI_STU_GC_X]residentCounty

19

<Ethnicity>

This contains the student's ethnicity.

[S_MI_STU_GC_X]ethnicIndian

[S_MI_STU_GC_X]ethnicAsian

[S_MI_STU_GC_X]ethnicBlack

[S_MI_STU_GC_X]ethnicPacific

[S_MI_STU_GC_X]ethnicWhite

[S_MI_STU_GC_X]ethnicHispanic

<Contacts>

20

<AddressTypeDescriptor>

This contains the type of address being reported.

[S_MI_STU_GC_X]AddressType_Physical

[S_MI_STU_GC_X]AddressType_Mailing

[S_MI_STU_GC_X]AddressType_Override

[S_MI_STU_GC_X]AddressType_Additional

21

<StreetNumberName>

This contains the number and name of the location of the address for the reported Address Type

[Students]street

[Students]mailing_street

[S_MI_STU_GC_X]pdStreetAddress

[S_MI_STU_GC_X]eoParentAddr1

22

<ApartmentRoomSuiteNumber>

This contains the additional street address information such as apartment, room, suite or lot number that refers to the reported Address Type.

[S_MI_STU_GC_X]pdStreetAddress2

[S_MI_STU_GC_X]eoParentAddr2

23

<City>

This contains the name of the city or town where the address is located.

[Students]city

[Students]mailing_city

[S_MI_STU_GC_X]pdCity

[S_MI_STU_GC_X]eoParentCity

24

<StateAbbreviationDescriptor>

This contains the abbreviation for the state (within the United States) or outlying area in which the address is located.

[Students]state

[Students]mailing_state

[S_MI_STU_GC_X]pdState

[S_MI_STU_GC_X]eoParentState

25

<PostalCode>

This contains the five- or nine-digit ZIP code of the location where the address is located.

[Students]zip

[Students]mailing_zip

[S_MI_STU_GC_X]pdZipCode

[S_MI_STU_GC_X]eoParentZip

26

<TelephoneNumber>

This contains the primary telephone number given by the student’s parent or guardian.

[Students]HomePhone

[S_MI_STU_GC_X]eoParentPhone

<Enrollment>

27

<EnrollmentDate>

This contains the student's entry date.

[Students]EntryDate

28

<ExitStatus>

This contains the student's exit code.

[Students]ExitCode

29

<ExitDate>

This contains the student's exit date.

[Students]ExitDate

30

<addGradAward>

This contains the student's additional graduation award.

[S_MI_STU_GC_X]addGradAward

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.