GP_SYSPIN_VW2

(SQL View)
 Index Back

System PIN Details View

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

SELECT B.PIN_NUM , A.SYSPIN_SRC , A.RECNAME , 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_PIN_NM_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    2 SYSPIN_SRC Character(1) VARCHAR2(1) NOT NULL System Element Source
    D=Database Field
    S=System-Computed
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    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