SSR_DEEWR_RP_VW (SQL View)	Index Back
DEEWR Reporting Period View This view is used as a prompt table for Reporting Period From and To fields on the AO Purge Page

SSR_DEEWR_RP_VW

(SQL View)

DEEWR Reporting Period View

This view is used as a prompt table for Reporting Period From and To fields on the AO Purge Page

SELECT DISTINCT A.INSTITUTION , A.SSR_DEEWR_RPT_PRD 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_DEEWR_RPT_PRD Number(2,0) SMALLINT NOT NULL Reporting Period

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	SSR_DEEWR_RPT_PRD	Number(2,0)	SMALLINT NOT NULL	Reporting Period