OPRIDPrompt Table: PSCLASSDEFN_SRC
00=Recruitment Administrator
01=Recruiter
02=Recruiting User
03=Hiring Manager
04=Federal Recruiter
05=RS Approval Administrator
06=RS Technical Administrator
HRS_SEC_TBL_I(SQL View) |
Index Back |
|---|---|
RS Row Security Driver TableRecruiting Solutions Row Level Security Driver Table. |
| SELECT A.OPRID ,A.ROWSECCLASS ,B.HRS_ROLE_TYPE FROM PSOPRDEFN A ,PS_HRS_ROLE_DEFN B , PSROLEUSER C WHERE B.HRS_ROLE_TYPE = '00' AND A.OPRID = C.ROLEUSER AND B.ROLENAME = C.ROLENAME |
| # | 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 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL |
The class used to determine row level security
Prompt Table: PSCLASSDEFN_SRC |
| 3 | HRS_ROLE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Recruiting Role Types
00=Recruitment Administrator 01=Recruiter 02=Recruiting User 03=Hiring Manager 04=Federal Recruiter 05=RS Approval Administrator 06=RS Technical Administrator |