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.

📄 Results

Field Name

Data Source/Logic

Description (sample)

Banner ID

Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'.

Name

Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'.

Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'.

E Class

PEAMPL PEBEMPL_ECLS_CODE

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.

E Group

🗺 Report Domain


Version Date Comment
Current Version (v. 1) May 01, 2023 21:56 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
  • No labels