Data Warehouse

AAP_PLAN_BEGIN_DATE

Start date of the AAP plan period.

DATE

AAP_PLAN_END_DATE

End date of the AAP plan period.

DATE

AAP_PLAN_TYPE

AAP plan type name/description.

VARCHAR2

50

AAP_PLAN_TYPE_DESCR

Short description for the AAP plan type.

VARCHAR2

8

AAP_PLAN_YEAR

AAP plan year associated with the metrics.

NUMBER

AAP_UNIT

Full name/description of the AAP organizational unit.

VARCHAR2

200

AAP_UNIT_ID

Identifier for the AAP organizational unit.

VARCHAR2

5

AAP_UNIT_SHORT_NAME

Short name for the AAP organizational unit.

VARCHAR2

15

AI_BEGIN_DATE

Start date for the applicable analysis interval (AI) used for activity measures (e.g., hires, promotions, terms).

DATE

AI_END_DATE

End date for the applicable analysis interval (AI) used for activity measures (e.g., hires, promotions, terms).

DATE

AMI_AVAIL

AMI availability measure for the unit/job group/plan period (category as defined by source).

NUMBER

12,7

AMI_HIRES

AMI hires measure for the analysis interval (category as defined by source).

NUMBER

12,7

AMI_HIRES_AI

AMI hires analysis-interval indicator/flag (category as defined by source).

VARCHAR2

5

AMI_HIRES_PCT

AMI hires percentage for the analysis interval (category as defined by source).

NUMBER

12,7

AMI_INCUMBENTS

AMI incumbents measure for the unit/job group/plan period (category as defined by source).

NUMBER

12,7

AMI_PLACE_GOAL

Indicator/flag for AMI placement goal applicability or status (category as defined by source).

VARCHAR2

5

AMI_PROMOTION_FROM

AMI promotions-from measure for the analysis interval (category as defined by source).

NUMBER

12,7

AMI_PROMOTION_FROM_AI

AMI promotions-from analysis-interval indicator/flag (category as defined by source).

VARCHAR2

5

AMI_PROMOTION_FROM_PCT

AMI promotions-from percentage for the analysis interval (category as defined by source).

NUMBER

12,7

AMI_RACE_AI_HIRE

Race AI indicator/flag related to hiring for AMI category (as defined by source).

CHAR

AMI_RACE_AI_PROMOTION

Race AI indicator/flag related to promotions for AMI category (as defined by source).

CHAR

AMI_RACE_AI_TERMS

Race AI indicator/flag related to terminations for AMI category (as defined by source).

CHAR

AMI_RET

AMI retention measure for the analysis interval or period (category as defined by source).

NUMBER

12,7

AMI_RET_PCT

AMI retention percentage for the analysis interval or period (category as defined by source).

NUMBER

12,7

AMI_TERMS

AMI terminations measure for the analysis interval (category as defined by source).

NUMBER

12,7

AMI_TERMS_AI

AMI terminations analysis-interval indicator/flag (category as defined by source).

VARCHAR2

5

AMI_TERMS_PCT

AMI terminations percentage for the analysis interval (category as defined by source).

NUMBER

12,7

AMI_TRANSFERS_OUT

AMI transfers-out measure for the analysis interval (category as defined by source).

NUMBER

12,7

AMI_TRANSFERS_OUT_AI

AMI transfers-out analysis-interval indicator/flag (category as defined by source).

VARCHAR2

5

AMI_TRANSFERS_OUT_PCT

AMI transfers-out percentage for the analysis interval (category as defined by source).

NUMBER

12,7

AMI_UTILIZATION

AMI utilization measure for the unit/job group/plan period (category as defined by source).

NUMBER

12,7

ASN_AVAIL

Asian availability measure for the unit/job group/plan period.

NUMBER

12,7

ASN_HIRES

Asian hires measure for the analysis interval.

NUMBER

12,7

ASN_HIRES_AI

Asian hires analysis-interval indicator/flag.

VARCHAR2

5

ASN_HIRES_PCT

Asian hires percentage for the analysis interval.

NUMBER

12,7

ASN_INCUMBENTS

Asian incumbents measure for the unit/job group/plan period.

NUMBER

12,7

ASN_PLACE_GOAL

