publish to LDS when the following checks pass: check referenced note_id, person id, visit_occurrence_id and visit_detail_id exist within the payload.
optional - generate rejected rows due to missing reference ids from step 3.
5 Add pipeline changes to all of the data sources, OMOP, PCORNet, ACT, TriNetX.
We need to accommodate, special cases where if the data partner forgets to submit the NOTE and NOTE_NLP datasets in the current payload then we should not overwrite the previously loaded dataset but try to reprocess the data with the current person and visit_occurrence ids.