Hi!
I am writing to ask whether it is okay to add a column, for instance, to the visit_occurence table named ‘visit occurence_id_source_value’ to save the source ID value. the visit IDs I am mapping from the source table are not integers and are a bit messy, so I created an auto incremented numeric id for visit_occurence_id. I also do not want to lose these source IDs as they might come useful when a use case requires a link back to the source dataset. I thought I could just add a column, but I figured that it’s also important to maintain the schema of the CDM because that is the purpose of the CDM. Should I add the column or do you suggest any other solution?
I would deeply appreciate your assistance. I also apologize if this question has been asked before. I searched in the forum and did not see it. Thank you and have a great day!