GPES_PSLPAP_LNG(SQL Table) |
Index Back |
---|---|
Payslip Contributions LangThis table is used to store the deductions that are used to print the social security constribution lines |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPES_PAYSLIP_ID | Character(6) | VARCHAR2(6) NOT NULL | Pay Slip Identification |
2 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
3 | GPES_PIN_PS1_NUM | Number(8,0) | INTEGER NOT NULL |
Pay slip Pin Number
Prompt Table: GP_PIN_DD0_VW |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |