Versions Compared

Old Version 12

changes.mady.by.user Cameron Ahana

Saved on

compared with

New Version 13

changes.mady.by.user Cameron Ahana

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
serverUH JIRA
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
maximumIssues20
jqlQueryfilter = "T&P Exclusion JIRAs"
serverIdd86084f3-16da-3128-87cd-009c94364c75

Requirements

#TitleUser StoryImportanceNotes

 Exclusion Screen

Faculty has the right to exclude up to 10 tenured faculty members from serving
on their TPRC committee.

Must Have


  

Buttons

  • "Add"

Modal box

  • Enter in the faculty to exclude

Validation

  • Applicant cannot exclude more then 10 people
  • It is valid to not exclude anyone
  • Applicants can only exclude people on the FPP list
Must Have 

 WorkflowWhen is the deadline for this form? When is the TPRC committee formed?   


FPP listing for faculty

Header row titles

  1. Name
  2. Campus
  3. Division
  4. Branch
  5. Section
  6. Job Title
  7. Grade
  8. Tenure Year
  9. Status
 
 



  • Either build a FPP database table which must be updated nightly (question) (question) or pull the information on the fly from the HR datamart

 FPP listing for Chancellors

Header row titles

  1. Name
  2. Campus
  3. Division
  4. Branch
  5. Section
  6. Job Title
  7. Grade
  8. Tenure Year
  9. Status
  10. Gender
  11. Ethnicity
 

  • Either build a FPP database table which must be updated nightly (question) (question) or pull the information on the fly from the HR datamart

...

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;

...


Query below pulls the FPP listing for chancellors, which is the same as above but includes the tenured faculty's gender and ethnicity
 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:
...