EMPLIDEMPL_RCDEFFDTDefault Value: %date
EFFSEQGPCH_FK_ST_VW(SQL View) |
Index Back |
|---|---|
State from LocationState from Location |
| SELECT J.EMPLID , J.EMPL_RCD , J.EFFDT , J.EFFSEQ , L.STATE , L.LOCALITY , J.COMPANY FROM PS_JOB J , PS_LOCATION_TBL L WHERE J.SETID_LOCATION = L.SETID AND J.LOCATION = L.LOCATION AND L.EFFDT = ( SELECT MAX (L1.EFFDT) FROM PS_LOCATION_TBL L1 WHERE L.SETID = L1.SETID AND L.LOCATION = L1.LOCATION AND L1.EFFDT <= J.EFFDT ) AND J.EFFSEQ = ( SELECT MAX (J1.EFFSEQ) FROM PS_JOB J1 WHERE J.EMPLID = J1.EMPLID AND J.EMPL_RCD = J1.EMPL_RCD AND J.EFFDT = J1.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 Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 6 | LOCALITY | Character(10) | VARCHAR2(10) NOT NULL | Locality |
| 7 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |