GP_NRP_CNTRY_VW

(SQL View)
Index Back

Country Non-Rule Package View

Country - 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