TRN_SCAT_CRS_VW

(SQL View)
Index Back

SubCategories tied to a Course

SubCategories 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