Create an Object Report Template

Title of this report

Enter the title of the report.

Table

Choose one of the following tables for the report:

• Students

• Student Schedule

• Staff

• Log

Selecting Log provides you access to the Log table from which you can select any field, including database extensions (legacy custom fields) that you want to include in the report. Each field you want to include in the log object report must be specified using the correct syntax to successfully display the data. The text that precedes the syntax (separated by a colon) can be modified (or deleted) based on your needs. For example, you could modify Name: ^([01]LastFirst) to appear as Student’s Last Name: ^([01]LastFirst).

The following are Log table student fields you can use in the report:

• Name: ^([01]LastFirst)

• Grade: ^([01]Grade_Level)

• SN: ^([01]Student_Number)

• DOB: ^([01]DOB)

• SSN: ^([01]SSN)

• Ethnicity: ^([01]Ethnicity)

• Mailing City: ^([01]Mailing_City)

• Mailing Street: ^([01]Mailing_Street)

• Mailing State: ^([01]Mailing_State)

• Mailing Zip: ^([01]Mailing_Zip)

• Alert Discipline: ^([01]Alert_Discipline)

• State Student #: ^([01]State_StudentNumber)

The following are Log table discipline fields you can use in the report:

• Entry Author: ~(Entry_Author)

• Entry Date: ~(Entry_Date)

• Entry Time: ~(Entry_Time)

• Title: ~(Subject)

• Entry Text: ~(Entry)

• Log Type ID: ~(logtypeid)

• Subtype: ~(Subtype)

• Category: ~(Category)

• Consequence: ~(Consequence)

• Incident Type: ~(Discipline_IncidentType)

• Action Taken Detail: ~(Discipline_ActionTakenDetail)

• Incident Type Category: ~(Discipline_IncidentTypeCategory)

• Action Taken End Date: ~(Discipline_ActionTakenEndDate)

• Incident Type Detail: ~(Discipline_IncidentTypeDetail)

• Student Number: ~(Student_Number)

• Administrator ID: ~(Discipline_AdministratorID)

• Likely Injury Flag: ~(Discipline_LikelyInjuryFlag)

• Alcohol Related Flag: ~(Discipline_AlcoholRelatedFlag)

• Money Loss Value: ~(Discipline_MoneyLossValue)

• Drug Related: ~(Discipline_DrugRelatedFlag)

• Offender: ~(Discipline_Offender)

• Drug Type Detail: ~(Discipline_DrugTypeDetail)

• Police Involved: ~(Discipline_PoliceInvolvedFlag)

• Duration Actual: ~(Discipline_DurationActual)

• Reporter: ~(Discipline_Reporter)

• Duration Assigned: ~(Discipline_DurationAssigned)

• Reporter ID: ~(Discipline_ReporterID)

• Duration Change: ~(Discipline_DurationChangeSource)

• School Rules Vio Flag: ~(Discipline_SchoolRulesVioFlag)

• Duration Notes: ~(Discipline_DurationNotes)

• Sequence: ~(Discipline_Sequence)

• Felony Flag: ~(Discipline_FelonyFlag)

• Victim Type: ~(Discipline_VictimType)

• Gang Related Flag: ~(Discipline_GangRelatedFlag)

• Weapon Related: ~(Discipline_WeaponRelatedFlag)

• Hate Crime: ~(Discipline_HateCrimeFlag)

• Weapon Type: ~(Discipline_WeaponType)

• Hearing Officer: ~(Discipline_HearingOfficerFlag)

• Weapon Type Notes: ~(Discipline_WeaponTypeNotes)

• Incident Context: ~(Discipline_IncidentContext)

• Incident Date: ~(Discipline_IncidentDate)

• Custom: ~(Custom)

• Incident Location: ~(Discipline_IncidentLocation)

• Action Date: ~(Discipline_ActionDate)

• Incident Loc Detail: ~(Discipline_IncidentLocDetail)

• Discipline Action: ~(Discipline_ActionTaken)

Default font

Choose the font in which you want the report to print.

The report prints in this font unless you include an HTML tag to specify another font within an object of the report.

Default font size

Choose the size in which you want the text of the report to print.

The report prints in this font size unless you include an HTML tag to specify a different font size within an object of the report.

Default text line height

Enter the default height of each line of text on the report. The line height determines the amount of space for each line of text in the object. Increasing the line height creates more space between each line of text.

Page Size

Choose the size of the paper on which you want to print this report. To enter a custom size, enter the horizontal and vertical page measurements in the Custom Size fields.

Margins (inches)

Enter the size, in inches, of the start, top, end, and bottom margins for this report. The start side and end side are determined by the direction of the language used in the report.

Orientation

To indicate the paper orientation of this report, choose one of the following:

• Vertical (portrait)

• Horizontal (landscape)

Scale

Edit the percentage to scale the object report. The lower the percentage, the smaller the form letter scales relative to the size of the page.

This report available to

Select one of the following options to determine who can use this report:

• users at all schools on this PowerSchool system

• only users at [the selected school]

Teachers can print?

If you want teachers to be able to print this report, select the checkbox. Otherwise, deselect the checkbox.

Override Course Exclude Setting?

Select the checkbox to override the setting on the Course Setup page to exclude courses from inclusion in reports.