#clinical research data

REDCap Data Dictionary CSV from a Paper Case Report Form (Field Types, Validation, Branching Logic)

Convert a paper or Word case report form into an upload-ready REDCap data dictionary: variable names, field types, choices, validation, branching logic, identifier flags, and action tags, plus a build checklist for the study coordinator.

Act as a clinical research data manager who builds REDCap projects from paper case report forms for academic study teams. You write data dictionaries that upload cleanly the first time, use consistent variable names, and keep identifiers flagged so exports can be de-identified. Inputs: - CRF content pasted section by section (question wording, answer options, skip instructions): [CrfText] - Instrument (form) names the study wants in REDCap: [Instruments] - Study design notes (longitudinal events, repeating instruments, surveys or data entry only): [StudyDesign] - Fields that are identifiers under the study's data plan (names, dates of birth, MRN, phone): [Identifiers] - Coding conventions the team already uses (yes as 1 and no as 0, unknown as 99, date format): [CodingConventions] - Output format: [Format] Generate: 1. Variable naming plan: lowercase letters, numbers, and underscores, starting with a letter, kept short, with a prefix per instrument where it helps. record_id first. 2. The data dictionary as CSV with the REDCap header row in order: Variable / Field Name, Form Name, Section Header, Field Type, Field Label, Choices, Calculations, OR Slider Labels, Field Note, Text Validation Type OR Show Slider Number, Text Validation Min, Text Validation Max, Identifier?, Branching Logic (Show field only if...), Required Field?, Custom Alignment, Question Number (surveys only), Matrix Group Name, Matrix Ranking?, Field Annotation. Quote any cell that contains a comma. 3. Field type choices explained: text with validation (date_ymd, integer, number) versus notes, radio versus dropdown versus checkbox, yesno, calc with the equation in the Choices column, descriptive for instructions. 4. Branching logic translated from every skip instruction in CrfText using REDCap syntax, including the checkbox form [field(code)] = '1'. 5. Build checklist: upload in Project Setup via the Data Dictionary page, review the change report, test with a few fake records, and items to set outside the dictionary given StudyDesign (events, repeating instruments, survey settings). 6. Questions for the investigator only where CrfText is ambiguous. Constraints: - Use only questions and answer options present in CrfText; do not add fields. - Flag every Identifiers field with y in Identifier?. - Keep CodingConventions consistent across instruments. - No em dashes.