GP_ABS_ERN_CRLV

(SQL View)
 Index Back

Abs Mgt PIN Earns w/CalcRule V

Abs Mgt PIN Earns w/CalcRule V

SELECT A.PIN_NUM , C.LANGUAGE_CD , B.EFFDT , C.PIN_NM , C.DESCR FROM PS_GP_PIN A , PS_GP_ERN_DED B , PS_GP_PIN_LANG C WHERE A.PIN_NUM = B.PIN_NUM AND A.PIN_NUM < 50000000 AND A.PIN_NUM = C.PIN_NUM AND A.PIN_TYPE='ER' AND (B.CALC_RULE = 'RU' OR B.CALC_RULE = 'RP')

  • Related Language Record for GP_ABS_ERN_CRVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description