GPBR_WTUN_ER_VW

(SQL View)
Index Back

WAGE TYPE ELEMENT VW

WAGE TYPE ELEMENT VW

SELECT DISTINCT A.GPBR_WAGE_TYPES_ID , A.PIN_ELEM_NUM , B.PIN_NM , B.DESCR FROM PS_GPBR_WAGTYP_DTL A , PS_GPBR_PIN_ER_VW B WHERE GPBR_UN_TYPE IN ('91') AND B.PIN_NUM = A.PIN_ELEM_NUM

  • Related Language Record: GPBR_WTUN_ER_VL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPBR_WAGE_TYPES_ID Character(8) VARCHAR2(8) NOT NULL Wages Types IDs for eSocial Brazil

    Prompt Table: GPBR_WAGE_TYPE

    2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    3 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description