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 |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Handled by |
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.
|
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 |
Contains many-to-many relationships of case and associated contacts. |
|
caseHouseholds |
Contains many-to-many relationships of case and associated households. |
|
caseMessages |
Contains information about every communication update to the case. |
|
caseOpportunities |
Contains many-to-many relationships of case and associated case opportunities. |
|
caseResources |
Contains many-to-many relationships of case and associated resources. |