ISET_BU_DTL_VW

(SQL View)
 Index Back

ISet Business Unit Detail


SELECT A.INSTITUTION_SET , A.BUSINESS_UNIT , A.DESCR , A.ITEM_TYPE , A.ITEM_TYPE_ECHK , A.SF_ALLOW_EXCESS , B.INSTITUTION FROM PS_ISET_BU_DTL A , PS_BUS_UNIT_TBL_SF B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.SF_ENABLE_WEB_PAY = 'Y'

  • Related Language Record: ISETBUDTLVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_SF

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: ITEM_TYPE_CR_VW

    5 ITEM_TYPE_ECHK Character(12) VARCHAR2(12) NOT NULL eCheck Item Type

    Prompt Table: ITEM_TYPE_EC_VW

    6 SF_ALLOW_EXCESS Character(1) VARCHAR2(1) NOT NULL Allow Excess Payment

    Y/N Table Edit

    Default Value: Y

    7 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution