SSR_REQS_RG_VW(SQL View) |
Index Back |
---|---|
Post Requisite Report ViewThis 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 |