Column Definitions

Available in: All plans
Last updated: 26-Feb-2026

Overview

The Kazinex activities grid supports 265 columns across 13 categories. This reference documents every column — its name, data type, and description. Use this when configuring the Column Chooser or interpreting data in the grid.

Data Types

Type	Description	Format Example
string	Text value	A1010, Pour Foundation
number	Numeric value	42, 1.5
date	Calendar date	15-Mar-2026
duration	Time span (hours or days)	80h, 10d
boolean	True/false toggle	✅ / —
percent	Percentage value	85.5%
cost	Currency amount	$125,000.00

Dynamic Columns

Three categories are populated dynamically from your uploaded file:

• Activity Codes — Created from the activity code types defined in P6 (e.g., Area, Phase, Responsibility)
• User Defined Fields (UDFs) — Created from UDF definitions in the XER file
• Predecessors/Successors — Relationship details generated from logic data

These columns appear automatically in the Column Chooser after import.

---

1. General (20 columns)

Core activity identification and configuration fields.

Column Name	ID	Data Type	Description
Activity ID	task_code	string	User-visible activity code identifier
Activity Name	activity_name	string	Activity name or description
Activity Type	activity_type	string	Task type: Task Dependent, Milestone, LOE, etc.
Status	status	string	Not Started, In Progress, or Completed
Duration Type	duration_type	string	Fixed Duration, Fixed Units, Fixed Units/Time, etc.
WBS	wbs_id	number	Work Breakdown Structure identifier
Project ID	project_id	number	Project identifier
Calendar	calendar_id	number	Calendar assigned to the activity
GUID	guid	string	Globally unique identifier
Location	location_id	number	Location reference
Created	create_date	date	Date the activity was created
Modified	update_date	date	Date of last modification
Created By	create_user	string	User who created the activity
Modified By	update_user	string	User who last modified the activity
Priority	priority	string	Top, High, Normal, or Low
Review Required	review_flag	boolean	Whether the activity requires review
Locked	locked	boolean	Whether the activity is locked for editing
Auto Compute Actuals	auto_compute	boolean	Automatically compute actual values
Estimate Weight	est_weight	number	Weight used in estimating
Percent Complete Type	complete_pct_type	string	How % complete is calculated: Physical, Duration, or Units

---

2. Dates (33 columns)

All date-related fields including planned, actual, early/late (CPM), baseline, and constraint dates.

Column Name	ID	Data Type	Description
Scheduled Dates	scheduled_date_range	string	Early Start → Early Finish range
Actual Dates	actual_date_range	string	Actual Start → Actual Finish range
Remaining Dates	remaining_date_range	string	Remaining Early Start → Remaining Early Finish range
Baseline Dates	baseline_date_range	string	BL Start → BL Finish range
Start	start	date	Current start: Actual Start if started, else Early Start
Finish	finish	date	Current finish: Actual Finish if complete, else Early Finish
Planned Start	planned_start	date	Planned start date
Planned Finish	planned_finish	date	Planned finish date
Early Start	early_start	date	CPM early start (forward pass)
Early Finish	early_finish	date	CPM early finish (forward pass)
Late Start	late_start	date	CPM late start (backward pass)
Late Finish	late_finish	date	CPM late finish (backward pass)
Actual Start	actual_start	date	When work actually started
Actual Finish	actual_finish	date	When work actually finished
Expected Finish	expected_finish	date	Forecasted completion date
Restart Date	restart_date	date	Date to resume suspended work
Re-Finish Date	reend_date	date	Adjusted finish for suspended work
Remaining Late Start	rem_late_start	date	Late start for remaining work
Remaining Late Finish	rem_late_finish	date	Late finish for remaining work
Constraint Type	constraint_type	string	Primary constraint (ASAP, ALAP, MSO, MFO, etc.)
Constraint Date	constraint_date	date	Primary constraint date
Constraint Type 2	constraint_type2	string	Secondary constraint type
Constraint Date 2	constraint_date2	date	Secondary constraint date
Suspend Date	suspend_date	date	Date work was suspended
Resume Date	resume_date	date	Date work resumed after suspension
External Early Start	external_early_start	date	Imposed early start (external constraint)
External Late Finish	external_late_finish	date	Imposed late finish (external constraint)
Primary Constraint Date	primary_constraint_date	date	Primary constraint date
Secondary Constraint Date	secondary_constraint_date	date	Secondary constraint date
Anticipated Start	anticipated_start	date	Anticipated start date
Anticipated Finish	anticipated_finish	date	Anticipated finish date
BL Start	bl_start	date	Baseline start: BL Actual Start if started, else BL Early Start
BL Finish	bl_finish	date	Baseline finish: BL Actual Finish if complete, else BL Early Finish

---

3. Durations (26 columns)

Duration values, float calculations, and schedule variance metrics.

Column Name	ID	Data Type	Description
Original Duration	original_duration	duration	Baseline duration in hours
Remaining Duration	remaining_duration	duration	Duration left to complete
Actual Duration	actual_duration	duration	Actual duration worked
At Completion Duration	at_completion_duration	duration	Actual + Remaining duration
BL Duration	bl_project_duration	duration	Project baseline duration
Variance - BL Duration	variance_bl_project_duration	duration	At Completion - Baseline duration (negative = overrun)
Variance - BL Start	variance_start	number	Days difference from baseline start (positive = delayed)
Variance - BL Finish	variance_finish	number	Days difference from baseline finish (positive = delayed)
Total Float	total_float	duration	Total float in hours
Free Float	free_float	duration	Free float (without affecting successors)
Remaining Float	remaining_float	duration	Remaining float (Late Finish - Remaining Early Finish)
Driving	driving_path	boolean	On driving (critical) path
Working Days	working_days	duration	Working days between start and finish (calendar-aware)
Calendar Days	calendar_days	duration	Calendar days between start and finish
Ahead/Behind Schedule	ahead_behind_schedule	number	Days ahead (positive) or behind (negative)
Baseline Variance (Days)	baseline_variance_days	number	Days variance from baseline dates
Actual Working Days	actual_working_days	duration	Actual working days elapsed
Remaining Working Days	remaining_working_days	duration	Remaining working days to finish
Days to Go	days_to_go	number	Calendar days until planned finish
Is Critical	is_critical	boolean	Total float ≤ 0
Is Near Critical	is_near_critical	boolean	Float between 0 and 10 days
Float Trend	float_trend	string	Increasing, Stable, or Decreasing
Criticality Index	criticality_index	number	0–100 criticality score
Driving Path (Enriched)	drivingPath	string	Path label if on driving path
Longest Path	longest_path	boolean	Is on the longest path
Secondary Float	secondary_float	duration	Float if driving predecessor removed

---

4. Percent Complete (43 columns)

All percentage-based progress metrics including physical, duration, cost, and baseline comparisons.

Column Name	ID	Data Type	Description
Physical % Complete	physical_pct_complete	percent	Manually entered physical progress
Duration % Complete	duration_pct_complete	percent	Based on total units (labor + nonlabor)
Labor Units % Complete	labor_units_pct_complete	percent	Actual work / target work
Nonlabor Units % Complete	nonlabor_units_pct_complete	percent	Actual nonlabor / at completion nonlabor
Cost % Complete	cost_pct_complete	percent	Actual cost / at completion cost
Expense Cost % Complete	expense_cost_pct_complete	percent	Actual expense / at completion expense
Labor Cost % Complete	labor_cost_pct_complete	percent	Actual labor cost / at completion labor cost
Material Cost % Complete	material_cost_pct_complete	percent	Actual material cost / at completion material cost
Nonlabor Cost % Complete	nonlabor_cost_pct_complete	percent	Actual nonlabor cost / at completion nonlabor cost
Units % Complete	units_pct_complete	percent	Actual units / at completion units
BL Activity % Complete	bl_project_activity_pct_complete	percent	Expected activity % per baseline at current date
BL Duration % Complete	bl_project_duration_pct_complete	percent	BL actual duration / BL total duration
BL Cost % Complete	bl_project_cost_pct_complete	percent	BL actual cost / BL total cost
BL Performance % Complete	bl_project_performance_pct_complete	percent	BL actual cost / BL target cost
BL Labor Cost % Complete	bl_project_labor_cost_pct_complete	percent	BL actual labor cost / BL labor cost
BL Nonlabor Cost % Complete	bl_project_nonlabor_cost_pct_complete	percent	BL actual nonlabor cost / BL nonlabor cost
BL Material Cost % Complete	bl_project_material_cost_pct_complete	percent	BL actual material cost / BL material cost
BL Expense Cost % Complete	bl_project_expense_cost_pct_complete	percent	BL actual expense cost / BL expense cost
BL Labor Units % Complete	bl_project_labor_units_pct_complete	percent	BL actual labor units / BL labor units
BL Nonlabor Units % Complete	bl_project_nonlabor_units_pct_complete	percent	BL actual nonlabor units / BL nonlabor units
BL Units % Complete	bl_project_units_pct_complete	percent	BL actual units / BL total units
BL Physical %	bl_project_physical_pct	percent	Baseline physical % complete
BL Schedule %	bl_project_schedule_pct	percent	Baseline schedule % complete
BL Cost % of Budget	bl_project_cost_pct_of_budget	percent	BL actual cost / BL budgeted cost
BL Duration % of Original	bl_project_duration_pct_of_original	percent	BL actual duration / BL original duration
BL % Complete Type	bl_project_percent_complete_type	string	Baseline calculation method
Variance - BL Activity %	variance_bl_project_activity_pct	percent	Current - baseline activity % (positive = ahead)
Variance - BL Duration %	variance_bl_project_duration_pct	percent	Current - baseline duration %
Variance - BL Cost %	variance_bl_project_cost_pct	percent	Current - baseline cost %
Variance - BL Performance %	variance_bl_project_performance_pct	percent	Current - baseline performance %
Variance - BL Labor Cost %	variance_bl_project_labor_cost_pct	percent	Current - baseline labor cost %
Variance - BL Nonlabor Cost %	variance_bl_project_nonlabor_cost_pct	percent	Current - baseline nonlabor cost %
Variance - BL Material Cost %	variance_bl_project_material_cost_pct	percent	Current - baseline material cost %
Variance - BL Expense Cost %	variance_bl_project_expense_cost_pct	percent	Current - baseline expense cost %
Variance - BL Labor Units %	variance_bl_project_labor_units_pct	percent	Current - baseline labor units %
Variance - BL Nonlabor Units %	variance_bl_project_nonlabor_units_pct	percent	Current - baseline nonlabor units %
Variance - BL Units %	variance_bl_project_units_pct	percent	Current - baseline units %
Variance - BL Physical %	variance_bl_project_physical_pct	percent	Current - baseline physical %
Variance - BL Schedule %	variance_bl_project_schedule_pct	percent	Current - baseline schedule %
Variance - BL Cost % of Budget	variance_bl_project_cost_pct_of_budget	percent	Current - baseline cost % of budget
Variance - BL Duration % of Original	variance_bl_project_duration_pct_of_original	percent	Current - baseline duration % of original
Performance % Complete	performance_pct_complete	percent	Actual cost / target cost
% Schedule Complete	percent_schedule_complete	percent	Percentage of schedule duration complete

---

5. Units (17 columns)

Labor and nonlabor resource unit quantities.

Column Name	ID	Data Type	Description
Primary Resource	primary_resource	number	Primary resource identifier
Budgeted Labor Units	planned_labor_units	number	Budgeted work hours
Remaining Labor Units	remaining_labor_units	number	Work remaining in hours
Actual Labor Units	actual_labor_units	number	Work completed in hours
Actual This Period Labor	actual_this_period_labor	number	Work this period in hours
Budgeted Nonlabor Units	planned_nonlabor_units	number	Budgeted equipment/nonlabor units
Remaining Nonlabor Units	remaining_nonlabor_units	number	Equipment remaining
Actual Nonlabor Units	actual_nonlabor_units	number	Equipment used
Actual This Period Nonlabor	actual_this_period_nonlabor	number	Equipment this period
BL Labor Units	bl_project_labor_units	number	Baseline labor units
BL Actual Labor Units	bl_project_actual_labor_units	number	Baseline actual labor units
BL Remaining Labor Units	bl_project_remaining_labor_units	number	Baseline remaining labor units
BL Nonlabor Units	bl_project_nonlabor_units	number	Baseline nonlabor units
BL Actual Nonlabor Units	bl_project_actual_nonlabor_units	number	Baseline actual nonlabor units
BL Remaining Nonlabor Units	bl_project_remaining_nonlabor_units	number	Baseline remaining nonlabor units
Variance - BL Labor Units	variance_bl_project_labor_units	number	At completion - baseline labor (negative = overrun)
Variance - BL Nonlabor Units	variance_bl_project_nonlabor_units	number	At completion - baseline nonlabor (negative = overrun)

---

6. Costs (42 columns)

All cost fields including budgeted, actual, remaining, at-completion, baseline, and variance values.

Column Name	ID	Data Type	Description
Budgeted Cost	planned_cost	cost	Total budgeted cost
Remaining Cost	remaining_cost	cost	Cost remaining to complete
Actual Cost	actual_cost	cost	Actual cost incurred
At Completion Cost	at_completion_cost	cost	Estimate at completion (EAC)
Cost Variance	cost_variance	cost	Actual - Planned cost
Cost % Complete	cost_percent_complete	percent	Actual / Planned cost
Planned Value (PV)	planned_value	cost	BCWS — Budgeted cost of work scheduled
Earned Value (EV)	earned_value	cost	BCWP — Budgeted cost of work performed
Cost Performance Index	cost_performance_index	number	EV / AC (below 1 = over budget)
Actual Labor Cost	actual_labor_cost	cost	Actual labor cost incurred
Actual Nonlabor Cost	actual_nonlabor_cost	cost	Actual nonlabor cost incurred
Actual Material Cost	actual_material_cost	cost	Actual material cost incurred
Actual Expense Cost	actual_expense_cost	cost	Actual expense cost incurred
Actual Total Cost	actual_total_cost	cost	Total actual cost (all categories)
Actual This Period Labor Cost	actual_this_period_labor_cost	cost	Labor cost in current period
Actual This Period Material Cost	actual_this_period_material_cost	cost	Material cost in current period
Actual This Period Nonlabor Cost	actual_this_period_nonlabor_cost	cost	Nonlabor cost in current period
At Completion Labor Cost	at_completion_labor_cost	cost	Projected total labor cost
At Completion Nonlabor Cost	at_completion_nonlabor_cost	cost	Projected total nonlabor cost
At Completion Material Cost	at_completion_material_cost	cost	Projected total material cost
At Completion Expense Cost	at_completion_expense_cost	cost	Projected total expense cost
At Completion Total Cost	at_completion_total_cost	cost	Projected total cost at completion
Budgeted Labor Cost	budgeted_labor_cost	cost	Planned labor cost
Budgeted Nonlabor Cost	budgeted_nonlabor_cost	cost	Planned nonlabor cost
Budgeted Material Cost	budgeted_material_cost	cost	Planned material cost
Budgeted Expense Cost	budgeted_expense_cost	cost	Planned expense cost
Budgeted Total Cost	budgeted_total_cost	cost	Total planned cost
Remaining Labor Cost	remaining_labor_cost	cost	Remaining labor cost
Remaining Nonlabor Cost	remaining_nonlabor_cost	cost	Remaining nonlabor cost
Remaining Material Cost	remaining_material_cost	cost	Remaining material cost
Remaining Expense Cost	remaining_expense_cost	cost	Remaining expense cost
Remaining Total Cost	remaining_total_cost	cost	Total remaining cost
BL Labor Cost	bl_project_labor_cost	cost	Baseline labor cost
BL Nonlabor Cost	bl_project_nonlabor_cost	cost	Baseline nonlabor cost
BL Material Cost	bl_project_material_cost	cost	Baseline material cost
BL Expense Cost	bl_project_expense_cost	cost	Baseline expense cost
BL Total Cost	bl_project_total_cost	cost	Total baseline cost
Variance - BL Labor Cost	variance_bl_project_labor_cost	cost	At completion - baseline labor cost
Variance - BL Nonlabor Cost	variance_bl_project_nonlabor_cost	cost	At completion - baseline nonlabor cost
Variance - BL Material Cost	variance_bl_project_material_cost	cost	At completion - baseline material cost
Variance - BL Expense Cost	variance_bl_project_expense_cost	cost	At completion - baseline expense cost
Variance - BL Total Cost	variance_bl_project_total_cost	cost	At completion - baseline total cost

