Table: cost_pool_group_calc

Previous: cost_pool_group

Unanet Data Model

Next: cost_pool_source

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	cost_pool_group_calc_key	decimal(15)
2.		cost_pool_group_key	decimal(15)		cost_pool_group	fk_cost_pool_group_calc1
3.		post_fiscal_month_key	decimal(15)		fiscal_month	fk_cost_pool_group_calc5
4.		rev_fiscal_month_key	decimal(15)		fiscal_month	fk_cost_pool_group_calc6
5.		calculated_by	decimal(15)		person	fk_cost_pool_group_calc2
6.		calculated_timestamp	datetime
7.		posted_by	decimal(15)		person	fk_cost_pool_group_calc3
8.		posted_timestamp	datetime
9.		voided_by	decimal(15)		person	fk_cost_pool_group_calc4
10.		voided_timestamp	datetime
11.		budget_key	decimal(15)		budget	fk_cost_pool_group_calc7

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
budget_key	budget	budget_key	fk_cost_pool_group_calc7
cost_pool_group_key	cost_pool_group	cost_pool_group_key	fk_cost_pool_group_calc1
post_fiscal_month_key	fiscal_month	fiscal_month_key	fk_cost_pool_group_calc5
rev_fiscal_month_key	fiscal_month	fiscal_month_key	fk_cost_pool_group_calc6
calculated_by	person	person_key	fk_cost_pool_group_calc2
posted_by	person	person_key	fk_cost_pool_group_calc3
voided_by	person	person_key	fk_cost_pool_group_calc4

Referenced from

Table	Column	Foreign Key Name
cost_pool_calc	cost_pool_group_calc_key	fk_cost_pool_calc1

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_cost_pool_group_calc	true	cost_pool_group_calc_key	Asc
idx_cost_pool_group_calc1	false	cost_pool_group_key	Asc
idx_cost_pool_group_calc2	false	calculated_by	Asc
idx_cost_pool_group_calc3	false	posted_by	Asc
idx_cost_pool_group_calc4	false	voided_by	Asc
idx_cost_pool_group_calc5	false	post_fiscal_month_key	Asc
idx_cost_pool_group_calc6	false	rev_fiscal_month_key	Asc
idx_cost_pool_group_calc7	false	budget_key	Asc