Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

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

COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_SATURN_SPRIDEN

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

Error rendering macro 'excerpt-include' : No location was provided.

Name

COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_SATURN_SPRIDEN

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

COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_GENERAL_GOREMAL

The CAMP Email type for the employee.

Current Hire Date

COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_PAYROLL_PEBEMPL

The Most Current Date of Hire

Original Hire Date

COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_PAYROLL_PEBEMPL

The first date of hire for this person

Termination Date

COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_PAYROLL_PEBEMPL

The date of termination/ separation for this person

Reason

COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_PAYROLL_PEBEMPL/COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_POSNCTL_NBRJOBS

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

COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_POSNCTL_NBRJOBS

If Separation the position code for the job they no longer work at.

Position Title

COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_POSNCTL_NBRJOBS

If Separation the position title for the job they no longer work at.

Department Org

COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_PAYROLL_PEBEMPL

If Separation The Organization Code this position belongs to.

Department Name

COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_PAYROLL_PEBEMPL

If Separation The organization description for the organization code.

Direct Manager

COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_POSNCTL_NBBPOSN

If Separation The Title of the Position that this persons job reported to.

Salary Grade

COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_POSNCTL_NBRJOBS

If Separation The Salary grade for the persons job.

Salary Step

COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_POSNCTL_NBRJOBS

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
  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.