TN_CTALOEVW_LNG(SQL View) |
Index Back |
---|---|
Rellang Catalog ViewAdminister Training/Budget Training related Language record of the TRN_CATALO_E_VW |
SELECT B.CATEGORY_CD, B.SUB_CATEGORY_CD, B.REAL_COURSE, A.LANGUAGE_CD, A.DESCR, A.DESCRSHORT FROM PS_TN_CTLOG_TL_LNG A, PS_TRN_CATALOG_TBL B WHERE A.CATEGORY_CD = B.CATEGORY_CD AND A.SUB_CATEGORY_CD = B.SUB_CATEGORY_CD |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(10) | VARCHAR2(10) NOT NULL | Category Code | |
2 | Character(10) | VARCHAR2(10) NOT NULL | Subcategory Code | |
3 | Character(7) | VARCHAR2(7) NOT NULL | Course Code | |
4 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |