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	VARCHAR2(255 CHAR)		X
PARTYUUID	VARCHAR2(64 CHAR)	X	X
CALLUUID	VARCHAR2(64 CHAR)		X
CALL_ID	VARCHAR2(255 CHAR)		X
ROOT_CALLUUID	VARCHAR2(64 CHAR)
DNIS	VARCHAR2(255 CHAR)
ANI	VARCHAR2(255 CHAR)
START_DATE_TIME_KEY	NUMBER(10)	X	X	X
INITIATED_TS	NUMBER(10)		X
ESTABLISHED_TS	NUMBER(10)
RELEASED_TS	NUMBER(10)		X
CDR_DIM1_KEY	NUMBER(10)		X		-2
CREATE_AUDIT_KEY	NUMBER(19)		X	X
UPDATE_AUDIT_KEY	NUMBER(19)			X
PRODUCER_BATCH_ID	NUMBER(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.