EMPLIDPrompt Table: PEOPLE_SRCH
NAME_TYPEPrompt Table: HCR_NM_TYP_I
EFFDTPrompt Table: NAME_PREFIX_TBL
Prompt Table: NAME_SUFFIX_TBL
GP_SRCH_NMS_VW(SQL View) |
Index Back |
|---|---|
Effective Dated Names VwThis view retrieves the currently effective Names record for each Name Type. |
| SELECT A.EMPLID ,A.NAME_TYPE ,A.EFFDT ,A.LAST_NAME ,A.FIRST_NAME ,A.MIDDLE_NAME ,A.NAME_PREFIX ,A.NAME_SUFFIX ,A.LAST_NAME_SRCH ,A.FIRST_NAME_SRCH ,A.NAME_DISPLAY FROM PS_NAMES A WHERE A.NAME_TYPE ='PRI' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | NAME_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Type of Name
Prompt Table: HCR_NM_TYP_I |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 5 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 6 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 7 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL |
Name Prefix
Prompt Table: NAME_PREFIX_TBL |
| 8 | NAME_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL |
Name Suffix
Prompt Table: NAME_SUFFIX_TBL |
| 9 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 10 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 11 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |