GPES_FILE_FLD

(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 present in both master and secondary tables specified in GPES_FILE_DEFN.RECNAME and GPES_FILE_DEFN.RECNAME_FILE). 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 label/description. RECNAME_EDIT. Edit table name, or, code table name. FIELDNAME_KEY1: Edit table key field name, or, translate values field.

  • Related Language Record: GPES_FILFLD_LNG

    • # 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 GPES_FIELD_I Number(4,0) SMALLINT NOT NULL Flat file field beginnig position
    5 GPES_FIELD_L Number(3,0) SMALLINT NOT NULL Flat file field length
    6 GPES_FLD_TYP Character(1) VARCHAR2(1) NOT NULL Flat file field type
    A=Alphabetic
    D=Date
    N=Numeric
    X=Alphanumeric
    7 GPES_FLD_DEC Character(1) VARCHAR2(1) NOT NULL Flat file field decimal positions
    8 GPES_FLD_FMT Character(4) VARCHAR2(4) NOT NULL Flat file field format for date type fields
    DD=Day
    DY2=DDMMYY
    DY2-=DD-MM-YY
    DY2/=DD/MM/YY
    DY4=DDMMYYYY
    DY4-=DD-MM-YYYY
    DY4/=DD/MM/YYYY
    MM=Month
    MY2=MMDDYY
    MY2-=MM-DD-YY
    MY2/=MM/DD/YY
    MY4=MMDDYYYY
    MY4-=MM-DD-YYYY
    MY4/=MM/DD/YYYY
    NONE=None
    Y2=YYMMDD
    Y2-=YY-MM-DD
    Y2/=YY/MM/DD
    Y4=YYYYMMDD
    Y4-=YYYY-MM-DD
    Y4/=YYYY/MM/DD
    YY=Year (2)
    9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSRECFIELDALL

    10 GPES_FLD_LBL Character(60) VARCHAR2(60) NOT NULL Flat file field label
    11 RECNAME_EDIT Character(15) VARCHAR2(15) NOT NULL Edit Table for Record

    Prompt Table: %EDITTABLE

    12 FIELDNAME_KEY1 Character(18) VARCHAR2(18) NOT NULL Field created for use with element packager

    Prompt Table: %EDITTABLE2