Skip to content

eq_ppi table needs to be refactored into an tc_interview table #6

@apippin

Description

@apippin

eq_ppi table should be renamed to tc_interview table

  • eqpresppi field should be changed to an enumerated type field called "type" with enumerated values "hti" and "ppi".
    • The upgrade script should set all visits currently marked as eq_presppi with "type" "ppi" and all other visits should set to "hti".
  • ppi field should be changed to "interview".
    • The upgrade script should rename the field.
  • The UI will need to change to enable companionship interviews to be scheduled and recorded.
    • Add a setting to the tc_config file to specify if "hti" type interviews are done as companionships or individuals.
    • Add a setting to the tc_config file to specify who does "ppi" type interviews (president, president + counselors, president + counselors + secretary).   + The UI will need to be updated to only list the valid interviewers for "ppi" type interviews based on this setting.
    • If hometeaching interviews are done for a companionship, the tool should make 2 entries in the tc_interview table for each individual with the same notes, date, type, and interviewer field values.
    • If hometeaching interviews are done for a companionship, the scheduling tool should let you select the companionship, rather than the individual. That way, you only have to manually schedule one interview, even though the tool would create both entries in tc_interview

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions