WCS_PERSON_NM_I (SQL View)	Index Back
Current Primary Name This view retrieves the currently effective Names record for all the Primary Name. Only one row per emplid is returned. The EFFDT is included only for reference back to NAMES as ASOFDATE.

WCS_PERSON_NM_I

(SQL View)

Current Primary Name

This view retrieves the currently effective Names record for all the Primary Name. Only one row per emplid is returned. The EFFDT is included only for reference back to NAMES as ASOFDATE.

SELECT A.EMPLID ,A.NAME_DISPLAY ,A.NAME_TYPE ,A.ASOFDATE FROM PS_HCR_PERSON_NM_I A

Related Language Record: WCS_PERSON_NM_L

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

3 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name
Prompt Table: NAME_TYPE_TBL

4 ASOFDATE Date(10) DATE As of Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
3	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name Prompt Table: NAME_TYPE_TBL
4	ASOFDATE	Date(10)	DATE	As of Date