GB_REC_FIELD

(SQL Table)
 Index Back

Group Build Records and Fields

Group Build Records and Fields Table Main record of the Group Build Records and Fields. The record contains the record fields (including record name, record field, label name, and edit table) of the fields that can be used to define a group.

  • Related Language Record: GB_REC_FLD_LNG

    • # 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 FIELDLABEL Character(30) VARCHAR2(30) NOT NULL Field Label

    Default Value: PSDBFLDLABL_VW.LONGNAME

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

    Prompt Table: GB_RF_EDIT_VW

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

    Default Value: N