GM_PERS_NAME_VW

(SQL View)
 Index Back

Grants Personal Data View 3

PERSONAL_DATA is one of the core records in the database. Use it to record personal and demographic data about an employee or applicant including name, address, birthdate, and ethnic group. View of Personal Data because we can only have one related display from a record for each panel.

SELECT A.EMPLID , %subrec(NAMEGBL_SBR,A) FROM PS_PERS_DATA_EFFDT A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_PERS_DATA_EFFDT A1 WHERE A1.EMPLID = A.EMPLID AND A1.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 Format for Country

Prompt Table: COUNTRY_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
1=Mr.
2=Mrs.
3=Ms.

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
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_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