EMPLIDGPGB_RTIX_DVW(SQL View) |
Index Back |
|---|---|
RTI XML Employee ViewRTI XML Employee View. |
| SELECT DISTINCT PD.EMPLID ,PD.NAME FROM PS_JOB J , PS_PERSONAL_DATA PD WHERE J.EFFDT=( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID=J.EMPLID AND J1.EMPL_RCD=J.EMPL_RCD AND J1.EFFDT<=%CurrentDateIn) AND J.EFFSEQ=( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID=J.EMPLID AND J2.EMPL_RCD=J.EMPL_RCD AND J2.EFFDT=J.EFFDT) AND J.EMPLID = PD.EMPLID AND J.REG_REGION IN ( SELECT DISTINCT R.REG_REGION FROM PS_REG_REGION_TBL R WHERE R.COUNTRY = 'GBR' AND R.REG_REGION <> 'ROI') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |