Goals
- Develop of the eligibility portion of the application
Requirements
| # | Title | User Story | Importance | Notes |
|---|---|---|---|---|
| Eligibility Screen | Coordinator will input this information for the Applicant | Must Have |
| |
| Form Fields | Campus
Subject Area
Primary Department
Primary College
Secondary Department
Secondary College
Initial Appointment (can this information be pulled from PeopleSoft's historical tables?)
Current Appointment (Pull information from PeopleSoft)
Tenure Consideration
Memo
Date of Tenure
Date of Last Promotion Waiver of Minimum Requirements
| Must Have |
|
User interaction and design
PeopleSoft Queries
Pulls all the fields in 1 query (subject area, primary and secondary department and college, initial and current appointment, date of tenure 
, date of last promotion
select ps.name, ps.empl_record_no, ps.eac_division_desc as primary_division, ps.eac_branch_desc as primary_branch,
ps.eac_section_desc as subject_area, secondary_ps.empl_record_no as secondary_empl_no, secondary_ps.eac_division_desc as secondary_division,
secondary_ps.eac_branch_desc as secondary_branch, ps.grade as current_grade,
initial_hire.grade as initial_grade, ps.tenure_code, ps.tenure_desc, ps.tenure_year, ps.univ_appt_date, ps.tenure_effective_date,
initial_hire.pers_reason_effective_date as hire_date, last_promotion.pers_reason_effective_date as last_promotion_date
from edadba.psempl ps,
(select * from
(select employee_alt_id, empl_record_no, eac_division_desc, eac_branch_desc, row_number()
over(partition by employee_alt_id order by empl_record_no ) as sort_column
from edadba.psempl where employee_alt_id='14589893' and employee_type_code='F' and empl_status <> 'T' and empl_record_no > 1)
where sort_column = 1) secondary_ps,
(select * from
(select employee_alt_id, empl_record_no, grade, pers_reason_effective_date, row_number()
over(partition by employee_alt_id order by pers_reason_effective_date desc ) as sort_column
from edadba.hr_ps_report_tbl where employee_alt_id='14589893' and employee_type_code='F' and pers_action in ('HIR','HRC'))
where sort_column = 1) initial_hire,
(select * from
(select employee_alt_id, empl_record_no, grade, pers_reason_effective_date, row_number()
over(partition by employee_alt_id order by pers_reason_effective_date desc ) as sort_column
from edadba.hr_ps_report_tbl where employee_alt_id='14589893' and employee_type_code='F' and pers_action='PRO')
where sort_column = 1) last_promotion
where ps.employee_alt_id='14589893' and
ps.employee_type_code='F' and
ps.empl_status <> 'T' and
ps.employee_alt_id = secondary_ps.employee_alt_id(+) and
ps.employee_alt_id=initial_hire.employee_alt_id and
ps.empl_record_no=initial_hire.empl_record_no and
ps.employee_alt_id=last_promotion.employee_alt_id(+) and
ps.empl_record_no=last_promotion.empl_record_no(+);
Questions
Below is a list of questions to be addressed as a result of this requirements document:
| Question | Outcome |
|---|---|
| Is the Tenure Consideration field required? | yes |
| Does the Coordinator need to upload a document of Chancellor's approval? | yes |