TERM_SUMM2SFLNG

(SQL View)
Index Back

Rel Lang Term Summary SF

TERM_SUMM2SFLNG is the language record view related to TERM_SUMM2_SF

SELECT a.business_unit ,a.emplid ,Z.LANGUAGE_CD ,Z.DESCRSHORT ,b.item_type_cd FROM ps_item_sf a ,PS_ITEM_TYPE_TBL b ,ps_bus_unit_tbl_sf c ,PS_TERM_VAL_LANG Z WHERE a.business_unit=c.business_unit AND A.ITEM_TERM=Z.STRM AND a.item_type = b.item_type AND b.setid= ( SELECT d.setid FROM ps_set_cntrl_rec d WHERE d.recname='ITEM_TYPE_TBL' AND d.setcntrlvalue=c.institution) AND b.effdt= ( SELECT MAX(e.effdt) FROM PS_ITEM_TYPE_TBL e WHERE b.setid=e.setid AND b.item_type=e.item_type AND e.effdt <= %CurrentDateIn) AND b.eff_status='A' GROUP BY a.business_unit ,a.emplid ,Z.LANGUAGE_CD ,Z.DESCRSHORT ,b.item_type_cd

  • Related Language Record for TERM_SUMM2_SF
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 ITEM_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Item Type Code
    A=Application Fee
    B=Billing Only
    C=Charge
    D=Deposit
    F=Financial Aid
    G=GL Interface Only
    H=Withholding
    I=Interest
    L=Pre-Paid Tuition
    P=Payment
    R=Refund
    T=Transfers
    V=Contributor Relations
    W=Waiver
    X=Write-off
    Z=Pay Plan Credit