Case

Contains the details and related information across case life cycle.

QName: {http://xmlns.oracle.com/apps/crm/service/caseMgmt/caseMgmtService/}Case

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type	Object or Service
Contains	Case Household
Contains	Case Message
Contains	Case Contact
Contains	Case Opportunity
Contains	Case Resource
Handled by	Case Service

Attributes

The following table describes attributes in the service data object.

Name	Type	Description
AssigneePartyName	string	Indicates the party name of the case assignee.
AssigneeResourceId	long	The ID of the resource (for example, a support engineer) assigned to the case.
BUOrgId	long	The unique ID of the business unit name associated to the case.
BusinessUnitName	string	Indicates the Business Unit Name of the case.
CaseCategoryId	long	Indicates the category of case.
CaseCreatedBy	string	Migration Who Column: set to the user who created the row.
CaseCreationDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	Migration Who Column: set to the case creation date.
CaseId	long	Indicates the case identifier. Primary Key
CaseLastUpdateDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	Migration Who Column: set to the date and time of the last update of the case.
CaseLastUpdateLogin	string	Migration Who Column: set to the session login associated to the user who last updated the case.
CaseLastUpdatedBy	string	Migration Who Column: set to the user who last updated the case.
CaseNumber	string	Indicates the reference number of the case.
CaseTypeCd	string	Lookup code that indicates the type of case.
CaseTypeCdMeaning	string	Indicates the display value corresponding to the case type lookup code for the case.
CategoryName	string	Indicates the name of the category associated to the case.
ClosedDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	Indicates the closed date for case.
CorpCurrencyCode	string	Indicates the corporate currency code.
CreatedBy	string	Indicates the user who created the case.
CreatedByPartyId	long	The user who created the case in the system.
CreatedByPartyName	string	The name of the user who created the case in the system.
CreationDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	Indicates the date and time of the creation of the case.
CurcyConvRateType	string	The corporate currency conversion rate type.
CurrencyCode	string	The currency code.
DeleteFlag	boolean	Indicates if the record can be deleted by the current user.
Description	string	Indicates description/statement of the case.
LastClosedDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	Indicates last closed date for case, if the case was closed and then reopened.
LastReopenDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	Indicates last reopen date for case, if the case was reopened.
LastUpdateDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	Indicates the date and time when the case was last updated.
LastUpdateLogin	string	Indicates the login session of the user who last updated the case.
LastUpdatedBy	string	Indicates the user who last updated the case.
LastUpdatedByPartyId	long	Indicates the party id of the user who last updated the case.
LastUpdatedByPartyName	string	The name of the user who last updated the case.
OpenDate	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	Indicates the opened date for case, in case the case is approved.
PrimaryContactPartyId	long	Indicates the primary contact for the case.
PrimaryContactPartyName	string	Indicates the name of the case primary contact.
PrimaryHouseholdPartyId	long	Indicates the primary household for the case.
PrimaryHouseholdPartyName	string	Indicates the name of the case primary household.
PriorityCd	string	Indicates the priority of the case.
PriorityCdMeaning	string	Indicates the display value corresponding to the priority lookup code for the case.
QueueId	long	Indicates the queue ID the case is assigned to.
QueueName	string	The name of the queue associated to the case.
ReportedByPartyId	long	Indicates the person who reported the case.
ReportedByPartyName	string	Indicates Reported By Party Name.
SensitivityCd	string	Indicates the sensitivity of the case.
SensitivityCdMeaning	string	Indicates the display value corresponding to the sensitivity lookup code for the case.
SourceCd	string	Indicates how the case was entered into the system.
SourceCdMeaning	string	Indicates the display value corresponding to the source lookup code for the case.
StatusCd	string	Indicates the status of the case.
StatusCdMeaning	string	Indicates the display value corresponding to the status lookup code for the case.
StatusTypeCd	string	Indicates the status type of the case.
StatusTypeCdMeaning	string	Indicates the display value corresponding to the status type lookup code for the case.
StripeCd	string	Indicates the stripe code for the case.
Title	string	Indicates the title of the case.
UpdateFlag	boolean	Indicates if the record can be updated by the current user.
caseContacts	Case Contact	Contains many-to-many relationships of case and associated contacts.
caseHouseholds	Case Household	Contains many-to-many relationships of case and associated households.
caseMessages	Case Message	Contains information about every communication update to the case.
caseOpportunities	Case Opportunity	Contains many-to-many relationships of case and associated case opportunities.
caseResources	Case Resource	Contains many-to-many relationships of case and associated resources.