Indicator/flag for Asian placement goal applicability or status.

VARCHAR2

5

ASN_PROMOTION_FROM

Asian promotions-from measure for the analysis interval.

NUMBER

12,7

ASN_PROMOTION_FROM_AI

Asian promotions-from analysis-interval indicator/flag.

VARCHAR2

5

ASN_PROMOTION_FROM_PCT

Asian promotions-from percentage for the analysis interval.

NUMBER

12,7

ASN_RACE_AI_HIRE

Race AI indicator/flag related to hiring for Asian category (as defined by source).

CHAR

ASN_RACE_AI_PROMOTION

Race AI indicator/flag related to promotions for Asian category (as defined by source).

CHAR

ASN_RACE_AI_TERMS

Race AI indicator/flag related to terminations for Asian category (as defined by source).

CHAR

ASN_RET

Asian retention measure for the analysis interval or period (as defined by source).

NUMBER

12,7

ASN_RET_PCT

Asian retention percentage for the analysis interval or period (as defined by source).

NUMBER

12,7

ASN_TERMS

Asian terminations measure for the analysis interval.

NUMBER

12,7

ASN_TERMS_AI

Asian terminations analysis-interval indicator/flag.

VARCHAR2

5

ASN_TERMS_PCT

Asian terminations percentage for the analysis interval.

NUMBER

12,7

ASN_TRANSFERS_OUT

Asian transfers-out measure for the analysis interval.

NUMBER

12,7

ASN_TRANSFERS_OUT_AI

Asian transfers-out analysis-interval indicator/flag.

VARCHAR2

5

ASN_TRANSFERS_OUT_PCT

Asian transfers-out percentage for the analysis interval.

NUMBER

12,7

ASN_UTILIZATION

Asian utilization measure for the unit/job group/plan period.

NUMBER

12,7

BLK_AVAIL

Black/African American availability measure for the unit/job group/plan period.

NUMBER

12,7

BLK_HIRES

Black/African American hires measure for the analysis interval.

NUMBER

12,7

BLK_HIRES_AI

Black/African American hires analysis-interval indicator/flag.

VARCHAR2

5

BLK_HIRES_PCT

Black/African American hires percentage for the analysis interval.

NUMBER

12,7

BLK_INCUMBENTS

Black/African American incumbents measure for the unit/job group/plan period.

NUMBER

12,7

BLK_PLACE_GOAL

Indicator/flag for Black/African American placement goal applicability or status.

VARCHAR2

5

BLK_PROMOTION_FROM

Black/African American promotions-from measure for the analysis interval.

NUMBER

12,7

BLK_PROMOTION_FROM_AI

Black/African American promotions-from analysis-interval indicator/flag.

VARCHAR2

5

BLK_PROMOTION_FROM_PCT

Black/African American promotions-from percentage for the analysis interval.

NUMBER

12,7

BLK_RACE_AI_HIRE

Race AI indicator/flag related to hiring for Black/African American category (as defined by source).

CHAR

BLK_RACE_AI_PROMOTION

Race AI indicator/flag related to promotions for Black/African American category (as defined by source).

CHAR

BLK_RACE_AI_TERMS

Race AI indicator/flag related to terminations for Black/African American category (as defined by source).

CHAR

BLK_RET

Black/African American retention measure for the analysis interval or period (as defined by source).

NUMBER

12,7

BLK_RET_PCT

Black/African American retention percentage for the analysis interval or period (as defined by source).

NUMBER

12,7

BLK_TERMS

Black/African American terminations measure for the analysis interval.

NUMBER

12,7

BLK_TERMS_AI

Black/African American terminations analysis-interval indicator/flag.

VARCHAR2

5

BLK_TERMS_PCT

Black/African American terminations percentage for the analysis interval.

NUMBER

12,7

BLK_TRANSFERS_OUT

Black/African American transfers-out measure for the analysis interval.

NUMBER

12,7

BLK_TRANSFERS_OUT_AI

Black/African American transfers-out analysis-interval indicator/flag.

VARCHAR2

5

BLK_TRANSFERS_OUT_PCT

Black/African American transfers-out percentage for the analysis interval.

NUMBER

12,7

BLK_UTILIZATION

Black/African American utilization measure for the unit/job group/plan period.

