CATEGORY_CDPrompt Table: TRN_CAT_TBL
SUB_CATEGORY_CDPrompt Table: TRN_SUBCAT_TBL
COURSEY/N Table Edit
TRN_CAT_MV_VW2(SQL View) |
Index Back |
|---|---|
Training Catalog Move View2Training Catalog Move View2 |
| SELECT CATEGORY_CD, SUB_CATEGORY_CD, COURSE, REAL_COURSE, 'N', DESCR FROM PS_TRN_CATALOG_TBL WHERE COURSE NOT LIKE 'NA%' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CATEGORY_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Category Code
Prompt Table: TRN_CAT_TBL |
| 2 | SUB_CATEGORY_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Subcategory Code
Prompt Table: TRN_SUBCAT_TBL |
| 3 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 4 | REAL_COURSE | Character(7) | VARCHAR2(7) NOT NULL | Course Code |
| 5 | COURSE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Course List Switch
Y/N Table Edit |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |