SSR_RQ_GRP_U_VW

(SQL View)
 Index Back

Rq Grp Search on Usage

This view is used to search for requirement groups based on the requirement usage. This view is used from the requisite side of the processing.

SELECT RQRMNT_USEAGE , RQRMNT_GROUP , EFFDT , EFF_STATUS , INSTITUTION , ACAD_GROUP , SUBJECT , CATALOG_NBR , DESCR FROM PS_RQ_GRP_TBL

  • Related Language Record: SAA_RQ_GRP_U_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RQRMNT_USEAGE Character(4) VARCHAR2(4) NOT NULL This field is used to specify how the requirement will be used. The value 'SHR1' is reserved for use in a future release.
    ADV=Academic Advisement
    ENR=Requisite/Restriction
    PLNR=Student Planner Report
    SHR=Rq Course Share Restrictn
    SHR1=Entity Course Share Restrictn
    STD=Student Individualized Plan

    Prompt Table: %EDITTABLE8

    2 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    6 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Prompt Table: ACAD_GROUP_TBL

    7 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Prompt Table: SUBJECT_TBL

    8 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr

    Prompt Table: CRSE_CATNO_SRCH

    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description