DSB_EMPL_CTG_VW(SQL View) | 
Index Back | 
|---|---|
Distinct Sub-CategoriesThis view displays the distinct Employee Sub-Categories. | 
| SELECT DISTINCT EMPL_CTG_L1 FROM PS_EMPL_CTG_L2 | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(6) | VARCHAR2(6) NOT NULL | Employee Subcategory |