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(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 |
📄 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. | |||||||||||||||||||
E Class | PEAMPL | 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. | ||||||||||||||||||
E Group | A broader classification of employees than “Employee Class.” Stored on Has a linkage to MIS reporting. |
🗺 Report Domain
| Version | Date | Comment |
|---|---|---|
| Current Version (v. 3) | May 01, 2023 22:55 | 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 |
Add Comment