Employee Without Primary Job

Owned by Jordan Lamb, created
Last updated: Nov 29, 2023
1 min read

Data Source

PROD

Job/Process Source (Refresh Interval)

HR does data entry on PEAEMPL and/or NBAJOBS

(Pulls from Live Data but Interval is Daily)

Functional User(s)

Keila Reynoso, Nancy Yanes, Elvia Rangel

Constituent(s)

Linda Reis

Report Owner

Keila Reynoso

Data Domain(s)

Employment

Contains PII

Yes

What It’s Used For

Banner allows employees to have jobs without having a primary job. Primary job is needed for reporting. This report is to catch data entry errors as they occur (Argos Automated Emails) and historical issues.

Options

Options

Description

Options

Description

Date

Date where report will query to look for missing Primary Job employees.

Employee Class

Grabs from the validation table PTRECLS so there may be codes no longer in use or never in use.

If there are additional codes added to the PTRECLS table then the Argos Bot (Automated Emails) would need to be modified.

Results

Field Name

Data Source/Logic

Description (sample)

Field Name

Data Source/Logic

Description (sample)

Banner ID

 

Name

 

Employee Class

Banner Page PEAEMPL

Employee Group

Banner Page PEAEMPL

Report Domain

In addition to the options selected by the report user the query looks at NBAJOB (NBRBJOB) and if an employee has a non-primary job, but does not have a primary job then they are returned on the report.

Version Date Comment
Current Version (v. 7) Nov 29, 2023 19:24 Jordan Lamb
v. 6 May 03, 2023 21:43 Jordan Lamb
v. 5 May 03, 2023 20:05 Jordan Lamb
v. 4 May 01, 2023 23:03 Jordan Lamb
v. 3 May 01, 2023 22:55 Jordan Lamb
v. 2 May 01, 2023 21:57 Jordan Lamb
v. 1 May 01, 2023 21:56 Jordan Lamb