CATEGORY_CDPrompt Table: TRN_CAT_TBL
SUB_CATEGORY_CDPrompt Table: TRN_SUBCAT_TBL
COURSELANGUAGE_CDTN_CATMVVW1_LNG(SQL View) |
Index Back |
|---|---|
Rellang Trn Catalog Move View1Administer Training/Budget Training related Language record of the TRN_CAT_MV_VW1 |
| SELECT CATEGORY_CD, SUB_CATEGORY_CD, COURSE, LANGUAGE_CD, DESCR FROM PS_TN_CTLOG_TL_LNG |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |