EOEW_ARC_FLST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOEW_MAP_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Map Object
2	EOEW_SRC_OBJ	Character(30)	VARCHAR2(30) NOT NULL	Source Object
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	EOEW_SRC_TYP	Character(1)	VARCHAR2(1) NOT NULL	Source Type 0=Reserved 1=Record 2=Data Object
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
6	EOEW_SRCCOLALIAS	Character(30)	VARCHAR2(30) NOT NULL	Column Alias
7	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
8	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number
9	SUBRECNAME	Character(15)	VARCHAR2(15) NOT NULL	Subrecord (Table) Name
10	SUBRECORD	Character(1)	VARCHAR2(1) NOT NULL	Sub Record
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	USEEDIT	Number(10,0)	DECIMAL(10) NOT NULL	Field Use and Edit Flags- USEEDIT reference
13	KEY_FIELD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Key Field
14	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
15	LENGTH	Number(5,0)	INTEGER NOT NULL	Length
16	DECIMALPOS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
17	FORMAT	Number(2,0)	SMALLINT NOT NULL	Field Format 0= If Fieldtype=0 (Character) then Upper Case If Fieldtype=6 (DateTime) then HH:MM 1=Name 2=Phone Number North American (mandatory length 12 characters) 3=Zip/Postal Code North American (mandatory length 10 characters) 4=US Social Security Number (mandatory length 9 characters) 5= 6=Mixed Case 7=Raw/Binary 8=Numbers only 9=SIN (mandatory length 9 characters) 10=International Phone Number 11=Zip/Postal Code International 12=Time HH:MM:SS 13=Time HH:MM:SS.999999 14=Custom (FORMATFAMILY and DISPFMTNAME must be completed)
18	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
19	LASTUPDDTTM	DateTime(26)	TIMESTAMP NOT NULL	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. Default Value: %datetime
20	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.