SSR_DEEWR_RF_VW (SQL View)	Index Back
DEEWR Reference Year View This view is used as a prompt table for Reference Year From and To fields on the AO Purge Page.

SSR_DEEWR_RF_VW

(SQL View)

DEEWR Reference Year View

This view is used as a prompt table for Reference Year From and To fields on the AO Purge Page.

SELECT DISTINCT A.INSTITUTION , A.SSR_REF_YEAR FROM PS_SSR_DEEWR_AOAPP A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

2 SSR_REF_YEAR Character(4) VARCHAR2(4) NOT NULL Australia DEST Processing

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	SSR_REF_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Australia DEST Processing