PSRECFIELD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFN
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: PSDBFIELD
3	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number
4	DEFRECNAME	Character(15)	VARCHAR2(15) NOT NULL	Default Record Name Prompt Table: PSRECDEFN
5	DEFFIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Default Field Name Prompt Table: PSDBFIELD
6	CURCTLFIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Currency Control Field Name Prompt Table: PSDBFIELD
7	EDITTABLE	Character(15)	VARCHAR2(15) NOT NULL	Edit Table Prompt Table: PSRECDEFN
8	USEEDIT	Number(10,0)	DECIMAL(10) NOT NULL	Field Use and Edit Flags- USEEDIT reference
9	USEEDIT2	Number(10,0)	DECIMAL(10) NOT NULL	More Field Use and Edit Flags
10	SUBRECORD	Character(1)	VARCHAR2(1) NOT NULL	Sub Record
11	SUBRECVER	Number(10,0)	DECIMAL(10) NOT NULL	Sub Record Version
12	SETCNTRLFLD	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Node User Key Field Name
13	DEFGUICONTROL	Number(2,0)	SMALLINT NOT NULL	Default GUI Control Default Value: 99
14	LABEL_ID	Character(18)	VARCHAR2(18) NOT NULL	LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
15	LASTUPDDTTM	DateTime(26)	TIMESTAMP	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.
16	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.
17	TIMEZONEUSE	Number(2,0)	SMALLINT NOT NULL	Time Zone Use Default Value: 0
18	TIMEZONEFIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Time Zone Field Name
19	RELTMDTFIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Related Time Date Field Name
20	CURRCTLUSE	Number(3,0)	SMALLINT NOT NULL	Currency Control Use