COURSE_LISTEFFDTDefault Value: %date
R_COURSE_SEQUENCELANGUAGE_CDCLST_DETL_LANG(SQL Table) |
Index Back |
|---|---|
Static Course List LanguageThis table is the related language record for CLST_DETL_TBL. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COURSE_LIST |
Character(9) | VARCHAR2(9) NOT NULL | Course List |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | R_COURSE_SEQUENCE |
Number(7,0) | INTEGER NOT NULL | Course Sequence |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | SAA_DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | This field is used to display information in the new student view for academic advisement reports. |
| 7 | SAA_WHERE_CLAUSE | Long Character | CLOB | This field contains the where clause used in different processes in academic advisement. |