SCC_CG_CLRPRCVW (SQL View)	Index Back
COMMGEN Processes to Clear View of SCC_COMMGEN processes that are available for clearing/resetting. This is in lieu of disabling restart on the App Engine. Processing Statuses limited to: Deleted, Error, Cancelled, Success, Not Successful, and Successful w/ Warning. In the case of a process in Error, Not Successful, Cancelled or Deleted, temporary processing tables used by the App Engine program SCC_COMMGEN need to be cleared; and the Communication record needs to be reset. In the case of Success or Success w/ Warning, users may want to re-run the Communication Generation process again, therefore needing the Communication record to be reset.

SCC_CG_CLRPRCVW

(SQL View)

COMMGEN Processes to Clear

View of SCC_COMMGEN processes that are available for clearing/resetting. This is in lieu of disabling restart on the App Engine. Processing Statuses limited to: Deleted, Error, Cancelled, Success, Not Successful, and Successful w/ Warning. In the case of a process in Error, Not Successful, Cancelled or Deleted, temporary processing tables used by the App Engine program SCC_COMMGEN need to be cleared; and the Communication record needs to be reset. In the case of Success or Success w/ Warning, users may want to re-run the Communication Generation process again, therefore needing the Communication record to be reset.

SELECT PRCSINSTANCE , PRCSNAME , OPRID , RUNCNTLID , RUNDTTM , RUNSTATUS , RUNSTATUSDESCR FROM PS_PMN_PRCSLIST WHERE PRCSNAME IN ('SCC_COMMGEN','CCLTRGEN','SCC_CGLABELS') AND RUNSTATUS IN ('2', '3', '8', '9', '10', '17') AND PRCSINSTANCE IN ( SELECT DISTINCT PROCESS_INSTANCE FROM PS_COMMUNICATION X2 WHERE X2.PROCESS_INSTANCE = PS_PMN_PRCSLIST.PRCSINSTANCE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID

5 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time

6 RUNSTATUS Character(2) VARCHAR2(2) NOT NULL Process Scheduler Process Run Status
1=Cancel
10=Not Successful
11=Posted
12=Unable to post
13=Resend
14=Posting
15=Content Generated
16=Pending
17=Success With Warning
18=Blocked
19=Restart
2=Delete
3=Error
4=Hold
5=Queued
6=Initiated
7=Processing
8=Cancelled
9=Success

7 RUNSTATUSDESCR Character(10) VARCHAR2(10) NOT NULL Run Status

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	RUNCNTLID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	RUNDTTM	DateTime(26)	TIMESTAMP	Run Date/Time
6	RUNSTATUS	Character(2)	VARCHAR2(2) NOT NULL	Process Scheduler Process Run Status 1=Cancel 10=Not Successful 11=Posted 12=Unable to post 13=Resend 14=Posting 15=Content Generated 16=Pending 17=Success With Warning 18=Blocked 19=Restart 2=Delete 3=Error 4=Hold 5=Queued 6=Initiated 7=Processing 8=Cancelled 9=Success
7	RUNSTATUSDESCR	Character(10)	VARCHAR2(10) NOT NULL	Run Status