EMPLIDEMPL_RCDEFFDTDefault Value: %date
GPFR_TAX_TRA_VW(SQL View) |
Index Back |
|---|---|
Array-View for LeviesView for Zip code and transportation rate for Levies. Looking into JOB and into ESTAB_TBL. |
| SELECT A.EMPLID , A.EMPL_RCD , B.EFFDT , B.ESTABID , B.POSTAL , C.TRANSPORT_RT FROM PS_JOB A , PS_ESTAB_TBL B , PS_ESTAB_TBL_FRA C WHERE A.ESTABID = B.ESTABID AND C.ESTABID = B.ESTABID AND C.EFFDT = B.EFFDT AND ( B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_ESTAB_TBL D WHERE A.ESTABID = D.ESTABID AND D.EFFDT <= A.EFFDT AND D.EFF_STATUS = 'A' ) OR ( B.EFFDT > A.EFFDT AND (B.EFFDT < ( SELECT MIN(E.EFFDT) FROM PS_JOB E WHERE E.EMPLID = A.EMPLID AND E.EMPL_RCD = A.EMPL_RCD AND E.EFFDT > A.EFFDT) OR NOT EXISTS ( SELECT 'X' FROM PS_JOB E WHERE E.EMPLID = A.EMPLID AND E.EMPL_RCD = A.EMPL_RCD AND E.EFFDT > A.EFFDT) ) ) ) AND B.EFF_STATUS = 'A' |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 5 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 6 | TRANSPORT_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Transport Rate |