IngestionFileLog
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 |
|---|
Showing 1-0 of 0
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 |
SimPay