Page Comparison

1

EJ03 - INVALID TOP CODE (Non-Instructional)

•  Valid ASA codes required on NBAJOBS>CA Pension Tab for reportable employees without a teaching assignment

Mary Schaefer in Payroll graciously populated values for us before we realized that some BAM values are invalid.

•  Some null values exist

Keila Reynosa, Linda Reis

BAM, Argos MIS EJ03 Report

2

EB07, EB08 - EEO6 AND EMPLOYMENT CLASS MUST AGREE

•  NTRPCLS>NTRPCLS_ESKL_CODE needs an audit for the following employee types: Police Academy instructors, Fire Academy instructors, assistant coaches

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) likely by Academic Services.

Keila Reynosa, Linda Reis, Khantee See

EB DED

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

EB-EJ Error Report Reference has specific examples with PII on Issue ID “EJ01_1”

Khantee See

EJ DED

4

EB09 - Null Values

•  PTRJCRE Job Change type crosswalk field has null values on about 70 codes.

Keila Reynosa, Linda Reis

EB DED

5

EJ04 - Quality Check

•  Hours per Day seems to be given a blanket 1 or 8.

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

EJ DED

6

EJ08 - Quality Check

•  Audit FTE on non instructional employees in particular.

FTE seems to be listed at 1 for Primary and Secondary assignments on PEAEMPL. For non instructional assignments that leads to some employees with >2 Full Time Equivalent loads.

Keila Reynosa, Linda Reis

EJ DED

7

EB06 - Null Values

•  Populate GOAMEDI>General Medical Information>"Primary Disability"

Keila Reynosa, Linda Reis

EB DED

8

EB11 Crosswalk

•  Audit PTRECLS, EEO “6-Unreported”. Currently crosswalks to EB11 “1-Less than 9 months” on PTVEEOG

Keila Reynosa, Linda Reis

EB DED

9

EJ08 - WEXP on Student Side

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”

Jordan Lamb , ludmilag

10

EJ08 - NURS Scheduling

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”

Jordan Lamb , ludmilag

11

EJ - Assignment not properly terminated.

•  Find jobs on NBAJOBS that have an NBRBJOB_END_DATE, but an NBRJOBS_STATUS that is not “T-Terminated”

SELECT *

FROM NBRJOBS a

INNER JOIN NBRBJOB

ON NBRBJOB_PIDM = a.NBRJOBS_PIDM AND NBRBJOB_POSN = a.NBRJOBS_POSN AND a.NBRJOBS_SUFF = NBRBJOB_SUFF

WHERE a.NBRJOBS_STATUS = 'A'

AND a.NBRJOBS_POSN NOT IN

(SELECT b.NBRJOBS_POSN

FROM NBRJOBS b

WHERE a.NBRJOBS_PIDM = b.NBRJOBS_PIDM AND a.NBRJOBS_SUFF = b.NBRJOBS_SUFF AND b.NBRJOBS_STATUS = 'T')

AND NBRBJOB_END_DATE < SYSDATE;

Possibly related to records with NBRJOBS_DATA_ORIGIN like '%.sql'

Jordan Lamb ludmilag