Data Source | Snowflake Prod_DB |
|---|---|
Job/Process Source (Refresh Interval) | HR does data entry on PEAEMPL and/or NBAJOBS (Pulls from day old data in Snowflake) |
Functional User(s) | Norma Chavez |
Stakeholder(s) | Linda Reis |
Report Owner | Norma Chavez |
Data Domain(s) | Employment |
Contains PII | No |
🛠 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 If there are additional codes added to the |
📄 Results
Field Name | Data Source/Logic | Description (sample) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Banner ID | Commonly Referred to as Banner ID. This is a unique ID per person/non-person that begins with the “@” symbol. This is PII, but widely used as the least bad option where COS Employees have “legitimate educational interest.” | |||||||||||||||||||
Name | A person’s legal first name. Often populated off CCCApply Application or manual entry by Human Resources. Allowed null for both persons and non-persons. A person’s legal surname. Often populated off CCCApply Application or manual entry by Human Resources. Allowed null for both persons and non-persons. | |||||||||||||||||||
Employee Class | Banner Page PEAEMPL | Describes the employee type in a more detail than Employee Group. Stored on Code Class A% Administrator B% Board Members C% Classified & Confidential F% Faculty J% Adjunct Faculty M% Miscellaneous R% Retiree S% Student SF & SJ break Naming Convention but aren’t in use. | ||||||||||||||||||
Employee Group | Banner Page PEAEMPL | A broader classification of employees than “Employee Class.” Stored on Has a linkage to MIS reporting. |
🗺 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. 2) | Sep 29, 2023 16:38 | Joshua Metry |
| v. 3 | Sep 29, 2023 17:49 | Joshua Metry |
| v. 2 | Sep 29, 2023 16:38 | Joshua Metry |
| v. 1 | Sep 29, 2023 16:33 | Joshua Metry |
Add Comment