Employee Status Description

From CSUMB Data Glossary
Jump to navigation Jump to search

Employee Status Description indicates the payroll status for employees. The statuses are based on either the personnel action or, in a few cases, the reason for the action, such as death.[1]

Metadata
Where Term Appears
CSUMB Data Warehouse Dashboards:Trends by College Dashboard
Data Custodian
University Personnel
Data Source
Source System:CMS - HR
Source Table Name:PSXLATITEM
Source Field Name:XLATLONGNAME
Census Process:No
Logical Transformation / Calculation
N/A
OBIEE Folder and Column
Folder Heading:"CSU Employee"
Column Heading:"Employee Status Description"

Business Rules

The CSUMB Data Warehouse captures employees with the following statuses into the CSU - Human Resources subject area:

  • Active
  • Leave With Pay
  • Leave of Absence
  • Short Work Break
  • Suspended

References

  1. Oracle. PeopleSoft Enterprise Human Resources 9.0 PeopleBook: Administer Workforce. Updating Person and Job Information. Retrieved from: https://docs.oracle.com/cd/E13053_01/hr9pbr1_website_master/eng/psbooks/hhaw/chapter.htm?File=hhaw/htm/hhaw16.htm.