| Page Properties | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
|
...
PA Program Spreadsheet | CASPA Source Field (API) | Slate Source Field |
|---|---|---|
CASPA ID | CAS/Liaison Persion ID | |
Last Name | Last Name | |
First Name | First Name | |
Middle Name | Middle Name | |
Email Address | Email Address | |
Repeat Candidate | ||
PA/MPH | dualdegree_choice_code | Program |
Vet | persInfo.otheInfo,.milStat0.militaryStatus | Military Veteran or Military Veteran Status? |
Age at Submission | persInfo.biogInfo.birtInfo.dob | Birthdate |
State | Current Mailing Address State | |
College | Primary college | |
Major | Primary college | |
Science GPA | ||
PreReq GPA | ||
Overall GPA | ||
App Score | Scoring: Application Score Score | |
Interview 1 Score | ||
Interview 2 Score | ||
Total Score | ||
Interviewer 1 Comments | ||
Interviewer 1 Rec | ||
Interviewer 2 Comments | ||
Interviewer 2 Rec | ||
Final Decision | ||
Date PID sent to admissions | ||
Pt Care Hours | Patient Care Experience: Total Hours |
Outcome:
Workflow View Queries
⚙️ To limit the output of the field value to be related to Interviewer 1 or Interviewer 2:
Start with a subquery export set to output = coalese. Then add a subquery export and add an export for the value you want to export if additional conditions are met. Then add a subquery filter to calculate if the current user (username) matches the username of the value of interviewer 1. If that is true, then the subquery export will populate with whatever was set for the export.
Set up the second subquery export for the next possible value in the same way, then save.
...
⚙️ To filter the view so the only results in the Reader are for candidates where the interviewer/reader is the one currently looking at the reader (i.e., can only see your own candidates in the Reader bin view):
In the View, add a subquery filter and set aggregate = comparison. Join to current user. Join Application to Form Responses, then Form Responses to Form Submitter. Join Form Responses to Form.
Add an export for current user username and an export for form submitter username, and set those as the two values you are comparing. Add filter for the form title to limit results to only the reader review form you need.
Custom PDF for Reader Form
...