RQENTITYSRCHLNG

(SQL View)
 Index Back

Search record for Entity group

This view is used to select only those entity groups that are of the type specified by the user in the Condition code.

SELECT A.ENTITY_GROUP_TYPE , A.RQRMNT_USEAGE , A.RQ_ENTITY_GROUP , A.EFFDT , L.LANGUAGE_CD , L.DESCR FROM PS_RQ_ENTITY_SRCH A , PS_RQ_ENT_GRP_LANG L WHERE A.RQ_ENTITY_GROUP = L.RQ_ENTITY_GROUP AND A.EFFDT = L.EFFDT

  • Related Language Record for RQ_ENTITY_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ENTITY_GROUP_TYPE Character(4) VARCHAR2(4) NOT NULL Entity Group Type
    PLAN=Plan
    PRGM=Program
    SGRP=Student Group
    SPLN=Sub Plan
    2 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
    3 RQ_ENTITY_GROUP Character(6) VARCHAR2(6) NOT NULL Academic Entity Group
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description