DIVERS_ETHNIC (SQL Table)	Index Back
Ethnic Diversity This table holds details of an employee's ethnic background. Created as a child of DIVERSIT record to allow recording of multiple Ethnic Group codes for each employee.

DIVERS_ETHNIC

(SQL Table)

Ethnic Diversity

This table holds details of an employee's ethnic background. Created as a child of DIVERSIT record to allow recording of multiple Ethnic Group codes for each employee.

# 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: OPR_DEF_TBL_HR.REG_REGION
Prompt Table: REG_REGION_TBL

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

4 SETID Character(5) VARCHAR2(5) NOT NULL SetID

5 APS_EC_NDS_AUS Character(1) VARCHAR2(1) NOT NULL Employees have the option of not wanting to provide their ethnicity information. This field is required for the purpose of APS reporting only.
Y/N Table Edit
Default Value: N

6 PRIMARY_INDICATOR Character(1) VARCHAR2(1) NOT NULL Primary Indicator
Y/N Table Edit
Default Value: N

#	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: OPR_DEF_TBL_HR.REG_REGION Prompt Table: REG_REGION_TBL
3	ETHNIC_GRP_CD	Character(8)	VARCHAR2(8) NOT NULL	Ethnic group code Prompt Table: ETHNIC_GRP_TBL
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	APS_EC_NDS_AUS	Character(1)	VARCHAR2(1) NOT NULL	Employees have the option of not wanting to provide their ethnicity information. This field is required for the purpose of APS reporting only. Y/N Table Edit Default Value: N
6	PRIMARY_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Primary Indicator Y/N Table Edit Default Value: N