CST_PUBCODEMAPPINGMISC (ver 15.5.1)
This table is a standalone table and stores values that map the ODS code values to PowerSchool local codes. This table allows for miscellaneous code mapping. Note: Each entry must have a unique CST_PUBCODESETMISCID, SCHOOLID, SCHOOLYEAR, and LOCALCODE. 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_PUBCODEMAPPINGMISC record to which the record is associated. Required. (Default – Next value in CST_PUBCODEMAPPINGMISC_SQ sequence) |
CST_PUBCODESETMISCID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBCODESETMISC record to which the record is associated. Required. |
SCHOOLID | 15.5.1 | NUMBER(19,0) | The internal ID for the SCHOOLS record to which the record is associated. Required. (Default 0-District) |
SCHOOLYEAR | 15.5.1 | NUMBER(4,0) | The school year for this code mapping. |
| LOCALCODE | 15.5.1 | VARCHAR2(50) | The local code in PowerSchool. (Default – ‘NULL’) |
| EXTERNALCODE | 15.5.1 | VARCHAR2(300) | The external code being mapped to. (Default – ‘NULL’) |