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 |
StakeholderConstituent(s) | Linda Reis |
Report Owner | Norma Chavez |
Data Domain(s) | Employment |
Contains PII | NoYes |
🛠 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 issuesHR needs to pull reports of who is terminated/separated to keep NeoEd updated for.
🔘 Options
Options | Description | ||
|---|---|---|---|
Terminated/Separated | These are tabs to determine the type of report the customer wants to see. | ||
Begin Date | Date where report will begin to query to look for missing Primary Job employees. | ||
Employee Class | Grabs from the validation table
| ||
employees terminated/separated | |||
End Date | Date where report will stop the query for employees terminated/separated |
📄 Results
Field Name | Data Source/Logic | Description (sample) | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Banner ID |
|
| |||||||||||||||||||||||||
Name |
|
| Employee Class | Banner Page PEAEMPL | |||||||||||||||||||||||
| Insert excerpt | Common Definitions | Common Definitions | |||||||||||||||||||||||||
| name | employee_class | ||||||||||||||||||||||||||
| nopanel | true | Employee Group | Banner Page PEAEMPL | ||||||||||||||||||||||||
| Insert excerpt | Common Definitions | Common Definitions | |||||||||||||||||||||||||
| name | Employee Group | ||||||||||||||||||||||||||
| nopanel | true |
🗺 Report Domain
...
COS Email |
| The CAMP Email type for the employee. |
Current Hire Date |
| The Most Current Date of Hire |
Original Hire Date |
| The first date of hire for this person |
Termination Date |
| The date of termination/ separation for this person |
Reason |
| The reason the person was terminated/separated. For termination this comes from the first table for separation this comes from the second table. |
Position Code |
| If Separation the position code for the job they no longer work at. |
Position Title |
| If Separation the position title for the job they no longer work at. |
Department Org |
| If Separation The Organization Code this position belongs to. |
Department Name |
| If Separation The organization description for the organization code. |
Direct Manager |
| If Separation The Title of the Position that this persons job reported to. |
Salary Grade |
| If Separation The Salary grade for the persons job. |
Salary Step |
| If Separation The salary step for the persons job. |
🗺 Report Domain
For Termination the data comes primarily from COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_PAYROLL_PEBEMPL. For Separation the data comes primarily from COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_POSNCTL_NBRJOBS.
...
| Change History |
|---|