SEL_VALID_FIELD

(SQL Table)
 Index Back

Selector Group Valid Fields

  • Related Language Record: SELVALIDFIELDLN

  • Parent record: SEL_VALID_RECS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_CS.SETID

    Prompt Table: SP_SETID_NONVW

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

    Prompt Table: SEL_VALID_RECS

    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: RECFIELD_SF_VW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: PSDBFIELD_VW.FIELDNAME

    5 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table

    Default Value: PSRECFIELD_VW.EDITTABLE

    Prompt Table: RECDEFN_SF_VW

    6 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number