REQ_ACTIVITY

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID Default Value: NEXT
3	DUE_DT	Date(10)	DATE NOT NULL	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received. Default Value: %date
4	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number Default Value: 1
5	ENTERED_DT	Date(10)	DATE NOT NULL	Entered on Default Value: %date
6	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
7	SIGNED_OFF	Character(1)	VARCHAR2(1) NOT NULL	Signed Off Y/N Table Edit Default Value: N
8	SIGNED_DT	Date(10)	DATE	Signed Date
9	OPRID_SIGNED_BY	Character(30)	VARCHAR2(30) NOT NULL	Signed By
10	COMMENTS_LONG	Long Character	CLOB	Comment Text