GP_NRP_CNTRY_VW(SQL View) |
Index Back |
---|---|
Country Non-Rule Package ViewCountry - Packaging view |
SELECT COUNTRY ,RTO_MTHD ,RTO_MTHD_IF_CNFLCT ,GP_BNK_CALC_MTHD ,GP_GL_CALC_MTHD ,CHECK_DELTA_COMP ,PIN_NPV_FRML_NUM + 50000000 ,PYE_OVRD_PRCS_OPTN ,ED_PRORATE_STRT_DT ,GP_PYE_SOVR_OPTN ,GP_MC_FLAG_CHE FROM PS_GP_COUNTRY |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
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) |
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) |
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 |
7 | PIN_NPV_FRML_NUM | Number(8,0) | INTEGER NOT NULL | Net Pay Validation Formula |
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 |
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 |
11 | GP_MC_FLAG_CHE | Character(1) | VARCHAR2(1) NOT NULL |
Swiss Multi Contract process Flag
Y/N Table Edit Default Value: N |