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 |