S_ON_XML_CLASS_S ver 21.3.0
This table is a standalone table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 21.3.0 | Number(11,0) | Primary key |
Academic_Year | 21.3.0 | VarChar2(9) | The academic year of the submission |
| Submission_Period_Type | 21.3.0 | VarChar2(20) | Submission period type |
| BSID | 21.3.0 | Number(11) | Board School Identification number |
| Action | 21.3.0 | VarChar2(6) | This is the action associated with this submission Valid values: ADD, UPDATE |
| Class_Code | 21.3.0 | VarChar2(25) | Class code |
| Class_Start_date | 21.3.0 | Date | Class start date |
| Class_End_date | 21.3.0 | Date | Class end date |
| Class_Type | 21.3.0 | VarChar2(5) | Class type |
| Language_Type | 21.3.0 | VarChar2(40) | Language Type |
| Classroom_Type | 21.3.0 | VarChar2(2) | Classroom Type |
| WhoCreated | 21.3.0 | VarChar2(100) | Who created the record |
| WhenCreated | 21.3.0 | TimeStamp(6) | When the record was created |
| WhoModified | 21.3.0 | VarChar2(100) | Who modified the record |
| WhenModified | 21.3.0 | TimeStamp(6) | When was the record modified |