GP_PSLP_NET_TMP

(SQL Table)
Index Back

Payslip Net Temporary Table

This temporary table stores the Net for the payslip

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 PMT_GRP_ID Number(3,0) SMALLINT NOT NULL Group Id for grouping payment
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
5 GP_PSLP_NET_PAY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field is the sum of all payments in a payslip
6 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
7 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
9 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
10 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
11 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
12 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
13 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
14 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
15 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
16 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
17 PYMT_DT Date(10) DATE Payment Date
18 PRD_BGN_DT Date(10) DATE Period Begin Date
19 PRD_END_DT Date(10) DATE Pay Period End Date
20 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
21 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
22 GP_PSLP_ID Character(40) VARCHAR2(40) NOT NULL Payslip Identifier
23 PAYMENT_MTHD1 Character(1) VARCHAR2(1) NOT NULL Zero Net payment method
N=Negative Net
Z=Zero Net
24 GP_PSLP_GEN_DT Date(10) DATE Date Payslip was Generated