SAD_TST_ETHNIC_GRPSAD_TST_HISP_VW(SQL View) |
Index Back |
|---|---|
Enroll Target Detail - EthnicThis is a view of the Enrollment Target Detail - Ethnic table. |
| SELECT A.ETHNIC_GRP_CD ,A.DESCR50 FROM PS_ETHNIC_GRP_TBL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_ETHNIC_GRP_TBL A1 WHERE A1.SETID = A.SETID AND A1.ETHNIC_GRP_CD = A.ETHNIC_GRP_CD AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND A.ETHNIC_GROUP = '3' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAD_TST_ETHNIC_GRP |
Character(8) | VARCHAR2(8) NOT NULL | Ethnic group code |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |