Goals
Develop the exclusion form of the application. This tab is only used by the CCs so it's hidden from all other campuses.
JIRAs
| Jira Legacy | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Requirements
| # | Title | User Story | Importance | Notes |
|---|
| Exclusion Screen | Faculty has the right to exclude up to 10 tenured faculty members from serving | Must Have |
|
Buttons
Modal box
Validation
| Must Have |
| Workflow | When is the deadline for this form? When is the TPRC committee formed? |
| Tenure codes in the HR datamart | AES ANE ANP APR APT EES EME ENS FAE FCN FEN FNR FNT FPP FPR FTA FTD FTN FTP FVF N/A | Tenured faculty for the FPP listing should only look at the bolded tenure codes on the left; they're also listed here for convenience FTN FTA | ||
| FPP listing for faculty | Header row titles
|
|
FPP listing for Chancellors (not used in the system but exists in the database) | Header row titles
|
|
User interaction and design
...
- only status column needs to be decoded; see status descriptions
| Code Block |
|---|
select name, employee_alt_id, empl_record_no, campus_key as campus, eac_division_desc as division, eac_branch_desc as branch, eac_section_desc as section, job_title, grade, tenure_year, empl_status as status from edadba.psempl where empl_status != 'T' and employee_type_code='F' and tenure_code= in ('FTN','FTA') order by name; |
...
Query below pulls the FPP listing for chancellors, which is the same as above but includes the tenured faculty's gender and ethnicity (not used in the system)
| Code Block |
|---|
select name, ps.employee_alt_id, empl_record_no, campus_key as campus, eac_division_desc as division,
eac_branch_desc as branch, eac_section_desc as section, job_title,
grade, tenure_year, empl_status as status, sex as gender,
decode(eeo_uh,'HS','Hispanic','AA','Black or African American','AI','American Indian or Alaskan','CA','White','CH','Chinese','FI','Filipino','GC','Guamanian or Chamorro','HW','Native Hawaiian or Part Hawaiian','IN','South Asian and Asian Indian','JP','Japanese','KO','Korean','LA','Laotian','MC','Micronesian','OA','Other Asian','OP','Other Pacific Islander','SA','Samoan','TH','Thai','TO','Tongan','VI','Vietnamese') as ethnicity
from edadba.psempl ps, edadba.psethnicity eth
where ps.employee_alt_id=eth.employee_alt_id and empl_status != 'T' and
ps.employee_type_code='F' and tenure_code='FTN' order by name; |
Questions
Below is a list of questions to be addressed as a result of this requirements document:
| Question | Outcome |
|---|---|
| Can the TPRC members be from any campus or only the campus for which this applicant is applying for? | Any campus for CCs Manoa has their complex selection process but they should come from Manoa faculty ranks 4/5, not on leave, not from the applicant's college. |
| When are the lists generated? | Generated in August or September. T&P process ends early Spring because by June, the board has to |
approve them; tenure is effective |
July 1 and promotions are effective |
August 1. Since we're hitting the HR datamart directly, out internal table is updated daily. | |
| Who generates the lists? | Leilani creates the list using Brio; OHR generates the system list which includes the CCs Not applicable as to who generates the lists because this process is automated. |
| What is on the list? | See FT-56 for the CC and System lists. Leilani generates 2 lists, one for the faculty and one for the chancellor. |