Skip to main content
Skip table of contents

CST_PUBPROGRAM (ver 15.5.1)

This table is a standalone table and stores program information downloaded from the ODS. Note: Each entry must have a unique CST_PUBPROFILEID, EDUORGID, SCHOOLYEAR, and NAME. 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_PUBPROGRAM record to which the record is associated. Required. (Default – Next value in CST_PUBPROGRAM_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.

EDUORGID

15.5.1

NUMBER(19,0)

The external education organization ID. Required.

TYPE

15.5.1

VARCHAR2(60)

The external type of program. Required.

NAME

15.5.1

VARCHAR2(60)

The external name of the program. Required.

PROGRAMID

15.5.1

VARCHAR2(60)

The external program ID.

SPONSORTYPE

15.5.1

VARCHAR2(60)

The external sponsor type for the program.

EXTERNALREFID

15.5.1

VARCHAR2(32)

The external reference ID.

VERSION

15.5.1

VARCHAR2(32)

The external version.

 

 

JavaScript errors detected

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

If this problem persists, please contact our support.