Scholar Number

From CSUMB Data Glossary
Jump to navigation Jump to search

Scholar Number or EMPLID (Employee Id Number) uniquely identifies a person within the organization.[1]

Metadata
Where Term Appears
CSUMB Data Warehouse Dashboards:
Data Custodian
Office of the Registrar
Data Source
Source System:CMS - HR; CMS - SA
Source Table Name:PS_PERSONAL_DATA
Source Field Name:EMPLID
Census Process:No
Logical Transformation / Calculation
OBIEE Folder and Column
Folder Heading:"Scholar"
Column Heading:"Scholar Number"

EMPLIDs are used for both students and employees.

Business Rules

IDs beginning with '8' were converted from Banner; PeopleSoft generates IDs beginning with '0'.

References

  1. Oracle. PeopleSoft HCM 9.1 Application Fundamentals PeopleBook. PeopleSoft HCM Application Fundamentals Preface. Retrieved from: https://docs.oracle.com/cd/E28727_01/hcm91fp2/eng/psbooks/hhaf/chapter.htm?File=hhaf/htm/hhaf01.htm.