GPFR_AF_EXTRACT_IDEMPLIDGPFR_DSN_EMPLST(SQL View) |
Index Back |
|---|---|
DSN Employee listDSN Employee list based on extraction |
| SELECT DISTINCT A.GPFR_AF_EXTRACT_ID , A.EMPLID , A.EMPL_RCD , A.GPFR_AF_APPL , A.GPFR_AF_LVL_1_VAL , A.COMPANY , A.ESTABID , D.LAST_NAME FROM PS_GPFR_AF_EXTRACT A , PS_GPFR_AF_NODE N , PS_GPFR_DSN_CIESTB C , PS_NAMES D WHERE A.COUNTRY = N.COUNTRY AND A.GPFR_AF_APPL = N.GPFR_AF_APPL AND A.GPFR_AF_EXTRACT_ID=C.GPFR_AF_EXTRACT_ID AND A.GPFR_AF_APPL =C.GPFR_AF_APPL AND A.COUNTRY =C.COUNTRY AND A.COMPANY =C.COMPANY AND A.ESTABID =C.ESTABID AND A.GPFR_AF_LVL_1_VAL =C.GPFR_AF_SNDREF AND A.GPFR_AF_KEY_NODE = N.GPFR_AF_KEY_NODE AND A.EMPLID=D.EMPLID AND D.EFFDT = ( SELECT MAX(EFFDT) FROM PS_NAMES EE WHERE EE.EMPLID=D.EMPLID AND EE.EFFDT<=%CurrentDateIn) AND A.COUNTRY ='FRA' AND A.EMPLID <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_AF_EXTRACT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Application Framework - Extraction ID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | GPFR_AF_APPL | Character(10) | VARCHAR2(10) NOT NULL | Application Framework - Application |
| 5 | GPFR_AF_LVL_1_VAL | Character(50) | VARCHAR2(50) NOT NULL | Application Framework - Key Value 1 |
| 6 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 7 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 8 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |