OCCUP_CG_AUSMGR=Manager
NON=Non-Manager
Default Value: NON
OCCUP_CG_AUS_VW(SQL View) |
Index Back |
|---|---|
GPAU Occupational categoriesGPAU Occupational categories Search record |
| SELECT OCCUP_CG_AUS , DESCR100 , CATEGORY_TYPE FROM PS_OCCUP_CG_AUS a WHERE a. EFFDT = ( SELECT MAX(b.effdt) FROM PS_OCCUP_CG_AUS b WHERE b.occup_cg_aus = a.occup_cg_aus AND b.effdt <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OCCUP_CG_AUS |
Character(4) | VARCHAR2(4) NOT NULL | Occupational category for WGEA report |
| 2 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 3 | CATEGORY_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
occupational category type
MGR=Manager NON=Non-Manager Default Value: NON |