FF_DSCOLUMN

(SQL Table)
 Index Back

Flat file group columns

Flat file section columns

  • Parent record: FF_SECTIONS

    • # 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_SECTIONID Character(30) VARCHAR2(30) NOT NULL Flat file section type
    4 FF_SECTIONTYPE Character(1) VARCHAR2(1) NOT NULL Flat file section type
    1=Header
    2=Detail
    3=Group
    4=Trailer
    5 FF_SUBSECTION Character(1) VARCHAR2(1) NOT NULL Flat file subsection type
    A=Additional Record
    D=Group Detail
    H=Group Header
    N=None
    T=Group Trailer
    6 FF_DSCOLFLD Character(30) VARCHAR2(30) NOT NULL Flat file data source field
    7 FF_GROUPBY Character(1) VARCHAR2(1) NOT NULL Flat file Group By
    N=No
    Y=Yes

    Default Value: N

    8 FF_GROUPBY_ORDER Number(5,0) INTEGER NOT NULL Flat file Group by order
    9 FF_DSCOLNAME Character(254) VARCHAR2(254) NOT NULL Flat file data source column
    10 FF_DSCOLTYPE Character(1) VARCHAR2(1) NOT NULL Flat file data source column type
    0=Character
    1=Long Character
    2=Number
    3=Signed Number
    4=Date
    5=Time
    6=DateTime
    11 FF_COLVAR_IND Character(1) VARCHAR2(1) NOT NULL Flat file column type variable indicator
    N=No
    Y=Yes

    Default Value: N

    12 FF_QRYCOLNUM Number(3,0) SMALLINT NOT NULL Flat file query column number
    13 FF_DSCOLUSE Character(1) VARCHAR2(1) NOT NULL Flat file section � use column
    N=No
    Y=Yes

    Default Value: N

    14 FF_DSCOLSEQ Number(3,0) SMALLINT NOT NULL Flat file data source column sequence
    15 FF_DSCOLUMNALIAS Character(30) VARCHAR2(30) NOT NULL Label
    16 FF_ADDLREC_IND Character(1) VARCHAR2(1) NOT NULL Flat file column additional record indicator
    N=No
    Y=Yes

    Default Value: N

    17 FF_DSCOLLENGTH Number(5,0) INTEGER NOT NULL Flat file section
    18 FF_DSCOL_SRC_LEN Number(5,0) INTEGER NOT NULL Flat file section
    19 FF_DSCOLABEL Character(100) VARCHAR2(100) NOT NULL Data Fields

    Prompt Table: FF_VRBL_DEF1_VW

    20 FF_DSCOLALIGN Character(1) VARCHAR2(1) NOT NULL Flat file column alignment
    L=Left
    R=Right
    21 FF_DSCOLPAD Character(1) VARCHAR2(1) NOT NULL Flat file column pad
    22 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N