ETHNIC_GRP_HVW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_11
2	ETHNIC_GRP_CD	Character(8)	VARCHAR2(8) NOT NULL	Ethnic group code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	ETHNIC_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Ethnic Category 1=White 2=Black 3=Hispanic 4=Asian/Pacific Islander 5=American Indian/Alaskan Native 6=Not Applicable 7=Chinese 9=Indian A=Aboriginal/Torres Strait Islnd B=Aboriginal Origin C=Torres Strait Islander Origin E=Eurasian I=Irianese M=Malay O=Maori P=Pacific Islander
8	ETHNIC_GROUP	Character(1)	VARCHAR2(1) NOT NULL	Ethnic Group 1=White 2=Black/African American 3=Hispanic/Latino 4=Asian 5=American Indian/Alaska Native 6=Not Specified 7=Native Hawaiian/Oth Pac Island A=American Indian/Alaskan Native B=Asian or Pacific Islander C=Black, not of Hispanic origin D=Hispanic E=White, not of Hispanic origin F=Asian Indian G=Chinese H=Filipino J=Guamanian K=Hawaiian L=Japanese M=Korean N=Samoan P=Vietnamese Q=All Other Asian o Pacific Is Y=Not Hispanic in Puerto Rico