Closed PietrH closed 1 month ago
This issue is not actionable until the meeting with RATO, a provided stabile identifier is vastly preferred
I made a mistake in the first post, we need to split off the older records anyway to maintain the old occurrenceIDs. This means we'll need to archive the current dataset in any case.
Had a call with Emiel, he agrees a stabile identifier on the database side is the preferred option. That way we would not need to mint our own as a data processor, a formula that is bound to go wrong sooner or later.
He'll discuss it with the GIS consultant (Sander), and get back to us.
Now using a GUID
Discussed with Sander and Anke, propose using
Dossier_ID
concatenated withLaatst_Bewerkt_Datum
asoccurrenceID
Discussed with @damianooldoni and @LienReyserhove:
All the other points are what we'd need to do if this is impossible:
Dossier_ID
and/orLaatst_Bewerkt_Datum
are not stabile (I've been assured that if they change a record, they make a new one instead) all this effort will be for naught, they have changedDossier_ID
in the past