CST_PUBFEEDERSCHOOL (ver 15.5.1)
This table is a standalone table and stores feeder school information downloaded from the ODS. This table is available for all states/provinces and may or may not be utilized for your state/province.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBFEEDERSCHOOL record to which the record is associated. Required. (Default – Next value in CST_PUBFEEDERSCHOOL_SQ sequence) |
CST_PUBPROFILEID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBPROFILE record to which the record is associated. Required. |
SCHOOLYEAR | 15.5.1 | NUMBER(4,0) | The external school year for the download resource. Required. |
FEEDERSCHOOLORGID | 15.5.1 | VARCHAR2(60) | The external feeder school organization ID for a feeder school. Required. |
RECEIVINGSCHOOLORGID | 15.5.1 | VARCHAR2(60) | The external receiving school organization ID for a feeder school. Required. |
BEGINDATE | 15.5.1 | DATE | The external begin date for a feeder school. Required. |
ENDDATE | 15.5.1 | DATE | The external end date for a feeder school. |
EXTERNALREFID | 15.5.1 | VARCHAR2(32) | The external reference ID for a given feeder school. |
VERSION | 15.5.1 | VARCHAR2(32) | The external version for a given feeder school. |