EB/EJ Annual Due Date | Opens Nov, due Jan 31 | ||||||
---|---|---|---|---|---|---|---|
Document status |
We learned most of these in 2020 for MIS Term 209 | ||||||
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.
...
:
Status | Error/Quality Check | Solution | Presumed Benefits | References/Comments | Proposed User | Resources | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||
| EB06 - Null Values |
| Emergency response, accommodation studies. Not having to manually look this up each cycle. | Keila Reynosa, Linda Reis | ||||||||
| 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” | |||||||||
| 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” | |||||||||
| EB11 Crosswalk |
| need to re-engage on this, HR needs to create more position class codes to relate more to contract duration than to hours per day (pt/ft) | Keila Reynosa, Linda Reis |
Resolved Issues:
Status | Error/Quality Check | Solution | Presumed Benefits | References/Comments | Proposed User | Resources |
---|
| EJ03 - INVALID TOP CODE (Non-Instructional) |
Mary Schaefer in Payroll graciously populated values for us before we realized that some BAM values are invalid.
|
|
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:
| More accurate IPEDs/Datamart. Could run reports off assignment classifications. | Keila Reynosa, Linda Reis |
| 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 | ||||||||||||
| 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 |
Code Block | ||
---|---|---|
| ||
SELECT DISTINCT BANINST1.COS_GENERAL.GET_BANNERID_FROM_PIDM(NBRJOBS_PIDM) AS BANNER_ID
,F_GET_ORDERBY_LAST_NAME(NBRJOBS_PIDM) AS LAST_NAME
,F_GET_ORDERBY_FIRST_NAME(NBRJOBS_PIDM) AS FIRST_NAME
,NBRJOBS_POSN
,NBRJOBS_SUFF
,NBRJOBS_DESC
,MAX(PHRHIST_EVENT_DATE)
FROM NBRJOBS
LEFT JOIN PHRHIST ON NBRJOBS_PIDM = PHRHIST_PIDM
WHERE NBRJOBS_PIDM NOT IN
(
SELECT SIRASGN_PIDM
FROM SIRASGN
WHERE SIRASGN_TERM_CODE = '202310' --FALL 2022
)
AND BANINST1.COS_EMPLOYEE.F_JOB_IS_ACTIVE(NBRJOBS_PIDM, NBRJOBS_POSN, NBRJOBS_SUFF) = 'A'
AND (NBRJOBS_ECLS_CODE LIKE 'J%' OR NBRJOBS_ECLS_CODE LIKE 'F%')
AND PHRHIST_EVENT_DATE=(SELECT MAX(PHRHIST_EVENT_DATE) FROM PHRHIST)
AND NBRJOBS_SUFF = '00'
GROUP BY NBRJOBS_PIDM
,NBRJOBS_POSN
,NBRJOBS_SUFF
,NBRJOBS_DESC
,PHRHIST_EVENT_DATE
ORDER BY BANNER_ID ASC |
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
- SIAASGN>Non Instructional Tab>SIRNIST_ASTY_CODE needs to be discussed. We need to decide of Banking Load, Using Bank Load, or Load Balancing should be reported and how. CLC (converted to Credit, Leave) is used in each scenario. Those then fail the referential to EJ02 where the employee assignment is typically “Y - Not Applicable” (not on Leave).
Relates to this project:
SIAASGN Best Practices ImplementationCan 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
- Hours per Day seems to be given a blanket 1 or 8.
- HR to assess on a per case basis. May require update to forms and will require getting that information from the hiring manager(s).
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)
Expand | ||
---|---|---|
| ||
Assignments that rely on just NBAJOBS records seem to be inaccurate. EJ04 has an integrity check to make sure it doesn’t exceed an allowed amount. |
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
- Audit FTE on non-instructional employees in particular.
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
- Populate GOAMEDI>General Medical Information>"Primary Disability"
Emergency response, accommodation studies.
Keila Reynosa, Linda Reis
8
EB11 Crosswalk
- Audit PTRECLS, EEO “6-Unreported”. Currently crosswalks to EB11 “1-Less than 9 months” on PTVEEOG
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.
|
| Prevent access/pay issues from possibly arising in the future. | Possibly related to records with NBRJOBS_DATA_ORIGIN like '%.sql' |
| 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 |
Question
Plan to Answer
Answer
Do we have any employees who should be reported but aren’t?
All HR |
Open Questions
| EJ01, EJ02 - ASSIGNMENT TYPE AND LEAVE TYPE MUST AGREE | Keila (HR Technician) and Linda (HR Specialist) decided on to 1) not report when employees save bank time and 2) report employees who use bank time. From that decision Khantee (Executive Assistant - Academic Services) will:
| Can create backup for Khantee. Make the offline Excel document more resilient. | EB-EJ Error Report Reference has specific examples with PII on Issue ID “EJ01_1” | Khantee See conversation can be assisted by: Antonio |