RuralDeathInput

Run Query

Table Name: rural_death_inputs

Columns
Name Type Nullable Primary Key Default
id INTEGER False Yes None
agreement_no VARCHAR False No None
customer_name VARCHAR True No None
death_date DATE True No None
death_certificate_no VARCHAR True No None
product_code VARCHAR True No None
state VARCHAR True No None
remark VARCHAR True No None
city VARCHAR True No None
claim_status VARCHAR True No None
claim_amount FLOAT True No None
month INTEGER True No None
year INTEGER True No None
metadata JSONB True No None
file_ingestion_id UUID True No None
ingestion_cycle_id INTEGER True No None
cycle_code VARCHAR(50) True No None
payout_category VARCHAR(128) True No None
payout_functions ARRAY True No None
payout_calculation_status VARCHAR(10) False No ScalarElementColumnDefault('pending')
payout_calculation_metadata JSONB True No None
payout_recipient_id VARCHAR(255) True No None
last_calculated_at DATETIME True No None
created_by VARCHAR(128) True No None
created_at DATETIME False No None
created_by_role VARCHAR(50) True No None
checked_by VARCHAR(128) True No None
checked_at DATETIME True No None
checker_status VARCHAR(50) True No None
checker_remarks TEXT True No None
approved_by VARCHAR(128) True No None
approved_at DATETIME True No None
approver_status VARCHAR(50) True No None
approver_remarks TEXT True No None
last_updated_by VARCHAR(128) True No None
last_updated_at DATETIME False No None
audit_version INTEGER True No ScalarElementColumnDefault(1)
audit_action VARCHAR(50) True No None
Data Filters

Active Filters:

Data Records
id agreement_no customer_name death_date death_certificate_no product_code state remark city claim_status claim_amount month year metadata file_ingestion_id ingestion_cycle_id cycle_code payout_category payout_functions payout_calculation_status payout_calculation_metadata payout_recipient_id last_calculated_at created_by created_at created_by_role checked_by checked_at checker_status checker_remarks approved_by approved_at approver_status approver_remarks last_updated_by last_updated_at audit_version audit_action
Relationships

This model has no defined relationships.