SCC_AID_YR_VW (SQL View)	Index Back
Aid Year View This View fetches a list of the different Aid Years and their descriptions for each institution. It is primarily used HE Configuration.

SCC_AID_YR_VW

(SQL View)

Aid Year View

This View fetches a list of the different Aid Years and their descriptions for each institution. It is primarily used HE Configuration.

SELECT INSTITUTION ,AID_YEAR ,DESCR ,DESCRSHORT ,ACAD_YEAR_START ,ACAD_YEAR_END FROM PS_AID_YEAR_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table: FED_AID_YR_TBL

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: FED_AID_YR_TBL.DESCRSHORT

5 ACAD_YEAR_START Date(10) DATE Academic Year Start Date

6 ACAD_YEAR_END Date(10) DATE Academic Year End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
2	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: FED_AID_YR_TBL
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: FED_AID_YR_TBL.DESCRSHORT
5	ACAD_YEAR_START	Date(10)	DATE	Academic Year Start Date
6	ACAD_YEAR_END	Date(10)	DATE	Academic Year End Date