Assignment Percentage

From CSUMB Data Glossary
Jump to navigation Jump to search

Assignment Percentage is the percentage a given class component or assigned time represents of an instructors overall workload FTE percentage for a term.

Metadata
Where Term Appears
CSUMB Data Warehouse Dashboards:
Data Custodian
Academic and Centralized Scheduling
Data Source
Source System:CMS - SA
Source Table Name:PS_CLASS_INSTR
Source Field Name:ASSIGNMENT_PCT
Census Process:Y
Logical Transformation / Calculation
N/A
OBIEE Folder and Column
Folder Heading:"Fact - Class Instructor"
Column Heading:"Assignment Percentage"


Business Rules

The system uses the following formula to calculate an individual's assignment full-time equivalency percentage for a regular scheduled class (non-OEE):

(assignment workload hours × assigned number of weeks × 100) / (100 percent weekly workload hours × total weeks in term)

Definition Source

"Regular Assignment FTE Formula

The system uses the following formula to calculate an individual's assignment full-time equivalency percentage for a regular scheduled class (non-OEE):

(assignment workload hours × assigned number of weeks × 100) / (100 percent weekly workload hours × total weeks in term)."[1]

References

  1. Oracle. PeopleSoft CS9.0. Student Records. Understanding Instructor Workload. Instructor Assignment Percentage Formulas. Retrieved from: https://docs.oracle.com/cd/E56917_01/cs9pbr4/eng/cs/lssr/concept_UnderstandingInstructorWorkload-ab485e.html#topofpage.