HR_EEO1_PAYDATA

(SQL Table)
Index Back

Payroll Staging Table

Staging table to load PNA data .Data will be picked up from this table for EEO-1 Component 2 report

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year

Prompt Table: HR_EEO1_YEAR_VW

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: HR_EEO1_COMP_VW

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
5 DESCR100B Character(100) VARCHAR2(100) NOT NULL Description
6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
7 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
8 NAME Character(50) VARCHAR2(50) NOT NULL Name
9 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status
A=Administrative
C=Computer Employee
E=Executive
H=Highly Compensated Employees
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
V=Nonexempt Alt Overtime
X=No FLSA Required
10 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
11 HR_EEO1_HRS_YTD Signed Number(10,2) DECIMAL(8,2) NOT NULL Hours Worked for EEO1 Reporting
12 HR_EEO1_HRS_EXT Number(9,2) DECIMAL(8,2) NOT NULL External Hours Worked for EEO1 Reporting
13 HR_EEO1_HRS_RPT Signed Number(10,2) DECIMAL(8,2) NOT NULL Reportable Hours for EEO1 Reporting
14 HR_EEO1_HRS_ADJ Signed Number(10,2) DECIMAL(8,2) NOT NULL Hours Worked Adjustements for EEO1 Reporting
15 PAY_DATA Signed Number(15,3) DECIMAL(13,3) NOT NULL Pay Data for EEO1
16 HR_EEO1_PAY_EXT Number(14,3) DECIMAL(13,3) NOT NULL Pay Data for EEO1
17 HR_EEO1_PAY_ADJ Signed Number(15,3) DECIMAL(13,3) NOT NULL Pay Data for EEO1
18 HR_EEO1_RPT_PAY Signed Number(15,3) DECIMAL(13,3) NOT NULL Pay Data for EEO1
19 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
20 EEO1CODE Character(1) VARCHAR2(1) NOT NULL EEO-1 Job Category
1=Officials and Managers
2=Professionals
3=Technicians
4=Sales Workers
5=Administrative Support Workers
6=Craft Workers
7=Operatives
8=Laborers and Helpers
9=Service Workers
A=Executive/Sr Level Officials
B=First/Mid Level Officials
N=No EEO-1 Reporting
21 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
22 HQUNIT Character(1) VARCHAR2(1) NOT NULL Headquarters Unit
23 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
24 HR_EEO1_EXEMPT Character(1) VARCHAR2(1) NOT NULL Exempt Employees
J=Report Actual Hours
P=Report Proxy Hours
25 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
26 HR_EEO1_SINGLE_EST Character(1) VARCHAR2(1) NOT NULL Multiple Establishment
27 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
28 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.
29 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.