GPES_CRAPTYP_VW

(SQL View)
 Index Back

Elem Grp Ent Types

Pin types that can be used in element groups of type application

SELECT DISTINCT %Substring(PR.ENTRY_TYPE_ID, 1, 2) , ET.DESCR FROM PS_GP_ENTRY_PRMPT2 PR , PS_GP_ENTRY_TYPE ET WHERE PR.ENTRY_PRMPT_ID = 'GP_ENT_EGELN_VW' AND PR.ENTRY_PROMPT_IND = 'Y' AND ET.ENTRY_TYPE_ID = %Substring(PR.ENTRY_TYPE_ID, 1, 2) %Concat '0'

  • Related Language Record: GPES_CRATYP_LNG

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