Direct Admit Report to State
This creates the Direct Admit .csv file that is uploaded to the Universities of Wisconsin.
Selection Criteria
How Students are selected for this report:
The school has opted in for Direct Admission and has been approved by the Universities of Wisconsin.
The student has an active enrollment during the specified date range.
The student's legal name and gender are entered in PowerSchool, select a student > Compliance > WISEid Student Information or WISEdata Choice Student Information pages for more information.
The student has a FERPA Consent date (select a student > Compliance > Direct Admission Reporting).
The student is identified to be submitted for Direct Admission.
If a override gpa is specified, an override tier should be specified and vice versa.
All students have been verified using the Student Academic Review for Direct Admit.
Additional Criteria
Only Schools with students in grade 12 may be selected.
If running prior the District having completed the Year End Process use the option - Run for Current Grade 11, (running before EOY process).
Report Input
Field | Description |
|---|---|
Academic Year (Year of Graduation) | Select the academic year. This will be the year that the student is a senior. |
Select School | Select the school to run the report. |
Select Students | Indicate which students to include in the report by selecting one of the following options:
If you run the report for a single student or a group of students, select the students prior to running the report. |
Enrollment Entry Date | Enter the enrollment entry date for the students you wish to report. |
Enrollment Exit Date | Enter the enrollment exit date for the students you wish to report. |
Run for Current Grade 11, (running before EOY process) | Select Yes or No. |
SFTP connections | Select SFTP connection. |
Report Output
Item | Data Element | Description | Table[Field Name] |
|---|---|---|---|
A | District Name | Indicates the District Name. | [Prefs]where Name='districtname' |
B | DPI District Code | Indicates the DPI district code. | [Prefs]where Number='districtnumber' |
C | High School Name | Indicates the High School name. | [Schools]Name |
D | DPI School Code | Indicates the DPI school code. | [Schools]Alternate_School_Number if > 0 ELSE schools.School_Number |
E | Student First Name | The student’s first name. | [PSCore]Legal_First_Name ELSE [Students]First_Name |
F | Student Middle Name | The student’s middle name. | [PSCore]Legal_Middle_Name ELSE [Students]Middle_Name |
G | Student Last Name | The student’s last name. | [PSCore]Legal_Last_Name ELSE [Students]Last_Name |
H | WISEid | The student’s WISEid. | [Students]State_StudentNumber |
I | Date of Birth | The student's date of birth in MM/DD/YYYY format. | [Students]DOB |
J | Local Student District ID | The student number. | [Students]student_number |
K | Graduation Year | Indicates the student’s graduation year. | [Students]Sched_YearOfGraduation |
L | Street Address | Indicates the students street address. | [Students]Street |
M | City | Indicates the students city. | [Students]City |
N | State | Indicates the students state. | [Students]State |
O | Zip Code | Indicates the students zip. | [Students]Zip |
P | Email Address | Indicates the students email address. | PowerSchool_Data_Sets.Student_Email |
Q | Tier Calculated | Indicates the student’s calculated tier. | [S_STU_DirectAdmit_X]da.Override_Tier if >= '1' ELSE S_STU_DirectAdmit_X.Stored_Tier |
R | GPA | Indicates the student’s GPA. | [S_STU_DirectAdmit_X]Override_GPA if >= 0 ELSE S_STU_DirectAdmit_X.Stored_GPA |
S | Legal Sex | Indicates the student’s legal gender. | [PSCore]Legal_Gender ELSE [Students]Gender |
T | Race Ethnicity | Indicates the student race. | [Students]fedethnicity = 1 then 1 studentrace where racecd LIKE I then 2 studentrace where racecd LIKE A then 3 studentrace where racecd LIKE B then 4 studentrace where racecd LIKE P then 5 studentrace where racecd LIKE W then 6 If studentrace has multiple race codes selected then 7 |