PAY_ENTITYCAL_RUN_IDEMPLIDGPGB_CAL_ID_VW2(SQL View) |
Index Back |
|---|---|
GPGB - Cal Run Id + Emplid VwGPGB - Calendar Run Id View to get Calendar Run ID description from generated (Writable Array) Pay calculation Result table for the UK. This view provide the Emplid calculated in this Cal Run Id. |
| SELECT DISTINCT B.PAY_ENTITY ,A.CAL_RUN_ID ,A.EMPLID ,P.NAME ,P.LAST_NAME_SRCH FROM PS_GP_PYE_PRC_STAT A , PS_GPGB_EE_RSLT B , PS_PERSON_NAME P WHERE A.EMPLID = B.EMPLID AND A.EMPLID = P.EMPLID AND A.CAL_RUN_ID = B.CAL_RUN_ID AND A.PRD_TYPE <> 'H' AND A.CALC_TYPE = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 2 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |