COURSE_DESCR(SQL Table) |
Index Back |
---|---|
Course DescriptionsCourse Descriptions: Effective Dated to store different types of Course Descriptions |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(6) | VARCHAR2(6) NOT NULL | Course Code | |
2 | Character(2) | VARCHAR2(2) NOT NULL |
Course Description Type
CA=Course Agenda CC=Course Content GI=General Information TA=Target Audience |
|
3 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
4 | DESCRLONG | Long Character | CLOB | Long Description |