GPES_PAYSLIP_HD(SQL Table) |
Index Back |
---|---|
Payslip HeaderName of the payslip setup |
# | 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 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
4 | GPES_RETRO_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Retroactivity Type
01=Two Payslips 02=Multiple Payslips 03=Single Payslip |
5 | GPES_EXTRA_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Payslip print extra period payslip in a separate page
Y/N Table Edit Default Value: Y |
6 | GPES_PSLIP_REPORT | Character(8) | VARCHAR2(8) NOT NULL |
Paysip layout
Prompt Table: PRCSDEFN |