GP_NRP_CNTRY_AD(SQL Table) |
Index Back |
---|---|
GP Country Specific ParmsGlobal Payroll - Country Specific Parameter record. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GP_PKG_ID | Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
2 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
3 | RTO_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Default Retroactive Method
C=Corrective F=Forwarding |
4 | RTO_MTHD_IF_CNFLCT | Character(1) | VARCHAR2(1) NOT NULL |
On Conflict Retroactive Method
C=Corrective F=Forwarding |
5 | 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) |
6 | 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) |
7 | 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 |
8 | PIN_NPV_FRML_NUM | Number(8,0) | INTEGER NOT NULL | Net Pay Validation Formula |
9 | 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 |
10 | 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. |
11 | GP_PYE_SOVR_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Payee Level SOVR option
E=By Slice S=By Segment |
12 | GP_MC_FLAG_CHE | Character(1) | VARCHAR2(1) NOT NULL |
Swiss Multi Contract process Flag
Y/N Table Edit Default Value: N |