RTBL_PURGE_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RTBL_ALOW_PURGE	Character(1)	VARCHAR2(1) NOT NULL	Allow Batch Data Purge Y/N Table Edit Default Value: Y
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	SCE_ID	Character(10)	VARCHAR2(10) NOT NULL	ID
6	RTBL_ID	Character(10)	VARCHAR2(10) NOT NULL	Scenario ID
7	RTBL_SCENARIO	Character(18)	VARCHAR2(18) NOT NULL	Scenario Name Prompt Table: RTBL_SCE_NAMEVW
8	RTBL_CLEANUP_OPTN	Character(1)	VARCHAR2(1) NOT NULL	RTBL Data Cleanup Options 1=Delete Output Rows 2=Reset Amount Columns
9	RECNAME1	Character(15)	VARCHAR2(15) NOT NULL	Record Name 1
10	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
11	PURGE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Purge History without Archive
12	COUNT_LINES	Number(15,0)	DECIMAL(15) NOT NULL	Count of Lines
13	RTBL	Character(1)	VARCHAR2(1) NOT NULL	RTBL Installed
14	OWNER_SCENARIO	Character(30)	VARCHAR2(30) NOT NULL	Owner
15	WHERE_TXT_LONG	Long Character(4000)	CLOB	Where clause
16	WHERE_TXT_LONG1	Long Character(4000)	CLOB	Where clause
17	RTBL_QUOTA_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Quota Status BT=Below Threshold ET=Threshold Reached YQ=Quota Reached
18	THRESHOLD_PCT	Number(3,0)	SMALLINT NOT NULL	Confidence %
19	PERCENTAGE_OWNED	Number(3,0)	SMALLINT NOT NULL	Percentage Minority Owned
20	RTBL_QUOTA	Number(20,4)	DECIMAL(19,4) NOT NULL	RTBL Quota Used (KB)
21	RTBL_DEF_ROWSIZE	Number(20,4)	DECIMAL(19,4) NOT NULL	Allotted System Quota (KB)
22	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage