SSR_ENRL_GRDCVW(SQL View) |
Index Back |
---|
SELECT XREF.ENRL_REQUEST_ID ,XREF.ENRL_REQ_DETL_SEQ ,REQ.EMPLID ,REQ.INSTITUTION ,REQ.SSR_APT_INSTANCE ,XREF.SSR_APT_ITEM_SEQ ,XREF.ATTEMPT_NBR ,XREF.STRM ,BEV.CLASS_NBR ,XREF.CRSE_ID ,XREF.CRSE_OFFER_NBR ,GRD.SSR_COMPONENT ,GRD.ASSOCIATED_CLASS ,BEV.ENRL_ACTION_LAST FROM PS_SSR_APT_REQUEST REQ ,PS_SSR_APT_REQXREF XREF , PS_SSR_ENRL_BEVNT BEV , PS_STDNT_ENRL_SSV1 GRD WHERE REQ.SSR_APT_REQUEST_ID = XREF.SSR_APT_REQUEST_ID AND XREF.ENRL_REQUEST_ID = BEV.ENRL_REQUEST_ID AND XREF.ENRL_REQ_DETL_SEQ = BEV.ENRL_REQ_DETL_SEQ AND BEV.EMPLID = GRD.EMPLID AND BEV.ACAD_CAREER = GRD.ACAD_CAREER AND BEV.INSTITUTION = GRD.INSTITUTION AND BEV.STRM = GRD.STRM AND BEV.CLASS_NBR = GRD.CLASS_NBR |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ENRL_REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Enrollment Request ID |
2 | ENRL_REQ_DETL_SEQ | Number(6,0) | INTEGER NOT NULL | Enrollment Req Detail Sequence |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
5 | SSR_APT_INSTANCE | Number(3,0) | SMALLINT NOT NULL | Academic Progress Tracker Instance Number |
6 | SSR_APT_ITEM_SEQ | Number(6,0) | INTEGER NOT NULL | APT Item Seq |
7 | ATTEMPT_NBR | Number(3,0) | SMALLINT NOT NULL | Attempt Nbr |
8 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
9 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Class Nbr |
10 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
11 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
12 | SSR_COMPONENT | Character(3) | VARCHAR2(3) NOT NULL |
Course Component.
CLN=Clinical CON=Continuance DIS=Discussion FLD=Field Studies IND=Independent Study LAB=Laboratory LEC=Lecture PRA=Practicum RSC=Research SEM=Seminar SUP=Supervision THE=Thesis Research TUT=Tutorial |
13 | ASSOCIATED_CLASS | Number(4,0) | SMALLINT NOT NULL | Associated Class |
14 | ENRL_ACTION_LAST | Character(2) | VARCHAR2(2) NOT NULL | Last Enrollment Action |