HRS_JOB_OPENING_IDHRS_JO_SALRNG1(SQL View) |
Index Back |
|---|
| SELECT C.HRS_JOB_OPENING_ID , c.HRS_PRM_JOBCODE , D.std_hrs_frequency ,D.std_hours ,B.freq_annual_factor ,%DecMult(b.freq_annual_factor,D.std_hours) FROM PS_FREQUENCY_TBL B ,PS_HRS_JOB_OPENING C ,PS_JOBCODE_TBL d WHERE 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 AND 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 c.setid_dept=D.setid AND C.hrs_prm_jobcode=D.jobcode |
| # | 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_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 |