SSR_HE_DLHERTVW

(SQL View)

SELECT INSTITUTION , SSR_HE_RET_NAME , SSR_HE_PRD_CODE FROM PS_SSR_HE_INST_HER WHERE SSR_HE_ACTIVE='Y' AND SSR_HE_RET_TYPE IN ('DLHE','GRADOUT')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SSR_HE_RET_NAME Character(30) VARCHAR2(30) NOT NULL Return Name

3 SSR_HE_PRD_CODE Character(10) VARCHAR2(10) 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_HE_RET_NAME	Character(30)	VARCHAR2(30) NOT NULL	Return Name
3	SSR_HE_PRD_CODE	Character(10)	VARCHAR2(10) NOT NULL	Reporting Period