SEV_XFM_PPL_SLN (SQL View)	Index Back
SEVIS F M 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. This view will only select people with a Visa Type of F-1 or M-1.

SEV_XFM_PPL_SLN

(SQL View)

SEVIS F M 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. This view will only select people with a Visa Type of F-1 or M-1.

SELECT PSL.OPRCLASS , PSL.EMPLID , PSL.LANGUAGE_CD , PSL.NID_DESCRSHORT FROM PS_PEOPLE_SRCH_LN PSL

Related Language Record for SEV_XFM_PPL_SCH

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	NID_DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	NID Short Description