EMPLIDOPRIDEFFDTDefault Value: %date
W3HR_PERS_SRCH(SQL View) |
Index Back |
|---|---|
WWW Personal Data search recorWWW Personal Data search record that retrieves only the operators data. This view retrieves only information effective dated greater or equal to the current effective dated information. |
| SELECT a.emplid ,b.oprid ,c.effdt ,a.name FROM ps_PERSON_NAME a ,PSOPRDEFN b ,ps_pers_data_effdt c WHERE a.emplid = b.emplid AND b.emplid = c.emplid AND c.effdt >= ( SELECT MAX(d.EFFDT) FROM ps_pers_data_effdt d WHERE d.emplid = c.emplid AND d.effdt <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |