FF_ADDLCOLFRMT

(SQL Table)
 Index Back

Flat file column formats

Flat file column formatting details

# 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_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_DSNBR_THSNDFRMT Character(1) VARCHAR2(1) NOT NULL Number Column thousand separator format
N=No
Y=Yes
9 FF_DSNBR_NEGFRMT Character(1) VARCHAR2(1) NOT NULL Number Column negative format
N=No
Y=Yes
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_DSCHAR_FORMAT Character(1) VARCHAR2(1) NOT NULL Character Column format
L=Lower
P=Proper
U=Upper
12 FF_DSNBR_FORMAT Character(1) VARCHAR2(1) NOT NULL Number Column format
1=Thousand Separator
2=Bracket Negative Number
3=Decimal Comma Separator
4=Decimal Point Separator
13 FF_DSNBR_DECMLFRMT Character(1) VARCHAR2(1) NOT NULL Number Column decimal comma separator format
N=No
Y=Yes
14 FF_DTSEPARATOR Character(1) VARCHAR2(1) NOT NULL Date separator
15 FF_DSDT_FORMAT Character(1) VARCHAR2(1) NOT NULL Date Column format
0=YYYYMMDD
1=MMDDYYYY
2=DDMMYYYY
3=YYYYDDMM
4=YYMMDD
5=MMDDYY
6=DDMMYY
7=YYDDMM
16 FF_TMSEPARATOR Character(1) VARCHAR2(1) NOT NULL Flat file section � use column
17 FF_DSTM_FORMAT Character(2) VARCHAR2(2) NOT NULL Data source column format
12=12 hour
24=24 hour
18 FF_DSDTTM_FORMAT Character(2) VARCHAR2(2) NOT NULL Date Time Column format
0=YYYYMMDD HH12
1=YYYYMMDD HH24
10=MMDDYY HH12
11=MMDDYY HH24
12=DDMMYY HH12
13=DDMMYY HH24
14=YYDDMM HH12
15=YYDDMM HH24
2=MMDDYYYY HH12
3=MMDDYYYY HH24
4=DDMMYYYY HH12
5=DDMMYYYY HH24
6=YYYYDDMM HH12
7=YYYYDDMM HH24
8=YYMMDD HH12
9=YYMMDD HH24
19 FF_DSCOLLENGTH Number(5,0) INTEGER NOT NULL Flat file section
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