ENROLL_TGT_VW (SQL View)	Index Back
Enrollment Target View This table contains the Enrollment Targets Summary.

ENROLL_TGT_VW

(SQL View)

Enrollment Target View

This table contains the Enrollment Targets Summary.

SELECT A.ENROLL_TGT_SEQ, A.TARGET_COHORT, A.TARGET_POPULATION, A.TARGET_DIVISION, A.GROUP_DETAIL, A.TARGET_NBR, A.RESULT_NBR, A.REAL_NBR, A.TARGET_CALC_DTTM FROM PS_ENROLL_MGMT_TGT A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ENROLL_TGT_SEQ Character(6) VARCHAR2(6) NOT NULL Enrollment Target Sequence Number

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

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

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

5 GROUP_DETAIL Character(1) VARCHAR2(1) NOT NULL This field has the translate value of Group / Detail
D=Detail
G=Group

6 TARGET_NBR Number(6,0) INTEGER NOT NULL Target number for the criteria (s).

7 RESULT_NBR Number(6,0) INTEGER NOT NULL This is the result number after running the Enrollment Target process. Total number of students within certain criteria (s)

8 REAL_NBR Number(6,0) INTEGER NOT NULL Real Count

9 TARGET_CALC_DTTM DateTime(26) TIMESTAMP Result Calculated Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ENROLL_TGT_SEQ	Character(6)	VARCHAR2(6) NOT NULL	Enrollment Target Sequence Number
2	TARGET_COHORT	Character(6)	VARCHAR2(6) NOT NULL	Target Cohort - First level identification for Enrollment Target. Prompt Table: TARGET_COH_TBL
3	TARGET_POPULATION	Character(6)	VARCHAR2(6) NOT NULL	Target Population - Second level identification for Enrollment Target. Prompt Table: TARGET_POP_TBL
4	TARGET_DIVISION	Character(6)	VARCHAR2(6) NOT NULL	Target Division - Third level identification for Enrollment Target. Prompt Table: TARGET_DIV_TBL
5	GROUP_DETAIL	Character(1)	VARCHAR2(1) NOT NULL	This field has the translate value of Group / Detail D=Detail G=Group
6	TARGET_NBR	Number(6,0)	INTEGER NOT NULL	Target number for the criteria (s).
7	RESULT_NBR	Number(6,0)	INTEGER NOT NULL	This is the result number after running the Enrollment Target process. Total number of students within certain criteria (s)
8	REAL_NBR	Number(6,0)	INTEGER NOT NULL	Real Count
9	TARGET_CALC_DTTM	DateTime(26)	TIMESTAMP	Result Calculated Date Time