PCA Validation Errors & Warnings - psi-org/hnqis2 GitHub Wiki

Excel Validation

Sheet Type Column / Cell Description Message
Instruction Conditional Formatting C12 Program name not found or is empty
Data Validation C12 Length of Program name should not be longer than 225 characters Program name exceeds 225 characters
C15 Length of data element should not be greater than 25 characters Data Element prefix exceeds 25 characters
C14 Should be valid option 'Yes' or 'No' Please selct the valid option from the list
C16 Should be valid Health Area. Please refer to 'Mapping'> 'Health Area' table for valid options. Please select the valid option from the list
Template Data Validation B Should be valid Section Type
  • Section
  • Label
  • Question
  • Score
Please select the valid value from the dropdown
D Should be valid option 'Yes' or 'No'
E Should be a valid option 'Yes' or 'No'
F Should be valid value type
  • NUMBER
  • INTEGER
  • INTEGER_POSITIVE
  • INTEGER_ZERO_OR_POSITIVE
  • TEXT
  • LONG_TEXT
  • PERCENTAGE
  • DATE
  • TIME
G Should be a valid option set. Please refer to 'Mapping' > 'Option Sets' table for valid option.
H Should be a valid Legend set. Please refer to 'Mapping' > 'Legend set' table for valid legend.
I Should be a valid numeric value Value is not numeric
I Value should be greater than '0' The numerator for the specified question have to be greater than zero.
Conditional Formatting A If 'Structure' has value as 'question' or 'label' corresponding Parent Name 'A' cannot be blank A parent name was not defined for the specified element
C If 'Structure' has value then corresponding 'Form Name' cannot be empty. A form name was not defined for the specified element.
C Length of the 'Form Name' should be between 2 and 200 Given form name length is out of the accepted range (Between 2 and 200 characters).
F If 'Structure' has value 'Score' or 'Label' then the valid type is disabled
I or J If 'Score Numerator' has value then corresponding 'Score Denominator' cannot be empty or vice versa
L or M If 'Parent Question' exist then corresponding 'Answer Value' should exist or vice versa.
⚠️ **GitHub.com Fallback** ⚠️