Versions Compared

Key

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

...

  1. Structure (Column A): In this cell, users need to choose a should select Tracked Entity Attribute (TEA) from the provided options. Upon selecting a has been selected TEA, the subsequent columns must be highlighted in red to indicate their mandatory status:

    1. UID

    2. Name

    3. Short Name

    4. Value type

    5. Aggregation type

  2. UID (Column B): This cell should be automatically filled in once the user enters the TEA name.

  3. Name (Column C): The user must enter TEA name and the following column should be automatically filled in:

    1. UID

    2. Short name

    3. Value type

    4. Aggregation type

  4. Short Name (Column D):This cell should be automatically filled in once the user enters the TEA name.

  5. Value Type (Column E): This cell should be automatically filled in once the user enters the TEA name.

  6. Aggregation Type (Column F): This cell should be automatically filled in once the user enters the TEA name.

  7. Mandatory (Column G): The user will be able to select between yes and no. If the user selects “Yes”. The TEA must be filled to complete the event.

  8. Searchable (Column H): The user will be able to select between yes and no. If the user selects “Yes”, allows the TEA to be used as a search filter in the Tracked Entity Instance list.

  9. Display in List (Column I): The user will be able to select between yes and no. If the user selects “Yes”, the value of the selected TEA will be displayed in the Tracked Entity Instances list.

  10. Allow Future Date (Column J): The user will be able to select between yes and no. If the user selects “Yes”, the TEA will allow selecting a future date.

  11. Error/Warning/Info (Column M): The template will show detail regarding the cell highlighting on each row.

Note
  • The UID, Short name, Value Type and Aggregation Type are used to verify that the TEA exists in the server, in case the TEA doesn’t exit, the cells will display a “Not found” message.

  • In case the expected cells aren't automatically populated, you can resolve this by dragging the formula from another cell within the same column.

  • Columns I to L will default to "No" if the cells are left blank.

...

A Tab is generated for every Program Stage available. Each Tab is used for the corresponding Program Stage management.

...

Managing sections

  • To add another section, the user only will have to add a new row (it is very important to remark that an entire row needs to be added) right below the previous section’s last stage.

    • For a new section, the user has to select "Section" on the Structure (A) column.

    • Then type a name on (C) column that will be displayed for the new section.

Managing Data elements

Adding new data elements:

  1. Structure (Column A): In this cell, users should select Data Elements from the provided options. Upon has been selected Data element, the subsequent columns must be highlighted in red to indicate their mandatory status:

    1. Form name

  2. Correlative (Column B): This cell should be automatically filled in once the user selecting Data Element in the structure column.

  3. Use auto Naming (Column C): The use can select between “yes” and “no”.

    1. If the user selects “Yes”, the full name, short name and code must not be entered by the user. These cells should be highlighted in gray color.

    2. If the user select “No”, the users must enter the full name, short name and code. These cells should be highlighted in red color.

  4. Form Name (Column D):This cell should be automatically filled in once the user enters the TEA name.

  5. Value Type (Column E): This cell should be automatically filled in once the user enters the TEA name.

  6. Aggregation Type (Column F): This cell should be automatically filled in once the user enters the TEA name.

  7. Mandatory (Column G): The user will be able to select between yes and no. If the user selects “Yes”. The TEA must be filled to complete the event.

  8. Searchable (Column H): The user will be able to select between yes and no. If the user selects “Yes”, allows the TEA to be used as a search filter in the Tracked Entity Instance list.

  9. Display in List (Column I): The user will be able to select between yes and no. If the user selects “Yes”, the value of the selected TEA will be displayed in the Tracked Entity Instances list.

  10. Allow Future Date (Column J): The user will be able to select between yes and no. If the user selects “Yes”, the TEA will allow selecting a future date.

  11. Error/Warning/Info (Column M): The template will show detail regarding the cell highlighting on each row.