PEOPLE_SRCH_FA (SQL View)	Index Back
People Search View Common view used when searching for/selecting a person for display/update. This view should be used as the basis for all other views which go against people. The PeopleCode contained on this view is important for any other view which is based on this one - the searching/formatting for names and setting the carry id is done with this code.

PEOPLE_SRCH_FA

(SQL View)

People Search View

Common view used when searching for/selecting a person for display/update. This view should be used as the basis for all other views which go against people. The PeopleCode contained on this view is important for any other view which is based on this one - the searching/formatting for names and setting the carry id is done with this code.

SELECT A.OPRCLASS ,A.EMPLID ,C.NAME ,D.SEX ,A.BIRTHDATE ,A.BIRTHDATE_MSK ,A.CAMPUS_ID ,B.NATIONAL_ID ,B.NATIONAL_ID_MSK ,B.COUNTRY ,B.NATIONAL_ID_TYPE ,B.NID_DESCRSHORT ,C.LAST_NAME_SRCH ,C.FIRST_NAME_SRCH FROM PS_PERSON_MSK_VW A , PS_PERS_NID_MSK_VW B , PS_HCR_PERSON_NM_I C , PS_HCR_PER_PDE_I D WHERE A.OPRCLASS = B.OPRCLASS AND A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND A.EMPLID = D.EMPLID AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_HCR_PER_PDE_I D1 WHERE D1.EMPLID=D.EMPLID AND D1.EFFDT<=%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

4 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec

5 BIRTHDATE Date(10) DATE Date of Birth

6 BIRTHDATE_MSK Character(10) VARCHAR2(10) NOT NULL Date of Birth

7 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID

8 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

9 NATIONAL_ID_MSK Character(20) VARCHAR2(20) NOT NULL National ID

10 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country

11 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
Prompt Table: NID_TYPE_TBL

12 NID_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL NID Short Description

13 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

14 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
5	BIRTHDATE	Date(10)	DATE	Date of Birth
6	BIRTHDATE_MSK	Character(10)	VARCHAR2(10) NOT NULL	Date of Birth
7	CAMPUS_ID	Character(16)	VARCHAR2(16) NOT NULL	Campus ID
8	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
9	NATIONAL_ID_MSK	Character(20)	VARCHAR2(20) NOT NULL	National ID
10	NID_COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	National ID Country
11	NATIONAL_ID_TYPE	Character(6)	VARCHAR2(6) NOT NULL	National ID Type Prompt Table: NID_TYPE_TBL
12	NID_DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	NID Short Description
13	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
14	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name