JPM_JP_TYPEPrompt Table: JPM_JP_PTYPE_VW
OPRIDEMPLIDJPM_EPROFLT_VW(SQL View) |
Index Back |
|---|---|
CI SRCH- NO ROWLVL SECURITYEMPLMT_SRCH_ALL is an Employment Search record containing all of the localized alternate search keys This view does not use the Department Security Tree. It is only used by CI updates (CI_JOB_DATA) where the security was already handled by the process calling the CI. This allows processes that aren't using Dept Security (such as Self Service and Kenmu) to update the Job rows that they need to even if the user running the CI does not have dept security access. To reapply Dept Security to the CIs, open the EMPLMT_SRCH_SAV view and do a save as EMPLMT_SRCH_ALL and overwrite this view. |
| SELECT P.JPM_JP_TYPE , %subrec(PER_KEY_SBR, A) , A.NAME , A.LAST_NAME_SRCH , A.NAME_AC FROM PS_PERS_SRCH_GBL A , PS_JPM_PROFILE P , PS_JPM_JP_SEC_VW S WHERE A.EMPLID = P.EMPLID AND S.JPM_JP_TYPE = P.JPM_JP_TYPE AND S.JPM_ROLE = 'ADM' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JPM_JP_TYPE |
Character(12) | VARCHAR2(12) NOT NULL |
Profile Type name for a JPM Profile Type
Prompt Table: JPM_JP_PTYPE_VW |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 6 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 7 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 8 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |