SSR_AIRITEM_V2L

(SQL View)
 Index Back

SELECT a1.INSTITUTION , a1.SSR_ITEM_TYPE , a1.SSR_ITEM_ID , a1RL.LANGUAGE_CD , a1.EFFDT , a1RL.DESCR50 , b1RL.DESCR FROM PS_SSR_AIR_HDR a1 , PS_SSR_AIR_HDR_LN a1RL , PS_SSR_ITEM_TYPE b1 , PS_SSR_ITEMTYPE_LN b1RL WHERE a1.INSTITUTION = a1RL.INSTITUTION AND a1.SSR_ITEM_ID = a1RL.SSR_ITEM_ID AND a1.EFFDT = a1RL.EFFDT AND a1.SSR_ITEM_TYPE = b1.SSR_ITEM_TYPE AND b1.SSR_ITEM_TYPE = b1RL.SSR_ITEM_TYPE AND a1RL.LANGUAGE_CD = b1RL.LANGUAGE_CD UNION SELECT a2.INSTITUTION , a2.SSR_ITEM_TYPE , a2.SSR_ITEM_ID , a2RL.LANGUAGE_CD , a2.EFFDT , a2RL.DESCR50 , b2.DESCR FROM PS_SSR_AIR_HDR a2 , PS_SSR_AIR_HDR_LN a2RL , PS_SSR_ITEM_TYPE b2 WHERE a2.INSTITUTION = a2RL.INSTITUTION AND a2.SSR_ITEM_ID = a2RL.SSR_ITEM_ID AND a2.EFFDT = a2RL.EFFDT AND a2.SSR_ITEM_TYPE = b2.SSR_ITEM_TYPE AND NOT EXISTS ( SELECT 'X' FROM PS_SSR_ITEMTYPE_LN b2t WHERE b2t.SSR_ITEM_TYPE = b2.SSR_ITEM_TYPE AND b2t.LANGUAGE_CD = a2RL.LANGUAGE_CD) UNION SELECT a3.INSTITUTION , a3.SSR_ITEM_TYPE , a3.SSR_ITEM_ID , a3RL.LANGUAGE_CD , a3.EFFDT , a3.DESCR50 , a3RL.DESCR FROM PS_SSR_AIR_HDR a3 , PS_SSR_ITEM_TYPE b3 , PS_SSR_ITEMTYPE_LN a3RL WHERE a3.SSR_ITEM_TYPE = b3.SSR_ITEM_TYPE AND NOT EXISTS ( SELECT 'X' FROM PS_SSR_AIR_HDR_LN a3t WHERE a3t.INSTITUTION = a3.INSTITUTION AND a3t.SSR_ITEM_ID = a3.SSR_ITEM_ID AND a3t.EFFDT = a3.EFFDT )

  • Related Language Record for SSR_AIR_ITEM_V2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 SSR_ITEM_TYPE2 Character(20) VARCHAR2(20) NOT NULL Item Type
    3 SSR_ITEM_ID_SRCH Character(11) VARCHAR2(11) NOT NULL Academic Item ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description