TN Drivers Permit Form | PowerSchool SIS Compliance

Introduction

This report generates the Tennessee Driver’s Permit Form (Certificate of Compulsory school Attendance Compliance) for student applying for a driver’s license or permit. This report can run at the school or district level. When run from the district, the report can run for one, multiple, or all schools.

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

The students selected on the home page are included in the report provided the student count is a minimum of 1 and a maximum of 100.

Report Setup

Steps to Add School Logo to the Report Output

Districts need to perform the following steps to upload school logos using the Manage Custom Pages SIS core functionality. This is a onetime activity for each school.

Navigate to System Management, Customizations, Manage Custom Pages.
On Manage Custom Pages, browse to the following path:
reporting, State, Images, SchoolLogo.
Right‑click on the SchoolLogo folder, select Upload, and upload the school logo file.

Ensure that the file size is below 50 KB.
The file format is PNG, JPG, or JPEG.

Confirm that the logo has been uploaded successfully to the SchoolLogo folder.

Select the Logo on the School Info Page

Navigate to District Management, District Setup, School Info.
For the Upload School Logo for Driver’s Permit Form field, select the uploaded logo from the drop-down list.
Click Submit to save the changes.

Note: If the file appears disabled or cannot be selected from the drop-down list, either the file is more than 50 KB, or the file format is not supported.

Navigation: Start Page, Data and Reporting, Reports, Compliance Reports, Tennessee Miscellaneous Reports - TN Drivers Permit Form.

Report Input

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

Field

Description

Students to Include*

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 that meet the selection criteria. If running the report for a single student, or a group of students, select the students prior to running report.

Note: To run the report successfully, ensure that the number of students selected is not more than 100. This limit applies to running the report both at school and district levels. As a minimum, one student must be selected to run the report.

Form Date

The date that needs to appear on the form.

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.

Data Element	Mapping from SIS Core	[Table]FieldName	Business Logic
Student	Yes	[StudentCoreFields] PSCore_Legal_First_Name, PSCore_Legal_Middle_Name, PSCore_Legal_Last_Name	Legal Name (Concatenate First Name and Middle Name and Last Name)
Gender	Yes	[StudentCoreFields]PSCore_Legal_Gender	Legal Gender
Grade/Graduation Year	Yes	[StudentCoreFields]Graduation_Year	Both Grade Level and Graduation Year are displayed.
Other ID	Yes	[Students]State_StudentNumber	State Student Number
Address	Yes	[Schools]Name [Schools]SchoolAddress [Schools]SchoolCity [Schools]SchoolZip [Schools]SchoolState	Concatenate School Name, School Address, School City, School State/Province and School Postal /Zip Code.
School Logo	Yes	[S_TN_SCH_X]School_Logo_Asset_Id	The logo of the corresponding school. The logo selected for the Upload School logo for Driver’s Permit Form field appears on the output PDF.
Phone (On the right side of the logo)	Yes	[Schools]SchoolPhone	School Phone Number
School #	Yes	[Schools]School_Number	School Number
County	Yes	[Schools]CountyName	School County Name
Student Name	Yes	[StudentCoreFields] PSCore_Legal_First_Name, PSCore_Legal_Middle_Name, PSCore_Legal_Last_Name	Legal Name (Concatenate First Name, Middle Name, and Last Name)
Date of Birth	Yes	[Students]DOB	DOB
Age	Yes	Derived from [Students]DOB	Age
Race	Yes	[Students]Ethnicity	Scheduling/Reporting Ethnicity
Gender	Yes	[Students]Gender	Gender
Driver License Status	No	NA	Default Value: Approved
Street Address	Yes	[Students]Street [Students]Mailing_Street [Students]City [Students]Mailing_City [Students]State [Students]ZIP [Students]Mailing_Zip	First Line: Street, Apt/Suite Second Line: City, State, Zip. The state is abbreviated to TN.
Last 4 SSN	No	NA	Blank
Telephone	Yes	[Students]Home_Phone	Home (Under Phone Numbers)
Parent/Guardian 1	Yes	[Person]First_Name [Person]Middle_Name [Person]Last_Name	The order of priority is Mother, Father, Parents, Guardian. In case of multiple entries with the same relationship, selection is based on Order.
Relationship to Student	Yes	[StudentContactAssoc]currreltypecodesetid	The relationship between the student and the contact.
Parent/Guardian 2	Yes	[Person]First_Name [Person]Middle_Name [Person]Last_Name	The order of priority is Mother, Father, Parents, Guardian. In case of multiple entries with the same relationship, selection is based on Order.
Relationship to Student	Yes	[StudentContactAssoc]currreltypecodesetid	Relationship
Name	Yes	[Users]First_Name, [Users]Middle_Name, [Users]Last_Name	Logged in Username (Concatenate First, middle, and last name)
Title	Yes	[Users]Title [Users]GoupValue	Title that appears on the Demographics page. If empty, then title is derived from Admin Access and Roles, Default Group
Signature	No	NA	Blank