GP_PSLP_GDE_HST

(SQL Table)
Index Back

Payslip Guide Table

This record is the guide table for Global Payroll Payslips.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

Prompt Table: GP_CAL_RUN

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 GP_PSLP_ID Character(40) VARCHAR2(40) NOT NULL Payslip Identifier
6 PMT_GRP_ID Number(3,0) SMALLINT NOT NULL Group Id for grouping payment
7 GP_CNTRY_PSLP_TMPL Character(3) VARCHAR2(3) NOT NULL Country
8 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
9 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
10 GP_PSLP_TMPL Character(12) VARCHAR2(12) NOT NULL This field is used to uniquely identify a payslip template.
11 GP_CNTRY_PSLP_TMSS Character(3) VARCHAR2(3) NOT NULL ePay Template Country
12 GP_PSLP_TMPL_SS Character(12) VARCHAR2(12) NOT NULL ePay Template (Self Service)
13 GP_PSLP_PRINT_IND Character(1) VARCHAR2(1) NOT NULL Payslip Generated Indicator

Y/N Table Edit

Default Value: N

14 GP_PSLP_SS_IND Character(1) VARCHAR2(1) NOT NULL Self Service Payslip Generated

Y/N Table Edit

Default Value: N

15 GP_PSLP_NET_PAY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field is the sum of all payments in a payslip
16 GP_PSLP_GDE_STAT Character(2) VARCHAR2(2) NOT NULL Payslip Guide Status
10=Active
20=Inactive
17 GP_PSLP_GEN_DT Date(10) DATE Date Payslip was Generated