---

7. Lists (8 columns)

Relationship and resource lookup fields.

Column Name	ID	Data Type	Description
Predecessors	predecessors	string	Comma-separated predecessor activity IDs
Successors	successors	string	Comma-separated successor activity IDs
Predecessor Details	predecessor_details	string	Predecessors with relationship type and lag
Successor Details	successor_details	string	Successors with relationship type and lag
Resource IDs	resource_ids	string	Comma-separated resource identifiers
Resources	resources	string	Comma-separated resource names
Role IDs	role_ids	string	Comma-separated role identifiers
Roles	roles	string	Comma-separated role names

---

8. Earned Value (42 columns)

Earned value management (EVM) metrics including BCWS, BCWP, CPI, SPI, variances, and forecasts.

Column Name	ID	Data Type	Description
Budget At Completion	budget_at_completion	cost	Total baseline budget (BAC)
Planned Value Cost	planned_value_cost	cost	BCWS — Budgeted Cost of Work Scheduled
Earned Value Cost	earned_value_cost	cost	BCWP — Budgeted Cost of Work Performed
Actual Cost (EV)	actual_cost_ev	cost	ACWP — Actual Cost of Work Performed
BAC - Labor Units	budget_at_completion_labor_units	number	Total baseline labor units
PV Labor Units	planned_value_labor_units	number	Planned labor units to date
EV Labor Units	earned_value_labor_units	number	Earned labor units based on progress
CPI	cost_performance_index_ev	number	EV / AC (below 1 = over budget)
CPI - Labor Units	cost_performance_index_labor_units	number	EV labor / actual labor units
SPI	schedule_performance_index_ev	number	EV / PV (below 1 = behind schedule)
SPI - Labor Units	schedule_performance_index_labor_units	number	EV labor / PV labor units
CV	cost_variance_ev	cost	EV - AC (negative = over budget)
CV - Labor Units	cost_variance_labor_units	number	EV labor - actual labor units
CVI	cost_variance_index	number	CV / EV (% variance from budget)
CVI - Labor Units	cost_variance_index_labor_units	number	CV labor / EV labor
SV	schedule_variance_ev	cost	EV - PV (negative = behind schedule)
SV - Labor Units	schedule_variance_labor_units	number	EV labor - PV labor units
SVI	schedule_variance_index	number	SV / PV (% variance from schedule)
SVI - Labor Units	schedule_variance_index_labor_units	number	SV labor / PV labor
EAC Cost	estimate_at_completion_cost	cost	Projected total cost
EAC - Labor Units	estimate_at_completion_labor_units	number	Projected total labor units
ETC	estimate_to_complete	cost	Expected remaining cost
ETC Labor Units	estimate_to_complete_labor_units	number	Expected remaining labor units
VAC	variance_at_completion	cost	BAC - EAC (projected variance)
VAC - Labor Units	variance_at_completion_labor_units	number	BAC labor - EAC labor
TCPI	to_complete_performance_index	number	(BAC - EV) / (BAC - AC) — required future CPI
Accounting Variance	accounting_variance	cost	Cost accounting variance
Accounting Variance - Labor Units	accounting_variance_labor_units	number	Labor accounting variance
Performance % Complete	performance_percent_complete	percent	% complete for EV calculation
Performance % Complete - Labor	performance_percent_complete_labor_units	percent	% complete based on labor units
Schedule Variance	schedule_variance	cost	EV - PV
Schedule Performance Index	schedule_performance_index	number	EV / PV
BCWS	bcws	cost	Budgeted Cost of Work Scheduled
BCWP	bcwp	cost	Budgeted Cost of Work Performed
SV (alias)	sv	cost	Schedule Variance (BCWP - BCWS)
CV (alias)	cv	cost	Cost Variance (BCWP - ACWP)
SPI (alias)	spi	number	Schedule Performance Index
CPI (alias)	cpi	number	Cost Performance Index
EAC (alias)	eac	cost	Estimate at Completion
ETC (alias)	etc	cost	Estimate to Complete
VAC (alias)	vac	cost	Variance at Completion
TCPI (alias)	tcpi	number	To Complete Performance Index

