Table: post_history

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	post_history_key	decimal(15)
2.		post_timestamp	datetime
3.		document_number	varchar(15)
4.		actuals_through_date	datetime
5.		journal_trans_date	datetime
6.		cp_recalc_begin_date	datetime
7.		cp_recalc_end_date	datetime
8.		posted_by_key	decimal(15)		person	fk_post_history1
9.		time_date_type	char(1)
10.		expense_date_type	char(1)
11.		bill_pool_rate_type	char(1)
12.		recog_pool_rate_type	char(1)
13.		use_financial_orgs	char(1)
14.		feature	tinyint
15.		post_to_gl	char(1)
16.		gl_post_level	tinyint
17.		gl_post_level_offset	tinyint
18.		gl_post_level_offset_alt	tinyint
19.		post_labor_cross_charge	char(1)	('N')

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
posted_by_key	person	person_key	fk_post_history1

Referenced from
Table	Column	Foreign Key Name
cost_plus_post_detail	post_history_key	fk_cost_plus_post_detail7
expense_data_allocation	cost_post_history_key	fk_expense_data_allocation10
expense_data_allocation	post_history_key	fk_expense_data_allocation7
fee_cap_adjustment	post_history_key	fk_fee_cap_adjustment3
fin_document_detail_expense	post_history_key	fk_fin_doc_detail_expense3
fixed_price	billable_post_history_key	fk_fixed_price5
fixed_price	post_history_key	fk_fixed_price4
fp_revenue_schedule	post_history_key	fk_fp_revenue_schedule2
funding_cap_adjustment	post_history_key	fk_funding_cap_adjustment3
journal_cost_plus_detail	post_history_key	fk_journal_cost_plus_detail4
journal_document_expense	post_history_key	fk_journal_document_expense4
journal_expense	post_history_key	fk_journal_expense4
journal_fee_cap_adjustment	post_history_key	fk_journal_fee_cap_adjust4
journal_fixed_price	post_history_key	fk_journal_fixed_price4
journal_funding_cap_adjustment	post_history_key	fk_journal_funding_cap_adj4
journal_prebilled_labor	post_history_key	fk_journal_prebilled_labor4
journal_time	post_history_key	fk_journal_time4
person_time_data	cost_post_history_key	fk_person_time_data13
person_time_data	post_history_key	fk_person_time_data11
prebilled_labor	post_history_key	fk_prebilled_labor2
project_post_history	post_history_key	fk_project_post_history2

Check Constraints
Name	Definition
cc_ph_actuals_through_date	([actuals_through_date]>='1900-01-01' AND [actuals_through_date]<='2099-12-31')
cc_ph_bill_pool_rate_type	([bill_pool_rate_type]='A' OR [bill_pool_rate_type]='P' OR [bill_pool_rate_type]='T')
cc_ph_cp_recalc_begin_date	([cp_recalc_begin_date]>='1900-01-01' AND [cp_recalc_begin_date]<='2099-12-31')
cc_ph_cp_recalc_end_date	([cp_recalc_end_date]>='1900-01-01' AND [cp_recalc_end_date]<='2099-12-31')
cc_ph_cp_recalc_range	([cp_recalc_begin_date] IS NULL AND [cp_recalc_end_date] IS NULL OR [cp_recalc_begin_date] IS NOT NULL AND [cp_recalc_end_date] IS NOT NULL AND [cp_recalc_begin_date]<=[cp_recalc_end_date])
cc_ph_exp_date_type	([expense_date_type]='P' OR [expense_date_type]='C' OR [expense_date_type]='I')
cc_ph_feature	([feature]>=(0) AND [feature]<=(99))
cc_ph_gl_post_level	([gl_post_level]>=(1) AND [gl_post_level]<=(99))
cc_ph_gl_post_lvl_offset	([gl_post_level_offset]>=(1) AND [gl_post_level_offset]<=(99))
cc_ph_gl_post_lvl_offset_alt	([gl_post_level_offset_alt]>=(1) AND [gl_post_level_offset_alt]<=(99))
cc_ph_journal_trans_date	([journal_trans_date]>='1900-01-01' AND [journal_trans_date]<='2099-12-31')
cc_ph_post_labor_cross_charge	([post_labor_cross_charge]='N' OR [post_labor_cross_charge]='Y')
cc_ph_post_to_gl	([post_to_gl]='N' OR [post_to_gl]='Y')
cc_ph_recog_pool_rate_type	([recog_pool_rate_type]='A' OR [recog_pool_rate_type]='P' OR [recog_pool_rate_type]='T')
cc_ph_time_date_type	([time_date_type]='P' OR [time_date_type]='W')
cc_ph_use_financial_orgs	([use_financial_orgs]='N' OR [use_financial_orgs]='Y')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_post_history	true	post_history_key	Asc
idx_post_history1	true	document_number	Asc