SCC_SFPPAYVWLN

(SQL View)
 Index Back

Payment Item VW


SELECT a.business_unit ,a.common_id ,a.sa_id_type ,a.payment_id_nbr ,z.language_cd ,z.descr ,z.descrshort FROM ps_payment_tbl a , ps_bus_unit_tbl_sf c , PS_ITEM_TYPE_TBL d , ps_item_type_lang z WHERE D.SETID=Z.SETID AND D.ITEM_TYPE=Z.ITEM_TYPE AND a.business_unit = c.business_unit AND d.item_type = a.item_type AND d.setid = ( SELECT e.setid FROM ps_set_cntrl_rec e WHERE e.setcntrlvalue = c.institution AND e.recname = 'ITEM_TYPE_TBL') AND d.effdt = ( SELECT MAX(f.effdt) FROM PS_ITEM_TYPE_TBL f , ps_item_type_lang z WHERE f.setid = z.setid AND F.ITEM_TYPE=Z.ITEM_TYPE AND f.setid = d.setid AND f.item_type = d.item_type AND f.effdt <= %CurrentDateIn) AND d.eff_status = 'A'

  • Related Language Record for SCC_SFP_PAY_VW

    • # 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 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person
    4 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description