SAD_SL_ACT_VW2

(SQL View)
 Index Back

Studielink Actions View

View of Studielink Actions for a student, indexed by EMPLID, INSTITUTION, ACAD_CAREER, ACAD_PROG and SAD_SL_MSG_CODE. These will provide a unique row. Used for Studielink equations.

SELECT MAX(A.EMPLID) ,MAX(A.INSTITUTION) ,MAX(A.ACAD_CAREER) ,MAX(A.ACAD_PROG) ,MAX(A.ACAD_YEAR) ,MAX(A.ACAD_PLAN) ,MAX(A.SCC_BRINCD_NLD) ,MAX(A.SAD_SL_MSG_CODE) ,MAX(A.SAD_SL_ACTN_SEQ) ,MAX(A.SAD_SL_ACTN_DTTM) ,MAX(A.SAD_SL_TRANS_INOUT) ,MAX(A.SAD_SL_TRANS_DTTM) ,MAX(A.SAD_SL_TRANS_SEQ) ,MAX(A.SAD_SL_INDEX_ID) FROM PS_SAD_SL_ACTION A WHERE A.SAD_SL_ACTN_SEQ = ( SELECT MAX(B.SAD_SL_ACTN_SEQ) FROM PS_SAD_SL_ACTION B WHERE B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.ACAD_CAREER = A.ACAD_CAREER AND B.ACAD_PROG = A.ACAD_PROG AND B.SAD_SL_MSG_CODE = A.SAD_SL_MSG_CODE ) AND A.SAD_SL_TRANS_INOUT ='O' GROUP BY A.EMPLID ,A.INSTITUTION ,A.ACAD_CAREER ,A.ACAD_PROG ,A.SAD_SL_MSG_CODE,A.ACAD_YEAR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
4 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
5 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
6 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
7 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode
8 SAD_SL_MSG_CODE Character(4) VARCHAR2(4) NOT NULL Studielink Message
9 SAD_SL_ACTN_SEQ Number(5,0) INTEGER NOT NULL Action Sequence
10 SAD_SL_ACTN_DTTM DateTime(26) TIMESTAMP Action DateTime
11 SAD_SL_TRANS_INOUT Character(1) VARCHAR2(1) NOT NULL Transaction Direction
I=Inbound
O=Outbound
12 SAD_SL_TRANS_DTTM DateTime(26) TIMESTAMP Transaction DateTime
13 SAD_SL_TRANS_SEQ Number(3,0) SMALLINT NOT NULL Sequence Number
14 SAD_SL_INDEX_ID Character(40) VARCHAR2(40) NOT NULL Index ID