GPDE_GR_VR_VL

(SQL View)
 Index Back

Garn Prompt View - Variable

Garn Prompt View - Variable

SELECT A.COUNTRY , E.PIN_NUM , C.PIN_NUM , B.PIN_NUM , F.LANGUAGE_CD , D.EFFDT , B.PIN_NM , B.DESCR FROM PS_GP_COUNTRY A , PS_GP_PIN B , PS_GP_VARIABLE D , PS_GP_ACM_MBR E , PS_GP_ERN_DED C , PS_GP_PIN_LANG F WHERE B.PIN_NUM = D.PIN_NUM AND B.PIN_NUM=F.PIN_NUM AND (B.USED_BY = 'A' OR (B.USED_BY = 'C' AND B.COUNTRY = A.COUNTRY)) AND (B.FLD_FMT = '4' OR B.FLD_FMT = '3') AND D.PIN_NUM = E.PIN_PCT_NUM AND E.PIN_MBR_NUM = C.PIN_NUM AND E.ENTRY_TYPE_ELEM IN ('ER0','DD0')

  • Related Language Record for GPDE_GR_VR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 GPDE_PIN_NUM_AC Number(8,0) INTEGER NOT NULL PIN Number Accumulator

    Prompt Table: GPDE_GR_AC_VW

    3 GPDE_PIN_NUM_ED Number(8,0) INTEGER NOT NULL PIN Number Deduction
    4 GPDE_PIN_NUM_VR Number(8,0) INTEGER NOT NULL Variable for Garnishment Earning/Deduction Override Handling.
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 EFFDT Date(10) DATE Effective Date
    7 GPDE_PIN_NM_VR Character(18) VARCHAR2(18) NOT NULL Var Name
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description