GP_CNTRY_PSLP_ASGNGP_PSLP_ASGN_CDSEQ_NUMA=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
Prompt Table: GP_COUNTRY
Prompt Table: GP_PSLP_TMPL
GP_PSLP_ASGN_PM(SQL Table) |
Index Back |
|---|---|
Payslip Template by Pay MethodAssign 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 |