Employee Record Number

From CSUMB Data Glossary
Jump to navigation Jump to search

Employee Record Number identifies the record number a job is assigned to and usually starts with an employee record number of 0.

Where Term Appears
CSUMB Data Warehouse Dashboards:N/A - Inactive and not available on dashboards
Other Reports:N/A
Data Custodian
University Personnel
Data Source
Source System:CMS - HR
Source Table Name:PS_INSTR_TERM_DTL
Source Field Name:EMPL_RCD
Census Process:N/A
Logical Transformation / Calculation
OBIEE Folder and Column
Folder Heading:N/A
Column Heading:N/A

Employees may have multiple employee record numbers. The first job would be the lowest in the sequence.

Business Rules

Brand new state employees (that have not worked for the university corporation) would be assigned an employee record number of 0. Multiple active appointments at the same time may increment the employee record number in sequential order.


  • 0
  • 1
  • 2
  • 10

See Also

Definition Source

"Employment record numbers (ERNs), in combination with a person's ID, uniquely identify a person’s job data records. The system distinguishes between a person’s organizational instances by using a new ERN when you create a new instance."[1]


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