TL_GP_ERN_LG_VW

(SQL View)
 Index Back

RelLngEarning View

This is the related language view for Earnings View

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

  • Related Language Record for TL_GP_ERN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 PIN_CODE Character(22) VARCHAR2(22) NOT NULL Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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