SAE_LIS_FNAM_VW

(SQL View)
Index Back

SAIP person form names view

Person form names view for SAIP

SELECT NAMES_VW.EMPLID , NAMES_MAP.SAE_TARGET_ID , NAMES_MAP.SAE_LIS_NAME_TYPE , NAMES_VW.NAME_TYPE , XLAT.XLATLONGNAME SAE_LIS_NAME_LNAME , NAMES_VW.COUNTRY_NM_FORMAT , NAMES_VW.NAME , NAMES_VW.NAME_INITIALS , NAMES_VW.NAME_PREFIX , NAMES_VW.NAME_SUFFIX , NAMES_VW.NAME_ROYAL_PREFIX , NAMES_VW.NAME_ROYAL_SUFFIX , NAMES_VW.NAME_TITLE , NAMES_VW.LAST_NAME_SRCH , NAMES_VW.FIRST_NAME_SRCH , NAMES_VW.LAST_NAME , NAMES_VW.FIRST_NAME , NAMES_VW.MIDDLE_NAME , NAMES_VW.SECOND_LAST_NAME , NAMES_VW.SECOND_LAST_SRCH , NAMES_VW.NAME_AC , NAMES_VW.PREF_FIRST_NAME , NAMES_VW.PARTNER_LAST_NAME , NAMES_VW.PARTNER_ROY_PREFIX , NAMES_VW.LAST_NAME_PREF_NLD , NAMES_VW.NAME_DISPLAY , NAMES_VW.NAME_FORMAL , 'A' SAE_MODE FROM %Table(SCC_EQNAMES_VW) NAMES_VW , %Table(SAE_LIS_FNAMMAP) NAMES_MAP , PSXLATITEM XLAT WHERE NAMES_VW.NAME_TYPE = NAMES_MAP.NAME_TYPE AND XLAT.FIELDNAME = 'SAE_LIS_NAME_TYPE' AND XLAT.FIELDVALUE = NAMES_MAP.SAE_LIS_NAME_TYPE AND %EffdtCheck(PSXLATITEM XL, XLAT, %CurrentDateIn) AND XLAT.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SAE_TARGET_ID Character(50) VARCHAR2(50) NOT NULL SAIP Target ID
3 SAE_LIS_NAME_TYPE Character(4) VARCHAR2(4) NOT NULL LIS Name Type
ALIA=Alias
CONT=Contact
FORM=Former
FULL=Full
MAID=Maiden
PREF=Preferred
4 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name
5 SAE_LIS_NAME_LNAME Character(30) VARCHAR2(30) NOT NULL LIS Name
6 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Supported Name Format Types
7 NAME Character(50) VARCHAR2(50) NOT NULL Name
8 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
9 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
10 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
11 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
12 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix
13 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
14 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
15 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
16 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
17 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
18 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
19 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
20 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
21 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
22 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
23 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.
24 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.
25 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
26 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
27 NAME_FORMAL Character(60) VARCHAR2(60) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
28 SAE_MODE Character(1) VARCHAR2(1) NOT NULL Operation Mode
A=Add
C=Change
D=Delete