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 |