GPES_FILFLD_LNG

(SQL Table)
 Index Back

Load flat file field setup

Input flat file record fields setup. GPES_FILE_CD: File code. GPES_REC_TYPE: Flat file record type. Required for files with several record layouts. GPES_FIELD_NUM: Field number. Provide enought gap between values. Cannot be changed (Remind this is also present in secondary table specified in GPES_FILE_DEFN.RECNAME0). GPES_FIELD_I: Flat file field starting position. GPES_FIELD_L: Flat file field length. GPES_FLD_TYP: Flat file field type. GPES_FLD_DEC: Flat file decimal positions for numeric fields. GPES_FLD_FMT: Flat file format for date fields. FIELDNAME: Table field name to store the flat file field value. Table name specified in GPES_FILE_DEFN.RECNAME (master table). GPES_FLD_LBL: Flat file field description. RECNAME_EDIT. Edit table name, or, code table name. FIELDNAME_KEY1: Edit table key field name, or, translate values field.

  • Related Language Record for GPES_FILE_FLD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPES_FILE_CD Character(8) VARCHAR2(8) NOT NULL File code
    2 GPES_REC_TYPE Character(8) VARCHAR2(8) NOT NULL Record type. Identifying with this different record layouts within the flat file.
    3 GPES_FIELD_NUM Number(6,0) INTEGER NOT NULL Field number/sequence within the record layout.
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 GPES_FLD_LBL Character(60) VARCHAR2(60) NOT NULL Flat file field label