EMPLIDPrompt Table: PERSON
GVT_PERSONAL_VW(SQL View) |
Index Back |
|---|---|
Personal Data Name ViewGVT_PERSONAL_VW is a view of Personal Data which retrieves only the name. It is used for the incubent(s) name in Position Management, because the Personal Data record was already being accessed in the panel via work scrolls. |
| SELECT DISTINCT EMPLID ,NAME_DISPLAY FROM PS_GVT_PERS_DATA A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GVT_PERS_DATA A2 WHERE A.EMPLID = A2.EMPLID AND A2.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_GVT_PERS_DATA A3 WHERE A3.EMPLID = A.EMPLID AND A3.EFFDT = A.EFFDT ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |