S_REPORTING_SEGMENTS_S (ver 16.10.1)
This table is standalone table that captures reporting periods/segments. This table is available for all states and provinces and may or may not be utilized for your state or province.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 16.10.1 | Number(11,0) | Primary Key |
| SegmentName | 16.10.1 | Varchar2(80) | The name of the report period. |
| StartDate | 16.10.1 | Date | The start date of the reporting period. |
| EndDate | 16.10.1 | Date | The end date of the report period. |
| SortOrder | 16.10.1 | Number(11,0) | The sort order of the reporting periods. |
| YearID | 16.10.1 | Number(11,0) | The year the reporting period is related to. |
| SchoolID | 16.10.1 | Number(11,0) | The School ID the reporting period is related to. |