GP_COUNTRY (SQL Table)	Index Back
GP Country Specific Parms Global Payroll - Country Specific Parameter record.

GP_COUNTRY

(SQL Table)

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.

#	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.