S_IM_LETTER_SETUP_S (ver 17.9.0)
This table is a stand-alone table used in conjunction with Incident Management to save letter templates. This table is available for all states and provinces and might or might not be utilized for your state or province.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 17.9.0 | Number(11,0) | Primary Key |
| SchoolID | 17.9.0 | Number(11,0) | School ID this letter applies to, which corresponds to the school_number field in the schools table. |
| Title | 17.9.0 | Varchar2(2000) | Title of the letter. |
| IncidentType | 17.9.0 | Number(11,0) | The Incident Type this letter applies to, which corresponds to the lu_code_id in the incident_lu_code table where code_type equals 'incidentTypeCode'. |
| ActionCode | 17.9.0 | Number(11,0) | The Action Code this letter applies to, which corresponds to the lu_code_id in the incident_lu_code table where code_type equals 'actioncode'. |
| ActionSubcode | 17.9.0 | Number(11,0) | The Action Sub Code this letter applies to, which corresponds to the lu_sub_code_id in the incident_lu_sub_code table. |
| OpeningParagraph | 17.9.0 | Varchar2(4000) | The Opening Paragraph text that will be used for this letter. |
| ClosingParagraph | 17.9.0 | Varchar2(4000) | The Closing Paragraph text that will be used for this letter. |
| Signature | 17.9.0 | Varchar2(4000) | The Signature text that will be used for this letter. |