TRN_CATALOG_TBL(SQL Table) | 
Index Back | 
|---|---|
Catalog TableAdminister Training/Budget Training - Details course catalog information by category and sub-category. | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL | 
Category Code
 Prompt Table: TRN_CAT_TBL  | 
|
| 2 | Character(10) | VARCHAR2(10) NOT NULL | 
Subcategory Code
 Prompt Table: TRN_SUBCAT_TBL  | 
|
| 3 | Character(6) | VARCHAR2(6) NOT NULL | 
Course Code
 Prompt Table: TRN_ALL_COURSE  | 
|
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description | 
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description | 
| 6 | REAL_COURSE | Character(7) | VARCHAR2(7) NOT NULL | 
Course Code
 Prompt Table: TRN_ALL_COURSE  |