ETHNICITY_DTL (SQL Table)	Index Back
Ethnicity Detail ETHNICITY_DTL stores the detail Ethnicity of the person.

ETHNICITY_DTL

(SQL Table)

Ethnicity Detail

ETHNICITY_DTL stores the detail Ethnicity of the person.

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
Default Value: HCR_OPRDEF_HR_I.REG_REGION
Prompt Table: HCR_REG_REGN_I

3 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code
Prompt Table: HCR_ETHNC_GRP_I

4 ETHNIC_PCT_NUMRATR Number(3,0) SMALLINT NOT NULL Percentage - Numerator

5 ETHNIC_PCT_DENMRTR Number(4,0) SMALLINT NOT NULL Percentage - Denominator

6 ETH_VALIDATED Character(1) VARCHAR2(1) NOT NULL Is Ethnicity verified?
Y/N Table Edit

7 HISP_LATINO Character(1) VARCHAR2(1) NOT NULL Hispanic or Latino
Y/N Table Edit
Default Value: N

8 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

9 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Default Value: HCR_OPRDEF_HR_I.REG_REGION Prompt Table: HCR_REG_REGN_I
3	ETHNIC_GRP_CD	Character(8)	VARCHAR2(8) NOT NULL	Ethnic group code Prompt Table: HCR_ETHNC_GRP_I
4	ETHNIC_PCT_NUMRATR	Number(3,0)	SMALLINT NOT NULL	Percentage - Numerator
5	ETHNIC_PCT_DENMRTR	Number(4,0)	SMALLINT NOT NULL	Percentage - Denominator
6	ETH_VALIDATED	Character(1)	VARCHAR2(1) NOT NULL	Is Ethnicity verified? Y/N Table Edit
7	HISP_LATINO	Character(1)	VARCHAR2(1) NOT NULL	Hispanic or Latino Y/N Table Edit Default Value: N
8	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
9	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.