HR_EEO1_TMP_TBL (SQL Table)	Index Back
EEO totals This table will hold the job categories and the corresponding race/ethnic categories of the employees currently processed for the establishment.

HR_EEO1_TMP_TBL

(SQL Table)

EEO totals

This table will hold the job categories and the corresponding race/ethnic categories of the employees currently processed for the establishment.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HR_EEO1_STATUS_CD Character(1) VARCHAR2(1) NOT NULL Status Code

2 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
Prompt Table: ESTAB_TBL

3 HR_EEO1_EEO1CODE Character(2) VARCHAR2(2) NOT NULL EEO-1 Job Category

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

5 HR_PAY_BAND_ID Number(3,0) SMALLINT NOT NULL PayBand ID to be used for EEO1 Reporting

6 HR_EEO1_HQ_UNIT Character(1) VARCHAR2(1) NOT NULL Head Quaarter Unit

7 TOTAL_COUNT Number(7,0) INTEGER NOT NULL Total Count

8 HR_EEO1_HRS_TOT Signed Number(13,2) DECIMAL(11,2) NOT NULL Reportable Hours for EEO1 Reporting

9 WHERE_LONG Long Character CLOB Where Clause

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HR_EEO1_STATUS_CD	Character(1)	VARCHAR2(1) NOT NULL	Status Code
2	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID Prompt Table: ESTAB_TBL
3	HR_EEO1_EEO1CODE	Character(2)	VARCHAR2(2) NOT NULL	EEO-1 Job Category
4	ETHNIC_GRP_CD	Character(8)	VARCHAR2(8) NOT NULL	Ethnic group code
5	HR_PAY_BAND_ID	Number(3,0)	SMALLINT NOT NULL	PayBand ID to be used for EEO1 Reporting
6	HR_EEO1_HQ_UNIT	Character(1)	VARCHAR2(1) NOT NULL	Head Quaarter Unit
7	TOTAL_COUNT	Number(7,0)	INTEGER NOT NULL	Total Count
8	HR_EEO1_HRS_TOT	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Reportable Hours for EEO1 Reporting
9	WHERE_LONG	Long Character	CLOB	Where Clause