GP_PINTYPE_VW

(SQL View)
Index Back

Element Type

This view selects Element Types. A view is needed to allow DESCRSHORT to be a list field. GP_PIN_TYPE does not have DESCRSHORT as a list field.

SELECT PIN_TYPE , DESCRSHORT FROM PS_GP_PIN_TYPE

  • Related Language Record: GP_PINTYPE_VL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type
    2 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description