HOLD_OPR_ALL_VW(SQL View) |
Index Back |
---|---|
All Hold Security by OpridAll hold codes that can either be added, deleted or modified by user. |
SELECT DISTINCT R.ROLEUSER , L.SETID , L.HOLD_CD FROM PSROLEUSER R , PS_HOLD_ROLE_LNK L WHERE L.ROLENAME = R.ROLENAME AND (L.ADD_AUTH = 'Y' OR L.MOD_AUTH = 'Y' OR L.DEL_AUTH = 'Y') |
# | 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 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
3 | HOLD_CD | Character(6) | VARCHAR2(6) NOT NULL | Hold Code |