EMPLIDGVT_EMPLID2_VW(SQL View) |
Index Back |
|---|---|
View of Terminated EmployeesUsed for the SF1150 report - shows all terminated employees |
| SELECT A.EMPLID , A.EMPL_RCD , B.NAME FROM PS_GVT_JOB A , PS_GVT_NM_DT_VW B WHERE A.EMPLID = B.EMPLID AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND A.GVT_NOA_CODE IN('300', '301', '302', '303', '304', '312', '317', '330', '350', '351', '352', '353', '355', '356', '357', '385', '386', '390', '920') |
| # | 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 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |