Definitions or Values Used

DE	Value	Label	Display UI Text
rollup_status	0	Active	Active
rollup_status	1	Inactive	Inactive

detail_level	0	Project / Shell	Project / Shell
detail_level	1	CBS	CBS
detail_level	2	Summary CBS	Summary CBS
detail_level	3	Commitment	Commitment

period_type	No	Standard Planning Period	Standard Planning Period
period_type	Yes	Financial Periods	Financial Periods

inc_spends_opt	0	next_month	The next month if after the cutoff date

inc_spends_opt	2	same_month	The same month as the effective date

distribution >type	0	manual	Manual

distribution >type	2	manual_autodistribution	manual auto distribute by default profile
distribution >type	3	schedule_sheet	Use data from Schedule Sheet
distribution >type	4	p6_sheet	Use data from P6 Source

Cost >Type	0	manual	Manually enter amounts for each period
Cost >Type	1	auto_distribution	Auto distribute total amount across all periods
Cost >Type	2	cost_sheet	Distribute amount from cost sheet column
Cost >Type	3	p6_sheet	Use Actuals from P6 Summary Sheet

Schedule >Type	0	manual	Manual
Schedule >Type	1	schedule_sheet	Use dates from Schedule Sheet
Schedule >Type	2	p6_sheet	Use dates from P6 Source
Schedule >Type	3

Filter >Type	0	all	All CBS codes from cost sheet
Filter >Type	1	summary_cbs	Select summary CBS codes
Filter >Type	2	cbs	Select CBS codes

Forecast > Option	TRUE	begin_end_of_curve	Begin calculations at end of curve
Forecast > Option	TRUE	current_actual_cut_off_date	Replace current period forecast with Actuals on cut Off date


Distribute unassigned amounts from Spends
Distribute unassigned amounts from Spends	0	weighted_avg_all_periods	Using weighted average over all remaining periods


Derived > Float Rate Option
Derived > Float Rate Option	0	beginning_period	At the beginning of the period
Derived > Float Rate Option	1	end_period	At the end of the period
Derived > Float Rate Option	2	weighted_period	A weighted average for the period

Detail level > Commitment Granularity	0	single_distribution	Single distribution of sum of base commit and all changes
Detail level > Commitment Granularity	1	individual_record	By individual record(base commit and all changes separately)
Detail level > Commitment Granularity	2	by_lineitem	By line items within each individual record

Distribution method	0	manual
Distribution method	1	Autodistribution_manual	Autodistribution - manual dates and profile
Distribution method	1	Autodistribution_bp {bp:"",from:"",to:"",profile:""}	Autodistribution - BP dates and default profile selection

Commit change Processes		BP : Status

See Also