ENROLL_TGT_SEQPrompt Table: TARGET_COH_TBL
Prompt Table: TARGET_POP1_VW
Prompt Table: TARGET_DIV1_VW
D=Detail
G=Group
Default Value: D
A=All
C=Current
Default Value: C
ENROLL_MGMT_TGT(SQL Table) |
Index Back |
|---|---|
Enrollment Target TableThis table contains the Enrollment Targets and the Process Informations. |
| # | 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_POP1_VW |
| 4 | TARGET_DIVISION | Character(6) | VARCHAR2(6) NOT NULL |
Target Division - Third level identification for Enrollment Target.
Prompt Table: TARGET_DIV1_VW |
| 5 | GROUP_DETAIL | Character(1) | VARCHAR2(1) NOT NULL |
This field has the translate value of Group / Detail
D=Detail G=Group Default Value: D |
| 6 | PROGRAM_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Program to Select
A=All C=Current Default Value: C |
| 7 | TARGET_NBR | Number(6,0) | INTEGER NOT NULL | Target number for the criteria (s). |
| 8 | 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) |
| 9 | ACTUAL_NBR | Number(6,0) | INTEGER NOT NULL | Actual Count |
| 10 | REAL_NBR | Number(6,0) | INTEGER NOT NULL | Real Count |
| 11 | TARGET_CALC_DTTM | DateTime(26) | TIMESTAMP | Result Calculated Date Time |
| 12 | COMMENTS | Long Character | CLOB | Comment |