Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Checklist for Pipeline table upload

1. Check for any white spaces in all labels and remove them (use trim() function in Excel).)

Image Added


2. Cross check the Code List/response domain Response Domain and Question Item tables to verify the response domain Response Domain is correctly attached (checking that if there is one attached that it is in the corresponding table and the labels match) with each question item (use VLOOKUP function in Excel).

Image Added



3. Check Parent_Name in tables Sequence, Statement, Question item, Question grid, Condition, Loop match with the same label as the table referred to in the Parent_Type table (use VLOOKUP function in Excel).


Image Addedif 


4. Check the code lists attached in the Question Item table have values (no blanks) for the min_responses and max_responses. However, Response domains Could have blanks for min_responses and max_responses. (use filter function in Excel).



5. Check for duplicate code lists Code List attached in the Question Item table which have different min_responses and max_responses (a code list must have unique min and max cardinality) (use filter function in Excel).

Image Added

6. Check the positions across the Sequence, Statement, Question item, Question grid, Condition and Loop tables to make sure they are in order within each Parent_Name, ensuring that thethere are no items across the tables which have the same Parent_Name and Position. (use filter function in Excel)