TARGET_COHORTPrompt Table: TARGET_COH_TBL
TARGET_POPULATIONPrompt Table: TARGET_POP_TBL
TARGET_POP1_VW(SQL View) |
Index Back |
|---|---|
Target Population View1This view contains Target population information. |
| SELECT A.TARGET_COHORT , A.TARGET_POPULATION , B.DESCR FROM PS_TARGET_COH_POP A , PS_TARGET_POP_TBL B WHERE A.TARGET_POPULATION = B.TARGET_POPULATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TARGET_COHORT |
Character(6) | VARCHAR2(6) NOT NULL |
Target Cohort - First level identification for Enrollment Target.
Prompt Table: TARGET_COH_TBL |
| 2 | TARGET_POPULATION |
Character(6) | VARCHAR2(6) NOT NULL |
Target Population - Second level identification for Enrollment Target.
Prompt Table: TARGET_POP_TBL |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |