Oracle E-Business Suite · Schema
Oracle EBS Employee
Schema representing an employee record in Oracle E-Business Suite Human Resources Management System (HRMS). Maps to PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_ADDRESSES, and PER_PHONES tables. Uses date-track versioning where records have effective start and end dates.
Business ApplicationsE-Business SuiteEnterpriseERPOracle
Properties
| Name | Type | Description |
|---|---|---|
| personId | integer | Unique person identifier (PER_ALL_PEOPLE_F.PERSON_ID) |
| employeeNumber | string | Employee number (PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER) |
| personTypeId | integer | Person type identifier (PER_PERSON_TYPES.PERSON_TYPE_ID) |
| title | stringnull | Title (Mr., Mrs., Ms., Dr., etc.) |
| firstName | string | First name |
| middleNames | stringnull | Middle name(s) |
| lastName | string | Last name |
| suffix | stringnull | Name suffix (Jr., Sr., III, etc.) |
| fullName | string | Full name (system-derived: LastName, Title FirstName MiddleNames Suffix) |
| knownAs | stringnull | Preferred/known-as name |
| previousLastName | stringnull | Previous last name (maiden name) |
| emailAddress | stringnull | Email address |
| sex | string | Gender |
| dateOfBirth | stringnull | Date of birth |
| nationalIdentifier | stringnull | National identifier (Social Security Number, National Insurance Number, etc.) |
| nationality | stringnull | Nationality lookup code |
| maritalStatus | stringnull | Marital status lookup code |
| registeredDisabledFlag | stringnull | Registered disabled status |
| effectiveStartDate | string | Date-track effective start date |
| effectiveEndDate | string | Date-track effective end date (31-DEC-4712 for current records) |
| hireDate | string | Original hire date (PER_PERIODS_OF_SERVICE.DATE_START) |
| originalDateOfHire | stringnull | Original date of hire (may differ from hire date for rehires) |
| adjustedServiceDate | stringnull | Adjusted service date |
| terminationDate | stringnull | Actual termination date |
| currentEmployeeFlag | string | Whether the person is currently an active employee |
| businessGroupId | integer | Business group identifier (HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID) |
| assignment | object | Primary employee assignment |
| assignments | array | All employee assignments (including secondary) |
| addresses | array | Employee addresses |
| phones | array | Employee phone numbers |
| periodOfService | object | Current period of service |
| createdBy | integer | User who created the record |
| creationDate | string | Record creation date |
| lastUpdatedBy | integer | User who last updated the record |
| lastUpdateDate | string | Record last update date |
| objectVersionNumber | integer | Object version number for optimistic locking |