Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
  • DV = Default value
  • In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in Cloud deployments is not multi-language.) THIS BULLET DISPLAYS ONLY IN THE MSSQL AND CLOUD PDMs.
(Updated DISPOSITION description)
(Removing highlights)
Line 5: Line 5:
 
{{PDMTable
 
{{PDMTable
 
|tableName = LDR_RECORD
 
|tableName = LDR_RECORD
−
|shortDesc = {{Editgrn_open}}Allows CX Contact record facts to be described based on contact information type, record type, record status, and disposition.{{Editgrn_close}}
+
|shortDesc = Allows CX Contact record facts to be described based on contact information type, record type, record status, and disposition.
−
|tableDesc = {{Editgrn_open}}This dimension table allows CX Contact record facts to be described based on characteristics of the outbound campaign records, such as contact information type, record type, record status, and disposition.{{Editgrn_close}}
+
|tableDesc = This dimension table allows CX Contact record facts to be described based on characteristics of the contact list records, such as contact information type, record type, record status, and disposition.
 
|subjectAreas =  
 
|subjectAreas =  
−
|introduced = {{Editgrn_open}}8.5.012{{Editgrn_close}}
+
|introduced = 8.5.012
 
|modified =  
 
|modified =  
 
|discontinued =  
 
|discontinued =  
Line 25: Line 25:
 
|foreignKey =  
 
|foreignKey =  
 
|default =
 
|default =
−
|colDesc = {{Editgrn_open}}The primary key of this table. This ID is referenced from other tables as LDR_RECORD_KEY.{{Editgrn_close}}
+
|colDesc = The primary key of this table. This ID is referenced from other tables as LDR_RECORD_KEY.
 
|introduced =  
 
|introduced =  
 
|modified =  
 
|modified =  
Line 55: Line 55:
 
|foreignKey =  
 
|foreignKey =  
 
|default = unknown
 
|default = unknown
−
|colDesc = {{Editgrn_open}}The type of the contact device. This field is set to one of the following values:{{Editgrn_close}}
+
|colDesc = The type of the contact device. This field is set to one of the following values:
 
{{ColumnFormat|cols=2|content=
 
{{ColumnFormat|cols=2|content=
 
* No Contact Type
 
* No Contact Type
Line 72: Line 72:
 
|modified =  
 
|modified =  
 
|discontinued =  
 
|discontinued =  
−
|xpath = {{Editgrn_open}}contact_info_type{{Editgrn_close}}
+
|xpath = contact_info_type
 
}}
 
}}
  
Line 84: Line 84:
 
|foreignKey =  
 
|foreignKey =  
 
|default = unknown
 
|default = unknown
−
|colDesc = {{Editgrn_open}}The type of the record from the contact list. This field is set to one of the following values:{{Editgrn_close}}
+
|colDesc = The type of the record from the contact list. This field is set to one of the following values:
 
{{ColumnFormat|cols=2|content=
 
{{ColumnFormat|cols=2|content=
 
* No Record Type
 
* No Record Type
Line 97: Line 97:
 
|modified =  
 
|modified =  
 
|discontinued =  
 
|discontinued =  
−
|xpath = {{Editgrn_open}}recordType{{Editgrn_close}}
+
|xpath = recordType
 
}}
 
}}
  
Line 109: Line 109:
 
|foreignKey =  
 
|foreignKey =  
 
|default = unknown
 
|default = unknown
−
|colDesc = {{Editgrn_open}}The status of the record from the contact list. This field is set to one of the following values:{{Editgrn_close}}
+
|colDesc = The status of the record from the contact list. This field is set to one of the following values:
 
{{ColumnFormat|cols=2|content=
 
{{ColumnFormat|cols=2|content=
 
* No Record Status
 
* No Record Status
Line 124: Line 124:
 
|modified =  
 
|modified =  
 
|discontinued =  
 
|discontinued =  
−
|xpath = {{Editgrn_open}}recordStatus {{Editgrn_close}}
+
|xpath = recordStatus
 
}}
 
}}
  
Line 136: Line 136:
 
|foreignKey =  
 
|foreignKey =  
 
|default = unknown
 
|default = unknown
−
|colDesc = {{Editgrn_open}}The reason for filtering out the record from the campaign during the pre-loading phase, as reported by CX Contact.{{Editgrn_close}}
+
|colDesc = The reason for filtering out the record from the campaign during the pre-loading phase, as reported by CX Contact.
 
|introduced =  
 
|introduced =  
 
|modified =  
 
|modified =  
 
|discontinued =  
 
|discontinued =  
−
|xpath = {{Editgrn_open}}disposition{{Editgrn_close}}
+
|xpath = disposition
 
}}
 
}}
  
