RF_SETID_TAX_VW

(SQL View)
 Index Back

Tax Parameter Set IDs.

This view lists all the distinct Set ID that exist in the Tax Parameter Definition table. This was designed to be a prompt table for the Set ID when dealing with Tax Parameter Definitions.

SELECT A.SETID , A.DESCR , A.DESCRSHORT , A.DESCRLONG FROM PS_SETID_TBL A WHERE EXISTS ( SELECT 'X' FROM PS_RF_TAX_PARAM B WHERE B.SETID = A.SETID )

  • Related Language Record: SETID_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 DESCRLONG Long Character CLOB Long Description