PSNVSBOOK

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	REQUEST_URI	Long Character(1024)	VARCHAR2(1024)	Request URL
4	AS_OF_DT_OPTION	Character(1)	VARCHAR2(1) NOT NULL	As Of Reporting Date D=Default R=Business Unit Reporting Date T=Today's Date U=Specify Default Value: T
5	AS_OF_DATE	Date(10)	DATE	As of Date Default Value: %date
6	EFFDT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Tree As Of Date D=Default R=Use As Of Reporting Date U=Specify Default Value: R
7	TREE_EFFDT	Date(10)	DATE	Effective date of the Tree Default Value: %date
8	IGNORE_ERRORS	Character(1)	VARCHAR2(1) NOT NULL	Ignore Errors Y/N Table Edit Default Value: Y
9	PT_RETENTIONDAYS	Number(4,0)	SMALLINT NOT NULL	Retention Days Default Value: 0