GP_AB_ERNDED_VW

(SQL View)
 Index Back

GP_AB_ERNDED_VW

GP_AB_ERNDED_VW

SELECT DISTINCT a.pin_nm ,a.descr ,a.pin_type FROM ps_gp_pin A , PS_GP_ABS_ANLY_GEN b WHERE a.pin_num= b.pin_num AND a.pin_type IN ('ER','DD')

  • Related Language Record: GP_AB_ERDD_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type