ERE_ID_ESPOPRIDEMPLIDEMPL_RCDERE_EM_SRCH_ESP(SQL View) |
Index Back |
|---|---|
Employee Search - GlobalThis view shows you records only for persons in departments that your operator class is allowed to access and filtered by companies present in the selected ERE ID. Use this view to access records with primary keys of EMPLID and EMPL_RCD#. |
| SELECT DISTINCT A.ERE_ID_ESP , %Sql(SCRTY_SEL_PKEY, OPR,SEC) , JB.COMPANY , JB.SETID_DEPT , JB.DEPTID , JB.SETID_JOBCODE , JB.JOBCODE , JB.POSITION_NBR FROM %Sql(SCRTY_PER_NM_FROM) , PS_ERE_CMP_DTA_ESP A , PS_ERE_DATA_ESP EDTA , PS_JOB JB WHERE A.ERE_ID_ESP = EDTA.ERE_ID_ESP AND A.COMPANY = SEC.COMPANY AND JB.EMPLID = SEC.EMPLID AND JB.EMPL_RCD = SEC.EMPL_RCD AND %EffdtCheck(JOB, JB, EDTA.ERE_BGNDT_ESP) AND JB.EFFSEQ = ( SELECT MAX(JB2.EFFSEQ) FROM PS_JOB JB2 WHERE JB2.EMPLID = JB.EMPLID AND JB2.EMPL_RCD = JB.EMPL_RCD AND JB2.EFFDT = JB.EFFDT) AND %Sql(SCRTY_NO_APPT1) AND %Sql(SCRTY_NAME) AND %Sql(SCRTY_WHERE, 'PPLJOB') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ERE_ID_ESP |
Character(10) | VARCHAR2(10) NOT NULL | ERE ID |
| 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 Record |
| 6 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 7 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 9 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 10 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 11 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |