This view is created to use in the sql text for SSR_HE_QUAL_TYPE field in Entry Profile page when the qual type has a mapping in the Entry qualification mapping page.

SSR_HE_QULGRDVW

(SQL View)

Index Back

SELECT institution ,ssr_he_qual_type ,ssr_he_qual_grade FROM %Table(ssr_he_qoe_map) WHERE ssr_he_active = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

2 SSR_HE_QUAL_TYPE Character(5) VARCHAR2(5) NOT NULL Qualification Type
Prompt Table: SSR_HE_QTDESCVW

3 SSR_HE_CODE Character(30) VARCHAR2(30) NOT NULL Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
2	SSR_HE_QUAL_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Qualification Type Prompt Table: SSR_HE_QTDESCVW
3	SSR_HE_CODE	Character(30)	VARCHAR2(30) NOT NULL	Code