index back

  • Parent record of PSRGWFLDOPT
  • PeopleSoft Field NameField TypeColumn TypeDescription
    INDEXNAMECharacter(30)VARCHAR2(30) NOT NULLName of Index for Collection

    Prompt Table: PSSIDXDEFN

    ZONEOPTCharacter(3)VARCHAR2(3) NOT NULLHow to zone the index
    FLD=Each field in own zone
    ONE=All data in one zone

    Default: ONE

    RGWIDX_SQLCharacter(200)VARCHAR2(200) NOT NULLWHERE clause to append
    VEGGIEKEYLong CharacterCLOBKey returned in search results
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFNPVW

    INCVWNAMECharacter(15)VARCHAR2(15) NOT NULLUpdate View Name

    Prompt Table: PSRECDEFN

    index back(c)David Kurtz 2019, 8.54
    PTRef generated on 09-JUN-19