GPUS_NRP_PSR_VW(SQL View) |
Index Back |
|---|---|
Payslip Packager ViewPackager View for the Payslip Temporary table |
| 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+50000000 , GPUS_PSLP_ELN_CAT , INSTANCE , PIN_CATEGORY , PAY_ENTITY , GP_CNTRY_PSLP_ELN , RSLT_VER_NUM , RSLT_REV_NUM , GP_ELN_SET , GPUS_PSLP_CURR_YTD , GPUS_PSLP_PRT_HRS , GPUS_PSLP_PRT_RATE , GP_PSLP_ORDER , SLICE_BGN_DT , GPUS_PSLP_TITLEOPT , GPUS_PSLP_TITLE , GPUS_PSLP_RES_DTL , SLICE_END_DT , CALC_RSLT_VAL , BASE_RSLT_VAL , RATE_RSLT_VAL , UNIT_RSLT_VAL , PCT_RSLT_VAL , USER_KEY1 , USER_KEY2 , USER_KEY3 , USER_KEY4 , USER_KEY5 , USER_KEY6 , COMPANY , SETID_DEPT , DEPTID , SETID_LOCATION , LOCATION , ESTABID , CONTRACT_NUM , PMT_GRP_ID , JOBINSTANCE FROM PS_GPUS_PSLP_RSLT |
| # | 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 | GPUS_PSLP_ELN_CAT |
Character(2) | VARCHAR2(2) NOT NULL |
Payslip ELN Categlroy
10=Hours and Earnings 20=Taxes 30=Before-Tax Deductions 40=After-Tax Deductions 50=Employer Paid Benefits 60=Gross to Net Accumulators 70=Absences |
| 13 | INSTANCE | Number(3,0) | SMALLINT NOT NULL | Instance Number |
| 14 | PIN_CATEGORY | Character(4) | VARCHAR2(4) NOT NULL | Element Category |
| 15 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 16 | GP_CNTRY_PSLP_ELN | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 17 | RSLT_VER_NUM | Number(4,0) | SMALLINT NOT NULL | Result Version Number |
| 18 | RSLT_REV_NUM | Number(4,0) | SMALLINT NOT NULL | Result Revision Number |
| 19 | GP_ELN_SET | Character(15) | VARCHAR2(15) NOT NULL | Element Set |
| 20 | GPUS_PSLP_CURR_YTD | Character(2) | VARCHAR2(2) NOT NULL |
Used by Payslip to indicate whether the amount prints in the current or year to date column.
10=Current 20=Year to Date |
| 21 | GPUS_PSLP_PRT_HRS | Character(1) | VARCHAR2(1) NOT NULL | Print Hours |
| 22 | GPUS_PSLP_PRT_RATE | Character(1) | VARCHAR2(1) NOT NULL | Payslip Print Rate component indicator |
| 23 | GP_PSLP_ORDER | Character(6) | VARCHAR2(6) NOT NULL | Payslip Order |
| 24 | SLICE_BGN_DT | Date(10) | DATE | Element Slice Begin Date |
| 25 | GPUS_PSLP_TITLEOPT | Character(2) | VARCHAR2(2) NOT NULL |
The payslip title
10=Element Description 20=Element Name 30=Report Data 40=Custom Title |
| 26 | GPUS_PSLP_TITLE | Character(16) | VARCHAR2(16) NOT NULL | Payslip Title |
| 27 | GPUS_PSLP_RES_DTL | Character(1) | VARCHAR2(1) NOT NULL | Show Multiple Resolution Detail |
| 28 | SLICE_END_DT | Date(10) | DATE | Element Slice End Date |
| 29 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
| 30 | BASE_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculated Base Value |
| 31 | RATE_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 32 | UNIT_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Number of units used in result calculation |
| 33 | PCT_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Percent Result Value |
| 34 | USER_KEY1 | Character(25) | VARCHAR2(25) NOT NULL | User Key 1 |
| 35 | USER_KEY2 | Character(25) | VARCHAR2(25) NOT NULL | User Key 2 |
| 36 | USER_KEY3 | Character(25) | VARCHAR2(25) NOT NULL | User Key 3 |
| 37 | USER_KEY4 | Character(25) | VARCHAR2(25) NOT NULL | User Key 4 |
| 38 | USER_KEY5 | Character(25) | VARCHAR2(25) NOT NULL | User Key 5 |
| 39 | USER_KEY6 | Character(25) | VARCHAR2(25) NOT NULL | User Key 6 |
| 40 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 41 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 42 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 43 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
| 44 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 45 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 46 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 47 | PMT_GRP_ID | Number(3,0) | SMALLINT NOT NULL | Group Id for grouping payment |
| 48 | JOBINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Job Instance |