Algorithm: Max categorical / other value per patient

[atbenmurray]

Add a first / last date algorithm:

• For a given primary key
• For a given table where that primary key is used as a foreign key
• Get maximum value for each given foreign key mapped to the primary keys
  • If this is a categorical field, construct a categorical field in response