SAD_T189_ETH_VW

(SQL View)
Index Back

IPEDS Ethnicity Mapping

IPEDS Ethnicity Mapping View

SELECT REG_REGION , ETHNIC_GRP_CD , SAD_IPEDS_ETHNIC FROM PS_SAD_T189_ETHNIC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

Prompt Table: REG_REGION_TBL

2 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code

Prompt Table: ETHNIC_GRP_TBL
Set Control Field: REG_REGION

3 SAD_IPEDS_ETHNIC Character(1) VARCHAR2(1) NOT NULL IPEDS Ethnicity