COURSECATEGORY_CDSUB_CATEGORY_CDTRN_SCAT_CRS_VW(SQL View) |
Index Back |
|---|---|
SubCategories tied to a CourseSubCategories tied to a Course |
| SELECT COURSE, CATEGORY_CD, SUB_CATEGORY_CD FROM PS_TRN_CATALOG_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 2 | CATEGORY_CD |
Character(10) | VARCHAR2(10) NOT NULL | Category Code |
| 3 | SUB_CATEGORY_CD |
Character(10) | VARCHAR2(10) NOT NULL | Subcategory Code |