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) |