ROWSECCLASSFIELDNAMETL_GPPY_FLD_VW(SQL View) |
Index Back |
|---|---|
Security view of GP_PYGRP fldsThis is a view of accessible field in GP_PYGRP based on the user's row security class. This is used for Group Creation. |
| SELECT C.ROWSECCLASS , A.FIELDNAME FROM PSRECFIELD A , PS_TL_GRP_FLD_SEC C WHERE ((A.RECNAME = 'GP_PYGRP' AND SUBRECORD = 'N') OR A.RECNAME IN ( SELECT FIELDNAME FROM PSRECFIELD B WHERE B.RECNAME = 'GP_PYGRP' AND B.SUBRECORD = 'Y')) AND A.FIELDNAME = C.FIELDNAME AND A.RECNAME = C.RECNAME AND C.ACCESSIBLE = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROWSECCLASS |
Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |