ENROLL_MGMT_AVW (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 that will make selections on 'All' Programs.

ENROLL_MGMT_AVW

(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 that will make selections on 'All' Programs.

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

# 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.

5 PROGRAM_SELECT Character(1) VARCHAR2(1) NOT NULL Program to Select
A=All
C=Current

#	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.
5	PROGRAM_SELECT	Character(1)	VARCHAR2(1) NOT NULL	Program to Select A=All C=Current