SSF_TAX_VW

(SQL View)
 Index Back

Tax View

Returns all the tax authority codes for an Item.

SELECT DISTINCT C.BUSINESS_UNIT , I.item_type , D.STRM , A.TAX_AUTHORITY_CD , B.TAX_PCT , B.SERVICE_IMPACT , C.INSTITUTION FROM PS_TAX_CD A , PS_TAX_AUTHORITY B , PS_BUS_UNIT_TBL_SF C , PS_TERM_TBL D , PS_ITEM_TYPE_TBL I WHERE A.SETID = B.SETID AND A.TAX_AUTHORITY_CD = B.TAX_AUTHORITY_CD AND C.INSTITUTION = D.INSTITUTION AND D.TERM_BEGIN_DT = ( SELECT MIN(D1.TERM_BEGIN_DT) FROM PS_TERM_TBL D1 WHERE D.INSTITUTION = D1.INSTITUTION AND D.STRM = D1.STRM) AND A.SETID = ( SELECT A1.SETID FROM PS_SET_CNTRL_REC A1 WHERE A1.SETCNTRLVALUE = C.BUSINESS_UNIT AND A1.RECNAME = 'TAX_HEADER_TBL') AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_TAX_AUTHORITY B1 WHERE B1.SETID = B.SETID AND B1.TAX_AUTHORITY_CD = B.TAX_AUTHORITY_CD AND B1.EFFDT <= D.TERM_BEGIN_DT) AND I.SETID = ( SELECT I1.SETID FROM PS_SET_CNTRL_REC I1 WHERE I1.SETCNTRLVALUE = C.INSTITUTION AND I1.RECNAME = 'ITEM_TYPE_TBL') AND I.EFFDT = ( SELECT MAX(I2.EFFDT) FROM PS_ITEM_TYPE_TBL I2 WHERE I2.SETID = I.SETID AND I2.ITEM_TYPE = I.ITEM_TYPE AND I2.EFFDT <= D.TERM_BEGIN_DT) AND A.TAX_CD = I.TAX_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
3 STRM Character(4) VARCHAR2(4) NOT NULL Term
4 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority
5 TAX_PCT Number(6,3) DECIMAL(5,3) NOT NULL Tax Percent
6 SERVICE_IMPACT Character(5) VARCHAR2(5) NOT NULL Service Impact
7 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution