GP_PSLP_ASGN_PM

(SQL Table)
Index Back

Payslip Template by Pay Method

Assign a template according to pay method.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_CNTRY_PSLP_ASGN Character(3) VARCHAR2(3) NOT NULL Country
2 GP_PSLP_ASGN_CD Character(12) VARCHAR2(12) NOT NULL Assignment Code
3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
4 PAYMENT_MTHD Character(1) VARCHAR2(1) NOT NULL Payment Method
A=Cash
C=Check
O=Pay Primary Account Only
P=Postal Order
T=Bank Transfer
U=Use Normal Distribution
W=Wire Transfer

Prompt Table: GP_X_PMTMTH3_VW

5 GP_CNTRY_PSLP_TMPL Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: GP_COUNTRY

6 GP_PSLP_TMPL Character(12) VARCHAR2(12) NOT NULL This field is used to uniquely identify a payslip template.

Prompt Table: GP_PSLP_TMPL