To create table descriptions for a custom program, copy existing table definitions in LSH

  • Recommendation: To create table descriptors for a custom program, in LSH, copy the study's existing target and source table definitions to the local application area. Do not use the existing definitions from the study application area for the custom program.

    Note:

    You do not need to do this if the source and target tables are the same table definition.

  • Rationale: The study's existing target and source table definitions typically provide the most accurate description of the tables. In addition, following this guidance allows for a consistent approach when underlying table definitions are updated.

  • Additional information: When you reference a study-specific table to create a table descriptor, make sure that the table descriptor does not reference the study, and that you copy the definition to the local application area.

    This method is a reliable, efficient, and repeatable way to create table descriptors. If you need to update or recreate them, you can recreate the exact process and the definition is a reliable description of the circumstance in the study.

    If you used the same definition for the source and target tables, load an MDD file that describes the table as the table descriptor for both source and target.