AR_RESET_VW

(SQL View)
 Index Back

AR Reset Process List

This view is used to list all the process requests in the AR Resetr. It will only list Application Engine starting with 'AR' and has status of '3' (error) and '10' (not success).

SELECT R.PRCSINSTANCE , R.RUNCNTLID , R.PRCSNAME , R.RUNLOCATION , R.RESTARTENABLED , R.SERVERNAMERUN , R.SERVERNAMERQST , R.OPRID , R.RQSTDTTM , R.RUNDTTM , R.BEGINDTTM , R.ENDDTTM , R.RUNSTATUS , R.GENPRCSTYPE , C.RQSTSTATUSUPD , C.RQSTSTATUSVIEW FROM PSPRCSRQST R , PSOPRDEFN B , PSPRCSPRFL C , PS_AR_RESET_TBL S WHERE B.OPRID = R.OPRID AND B.OPRCLASS = C.CLASSID AND R.RUNSTATUS IN ('3','10','8') AND R.RUNLOCATION = '2' AND R.PRCSTYPE IN ('Application Engine', 'PSJob') AND R.GENPRCSTYPE IN ('5', '0') AND R.PRCSJOBSEQ = 0 AND R.PRCSNAME = S.PRCSNAME AND S.ENABLED = 'Y' AND NOT ( R.PRCSNAME = 'FS_STREAMLN' AND NOT EXISTS ( SELECT 'X' FROM PS_RP_PARALLEL P WHERE P.RUN_CNTL_ID = R.RUNCNTLID AND P.OPRID = R.OPRID))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
4 RUNLOCATION Character(1) VARCHAR2(1) NOT NULL Run Location
0=Both
1=Client
2=Server
5 RESTARTENABLED Character(1) VARCHAR2(1) NOT NULL Restart Enabled?
6 SERVERNAMERUN Character(8) VARCHAR2(8) NOT NULL Server Name - Runtime
7 SERVERNAMERQST Character(8) VARCHAR2(8) NOT NULL Server Name Request
8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
9 RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
10 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
11 BEGINDTTM DateTime(26) TIMESTAMP Begin Date/Time
12 ENDDTTM DateTime(26) TIMESTAMP End Date/Time
13 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
14 GENPRCSTYPE Character(2) VARCHAR2(2) NOT NULL Generic Process Type
0=Other
1=SQR
2=PeopleSoft COBOL
3=Crystal Report
4=Winword Macro
5=Application Engine
6=Cube Builder
7=nVision
8=Data Mover
9=PSJob
15 RQSTSTATUSUPD Number(1,0) SMALLINT NOT NULL Request Status Update
16 RQSTSTATUSVIEW Number(1,0) SMALLINT NOT NULL Request Status View