GP_CNTRY_PSLP_TMPLPrompt Table: GP_COUNTRY
GP_PSLP_TMPLEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
DEPT=Department Address
HOME=Home Address
LOCN=Location Address
MAIL=Mailing Address
Default Value: MAIL
GP_PSLP_TMPLDTL(SQL Table) |
Index Back |
|---|---|
Payslip Template DetailPayslip Template Detail table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_CNTRY_PSLP_TMPL |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_COUNTRY |
| 2 | GP_PSLP_TMPL |
Character(12) | VARCHAR2(12) NOT NULL | This field is used to uniquely identify a payslip template. |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | GP_PSLP_DFLT_ADDR | Character(4) | VARCHAR2(4) NOT NULL |
Default delivery address for employees that are assigned a payslip template
DEPT=Department Address HOME=Home Address LOCN=Location Address MAIL=Mailing Address Default Value: MAIL |