ISIR_NAME_VW(SQL View) |
Index Back |
|---|---|
ISIR NAME ViewThis view is used for selecting the NAME based upon the NAME usage for the NAME search panel. This view utilizes the NAME order table to find the matching address, if any. |
| SELECT A.EMPLID ,%subrec(NAMEGBL_NPC_SBR,A) , C.NAME_USAGE_ORDER FROM PS_HCR_PER_NAME_I A , PS_NAME_ORDER_TBL C , PS_FA_PRCSDEMO_TBL D WHERE A.NAME_TYPE = C.NAME_TYPE AND A.EFFDT = ( SELECT MAX(A11.EFFDT) FROM PS_HCR_PER_NAME_I A11 WHERE A11.EMPLID = A.EMPLID AND A11.NAME_TYPE = A.NAME_TYPE AND A11.EFFDT <=%CurrentDateIn) AND C.NAME_USAGE = D.NAME_USAGE AND D.FA_PROCESS_NAME = 'I' AND C.NAME_USAGE_ORDER = ( SELECT MIN(C1.NAME_USAGE_ORDER) FROM PS_NAME_ORDER_TBL C1 WHERE C1.NAME_USAGE = C.NAME_USAGE AND C1.NAME_TYPE IN ( SELECT A1.NAME_TYPE FROM PS_HCR_PER_NAME_I A1 WHERE A1.EMPLID = A.EMPLID AND A1.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_HCR_PER_NAME_I A2 WHERE A2.EMPLID = A1.EMPLID AND A2.NAME_TYPE = A1.NAME_TYPE AND A2.EFFDT<=%CurrentDateIn))) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | COUNTRY_NM_FORMAT | Character(3) | VARCHAR2(3) NOT NULL |
Supported Name Format Types
Prompt Table: NAME_FORMAT_TBL |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | NAME_INITIALS | Character(6) | VARCHAR2(6) NOT NULL | Name Initials |
| 5 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL |
Name Prefix
Prompt Table: NAME_PREFIX_TBL |
| 6 | NAME_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL |
Name Suffix
Prompt Table: NAME_SUFFIX_TBL |
| 7 | NAME_ROYAL_PREFIX | Character(15) | VARCHAR2(15) NOT NULL |
Name Royal Prefix
Prompt Table: NM_ROYPREF_GBL |
| 8 | NAME_ROYAL_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL |
Name Royal Suffix
Prompt Table: NM_ROYSUFF_GBL |
| 9 | NAME_TITLE | Character(30) | VARCHAR2(30) NOT NULL |
Title
Prompt Table: TITLE_TBL |
| 10 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 11 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 12 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 13 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 14 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 15 | SECOND_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Second Last Name |
| 16 | SECOND_LAST_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Second Name |
| 17 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
| 18 | PREF_FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Preferred First Name |
| 19 | PARTNER_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name. |
| 20 | PARTNER_ROY_PREFIX | Character(15) | VARCHAR2(15) NOT NULL |
The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.
Prompt Table: NM_ROYPREF_GBL |
| 21 | LAST_NAME_PREF_NLD | Character(1) | VARCHAR2(1) NOT NULL |
The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name.
1=Own Name 2=Name Partner 3=Name Partner + Own Name 4=Own Name + Name Partner Default Value: 1 |
| 22 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 23 | NAME_FORMAL | Character(60) | VARCHAR2(60) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 24 | NAME_USAGE_ORDER | Number(4,0) | SMALLINT NOT NULL | Name Usage Order |