SAD_SL_25_VW

(SQL View)
Index Back

Studielink Msg 25 View


SELECT C.EMPLID , F.ACAD_PROG , %Substring(A.SAD_SL_EXT_PROG_CD, 1, 10) , A.SAD_SL_BRIN_CODE , A.SAD_SL_ACAD_YEAR , A.SAD_SL_SUBINST , E.SAD_SL_ACTN_SEQ , A.SAD_SL_INDEX_ID , A.SAD_SL_STDLNK_NBR , A.SAD_SL_NAME_TEXT , A.SAD_SL_O_NBR , A.SAD_SL_CIOP_NBR , A.SAD_SL_SOFI_NBR , A.SAD_SL_STUD_NBR , A.SAD_SL_ACTIVITY_DT , A.SAD_SL_STATUS , A.SAD_SL_EXT_PROG_CD , A.SAD_SL_ACAD_LOAD , A.SAD_SL_ACTEDU_CITY , A.SAD_SL_ACAD_LEVEL , A.SAD_SL_ENRL_MANNER , A.SAD_SL_ACAD_YEAR , A.SAD_SL_START_MONTH , A.SAD_SL_PAYED_BY , A.SSR_SL_PAYMODE_NLD , A.SAD_SL_PAY_NAME , A.SAD_SL_ADDR_TYPE , A.SAD_SL_STREET , A.SAD_SL_APT_TYPE , A.SAD_SL_APT_PREFIX , A.SAD_SL_APT_NBR , A.SAD_SL_APT_SUFFIX , A.SAD_SL_POST_CODE , A.SAD_SL_CITY , A.SAD_SL_CNTRY , A.SAD_SL_POST_CD_CHK , A.SAD_SL_FORGN_TYPE , A.SAD_SL_FORGN_ADDR1 , A.SAD_SL_FORGN_ADDR2 , A.SAD_SL_FORGN_ADDR3 , A.SAD_SL_FORGN_CNTRY , A.SAD_SL_ACCT_NBR , A.SAD_SL_TERMS_IND , A.SAD_SL_START_OCCSN , A.SAD_SL_ACAD_LOAD_O , A.SAD_SL_FORGN_ACCNO , A.SAD_SL_BANK_NAME , A.SAD_SL_BANK_CNTRY , A.SAD_SL_STATJOB_REQ , A.SAD_SL_STATACT_REQ FROM PS_SAD_SL_25 A ,PS_EXTERNAL_SYSTEM C ,PS_SAD_SL_TRNS_INF D ,PS_ACAD_PROG_TBL F ,PS_SAD_SL_ACTION E WHERE A.SAD_SL_TRANS_INOUT='I' AND A.SAD_SL_TRANS_DTTM=D.SAD_SL_TRANS_DTTM AND A.SAD_SL_TRANS_INOUT=D.SAD_SL_TRANS_INOUT AND A.SAD_SL_TRANS_SEQ=D.SAD_SL_TRANS_SEQ AND A.SAD_SL_INDEX_ID=D.SAD_SL_INDEX_ID AND A.SAD_SL_TRANS_DTTM=E.SAD_SL_TRANS_DTTM AND A.SAD_SL_TRANS_INOUT=E.SAD_SL_TRANS_INOUT AND A.SAD_SL_TRANS_SEQ=E.SAD_SL_TRANS_SEQ AND A.SAD_SL_INDEX_ID=E.SAD_SL_INDEX_ID AND D.SAD_SL_TRANS_STAT='P' AND C.EXTERNAL_SYSTEM='SLN' AND A.SAD_SL_STATUS <> 'N' AND A.SAD_SL_STDLNK_NBR = C.EXTERNAL_SYSTEM_ID AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_EXTERNAL_SYSTEM C1 WHERE C.EMPLID = C1.EMPLID AND C.EXTERNAL_SYSTEM = C1.EXTERNAL_SYSTEM AND C1.EFFDT <= %CurrentDateIn) AND A.SAD_SL_TRANS_DTTM=( SELECT MAX(E.SAD_SL_TRANS_DTTM) FROM PS_SAD_SL_25 E WHERE E.SAD_SL_STDLNK_NBR=A.SAD_SL_STDLNK_NBR AND E.SAD_SL_BRIN_CODE=A.SAD_SL_BRIN_CODE AND E.SAD_SL_PROG_CODE=A.SAD_SL_PROG_CODE AND E.SAD_SL_EXT_PROG_CD =A.SAD_SL_EXT_PROG_CD ) AND F.CIP_CODE = A.SAD_SL_PROG_CODE AND F.EFFDT = ( SELECT MAX(F1.EFFDT) FROM PS_ACAD_PROG_TBL F1 WHERE F.INSTITUTION = F1.INSTITUTION AND F.ACAD_PROG = F1.ACAD_PROG AND F1.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
3 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
4 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode
5 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
6 SCC_SUBBRINCD_NLD Character(2) VARCHAR2(2) NOT NULL Sub Institute
7 SAD_SL_ACTN_SEQ Number(5,0) INTEGER NOT NULL Action Sequence
8 SAD_SL_INDEX_ID Character(40) VARCHAR2(40) NOT NULL Index ID
9 SAD_SL_STDLNK_NBR Character(9) VARCHAR2(9) NOT NULL Studielink Number
10 SAD_SL_NAME_TEXT Character(220) VARCHAR2(220) NOT NULL Merged name
11 SAD_SL_O_NBR Character(9) VARCHAR2(9) NOT NULL Onumber
12 SAD_SL_CIOP_NBR Character(12) VARCHAR2(12) NOT NULL Correspondence number
13 SAD_SL_SOFI_NBR Character(9) VARCHAR2(9) NOT NULL Social Fiscal Number
14 SAD_SL_STUD_NBR Character(12) VARCHAR2(12) NOT NULL Student Number
15 SAD_SL_ACTIVITY_DT Character(10) VARCHAR2(10) NOT NULL Activity Date
16 SAD_SL_STATUS Character(1) VARCHAR2(1) NOT NULL Status
B=Continuing Application
G=Cancelled/Withdrawn
I=Registered/Enrolled
N=No Re-Enrollment
R=Rejected/Denied
S=Study Suspended
U=Departed
V=Enrollment Requested
W=Data Change
X=Not a Studielink Participant
17 SAD_SL_EXT_PROG_CD Character(12) VARCHAR2(12) NOT NULL Alternative programcode
18 SAD_SL_ACAD_LOAD Character(1) VARCHAR2(1) NOT NULL Academic load
1=Full-time
2=Part-time
3=Dual
19 SAD_SL_ACTEDU_CITY Character(24) VARCHAR2(24) NOT NULL City
20 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
21 SAD_SL_ENRL_MANNER Character(1) VARCHAR2(1) NOT NULL Enrolment Manner
A=Auditor
D=Participant
E=Extraneus
S=Student
T=Coop/Dual
22 SAD_SL_ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
23 SAD_SL_START_MONTH Character(2) VARCHAR2(2) NOT NULL Start month
24 SAD_SL_PAYED_BY Character(1) VARCHAR2(1) NOT NULL Payed By
25 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
26 SAD_SL_PAY_NAME Character(220) VARCHAR2(220) NOT NULL Payment Method name
27 SAD_SL_ADDR_TYPE Character(9) VARCHAR2(9) NOT NULL Address Type
28 SAD_SL_STREET Character(80) VARCHAR2(80) NOT NULL Street Name
29 SAD_SL_APT_TYPE Character(35) VARCHAR2(35) NOT NULL Apartment Type
30 SAD_SL_APT_PREFIX Character(2) VARCHAR2(2) NOT NULL Apartment Number Prefix
31 SAD_SL_APT_NBR Character(5) VARCHAR2(5) NOT NULL Apartment Number
32 SAD_SL_APT_SUFFIX Character(5) VARCHAR2(5) NOT NULL Apartment Num Suffix
33 SAD_SL_POST_CODE Character(6) VARCHAR2(6) NOT NULL Postal Code
34 SAD_SL_CITY Character(30) VARCHAR2(30) NOT NULL City
35 SAD_SL_CNTRY Character(4) VARCHAR2(4) NOT NULL Country Code
36 SAD_SL_POST_CD_CHK Character(1) VARCHAR2(1) NOT NULL Postcodecheck
F=False
T=True
37 SAD_SL_FORGN_TYPE Character(9) VARCHAR2(9) NOT NULL Foreign Address Type
38 SAD_SL_FORGN_ADDR1 Character(35) VARCHAR2(35) NOT NULL Street Name
39 SAD_SL_FORGN_ADDR2 Character(35) VARCHAR2(35) NOT NULL City
40 SAD_SL_FORGN_ADDR3 Character(35) VARCHAR2(35) NOT NULL Additional Address
41 SAD_SL_FORGN_CNTRY Character(4) VARCHAR2(4) NOT NULL Foreign Address Country
42 SAD_SL_ACCT_NBR Character(10) VARCHAR2(10) NOT NULL Payment method bank/giroaccnt
43 SAD_SL_TERMS_IND Character(1) VARCHAR2(1) NOT NULL Payment method periods
44 SAD_SL_START_OCCSN Character(12) VARCHAR2(12) NOT NULL Start Occasion
45 SAD_SL_ACAD_LOAD_O Character(1) VARCHAR2(1) NOT NULL Old Academic Load
46 SAD_SL_FORGN_ACCNO Character(34) VARCHAR2(34) NOT NULL Foreign Accountnbr
47 SAD_SL_BANK_NAME Character(50) VARCHAR2(50) NOT NULL Bankname
48 SAD_SL_BANK_CNTRY Character(4) VARCHAR2(4) NOT NULL Bank Country
49 SSR_SL_JOBSTAT_NLD Character(1) VARCHAR2(1) NOT NULL Prof Requirements Status
A=Rejected
G=Selected/passed
N=Not Applicable
O=Open, not yet determined
50 SSR_SL_ACTSTAT_NLD Character(1) VARCHAR2(1) NOT NULL Professional Duties Status
A=Rejected
G=Selected/passed
N=Not applicable
O=Open, not yet determined