ENROLL_MGMT_VW (SQL View)	Index Back
Enrollment Target View This is a view of the Enrollment Target Details. It is used as a prompt for the Group. Groups are consisted of one / more details.

ENROLL_MGMT_VW

(SQL View)

Enrollment Target View

This is a view of the Enrollment Target Details. It is used as a prompt for the Group. Groups are consisted of one / more details.

SELECT ENROLL_TGT_SEQ, TARGET_COHORT, TARGET_POPULATION, TARGET_DIVISION FROM PS_ENROLL_MGMT_TGT WHERE GROUP_DETAIL = 'D'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ENROLL_DTL_SEQ Character(6) VARCHAR2(6) NOT NULL Enrollment Detail Sequence

2 TARGET_COHORT Character(6) VARCHAR2(6) NOT NULL Target Cohort - First level identification for Enrollment Target.

3 TARGET_POPULATION Character(6) VARCHAR2(6) NOT NULL Target Population - Second level identification for Enrollment Target.

4 TARGET_DIVISION Character(6) VARCHAR2(6) NOT NULL Target Division - Third level identification for Enrollment Target.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ENROLL_DTL_SEQ	Character(6)	VARCHAR2(6) NOT NULL	Enrollment Detail Sequence
2	TARGET_COHORT	Character(6)	VARCHAR2(6) NOT NULL	Target Cohort - First level identification for Enrollment Target.
3	TARGET_POPULATION	Character(6)	VARCHAR2(6) NOT NULL	Target Population - Second level identification for Enrollment Target.
4	TARGET_DIVISION	Character(6)	VARCHAR2(6) NOT NULL	Target Division - Third level identification for Enrollment Target.