EMPLIDEMPL_RCDEFFDTDefault Value: %date
GPFR_TX_TRA2_VW(SQL View) |
Index Back |
|---|---|
Array-View for Addnl TransportView for Addnl Transportation data. Looking into JOB and into ESTAB_TBL. |
| SELECT A.EMPLID , A.EMPL_RCD , B.EFFDT , B.ESTABID , B.TRS_RATE_DT_FRA , B.TRANSPORT_RT2_FRA , B.TAT_RATE_DT_FRA FROM PS_JOB A , PS_ESTAB_TBL_FRA B WHERE A.ESTABID = B.ESTABID 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) ) ) ) |
| # | 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 | TRS_RATE_DT_FRA | Date(10) | DATE | DUCS Transport Rate Date |
| 6 | TRANSPORT_RT2_FRA | Number(19,6) | DECIMAL(18,6) NOT NULL | DUCS Additional Transport Rate |
| 7 | TAT_RATE_DT_FRA | Date(10) | DATE | DUCS Additional Transport Rate Date |