SSR_BR_BPVW_NLD

(SQL View)
 Index Back

BPV Service Current View

BPV Service Current View

SELECT DISTINCT ES.INSTITUTION , ES.SCC_BRINCD_NLD , ES.EMPLID , ES.SSR_BR_ENRL_SQ_NLD , BPV.SAD_BR_BPV_SEQ_NLD , BPV.SAD_BR_BPV_CRT_DT , BPV.START_DATE , BPV.END_DATE , (%Sql(SSR_BR_BPV_GET_RDT_BPV_SQL,BPV.CANCEL_DATE,AP.PROG_STATUS,BPV.END_DATE,AP.EFFDT)) , (%Sql(SSR_BR_BPV_GET_EXT_SYS_ID_SQL, BPV.EXT_ORG_ID, ES.INSTITUTION, ES.SCC_BRINCD_NLD)) , CASE WHEN BPV.SAD_TOTHRS_BPV_NLD > 0 THEN BPV.SAD_TOTHRS_BPV_NLD ELSE (BPV.SAD_CONTR_LNGT_NLD * BPV.SAD_WEEK_HRS_NLD) END , %Substring(BPV.HEGIS_CODE,1,5) , ( SELECT D.SCC_HEGIS_TYPE_NLD FROM PS_SSR_HEGISCD_NLD D WHERE D.HEGIS_CODE = BPV.HEGIS_CODE AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_SSR_HEGISCD_NLD D1 WHERE D1.HEGIS_CODE = D.HEGIS_CODE AND D1.EFFDT <= %CurrentDateIn)) , ES.ACAD_CAREER , ES.STDNT_CAR_NBR FROM PS_SSR_BR_ENRVWNLD ES JOIN PS_SAD_BPV_STC_NLD BPV ON ES.EMPLID = BPV.EMPLID AND ES.ACAD_CAREER = BPV.ACAD_CAREER AND ES.STDNT_CAR_NBR = BPV.STDNT_CAR_NBR JOIN PS_ACAD_PROG AP ON AP.EMPLID = BPV.EMPLID AND BPV.SAD_BR_EX_BRON_NLD <> 'Y' AND BPV.SAD_PR_TSTSTAT_NLD = 'P' AND AP.ACAD_CAREER = BPV.ACAD_CAREER AND AP.STDNT_CAR_NBR = BPV.STDNT_CAR_NBR AND ( BPV.CANCEL_DATE IS NULL OR BPV.CANCEL_DATE <> BPV.START_DATE) AND AP.EFFDT = ( SELECT MAX(AP_ED.EFFDT) FROM PS_ACAD_PROG AP_ED WHERE 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_ED.EFFDT <= BPV.END_DATE) AND AP.EFFSEQ = ( SELECT MAX(AP_ES.EFFSEQ) FROM PS_ACAD_PROG AP_ES WHERE AP.EMPLID = AP_ES.EMPLID AND AP.ACAD_CAREER = AP_ES.ACAD_CAREER AND AP.STDNT_CAR_NBR = AP_ES.STDNT_CAR_NBR AND AP.EFFDT = AP_ES.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 SSR_BR_ENRL_SQ_NLD Character(20) VARCHAR2(20) NOT NULL 2020-04-15 bug 31180485 - enlarged enrollment seq nbr
5 SAD_BR_BPV_SEQ_NLD Number(2,0) SMALLINT NOT NULL BPV sequence number
6 SAD_BR_BPV_CRT_DT Date(10) DATE BPV End Date for BRON
7 SAD_BR_BDT_BPV_NLD Date(10) DATE BRON BPV begin date
8 SAD_BR_PDT_BPV_NLD Date(10) DATE Planned End Date BPV
9 SAD_BR_RDT_BPV_NLD Date(10) DATE Real end date BPV
10 SAD_BR_INTSHIP_NLD Character(40) VARCHAR2(40) NOT NULL BRON Internship Company
11 SAD_BR_HRS_BPV_NLD Number(4,0) SMALLINT NOT NULL BRON Hours BPV
12 SAD_BR_HEG_BPV_NLD Character(5) VARCHAR2(5) NOT NULL Field used to store CREBO code BPV students for BRON
13 SCC_HEGIS_TYPE_NLD Character(1) VARCHAR2(1) NOT NULL Hegis Code Type
C=Course
E=Elective
K=Elective
P=Program
T=Testimony
14 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
15 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr