EMPLIDEMPL_RCDCO_PE_EMPLOC_VW(SQL View) |
Index Back |
|---|---|
Employee Loctation ViewSelect employee location from ps_job to be shown on the direct reports pagelet. |
| SELECT A.EMPLID , A.EMPL_RCD , A.LOCATION , B.DESCR , B.DESCRSHORT , B.BUILDING , B.FLOOR , B.SECTOR FROM PS_JOB A , PS_LOCATION_TBL B WHERE A.SETID_LOCATION = B.SETID AND A.LOCATION = B.LOCATION AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_JOB A2 WHERE A.EMPLID = A2.EMPLID AND A.EMPL_RCD = A2.EMPL_RCD AND A2.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(A3.EFFSEQ) FROM PS_JOB A3 WHERE A.EMPLID = A3.EMPLID AND A.EMPL_RCD = A3.EMPL_RCD AND A.EFFDT = A3.EFFDT ) AND B.EFFDT = ( SELECT MAX(Z.EFFDT) FROM PS_LOCATION_TBL Z WHERE Z.SETID = B.SETID AND Z.LOCATION = B.LOCATION AND Z.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | BUILDING | Character(10) | VARCHAR2(10) NOT NULL | Building Nbr |
| 7 | FLOOR | Character(10) | VARCHAR2(10) NOT NULL | Floor Nbr |
| 8 | SECTOR | Character(10) | VARCHAR2(10) NOT NULL | Sector |