JOBCODEGVT_APPRTG_SRC2(SQL View) |
Index Back |
|---|---|
Jobcode View for GVT eRec |
| SELECT A.JOBCODE , A.GVT_PAY_PLAN , A.GVT_OCC_SERIES , A.GRADE , A.GVT_OFFICIAL_DESCR FROM PS_JOBCODE_TBL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 2 | GVT_PAY_PLAN | Character(2) | VARCHAR2(2) NOT NULL | Pay Plan |
| 3 | GVT_OCC_SERIES | Character(4) | VARCHAR2(4) NOT NULL | Occupational Series |
| 4 | GRADE | Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
| 5 | GVT_OFFICIAL_DESCR | Character(70) | VARCHAR2(70) NOT NULL | Official Position Title |