Versions Compared

Old Version 16

changes.mady.by.user Cameron Ahana

Saved on

compared with

New Version Current

changes.mady.by.user Cameron Ahana

Saved on

Key

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

...

#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?


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

  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) or pull the information on the fly from the HR datamart

FPP listing for Chancellors

(not used in the system but 

exists in the database)

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) 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= 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)

...