OPRIDWORKSET_CDA=Staff Role
O=Public
P=Private
S=Security Role
Default Value: P
D=Dynamic
S=Static
Default Value: S
AV_WSET_O_VW(SQL View) |
Index Back |
|---|---|
Organization WorksetSelects all Organization worksets. |
| SELECT DISTINCT A.OPRID , A.WORKSET_CD , A.AV_AUTHOR_ID ,A.WORKSET_ACCESS_TYP ,A.WORKSET_TYPE ,A.DESCR FROM PS_AV_WORKSET A , PS_AV_WORKSET_MBR B WHERE B.AV_PNL_TYPE='O' AND A.OPRID=B.OPRID AND A.WORKSET_CD=B.WORKSET_CD AND A.WORKSET_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | WORKSET_CD |
Character(10) | VARCHAR2(10) NOT NULL | Workset Code |
| 3 | AV_AUTHOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Workset Author |
| 4 | WORKSET_ACCESS_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Workset Access
A=Staff Role O=Public P=Private S=Security Role Default Value: P |
| 5 | WORKSET_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Workset Type
D=Dynamic S=Static Default Value: S |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |