SADSTDAPPNLDVW(SQL View) |
Index Back |
---|---|
Higher Ed Stdnt Admission ViewApplications record for Higher Education Netherlands |
SELECT A.EMPLID ,A.ACAD_CAREER ,A.STDNT_CAR_NBR ,A.ADM_APPL_NBR ,A.APPL_PROG_NBR ,A.SSR_FORM_STUDY_NLD ,A.SSR_ACAD_LEVEL_NLD ,A.SSR_FUNDING_CD_NLD ,A.SCC_BRINCD_NLD ,A.SSR_SL_PROG_CD_NLD ,A.SSR_SL_ACAD_YR_NLD ,A.SSR_SL_FIRSTYR_NLD ,A.SSR_SL_PAYMODE_NLD ,A.SSR_SL_PAIDBY_NLD ,A.SSR_SL_BL_TRMS_NLD ,A.SSR_SL_STATUS_NLD ,A.SSR_SL_DEFSTAT_NLD ,A.SSR_SL_JOBSTAT_NLD ,A.SSR_SL_ACTSTAT_NLD ,A.SSR_SL_DRAWOPT_NLD ,A.SSR_SL_STATLNG_NLD ,A.SSR_SL_IBGSTAT_NLD ,A.SSR_SL_IBGSRSN_NLD ,A.SSR_SL_IBGDEFI_NLD ,A.SSR_SL_TUITAMT_NLD ,A.SSR_SL_TUITIND_NLD ,A.SSR_SL_DRAW_DT_NLD ,A.SSR_SL_DRAWRST_NLD ,A.SSR_SL_DRAWRSN_NLD ,A.SSR_SL_DRAWSEQ_NLD FROM PS_SAD_STD_APP_NLD A WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_ADM_APPL_PROG A_ED WHERE A.EMPLID = A_ED.EMPLID AND A.ACAD_CAREER = A_ED.ACAD_CAREER AND A.STDNT_CAR_NBR = A_ED.STDNT_CAR_NBR AND A.ADM_APPL_NBR = A_ED.ADM_APPL_NBR AND A.APPL_PROG_NBR = A_ED.APPL_PROG_NBR AND A_ED.EFFDT <= %CurrentDateIn ) AND A.EFFSEQ = ( SELECT MAX(A_ES.EFFSEQ) FROM PS_ADM_APPL_PROG A_ES WHERE A.EMPLID = A_ES.EMPLID AND A.ACAD_CAREER = A_ES.ACAD_CAREER AND A.STDNT_CAR_NBR = A_ES.STDNT_CAR_NBR AND A.ADM_APPL_NBR = A_ES.ADM_APPL_NBR AND A.APPL_PROG_NBR = A_ES.APPL_PROG_NBR AND A.EFFDT = A_ES.EFFDT ) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: HCR_PERSON_I |
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 | STDNT_CAR_NBR | Number(3,0) | SMALLINT NOT NULL | Student Career Nbr |
4 | ADM_APPL_NBR | Character(8) | VARCHAR2(8) NOT NULL |
Application Nbr
Prompt Table: ADM_APPL_DATA |
5 | APPL_PROG_NBR | Number(3,0) | SMALLINT NOT NULL |
Application Program Nbr
Prompt Table: ADM_APP_CAR_SEQ |
6 | SSR_FORM_STUDY_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Form of Study Higher Education
A=Auditor D=Participant E=Extraneus S=Student T=Coop/Dual |
7 | SSR_ACAD_LEVEL_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Academ. Level Higher Education
A=Associate Degree B=Bachelor D=Propaedeutic Bachelor H=Main I=Initial Phase K=Candidate L=University teacher education M=Master P=Propaedeutic Phase Q=Post-Initial T=Interim Doctoral Exam V=Continuation Phase W=Continuing study |
8 | SSR_FUNDING_CD_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Funding Applies
Y/N Table Edit |
9 | SCC_BRINCD_NLD | Character(4) | VARCHAR2(4) NOT NULL | BRINcode |
10 | SSR_SL_PROG_CD_NLD | Character(5) | VARCHAR2(5) NOT NULL | Studielink Program Code |
11 | SSR_SL_ACAD_YR_NLD | Character(4) | VARCHAR2(4) NOT NULL | Academic Year |
12 | SSR_SL_FIRSTYR_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Approval Higher Year
F=False T=True |
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_PAIDBY_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Paid by
A=Other E=Another Institution O=Parents X=Already Paid Z=Student |
15 | SSR_SL_BL_TRMS_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Request Payment Terms
F=False T=True |
16 | SSR_SL_STATUS_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Studielink 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 X=Not a Studielink Participant |
17 | SSR_SL_DEFSTAT_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Deficiency Status
D=Deficient via Institution J=Deficient via IBG counter N=Not yet determined S=Sufficient T=Not Deficient via IBG Counter V=Provisional IBG W=Provisional Institution |
18 | 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 |
19 | 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 |
20 | SSR_SL_DRAWOPT_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Lot Drawing Type
C=Central I=Local N=None S=Selection & Placement |
21 | SSR_SL_STATLNG_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Language Test Status
A=Rejected G=Selected/passed H=Passed N=Not applicable O=Open, not yet determined |
22 | SSR_SL_IBGSTAT_NLD | Character(1) | VARCHAR2(1) NOT NULL |
IBG Status
A=Rejected by RASP G=Sent N=Not sent V=Processed in RASP |
23 | SSR_SL_IBGSRSN_NLD | Character(1) | VARCHAR2(1) NOT NULL |
IBG Status Reason
B=Identity not timely verifieD C=Transcript too late I=Declaration too late L=Too often entered in lotterey M=Not permitted to enter lottery N=Not complied Admin Requisites O=Deceased P=No placement certificate S=Too often selected T=Applied after close date V=No temp placement certificate W=Correspon.nbr changed |
24 | SSR_SL_IBGDEFI_NLD | Character(1) | VARCHAR2(1) NOT NULL | IBG Deficiency Status |
25 | SSR_SL_TUITAMT_NLD | Character(13) | VARCHAR2(13) NOT NULL | Payment Amount |
26 | SSR_SL_TUITIND_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Payment Indicator
F=Not Paid O=Undo Previous Payment T=Paid |
27 | SSR_SL_DRAW_DT_NLD | Date(10) | DATE | Lot Drawing Date |
28 | SSR_SL_DRAWRST_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Lot Drawing Result
D=Locally Drawn I=Selected J=Selected (decentralized) M=Locally Not Participated N=Locally Not Selected O=Conditionally Selected S=Locally Selected U=Centrally Not Selected V=Temp placement certificate |
29 | SSR_SL_DRAWRSN_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Lot Drawing Result Reason
D=Several H=Hardship Clause N=Language Test O=Supremacy V=Not yet sufficient |
30 | SSR_SL_DRAWSEQ_NLD | Character(3) | VARCHAR2(3) NOT NULL | Lot Drawing Number |