SAD_BR_VASTD_VW

(SQL View)
 Index Back

BRON enrollment sequence view


SELECT ES.INSTITUTION , ES.SCC_BRINCD_NLD , 'VA' , ES.EMPLID , M305.SAD_SL_SOFI_NBR ,M305.SAD_BR_NAT_ID_NLD ,' ' FROM PS_SAD_BR_ENRSQ_VA ES ,PS_SAD_BR_M305_VA M305 ,PS_SAD_BR_M330_NLD M330 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 = M330.EMPLID AND ES.sad_br_enrl_sq_nld = M330.sad_br_enrl_sq_nld AND ES.INSTITUTION = M330.INSTITUTION AND ES.SCC_BRINCD_NLD = M330.SCC_BRINCD_NLD AND ES.SAD_BR_EDU_SEC_NLD = M330.SAD_BR_EDU_SEC_NLD UNION ALL SELECT ES.INSTITUTION , ES.SCC_BRINCD_NLD ,'VA' , ES.EMPLID , M305.SAD_SL_SOFI_NBR , M305.SAD_BR_NAT_ID_NLD ,' ' FROM PS_SAD_BR_ENRSQ_VA ES ,PS_SAD_BR_M305_VA M305 ,PS_SAD_BR_ISV_NLD ISV 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 = ISV.emplid AND es.scc_brincd_nld = ISV.scc_brincd_nld AND ES.sad_br_edu_sec_nld = ISV.sad_br_edu_sec_nld AND ES.sad_br_enrl_sq_nld = ISV.sad_br_enrl_sq_nld AND NOT EXISTS ( SELECT 'X' FROM PS_SAD_BR_M430_NLD M430 WHERE M430.INSTITUTION = ES.INSTITUTION AND M430.SCC_BRINCD_NLD = ES.SCC_BRINCD_NLD AND M430.SAD_BR_EDU_SEC_NLD = 'VA' AND M430.EMPLID = ES.EMPLID AND M430.sad_br_enrl_sq_nld = ES.sad_br_enrl_sq_nld ) AND NOT EXISTS ( SELECT 'X' FROM PS_SAD_BR_M330_NLD M330_1 WHERE M330_1.INSTITUTION = ES.INSTITUTION AND M330_1.SCC_BRINCD_NLD = ES.SCC_BRINCD_NLD AND M330_1.SAD_BR_EDU_SEC_NLD = 'VA' AND M330_1.EMPLID = ES.EMPLID AND M330_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