Hi all,
I always refer to everyone’s posts.
Today, I would like to hear your opinions on how to handle discharge dates. Due to the method of extracting source data, we have cases where data starts with a discharge date without an admission date. In such cases, I would like to know your policy for ETL. I am considering three options:
- Generate records that only have a discharge date without an admission date.
- Do not generate records that start with a discharge date.
- Insert some value for the admission date and generate the record.
This is a very detailed matter, but I would appreciate hearing about your experiences.