TARGET_COH_VW(SQL View) |
Index Back |
---|---|
Target Cohort ViewThis view contains all the Target Cohort that are in the Enrollment Target Setup. |
SELECT DISTINCT A.TARGET_COHORT , B.DESCR FROM PS_ENROLL_MGMT_TGT A , PS_TARGET_COH_TBL B WHERE A.TARGET_COHORT = B.TARGET_COHORT |
# | 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. |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |