AR_AE_PROCS_VW(SQL View) |
Index Back |
---|---|
AR Reset Process ListThis 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 PRCSNAME , DESCR FROM PS_PRCSDEFN WHERE PRCSTYPE = 'Application Engine' AND (%Substring(PRCSNAME, 1, 2) = 'AR' OR PRCSNAME = 'FS_STREAMLN') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |