R Runner File Specifications

Contents

General Information

This document outlines the standardized file formats for insights+ outcome products generated by parameterized R scripts (R Runner).
Currently, the tables produced by R Runner are for Explain, Forecast, and Predict stages.
Employment Gap table field names and types are discussed separately in this document as it does not follow the standard table format.

File Specifications

Generated files for each stage are stored in a separate subfolder within each outcome folder.
- e.g., college_going/explain
If a custom population ID is supplied, an additional separate folder will be created.
- e.g., college_going/explain/custom_population_id
For outcome_name, the name of the outcome being analyzed is used.
For cohort_name, the name of the base cohort being analyzed is used.

Stage	Table	File Name
Explain	Impact table	(outcome_name)_(cohort_name)_explain_ variable_impact.csv
Predict	Influence-impact table	(outcome_name)_(cohort_name)_predict_influence_impact.csv
Predict	Individual-level predicted probability table	(outcome_name)_(cohort_name)_predict_individual_probability.csv
Predict	Predicted/observed outcome table	(outcome_name)_(cohort_name)_predict_model_performance.csv
Forecast	Historical count/rate table	(outcome_name)_(cohort_name)_forecast_historical_data.csv
Forecast	Forecasted count/rate table	(outcome_name)_(cohort_name)_forecast_forecasted_data.csv

Field Specifications

IMPORTANT NOTE. The order of fields, as indicated by field number, must remain unchanged for each file. Any additions or reordering must be discussed and coordinated with the Dev team.
Explain – Impact table
- This table is used for the Top Impacts panel.

Field Number	Field Name	Field Type (Range)	Field Description
1	year	Character	This field includes cohort years.
2	variable	Character	This field includes the name of the variables included in the analysis
3	D	Numeric (0-1)	This field represents Impact measure in the panel.
4	cohort	Character	This field includes cohort names.
5	industry	Integer	For Industry Placement, industry field represents two-digit North American Industry Classification System (NAICS) codes. For other outcomes this field is left blank (NA).

Predict – Influence-impact table
- This table is used for the Things That Matter panel.

Field Number	Field Name	Field Type (Range)	Field Description
1	variable	Character	This field includes the name of the variables included in the analysis
2	importance	Numeric (0-100)	This field represents Impact measure in the panel.
3	control	Numeric (0-100)	This field represents Influence measure in the panel.
4	cohort	Character	This field includes cohort names.
5	industry	Character	For Industry Placement, this field represents two-digit North American Industry Classification System (NAICS) codes. For other outcomes this field is left blank (NA).

Predict – Individual-level predicted probability table
- This table is used for the Where Things Matter panel and Model Performance panel.

Field Number	Field Name	Field Type (Range)	Field Description
1	nswers_id	Character	This field includes student identifiers.
2	year	Character	This field includes cohort years.
3	(variable_name)	Character or Numeric	(variable_name) represents a bundle of variable fields included in the analysis. e.g., gender, race, in_state. IMPORTANT NOTE: The order of variables inserted into `dat_tbl` in the R Runner script must remain unchanged. Any additions or changes to the variable order must be discussed and coordinated with the Dev team.
4	prediction_prob	Numeric (0-100)	This field includes individual-level predicted probabilities (0-100) to build parallel box plots and histogram plots.
5	cohort	Character	This field includes cohort names.
6	industry	Character	For Industry Placement, this field represents two-digit North American Industry Classification System (NAICS) codes. For other outcomes this field is left blank (NA).

Predict – model performance table
- This table is used for the Model Performance panel.
- The data of the table is used to compute the model performance (accuracy, sensitivity, specificity) and build histogram plots.

