SSR_REQS_RGLVWL

(SQL View)
 Index Back

PERC Req Grp Line View for RL


SELECT A.RQRMNT_GROUP , A.EFFDT , A.RQ_LINE_KEY_NBR , A.LANGUAGE_CD , B.RQ_GRP_LINE_TYPE , A.SSR_DESCR80 , A.SAA_DESCRLONG , B.REQUIREMENT FROM PS_RQ_GRP_DETL_LNG A ,PS_RQ_GRP_DETL_TBL B WHERE B.RQRMNT_GROUP = A.RQRMNT_GROUP AND B.EFFDT = A.EFFDT AND B.RQ_LINE_KEY_NBR = A.RQ_LINE_KEY_NBR

  • Parent record: RQ_GRP_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 RQ_LINE_KEY_NBR Character(4) VARCHAR2(4) NOT NULL Background Key
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 RQ_GRP_LINE_TYPE Character(4) VARCHAR2(4) NOT NULL Group Line Type
    COND=Condition
    CRSE=Course
    CRSW=Wild Card Course
    RQ=Requirement
    6 SSR_DESCR80 Character(80) VARCHAR2(80) NOT NULL This field is used for holding the 80 character description used in the xml file for post enrollment requisite check reports.
    7 SAA_DESCRLONG Long Character CLOB This field is used to display information in the new student view for academic advisement reports.
    8 REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement