IngestionFileLog

Run Query

Table Name: ingestion_file_log

Columns
Name Type Nullable Primary Key Default
id INTEGER False Yes None
file_name VARCHAR(255) True No None
master_or_transaction VARCHAR(64) True No None
cycle_id INTEGER True No None
status VARCHAR(10) False No ScalarElementColumnDefault('PENDING')
received_at DATETIME True No None
checksum VARCHAR(64) True No None
metadata JSONB True No None
file_ingestion_id UUID True No None
config_id INTEGER True No None
version INTEGER False No ScalarElementColumnDefault(1)
is_active BOOLEAN False No ScalarElementColumnDefault(True)
replaced_by_id INTEGER True No None
trigger_type VARCHAR(50) True No None
triggered_by VARCHAR(100) True No None
retry_reason TEXT True No None
records_received INTEGER True No None
records_validated INTEGER True No None
records_failed INTEGER True No None
validation_errors JSONB True No None
payout_category VARCHAR(255) True No None
payout_functions ARRAY True No None
payout_ready BOOLEAN True No ScalarElementColumnDefault(False)
Data Filters

Active Filters:

Data Records
id file_name master_or_transaction cycle_id status received_at checksum metadata file_ingestion_id config_id version is_active replaced_by_id trigger_type triggered_by retry_reason records_received records_validated records_failed validation_errors payout_category payout_functions payout_ready
Relationships
Relationship Name Target Model Direction
file_ingestion file_ingestions MANYTOONE
config master_ingestion_config MANYTOONE
replaced_by ingestion_file_log MANYTOONE
cycle ingestion_cycle_record MANYTOONE
replaces ingestion_file_log ONETOMANY
replaced_as_old file_replacement_history ONETOMANY
replaced_as_new file_replacement_history ONETOMANY