REFUND_TAX_VW (SQL View)	Index Back
Emplid Tax Search Record This is a Dynamic view to select all students who have an account balance or who have a refund assigned to them (i.e. REFUND_EMPLID <> ' '). It uses a UNION which is not portable to all database platforms, therefore the need for a dynamic view instead.

REFUND_TAX_VW

(SQL View)

Emplid Tax Search Record

This is a Dynamic view to select all students who have an account balance or who have a refund assigned to them (i.e. REFUND_EMPLID <> ' '). It uses a UNION which is not portable to all database platforms, therefore the need for a dynamic view instead.

SELECT DISTINCT A.BUSINESS_UNIT , B.EMPLID FROM PS_BUS_UNIT_TBL_SF A , PS_SCC_PERS_SA_VW B WHERE EXISTS ( SELECT C.REFUND_EMPLID FROM PS_ITEM_SF C WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.REFUND_EMPLID = B.EMPLID AND C.REFUND_EMPLID <> ' ') OR EXISTS ( SELECT D.EMPLID FROM PS_ACCOUNT_SF D WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.EMPLID = B.EMPLID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID