CareerTechProgramNode (ver21.11.0)
Represents an individual rule on the academic and career planner program rule tree.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AllowAnyOf | 21.11.0.0 | Number(1) | Indicates whether the node supports "Any of" for child nodes. Valid values: 1 = Yes, 0 = No. Defaults to 0. Required. |
| CareerTechProgramId | 21.11.0.0 | Number(10) | Foreign key to CareerTechProgram.ID. Required. Indexed. Unique composite index on CareerTechProgramID, ParentID and Name. |
| CreditCapacity | 21.11.1.0 | Number(15,10) | The number of credits that are required to satisfy this program node. |
| ID | 21.11.0.0 | Number(10) | Unique identifier assigned by system. Indexed. Required. |
| Name | 21.11.0.0 | Varchar2(100) | Name of this node. Required. Unique composite index on CareerTechProgramID, ParentID and Name. |
| ParentID | 21.11.0.0 | Number(10) | "Parent" node ID which contains this one, or null for the "root" node in a program. Indexed. Unique composite index on CareerTechProgramID, ParentID and Name. |
| SortOrder | 21.11.0.0 | Number(10) | Order of the node amongst its siblings. Required. |
| WhenCreated | 21.11.0.0 | Timestamp(6) | Date and time when record was created. Defaults to the system date. Required. |
| WhenModified | 21.11.0.0 | Timestamp(6) | Date and time when record was updated. Defaults to the system date. Required. |
| WhoCreated | 21.11.0.0 | Varchar2(100) | The user that created the record. Defaults to User. Required. |
| WhoModified | 21.11.0.0 | Varchar2(100) | The user that updated the record. Defaults to User. Required. |