FF_SETTINGS

(SQL Table)
 Index Back

Flat file settings

Flat file settings

  • Related Language Record: FF_SETTING_LNG

  • Parent Record Of FF_FILE_INF_DVW FF_FILE_INF_LNG FF_FILE_INF_VW FF_FILE_RUN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FF_FILE_NAME Character(30) VARCHAR2(30) NOT NULL Flat file name
    2 FF_VERSION Character(30) VARCHAR2(30) NOT NULL Message Version
    3 FF_FILE_STATUS Character(1) VARCHAR2(1) NOT NULL File status
    A=Active
    I=Inactive
    P=In Progress

    Default Value: P

    4 FF_ACCESSID Character(18) VARCHAR2(18) NOT NULL Access ID

    Prompt Table: FF_ACCESS

    5 FF_FIXEDRECBLK Character(1) VARCHAR2(1) NOT NULL Flat file fixed record blocks
    N=No
    Y=Yes
    6 FF_BLKFACTOR Number(3,0) SMALLINT NOT NULL Flat file blocking factor
    7 FF_DS_TYPE Character(3) VARCHAR2(3) NOT NULL Flat file data source
    QRY=PS Query

    Default Value: QRY

    8 FF_CATEGORY Character(30) VARCHAR2(30) NOT NULL Category

    Prompt Table: FF_CATEGORY_VW

    9 FF_FILE_TYPE Character(1) VARCHAR2(1) NOT NULL File Type
    D=Delimited
    F=Fixed

    Default Value: D

    10 FF_DELIMITER Character(1) VARCHAR2(1) NOT NULL Flat file delimiter
    C=Comma
    N=Semicolon
    S=Space
    T=Tab
    U=Other

    Default Value: C

    11 FF_USERDELIMITER Character(1) VARCHAR2(1) NOT NULL User Delimiter
    12 FF_QUALIFIER Character(1) VARCHAR2(1) NOT NULL Flat file qualifier
    13 FF_BLKFILL Long Character CLOB Record Fill
    14 FF_ADDLREC_IND Character(1) VARCHAR2(1) NOT NULL Flat file column additional record indicator
    N=No
    Y=Yes

    Default Value: N

    15 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    16 DESCRLONG Long Character CLOB Long Description
    17 FF_FILE_DEST Character(1) VARCHAR2(1) NOT NULL Flat file destination
    D=Report Manager
    P=File Path
    U=URL

    Default Value: D

    18 FF_FILE_PATH Character(250) VARCHAR2(250) NOT NULL Flat file destination
    19 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).

    Prompt Table: PSURLDEFN

    20 FF_USERFILENAME Character(64) VARCHAR2(64) NOT NULL Output File Name
    21 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    22 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    23 FF_CREATED_DTTM DateTime(26) TIMESTAMP Created Date/Time
    24 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    25 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N