FS_FLAT_FILE

(SQL Table)
Index Back

  • Related Language Record: FS_FF_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FS_FF_LAYOUT_ID Character(20) VARCHAR2(20) NOT NULL Layout ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 FS_FF_FLD_DLMT Character(5) VARCHAR2(5) NOT NULL Field Delimiter
    4 FS_FF_SUBF_DLMT Character(5) VARCHAR2(5) NOT NULL Sub-Field Delimiter
    5 FS_FF_REC_DLMT Character(5) VARCHAR2(5) NOT NULL Record Delimiter
    6 FS_FF_RET_FOLLOW Character(1) VARCHAR2(1) NOT NULL Add Line Feed

    Y/N Table Edit

    Default Value: Y

    7 FS_FF_COMMENT Character(5) VARCHAR2(5) NOT NULL Comment
    8 IB_PACKAGEID Character(100) VARCHAR2(100) NOT NULL Referenced Package

    Prompt Table: PSLSDEFNPACK_VW

    9 IB_SCHEMANAME Character(100) VARCHAR2(100) NOT NULL Document Name

    Prompt Table: PSLSDEFNSRCH_VW

    10 IB_VARIANTNAME Character(30) VARCHAR2(30) NOT NULL Version Name

    Prompt Table: FS_DEFNVARS_VW

    11 FS_MAP_UPLD_PB Character(1) VARCHAR2(1) NOT NULL PS Document Builder
    12 FS_MAP_DOC_LD_PB Character(1) VARCHAR2(1) NOT NULL Display Document
    13 FS_MAP_TITLE_PRINT Character(1) VARCHAR2(1) NOT NULL Insert Column Header

    Y/N Table Edit

    Default Value: N

    14 TREECTLEVENT Character(46) VARCHAR2(46) NOT NULL Tree Control Event