Improper NBAJOBS Termination

Data Source

Variable

Refresh Interval

Dependent on Data Source

Functional User

Keila Reynosa (Human Resource Technician)

Report Owner

Keila Reynosa (Human Resource Technician)

What It’s Used For

Finds records that were not completely Terminated in Banner.

How To Use

Returns records that have an End Date in the past, but their NBAJOBS record is not Terminated. Report returns null if no records are found.

Parameter

Parameter

Description

Parameter

Description

n/a

 

Checkboxes or Options

n/a

Report Columns

Column

Description

Column

Description

Banner_ID

NBRBJOB_POSN

Position number on NBAJOBS

NBRJOBS_SUFF

Suffix of Position number.

NBRBJOB_END_DATE

End date of NBAJOB record.

Domain

 NBRJOBS and NBRBJOB tables