CareerTechProgramCourse (ver21.11.0)
Associates a course to an academic and career planner program node
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CareerTechProgramCourseID | 21.11.0.0 | Number(10) | Unique identifier created by the system. Required. Indexed |
| CareerTechProgramNodeID | 21.11.0.0 | Number(10) | Foreign key to CareerTechProgramNode.ID. Required. Uniquely indexed with CourseNumber. |
| CourseNumber | 21.11.0.0 | Varchar2(20) | The course number to associate with the program. Required. |
| IsRequired | 21.11.0.0 | Number(1) | Indicates if the course is required for the program. 0 = false, 1 = true. Required. |
| WhenCreated | 21.11.0.0 | TimeStamp(6) | The date and time the record was created. Defaults to system date. Required. |
| WhenModified | 21.11.0.0 | Timestamp(6) | The date and time the record was updated. Defaults to system date. Required. |
| WhoCreated | 21.11.0.0 | Varchar2(100) | The name of the user who created the record. Defaults to User. Required. |
| WhoModified | 21.11.0.0 | Varchar2(100) | The name of the user who updated the record. Defaults to User. Required. |