---

9. Enhanced Metrics (21 columns)

Calculated and derived metrics computed by Kazinex from raw data.

Column Name	ID	Data Type	Description
At Completion Labor Units	at_completion_labor_units	number	Projected total work hours
At Completion Nonlabor Units	at_completion_nonlabor_units	number	Projected total nonlabor units
Activity % Complete	activity_percent_complete	percent	Overall % based on configured type
Cost % of Budget	cost_pct_of_budget	percent	Actual / budgeted cost
Duration % of Original	duration_pct_of_original	percent	At completion / original duration
Schedule % Complete	schedule_pct_complete	percent	Time-based schedule completion
Hard Constraint	has_hard_constraint	boolean	Has constraining date restriction
Is Milestone	is_milestone	boolean	Activity is a milestone
Criticality	criticality_status	string	Critical, Near-Critical, or Normal
Critical Path	critical_path_indicator	string	Critical, Near-Critical, or Non-Critical
Has Constraints	has_constraints	boolean	Has hard constraints applied
Labor Hours	labor_hours	number	Total labor hours assigned
Equipment Hours	equipment_hours	number	Total equipment hours assigned
Material Cost	material_cost	cost	Total material cost
Total Resource Cost	total_resource_cost	cost	Sum of all resource costs
Resource Count	resourceCount	number	Number of resources assigned
Overallocated	overallocated	boolean	Any resource overallocated
Peak Loading %	peak_loading	percent	Peak resource loading percentage
Average Loading %	average_loading	percent	Average resource loading percentage
WBS Code	wbs_code	string	Work Breakdown Structure code
WBS Name	wbs_name	string	Work Breakdown Structure name

---

10. Number of Activities (11 columns)

Activity count fields used primarily in grouped/summary rows.

Column Name	ID	Data Type	Description
Activity Count	activity_count	number	Count of activities in group
Resource Assignment Count	activity_resource_assignment_count	number	Count of resource assignments
Actual Completed	actual_completed_activities	number	Activities with actual finish
Actual In-Progress	actual_in_progress_activities	number	Activities started but not finished
Actual Not-Started	actual_not_started_activities	number	Activities without actual start
BL Completed	bl_project_completed_activities	number	Should be completed per baseline
BL In-Progress	bl_project_in_progress_activities	number	Should be in-progress per baseline
BL Not-Started	bl_project_not_started_activities	number	Should not be started per baseline
Variance - Completed	variance_completed_activities	number	Actual - BL completed (positive = ahead)
Variance - In-Progress	variance_in_progress_activities	number	Actual - BL in-progress
Variance - Not-Started	variance_not_started_activities	number	Actual - BL not-started

---

11. Activity Codes (Dynamic)

Activity code columns are created dynamically based on the codes defined in your uploaded file. Common P6 activity code types include:

• Area — Geographic or site area
• Phase — Project phase (Design, Procurement, Construction, etc.)
• Responsibility — Team or person responsible
• Discipline — Engineering discipline (Civil, Mechanical, Electrical, etc.)

Each activity code type becomes a column in the grid showing the assigned code value per activity.

---

12. User Defined Fields (Dynamic)

UDF columns are created from the User Defined Field definitions in your file. UDFs can be of types: Text, Number, Integer, Date, Start Date, Finish Date, Cost, or Indicator.

---

13. Predecessors / Successors (Dynamic)

Relationship detail columns are generated from the logic data, showing predecessor and successor information with relationship types and lag values.

---

Summary

Category	# Columns	Data Types Used
General	20	string, number, date, boolean
Dates	33	date, string
Durations	26	duration, number, boolean, string
Percent Complete	43	percent, string
Units	17	number
Costs	42	cost, percent, number
Lists	8	string
Earned Value	42	cost, number, percent
Enhanced Metrics	21	number, percent, boolean, string, cost
Number of Activities	11	number
Activity Codes	Dynamic	string
User Defined Fields	Dynamic	varies
Predecessors/Successors	Dynamic	string
Total	265+

Related Documentation

• Column Chooser
• Activities Grid
• Grouping
• Filtering