S_ON_MINISTRYSCHOOLS_S ver 22.5.3.0
This is a Standalone table.
Column Name | Version | Data Type | Mandatory/Optional | Description / Notes |
|---|---|---|---|---|
ID | 22.5.3.0 | Number(11,0) | Mandatory | Primary Key - automated generated with extension architecture |
Board_Number | 22.5.3.0 | VarChar2(10) | Mandatory | This should be Unique and match the District Number |
City | 22.5.3.0 | VarChar2(80) | ||
Country | 22.5.3.0 | VarChar2(50) | ||
PO_Box | 22.5.3.0 | VarChar2(50) | ||
PostalCode | 22.5.3.0 | VarChar2(10) | ||
Province | 22.5.3.0 | VarChar2(30) | ||
Sch_Special_Cond_Code | 22.5.3.0 | VarChar2(100) | ||
School_Language | 22.5.3.0 | VarChar2(20) | ||
School_Level | 22.5.3.0 | VarChar2(25) | ||
School_Name | 22.5.3.0 | VarChar2(200) | Mandatory | |
School_Number | 22.5.3.0 | VarChar2(10) | Mandatory | |
School_Type | 22.5.3.0 | VarChar2(50) | ||
SchoolAddLine1 | 22.5.3.0 | VarChar2(100) | ||
SchoolAddLine2 | 22.5.3.0 | VarChar2(100) | ||
SchoolAddLine3 | 22.5.3.0 | VarChar2(100) | ||
Street | 22.5.3.0 | VarChar2(100) | ||
Suite | 22.5.3.0 | VarChar2(100) | ||
WhoCreated | 22.5.3.0 | VarChar2(100) | Mandatory | automated generated with extension architecture |
WhenCreated | 22.5.3.0 | TimeStamp(6) | Mandatory | automated generated with extension architecture |
WhoModified | 22.5.3.0 | VarChar2(100) | Mandatory | automated generated with extension architecture |
WhenModified | 22.5.3.0 | TimeStamp(6) | Mandatory | automated generated with extension architecture |