NUMBER

12,7

FEM_AVAILABILITY

Female availability measure for the unit/job group/plan period.

NUMBER

12,7

FEM_HIRES

Female hires measure for the analysis interval.

NUMBER

12,7

FEM_HIRES_AI

Female hires analysis-interval indicator/flag.

VARCHAR2

5

FEM_HIRES_PCT

Female hires percentage for the analysis interval.

NUMBER

12,7

FEM_INCUMBENTS

Female incumbents measure for the unit/job group/plan period.

NUMBER

12,7

FEM_PLACEMENT_GOAL

Indicator/flag for female placement goal applicability or status.

VARCHAR2

5

FEM_PROMOTION_FROM

Female promotions-from measure for the analysis interval.

NUMBER

12,7

FEM_PROMOTION_FROM_AI

Female promotions-from analysis-interval indicator/flag.

VARCHAR2

5

FEM_PROMOTION_FROM_PCT

Female promotions-from percentage for the analysis interval.

NUMBER

12,7

FEM_RET

Female retention measure for the analysis interval or period (as defined by source).

NUMBER

12,7

FEM_RET_PCT

Female retention percentage for the analysis interval or period (as defined by source).

NUMBER

12,7

FEM_TERMS

Female terminations measure for the analysis interval.

NUMBER

12,7

FEM_TERMS_AI

Female terminations analysis-interval indicator/flag.

VARCHAR2

5

FEM_TERMS_PCT

Female terminations percentage for the analysis interval.

NUMBER

12,7

FEM_TRANSFERS_OUT

Female transfers-out measure for the analysis interval.

NUMBER

12,7

FEM_TRANSFERS_OUT_AI

Female transfers-out analysis-interval indicator/flag.

VARCHAR2

5

FEM_TRANSFERS_OUT_PCT

Female transfers-out percentage for the analysis interval.

NUMBER

12,7

FEM_UTILIZATION

Female utilization measure for the unit/job group/plan period.

NUMBER

12,7

HIS_AVAIL

Hispanic/Latino availability measure for the unit/job group/plan period.

NUMBER

12,7

HIS_HIRES

Hispanic/Latino hires measure for the analysis interval.

NUMBER

12,7

HIS_HIRES_AI

Hispanic/Latino hires analysis-interval indicator/flag.

VARCHAR2

5

HIS_HIRES_PCT

Hispanic/Latino hires percentage for the analysis interval.

NUMBER

12,7

HIS_INCUMBENTS

Hispanic/Latino incumbents measure for the unit/job group/plan period.

NUMBER

12,7

HIS_PLACE_GOAL

Indicator/flag for Hispanic/Latino placement goal applicability or status.

VARCHAR2

5

HIS_PROMOTION_FROM

Hispanic/Latino promotions-from measure for the analysis interval.

NUMBER

12,7

HIS_PROMOTION_FROM_AI

Hispanic/Latino promotions-from analysis-interval indicator/flag.

VARCHAR2

5

HIS_PROMOTION_FROM_PCT

Hispanic/Latino promotions-from percentage for the analysis interval.

NUMBER

12,7

HIS_RACE_AI_HIRE

Race AI indicator/flag related to hiring for Hispanic/Latino category (as defined by source).

CHAR

HIS_RACE_AI_PROMOTION

Race AI indicator/flag related to promotions for Hispanic/Latino category (as defined by source).

CHAR

HIS_RACE_AI_TERMS

Race AI indicator/flag related to terminations for Hispanic/Latino category (as defined by source).

CHAR

HIS_RET

Hispanic/Latino retention measure for the analysis interval or period (as defined by source).

NUMBER

12,7

HIS_RET_PCT

Hispanic/Latino retention percentage for the analysis interval or period (as defined by source).

NUMBER

12,7

HIS_TERMS

Hispanic/Latino terminations measure for the analysis interval.

NUMBER

12,7

HIS_TERMS_AI

Hispanic/Latino terminations analysis-interval indicator/flag.

VARCHAR2

5

HIS_TERMS_PCT

Hispanic/Latino terminations percentage for the analysis interval.

NUMBER

12,7

HIS_TRANSFERS_OUT

Hispanic/Latino transfers-out measure for the analysis interval.

NUMBER

12,7

HIS_TRANSFERS_OUT_AI

Hispanic/Latino transfers-out analysis-interval indicator/flag.

VARCHAR2

5

HIS_TRANSFERS_OUT_PCT

Hispanic/Latino transfers-out percentage for the analysis interval.

NUMBER

12,7

HIS_UTILIZATION

Hispanic/Latino utilization measure for the unit/job group/plan period.

NUMBER

12,7

IWD_HIRES

IWD hires measure for the analysis interval.

NUMBER

12,7

IWD_INCUMBENTS

Count/measure of IWD incumbents for the unit/job group/plan period.

NUMBER

12,7

IWD_PLACEMENT

IWD placement measure for the analysis interval.

NUMBER

12,7

IWD_PLACE_MET_TARGET

Indicator showing whether the IWD placement met the target.

VARCHAR2

5

IWD_PROMOTION_TO

IWD promotions-to measure for the analysis interval.

NUMBER

12,7

IWD_TARGET

IWD target value for the unit/job group/plan period.

NUMBER

12,7

IWD_TARGET_MET_FLAG

Indicator showing whether the IWD target was met.

VARCHAR2

5

IWD_UTILIZATION

IWD utilization measure for the unit/job group/plan period.

NUMBER

12,7

JOB_GROUP

Name/description of the AAP job group.

VARCHAR2

200

JOB_GROUP_CODE

Code identifying the AAP job group.

VARCHAR2

5

MAL_AVAILABLILTIY

Male availability measure for the unit/job group/plan period.

NUMBER

12,7

MAL_HIRES

Male hires measure for the analysis interval.

NUMBER

12,7

MAL_HIRES_AI

Male hires analysis-interval indicator/flag.

VARCHAR2

5

MAL_HIRES_PCT

Male hires percentage for the analysis interval.

NUMBER

12,7

MAL_INCUMBENTS

Male incumbents measure for the unit/job group/plan period.

NUMBER

12,7

MAL_PROMOTION_FROM

Male promotions-from measure for the analysis interval.

NUMBER

12,7

MAL_PROMOTION_FROM_AI

Male promotions-from analysis-interval indicator/flag.

VARCHAR2

5

MAL_PROMOTION_FROM_PCT

Male promotions-from percentage for the analysis interval.

NUMBER

12,7

MAL_RET

Male retention measure for the analysis interval or period (as defined by source).

NUMBER

12,7

MAL_RET_PCT

Male retention percentage for the analysis interval or period (as defined by source).

NUMBER

12,7

MAL_TERMS

Male terminations measure for the analysis interval.

NUMBER

12,7

MAL_TERMS_AI

Male terminations analysis-interval indicator/flag.

VARCHAR2

5

MAL_TERMS_PCT

Male terminations percentage for the analysis interval.

NUMBER

12,7

MAL_TRANSFERS_OUT

Male transfers-out measure for the analysis interval.

NUMBER

12,7

MAL_TRANSFERS_OUT_AI

Male transfers-out analysis-interval indicator/flag.

VARCHAR2

5

MAL_TRANSFERS_OUT_PCT

Male transfers-out percentage for the analysis interval.

NUMBER

12,7

MAL_UTILIZATION

Male utilization measure for the unit/job group/plan period.

NUMBER

12,7

MIN_AVAILABILITY

Minority availability measure for the unit/job group/plan period.

NUMBER

12,7

MIN_INCUMBENTS

Minority incumbents measure for the unit/job group/plan period.

NUMBER

12,7

MIN_PLACEMENT_GOAL

Indicator/flag for minority placement goal applicability or status.

VARCHAR2

5

MIN_UTILIZATION

Minority utilization measure for the unit/job group/plan period.

NUMBER

12,7

PIH_AVAIL

PIH availability measure for the unit/job group/plan period (category as defined by source).

NUMBER

12,7

PIH_HIRES

PIH hires measure for the analysis interval (category as defined by source).

NUMBER

12,7

PIH_HIRES_AI

PIH hires analysis-interval indicator/flag (category as defined by source).

VARCHAR2

5

PIH_HIRES_PCT

PIH hires percentage for the analysis interval (category as defined by source).

NUMBER

12,7

PIH_INCUMBENTS

PIH incumbents measure for the unit/job group/plan period (category as defined by source).

NUMBER

12,7

PIH_PLACE_GOAL

Indicator/flag for PIH placement goal applicability or status (category as defined by source).

VARCHAR2

5

PIH_PROMOTION_FROM

PIH promotions-from measure for the analysis interval (category as defined by source).

NUMBER

12,7

PIH_PROMOTION_FROM_AI

PIH promotions-from analysis-interval indicator/flag (category as defined by source).

VARCHAR2

5

PIH_PROMOTION_FROM_PCT

PIH promotions-from percentage for the analysis interval (category as defined by source).

NUMBER

12,7

PIH_RACE_AI_HIRE

Race AI indicator/flag related to hiring for PIH category (as defined by source).

CHAR

PIH_RACE_AI_PROMOTION

Race AI indicator/flag related to promotions for PIH category (as defined by source).

CHAR

PIH_RACE_AI_TERMS

Race AI indicator/flag related to terminations for PIH category (as defined by source).

CHAR

PIH_RET

PIH retention measure for the analysis interval or period (category as defined by source).

NUMBER

12,7

PIH_RET_PCT

PIH retention percentage for the analysis interval or period (category as defined by source).

NUMBER

12,7

PIH_TERMS

PIH terminations measure for the analysis interval (category as defined by source).

NUMBER

12,7

PIH_TERMS_AI

PIH terminations analysis-interval indicator/flag (category as defined by source).

VARCHAR2

5

PIH_TERMS_PCT

PIH terminations percentage for the analysis interval (category as defined by source).

NUMBER

12,7

PIH_TRANSFERS_OUT

PIH transfers-out measure for the analysis interval (category as defined by source).

NUMBER

12,7

PIH_TRANSFERS_OUT_AI

PIH transfers-out analysis-interval indicator/flag (category as defined by source).

VARCHAR2

5

PIH_TRANSFERS_OUT_PCT

PIH transfers-out percentage for the analysis interval (category as defined by source).

NUMBER

12,7

PIH_UTILIZATION

PIH utilization measure for the unit/job group/plan period (category as defined by source).

NUMBER

12,7

RACE_AI_HIRE_TEXT

Narrative or explanatory text related to race-based AI/hiring indicators for the unit/job group/period.

VARCHAR2

32767

RACE_AI_PROMOTION_TEXT

Narrative or explanatory text related to race-based AI/promotion indicators for the unit/job group/period.

VARCHAR2

32767

RACE_AI_TERMS_TEXT

Narrative or explanatory text related to race-based AI/terminations indicators for the unit/job group/period.

VARCHAR2

32767

TWO_AVAIL

TWO availability measure for the unit/job group/plan period (category as defined by source).

NUMBER

12,7

TWO_HIRES

TWO hires measure for the analysis interval (category as defined by source).

NUMBER

12,7

TWO_HIRES_AI

TWO hires analysis-interval indicator/flag (category as defined by source).

VARCHAR2

5

TWO_HIRES_PCT

TWO hires percentage for the analysis interval (category as defined by source).

NUMBER

12,7

TWO_INCUMBENTS

TWO incumbents measure for the unit/job group/plan period (category as defined by source).

NUMBER

12,7

TWO_PLACE_GOAL

Indicator/flag for TWO placement goal applicability or status (category as defined by source).

VARCHAR2

5

TWO_PROMOTION_FROM

TWO promotions-from measure for the analysis interval (category as defined by source).

NUMBER

12,7

TWO_PROMOTION_FROM_AI

TWO promotions-from analysis-interval indicator/flag (category as defined by source).

VARCHAR2

5

TWO_PROMOTION_FROM_PCT

TWO promotions-from percentage for the analysis interval (category as defined by source).

NUMBER

12,7

TWO_RACE_AI_HIRE

Race AI indicator/flag related to hiring for TWO category (as defined by source).

CHAR

TWO_RACE_AI_PROMOTION

Race AI indicator/flag related to promotions for TWO category (as defined by source).

CHAR

TWO_RACE_AI_TERMS

Race AI indicator/flag related to terminations for TWO category (as defined by source).

CHAR

TWO_RET

TWO retention measure for the analysis interval or period (category as defined by source).

NUMBER

