Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Stakeholder

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

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.

Note

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)

Banner ID

Insert excerpt
Common Definitions
Common Definitions
nameSTUDENTID
nopaneltrue

Name

Insert excerpt
Common Definitions
Common Definitions
nameFIRSTNAME
nopaneltrue

Insert excerpt
Common Definitions
Common Definitions
nameLASTNAME
nopaneltrue

Employee Class

Banner Page PEAEMPL

Insert excerpt
Common Definitions
Common Definitions
nameemployee_class
nopaneltrue

Employee Group

Banner Page PEAEMPL

Insert excerpt
Common Definitions
Common Definitions
nameEmployee Group
nopaneltrue

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

...