Table harbinger.public.claim_transactions
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_transactions_id_seq'::regclass)
card_case_claim_transactions.claim_transaction_id card_case_claim_transactions_claim_transaction_fk R
claim_transaction_cms_modifiers.claim_transaction_id claim_transaction_cms_modifiers_claim_fk R
claim_transaction_diagnoses.claim_transaction_id claim_transaction_diagnoses_claim_transaction_fk R
claim_transaction_facts.claim_transaction_id claim_transaction_facts_claim_transaction_id_fk R
claims.current_claim_transaction_id claim_current_claim_transaction_fk R
claims.first_claim_transaction_id claim_first_claim_transaction_fk R
rad_exam_claim_transactions.claim_transaction_id rad_exam_claim_transactions_claim_transaction_fk R
claim_id int8 19
claims.id claim_transaction_claim_fk R
claim_sequence int8 19
cms_hcpcs_code_id int8 19
cms_hcpcs_codes.id claim_transaction_cms_hcpcs_code_fk R
service_performed timestamptz 35,6
ordering_employee_id int8 19  √  null
employees.id claim_transaction_ordering_employee_fk R
performing_employee_id int8 19  √  null
employees.id claim_transaction_performing_employee_fk R
billing_employee_id int8 19
employees.id claim_transaction_billing_employee_fk R
posting_employee_id int8 19  √  null
employees.id claim_transaction_posting_employee_fk R
transaction_post timestamptz 35,6
claim_status_id int8 19
external_system_statuses.id claim_transaction_claim_status_external_system_status_fk R
claim_transaction_type_id int8 19
claim_transaction_types.id claim_transaction_claim_transaction_type_fk R
transaction_amount int8 19
unit_count int4 10  √  null
balance int8 19
carrier_id int8 19  √  null
insurance_carriers.id claim_transaction_carrier_fk R
insurance_policy_id int8 19  √  null
insurance_policies.id claim_transaction_insurance_policy_fk R
self_pay bool 1  √  null
auth_number text 2147483647  √  null
comments text 2147483647  √  null
claim_denial_reason_id int8 19  √  null
reasons.id claim_transaction_claim_denial_reason_fk R
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_id
auth_number Performance Asc claim_transaction_auth_number_idx
transaction_post Performance Asc claim_transaction_post_idx
service_performed Performance Asc claim_transaction_service_performed_idx
carrier_id Performance Asc claim_transactions_carrier_fk
claim_id + claim_sequence Performance Asc/Asc claim_transactions_dm_idx
insurance_policy_id Performance Asc claim_transactions_insurance_policy_fk
billing_employee_id Performance Asc fki_claim_transaction_billing_employee_fk
claim_denial_reason_id Performance Asc fki_claim_transaction_claim_denial_reason_fk
claim_id Performance Asc fki_claim_transaction_claim_fk
cms_hcpcs_code_id Performance Asc fki_claim_transaction_cms_hcpcs_code_fk
claim_status_id Performance Asc fki_claim_transaction_external_system_status_fk
ordering_employee_id Performance Asc fki_claim_transaction_ordering_employee_fk
performing_employee_id Performance Asc fki_claim_transaction_performing_employee_fk
posting_employee_id Performance Asc fki_claim_transaction_posting_employee_fk
claim_transaction_type_id Performance Asc fki_claim_transaction_transaction_type_fk

Close relationships  within of separation: