SETIDETHNIC_GRP_CDAV_MBR_ETHNC_VW(SQL View) |
Index Back |
|---|---|
Ethnicity Table ViewETHNICITY_TBL stores the Ethnicity codes. This view is used to prompt for Valid Values in the Membership Criteria Panel. |
| SELECT SETID , ETHNIC_GRP_CD , DESCR50 , DESCRSHORT FROM PS_HCR_ETHNC_GRP_I E WHERE EFF_STATUS = 'A' AND %EffdtCheck( HCR_ETHNC_GRP_I E1, E, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | ETHNIC_GRP_CD |
Character(8) | VARCHAR2(8) NOT NULL | Ethnic group code |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |