SETIDHRS_PRM_JOBCODEHRS_JO_SALRN_I(SQL View) |
Index Back |
|---|---|
Salary Range ViewSalary Range View created for use in Job Posting Search Index Pre-Processing Library. |
| SELECT D.SETID ,D.JOBCODE ,D.std_hrs_frequency ,D.std_hours ,B.freq_annual_factor ,%DecMult(b.freq_annual_factor,D.std_hours) FROM PS_JOBCODE_TBL d , PS_FREQUENCY_TBL B WHERE D.EFFDT=( SELECT MAX(D_ED.EFFDT) FROM PS_JOBCODE_TBL D_ED WHERE D_ED.SETID = D.SETID AND D_ED.JOBCODE = D.JOBCODE AND D_ED.EFFDT <=%CurrentDateIn) AND B.FREQUENCY_ID=D.std_hrs_frequency AND B.EFFDT=( SELECT MAX(B_ED.EFFDT) FROM PS_FREQUENCY_TBL B_ED WHERE B_ED.FREQUENCY_ID = B.FREQUENCY_ID AND B_ED.EFFDT <= %CurrentDateIn) AND B.FREQ_ANNUAL_FACTOR<>0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | HRS_PRM_JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Primary Job Code of Job Opening. |
| 3 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL | Standard Work Period |
| 4 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 5 | FREQ_ANNUAL_FACTOR | Number(12,7) | DECIMAL(11,7) NOT NULL | Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year. |
| 6 | NUM_PRD | Number(16,6) | DECIMAL(15,6) NOT NULL | Period of Adjustment |