REFUND_SRCH_VW (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.

REFUND_SRCH_VW

(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.BUSINESS_UNIT , A.REFUND_EMPLID , B.NAME FROM PS_ITEM_SF A , PS_SCC_PRI_NAME_VW B WHERE A.REFUND_EMPLID = B.EMPLID AND A.REFUND_EMPLID <> A.COMMON_ID AND A.SA_ID_TYPE = 'P' AND A.ITEM_BALANCE < 0 GROUP BY A.BUSINESS_UNIT, A.REFUND_EMPLID, B.NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 EMPLID_OLD Character(11) VARCHAR2(11) NOT NULL Previous Employee ID

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	EMPLID_OLD	Character(11)	VARCHAR2(11) NOT NULL	Previous Employee ID
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name