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

Version 1 Next »

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 PTRECLS so there may be codes no longer in use or never in use.

If there are additional codes added to the PTRECLS table then the Argos Bot (Automated Emails) would need to be modified.

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

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

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 PEBEMPL_ECLS_CODE

Naming Convention:

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 PEBEMPL_EGRP_CODE

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. 1) Sep 29, 2023 16:33 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.