WISEid Person Upload
This report creates the required file for the WISEid Upload for Students Process.
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 Criteria
Students are selected for this report by the following:
- The student must not be excluded from WISE Reporting.
- The student's entry date must be on or before the Student Enrollment End Date Specified.
- The student's exit date must be after the Student Enrollment Start Date Specified.
School Selection Criteria
- The school must not be excluded from State Reporting.
- The school must indicate its WISEdata Reporting Option:
- Public School All Students reported
- Private School Only Choice Students reported
- Private School All Students reported.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
|---|---|
Report Parameters | Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All. |
Select Schools | If you run the report at the district level, choose one of the following:
If you run the report at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
| Who to Include (Choice only or All) | Select the appropriate option for your school:
|
| Include Student Email | Select Yes or No to include student emails. |
| Student Enrollment Start Date | Enter the student enrollment start date. The student’s exit date must be after the Student Enrollment Start Date specified. |
| Student Enrollment End Date | Enter the student enrollment end date. The student’s entry date must be on or before the Student Enrollment End Date specified. |
| Current Selection of Students | Choose to use the current selection of students or All Students. |
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
The WISEid Upload for Students is a comma separated variable (.csv) file.
Item | Data Element | Description | [Table]FieldName | Field Length |
|---|---|---|---|---|
1 | WISEid | The student’s WISEid. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [Students]State_StudentNumber | 10 |
2 | Local Person ID | The PowerSchool student number. This value is extracted from the start page > select a student > Demographics. | [Students]Student_Number | 50 |
3 | Last Name | The student’s legal last name. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information or Demographics. Note: The last name can be populated by one of three fields, the order of the field used is: WISEdata Reported Last Name, if WISEdata Reported Last Name is blank than Legal Last Name, if Legal Last Name is blank then Preferred Last Name. | [S_STU_X]Pref_Last Else [StudentCoreFields]Pscore_Legal_Last_Name Else [Students]Last_Name | 50 |
4 | First Name | The student’s legal first name. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information or Demographics. Note: The first name can be populated by one of three fields, the order of the field used is: WISEdata Reported First Name, if WISEdata Reported First Name is blank than Legal First Name, if Legal First Name is blank then Preferred First Name. | [S_STU_X]Pref_First Else [StudentCoreFields]Pscore_Legal_First_Name Else [Students]First_Name | 50 |
5 | Middle Name | The student’s legal middle name. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information or Demographics. Note: The middle name can be populated by one of three fields, the order of the field used is: WISEdata Reported Middle Name, if WISEdata Reported Middle Name is blank than Legal Middle Name, if Legal Middle Name is blank then Preferred Middle Name. | [S_STU_X]Pref_Middle Else [StudentCoreFields]Pscore_Legal_Middle_Name Else [Students]Middle_Name | 50 |
6 | Suffix | The student’s legal suffix. (I, II, III, IV, Sr, Jr, SJ.) This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [S_WI_STU_WISE_X]Name_Suffix | 5 |
7 | Birthdate | The student’s date of birth. This value is extracted from the start page > select a student > Demographics. | [Students]DOB | 10 |
8 | Gender ID | The student’s gender. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information or Demographics. Valid values:
| [Students]Gender | 1 |
9 | Race Key | The student's Race/Ethnicity Code or Race Key: A code corresponding to the racial/ethnic group or groups with which the student identifies. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information or Demographics. | [Students]FedEthnicity and [StudentRace]Racecd(s) See https://dpi.wi.gov/sites/default/.../dpi_race_ethnicity_crosswalk.doc | 4 |
10 | Other Name Last Name | Former and/or other last names that the student may have had. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [S_WI_STU_WISE_X]Alias_Lname | 50 |
11 | Other Name First Name | Former and/or other first names that the student may have had. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [S_WI_STU_WISE_X]Alias_Fname | 50 |
12 | Other Name Middle Name | Former and/or other middle names that the student may have had. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [S_WI_STU_WISE_X]Alias_Mname | 50 |
13 | Other Name Suffix | Former and/or other name suffixes the student may have had. (I, II, III, IV, Sr, Jr, SJ.) This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [S_WI_STU_WISE_X]Alias_Suffix | 5 |
14 | Birth City | Optional, but recommended the student was born in the United States or Puerto Rico. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [S_WI_STU_WISE_X]Birth_City | 30 |
15 | Birth State | Optional, but recommended the student was born in the United States or Puerto Rico. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [S_WI_STU_WISE_X]Birth_State | 2 |
16 | Birth County | Optional, but recommended the student was born in the United States or Puerto Rico. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [S_WI_STU_WISE_X]Birth_County | 35 |
17 | Birth Country | Optional, but recommended the student was born outside the United States or Puerto Rico. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [S_WI_STU_X]Birth_Country | 60 |
18 | Entity ID | Not reported. | Null | |
19 | Local Person ID Key Type | “Student” is submitted | ‘Student’ | 7 |
| 20 | The student's email. Optional. | [PSM_StudentContact]Email | 50 | |
20 | Parent 1 Type | The type of parent/guardian. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. Valid values:
| [StudentCoreFields]Guardian | 1 |
21 | Parent 1 Last Name | The parent's last name. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [StudentCoreFields]Guardian_LN | 50 |
22 | Parent 1 First Name | The parent's first name. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [StudentCoreFields]Guardian_FN | 50 |
23 | Parent 1 Middle Name | The parent's middle name. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [StudentCoreFields] Guardian_MN | 50 |
24 | Parent 1 Name Suffix | The parent's name suffix. (I, II, III, IV, Sr, Jr, SJ.) This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | Null | |
25 | Parent 2 Type | The type of parent/guardian. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. Valid values:
| [S_WI_STU_WISE_X]Guardian2_rel | 1 |
26 | Parent 2 Last Name | The parent's last name. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [S_WI_STU_WISE_X]Guardian2_ln | 50 |
27 | Parent 2 First Name | The parent's first name. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [S_WI_STU_WISE_X]Guardian2_fn | 50 |
28 | Parent 2 Middle Name | The parent's middle name. This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [S_WI_STU_WISE_X]guardian2_mn | 50 |
29 | Parent 2 Name Suffix | The parent's name suffix. (I, II, III, IV, Sr, Jr, SJ.) This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | Null | |
| 30 | Multiple Birth Indicator | Indicates if a person was part of a set from the same birth (twins, triplets, quadruplets, quintuplets, sextuplets, septuplets, octuplets). This field is highly recommended as it will block auto-matching and prevent incorrect auto-matching of siblings with the same birth date and same or similar names. Valid values:
This value is extracted from the start page > select a student > State/Province - WI > Choice Students or WISEdata Student Information. | [S_WI_STU_WISE_X]Multiple_Birth_Status | 1 |