S_PA_ExpulsionSuspension_S (ver 15.4.0)
This table is a standalone table and stores Letter text for Pennsylvania Expulsion and Suspension Letters (Incident Management).
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 15.4.0 | Number(11,0) | The Letter ID. This is shown on the page where the Letter is edited, but is not editable by the enduser. |
SchoolID | 15.4.0 | Number(11,0) | School Number |
Title | 15.4.0 | Varchar2(2000) | Title of the Letter, such as "OSS-4 days". This will be shown in dropdowns where the desired letter is selected for printing. |
IncidentType | 15.4.0 | Number(11,0) | The Incident Type from the Incident Management code table, such as "State Reportable" or "Academic Violations". |
ActionCode | 15.4.0 | Number(11,0) | The Action Code from the Incident Management code table, such as "S3-IN SCHOOL SUSPENSION" or "S5-EXPULSION LESS THAN ONE CALENDAR YEAR". |
OpeningParagraph | 15.4.0 | Varchar2(2000) | The boilerplate text for the opening paragraph. This will appear above the incident details. |
ClosingParagraph | 15.4.0 | Varchar2(2000) | The boilerplate text for the closing paragraph. This will appear below the incident details. |
Signature | 15.4.0 | Varchar2(2000) | The boilerplate text for the signature. This will appear below the closing paragraph. |