FORM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
2	FORM_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Form and Builder Field Prompt Table: FORM_TYPE
3	FORM_SUBJECT	Character(100)	VARCHAR2(100) NOT NULL	Subject
4	FORM_DESCRIPTION	Long Character	CLOB	Description
5	FORM_APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	work order approval status 0=All A=Approved C=Cancelled E=Denied H=On Hold I=Initial P=Pending Approval Default Value: I
6	FORM_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Priority 1=1-Critical 2=2-Urgent 3=3-Standard 4=4-Low Default Value: 3
7	FORM_DUE_DATE	Date(10)	DATE	Due Date
8	CREATED_BY	Character(30)	VARCHAR2(30) NOT NULL	Created By
9	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Datetime
10	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.
11	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.
12	EOFM_SUBMIT_BY	Character(30)	VARCHAR2(30) NOT NULL	Submit By
13	EOFM_SUBMIT_DTTM	DateTime(26)	TIMESTAMP	Submitted Datetime