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
Table Column
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