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