PSPTADSRTRWD_VW(SQL View) |
Index Back |
|---|---|
Datasets copy/comparableADS datasets access rights by its definition itself |
| SELECT AD.PTADSNAME , AD.PTCOPYABLE , AD.PTCOMPARABLE FROM PSADSDEFN AD ORDER BY AD.PTADSNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTADSNAME | Character(30) | VARCHAR2(30) NOT NULL | Data Set Name (see PSADSDEFN). |
| 2 | PTCOPYABLE | Character(1) | VARCHAR2(1) NOT NULL |
Is Copyable
N=Not Copyable Y=Copyable |
| 3 | PTCOMPARABLE | Character(1) | VARCHAR2(1) NOT NULL |
Is Comparable
N=Not Comparable Y=Comparable |