Skip to main content
Skip table of contents

CST_PUBCODEMAPPING (ver 15.5.1)

This table is a standalone table and stores values that map the ODS code values to PowerSchool local codes.  Note: Each entry must have a unique CST_PUBCODEVALUEID, SCHOOLID, 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_PUBCODEMAPPING record to which the record is associated. Required. (Default – Next value in CST_PUBCODEMAPPING_SQ sequence)

CST_PUBCODEVALUEID  

15.5.1

NUMBER(19,0)

The internal ID for the CST_PUBCODEVALUE 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).

LOCALCODE 

15.5.1

VARCHAR2(30)

The local code in PowerSchool. Required. (Default – ‘NULL’)

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.