SAA_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 academic advisement side of the processing.

SELECT RQRMNT_USEAGE , RQRMNT_GROUP , EFFDT , EFF_STATUS , INSTITUTION , ACAD_CAREER , ACAD_PROG , ACAD_PLAN , ACAD_SUB_PLAN , 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_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Prompt Table: ACAD_CAR_TBL

    7 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_CARVW

    8 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ACAD_PLAN_TBL

    9 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan

    Prompt Table: ACAD_SUBPLN_TBL

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