SSR_STDGR_ADD (SQL View)	Index Back
Advising Student Groups Search This view is the search view used for entering the component that contains the valid student groups to be available in academic advising.

SSR_STDGR_ADD

(SQL View)

Advising Student Groups Search

This view is the search view used for entering the component that contains the valid student groups to be available in academic advising.

SELECT INSTITUTION , RQRMNT_USEAGE FROM PS_SAA_STDGR_HDR WHERE RQRMNT_USEAGE = 'ENR'

Parent record: INSTITUTION_TBL

# 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 RQRMNT_USEAGE Character(4) VARCHAR2(4) NOT NULL This field is used to specify how the requirement will be used. The value 'SHR1' is reserved for use in a future release.
ADV=Academic Advisement
ENR=Requisite/Restriction
PLNR=Student Planner Report
SHR=Rq Course Share Restrictn
SHR1=Entity Course Share Restrictn
STD=Student Individualized Plan
Default Value: ENR

#	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	RQRMNT_USEAGE	Character(4)	VARCHAR2(4) NOT NULL	This field is used to specify how the requirement will be used. The value 'SHR1' is reserved for use in a future release. ADV=Academic Advisement ENR=Requisite/Restriction PLNR=Student Planner Report SHR=Rq Course Share Restrictn SHR1=Entity Course Share Restrictn STD=Student Individualized Plan Default Value: ENR