GPES_PSLPTMP_VW(SQL View) |
Index Back |
---|---|
Pay Slip Temp TablePay Slip Temp table view to build the field GP_PSLP_ID in order to be utilized where necessary, mainly SQRs. Constructing the field GP_PSLP_ID needs of platform dependent syntax that is complex to manage in SQRs. Using this view will benefit of metasql wrappers. |
SELECT OPRID , RUN_CNTL_ID , EMPLID , CAL_RUN_ID , EMPL_RCD , GP_PAYGROUP , CAL_ID , ORIG_CAL_RUN_ID , RSLT_SEG_NUM , GPES_FIELDNAME1 , GPES_FIELDNAME2 , GPES_FIELDNAME3 , GPES_FIELDNAME4 , GPES_FIELDNAME5 , GPES_PAYSLIP_ID , GPES_EXTRA_PERIOD , EFFDT_USED , GPES_PYSL_SK_ORD1 , GPES_PYSL_SK_ORD2 , GPES_PYSL_SK_ORD3 , GPES_PYSL_SK_ORD4 , GPES_PYSL_SK_ORD5 , RSLT_VER_NUM , RSLT_REV_NUM , PYMT_DT , PYMT_KEY1 , PYMT_KEY2 , PYMT_KEY3 , PYMT_KEY4 , PRD_BGN_DT , PRD_END_DT , SEG_BGN_DT , SEG_END_DT , PIN_GROSS_VAL , PIN_NET_VAL , PYE_CALC_STAT , SEL_STAT , CALC_ACTION , GP_TX_TYPE , SEL_ACTION , RUN_TYPE , PRC_ORD_TS , CAL_ID %Concat '_' %Concat GP_PAYGROUP %Concat '_' %Concat %NumToChar(EMPL_RCD) %Concat '_' %Concat %NumToChar(RSLT_SEG_NUM) FROM PS_GPES_PSLIP_TMP |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
4 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
6 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
7 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
8 | ORIG_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
9 | RSLT_SEG_NUM | Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
10 | GPES_PAYSLIP_ID | Character(6) | VARCHAR2(6) NOT NULL | Pay Slip Identification |
11 | GPES_FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Payslip order by field name #1 |
12 | GPES_FIELDNAME2 | Character(18) | VARCHAR2(18) NOT NULL | Payslip order by field name #2 |
13 | GPES_FIELDNAME3 | Character(18) | VARCHAR2(18) NOT NULL | Payslip order by field name #3 |
14 | GPES_FIELDNAME4 | Character(18) | VARCHAR2(18) NOT NULL | Payslip order by field name #4 |
15 | GPES_FIELDNAME5 | Character(18) | VARCHAR2(18) NOT NULL | Payslip order by field name #5 |
16 | GPES_EXTRA_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Payslip print extra period payslip in a separate page
Y/N Table Edit |
17 | EFFDT_USED | Date(10) | DATE | Date driving 'processed' code |
18 | GPES_PYSL_SK_ORD1 | Character(4) | VARCHAR2(4) NOT NULL |
Pay slip sort Key 1
ASC=Ascending DESC=Descending |
19 | GPES_PYSL_SK_ORD2 | Character(4) | VARCHAR2(4) NOT NULL |
Pay slip sort Key 2
ASC=Ascending DESC=Descending |
20 | GPES_PYSL_SK_ORD3 | Character(4) | VARCHAR2(4) NOT NULL |
Pay slip sort Key 3
ASC=Ascending DESC=Descending |
21 | GPES_PYSL_SK_ORD4 | Character(4) | VARCHAR2(4) NOT NULL |
Pay slip sort Key 4
ASC=Ascending DESC=Descending |
22 | GPES_PYSL_SK_ORD5 | Character(4) | VARCHAR2(4) NOT NULL |
Pay slip sort Key 5
ASC=Ascending DESC=Descending |
23 | RSLT_VER_NUM | Number(4,0) | SMALLINT NOT NULL | Result Version Number |
24 | RSLT_REV_NUM | Number(4,0) | SMALLINT NOT NULL | Result Revision Number |
25 | PYMT_DT | Date(10) | DATE | Payment Date |
26 | PYMT_KEY1 | Character(25) | VARCHAR2(25) NOT NULL | Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number |
27 | PYMT_KEY2 | Character(25) | VARCHAR2(25) NOT NULL | Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number |
28 | PYMT_KEY3 | Character(25) | VARCHAR2(25) NOT NULL | Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number |
29 | PYMT_KEY4 | Character(25) | VARCHAR2(25) NOT NULL | Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number |
30 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
31 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
32 | SEG_BGN_DT | Date(10) | DATE | Payee Process Segment's Begin Date |
33 | SEG_END_DT | Date(10) | DATE | Payee Process Segment's End Date |
34 | PIN_GROSS_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Gross Pay Value |
35 | PIN_NET_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Net Pay Value |
36 | PYE_CALC_STAT | Character(2) | VARCHAR2(2) NOT NULL |
Calculation Status: field indicates the processing status of a segment (payment)
00=Identified 02=Calculation Error 03=Calculation Error - Bypassed 04=Calculation Error - By Rule 11=No Segment Created 50=Calculation Successful 55=Frozen For Further Calc 70=Finalized 75=Finalized - With Banking |
37 | SEL_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Indicates status of the selected payee in a Calendar Group
As they are identified payees are pulled in either as Active or Inactive based on the EMPL_STATUS.
The system or the user can remove a payee either permanently or temporarily for various reasons. These are indicated by the status values other than Active and Inactive.
A=Active C=Cancelled I=Inactive S=System Suspend U=User Suspend |
38 | CALC_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Calculate Action
C=Calculate R=Calculate and Replace V=Reverse W=Reverse and Replace |
39 | GP_TX_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Type (introduced with Off-cycle). Identifies an offcycle request as correction,manual payment, unscheduled payment or advance.
XLAT values are assigned to support batch processing order
A=Advance M=Manual Payment R=Correction U=Additional Payment |
40 | SEL_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Select Action
A=Retro Add C=Current Calculation R=Retro Recalc V=Retro Reversal Z=Retro Rvr & Recalc |
41 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
42 | PRC_ORD_TS | DateTime(26) | TIMESTAMP | Process Order Timestamp |
43 | GP_PSLP_ID | Character(40) | VARCHAR2(40) NOT NULL | Payslip Identifier |