Notifications
Erreur (Errors/Notifications)
The Erreur table contains all notifications generated by Gestal systems.
| Column | Type | Description |
| DateErr | Timestamp | Date and time of occurence ('yyyy-MM-dd HH:mm:ss.SSS') |
| CodeErr | 16-bit integer | Error or notification code (see chart below) |
| EmplID | 16-bit integer | Unique location ID |
| Section | 16-bit integer | Section of feeder location (see chart below) |
| NomEmpl | Varchar(20) | Location name |
| DataErr | Varchar(100) | Additional details about notification |
| DejaVu | Boolean | Marked as read or not by the user |
Sections conversion table
| ID | Description |
1 | System |
3 | Farrowing |
4 | Gestation |
5 | Breeding |
6 | Finishing |
9 | Heat detection |
Codes conversion table
| Code | Description |
0 | Nothing found (unplugged converter?) |
1 | Missing antenna |
10 | Backup failed |
11 | Backup path not found |
12 | Backup disk full |
100 | Missing feeder |
101 | No motor pulse count |
102 | Motor pulse count lower than target |
103 | Motor pulse count higher than target |
104 | Motor error (unknown) |
106 | Sow present at 2 locations (details in data field) |
107 | No calibration |
108 | Empty feed reserve |
109 | Missing data (details in data field) |
110 | RFID reader not detected |
111 | Sow detected in wrong pen |
112 | Suspicious sow ID readings |
113 | Fixed heating device not detected |
114 | Variable heating device not detected |
115 | Temperature probe not detected |
116 | Paint marker maximum count reached |
117 | Second sow ID not read |
118 | Maximum number of consectuve motor errors reached |
119 | Gestation unit did not feed since X hours |
120 | Farrowing detected (unused) |
121 | Calibration outdated |
122 | Suspicious calibration values |
301 | Suspicious feed distribution |