dhis2_submission_status

Table: dhis2_submission_status

The dhis2_submission_status table tracks the status of data submissions to the DHIS2 system.
It records API responses, payloads, and submission timestamps for monitoring and troubleshooting.

---

Columns

Column Name	Data Type	Constraints	Description
id	int(11)	NOT NULL, AUTO_INCREMENT	Unique identifier for each submission record
DHIS2_center_id	int(11)	NULL	Internal ID of the DHIS2 center to which data was submitted
period_date	date	NULL	Period or date for which the data was submitted
api_status_code	int(3)	NULL	HTTP status code returned by the DHIS2 API
api_response	text	NULL	Response message or body returned by the API
payload	text	NULL	The data payload sent to the DHIS2 system
created_at	datetime	DEFAULT CURRENT_TIMESTAMP	Timestamp when the submission record was created

---

Indexes

1. PRIMARY - Primary key on id

---

Foreign Key Relations

• None

---

Usage Notes

• Stores submission results for data sent to DHIS2 for tracking and auditing.
• api_status_code and api_response help in identifying failures or errors.
• payload field allows for debugging by storing the exact data sent.
• created_at tracks when each submission occurred.