CREATE TABLE gtg_aar_incidents (
    INCIDENT_ID                      NUMBER(18, 0) ,
    IS_INTRA_ROLE                    VARCHAR2(4)   ,
    AAR_ROLE_REQUEST_ID              NUMBER(18, 0)     NOT NULL,
    GLOBAL_USER_ID                   NUMBER(18, 0)     NOT NULL,
    USER_GUID                        VARCHAR2(256)     NOT NULL,
    USER_NAME                        VARCHAR2(1024),
    ROLE                             VARCHAR2(4000),
    ACCESS_POINT_NAME                VARCHAR2(1024),
    ACCESS_PATH_ID                   VARCHAR2(1024),
    ACCESS_PATH_IDS                  VARCHAR2(4000),
    PATH_EXPRESSION                  VARCHAR2(4000),
    ACCESS_PATH_GROUPING             VARCHAR2(4000),
    CONFLICTING_ACCESS_POINT_ID      VARCHAR2(1024),
    CONFLICTING_ACCESS_POINT_NAME    VARCHAR2(1024),
    CONFLICTING_ACCESS_POINT_TYPE    VARCHAR2(1024),
    ROLE_GROUPING                    VARCHAR2(4000),
    ORIG_KEYPATH                     VARCHAR2(4000),
    HASHCODE                         VARCHAR2(4000),
    CONTROL_ID                       NUMBER(18, 0)     NOT NULL,
    CONTROL_NAME                     VARCHAR2(4000),
    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) ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)      NOT NULL,
    INCIDENT_ID                      NUMBER(18, 0) ,
    IS_INTRA_ROLE                    VARCHAR2(4)   ,
    AAR_ROLE_REQUEST_ID              NUMBER(18, 0)     NOT NULL,
    GLOBAL_USER_ID                   NUMBER(18, 0)     NOT NULL,
    USER_GUID                        VARCHAR2(256)     NOT NULL,
    USER_NAME                        VARCHAR2(1024),
    ROLE                             VARCHAR2(4000),
    ACCESS_POINT_NAME                VARCHAR2(1024),
    ACCESS_PATH_ID                   VARCHAR2(1024),
    ACCESS_PATH_IDS                  VARCHAR2(4000),
    PATH_EXPRESSION                  VARCHAR2(4000),
    ACCESS_PATH_GROUPING             VARCHAR2(4000),
    CONFLICTING_ACCESS_POINT_ID      VARCHAR2(1024),
    CONFLICTING_ACCESS_POINT_NAME    VARCHAR2(1024),
    CONFLICTING_ACCESS_POINT_TYPE    VARCHAR2(1024),
    ROLE_GROUPING                    VARCHAR2(4000),
    ORIG_KEYPATH                     VARCHAR2(4000),
    HASHCODE                         VARCHAR2(4000),
    CONTROL_ID                       NUMBER(18, 0)     NOT NULL,
    CONTROL_NAME                     VARCHAR2(4000),
    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) ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)      NOT NULL,
    CONSTRAINT pk_gtg_aar_incidents PRIMARY KEY (INCIDENT_ID, INCIDENT_ID)
);
