HRS_BIP_JSAL_VW(SQL View) |
Index Back |
|---|---|
Used in XMLP report for Job OXMLP report Print Job Opening Salary Information |
| SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ , A.JOBCODE , A.HRS_JO_PRM_JCD_FLG , ' ' , ' ' , A.SAL_ADMIN_PLAN , ' ' , ' ' , A.HRS_JO_MIN_RT , A.HRS_JO_MAX_RT , A.PAY_FREQ_ABBRV , ' ' , A.CURRENCY_CD , ' ' , A.GRADE_FROM , ' ' , ' ' , A.GRADE_TO , ' ' , ' ' , A.STEP_FROM , ' ' , A.STEP_TO , ' ' FROM PS_HRS_JO_RQMT A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 2 | HRS_JO_RQMT_SEQ | Number(3,0) | SMALLINT NOT NULL | Job opening requirement sequence |
| 3 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 4 | HRS_JO_PRM_JCD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Primary job code for job opening
N=No Y=Yes |
| 5 | FLAG1 | Character(1) | VARCHAR2(1) NOT NULL | Flag1 |
| 6 | GVT_PAY_PLAN | Character(2) | VARCHAR2(2) NOT NULL | Pay Plan |
| 7 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL | Salary Administration Plan |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | HRS_BIP_SALAPDESCR | Character(40) | VARCHAR2(40) NOT NULL | Salary Admin Paln |
| 10 | HRS_JO_MIN_RT | Number(22,6) | DECIMAL(21,6) NOT NULL | Job opening minimum rate |
| 11 | HRS_JO_MAX_RT | Number(22,6) | DECIMAL(21,6) NOT NULL | Job opening maximum rate |
| 12 | PAY_FREQ_ABBRV | Character(1) | VARCHAR2(1) NOT NULL |
Pay Frequency
A=Annual B=Bi-weeky H=Hour M=Month Y=Year |
| 13 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 15 | DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Description |
| 16 | GRADE_FROM | Character(3) | VARCHAR2(3) NOT NULL | From Grade |
| 17 | DESCR3 | Character(30) | VARCHAR2(30) NOT NULL | Descr 3 |
| 18 | HRS_BIP_GRDFMDESCR | Character(40) | VARCHAR2(40) NOT NULL | Grade From |
| 19 | GRADE_TO | Character(3) | VARCHAR2(3) NOT NULL | To Grade |
| 20 | DESCR4 | Character(30) | VARCHAR2(30) NOT NULL | Descr 4 |
| 21 | HRS_BIP_GRDTODESCR | Character(40) | VARCHAR2(40) NOT NULL | Grade To |
| 22 | STEP_FROM | Number(2,0) | SMALLINT NOT NULL | Step |
| 23 | DESCR5 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |
| 24 | STEP_TO | Number(2,0) | SMALLINT NOT NULL | Step |
| 25 | DESCR6 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |