PeopleSoft · Schema
Employee
PeopleSoft HCM employee personal data record.
Campus SolutionsCRMEnterprise SoftwareERPFinancial ManagementHCMSupply Chain Management
Properties
| Name | Type | Description |
|---|---|---|
| EMPLID | string | Employee ID. |
| NAME | string | Employee full name. |
| FIRST_NAME | string | First name. |
| LAST_NAME | string | Last name. |
| DEPTID | string | Department ID. |
| JOBCODE | string | Job code. |
| POSITION_NBR | string | Position number. |
| LOCATION | string | Work location code. |
| COMPANY | string | Company code. |
| BUSINESS_UNIT | string | Business unit. |
| EMPL_STATUS | string | Employment status. |
| HR_STATUS | string | HR status. |
| REG_TEMP | string | Regular or temporary. |
| FULL_PART_TIME | string | Full or part time. |
| HIRE_DT | string | Hire date. |
| TERMINATION_DT | string | Termination date. |
| ANNUAL_RT | number | Annual salary rate. |
| CURRENCY_CD | string | Currency code. |
| EMAIL_ADDR | string | Email address. |
| PHONE | string | Phone number. |
| ADDRESS1 | string | Street address. |
| CITY | string | City. |
| STATE | string | State code. |
| POSTAL | string | Postal code. |
| COUNTRY | string | Country code. |
| SUPERVISOR_ID | string | Supervisor employee ID. |