Uploaded image for project: 'Teacher Preparation Data Model'
  1. Teacher Preparation Data Model
  2. TPDMX-197

Unsure where to store "Next Steps" or "Action Steps"

    XMLWordPrintable

Details

    Description

      Two types of data we're storing in the TPDM are Goals and Action Steps. We have recently been utilizing Goals to store the goals that teachers create in our platform at the beginning of the school year. "Next Steps" (also called Action Steps") are a very important piece of data that we store and associate to Goals. Next Steps are like to-do items or tasks, and are a critical part of the growth cycle for teachers.

      We are having trouble figuring out the best place to store these. As a brief reference, these Action Steps contain the following data:

      • Description (text string)
      • Staff member
      • Due date (optional)

      There are more fields we store (like complete or archived flags, statuses, etc) but at a minimum this is the core of the Action Step.

      Our current plan, which we are not that happy with, is to store these in the Goals domain entity, utilizing the "GoalType" field of that entity as a means of denoting that the object is an Action Step; i.e. we would use a descriptor "Goal" for the GoalType field if the object is a Goal and the descriptor "Action Step" in that field if the object is an Action Step. This is purely a workaround and a separate table for these Action Steps would be highly preferable; however, we understand the nature of adding a new table like this and are looking for any guidance at all where to store this of data.

      Thank you very much for your time and please let me know if there is any additional information or context needed.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mike Mike Gioia
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Salesforce