EB/EJ Annual Due Date | Opens Nov, due Jan 31 |
---|---|
Document status | IN PROGRESS |
Document owner | |
Tech lead | |
Functional User(s) | Keila Reynosa, Linda Reis, Norma Chavez, Khantee See |
Report Manager(s) | John Bratsch, Jennifer Vega La Serna |
Objective
Detail where reports are deficient and steps to resolve and prioritize issues.
Priority | Status | Error/Quality Check | Solution | Presumed Benefits | References/Comments | Proposed User | Resources |
---|---|---|---|---|---|---|---|
1 | EJ03 - INVALID TOP CODE (Non-Instructional) |
Mary Schaefer in Payroll graciously populated values for us before we realized that some BAM values are invalid. Values must comply with DED and BAM. 6000 - 7900 HR Banner Consultant Meeting on 5/24/2022 recommended that Applications script populate ASA codes off the Program code. It does not appear that the Program code of every FOAP lines up with an allowed ASA code: SELECT a.NBRJLBD_PIDM, F_GETSPRIDENID(a.NBRJLBD_PIDM) AS BANNER_ID, a.NBRJLBD_POSN, a.NBRJLBD_SUFF, a.NBRJLBD_PROG_CODE, a.NBRJLBD_EFFECTIVE_DATE, NBRJOBS_DESC FROM NBRJLBD a JOIN NBRJOBS ON NBRJLBD_PIDM = NBRJOBS_PIDM AND NBRJLBD_POSN = NBRJOBS_POSN AND NBRJLBD_SUFF = NBRJOBS_SUFF JOIN PEBEMPL ON NBRJLBD_PIDM = PEBEMPL_PIDM JOIN NBBPOSN ON NBBPOSN_POSN = NBRJLBD_POSN INNER JOIN ( SELECT NBRJLBD_PIDM, MAX(NBRJLBD_EFFECTIVE_DATE) AS NBRJLBD_EFFECTIVE_DATE FROM NBRJLBD GROUP BY NBRJLBD_PIDM ) b ON a.NBRJLBD_PIDM = b.NBRJLBD_PIDM AND a.NBRJLBD_EFFECTIVE_DATE = b.NBRJLBD_EFFECTIVE_DATE WHERE NBRJOBS_STATUS = 'A' AND PEBEMPL_EMPL_STATUS = 'A' AND NBRJOBS_SGRP_CODE LIKE '2022%' AND (NBRJLBD_PROG_CODE < '6000' OR NBRJLBD_PROG_CODE > '8000') AND NBBPOSN_STATUS = 'A' AND PEBEMPL_EGRP_CODE NOT IN ('O','XB','XR','XS','XT') GROUP BY a.NBRJLBD_PIDM, a.NBRJLBD_POSN, a.NBRJLBD_SUFF, a.NBRJLBD_PROG_CODE, a.NBRJLBD_EFFECTIVE_DATE, NBRJOBS_DESC ORDER BY NBRJLBD_POSN ASC; This code returned 749 records on 5/25/2022.
| More accurate IPEDs/Datamart. Could run reports off assignment classifications. | Keila Reynosa, Linda Reis | |||
2 | EB07, EB08 - EEO6 AND EMPLOYMENT CLASS MUST AGREE |
Query that looks for paid faculty that do not have a SIRASGN record w/ Percent of Responsibility > 0 for specified term has been added to the MIS EB/EJ Error Checking report. | Possible benefit of preventing adjunct from going overload. | If it’s decided that they should be non-teaching faculty, then EJ01 will have to be maintained for each of these employees on SIAASGN (SIRNIST). Recommendation is that Academic Services be responsible for that. Ellucian has recommended that we use non-Instructional records to accurately represent the entire responsibilities of an employee’s position. | Khantee See, Keila Reynosa, Linda Reis conversation can be assisted by: Antonio | ||
3 | EJ01, EJ02 - ASSIGNMENT TYPE AND LEAVE TYPE MUST AGREE |
Relates to this project: SIAASGN Best Practices Implementation | Can create backup for Khantee. Make an offline Excel document more resilient. Could create reports for faculty to view. | EB-EJ Error Report Reference has specific examples with PII on Issue ID “EJ01_1” | Khantee See conversation can be assisted by: Antonio | ||
4 | EB09 - Null Values |
| Keila Reynosa, Linda Reis | ||||
5 | EJ04 - Quality Check |
| Could create reports to assess additional positions. Could avoid the erroneous public perception (Datamart/IPEDs) that we have hundreds/thousands hours of extra hours per day being worked by our employees. | EMPLOYEE ASSIGNMENT WEEKLY HOURS if not in student, Hours per Day x Appointment Percent x 5(((NBRJOBS_HRS_DAY * NBRJOBS_APPT_PCT)/100) *5) EB-EJ Error Report Reference has specific examples with PII on Issue ID “EJ04-1” | Keila Reynosa, Linda Reis conversation can be assisted by: Julie Monfette | ||
6 | EJ08 - Quality Check |
| Could create reports off this accurate data. Faculty productivity, FON audit. Could protect us against future audits, or the state using this data for an increased purpose. | FTE seems to be listed at 1 for Primary and Secondary assignments on NBAJOBS. For non-instructional assignments that leads to some employees with >2 Full Time Equivalent loads. | Keila Reynosa, Linda Reis | ||
7 | EB06 - Null Values |
| Emergency response, accommodation studies. | Keila Reynosa, Linda Reis | |||
8 | EB11 Crosswalk |
| Keila Reynosa, Linda Reis | ||||
9 | EJ08 - WEXP on Student Side | We may be reporting WEXP FTE inaccurately. | How should WEXP FTE be reported? Having the answer to this may have impacts on Scheduling. EB-EJ Error Report Reference has specific examples with PII on Issue ID “EJ08-1” | ||||
10 | EJ08 - NURS Scheduling | Would decrease manual edits. | Our SQL that takes the table and converts it to the file seems wrong at the least for NURS sections. Seems like the FTE is summing for each section and putting them on each separate session record. EB-EJ Error Report Reference has specific examples with PII on Issue ID “EJ08-2” | ||||
11 | EJ - Assignment not properly terminated. - AP-105Getting issue details... STATUS |
| Prevent access/pay issues from possibly arising in the future. | Possibly related to records with NBRJOBS_DATA_ORIGIN like '%.sql' | |||
13 (NEW) | We have not been using MIS DED allowed codes for EB14 and there is no crosswalk table. |
| We’ll report more than just three unique values on EB14 | All HR |
Open Questions
Question | Plan to Answer | Answer |
---|---|---|
Do we have any employees who should be reported but aren’t? | Can we write a query based on HR specs, then compare with 209 baseline run? |
0 Comments