SSR_BR_STSTA_VW

(SQL View)
Index Back

Student Status Overview Search

Student Status Overview Search View

SELECT A.OPRCLASS , %Substring(A1.SAD_SL_STUD_NBR ,1,11) , A1.SSR_BRHO_ENRSQ_NLD ,' ' , %Substring(A.NATIONAL_ID, 1, 9) , A.NAME , A.LAST_NAME_SRCH , A.FIRST_NAME_SRCH FROM PS_SSR_BR_ENSTA_VW A1 , PS_PEOPLE_SRCH A WHERE A.EMPLID = A1.SAD_SL_STUD_NBR UNION SELECT A.OPRCLASS , %Substring(B.SAD_SL_STUD_NBR ,1,11) ,' ' ,B.SSR_BRHO_RESEQ_NLD , %Substring(A.NATIONAL_ID, 1, 9) , A.NAME , A.LAST_NAME_SRCH , A.FIRST_NAME_SRCH FROM PS_SSR_BR_RESTA_VW B , PS_PEOPLE_SRCH A WHERE A.EMPLID = B.SAD_SL_STUD_NBR UNION SELECT A.OPRCLASS , %Substring(CE.SAD_SL_STUD_NBR ,1,11) ,CE.SSR_BRHO_ENRSQ_NLD ,' ' , %Substring(A.NATIONAL_ID, 1, 9) , A.NAME , A.LAST_NAME_SRCH , A.FIRST_NAME_SRCH FROM PS_SSR_BR_MENR_DEL CE , PS_PEOPLE_SRCH A WHERE A.EMPLID = CE.SAD_SL_STUD_NBR UNION SELECT A.OPRCLASS , %Substring(D.SAD_SL_STUD_NBR ,1,11) ,' ' ,D.SSR_BRHO_RESEQ_NLD , %Substring(A.NATIONAL_ID, 1, 9) , A.NAME , A.LAST_NAME_SRCH , A.FIRST_NAME_SRCH FROM PS_SSR_BR_MRST_DEL D , PS_PEOPLE_SRCH A WHERE A.EMPLID = D.SAD_SL_STUD_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

3 SSR_BRHO_ENRSQ_NLD Character(20) VARCHAR2(20) NOT NULL BRON Enrolment Seq Nbr

Prompt Table: SSR_BR_ENRSQ_VW

4 SSR_BRHO_RESEQ_NLD Character(20) VARCHAR2(20) NOT NULL BRON Result Seq Nbr

Prompt Table: SSR_BR_RSLSQ_VW

5 SAD_SL_SOFI_NBR Character(9) VARCHAR2(9) NOT NULL BSN/OWN

Prompt Table: SSR_BR_NAT_VW

6 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
8 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name