OPRIDWORKSET_CDA=Staff Role
O=Public
P=Private
S=Security Role
Default Value: P
D=Dynamic
S=Static
Default Value: S
AV_WSET_P_VW(SQL View) |
Index Back |
|---|---|
Person WorksetSelects all person worksets. |
| SELECT DISTINCT W.OPRID , W.WORKSET_CD , W.AV_AUTHOR_ID ,W.WORKSET_ACCESS_TYP ,W.WORKSET_TYPE ,W.DESCR FROM PS_AV_WORKSET W , PS_AV_WORKSET_MBR B WHERE B.AV_PNL_TYPE = 'P' AND W.OPRID=B.OPRID AND W.WORKSET_CD=B.WORKSET_CD AND W.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 |