Table CDR_FACT

Description

Introduced: 8.5.013.06
Modified: 8.5.015.19 (PRODUCER_BATCH_ID added); 8.5.015.07 (size of the CALL_ID column increased)

In partitioned databases, this table is partitioned.

Reserved for future use.

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
DN	varchar(255)		X
PARTYUUID	varchar(64)	X	X
CALLUUID	varchar(64)		X
CALL_ID	varchar(255)		X
ROOT_CALLUUID	varchar(64)
DNIS	varchar(255)
ANI	varchar(255)
START_DATE_TIME_KEY	integer	X	X	X
INITIATED_TS	integer		X
ESTABLISHED_TS	integer
RELEASED_TS	integer		X
CDR_DIM1_KEY	integer		X		-2
CREATE_AUDIT_KEY	numeric(19)		X	X
UPDATE_AUDIT_KEY	numeric(19)			X
PRODUCER_BATCH_ID	numeric(19)

DN

>> Back to Column List

PARTYUUID

>> Back to Column List

CALLUUID

>> Back to Column List

CALL_ID

Modified: 8.5.015.07 (size of the column increased)

>> Back to Column List

ROOT_CALLUUID

>> Back to Column List

DNIS

>> Back to Column List

ANI

>> Back to Column List

START_DATE_TIME_KEY

>> Back to Column List

INITIATED_TS

>> Back to Column List

ESTABLISHED_TS

>> Back to Column List

RELEASED_TS

>> Back to Column List

CDR_DIM1_KEY

>> Back to Column List

CREATE_AUDIT_KEY

>> Back to Column List

UPDATE_AUDIT_KEY

>> Back to Column List

PRODUCER_BATCH_ID

Introduced: Release 8.5.015.19
Reserved for internal use.

>> Back to Column List

Index List

CODE	U	C	Description
I_CDR_FACT_SDT			Reserved for future use.

Index I_CDR_FACT_SDT

Field	Sort	Comment
START_DATE_TIME_KEY	Ascending

Subject Areas

No subject area information available.