SSR_SLSTD_19_VW(SQL View) |
Index Back |
---|---|
Studielink Current Pay status |
SELECT A.INSTITUTION ,A.ACAD_CAREER ,A.EMPLID ,A.ACAD_PROG ,B.ACAD_PLAN ,C.SCC_BRINCD_NLD ,C.ACAD_YEAR ,A.STDNT_CAR_NBR ,C.SSR_SL_PAIDBY_NLD ,C.SSR_SL_TUITIND_NLD ,C.SSR_SL_TUITAMT_NLD ,C.SSR_SL_PDINST_NLD ,C.SSR_SL_PAYMODE_NLD ,C.SSR_SL_TUITNBR_NLD ,C.SSR_SL_PDINSTN_NLD FROM PS_ACAD_PROG A , PS_ACAD_PLAN B , PS_SSR_STD_PRG_NLD C , PS_EXTERNAL_SYSTEM D WHERE A.EMPLID =B.EMPLID AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STDNT_CAR_NBR = B.STDNT_CAR_NBR AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND A.EMPLID =C.EMPLID AND A.ACAD_CAREER = C.ACAD_CAREER AND A.STDNT_CAR_NBR = C.STDNT_CAR_NBR AND A.EMPLID = D.EMPLID AND D.EXTERNAL_SYSTEM ='SLN' AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_EXTERNAL_SYSTEM D1 WHERE D.EMPLID = D1.EMPLID AND D.EXTERNAL_SYSTEM = D1.EXTERNAL_SYSTEM AND D1.EFFDT <= %CurrentDateIn) AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_ACAD_PROG A1 WHERE A.EMPLID =A1.EMPLID AND A.ACAD_CAREER = A1.ACAD_CAREER AND A.STDNT_CAR_NBR = A1.STDNT_CAR_NBR AND A1.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_ACAD_PROG A2 WHERE A.EMPLID =A2.EMPLID AND A.ACAD_CAREER = A2.ACAD_CAREER AND A.STDNT_CAR_NBR = A2.STDNT_CAR_NBR AND A.EFFDT =A2.EFFDT) AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_SSR_STD_PRG_NLD C1 WHERE C.EMPLID =C1.EMPLID AND C.ACAD_CAREER = C1.ACAD_CAREER AND C.STDNT_CAR_NBR = C1.STDNT_CAR_NBR AND C1.EFFDT <= %CurrentDateIn) AND C.EFFSEQ = ( SELECT MAX(C2.EFFSEQ) FROM PS_SSR_STD_PRG_NLD C2 WHERE C.EMPLID =C2.EMPLID AND C.ACAD_CAREER = C2.ACAD_CAREER AND C.STDNT_CAR_NBR = C2.STDNT_CAR_NBR AND C.EFFDT =C2.EFFDT) AND C.SSR_SL_TUITAMT_NLD <> ' ' AND C.SSR_SL_PDINST_NLD <> ' ' AND C.SSR_SL_PDINSTN_NLD <> ' ' AND C.SSR_SL_TUITIND_NLD = 'T' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
2 | 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 |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
4 | ACAD_PROG | Character(5) | VARCHAR2(5) NOT NULL | Academic Program |
5 | ACAD_PLAN | Character(10) | VARCHAR2(10) NOT NULL | Academic Plan |
6 | SCC_BRINCD_NLD | Character(4) | VARCHAR2(4) NOT NULL | BRINcode |
7 | ACAD_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Academic Year |
8 | STDNT_CAR_NBR | Number(3,0) | SMALLINT NOT NULL | Student Career Nbr |
9 | SSR_SL_PAIDBY_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Paid by
A=Other E=Another Institution O=Parents X=Already Paid Z=Student |
10 | SSR_SL_TUITIND_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Payment Indicator
F=Not Paid O=Undo Previous Payment T=Paid |
11 | SSR_SL_TUITAMT_NLD | Character(13) | VARCHAR2(13) NOT NULL | Payment Amount |
12 | SSR_SL_PDINST_NLD | Character(4) | VARCHAR2(4) NOT NULL | Paid at Brincode |
13 | SSR_SL_PAYMODE_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Studielink Form of Payment
0=Payment Transfer 1=Auth Printed by Institution 2=Auth Printed by Student 3=Foreign Account Number 4=Other 5=E-Payment 6=Electronic Direct Debit 7=Via Institution 8=Non SEPA Country |
14 | SSR_SL_TUITNBR_NLD | Character(2) | VARCHAR2(2) NOT NULL | Number of Payments |
15 | SSR_SL_PDINSTN_NLD | Character(70) | VARCHAR2(70) NOT NULL | paidatinstitutename paidatins |