Line 146: Line 146:
 
{{PDMIndexItem
 
{{PDMIndexItem
 
|indexName = I_LDR_RECORD
 
|indexName = I_LDR_RECORD
−
|indexDesc = {{Editgrn_open}}Ensures that the combinations of values that are stored in the dimension table are unique.{{Editgrn_close}}
+
|indexDesc = Ensures that the combinations of values that are stored in the dimension table are unique.
 
|indexPresentInPartitioned = yes
 
|indexPresentInPartitioned = yes
 
|indexKey1 = CONTACT_INFO_TYPE
 
|indexKey1 = CONTACT_INFO_TYPE

Revision as of 18:17, February 21, 2019

Table LDR_RECORD

Description

Introduced: 8.5.012

In partitioned databases, this table is not partitioned.


This dimension table allows CX Contact record facts to be described based on characteristics of the contact list records, such as contact information type, record type, record status, and disposition.

Tip
To assist you in preparing supplementary documentation, click the following link to download a comma-separated text file containing information such as the data types and descriptions for all columns in this table: Download a CSV file.

Hint: For easiest viewing, open the downloaded CSV file in Excel and adjust settings for column widths, text wrapping, and so on as desired. Depending on your browser and other system settings, you might need to save the file to your desktop first.

Column List

Legend

Column Data Type P M F DV
ID Oracle: NUMBER(10)
MSSQL: int
PostgreSQL: integer
 X X
CREATE_AUDIT_KEY Oracle: NUMBER(19)
MSSQL: numeric(19)
PostgreSQL: numeric(19)
 X X
CONTACT_INFO_TYPE Oracle: VARCHAR2(32 CHAR)
MSSQL: nvarchar(32)
PostgreSQL: varchar(32)
 X unknown
RECORD_TYPE Oracle: VARCHAR2(32 CHAR)
MSSQL: nvarchar(32)
PostgreSQL: varchar(32)
 X unknown
RECORD_STATUS Oracle: VARCHAR2(32 CHAR)
MSSQL: nvarchar(32)
PostgreSQL: varchar(32)
 X unknown
DISPOSITION Oracle: VARCHAR2(255 CHAR)
MSSQL: nvarchar(255)
PostgreSQL: varchar(255)
 X unknown

ID

The primary key of this table. This ID is referenced from other tables as LDR_RECORD_KEY.

>> Back to Column List

CREATE_AUDIT_KEY

The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify newly added data.

>> Back to Column List

CONTACT_INFO_TYPE

Based on application data attribute: contact_info_type

The type of the contact device. This field is set to one of the following values:

  • No Contact Type
  • Home Phone
  • Direct Business Phone
  • Business With Extension
  • Mobile
  • Vacation Phone
  • Pager
  • Modem
  • Voice Mail
  • Pin Pager
  • E-Mail Address
  • Instant Messaging
>> Back to Column List

RECORD_TYPE

Based on application data attribute: recordType

The type of the record from the contact list. This field is set to one of the following values:

  • No Record Type
  • Unknown Record Type
  • General
  • Campaign Rescheduled
  • Personal Rescheduled
  • Personal Callback
  • Campaign Callback
  • No Call
>> Back to Column List

RECORD_STATUS

Based on application data attribute: recordStatus

The status of the record from the contact list. This field is set to one of the following values:

  • No Record Status
  • Ready
  • Retrieved
  • Updated
  • Stale
  • Cancelled
  • Agent Error
  • Chain Updated
  • Missed Callback
  • Chain Ready
>> Back to Column List

DISPOSITION

Based on application data attribute: disposition

The reason for filtering out the record from the campaign during the pre-loading phase, as reported by CX Contact.

>> Back to Column List

Index List

CODE U C Description
I_LDR_RECORD X Ensures that the combinations of values that are stored in the dimension table are unique.

Index I_LDR_RECORD

Field Sort Comment
CONTACT_INFO_TYPE Ascending
RECORD_TYPE Ascending
RECORD_STATUS Ascending
DISPOSITION Ascending

Subject Areas

No subject area information available.


References

The summary List of References will include the following entries for this table or view:


Child Table/View Child Table/View Column Parent Table/View Parent Table/View Column
LDR_RECORD CREATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY

 

Comments or questions about this documentation? Contact us for support!