ESTABIDPrompt Table: ESTAB_TBL
START_DTPrompt Table: AAP_YEAR
EEO_JOB_GROUPPrompt Table: EEO_JOB_GRP_TBL
AAP_YEAR_JOBGRP(SQL Table) |
Index Back |
|---|---|
AAP Year Job Group |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTAB_TBL |
| 2 | START_DT |
Date(10) | DATE NOT NULL |
Start Date
Prompt Table: AAP_YEAR |
| 3 | EEO_JOB_GROUP |
Character(4) | VARCHAR2(4) NOT NULL |
EEO Job Group
Prompt Table: EEO_JOB_GRP_TBL |
| 4 | FEMALE_GOAL | Number(6,0) | INTEGER NOT NULL | Female Goal |
| 5 | MINORITY_GOAL | Number(6,0) | INTEGER NOT NULL | Minority Goal |