PAY_ENTITYEMPLIDGPGB_PENEMP_VW(SQL View) |
Index Back |
|---|---|
Employee View GBREmployee View GBR |
| SELECT B.PAY_ENTITY , A.EMPLID , A.EMPL_RCD , C.NAME_FORMAL FROM PS_JOB A , PS_GP_PYGRP B , PS_PERSONAL_DATA C WHERE A.TERMINATION_DT IS NULL AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_JOB A1 WHERE A1.EMPLID = A.EMPLID AND A1.EMPL_RCD = A.EMPL_RCD ) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_JOB A2 WHERE A2.EMPLID = A.EMPLID AND A2.EMPL_RCD = A.EMPL_RCD AND A2.EFFDT = A.EFFDT ) AND C.EMPLID = A.EMPLID AND B.GP_PAYGROUP = A.GP_PAYGROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | NAME_FORMAL | Character(60) | VARCHAR2(60) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |