SSR_AIRMAIN_VLN

(SQL View)
Index Back

AIR Hdr+Attribs Lang Vw


SELECT a.INSTITUTION , a.SSR_ITEM_ID , a.EFFDT , b.SCC_CAF_ATTR_SEQ , a.LANGUAGE_CD , a.DESCR50 , b.SCC_CAF_ATTR_VAL , b.SCC_CAF_ATTR_TVAL , a.SSR_DESCRLONG , b.SCC_CAF_ATTR_LVAL FROM PS_SSR_AIR_HDR x , PS_SSR_AIR_HDR_LN a , PS_SSR_AIR_ADD_LNG b WHERE x.INSTITUTION = a.INSTITUTION AND x.SSR_ITEM_ID = a.SSR_ITEM_ID AND x.EFFDT = a.EFFDT AND x.INSTITUTION = b.INSTITUTION AND x.SSR_ITEM_ID = b.SSR_ITEM_ID AND x.EFFDT = b.EFFDT AND a.LANGUAGE_CD = b.LANGUAGE_CD UNION ALL SELECT a.INSTITUTION , a.SSR_ITEM_ID , a.EFFDT , y.SCC_CAF_ATTR_SEQ , a.LANGUAGE_CD , a.DESCR50 , y.SCC_CAF_ATTR_VAL , y.SCC_CAF_ATTR_TVAL , a.SSR_DESCRLONG , y.SCC_CAF_ATTR_LVAL FROM PS_SSR_AIR_HDR x , PS_SSR_AIR_HDR_LN a , PS_SSR_AIR_ADD y WHERE x.INSTITUTION = a.INSTITUTION AND x.SSR_ITEM_ID = a.SSR_ITEM_ID AND x.EFFDT = a.EFFDT AND x.INSTITUTION = y.INSTITUTION AND x.SSR_ITEM_ID = y.SSR_ITEM_ID AND x.EFFDT = y.EFFDT AND NOT EXISTS ( SELECT 'X' FROM PS_SSR_AIR_ADD_LNG b WHERE b.INSTITUTION = y.INSTITUTION AND b.SSR_ITEM_ID = y.SSR_ITEM_ID AND b.EFFDT = y.EFFDT AND b.LANGUAGE_CD = a.LANGUAGE_CD) UNION ALL SELECT x.INSTITUTION , x.SSR_ITEM_ID , x.EFFDT , b.SCC_CAF_ATTR_SEQ , b.LANGUAGE_CD , x.DESCR50 , b.SCC_CAF_ATTR_VAL , b.SCC_CAF_ATTR_TVAL , x.SSR_DESCRLONG , b.SCC_CAF_ATTR_LVAL FROM PS_SSR_AIR_HDR x , PS_SSR_AIR_ADD_LNG b WHERE x.INSTITUTION = b.INSTITUTION AND x.SSR_ITEM_ID = b.SSR_ITEM_ID AND x.EFFDT = b.EFFDT AND NOT EXISTS ( SELECT 'X' FROM PS_SSR_AIR_HDR_LN a WHERE a.INSTITUTION = x.INSTITUTION AND a.SSR_ITEM_ID = x.SSR_ITEM_ID AND a.EFFDT = x.EFFDT AND a.LANGUAGE_CD = b.LANGUAGE_CD)

  • Related Language Record for SSR_AIR_MAIN_V2 SSR_AIR_MAIN_VW
  • # 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_ID Character(11) VARCHAR2(11) NOT NULL Academic Item ID
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 SCC_CAF_ATTR_SEQ Number(4,0) SMALLINT NOT NULL Attribute Sequence
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    7 SCC_CAF_ATTR_VAL Character(20) VARCHAR2(20) NOT NULL Attribute Value
    8 SCC_CAF_ATTR_TVAL Character(50) VARCHAR2(50) NOT NULL Text Value
    9 SSR_DESCRLONG Long Character CLOB Description
    10 SCC_CAF_ATTR_LVAL Long Character CLOB Long Text Value