S_MB_SCH_X (ver 16.12.1)
This table is an extension of the [Schools] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| SchoolsDCID | 16.12.1 | Number (10,0) | Primary key that relates the extended table to the [Schools] table |
| ArtByCat_A_1 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 1 First Subject Code. Migrated from [Schools.MB_ArtByCat_A_1]. |
| ArtByCat_A_2 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 2 First Subject Code. Migrated from [Schools.MB_ArtByCat_A_2]. |
| ArtByCat_A_3 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 3 First Subject Code. Migrated from [Schools.MB_ArtByCat_A_3]. |
| ArtByCat_A_4 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 4 First Subject Code. Migrated from [Schools.MB_ArtByCat_A_4]. |
| ArtByCat_A_5 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 5 First Subject Code. Migrated from [Schools.MB_ArtByCat_A_5]. |
| ArtByCat_A_6 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 6 First Subject Code. Migrated from [Schools.MB_ArtByCat_A_6]. |
| ArtByCat_A_7 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 7 First Subject Code. Migrated from [Schools.MB_ArtByCat_A_7]. |
| ArtByCat_A_8 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 8 First Subject Code. Migrated from [Schools.MB_ArtByCat_A_8]. |
| ArtByCat_B_1 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 1 Second Subject Code. Migrated from [Schools.MB_ArtByCat_B_1]. |
| ArtByCat_B_2 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 2 Second Subject Code. Migrated from [Schools.MB_ArtByCat_B_2]. |
| ArtByCat_B_3 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 3 Second Subject Code. Migrated from [Schools.MB_ArtByCat_B_3]. |
| ArtByCat_B_4 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 4 Second Subject Code. Migrated from [Schools.MB_ArtByCat_B_4]. |
| ArtByCat_B_5 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 5 Second Subject Code. Migrated from [Schools.MB_ArtByCat_B_5]. |
| ArtByCat_B_6 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 6 Second Subject Code. Migrated from [Schools.MB_ArtByCat_B_6]. |
| ArtByCat_B_7 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 7 Second Subject Code. Migrated from [Schools.MB_ArtByCat_B_7]. |
| ArtByCat_B_8 | 16.12.1 | Varchar2(4) | Art Subject Marked At Category Level Grade 8 Second Subject Code. Migrated from [Schools.MB_ArtByCat_B_8]. |
| ArtByCat_C_1 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 1 Third Subject Code. |
| ArtByCat_C_2 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 2 Third Subject Code. |
| ArtByCat_C_3 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 3 Third Subject Code. |
| ArtByCat_C_4 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 4 Third Subject Code. |
| ArtByCat_C_5 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 5 Third Subject Code. |
| ArtByCat_C_6 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 6 Third Subject Code. |
| ArtByCat_C_7 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 7 Third Subject Code. |
| ArtByCat_C_8 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 8 Third Subject Code. |
| ArtByCat_D_1 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 1 Fourth Subject Code. |
| ArtByCat_D_2 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 2 Fourth Subject Code. |
| ArtByCat_D_3 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 3 Fourth Subject Code. |
| ArtByCat_D_4 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 4 Fourth Subject Code. |
| ArtByCat_D_5 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 5 Fourth Subject Code. |
| ArtByCat_D_6 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 6 Fourth Subject Code. |
| ArtByCat_D_7 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 7 Fourth Subject Code. |
| ArtByCat_D_8 | 19.8.2 | Varchar2(4) | Art Subject Marked At Category Level Grade 8 Fourth Subject Code. |
| ERC_LB1_Description | 16.12.1 | Varchar2(250) | First Local Option Learning Behaviour Description. Migrated from [Schools.MB_ERC_LB1_Description]. |
| ERC_LB1_Name | 16.12.1 | Varchar2(80) | First Local Option Learning Behaviour Name. Migrated from [Schools.MB_ERC_LB1_Name]. |
| ERC_LB2_Description | 16.12.1 | Varchar2(250) | Second Local Option Learning Behaviour Description. Migrated from [Schools.MB_ERC_LB2_Description]. |
| ERC_LB2_Name | 16.12.1 | Varchar2(80) | Second Local Option Learning Behaviour Name. Migrated from [Schools.MB_ERC_LB2_Name. |
| MultiSubject_Title | 16.12.1 | Varchar2(80) | Multi-subject Grading Box Title. Migrated from [Schools.MB_MultiSubject_Title]. |
| PrincipalComments_16 | 16.12.1 | Varchar2(4000) | Principal's Report Card Comments For Grades 1-6. Migrated from [Schools.MB_PrincipalComments_16]. |
| PrincipalComments_78 | 16.12.1 | Varchar2(4000) | Principal's Report Card Comments For Grades 7-8. Migrated from [Schools.MB_PrincipalComments_78]. |
| PrincipalComments_912 | 16.12.1 | Varchar2(4000) | Principal's Report Card Comments For Grades 9-12. Migrated from [Schools.MB_PrincipalComments_912]. |
| PrincipalSignaturePath | 16.12.1 | Varchar2(250) | Path For Principal's Signature For Report Cards. Migrated from [Schools.MB_PrincipalSignaturePath]. |
| SchoolLogoPath | 16.12.1 | Varchar2(250) | Path For School Logo For Report Cards. Migrated from [Schools.MB_SchoolLogoPath]. |
| SRC_LB1_Description | 16.12.1 | Varchar2(250) | First Local Option Learning Behaviour Description. Migrated from [Schools.MB_SRC_LB1_Description]. |
| SRC_LB1_Name | 16.12.1 | Varchar2(80) | First Local Option Learning Behaviour Name. Migrated from [Schools.MB_SRC_LB1_Name]. |
| SRC_LB2_Description | 16.12.1 | Varchar2(250) | Second Local Option Learning Behaviour Description. Migrated from [Schools.MB_SRC_LB2_Description]. |
| SRC_LB2_Name | 16.12.1 | Varchar2(80) | Second Local Option Learning Behaviour Name. Migrated from [Schools.MB_SRC_LB1_Name]. |
| T1_End_Date | 16.12.1 | Date | Elementary Report Card Term 1 Attendance End Date. Migrated from [Schools.MB_T1_End_Date]. |
| T2_End_Date | 16.12.1 | Date | Elementary Report Card Term 2 Attendance End Date. Migrated from [Schools.MB_T2_End_Date]. |
| SRC_First_LB_Description | 17.6.0 | Varchar2(250) | First Local Option Learning Behaviour Description. |
| SRC_First_LB_Name | 17.6.0 | Varchar2(80) | First Local Option Learning Behaviour Name. |
| SRC_Second_LB_Description | 17.6.0 | Varchar2(250) | Second Local Option Learning Behaviour Description. |
| SRC_Second_LB_Name | 17.6.0 | Varchar2(80) | Second Local Option Learning Behaviour Name. |
| PrincipalSignatureRCPath | 17.6.0 | Varchar2(250) | Path For Principal's Signature For Report Cards. |