Data Guidelines

The data structure the CRF Heat Map expects is one record per participant ID, per visit, per form. The variables listed below are not all required to initialize the chart, but are all used at Rho and by default:

• sitename
• subjectnameoridentifier
• folderinstancename
• ecrfpagename
• is_partial_entry
• verified
• needs_verification
• ready_for_freeze
• is_frozen
• is_signed
• needs_signature
• is_locked
• open_query_cnt
• answer_query_cnt
• foldername
• architectformname
• status
• subjfreezeflg
• subset1
• subset2
• subset3
• folder_ordinal
• form_ordinal

Data Suggestions

• The database subset variables (subset1, subset2, subset3) shall contain values of at most 10 characters.
• The database subset variables (subset1, subset2, subset3) shall not contain empty strings. Replace them with N/A.