DistrictCategory (ver8.1.0)
This table stores user-created categories available to all schools in the district for classifying student document attachments. Categories for records marked deleted will not be displayed. To navigate to this page in the application: District > Document Attachment Categories.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| Description | 8.1.0 | Varchar2(200) | User specified description of the category. |
ID | 8.1.0 | Number(19,0) | Unique sequential number generated by the application. Indexed. Required. |
| IsDeleted | 8.1.0 | Number(1) | 1 indicates the user deleted the record leaving the record no longer accessible. Defaults to 0. |
| IsVisible | 8.1.0 | Number(1) | 1 indicates the category can be seen on the Document Attachment Categories page. |
| Name | 8.1.0 | Varchar2(50) | User specified unique name for the category. Indexed. Required. |
WhenCreated | 8.1.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 8.1.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 8.1.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 8.1.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |