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 |
|---|---|---|
|
AllegationCd |
string |
Indicates the allegation code of a case. |
|
AllegationCdMeaning |
string |
Indicates the display value corresponding to the allegation code for a case. |
|
ArbitrationRequiredFlag |
boolean |
Indicates whether or not arbitration is required. |
|
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. |
|
ComplaintTypeCd |
string |
Indicates the complaint type code of a case. |
|
ComplaintTypeCdMeaning |
string |
Indicates the display value corresponding to the complaint type code for a case. |
|
ContributingFactorsCd |
string |
Indicates the contributing factors codes of a case. |
|
ContributingFactorsCdMeanings |
string |
Indicates the display values corresponding to the contributing factors codes for a 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. |
|
FiledByTypeCd |
string |
Indicates the filed by type code of a case. |
|
FiledByTypeCdMeaning |
string |
Indicates the display value corresponding to the filed by type code for a case. |
|
IncidentOccurrenceDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Indicates the date and time when the incident occurred. |
|
IncidentTypeCd |
string |
Indicates the incident type code of a case. |
|
IncidentTypeCdMeaning |
string |
Indicates the display value corresponding to the incident type code for a case. |
|
IsolatedIncidentFlag |
boolean |
Indicates whether or not the incident is isolated. |
|
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. |
|
LastResolvedDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Indicates the date and time when the case was last resolved. |
|
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. |
|
MeasuresTakenCd |
string |
Indicates the measures taken code of a case. |
|
MeasuresTakenCdMeanings |
string |
Indicates the display values corresponding to the measures taken codes for a case. |
|
OpenDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Indicates the opened date for case, in case the case is approved. |
|
PolicyViolatedFlag |
boolean |
Indicates whether or not policy is violated. |
|
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. |
|
ResolutionCd |
string |
Indicates the resolution code of a case. |
|
ResolutionCdMeaning |
string |
Indicates the display value corresponding to the resolution lookup code for a case. |
|
ResolveDescription |
string |
Indicates the description of how a case has been resolved. |
|
ResolveOutcomeCd |
string |
Indicates the resolution outcome code of a case. |
|
ResolveOutcomeCdMeaning |
string |
Indicates the display value corresponding to the resolution outcome lookup code for a case. |
|
ResolvedBy |
string |
Indicates the user who resolved a case. |
|
ResolvedByPartyId |
long |
Indicates the unique identification of the user who resolved the case. |
|
ReviewedByCd |
string |
Indicates the reviewed by code of a case. |
|
ReviewedByCdMeanings |
string |
Indicates the display value corresponding to the reviewed by code for a case. |
|
SensitivityCd |
string |
Indicates the sensitivity of the case. |
|
SensitivityCdMeaning |
string |
Indicates the display value corresponding to the sensitivity lookup code for the case. |
|
SettlementAmount |
decimal |
Indicates the amount required in settlement of a case. |
|
SettlementRequiredFlag |
boolean |
Indicates whether or not settlement is required. |
|
SettlementSummary |
string |
Indicates the description of how a case was settled. |
|
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. |
|
SpecialistRequiredFlag |
boolean |
Indicates whether or not a specialist is required. |
|
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. |