Table: cost_report_element

Previous: cost_report

Unanet Data Model

Next: cost_struct

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	cost_report_element_key	decimal(15)
2.		cost_report_key	decimal(15)		cost_report	fk_cost_report_element1
3.		cost_report_element	varchar(128)
4.		sequence	smallint
5.		actuals_formula	varchar(3500)
6.		budget_formula	varchar(3500)
7.		value_format	char(1)	('N')
8.		total_ind	char(1)	('N')
9.		use_in_rev_report	char(1)	('N')

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
cost_report_key	cost_report	cost_report_key	fk_cost_report_element1

Check Constraints

Name	Definition
cc_cre_total_ind	([total_ind]='N' OR [total_ind]='Y')
cc_cre_use_in_rev_report	([use_in_rev_report]='N' OR [use_in_rev_report]='Y')
cc_cre_value_format	([value_format]='P' OR [value_format]='N')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_cost_report_element	true	cost_report_element_key	Asc
idx_cost_report_element1	true	cost_report_element	Asc
		cost_report_key
idx_cost_report_element2	false	cost_report_key	Asc