SSR_REQS_RG_VW

(SQL View)
Index Back

Post Requisite Report View

This view is used to hold the data used to create the xml data file for the post enrollment requisite check report. This view may not work correctly for selecting data as it is meant to be used in a file layout to create the xml report.

SELECT A.INSTITUTION , A.STRM , A.CLASS_NBR , A.RQRMNT_GROUP , C.DESCR , C.SAA_DESCR80 , C.DESCR254A , C.DESCRLONG FROM PS_SSR_REQS_RSLTS A , PS_TERM_TBL B , PS_RQ_GRP_TBL C WHERE A.INSTITUTION = B.INSTITUTION AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STRM = B.STRM AND A.RQRMNT_GROUP = C.RQRMNT_GROUP AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_RQ_GRP_TBL C1 WHERE C.RQRMNT_GROUP = C1.RQRMNT_GROUP AND C1.EFFDT <= B.TERM_BEGIN_DT AND C1.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 STRM Character(4) VARCHAR2(4) NOT NULL Term

Default Value: OPR_DEF_TBL_CS.STRM

Prompt Table: TERM_VAL_TBL

3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
4 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group

Prompt Table: RQ_GRP_TBL

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 SAA_DESCR80 Character(80) VARCHAR2(80) NOT NULL This field is used to display information in the new student view for academic advisement reports.
7 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description
8 DESCRLONG Long Character CLOB Long Description