Table COMMUNICATION_CONTENT

DescriptionThe content of a . The materialisation of the communication content, in any format, electronic or physical, is expressed as a .

e.g. A claim form filled in by Jacques Tincan.

Columns
COMMUNICATION_CONTENT_IDCOMMUNICATION_CONTENT_ID
ANCHOR_IDANCHOR_ID
CREATION_DATECREATION_DATE
DESCRIPTIONDESCRIPTION
DESTINATIONDESTINATION
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
NAMENAME
RECEIVER_CONTACT_NAMERECEIVER_CONTACT_NAME
RECEIVER_FIRST_NAMERECEIVER_FIRST_NAME
RECEIVER_LAST_NAMERECEIVER_LAST_NAME
SOURCESOURCE
TYPETYPE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE

Primary Key
COMMUNICATION_CONTENT_PKCOMMUNICATION_CONTENT_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 COMMUNICATION_CONTENT_ID
DescriptionThe unique identifier of the Communication content
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ANCHOR_ID
DescriptionAny value without business meaning that uniquely distinguishes occurrences of this entity independently of its history.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CREATION_DATE
DescriptionThe date on which this communication content was created. It includes the time of creation.
For a specified content it is the date and time the content is generated.
For an unspecified content it is the date and time the content is written and recorded.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionA free-text statement used to explain the meaning of this communication content. The description may include the purpose and usage of the communication content as well as other aspects.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESTINATION
DescriptionThe destination of a communication.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionThe effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionThe effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NAME
DescriptionA text reference that aids the identification and understanding of this communication content.

e.g. complaint
e.g. direct debit authorisation.
e.g. Policy document
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RECEIVER_CONTACT_NAME
DescriptionName of the contact person at the organisation receiving the communication.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RECEIVER_FIRST_NAME
DescriptionFirst name of the receiver of the communication.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RECEIVER_LAST_NAME
DescriptionLast name of the receiver of the communication.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOURCE
DescriptionThe source of the communication.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TYPE
DescriptionThe mutually exclusive categorisation of this Communication content.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionThe transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionThe transaction time that represents the end of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 COMMUNICATION_CONTENT_PK
DescriptionThe unique identifier of the Communication content
MemberCOMMUNICATION_CONTENT_ID [BIGINT]

Dependency Details

 AWM - Transformation