EMPLIDGM_ELIG_PI2_VW(SQL View) |
Index Back |
|---|---|
Effective Dated Personal DataPERS_DATA_EFFDT is one of the core records in the database. Use it to record effective dated personal data about an employee or applicant including name and address. |
| Select P.EMPLID, P.NAME From PS_PERS_DATA_EFFDT P, PS_GM_PERS_DATA D Where P.EMPLID=D.EMPLID And D.PROF_ELIG_IND='Y' And P.EFFDT=(Select MAX(E.EFFDT) From PS_PERS_DATA_EFFDT E Where E.EMPLID=P.EMPLID And E.EFFDT <= D.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |