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 ADV=Remittance Advice Only CAV=Check with Separate Advice CRA=Crystal Check w/Advice CRW=Crystal Check CSA=Check over Stub with Advice CSO=Check over Stub with Overflow EFA=EFT File with Advice EFT=EFT File SCA=Stub over Check with Advice SCO=Stub over Check with Overflow 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 Date and time
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