Table CDR_FACT

Description

Introduced: 8.5.013.06

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	Oracle: VARCHAR2(255 CHAR) MSSQL: varchar(255)/nvarchar(255) PostgreSQL: varchar(255)		X
PARTYUUID	Oracle: VARCHAR2(64 CHAR) MSSQL: varchar(64) PostgreSQL: varchar(64)	X	X
CALLUUID	Oracle: VARCHAR2(64 CHAR) MSSQL: varchar(64) PostgreSQL: varchar(64)		X
CALL_ID	Oracle: VARCHAR2(64 CHAR) MSSQL: varchar(64) PostgreSQL: varchar(64)		X
ROOT_CALLUUID	Oracle: VARCHAR2(64 CHAR) MSSQL: varchar(64) PostgreSQL: varchar(64)
DNIS	Oracle: VARCHAR2(255 CHAR) MSSQL: varchar(255)/nvarchar(255) PostgreSQL: varchar(255)
ANI	Oracle: VARCHAR2(255 CHAR) MSSQL: varchar(255)/nvarchar(255) PostgreSQL: varchar(255)
START_DATE_TIME_KEY	Oracle: NUMBER(10) MSSQL: int PostgreSQL: integer	X	X	X
INITIATED_TS	Oracle: NUMBER(10) MSSQL: int PostgreSQL: integer		X
ESTABLISHED_TS	Oracle: NUMBER(10) MSSQL: int PostgreSQL: integer
RELEASED_TS	Oracle: NUMBER(10) MSSQL: int PostgreSQL: integer		X
CDR_DIM1_KEY	Oracle: NUMBER(10) MSSQL: int PostgreSQL: integer		X		-2
CREATE_AUDIT_KEY	Oracle: NUMBER(19) MSSQL: numeric(19) PostgreSQL: numeric(19)		X	X
UPDATE_AUDIT_KEY	Oracle: NUMBER(19) MSSQL: numeric(19) PostgreSQL: numeric(19)			X

DN

>> Back to Column List

PARTYUUID

>> Back to Column List

CALLUUID

>> Back to Column List

CALL_ID

>> 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

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.

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
CDR_FACT	CREATE_AUDIT_KEY	CTL_AUDIT_LOG	AUDIT_KEY
CDR_FACT	START_DATE_TIME_KEY	DATE_TIME	DATE_TIME_KEY
CDR_FACT	UPDATE_AUDIT_KEY	CTL_AUDIT_LOG	AUDIT_KEY