EMPLIDCAL_RUN_IDORIG_CAL_RUN_IDPIN_NUMPIN_RTO_ADJ_NUMGPBR_DTA_PCT_VW(SQL View) |
Index Back |
|---|---|
Deltas Earnings DeductionsDeltas Earnings Deductions |
| SELECT DISTINCT A.EMPLID ,A.CAL_RUN_ID ,A.ORIG_CAL_RUN_ID ,A.PIN_NUM ,B.PIN_RTO_ADJ_NUM ,A.PCT_RSLT_VAL ,B.UNIT_DELTA_VAL ,B.CALC_DELTA_VAL ,B.RUN_TYPE FROM PS_GP_RSLT_ERN_DED A ,PS_GP_RSLT_DELTA B WHERE A.EMPLID=B.EMPLID AND A.CAL_RUN_ID=B.FWD2_CAL_RUN_ID AND A.CAL_RUN_ID<>A.ORIG_CAL_RUN_ID AND B.CAL_RUN_ID<>B.ORIG_CAL_RUN_ID AND A.ORIG_CAL_RUN_ID=B.ORIG_CAL_RUN_ID AND A.PIN_NUM=B.PIN_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 3 | ORIG_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 4 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 5 | PIN_RTO_ADJ_NUM |
Number(8,0) | INTEGER NOT NULL | Element number field |
| 6 | PCT_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Percent Result Value |
| 7 | UNIT_DELTA_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Unit Delta |
| 8 | CALC_DELTA_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount Delta |
| 9 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |