...
- When importing data to StudyTRAX on a scheduled basis, It is invaluable to have the same contact extract the source data as cleanly as possible.
- Organization of this data should be cleaned in a procedural fashion, to be sure the same type of data is being imported into StudyTRAX.
- Seperate Separate all subject data as one row per subject and re-label all columns to fit the code names of the data fields defined in StudyTRAX
- If a screening interval is imported, but the screening dates are meaningless to the study, a dummy screening date will be defined as the date the import occurred.
- Make sure all longnitudinal longitudinal type data has a specific date column that defines the encounter date.
- Devise an import plan that best keeps the process procedurally organized. For example, if the number of total subjects in the source database is less than 100, we suggest importing data on a form by form basis for all subjects. This is especially true when importing longnitudinal longitudinal data.
- Be sure all column of unique data source types, fit the destination (StudyTRAX) data source type.
- If a "site variable" is defined in the source data, be sure this is modified to fit the destinations exact "site code" name.
...