IngestionCycleRecord

Table Name: ingestion_cycle_record

Columns

Name	Type	Nullable	Primary Key	Default
`id`	`INTEGER`	False	Yes	None
`category`	`VARCHAR(64)`	False	No	None
`product`	`VARCHAR(128)`	True	No	None
`function`	`VARCHAR(128)`	True	No	None
`month`	`INTEGER`	False	No	None
`year`	`INTEGER`	False	No	None
`status`	`VARCHAR(18)`	False	No	ScalarElementColumnDefault('OPEN')
`is_simulation`	`BOOLEAN`	True	No	ScalarElementColumnDefault(False)
`created_at`	`DATETIME`	False	No	None
`metadata`	`JSONB`	True	No	None
`cycle_code`	`VARCHAR(50)`	True	No	None
`data_period_start`	`DATE`	True	No	None
`data_period_end`	`DATE`	True	No	None
`data_period_month`	`INTEGER`	True	No	None
`data_period_year`	`INTEGER`	True	No	None
`data_period_quarter`	`INTEGER`	True	No	None
`data_period_week`	`INTEGER`	True	No	None
`data_period_label`	`VARCHAR(64)`	True	No	None
`sla_data_ingestion_due`	`DATE`	True	No	None
`sla_data_ingestion_completed`	`DATETIME`	True	No	None
`sla_template_config_due`	`DATE`	True	No	None
`sla_template_config_completed`	`DATETIME`	True	No	None
`sla_validation_due`	`DATE`	True	No	None
`sla_validation_completed`	`DATETIME`	True	No	None
`sla_final_process_due`	`DATE`	True	No	None
`sla_final_process_completed`	`DATETIME`	True	No	None
`sla_status`	`VARCHAR(32)`	True	No	ScalarElementColumnDefault('pending')
`sla_breach_reason`	`TEXT`	True	No	None
`frequency_config_id`	`INTEGER`	True	No	None
`expected_completion_date`	`DATE`	True	No	None
`auto_finalize_date`	`DATE`	True	No	None
`modification_locked`	`BOOLEAN`	True	No	ScalarElementColumnDefault(False)
`payout_cycle_master_code`	`VARCHAR(50)`	True	No	None
`is_finalized`	`BOOLEAN`	False	No	ScalarElementColumnDefault(False)
`finalized_at`	`DATETIME`	True	No	None
`finalized_by`	`VARCHAR(128)`	True	No	None
`finalization_reason`	`TEXT`	True	No	None
`unfreeze_requested_by`	`VARCHAR(128)`	True	No	None
`unfreeze_requested_at`	`DATETIME`	True	No	None
`unfreeze_approved_by`	`VARCHAR(128)`	True	No	None
`unfreeze_approved_at`	`DATETIME`	True	No	None
`unfreeze_reason`	`TEXT`	True	No	None
`payout_categories`	`ARRAY`	True	No	None
`payout_status`	`VARCHAR(23)`	False	No	ScalarElementColumnDefault('not_ready')
`calculation_requested_at`	`DATETIME`	True	No	None
`calculation_completed_at`	`DATETIME`	True	No	None
`calculation_details`	`JSONB`	True	No	None
`payment_details`	`JSONB`	True	No	None

Data Filters

Column

Value

Active Filters:

Data Records

id	category	product	function	month	year	status	is_simulation	created_at	metadata	cycle_code	data_period_start	data_period_end	data_period_month	data_period_year	data_period_quarter	data_period_week	data_period_label	sla_data_ingestion_due	sla_data_ingestion_completed	sla_template_config_due	sla_template_config_completed	sla_validation_due	sla_validation_completed	sla_final_process_due	sla_final_process_completed	sla_status	sla_breach_reason	frequency_config_id	expected_completion_date	auto_finalize_date	modification_locked	payout_cycle_master_code	is_finalized	finalized_at	finalized_by	finalization_reason	unfreeze_requested_by	unfreeze_requested_at	unfreeze_approved_by	unfreeze_approved_at	unfreeze_reason	payout_categories	payout_status	calculation_requested_at	calculation_completed_at	calculation_details	payment_details
1	COLLECTION_01	None	None	11	2025	OPEN	False	2025-10-17 07:58:31	MetaData()	COLL-MTH-2025-10-001	2025-10-01 00:00:00	2025-10-31 00:00:00	10	2025	None	None	October 2025	2025-11-05 00:00:00	None	2025-11-07 00:00:00	None	2025-11-10 00:00:00	None	2025-11-12 00:00:00	None	pending	None	None	2025-11-15 00:00:00	2025-11-20 00:00:00	False	None	False	None	None	None	None	None	None	None	None	None	not_ready	None	None	None	None
2	COLLECTIONS	None		11	2025	OPEN	False	2025-10-17 08:54:28	MetaData()	COLL-MTH-2025-10-002	2025-10-01 00:00:00	2025-10-31 00:00:00	10	2025	None	None	October 2025	2025-11-03 00:00:00	None	2025-11-05 00:00:00	None	2025-11-07 00:00:00	None	2025-11-10 00:00:00	None	pending	None	None	2025-11-15 00:00:00	2025-11-20 00:00:00	False	None	False	None	None	None	None	None	None	None	None	None	not_ready	None	None	None	None

Showing 1-2 of 2

Relationships

Relationship Name	Target Model	Direction
`expected_files`	ingestion_expected_files	ONETOMANY
`file_logs`	ingestion_file_log	ONETOMANY
`file_ingestions`	file_ingestions	ONETOMANY
`batch_index`	cycle_batch_index	ONETOMANY
`evolved_records`	evolved_records	ONETOMANY
`file_replacements`	file_replacement_history	ONETOMANY
`payout_cycle`	payout_cycle_records	ONETOMANY
`upload_sessions`	ingestion_upload_sessions	ONETOMANY
`expected_files_new`	cycle_expected_files	ONETOMANY
`frequency_config`	ingestion_frequency_configs	MANYTOONE
`change_logs`	ingestion_change_logs	ONETOMANY
`finalization_control`	cycle_finalization_controls	ONETOMANY
`dry_runs`	dry_run_executions	ONETOMANY
`master_generation`	cycle_master_generation	ONETOMANY
`lifecycle_records`	ingestion_lifecycle_status	ONETOMANY
`finalization_record`	data_finalization_records	ONETOMANY