BI_ITEMSF_VWLNG

(SQL View)
 Index Back

Rel Lang Billing Item View

BI_ITEMSF_VWLNG is the language record view related to BI_ITEMSF_VW

SELECT a.business_unit , a.common_id , a.item_nbr , d.language_cd , d.descr FROM ps_item_sf a , PS_ITEM_LINE_SF c , ps_item_type_lng d , ps_bus_unit_tbl_sf e , PS_SCC_PRI_NAME_VW f WHERE c.business_unit = a.business_unit AND c.common_id = a.common_id AND c.sa_id_type = a.sa_id_type AND c.item_nbr = a.item_nbr AND a.sa_id_type = 'P' AND d.item_type = a.item_type AND e.business_unit = a.business_unit AND a.common_id = f.emplid AND f.effdt = ( SELECT MAX(G.EFFDT) FROM PS_SCC_PRI_NAME_VW G WHERE G.EMPLID = F.EMPLID AND G.EFFDT <= %CurrentDateIn) AND d.setid= ( SELECT setid FROM ps_set_cntrl_rec WHERE setcntrlvalue=e.institution AND recname='ITEM_TYPE_TBL') AND d.effdt = ( SELECT MAX(effdt) FROM ps_item_type_lng WHERE d.setid = setid AND d.item_type = item_type AND d.language_cd = language_cd AND effdt <= %CurrentDateIn)

  • Related Language Record for BI_ITEMSF_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    3 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description