GP_PG_DTL_SGPIN

(SQL Table)
Index Back

Paygroup Details - IND

This 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