This table defines what Programs are offered for a Cluster. This table is generated as Programs are associated with Clusters.
|CareerTechClusterID||19.11.0||Number(10,0)||Foreign key to the Cluster table. Indexed. Required.|
|CareerTechClusterProgramsID||19.11.0||Number(10,0)||Unique identifier for this table. Indexed. Required.|
|CareerTechProgramID||19.11.0||Number(10,0)||Foreign key to the Program table. Indexed. Required.|
|IsActive||19.11.0||Number(1,0)||Indicates whether the Cluster/Program combination is active or not. Valid values: 1=True, 0=False. Default 1.|
The date and time the record was created. Defaults to system date. Required.
|WhenModified||19.11.0||Timestamp(6)||The date and time the record was modified. Defaults to system date. Required.|
|WhoCreated||19.11.0||Varchar2(100)||The name of the person who create the record. Defaults to user. Required.|
|WhoModified||19.11.0||Varchar2(100)||The name of person who modified the record. Defaults to user. Required.|
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.