GP_PAYGROUPDefault Value: GP_PYGRP_DTL.GP_PAYGROUP
EFFDTDefault Value: GP_PYGRP_DTL.EFFDT
Prompt Table: GPNZ_RTYP_P_VW
Prompt Table: GPNZ_PSLP
GP_PG_DTL_SGPNZ(SQL Table) |
Index Back |
|---|---|
Paygroup Details - nzlThis is the paygroup record for New Zealand. It is a sibling to the GP_PYGRP_DTL table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Default Value: GP_PYGRP_DTL.GP_PAYGROUP |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: GP_PYGRP_DTL.EFFDT |
| 3 | GPNZ_REG_RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
The Regular Run Type identifies a single Run Type that will be used when determining when an Advance Payment is to be made.
The Advance calculation will use the dates from Calendars of the is Run Type to determine which Calendar Group the advance should be paid in.
Prompt Table: GPNZ_RTYP_P_VW |
| 4 | GPNZ_PAYSLIP_ID | Character(18) | VARCHAR2(18) NOT NULL |
This field is used to uniquely identify a payslip template.
Prompt Table: GPNZ_PSLP |