SSR_AIR_ITEM_V2

(SQL View)
Index Back

AIR Hdr + Item Type


SELECT a.INSTITUTION , a.SSR_ITEM_TYPE , a.SSR_ITEM_ID , a.EFFDT , a.END_EFFDT , a.EFF_STATUS , a.DESCR50 , b.DESCR , a.EFFDT FROM PS_SSR_AIR_HDR a , PS_SSR_ITEM_TYPE b WHERE a.SSR_ITEM_TYPE = b.SSR_ITEM_TYPE

  • Related Language Record: SSR_AIRITEM_V2L
  • # 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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 END_EFFDT Date(10) DATE End Effdt
    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    7 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 ORIG_EFFDT Date(10) DATE Original Effdt