First step is the comparison of metadata with the SDTM domain metadata. If the data getting from the data MANAGEMENT is in somewhat compliance to SDTM metadata, use automated MAPPING as the Ist step.

If the data management metadata is not in compliance with SDTM then avoid auto mapping. So do MANUAL mapping the datasets to SDTM datasets and the mapping each variable to appropriate domain.

The whole process of mapping include: *Read in the corporate data standards into a database table.

• Assign a CDISC domain prefix to each database module.
• Attach a COMBO box containing the SDTM variable for the selected domain to a new mapping variable field.
• Search each module, and within each module select the most appropriate CDISC variable.
• Then search for variables mapped to the wrong type Character not equal to Character; Numeric not equal to Numeric. 
• Review the mapping to see if any conflicts are RESOLVABLE by mapping to a more appropriate variable.
• We need to verify that the mapped variable is appropriate for each role.
• Then finally we have to ensure all ‘required’ variables are present in the domain6.

First step is the comparison of metadata with the SDTM domain metadata. If the data getting from the data management is in somewhat compliance to SDTM metadata, use automated mapping as the Ist step.

If the data management metadata is not in compliance with SDTM then avoid auto mapping. So do manual mapping the datasets to SDTM datasets and the mapping each variable to appropriate domain.

The whole process of mapping include: *Read in the corporate data standards into a database table.