ORIGIN_SF_VWLNG

(SQL View)
 Index Back

rellng-Origins Vw no security

ORIGIN_SF_VWLNG is the related language recordfor the record ORIGIN_SF_VW

SELECT a.setid , a.origin_id ,b.language_cd , b.descr , b.descrshort FROM PS_ORIGIN_TBL a , PS_ORIGIN_LNG b WHERE a.setid=b.setid AND a.origin_id=b.origin_id AND a. effdt = ( SELECT MAX(a1.effdt) FROM PS_ORIGIN_TBL a1 WHERE a.setid = a1.setid AND a.origin_id = a1.origin_id AND a1.effdt <= %CurrentDateIn) AND eff_status = 'A'

  • Related Language Record for ORIGIN_SF_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 ORIGIN_ID Character(5) VARCHAR2(5) NOT NULL Origin ID

    Prompt Table: ORIGIN_TBL

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description