CREATE TABLE fnd_ca_engagement_fact (
    SEQ_ID                   NUMBER(18, 0) ,
    TIMELINE_ID              VARCHAR2(1024)    NOT NULL,
    PAGE_GROUPING_ID         VARCHAR2(1024)    NOT NULL,
    ENV_ID                   VARCHAR2(1024)    NOT NULL,
    PAGE_VIEWS               NUMBER(30, 0) ,
    DISTINCT_ENVIRONMENTS    NUMBER(30, 0) ,
    DISTINCT_USERS           NUMBER(30, 0) ,
    DISTINCT_SESSIONS        NUMBER(30, 0) ,
    TIMESPENT_P25            NUMBER(38, 2) ,
    TIMESPENT_P50            NUMBER(38, 2) ,
    TIMESPENT_P75            NUMBER(38, 2) ,
    TIMESPENT_P90            NUMBER(38, 2) ,
    TIMESPENT_P95            NUMBER(38, 2) ,
    TOTAL_TIME_SPENT         NUMBER(38, 2) ,
    CREATED_BY               VARCHAR2(256)     NOT NULL,
    CREATION_DATE            TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128) ,
    SEQ_ID                   NUMBER(18, 0) ,
    TIMELINE_ID              VARCHAR2(1024)    NOT NULL,
    PAGE_GROUPING_ID         VARCHAR2(1024)    NOT NULL,
    ENV_ID                   VARCHAR2(1024)    NOT NULL,
    PAGE_VIEWS               NUMBER(30, 0) ,
    DISTINCT_ENVIRONMENTS    NUMBER(30, 0) ,
    DISTINCT_USERS           NUMBER(30, 0) ,
    DISTINCT_SESSIONS        NUMBER(30, 0) ,
    TIMESPENT_P25            NUMBER(38, 2) ,
    TIMESPENT_P50            NUMBER(38, 2) ,
    TIMESPENT_P75            NUMBER(38, 2) ,
    TIMESPENT_P90            NUMBER(38, 2) ,
    TIMESPENT_P95            NUMBER(38, 2) ,
    TOTAL_TIME_SPENT         NUMBER(38, 2) ,
    CREATED_BY               VARCHAR2(256)     NOT NULL,
    CREATION_DATE            TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128) ,
    CONSTRAINT pk_fnd_ca_engagement_fact PRIMARY KEY (SEQ_ID, SEQ_ID)
);
