REFUND_SRCH3_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.

SELECT A.BUSINESS_UNIT ,A.REFUND_EMPLID ,A.COMMON_ID ,A.SA_ID_TYPE ,B.NAME ,A.EMPLID ,A.EXT_ORG_ID FROM PS_ITEM_SF A , PS_SCC_PRI_NAME_VW B WHERE A.REFUND_EMPLID = B.EMPLID AND A.ITEM_BALANCE < 0 AND A.ITEM_TYPE_CD IN('P','F','D','L','W') AND ((A.SA_ID_TYPE = 'P' AND A.REFUND_EMPLID <> A.COMMON_ID) OR (A.SA_ID_TYPE = 'O' AND A.REFUND_EXT_ORG_ID <> A.COMMON_ID)) GROUP BY A.BUSINESS_UNIT, A.COMMON_ID, A.SA_ID_TYPE, A.REFUND_EMPLID, B.NAME, A.EMPLID, A.EXT_ORG_ID

# 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 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
4 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 EMPLID_RELATED Character(11) VARCHAR2(11) NOT NULL Related People ID
7 EXT_ORG_ID_RELATED Character(11) VARCHAR2(11) NOT NULL Related ID