BPW_PURGE_REQ

(SQL Table)

# 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 BPW_PROC_STATUS Character(2) VARCHAR2(2) NOT NULL Process Status for Business Process Weaver. - Any change should be reflected in BUSINESS_PROCESS_WEAVER:ENUM:ProcessStatus - "Summarized" status is by xlate value so make so to choose the proper value for new status.
10=Skipped
15=Cancelled
20=Complete
22=Compl/Warning
25=Complete/Error
30=Paused After
40=Not Started
50=Paused Before
60=Started
70=On Hold
90=Error

4 DAYSBEFOREPURGE Number(3,0) SMALLINT NOT NULL Days Before Purge

5 ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.
Y/N Table Edit

6 LASTEXECDTTM DateTime(26) TIMESTAMP Date of Last Run

7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	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	BPW_PROC_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Process Status for Business Process Weaver. - Any change should be reflected in BUSINESS_PROCESS_WEAVER:ENUM:ProcessStatus - "Summarized" status is by xlate value so make so to choose the proper value for new status. 10=Skipped 15=Cancelled 20=Complete 22=Compl/Warning 25=Complete/Error 30=Paused After 40=Not Started 50=Paused Before 60=Started 70=On Hold 90=Error
4	DAYSBEFOREPURGE	Number(3,0)	SMALLINT NOT NULL	Days Before Purge
5	ENABLED	Character(1)	VARCHAR2(1) NOT NULL	A flag indicates whether this row is enabled or not. Y/N Table Edit
6	LASTEXECDTTM	DateTime(26)	TIMESTAMP	Date of Last Run
7	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance