SAD_BR_STDST_VW

(SQL View)
 Index Back

BRON enrollment sequence view


SELECT ES.INSTITUTION , ES.SCC_BRINCD_NLD , 'BO' , ES.EMPLID , M305.SAD_SL_SOFI_NBR ,M305.SAD_BR_NAT_ID_NLD ,CNSR.STRM FROM PS_SAD_BR_ENRSQNLD ES ,PS_SAD_BR_M305_NLD M305 ,PS_SAD_BR_305C_NLD CNSR ,PS_SAD_BR_M320_NLD M320 WHERE ES.EMPLID = M305.EMPLID AND ES.INSTITUTION = M305.INSTITUTION AND ES.SCC_BRINCD_NLD = M305.SCC_BRINCD_NLD AND ES.SAD_BR_EDU_SEC_NLD = M305.SAD_BR_EDU_SEC_NLD AND ES.SCC_BRINCD_NLD = CNSR.SCC_BRINCD_NLD AND ES.SAD_BR_EDU_SEC_NLD = CNSR.SAD_BR_EDU_SEC_NLD AND ES.EMPLID = M320.EMPLID AND ES.sad_br_enrl_sq_nld = M320.sad_br_enrl_sq_nld AND ES.INSTITUTION = M320.INSTITUTION AND ES.SCC_BRINCD_NLD = M320.SCC_BRINCD_NLD AND ES.SAD_BR_EDU_SEC_NLD = M320.SAD_BR_EDU_SEC_NLD UNION ALL SELECT ES.INSTITUTION , ES.SCC_BRINCD_NLD ,'BO' , ES.EMPLID , M305.SAD_SL_SOFI_NBR , M305.SAD_BR_NAT_ID_NLD ,' ' FROM PS_SAD_BR_ENRSQNLD ES ,PS_SAD_BR_M305_NLD M305 ,PS_SAD_BR_ISG_NLD ISG WHERE ES.EMPLID = M305.EMPLID AND ES.INSTITUTION = M305.INSTITUTION AND ES.SCC_BRINCD_NLD = M305.SCC_BRINCD_NLD AND ES.SAD_BR_EDU_SEC_NLD = M305.SAD_BR_EDU_SEC_NLD AND ES.EMPLID = ISG.emplid AND es.scc_brincd_nld = ISG.scc_brincd_nld AND ES.sad_br_edu_sec_nld = ISG.sad_br_edu_sec_nld AND ES.sad_br_enrl_sq_nld = ISG.sad_br_enrl_sq_nld AND NOT EXISTS ( SELECT 'X' FROM PS_SAD_BR_M420_NLD M420 WHERE M420.INSTITUTION = ES.INSTITUTION AND M420.SCC_BRINCD_NLD = ES.SCC_BRINCD_NLD AND M420.SAD_BR_EDU_SEC_NLD = 'BO' AND M420.EMPLID = ES.EMPLID AND M420.sad_br_enrl_sq_nld = ES.sad_br_enrl_sq_nld ) AND NOT EXISTS ( SELECT 'X' FROM PS_SAD_BR_M320_NLD M320_1 WHERE M320_1.INSTITUTION = ES.INSTITUTION AND M320_1.SCC_BRINCD_NLD = ES.SCC_BRINCD_NLD AND M320_1.SAD_BR_EDU_SEC_NLD = 'BO' AND M320_1.EMPLID = ES.EMPLID AND M320_1.sad_br_enrl_sq_nld = ES.sad_br_enrl_sq_nld )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

2 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode

Prompt Table: SCC_BRINCD_NLD

3 SAD_BR_EDU_SEC_NLD Character(2) VARCHAR2(2) NOT NULL Educational Sector
BO=Professional Education
ED=Education
VA=VAVO
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 SAD_SL_SOFI_NBR Character(9) VARCHAR2(9) NOT NULL Social Fiscal Number
6 SAD_BR_NAT_ID_NLD Character(20) VARCHAR2(20) NOT NULL Educational Number
7 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: SAD_BR_TERM_VW