...
- Develop the exclusion form of the application
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? | |||
| FPP listing for faculty | Header row titles
|
|
| ||||
| FPP listing for Chancellors | Header row titles
|
|
|
User interaction and design
...
| 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='FTN' order by name; |
...
| 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; |
...
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 |
| When are the lists generated? | Generated in August or September. T&P process ends early Spring because by June, the board has to |
| Who generates the lists? | Leilani creates the list using Brio; OHR generates the system list which includes the CCs |
| 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. |