PSADSGROUP_VW(SQL View) | 
Index Back | 
|---|---|
Data Set Groups | 
| SELECT PTADSNAME , PTGROUPNAME , PTGRPDISPNAME , PTGRPLONGNAME FROM PSADSGROUP WHERE PSGROUPCONT = 'G' | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | 
Data Set Name (see PSADSDEFN).
 Prompt Table: PSADSDEFN  | 
|
| 2 | Character(40) | VARCHAR2(40) NOT NULL | Group Code | |
| 3 | PTGRPDISPNAME | Character(30) | VARCHAR2(30) NOT NULL | Group Name | 
| 4 | PTGRPLONGNAME | Character(254) | VARCHAR2(254) NOT NULL | Group Description |