Skip to main content
Skip table of contents

CareerTechProgram (ver19.11.0)

This table contains Career Tech Programs.

Column Name

Initial Version

Data TypeDescription
CareerTechProgramID19.11.0Number(10,0)Unique identifier for this table. Indexed. Required.
CareerTechProgramTypeID19.11.0Number(10,0)Foreign key to Program Type. Indexed. Required.
ProgramCode21.11.0Varchar2(10)Program identifier. Indexed with YearId. Required.
ProgramName19.11.0VarChar2(100)Name of the Program. Indexed with YearId.Required.
WhenCreated19.11.0Timestamp(6)

The date and time the record was created. Defaults to system date. Required.

WhenModified19.11.0Timestamp(6)The date and time the record was modified. Defaults to system date. Required.
WhoCreated19.11.0Varchar2(100)The name of the person who creates the record. Defaults to user. Required.
WhoModified19.11.0Varchar2(100)The name of the person who modified the record. Defaults to user. Required.
YearID19.11.0Number(10,0)

A number representing which year the term belongs to, such as 19 for 2019-2020.

The number is equal to the ID of the year term divided by 100. Required. Indexed with ProgramCode and ProgramName.

JavaScript errors detected

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

If this problem persists, please contact our support.