SSR_MP_CRSGP_VW

(SQL View)
 Index Back

MyPlanner - Hgrid -Crsgrp VIew


SELECT HDR.INSTITUTION , HDR.SSR_ITEM_ID , ATT.SSR_ITEM_ID , ATT.SSS_SUBJ_CATLG , ATT.UNITS_MINIMUM , ATT.UNITS_MAXIMUM , ' ' , ATT.CRSE_ID , ATT.CRSE_OFFER_NBR , ATT.SUBJECT , ATT.CATALOG_NBR FROM PS_SSR_AIR_H_CGRP HDR , PS_SSR_CRS_OF_AT ATT WHERE HDR.INSTITUTION = ATT.INSTITUTION AND %EffdtCheck(SSR_AIR_H_CGRP HDR_ED, HDR, %CurrentDateIn) AND %EffdtCheck(SSR_CRS_OF_AT ATT_ED, ATT, %CurrentDateIn)

  • Parent record: SSR_AIR_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 SSR_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Academic Item ID
    3 SSR_CHILD_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Child Item ID

    Prompt Table: %EDITTABLE3

    4 SSS_SUBJ_CATLG Character(20) VARCHAR2(20) NOT NULL Subject / Catalog
    5 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units
    6 UNITS_MAXIMUM Number(6,2) DECIMAL(5,2) NOT NULL Maximum Units
    7 UNITS_RANGE Character(15) VARCHAR2(15) NOT NULL Units
    8 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    9 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    10 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    11 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr