Horizontal Initiative Database Data Dictionary

General

The information provided in this table gives an overview of the initiative. This is also the only table that provides the association between the Horizontal Initiative Code (HI Code) and the name of the horizontal initiative. This four digit code will always appear in the first column of each table (column A) directly followed by the fiscal year (column B). The information that can be found in this table includes:

HI Code

Main identifier for the horizontal initiative throughout the dataset

Fiscal year

Identifies the fiscal year of the information included within the row

Name of Horizontal Initiative

Name of each horizontal initiative

Description of the Horizontal Initiative

Description of what the initiative is trying to achieve and how they will achieve it

Department Code

Identifier for federal departments

Lead Department

Department leading the management and reporting of the initiative

Original Start Date of the horizontal initiative

Date initiative initiated and began horizontal reporting

End Date of the horizontal initiative

Planned date the initiative will complete horizontal reporting

Total Federal Allocation (from start date to end date) for the initiative as a whole (dollars)

All funds allocated to the initiative, including any renewed funds

Governance Structures

Description of the governance structures supporting the initiative

Fiscal year of next planned evaluation

Planned date of next evaluation

Performance Information

Description of the performance of the horizontal initiative

Partners

All horizontal initiatives have a lead department and at least one partner department. This table lists the federal departments that partner in the initiative, as well as any non-governmental partner. The information that can be found in this table includes:

HI Code

Main identifier for the horizontal initiative throughout the dataset

Fiscal year

Identifies the fiscal year of the information included within the row

Type of Partner

Identified if the partner is a “Federal partner organization” or a “Non-federal and non-governmental partner”

Department Code

Identifier for federal departments

Organization Name

Name of federal partner organizations or non-federal and non-governmental partners

Programs

Horizontal initiatives combine departmental activities to achieve a shared outcome. The programs associated with the horizontal initiative can completely or partially contribute to the initiative. The information that can be found in this table includes:

HI Code

Main identifier for the horizontal initiative throughout the dataset

Fiscal year

Identifies the fiscal year of the information included within the row

Department Code

Identifier for federal departments

Organization Name

Name of federal partner organizations or non-federal and non-governmental partners associated with the horizontal activity included in the table row

Program activity code

Identifier for the contributing federal program

Program name

Name of the contributing federal program

Horizontal activity code

Identifier for the activity under the federal program contributing to the horizontal initiative

Contributing activities within the selected program

Identifies the specific activity that contributes to the shared outcome of the horizontal initiative

SOThemes

The Shared Outcome(s) (SO) are a cornerstone of the horizontal initiative, representing the long-term outcome the initiative is trying to achieve. Themes divide the initiative into a limited number of smaller and logical outcome areas, to help measure the progress toward the (SO). The information that can be found in this table includes:

HI Code

Main identifier for the horizontal initiative throughout the dataset

Fiscal year

Identifies the fiscal year of the information included within the row

Shared Outcome or Theme code

Identifier for the shared outcome or theme

Shared Outcome or Theme

Describes the shared outcome (there may be more than one per initiative); this column also includes the names of themes. Note not all horizontal initiatives have themes

Theme Outcome code

Identifier for the theme outcome

Theme Outcome

Describes the theme outcome (there may be more than one per theme)

Department Code

Identifier for federal departments

Organization Name

Name of federal partner organizations or non-federal and non-governmental partners associated with the horizontal activity included in the table row

Department level outcome code

Identifier for the department level outcome

Department level outcome

Describes the department level outcome

Expected Results Code

Identifier for the expected results

Expected Results

The expected results of the shared outcome, theme or department

Performance Indicator Code

Identifier for the performance indicator

Indicator

Indicator that will measure progress toward the expected results

Target Code

Identifier for the performance target

Target

Target the expected results are trying to achieve and the performance indicator is measuring

Date to achieve target

Date the initiative plans to achieve the target

Results Code

Identifier for the results

Actual Results

Actual results measured through the performance indicator

Data Source

Source of the actual results data

Data collection frequency

Frequency at which the actual results data is collected

Program$

This table includes actual spending financial information by horizontal initiative activity. Users can filter by horizontal initiative and fiscal year to roll up the annual spending of an individual initiative. The information that can be found in this table includes:

HI Code

Main identifier for the horizontal initiative throughout the dataset

Fiscal year

Identifies the fiscal year of the information included within the row

Department Code

Identifier for federal departments

Organization Name

Name of federal partner organizations or non-federal and non-governmental partners associated with the horizontal activity included in the table row

Program activity code

Identifier for the contributing federal program

Program name

Name of the contributing federal program

Horizontal activity code

Identifier for the activity under the federal program contributing to the horizontal initiative

Contributing activities within the selected program

Identifies the specific activity that contributes to the shared outcome of the horizontal initiative

Theme code

Identifier for the theme (if applicable)

Fiscal year only – Actual spending (dollars)

Actual spending for each horizontal initiative activity

Results

This table shows the performance measurement strategy at the activity level, and includes actual results information, where available.

HI Code

Main identifier for the horizontal initiative throughout the dataset

Fiscal year

Identifies the fiscal year of the information included within the row

Theme code

Identifier for the theme (if applicable)

Department Code

Identifier for federal departments

Organization Name

Name of federal partner organizations or non-federal and non-governmental partners associated with the horizontal activity included in the table row

Program activity code

Identifier for the contributing federal program

Program name

Name of the contributing federal program

Horizontal activity code

Identifier for the activity under the federal program contributing to the horizontal initiative

Contributing activities within the selected program

Identifies the specific activity that contributes to the shared outcome of the horizontal initiative

Expected Results Code

Identifier for the expected results

Expected Results

The expected results of the horizontal activity

Performance Indicator Code

Identifier for the performance indicator

Performance Indicator

Indicator that will measure progress toward the expected results

Data Source Code

Identifier for the data source

Data Source

Source of the actual results data

Data collection frequency

Frequency at which the actual results data is collected

Target Code

Identifier for the performance target

Target

Target the expected results are trying to achieve and the performance indicator is measuring

Date to achieve target

Date the initiative plans to achieve the target

Actual Results Code

Identifier for the results

Actual Results

Actual results measured through the performance indicator

Annex A: Dataset Coding Chart

The coding in this dataset allows for dynamic analysis of results over time. All codes are unique to their corresponding horizontal initiative, meaning specific information can be isolated to analyze movement over time. For example, by filtering for a horizontal activity expected results code in the “Results” table, users will be provided with the performance indicator, target, data source and actual results information across fiscal years for this single expected result.

NOTE: if any component missing (for example, theme, theme outcome) this code is dropped from the code chain. For example, if there is no theme outcome, chain would be HICode-ThemeCode-ExpectedResultsCode instead of HICode-ThemeCode-ThemeOutcomeCode-ExpectedResultsCode