GPJP_PP_PG_DTL(SQL Table) |
Index Back |
---|---|
Pay Group Pay Slip DetailThis record links pay groups and run types to pay slip templates. This allows the program to determine which pay slip template to use for a payee when generating pay slips. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP_OPR_VW |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Run Type Name
Prompt Table: GP_RUN_TYPE |
4 | GPJP_PAYSLIP_ID | Character(18) | VARCHAR2(18) NOT NULL |
Assigns a unique ID to a template used to generate pay slips.
Prompt Table: GPJP_PP_TMPL |