GPES_PSLPTMP_VW

(SQL View)
Index Back

Pay Slip Temp Table

Pay 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