SAD_SL_31Z_VW

(SQL View)
 Index Back

Studielink Admissions Suspense


SELECT A.SAD_SL_TRANS_INOUT ,A.SAD_SL_TRANS_DTTM ,A.SAD_SL_TRANS_SEQ ,A.SAD_SL_INDEX_ID ,A.SAD_SL_STDLNK_NBR ,B.SAD_SL_SOURCE_ID ,A.ACAD_CAREER ,A.SAD_SL_PROG_CODE ,A.SAD_SL_EXT_PROG_CD ,A.SAD_SL_BRIN_CODE ,A.SAD_SL_ACAD_LOAD ,A.SAD_SL_ACAD_LEVEL ,A.SAD_SL_ENRL_MANNER ,A.SAD_SL_ACAD_YEAR ,A.SAD_SL_START_MONTH ,A.SAD_SL_START_OCCSN ,A.SAD_SL_SUBINST ,A.SAD_SL_ACTEDU_CITY ,B.SAD_SL_TRANS_STAT FROM PS_SAD_SL_31 A , PS_SAD_SL_TRNS_INF B WHERE A.SAD_SL_TRANS_INOUT = B.SAD_SL_TRANS_INOUT AND A.SAD_SL_TRANS_DTTM =B.SAD_SL_TRANS_DTTM AND A.SAD_SL_TRANS_SEQ = B.SAD_SL_TRANS_SEQ AND A.SAD_SL_INDEX_ID = B.SAD_SL_INDEX_ID AND A.SAD_SL_TRANS_DTTM = ( SELECT MAX(C.SAD_SL_TRANS_DTTM) FROM PS_SAD_SL_31 C WHERE A.ACAD_CAREER =C.ACAD_CAREER AND A.SAD_SL_PROG_CODE =C.SAD_SL_PROG_CODE AND A.SAD_SL_EXT_PROG_CD =C.SAD_SL_EXT_PROG_CD AND A.SAD_SL_BRIN_CODE =C.SAD_SL_BRIN_CODE AND A.SAD_SL_ACAD_LOAD =C.SAD_SL_ACAD_LOAD AND A.SAD_SL_ACAD_LEVEL =C.SAD_SL_ACAD_LEVEL AND A.SAD_SL_ENRL_MANNER =C.SAD_SL_ENRL_MANNER AND A.SAD_SL_ACAD_YEAR =C.SAD_SL_ACAD_YEAR AND A.SAD_SL_START_MONTH =C.SAD_SL_START_MONTH AND A.SAD_SL_START_OCCSN =C.SAD_SL_START_OCCSN AND A.SAD_SL_SUBINST =C.SAD_SL_SUBINST)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SAD_SL_TRANS_INOUT Character(1) VARCHAR2(1) NOT NULL Transaction Direction
I=Inbound
O=Outbound
2 SAD_SL_TRANS_DTTM DateTime(26) TIMESTAMP Transaction DateTime
3 SAD_SL_TRANS_SEQ Number(3,0) SMALLINT NOT NULL Sequence Number
4 SAD_SL_INDEX_ID Character(40) VARCHAR2(40) NOT NULL Index ID
5 SAD_SL_STDLNK_NBR Character(9) VARCHAR2(9) NOT NULL Studielink Number
6 SAD_SL_SOURCE_ID Character(50) VARCHAR2(50) NOT NULL Source ID
7 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
8 SAD_SL_PROG_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
9 SAD_SL_EXT_PROG_CD Character(12) VARCHAR2(12) NOT NULL Alternative programcode
10 SAD_SL_BRIN_CODE Character(4) VARCHAR2(4) NOT NULL Brincode institution
11 SAD_SL_ACAD_LOAD Character(1) VARCHAR2(1) NOT NULL Academic load
1=Full-time
2=Part-time
3=Dual
12 SAD_SL_ACAD_LEVEL Character(1) VARCHAR2(1) NOT NULL Academic Level
B=Bachelor
D=Propaedeutic Bachelor
H=Main
I=Initial Phase
M=Master
P=Propaedeutic Phase
V=Continuation Phase
13 SAD_SL_ENRL_MANNER Character(1) VARCHAR2(1) NOT NULL Enrolment Manner
A=Auditor
D=Participant
E=Extraneus
S=Student
T=Coop/Dual
14 SAD_SL_ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
15 SAD_SL_START_MONTH Character(2) VARCHAR2(2) NOT NULL Start month
16 SAD_SL_START_OCCSN Character(12) VARCHAR2(12) NOT NULL Start Occasion
17 SAD_SL_SUBINST Character(2) VARCHAR2(2) NOT NULL Sub Institute
18 SAD_SL_ACTEDU_CITY Character(24) VARCHAR2(24) NOT NULL City
19 SAD_SL_TRANS_STAT Character(1) VARCHAR2(1) NOT NULL Studielink Message Status
C=Communication Error
E=Transmission Error
G=Partially Processed
M=Manually Resolved
O=Skip Transaction
P=Processed
S=Suspended
T=Test Without XML
U=Unprocessed