SSR_BR_ROVV_NLD

(SQL View)
 Index Back

Results Outcome Current View 4

Results Outcome current view for VAVO

SELECT DISTINCT ES.EMPLID , ES.INSTITUTION , ES.SCC_BRINCD_NLD , ES.SSR_BR_ENRL_SQ_NLD , ES.SSR_BR_ENRL_SQ_NLD , 'Y' AS SSR_BR_OUTCIND_NLD ,TRM.ACAD_YEAR AS SSR_BR_ACD_YR_NLD , CASE WHEN AP.PROG_ACTION = 'COMP' THEN 'G' ELSE CASE WHEN (%Sql(SSR_BR_VA_EX_RES_PGAC_FAIL_NLD, ES.INSTITUTION, ES.SCC_BRINCD_NLD, AP.EFFDT, AP.PROG_ACTION, AP.PROG_REASON)) IS NOT NULL THEN 'A' ELSE 'D' END END AS SSR_BR_OUTCOM_NLD ,%Coalesce( (%SQL(SSR_BR_VA_EDU_LVL_NLD, APG.HEGIS_CODE, AP.EFFDT)), ' ') AS SCC_EDU_LEVEL_NLD , AP.EFFDT AS SSR_BR_RES_DT_NLD , CASE WHEN AP.PROG_ACTION = 'COMP' THEN CASE WHEN (%Sql(SSR_BR_VA_CUMLAUDE_SQL, ES.INSTITUTION, ES.SCC_BRINCD_NLD, AP.PROG_REASON)) IS NOT NULL THEN 'Y' ELSE 'N' END END AS SSR_BR_CUM_LAU_NLD , ES.ACAD_CAREER ,ES.STDNT_CAR_NBR FROM PS_SSR_BR_ENVVWNLD ES , PS_ACAD_PROG AP JOIN PS_ACAD_PROG_TBL APG ON APG.INSTITUTION = AP.INSTITUTION AND AP.ACAD_PROG = APG.ACAD_PROG AND APG.EFFDT = ( SELECT MAX(APG1.EFFDT) FROM PS_ACAD_PROG_TBL APG1 WHERE APG1.INSTITUTION = APG.INSTITUTION AND APG1.ACAD_PROG = APG.ACAD_PROG AND APG1.EFFDT <= AP.EFFDT) , PS_SSR_APT_HDR APT ,PS_TERM_TBL TRM WHERE ES.EMPLID = AP.EMPLID AND ES.ACAD_CAREER =AP.ACAD_CAREER AND ES.STDNT_CAR_NBR = AP.STDNT_CAR_NBR AND AP.EFFDT = ( SELECT MAX(AP_ED.EFFDT) FROM PS_ACAD_PROG AP_ED WHERE AP_ED.INSTITUTION = AP.INSTITUTION AND AP_ED.EMPLID = AP.EMPLID AND AP_ED.ACAD_CAREER =AP.ACAD_CAREER AND AP_ED.STDNT_CAR_NBR = AP.STDNT_CAR_NBR) AND AP.EFFSEQ = ( SELECT MAX(AP_E.EFFSEQ) FROM PS_ACAD_PROG AP_E WHERE AP_E.INSTITUTION = AP.INSTITUTION AND AP_E.EMPLID = AP.EMPLID AND AP_E.ACAD_CAREER = AP.ACAD_CAREER AND AP_E.STDNT_CAR_NBR = AP.STDNT_CAR_NBR AND AP_E.EFFDT = AP.EFFDT) AND AP.PROG_ACTION IN (%Sql(SSR_BR_VA_OUTCOME_PRGACT_SQL, ES.INSTITUTION, ES.SCC_BRINCD_NLD)) AND APT.INSTITUTION = ES.INSTITUTION AND APT.EMPLID = ES.EMPLID AND APT.SSR_APT_INSTANCE = AP.SSR_APT_INSTANCE AND TRM.INSTITUTION = APT.INSTITUTION AND TRM.ACAD_CAREER = APT.ACAD_CAREER AND TRM.STRM = APT.REQ_TERM AND 1 = (CASE WHEN (%Sql(SSR_BR_VA_EX_RES_PGAC_NLD, ES.INSTITUTION, ES.SCC_BRINCD_NLD, AP.EFFDT, AP.PROG_ACTION, AP.PROG_REASON)) IS NOT NULL THEN '0' ELSE '1' END)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode
4 SSR_BR_ENRL_SQ_NLD Character(20) VARCHAR2(20) NOT NULL 2020-04-15 bug 31180485 - enlarged enrollment seq nbr
5 SSR_BR_XRSL_SQ_NLD Character(20) VARCHAR2(20) NOT NULL Exam Result sequence Number
6 SSR_BR_OUTCIND_NLD Character(1) VARCHAR2(1) NOT NULL Outcome indicator only used as a static key in records MROV, MRPV, MRLV and MRGV records in VAVO

Default Value: Y

7 SSR_BR_ACD_YR_NLD Character(4) VARCHAR2(4) NOT NULL Exam Regime Year
8 SSR_BR_OUTCOM_NLD Character(1) VARCHAR2(1) NOT NULL Outcome
A=Turned down
D=Part exam
G=Successful
9 SCC_EDU_LEVEL_NLD Character(4) VARCHAR2(4) NOT NULL Education level
ATH=Atheneum
BB=VMBO Basic Professional Ed
GL=VMBO Mixed Professional Ed
GYM=Gymnasium
HA=HAVO
HBO=College Degree
KB=VMBO Kader Professional Ed
KSB1=Kwalification Structure PrEd 1
KSB2=Kwalification Structure PrEd 2
KSB3=Kwalification Structure PrEd 3
KSB4=Kwalification Structure PrEd 4
TL=VMBO Theoretic Professional Ed
VWO=VWO
WO=University Degree
10 SSR_BR_RES_DT_NLD Date(10) DATE NOT NULL Result Date
11 SSR_BR_CUM_LAU_NLD Character(1) VARCHAR2(1) NOT NULL Indication Cum Laude (Honors)

Y/N Table Edit

12 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
13 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr