FF_ADDLDSCOLUMN

(SQL Table)
 Index Back

  • Parent record: FF_DSCOLUMN

    • # 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

    Default Value: N

    6 FF_CNTRLFLD Character(30) VARCHAR2(30) NOT NULL Flat file data source addenda control field
    7 FF_DSCOLFLD Character(30) VARCHAR2(30) NOT NULL Flat file data source field
    8 FF_CNTRLVAL Character(100) VARCHAR2(100) NOT NULL Flat file data source addenda control field
    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
    14 FF_DSCOLSEQ Number(3,0) SMALLINT NOT NULL Flat file data source column sequence
    15 FF_DSCOLLENGTH Number(5,0) INTEGER NOT NULL Flat file section
    16 FF_DSCOLABEL Character(100) VARCHAR2(100) NOT NULL Data Fields

    Prompt Table: FF_VRBLDEF_A_VW

    17 FF_DSCOLALIGN Character(1) VARCHAR2(1) NOT NULL Flat file column alignment
    L=Left
    R=Right
    18 FF_DSCOLPAD Character(1) VARCHAR2(1) NOT NULL Flat file column pad
    19 FF_COLVARVAL Character(100) VARCHAR2(100) NOT NULL Flat file column variable Value
    20 FF_ADD_INLINE Character(1) VARCHAR2(1) NOT NULL Print addenda record inline
    N=No
    Y=Yes

    Default Value: N

    21 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N