S_NE_SCH_SSAPeriods_C (ver 15.2.2)
This is an extension of the Schools table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 15.2.2 | Number(10,0) | System generated primary key. |
SCHOOLSDCID | 15.2.2 | Number(10,0) | Foreign key to the Schools table. (System generated) |
PERFOURENDDATE | 15.2.2 | Date | Collection Period 4 End Date. |
PERFOURSTSTARTDATE | 15.2.2 | Date | Collection Period 4 Start Date. |
PERONEENDDATE | 15.2.2 | Date | Collection Period 1 End Date. |
PERONESTARTDATE | 15.2.2 | Date | Collection Period 1 Start Date. |
PERTHREEENDDATE | 15.2.2 | Date | Collection Period 3 End Date. |
PERTHREESTARTDATE | 15.2.2 | Date | Collection Period 3 Start Date. |
| PERTWOENDDATE | 15.2.2 | Date | Collection Period 2 End Date. |
| PERTWOSTARTDATE | 15.2.2 | Date | Collection Period 2 Start Date. |
| SCHOOLID | 15.2.2 | Number(11,0) | School number of the selected school. |
| TERMID | 15.2.2 | Number(11,0) | The selected termid of the term. |
| YEARID | 15.2.2 | Number(11,0) | School year identifier for this record. |