EMPLIDEMPL_RCDEFFDTEFFSEQLBR_AGRM_ESP_VW(SQL View) |
Index Back |
|---|---|
AFI Data dates VWAFI Data dates VW |
| SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.COMPANY , A.LABOR_AGREEMENT , A.EMPL_CTG , A.EMPL_CTG_L1 , B.SOCS_LBR_AGRMT_ESP FROM PS_JOB A , PS_EMPL_CTG_ESP B WHERE A.SETID_LBR_AGRMNT = B.SETID AND A.LABOR_AGREEMENT = B.LABOR_AGREEMENT AND A.EFFDT = ( SELECT MAX(ED.EFFDT) FROM PS_JOB ED WHERE ED.EMPLID = A.EMPLID AND ED.EMPL_RCD = A.EMPL_RCD AND ED.EFFDT <= A.EFFDT) AND B.EFFDT = ( SELECT MAX(ED2.EFFDT) FROM PS_EMPL_CTG_ESP ED2 WHERE ED2.SETID = B.SETID AND ED2.LABOR_AGREEMENT = B.LABOR_AGREEMENT AND ED2.EFFDT <= B.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 |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 6 | LABOR_AGREEMENT | Character(6) | VARCHAR2(6) NOT NULL | Labor Agreement |
| 7 | EMPL_CTG | Character(6) | VARCHAR2(6) NOT NULL | Employee Category |
| 8 | EMPL_CTG_L1 | Character(6) | VARCHAR2(6) NOT NULL | Employee Subcategory |
| 9 | SOCS_LBR_AGRMT_ESP | Character(14) | VARCHAR2(14) NOT NULL | Social Security Labor Agreement. Special codification following Social Security tables. This info is needed for AFI File. |