Large Lecture Compensation

Owned by Michael Citi, created
Jun 26, 2024
1 min read

Data Source

Oracle

Job/Process Source (Refresh Interval)

Live

Report Domain

Census Enrollment and Pay Compensation

Functional User(s)

Khantee See, Daniel Alvarado

Constituent(s)

Report Owner

Khantee See

Data Domain(s)

Academic

Contains PII

Yes, Internal Use

What It’s Used For

To more efficiently locate and track large lecture compensation for full time faculty. Essentially, it’s tracking the compensation pay structure for CRN’s that enroll over 40 students.

Options

Options

Description

Options

Description

Term Code

Term code of interest to the report viewer.

PTRM Code

Part of term code. This dropdown is populated by the available PTRM codes in the selected Term Code.

Results

Field Name

Data Source/Logic

Description (sample)

Field Name

Data Source/Logic

Description (sample)

CRN

SIRASGN_CRN

The CRN for the course.

Course

SSBSECT_CRSE_NUMB and SSBSECT_SUBJ_CODE

The combined course number and subject code for the course.

Faculty

SPRIDEN_LAST_NAME,
SPRIDEN_FIRST_NAME,
SPRIDEN_MI

The full faculty name of the assigned faculty to the course.

Banner ID

SPRIDEN_ID

The Banner ID for the faculty member.

Census Enroll

SSBSECT_CENSUS_ENRL

The total value of students enrolled in the CRN by the census date.

WCH

SCBCRSE_LEC_HR_LOW

Weekly Contact Hours (Units).

OL Hours

((((SSB.SSBSECT_CENSUS_ENRL - 40) / 40)) * 17.5 * NVL(SSB.SSBSECT_LEC_HR, SCB.SCBCRSE_LEC_HR_LOW))

Large Class Overload Hours. The math determines the value at which to multiply the Hourly Rate to calculate the Total Pay.

Hrly Rate

NBRJOBS_REG_RATE

Pay rate for the faculty during the selected term.

Total Pay

OL Hours * Hrly Rate

Total pay calculation.

 

Version Date Comment
Current Version (v. 1) Jun 26, 2024 22:10 Michael Citi