GUID

VARCHAR2(36)

RAWTOHEX(sys_ guid())

No

Primary Key.

SRC_IP

VARCHAR2(16)

NULL

Yes

The IP address of the client that initiated the activity.

OP_TYPE

CHAR(1)

No

The type of operation that was carried out. One of
"A" - Object was added,

"D" - the object was deleted,

"U" - the object was updated,

"L" - the object was linked to another object,

"X" - the object was unlinked from another object.

DESCR

NVARCHAR2(1333)

NULL

Yes

An optional description of the change or activity that occurred.

OBJ_ID

NUMBER(9)

NULL

Yes

The ID of the object that was affected, for records that use numeric primary keys.

OBJ_GUID

VARCHAR2(36)

NULL

Yes

The GUID of the object that was affected, for records that used GUIDs as primary keys.

OBJ_TYPE

VARCHAR2(32)

NULL

Yes

A string indicating the type of object, as maintained by the SPRT_EC_AUDIT_OBJ table, and therefore which table OBJ_ID or OBJ_GUID refers.

OBJ_ DESCR

NVARCHAR2(100)

NULL

Yes

A displayable description of the object affected.

REFOBJ_ ID

NUMBER(9)

NULL

Yes

For OP_TYPE of "L" or "X", the ID of the other object in the link being made or broken, for records that use numeric primary keys.

REFOBJ_ GUID

VARCHAR2(36)

NULL

Yes

For OP_TYPE of "L" or "X", the GUID of the other object in the link being made or broken, for records that use GUIDs as primary keys.

REFOBJ_ TYPE

VARCHAR2(32)

NULL

Yes

A string indicating the type of object, as maintained by the SPRT_EC_AUDIT_OBJ table, and therefore which table REFOBJ_ID or REFOBJ_GUID refers.

REFOBJ_ DESCR

NVARCHAR2(100)

NULL

Yes

A displayable description of the object affected.

CREATED

DATE

SYSDATE

No

The date upon creation.

CREATED_ BY

NVARCHAR2(32)

No

Username of user that created the record.