PROCESS_INSTANCEEMPLIDCAL_RUN_IDEMPL_RCDGP_PAYGROUPCAL_IDORIG_CAL_RUN_IDRSLT_SEG_NUMGP_RPT_KEYSEQ_NUMPIN_NUMSLICE_END_DTUSER_KEY1PIN_CODE1=Original
2=Recalculation
3=Prior Calculation
4=Last Version/Revision
GPTH_RPT_D_VW(SQL View) |
Index Back |
|---|---|
Results Register Detail ViewResults Register Detail View |
| SELECT PROCESS_INSTANCE , EMPLID , CAL_RUN_ID , EMPL_RCD , GP_PAYGROUP , CAL_ID , ORIG_CAL_RUN_ID , RSLT_SEG_NUM , GP_RPT_KEY , SEQ_NUM , PIN_NUM , SLICE_END_DT , USER_KEY1 , PIN_CODE , INSTANCE , OFF_CYCLE , GP_RPT_RETRO , ACM_FROM_DT , ACM_THRU_DT , SLICE_BGN_DT , (CALC_RSLT_VAL + USER_ADJ_VAL) AS CALC_RSLT_VAL , BASE_RSLT_VAL , RATE_RSLT_VAL , UNIT_RSLT_VAL , PCT_RSLT_VAL , RSLT_ADD_ARR , RSLT_NOT_TKN , RSLT_PAYBK , RSLT_XFER_VAL , BASE_ADJ_VAL , CALC_ADJ_VAL , UNIT_ADJ_VAL , USER_ADJ_VAL , USER_KEY2 , USER_KEY3 , USER_KEY4 , USER_KEY5 , USER_KEY6 , PIN_TYPE , PIN_NM , PIN_CUSTOM1 FROM PS_GPTH_RPT_D_TMP E WHERE E.SLICE_END_DT=( SELECT MAX(E_ED.SLICE_END_DT) FROM PS_GPTH_RPT_D_TMP E_ED WHERE E.PROCESS_INSTANCE=E_ED.PROCESS_INSTANCE AND E.EMPLID=E_ED.EMPLID AND E.EMPL_RCD=E_ED.EMPL_RCD AND E.PIN_CODE=E_ED.PIN_CODE AND E.USER_KEY1=E_ED.USER_KEY1) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 5 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 6 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 7 | ORIG_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 8 | RSLT_SEG_NUM |
Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 9 | GP_RPT_KEY |
Character(22) | VARCHAR2(22) NOT NULL | Output Result Key |
| 10 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 11 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 12 | SLICE_END_DT |
Date(10) | DATE | Element Slice End Date |
| 13 | USER_KEY1 |
Character(25) | VARCHAR2(25) NOT NULL | User Key 1 |
| 14 | PIN_CODE |
Character(22) | VARCHAR2(22) NOT NULL | Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN) |
| 15 | INSTANCE | Number(3,0) | SMALLINT NOT NULL | Instance Number |
| 16 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |
| 17 | GP_RPT_RETRO | Character(1) | VARCHAR2(1) NOT NULL |
Retroactivity Type
1=Original 2=Recalculation 3=Prior Calculation 4=Last Version/Revision |
| 18 | ACM_FROM_DT | Date(10) | DATE | From Date |
| 19 | ACM_THRU_DT | Date(10) | DATE | Through Date |
| 20 | SLICE_BGN_DT | Date(10) | DATE | Element Slice Begin Date |
| 21 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
| 22 | BASE_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculated Base Value |
| 23 | RATE_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 24 | UNIT_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Number of units used in result calculation |
| 25 | PCT_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Percent Result Value |
| 26 | RSLT_ADD_ARR | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount Added To Arrears |
| 27 | RSLT_NOT_TKN | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount Not Taken |
| 28 | RSLT_PAYBK | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Payback Amount Result |
| 29 | RSLT_XFER_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Bank Transfer Value of Deduct |
| 30 | BASE_ADJ_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Base Adjustment |
| 31 | CALC_ADJ_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Adjustment Value |
| 32 | UNIT_ADJ_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Unit Adjustment |
| 33 | USER_ADJ_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | User Adjustment Value |
| 34 | USER_KEY2 | Character(25) | VARCHAR2(25) NOT NULL | User Key 2 |
| 35 | USER_KEY3 | Character(25) | VARCHAR2(25) NOT NULL | User Key 3 |
| 36 | USER_KEY4 | Character(25) | VARCHAR2(25) NOT NULL | User Key 4 |
| 37 | USER_KEY5 | Character(25) | VARCHAR2(25) NOT NULL | User Key 5 |
| 38 | USER_KEY6 | Character(25) | VARCHAR2(25) NOT NULL | User Key 6 |
| 39 | PIN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Element Type |
| 40 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 41 | PIN_CUSTOM1 | Character(20) | VARCHAR2(20) NOT NULL | Customer FIelds |