Oracle Siebel · Schema

Oracle Siebel CRM Contact

A Contact business component record in Oracle Siebel CRM representing an individual person associated with an account. Contacts store personal and professional information including name, job title, communication details, and organizational affiliations.

CRMCustomer ManagementEnterprise SoftwareMarketing AutomationOracleSales AutomationService Automation

Properties

Name	Type	Description
Id	string	Unique system-generated row identifier for the contact record
First Name	string	Contact first name
Last Name	string	Contact last name
Middle Name	string	Contact middle name
Salutation	string	Salutation or title prefix (e.g., Mr., Ms., Dr.)
Job Title	string	Job title or role within the organization
Department	string	Department within the organization
Email Address	string	Primary email address
Work Phone #	string	Work telephone number
Cellular Phone #	string	Mobile or cellular phone number
Home Phone #	string	Home telephone number
Fax Phone #	string	Fax number
Account	string	Name of the associated account
Account Id	string	Row identifier of the associated account
Employee Number	string	Employee number if the contact is an internal employee
Employer Name	string	Name of the employer organization
Primary Organization Id	string	Row identifier of the primary Siebel organization for visibility and access control
Status	string	Contact status
Contact Method	string	Preferred method of communication
Personal Address	object

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://docs.oracle.com/schemas/oracle-siebel/contact.json",
  "title": "Oracle Siebel CRM Contact",
  "description": "A Contact business component record in Oracle Siebel CRM representing an individual person associated with an account. Contacts store personal and professional information including name, job title, communication details, and organizational affiliations.",
  "type": "object",
  "required": ["First Name", "Last Name"],
  "properties": {
    "Id": {
      "type": "string",
      "description": "Unique system-generated row identifier for the contact record"
    },
    "First Name": {
      "type": "string",
      "description": "Contact first name",
      "minLength": 1,
      "maxLength": 50
    },
    "Last Name": {
      "type": "string",
      "description": "Contact last name",
      "minLength": 1,
      "maxLength": 50
    },
    "Middle Name": {
      "type": "string",
      "description": "Contact middle name"
    },
    "Salutation": {
      "type": "string",
      "description": "Salutation or title prefix (e.g., Mr., Ms., Dr.)"
    },
    "Job Title": {
      "type": "string",
      "description": "Job title or role within the organization"
    },
    "Department": {
      "type": "string",
      "description": "Department within the organization"
    },
    "Email Address": {
      "type": "string",
      "format": "email",
      "description": "Primary email address"
    },
    "Work Phone #": {
      "type": "string",
      "description": "Work telephone number"
    },
    "Cellular Phone #": {
      "type": "string",
      "description": "Mobile or cellular phone number"
    },
    "Home Phone #": {
      "type": "string",
      "description": "Home telephone number"
    },
    "Fax Phone #": {
      "type": "string",
      "description": "Fax number"
    },
    "Account": {
      "type": "string",
      "description": "Name of the associated account"
    },
    "Account Id": {
      "type": "string",
      "description": "Row identifier of the associated account"
    },
    "Employee Number": {
      "type": "string",
      "description": "Employee number if the contact is an internal employee"
    },
    "Employer Name": {
      "type": "string",
      "description": "Name of the employer organization"
    },
    "Primary Organization Id": {
      "type": "string",
      "description": "Row identifier of the primary Siebel organization for visibility and access control"
    },
    "Status": {
      "type": "string",
      "description": "Contact status",
      "enum": ["Active", "Inactive"]
    },
    "Contact Method": {
      "type": "string",
      "description": "Preferred method of communication"
    },
    "Personal Address": {
      "$ref": "#/$defs/Address"
    }
  },
  "$defs": {
    "Address": {
      "type": "object",
      "description": "Physical address associated with the contact",
      "properties": {
        "Street Address": {
          "type": "string",
          "description": "Street address line"
        },
        "Street Address 2": {
          "type": "string",
          "description": "Secondary address line"
        },
        "City": {
          "type": "string",
          "description": "City name"
        },
        "State": {
          "type": "string",
          "description": "State or province"
        },
        "Postal Code": {
          "type": "string",
          "description": "Postal or ZIP code"
        },
        "Country": {
          "type": "string",
          "description": "Country name"
        }
      }
    }
  }
}