Employee

Business ApplicationsE-Business SuiteEnterpriseERPOracle

Properties

Name	Type	Description
personId	integer	Person identifier
employeeNumber	string	Employee number
title	string	Title (Mr., Mrs., etc.)
firstName	string	First name
middleNames	string	Middle name(s)
lastName	string	Last name
fullName	string	Full name (derived)
knownAs	string	Preferred name
emailAddress	string	Email address
sex	string	Gender
dateOfBirth	string	Date of birth
nationalIdentifier	string	National identifier (e.g., SSN)
nationality	string	Nationality code
maritalStatus	string	Marital status
effectiveStartDate	string	Record effective start date (date-tracked)
effectiveEndDate	string	Record effective end date (date-tracked)
hireDate	string	Original hire date
currentEmployeeFlag	string
businessGroupId	integer	Business group identifier
addresses	array
phones	array
creationDate	string
lastUpdateDate	string

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "Employee",
  "type": "object",
  "properties": {
    "personId": {
      "type": "integer",
      "description": "Person identifier"
    },
    "employeeNumber": {
      "type": "string",
      "description": "Employee number"
    },
    "title": {
      "type": "string",
      "description": "Title (Mr., Mrs., etc.)"
    },
    "firstName": {
      "type": "string",
      "description": "First name"
    },
    "middleNames": {
      "type": "string",
      "description": "Middle name(s)"
    },
    "lastName": {
      "type": "string",
      "description": "Last name"
    },
    "fullName": {
      "type": "string",
      "description": "Full name (derived)"
    },
    "knownAs": {
      "type": "string",
      "description": "Preferred name"
    },
    "emailAddress": {
      "type": "string",
      "description": "Email address"
    },
    "sex": {
      "type": "string",
      "description": "Gender"
    },
    "dateOfBirth": {
      "type": "string",
      "description": "Date of birth"
    },
    "nationalIdentifier": {
      "type": "string",
      "description": "National identifier (e.g., SSN)"
    },
    "nationality": {
      "type": "string",
      "description": "Nationality code"
    },
    "maritalStatus": {
      "type": "string",
      "description": "Marital status"
    },
    "effectiveStartDate": {
      "type": "string",
      "description": "Record effective start date (date-tracked)"
    },
    "effectiveEndDate": {
      "type": "string",
      "description": "Record effective end date (date-tracked)"
    },
    "hireDate": {
      "type": "string",
      "description": "Original hire date"
    },
    "currentEmployeeFlag": {
      "type": "string"
    },
    "businessGroupId": {
      "type": "integer",
      "description": "Business group identifier"
    },
    "addresses": {
      "type": "array"
    },
    "phones": {
      "type": "array"
    },
    "creationDate": {
      "type": "string"
    },
    "lastUpdateDate": {
      "type": "string"
    }
  }
}