New feature: supervisor provided TA load and funding info

[jonatanschroeder]

We should provide supervisors (who can have the same roles as instructors) the ability to provide information about funding for their TAs. This means that:

• Students should have a new column indicating the user ID of their supervisors (up to two). This should be optional, and only unit 1s will typically have this filled (though it's ok for unit 2 to have a value or for unit 1 to not have it, e.g., for users from other departments).
• A new table indicates, for an applicant and a term, what their TA load is expected to be (in quarter loads), and some comment field.
• A new page in the instructor view allows instructors (supervisors) to indicate, for all TAs they supervise, their expected load and a comment.
• The applicant page should include for information the expected TA load provided by the supervisor.
• An export option in the admin page should list all applicants where the supervisor has provided the load, including applicant name, student number, supervisor name(s), TA load and comments.

[kukuminer]

[jonatanschroeder]

Possible MVP for now:

• a table (funding_loads) with unique key user ID (applicant) and term and a column for funding level (in quarter loads);
• when the applicant opens the application, the expected funding level is shown to the user:
  • Label: Required load for full funding;
  • Help: This load is based on information provided by your supervisor. In order to obtain full funding for the term, you need to be assigned one or more TA positions at this load. If this information does not match your records, please get in touch with your supervisor. If your availability is lower than this value, you are forfeiting part of your funding.
  • If zero: You are not expected to get a TA position for the coming term, either because you have completed your required funding or because your supervisor is covering your funding for the term. If this information does not match your records, please get in touch with your supervisor.
  • If record missing: do not show.
• Make availability default to this value.

[kukuminer]

PK: ID (serial) unique: userid, termid data: funding level (number)

[kukuminer]

add note beside availability in student application, note displays if a matching entry exists in the table note displays expected load from the student ("required load for full funding")

[jonatanschroeder]

Note: instead of userid, please use the student ID to identify the user. Some users have never logged in to the system when we provide the funding, and the info we have has the student number as key.

[kukuminer]

@jonatanschroeder forgot to ask: what should take precedent for availability in a new application?

1. The most recent term's availability OR
2. the funding number

[jonatanschroeder]

The funding number takes precedence.

[kukuminer]

resolved by #153

[jonatanschroeder]

I am reopening this to keep track of the supervisor-facing interface to provide this information.