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 | Yes |
🛠 What It’s Used For
HR 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 for 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 |
| 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. |
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.
| Version | Date | Comment |
|---|---|---|
| Current Version (v. 3) | Sep 29, 2023 17:49 | 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