12,7

TWO_RET_PCT

TWO retention percentage for the analysis interval or period (category as defined by source).

NUMBER

12,7

TWO_TERMS

TWO terminations measure for the analysis interval (category as defined by source).

NUMBER

12,7

TWO_TERMS_AI

TWO terminations analysis-interval indicator/flag (category as defined by source).

VARCHAR2

5

TWO_TERMS_PCT

TWO terminations percentage for the analysis interval (category as defined by source).

NUMBER

12,7

TWO_TRANSFERS_OUT

TWO transfers-out measure for the analysis interval (category as defined by source).

NUMBER

12,7

TWO_TRANSFERS_OUT_AI

TWO transfers-out analysis-interval indicator/flag (category as defined by source).

VARCHAR2

5

TWO_TRANSFERS_OUT_PCT

TWO transfers-out percentage for the analysis interval (category as defined by source).

NUMBER

12,7

TWO_UTILIZATION

TWO utilization measure for the unit/job group/plan period (category as defined by source).

NUMBER

12,7

VET_HIRES

Veteran hires measure for the analysis interval.

NUMBER

12,7

VET_INCUMBENTS

Count/measure of veteran incumbents for the unit/job group/plan period.

NUMBER

12,7

VET_PLACEMENT

Veteran placement measure for the analysis interval.

NUMBER

12,7

VET_PLACE_MET_TARGET

Indicator showing whether the veteran placement met the target.

VARCHAR2

5

VET_PROMOTION_TO

Veteran promotions-to measure for the analysis interval.

NUMBER

12,7

VET_TARGET

Veteran target value for the unit/job group/plan period.

NUMBER

12,7

VET_TARGET_MET_FLAG

Indicator showing whether the veteran target was met.

VARCHAR2

5

VET_UTILIZATION

Veteran utilization measure for the unit/job group/plan period.

NUMBER

12,7

WAREHOUSE_CREATE_DATE

Timestamp/date the record was created in the warehouse.

DATE

WAREHOUSE_UPDATE_DATE

Timestamp/date the record was last updated in the warehouse.

DATE

WHT_AVAILABLILTIY

White availability measure for the unit/job group/plan period.

NUMBER

12,7

WHT_HIRES

White hires measure for the analysis interval.

NUMBER

12,7

WHT_HIRES_AI

White hires analysis-interval indicator/flag.

VARCHAR2

5

WHT_HIRES_PCT

White hires percentage for the analysis interval.

NUMBER

12,7

WHT_INCUMBENTS

White incumbents measure for the unit/job group/plan period.

NUMBER

12,7

WHT_PROMOTION_FROM

White promotions-from measure for the analysis interval.

NUMBER

12,7

WHT_PROMOTION_FROM_AI

White promotions-from analysis-interval indicator/flag.

VARCHAR2

5

WHT_PROMOTION_FROM_PCT

White promotions-from percentage for the analysis interval.

NUMBER

12,7

WHT_RACE_AI_HIRE

Race AI indicator/flag related to hiring for White category (as defined by source).

CHAR

WHT_RACE_AI_PROMOTION

Race AI indicator/flag related to promotions for White category (as defined by source).

CHAR

WHT_RACE_AI_TERMS

Race AI indicator/flag related to terminations for White category (as defined by source).

CHAR

WHT_RET

White retention measure for the analysis interval or period (as defined by source).

NUMBER

12,7

WHT_RET_PCT

White retention percentage for the analysis interval or period (as defined by source).

NUMBER

12,7

WHT_TERMS

White terminations measure for the analysis interval.

NUMBER

12,7

WHT_TERMS_AI

White terminations analysis-interval indicator/flag.

VARCHAR2

5

WHT_TERMS_PCT

White terminations percentage for the analysis interval.

NUMBER

12,7

WHT_TRANSFERS_OUT

White transfers-out measure for the analysis interval.

NUMBER

12,7

WHT_TRANSFERS_OUT_AI

White transfers-out analysis-interval indicator/flag.

VARCHAR2

5

WHT_TRANSFERS_OUT_PCT

White transfers-out percentage for the analysis interval.

NUMBER

12,7

WHT_UTILIZATION

White utilization measure for the unit/job group/plan period.

NUMBER

12,7