Program, 174 (ver4.0.4)
This table stores all program-related information.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DCID | 4.0.4 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 4.0.4 | CLOB | The program description. |
Effective_End_Dt | 4.0.4 | Date | Program effective end date. |
Effective_Start_Dt | 4.0.4 | Date | Program effective start date. |
ID | 4.0.4 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Name | 4.0.4 | Varchar(50) | The name of preferences of almost anything in the system. User specific preferences are the name-U0#### where ##### represents the users internal ID relating to the Users table. And school specific preferences are name-S##### where ##### is the schools number. Indexed. |
Program_Num | 4.0.4 | Varchar(32) | Program number. |
SchoolID | 4.0.4 | Number(10,0) | The School_Number of the associated Schools record. |
YearID | 4.0.4 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Maintained in the Terms table. Indexed. |