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