Active Employees

Data Source

Oracle [PROD]

Job/Process Source (Refresh Interval)

REPORTSNET.COS_SV_ACTIVE_EMPLOYEES [LIVE]

 

Report Domain

BANINST1.COS_SSO_EMPLOYEE

Functional User(s)

Norma Chavez (Human Resource Assistant)

Constituent(s)

Janet Leija (Facilities Technician)

Used to true up employees on the DMV Employer Pull Notice Program

Report Owner

Keila Reynosa (Human Resource Technician)

Data Domain(s)

Employment

Contains PII

Yes

What It’s Used For

Returns people who are active employees and their COS_Email and Employee type.

Long term this report should incorporate Employees and the Reports To reports to move us away from EIS. At that point it should be renamed to something more comprehensive.

Options

Options

Description

Options

Description

Email

text field to search for emails (or a portion of an email)

Employee’s First Name

text field to search for a name (or a portion of a name)

Employee’s Last Name

text field to search for a name (or a portion of a name)

ID

text field to search for a Banner ID.

Must be exact. Must include the @ symbol

Results

Field Name

Data Source/Logic

Field Name

Data Source/Logic

Banner_ID

 

FIRST_NAME

 

LAST_NAME

 

COS_EMAIL

 

EMP_TYPE

COS_GEN_SSO.EMP_CLASS_CODE

 


Version Date Comment
Current Version (v. 6) Oct 31, 2024 17:31 Jordan Lamb
v. 5 Oct 31, 2024 17:29 Jordan Lamb
v. 4 Oct 31, 2024 17:27 Jordan Lamb
v. 3 Oct 31, 2024 17:19 Jordan Lamb
v. 2 Oct 30, 2024 21:04 Jordan Lamb
v. 1 Oct 30, 2024 20:56 Jordan Lamb