Field Number	Field Name	Field Type (Range)	Field Description
1	prediction_prob	Numeric (0-100)	This field includes individual-level predicted probabilities (0-100) to build parallel box plots and histogram plots.
2	prediction	Integer (0,1)	This field includes individual-level predicted outcomes (True, False).
3	observed	Integer (0,1)	This field includes individual-level observed outcomes (True, False).
4	cohort	Character	This field includes cohort names.
5	industry	Character	For Industry Placement, this field represents two-digit North American Industry Classification System (NAICS) codes. For other outcomes this field is left blank (NA).

Forecast – Historical count/rate table
- This table is used for the What to Expect plot and Forecasted Count/Rate table.

Field Number	Field Name	Field Type (Range)	Field Description
1	year	Integer	This field includes cohort years.
2	count	Integer (0-Inf)	This field includes the total number of students who achieved the outcome in the given year.
3	percent	Numeric (0-100)	This field includes the percentage of students who achieved the outcome in the given year.
4	cohort	Character	This field includes cohort names.
5	industry	Character	For Industry Placement, industry field represents two-digit North American Industry Classification System (NAICS) codes. For other outcomes this field is left blank (NA).

Forecast – Forecasted count/rate table
- This table is used for the What to Expect plot and Forecasted Count/Rate table.

Field Number	Field Name	Field Type (Range)	Field Description
1	year	Integer	This field includes cohort years.
2	model	Character	This field includes the name of forecasting models used in the analysis
3	count_predicted	Integer (0-Inf)	This field includes the predicted total number of students who achieved the outcome in the given year.
4	count_lower	Integer (0-Inf)	This field includes the lower bound of prediction interval for the total number of students who achieved the outcome in the given year
5	count_upper	Integer (0-Inf)	This field includes the upper bound of prediction interval for the total number of students who achieved the outcome in the given year
6	percent_ predicted	Numeric (0-100)	This field includes the predicted percentage of students who achieved the outcome in the given year.
7	percent_lower	Numeric (0-100)	This field includes the lower bound of prediction interval for the percentage of students who achieved the outcome in the given year.
8	percent_upper	Numeric (0-100)	This field includes the upper bound of prediction interval for the percentage of students who achieved the outcome in the given year.
9	cohort	Character	This field includes cohort names.
10	industry	Character	For Industry Placement, industry field represents two-digit North American Industry Classification System (NAICS) codes. For other outcomes this field is left blank (NA).

Employment Gap Table Field Specifications

Forecast – Historical count/rate table
- This table is used for the What to Expect plot and Forecasted Count/Rate table.

Field Number	Field Name	Field Type (Range)	Field Description
1	year	Integer	This field includes cohort years.
2	count	Integer (0-Inf)	This field includes the total number of students who achieved the outcome in the given year.
3	demand	Integer (0-Inf)	This field includes the total job opening estimates for each occupation in the given year.
4	cohort	Character	This field includes cohort names.
5	industry	Character	For Industry Placement, industry field represents two-digit North American Industry Classification System (NAICS) codes. For other outcomes this field is left blank (NA).

Forecast – Forecasted count/rate table
- This table is used for the What to Expect plot and Forecasted Count/Rate table.

Field Number	Field Name	Field Type (Range)	Field Description
1	year	Integer	This field includes cohort years.
2	model	Character	This field includes the name of forecasting models used in the analysis
3	count_predicted	Integer (0-Inf)	This field includes the predicted total number of students who achieved the outcome in the given year.
4	count_lower	Integer (0-Inf)	This field includes the lower bound of prediction interval for the total number of students who achieved the outcome in the given year
5	count_upper	Integer (0-Inf)	This field includes the upper bound of prediction interval for the total number of students who achieved the outcome in the given year
6	demand	Numeric (0-100)	This field includes the total job opening estimates for each occupation in the latest available year from historical count/rate table.
7	cohort	Character	This field includes cohort names.
8	industry	Character	For Industry Placement, industry field represents two-digit North American Industry Classification System (NAICS) codes. For other outcomes this field is left blank (NA).

Updated on April 8, 2026

Leave a Reply Cancel reply