GB_PRE_REQ_FLD

(SQL Table)
 Index Back

GB Rec Fld - Prereq Fields Tb

Group Build Records and Fields - Prerequisite Fields Table Child record of the Group Build Records and Fields (GB_REC_FIELD). The record contains the required prompt fields and the equivalent record fields of a record field in the Group Build Records and Fields.

  • Related Language Record: GB_PRE_RQFLD_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: GB_REC_FIELD_VW

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

    Prompt Table: GB_RF_FIELD_VW

    3 GB_PROMPT_FIELD Character(18) VARCHAR2(18) NOT NULL Required for Prompt

    Prompt Table: GB_RF_VALUE_VW

    4 FIELDLABEL Character(30) VARCHAR2(30) NOT NULL Field Label

    Default Value: PSDBFLDLABL_VW.SHORTNAME

    5 GB_RECORD_FIELD Character(18) VARCHAR2(18) NOT NULL Name of related Record Field

    Prompt Table: GB_RF_FIELD_VW

    6 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type CD
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N