PAYMNTTBLVW3LNG

(SQL View)
 Index Back

Payment Item VW

PAYMNTTBLVW3LNG is the related language recordfor the record PAYMENT_TBL_VW3

SELECT a.business_unit ,a.emplid ,a.ext_org_id ,z.language_cd ,z.descr 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' GROUP BY a.business_unit ,a.emplid ,a.ext_org_id ,z.language_cd,z.descr

  • Related Language Record for PAYMENT_TBL_VW3

    • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    3 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description