JOB_REQ_NBRGVT_OCC_SERIESGVT_VA_OCCSER_V(SQL View) |
Index Back |
|---|---|
USA Jobs Runctl prompt table |
| SELECT DISTINCT JOB_REQ_NBR , GVT_OCC_SERIES FROM PS_GVT_RQSN_JOBCD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JOB_REQ_NBR |
Character(6) | VARCHAR2(6) NOT NULL | Job requisition number |
| 2 | GVT_OCC_SERIES |
Character(4) | VARCHAR2(4) NOT NULL | Occupational Series |