SSR_AIR_ELEM_V2

(SQL View)
 Index Back

SELECT a.INSTITUTION , a.SSR_ITEM_ID , a.EFFDT , a.SSR_CHILD_ITEM_ID , a.SSR_ITEM_SEQ , b.END_EFFDT , a.RQ_CONNECT , a.SSR_LPAREN_CNT , a.SSR_RPAREN_CNT , b.SSR_ITEM_TYPE , a.SSR_ITEM_WEIGHT , a.SSR_ENRL_CAT , a.DEGREE , b.DESCR50 , b.SSR_DESCRLONG FROM PS_SSR_AIR_ELEM a , PS_SSR_AIR_HDR b WHERE a.INSTITUTION = b.INSTITUTION AND a.SSR_CHILD_ITEM_ID = b.SSR_ITEM_ID AND b.EFFDT <= a.EFFDT AND b.END_EFFDT >= a.EFFDT AND b.EFF_STATUS = 'A'

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

    Default Value: %date

    4 SSR_CHILD_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Child Item ID

    Prompt Table: SSR_AIR_ITEM_VW

    5 SSR_ITEM_SEQ Number(6,0) INTEGER NOT NULL Sequence Number
    6 END_EFFDT Date(10) DATE End Effdt
    7 RQ_CONNECT Character(4) VARCHAR2(4) NOT NULL Detail Connector
    AND=And
    OR=Or
    8 SSR_LPAREN_CNT Number(1,0) SMALLINT NOT NULL Parenthesis
    9 SSR_RPAREN_CNT Number(1,0) SMALLINT NOT NULL Parenthesis
    10 SSR_ITEM_TYPE Character(20) VARCHAR2(20) NOT NULL Academic Item Type

    Prompt Table: SSR_ITEM_TYPE

    11 SSR_ITEM_WEIGHT Number(3,0) SMALLINT NOT NULL Item Weight
    12 SSR_ENRL_CAT Character(4) VARCHAR2(4) NOT NULL Enrollment Category

    Prompt Table: SSR_ENRL_CAT

    13 DEGREE Character(8) VARCHAR2(8) NOT NULL Degree

    Prompt Table: DEGREE_INTRN_VW

    14 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    15 SSR_DESCRLONG Long Character CLOB Description