GP_COUNTRY

(SQL Table)
Index Back

GP Country Specific Parms

Global Payroll - Country Specific Parameter record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

2 RTO_MTHD Character(1) VARCHAR2(1) NOT NULL Default Retroactive Method
C=Corrective
F=Forwarding
3 RTO_MTHD_IF_CNFLCT Character(1) VARCHAR2(1) NOT NULL On Conflict Retroactive Method
C=Corrective
F=Forwarding
4 GP_BNK_CALC_MTHD Character(1) VARCHAR2(1) NOT NULL Controls whether the Payment Preparation process will correct prior period postings in place (N) or by posting the current periods values inclusive of any retroactive changes brought forward (Y)

Default Value: N

5 GP_GL_CALC_MTHD Character(1) VARCHAR2(1) NOT NULL Controls whether the GL process will correct prior period postings in place (N) or by posting the current periods values inclusive of any retroactive changes brought forward (Y)

Default Value: N

6 CHECK_DELTA_COMP Character(1) VARCHAR2(1) NOT NULL A flag whether to check the component when delta and store non-zero values.
N=Ignore Delta Component
Y=Check Delta Component

Default Value: N

7 PIN_NPV_FRML_NUM Number(8,0) INTEGER NOT NULL Net Pay Validation Formula

Default Value: 0

Prompt Table: GP_PIN_FM5_VW

8 PYE_OVRD_PRCS_OPTN Character(1) VARCHAR2(1) NOT NULL Payee Override Process Option identifies whether to prorate partial earnings deduction assignment during processing.
A=Active Anytime within Segment
E=Active as of Segment End Date

Default Value: E

9 ED_PRORATE_STRT_DT Date(10) DATE Earnings Deduction Assignment Proration Start Date. This is the date at which the Payee Override Process Option - Anytime within Segment is applicable. It is intended to prevent payee override (payee assignments) from being reprocessed differently during retro if desired.
10 GP_PYE_SOVR_OPTN Character(1) VARCHAR2(1) NOT NULL Payee Level SOVR option
E=By Slice
S=By Segment

Default Value: S

11 GP_MC_FLAG_CHE Character(1) VARCHAR2(1) NOT NULL Swiss Multi Contract process Flag

Y/N Table Edit

Default Value: N