GP_PG_DTL_SGPIN(SQL Table) |
Index Back |
|---|---|
Paygroup Details - INDThis is the paygroup record for India. 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 | GPIN_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: GPIN_RTYP_P_VW |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: GP_PYGRP_DTL.EFFDT |
| 4 | GPIN_PAYSLIP_ID | Character(18) | VARCHAR2(18) NOT NULL |
This field is used to uniquely identify a payslip template.
Prompt Table: GPIN_PSLP_ID_VW |
| 5 | PAY_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Pay Frequency
A=Annual B=Biweekly D=Daily M=Monthly Q=Quarterly S=Semimonthly W=Weekly Prompt Table: FREQUENCY_TBL |