Table harbinger.public.claim_transaction_facts
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19  √  nextval('claim_transaction_facts_id_seq'::regclass)
service_performed_year int2 5
service_performed_month int2 5
service_performed_day int2 5
service_performed_hour int2 5
service_performed_minute int2 5
service_performed_epoch int8 19
service_performed_dow int2 5
service_performed_woy int2 5
transaction_post_month int2 5
transaction_post_year int2 5
transaction_post_day int2 5
transaction_post_hour int2 5
transaction_post_minute int2 5
transaction_post_epoch int8 19
transaction_post_dow int2 5
transaction_post_woy int2 5
claim_transaction_id int8 19
claim_transactions.id claim_transaction_facts_claim_transaction_id_fk R
claim_id int8 19  √  null
claims.id claim_transaction_facts_claim_id_fk R
site_id int8 19  √  null
sites.id claim_transaction_facts_site_id_fk R
site_class_id int8 19  √  null
site_classes.id claim_transaction_facts_site_class_id_fk R
cms_hcpcs_code_id int8 19  √  null
cms_hcpcs_codes.id claim_transaction_facts_cms_hcpcs_code_id_fk R
insurance_policy_id int8 19  √  null
insurance_policies.id claim_transaction_facts_insurance_policy_id_fk R
insurance_carrier_plan_id int8 19  √  null
insurance_carrier_plans.id claim_transaction_facts_insurance_carrier_plan_id_fk R
insurance_carrier_plan_grouping_id int8 19  √  null
insurance_carrier_plan_groupings.id claim_transaction_facts_insurance_carrier_plan_grouping_id_fk R
insurance_carrier_id int8 19  √  null
insurance_carriers.id claim_transaction_facts_insurance_carrier_id_fk R
ordering_employee_id int8 19  √  null
employees.id claim_transaction_facts_ordering_employee_id_fk R
performing_employee_id int8 19  √  null
employees.id claim_transaction_facts_performing_employee_id_fk R
billing_employee_id int8 19  √  null
employees.id claim_transaction_facts_billing_employee_id_fk R
posting_employee_id int8 19  √  null
employees.id claim_transaction_facts_posting_employee_id_fk R
claim_status_id int8 19  √  null
external_system_statuses.id claim_transaction_facts_claim_status_id_fk R
universal_event_type_id int8 19  √  null
universal_event_types.id claim_transaction_facts_universal_event_type_id_fk R
claim_transaction_type_id int8 19  √  null
claim_transaction_types.id claim_transaction_facts_claim_transaction_type_id_fk R
claim_denial_reason_id int8 19  √  null
reasons.id claim_transaction_facts_claim_denial_reason_id_fk R
self_pay bool 1  √  null
unit_count int4 10  √  null
transaction_amount int8 19  √  null
updated_at timestamptz 35,6 now()

Analyzed at Tue Aug 16 14:31 UTC 2022

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc claim_transaction_facts_id
billing_employee_id Performance Asc claim_transaction_facts_billing_employee_id_idx
claim_denial_reason_id Performance Asc claim_transaction_facts_claim_denial_reason_id_idx
claim_id Performance Asc claim_transaction_facts_claim_id_idx
claim_status_id Performance Asc claim_transaction_facts_claim_status_id_idx
claim_transaction_id Performance Asc claim_transaction_facts_claim_transaction_id_idx
claim_transaction_type_id Performance Asc claim_transaction_facts_claim_transaction_type_id_idx
cms_hcpcs_code_id Performance Asc claim_transaction_facts_cms_hcpcs_code_id_idx
insurance_carrier_id Performance Asc claim_transaction_facts_insurance_carrier_id_idx
insurance_carrier_plan_grouping_id Performance Asc claim_transaction_facts_insurance_carrier_plan_grouping_id_idx
insurance_carrier_plan_id Performance Asc claim_transaction_facts_insurance_carrier_plan_id_idx
insurance_policy_id Performance Asc claim_transaction_facts_insurance_policy_id_idx
ordering_employee_id Performance Asc claim_transaction_facts_ordering_employee_id_idx
performing_employee_id Performance Asc claim_transaction_facts_performing_employee_id_idx
posting_employee_id Performance Asc claim_transaction_facts_posting_employee_id_idx
service_performed_day Performance Asc claim_transaction_facts_service_performed_day_idx
service_performed_dow Performance Asc claim_transaction_facts_service_performed_dow_idx
service_performed_epoch Performance Asc claim_transaction_facts_service_performed_epoch_idx
service_performed_hour Performance Asc claim_transaction_facts_service_performed_hour_idx
service_performed_minute Performance Asc claim_transaction_facts_service_performed_minute_idx
service_performed_month Performance Asc claim_transaction_facts_service_performed_month_idx
service_performed_woy Performance Asc claim_transaction_facts_service_performed_woy_idx
service_performed_year Performance Asc claim_transaction_facts_service_performed_year_idx
site_class_id Performance Asc claim_transaction_facts_site_class_id_idx
site_id Performance Asc claim_transaction_facts_site_id_idx
transaction_post_day Performance Asc claim_transaction_facts_transaction_post_day_idx
transaction_post_dow Performance Asc claim_transaction_facts_transaction_post_dow_idx
transaction_post_epoch Performance Asc claim_transaction_facts_transaction_post_epoch_idx
transaction_post_hour Performance Asc claim_transaction_facts_transaction_post_hour_idx
transaction_post_minute Performance Asc claim_transaction_facts_transaction_post_minute_idx
transaction_post_month Performance Asc claim_transaction_facts_transaction_post_month_idx
transaction_post_woy Performance Asc claim_transaction_facts_transaction_post_woy_idx
transaction_post_year Performance Asc claim_transaction_facts_transaction_post_year_idx
universal_event_type_id Performance Asc claim_transaction_facts_universal_event_type_id_idx

Close relationships  within of separation: