SSR_ENRL_DRP_VW

(SQL View)
 Index Back

APT Enrollment view


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 ,BEV.ENRL_REQ_ACTION ,BEV.ENRL_REQ_DETL_STAT FROM PS_SSR_APT_REQUEST REQ ,PS_SSR_APT_REQXREF XREF , PS_ENRL_REQ_DETAIL BEV 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 REQ.EMPLID = BEV.EMPLID AND REQ.ACAD_CAREER = BEV.ACAD_CAREER AND REQ.INSTITUTION = BEV.INSTITUTION AND XREF.STRM = BEV.STRM AND XREF.CLASS_NBR = BEV.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 ENRL_REQ_ACTION Character(2) VARCHAR2(2) NOT NULL Enrollment Request Action
A=Add Grade
C=Change Grade
D=Drop
E=Enroll
M=Normal Maintenance
P=Change Wait List Position
R=Remove Grade
S=Swap Courses
W=Drop to Wait List
13 ENRL_REQ_DETL_STAT Character(1) VARCHAR2(1) NOT NULL Enrollment Req Detail Status
E=Errors found
M=Success/Messages
P=Pending
S=Success
X=Pending