Direct Admit Report to State | PowerSchool SIS Compliance

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: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. 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