Case Episode DMO

Object API Name: ssot__CaseEpisode__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

• SubjectId has a FOREIGNKEY relationship with the Account Contact DMO Id field.
• EpisodeReason has a FOREIGNKEY relationship with the Case Proceeding Result DMO Id field.
• EpisodeAccountId has a FOREIGNKEY relationship with the Account DMO Id field.
• Case has a FOREIGNKEY relationship with the Case DMO Id field.
• Address has a FOREIGNKEY relationship with the Address DMO Id field.
• SubjectId has a FOREIGNKEY relationship with the Account DMO Id field.
• RelatedEpisodeId has a FOREIGNKEY relationship with the Case Episode DMO Id field.

• Address
• Case
• CaseEpisodeStatus
• CaseEpisodeSubType
• CaseEpisodeType
• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• Description
• EndDateTime
• EpisodeAccountId
• EpisodeReason
• Id
• InternalOrganizationId
• KQ_Address
• KQ_Case
• KQ_EpisodeAccountId
• KQ_EpisodeReason
• KQ_Id
• KQ_RelatedEpisodeId
• KQ_SubjectId
• RelatedEpisodeId
• StartDateTime
• StatusChangeReason
• SubjectId

• Field API Name: ssot__Address__c
• Data Type: TEXT
• Description: The address where the subject is being removed from or placed at.

• Field API Name: ssot__Case__c
• Data Type: TEXT
• Description: The case associated with the case episode.

• Field API Name: ssot__CaseEpisodeStatus__c
• Data Type: TEXT
• Description: Specfies the status of the case episode. For example, Open, In Progress, Closed.

• Field API Name: ssot__CaseEpisodeSubType__c
• Data Type: TEXT
• Description: The subtypes of the case episode. For example, Home Parents, Specified Relative, Forster Care Organization, Foster Care Family, Prison.

• Field API Name: ssot__CaseEpisodeType__c
• Data Type: TEXT
• Description: The types of case episode. For example, Detention, Probation, Removal, Eviction, Suspension, Revocation, Placement.

• Field API Name: ssot__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: ssot__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__Description__c
• Data Type: TEXT
• Description: The description of the case episode.

• Field API Name: ssot__EndDateTime__c
• Data Type: DATETIME
• Description: End date of the case episode.

• Field API Name: ssot__EpisodeAccountId__c
• Data Type: TEXT
• Description: Specifies business or person account who are involved in the removal or placement of the subject.

• Field API Name: ssot__EpisodeReason__c
• Data Type: TEXT
• Description: The situation that led to the case episode.

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this CaseEpisode record. Maximum size is 15 characters.

• Field API Name: ssot__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: KQ_Address__c
• Data Type: TEXT
• Description: Key Qualifier system field for Address

• Field API Name: KQ_Case__c
• Data Type: TEXT
• Description: Key Qualifier system field for Case

• Field API Name: KQ_EpisodeAccountId__c
• Data Type: TEXT
• Description: Key Qualifier system field for EpisodeAccountId

• Field API Name: KQ_EpisodeReason__c
• Data Type: TEXT
• Description: Key Qualifier system field for EpisodeReason

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_RelatedEpisodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for RelatedEpisodeId

• Field API Name: KQ_SubjectId__c
• Data Type: TEXT
• Description: Key Qualifier system field for SubjectId

• Field API Name: ssot__RelatedEpisodeId__c
• Data Type: TEXT
• Description: The relationship between all related case episodes.

• Field API Name: ssot__StartDateTime__c
• Data Type: DATETIME
• Description: Start date of the case episode.

• Field API Name: ssot__StatusChangeReason__c
• Data Type: TEXT
• Description: The reason for changing the status of the case episode.

• Field API Name: ssot__SubjectId__c
• Data Type: TEXT
• Description: The subject involved in the case episode.