| PSPRCSGRP_VW(SQL View) | Index Back | 
|---|---|
| Process GroupsThis view is used to list all the unique Process Groups. | 
| SELECT DISTINCT PRCSGRP FROM PS_PRCSJOBGRP WHERE PRCSGRP <> ' ' UNION SELECT DISTINCT PRCSGRP FROM PS_PRCSDEFNGRP WHERE PRCSGRP <> ' ' | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Process Definition Group Name |