GP_SYSPIN_VW

(SQL View)
 Index Back

System PIN Details View

This view selects System Pins from the System Element definition table.

SELECT A.SYSPIN_SRC , A.RECNAME , B.PIN_NUM , B.PIN_NM , A.FIELDNAME , A.SYSPIN_SETID_IND , A.PIN_SETID_NUM , A.PROMPTVIEW FROM PS_GP_SYSTEM_PIN A , PS_GP_PIN B WHERE A.PIN_NUM = B.PIN_NUM

  • Related Language Record: GP_SYSPIN_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SYSPIN_SRC Character(1) VARCHAR2(1) NOT NULL System Element Source
    D=Database Field
    S=System-Computed

    Default Value: D

    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    4 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSRECFIELD_VW

    6 SYSPIN_SETID_IND Character(1) VARCHAR2(1) NOT NULL SetID Controlled

    Y/N Table Edit

    7 PIN_SETID_NUM Number(8,0) INTEGER NOT NULL Element number field
    8 PROMPTVIEW Character(18) VARCHAR2(18) NOT NULL Element Entry Prompt View