SSR_BR_STSTA_VW(SQL View) |
Index Back |
---|---|
Student Status Overview SearchStudent 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 | Character(30) | VARCHAR2(30) NOT NULL | Operator Class | |
2 | 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 |