ACAD_YEAR_MC_VW (SQL View)	Index Back
Academic Year View This view lists all valid Academic Years from Term Table.

ACAD_YEAR_MC_VW

This view lists all valid Academic Years from Term Table.

SELECT DISTINCT ACAD_YEAR FROM PS_TERM_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year