SSR_GR_CALTRMVW

(SQL View)
Index Back

Acad Cal View for Grad App

Acad Cal View for Grad App

SELECT a.INSTITUTION , a.ACAD_CAREER , a.ACAD_CALENDAR_ID , a.STRM , a.GRAD_APPLY_ST_DT , a.GRAD_APPLY_END_DT , a.SSR_GR_EDIT_END_DT FROM PS_ACAD_CALTRM_TBL a WHERE a.GRAD_APPLY_ST_DT IS NOT NULL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
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 ACAD_CALENDAR_ID Character(4) VARCHAR2(4) NOT NULL Academic Calendar
4 STRM Character(4) VARCHAR2(4) NOT NULL Term
5 GRAD_APPLY_ST_DT Date(10) DATE Apply For Graduation Start Dt
6 GRAD_APPLY_END_DT Date(10) DATE Apply for Graduation End Dt
7 SSR_GR_EDIT_END_DT Date(10) DATE Graduation Application Ending Date