SSR_BR_FNDCH_VW

(SQL View)
 Index Back

Funding status Work rec


SELECT DISTINCT A.EMPLID , A.ACAD_CAREER ,A.STDNT_CAR_NBR ,A.EFFDT ,A.EFFSEQ , B.SSR_BRHO_ENRSQ_NLD , B.SSR_BRHO_RESEQ_NLD ,B.SSR_BR_STA_FND_NLD ,B.SSR_BR_DEF_FND_NLD FROM PS_SSR_STD_PRG_NLD A ,PS_SSR_BR_FNDS_NLD B WHERE A.EMPLID = B.SAD_SL_STUD_NBR AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STDNT_CAR_NBR = B.STDNT_CAR_NBR AND ((A.SSR_BRHO_ENRSQ_NLD = B.SSR_BRHO_ENRSQ_NLD AND B.SSR_BRHO_ENRSQ_NLD <> ' ') OR (B.SSR_BRHO_RESEQ_NLD = A.SSR_BRHO_RESEQ_NLD AND B.SSR_BRHO_RESEQ_NLD <> ' ')) AND B.SAD_SL_TRANS_DTTM = ( SELECT MAX(B1.SAD_SL_TRANS_DTTM) FROM PS_SSR_BR_FNDS_NLD B1 WHERE B.SAD_SL_STUD_NBR = B1.SAD_SL_STUD_NBR AND ((B.SSR_BRHO_ENRSQ_NLD = B1.SSR_BRHO_ENRSQ_NLD AND B1.SSR_BRHO_ENRSQ_NLD <> ' ') OR (B.SSR_BRHO_RESEQ_NLD = B1.SSR_BRHO_RESEQ_NLD AND B1.SSR_BRHO_RESEQ_NLD <> ' ')) AND B1.SAD_SL_TRANS_DTTM <= %CurrentDateTimeIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 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
3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
6 SSR_BRHO_ENRSQ_NLD Character(20) VARCHAR2(20) NOT NULL BRON Enrolment Seq Nbr
7 SSR_BRHO_RESEQ_NLD Character(20) VARCHAR2(20) NOT NULL BRON Result Seq Nbr
8 SSR_BR_STA_FND_NLD Character(2) VARCHAR2(2) NOT NULL Status Funding
9 SSR_BR_DEF_FND_NLD Character(200) VARCHAR2(200) NOT NULL Definition of Funding Status