SAD_PB_CASNBRVW(SQL View) |
Index Back |
|---|
| SELECT A.emplid ,A.institution ,A.acad_career ,A.stdnt_car_nbr ,A.sad_pb_cas_number ,a.sad_pb_reC_number ,a.adm_appl_nbr FROM PS_SAD_PB_CAS A WHERE A.EFFDT=( SELECT MAX(B.EFFDT) FROM PS_SAD_PB_CAS B WHERE B.EMPLID=A.EMPLID AND B.INSTITUTION=A.INSTITUTION AND B.SAD_PB_REC_TYPE=A.SAD_PB_REC_TYPE AND B.ACAD_CAREER=A.ACAD_CAREER AND B.STDNT_CAR_NBR=A.STDNT_CAR_NBR AND B.SAD_PB_REC_NUMBER=A.SAD_PB_REC_NUMBER AND B.ADM_APPL_NBR=A.ADM_APPL_NBR AND B.APPL_PROG_NBR=A.APPL_PROG_NBR AND B.EFFDT<=%CurrentDateIn) AND A.effseq = ( SELECT MAX(C.effseq) FROM PS_SAD_PB_CAS C WHERE A.emplid = c.emplid AND a.institution = c.institution AND a.sad_pb_rec_type = c.sad_pb_rec_type AND a.acad_career = c.acad_career AND a.stdnt_car_nbr=c.stdnt_car_nbr AND a.sad_pb_rec_number=c.sad_pb_rec_number AND a.adm_appl_nbr = c.adm_appl_nbr AND a.appl_prog_nbr = c.appl_prog_nbr AND a.effdt = c.effdt) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | 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 |
| 4 | STDNT_CAR_NBR |
Number(3,0) | SMALLINT NOT NULL | Student Career Nbr |
| 5 | SAD_PB_CAS_NUMBER |
Character(14) | VARCHAR2(14) NOT NULL | CAS Number |
| 6 | SAD_PB_REC_NUMBER | Number(3,0) | SMALLINT NOT NULL | Record Number |
| 7 | ADM_APPL_NBR | Character(8) | VARCHAR2(8) NOT NULL | Application Nbr |