GM_PERS_DATA_VW

(SQL View)
 Index Back

EE Personal Data - View


SELECT A.EMPLID , %subrec(NAMEGBL_NPC_SBR,A) FROM PS_PERSONAL_DATA A

# 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 Format for Country
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
1=Mr.
2=Mrs.
3=Ms.
6 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
7 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
8 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix
9 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
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_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
16 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last 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