S_SUBAREA_ACP_C (ver 16.11.0)
This table is a child table of [S_ACP_S] table and is used to relate Subject Areas to an Academic Plan. This table is available for all states and provinces and might or might not be utilized for your state or province.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 16.11.0 | Number(11,0) | Primary Key |
| S_ACP_SID | 16.11.0 | Number(11,0) | Foreign Key to S_ACP_S table. |
| Name | 16.11.0 | Varchar2(50) | The name of the subject area. |
| SCED_SubArea | 17.11.0 | Varchar2(200) | A comma-separated list of SCED subject areas, e.g. "02,12,24". |
| SCED_SubArea_Text | 17.11.0 | Varchar2(2) | Contains the last added subject area, e.g. "24", and is required for use with multiselect_script.js. |
| SortOrder | 16.11.0 | Number(11,0) | Defines the order preference. |