...
- Bulk Operation
- TPRC Assignment
- include app IDs to exclude from the process
Flat file format
The flat file will contain the reviewers who are eligible to be on a TPRC committee for the upcoming cycle. OVPAE pulls the following from Peoplesoft.
- Rank 5 tenured faculty not on leave
- Remove those who served on last year's TPRC lists
- Poll faculty who are available
CSV file will have the following fields
...
OVPAE will give us an xls extract from PS which includes the fields below in addition to many other fields. UHM College Code corresponds to our system's Office ID which maps to "Job Div Cd" in the speadsheet.
| UH Number | Faculty Type | UHM College Code |
Program to process flat file and do bulk assignment
...