GP_COUNTRY(SQL Table) |
Index Back |
---|---|
GP Country Specific ParmsGlobal 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 |