ORIGIN_SF_VW

(SQL View)
 Index Back

Origins View no security


select setid, origin_id, descr, descrshort from PS_ORIGIN_TBL a where 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: ORIGIN_SF_VWLNG

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description