R_PER016

(SQL Table)
Index Back

Table to hold PER16 totals.

Table to hold PER16 totals.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
2 CTL_ESTABID Character(12) VARCHAR2(12) NOT NULL Controlling Establishment ID
3 EEO_RPT_TYPE Character(30) VARCHAR2(30) NOT NULL EEO Report Type
4 FROMDATE Date(10) DATE From Date
5 THRUDATE Date(10) DATE End Date
6 REPORT_RUN_DATE Date(10) DATE Report Run Date
7 EEO1BK_TOT Number(7,0) INTEGER NOT NULL EEO1 Report B-K Total
8 EEO1A_TOT Number(7,0) INTEGER NOT NULL EEO1 Report A
9 EEO1B_TOT Number(7,0) INTEGER NOT NULL EEO1 Report B
10 EEO1C_TOT Number(7,0) INTEGER NOT NULL EEO1 Report C
11 EEO1D_TOT Number(7,0) INTEGER NOT NULL EEO1 Report D
12 EEO1E_TOT Number(7,0) INTEGER NOT NULL EEO1 Report E
13 EEO1F_TOT Number(7,0) INTEGER NOT NULL EEO1 Report F
14 EEO1G_TOT Number(7,0) INTEGER NOT NULL EEO1 Report G
15 EEO1H_TOT Number(7,0) INTEGER NOT NULL EEO1 Report H
16 EEO1I_TOT Number(7,0) INTEGER NOT NULL EEO1 Report I
17 EEO1J_TOT Number(7,0) INTEGER NOT NULL EEO1 Report J
18 EEO1K_TOT Number(7,0) INTEGER NOT NULL EEO1 Report K
19 EEO1L_TOT Number(7,0) INTEGER NOT NULL EEO1 Report L
20 EEO1M_TOT Number(7,0) INTEGER NOT NULL EEO1 Report M
21 EEO1N_TOT Number(7,0) INTEGER NOT NULL EEO1 Report N
22 EEO1O_TOT Number(7,0) INTEGER NOT NULL EEO1 Report O (A-N Total)