PSFLDFIELDDEFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FLDDEFNNAME	Character(30)	VARCHAR2(30) NOT NULL	Definition Name (see PSFLDDEFN).
2	FLDSEGNAME	Character(15)	VARCHAR2(15) NOT NULL	Segment Name
3	FLDFIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name
4	FLDSTART	Number(5,0)	INTEGER NOT NULL	Starting Position
5	FLDLENGTH	Number(5,0)	INTEGER NOT NULL	Field Length
6	FLDOFFSET	Number(5,0)	INTEGER NOT NULL	Field Offset
7	FLDFIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type
8	DECIMAL_POS	Number(2,0)	SMALLINT NOT NULL	Decimal Position
9	FLDTAG	Character(30)	VARCHAR2(30) NOT NULL	XML End Tag
10	FLDSEQNO	Number(5,0)	INTEGER NOT NULL	Field Sequence Number
11	FLDSUPPRESS	Number(3,0)	SMALLINT NOT NULL	Suppress Field Flag
12	FLDDATEFMT	Character(30)	VARCHAR2(30) NOT NULL	Field Date Format
13	FLDDATESEPARATOR	Character(1)	VARCHAR2(1) NOT NULL	Field Date Separator
14	FLDQUALIFIER	Character(1)	VARCHAR2(1) NOT NULL	Field Qualifier
15	FLDTRIMSPACES	Number(3,0)	SMALLINT NOT NULL	Trim Trailing Spaces
16	FLDIPVSEG	Character(15)	VARCHAR2(15) NOT NULL	Inherit Parent Val SegmentName
17	FLDIPVFIELD	Character(18)	VARCHAR2(18) NOT NULL	Inherit Parent Val Field Name
18	FLDFIELDDFLT	Character(100)	VARCHAR2(100) NOT NULL	Field Default
19	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
20	FLDUPPER	Number(3,0)	SMALLINT NOT NULL	Convert to Upper Case
21	FLDSTRIPCHAR	Character(100)	VARCHAR2(100) NOT NULL	Strip Characters
22	PTFLDPADFIELD	Number(3,0)	SMALLINT NOT NULL	Pad Field