Table V_AUDIT_14

AUDIT_DATE_TIME

datetime

Audit date time of the audit action

BASE_CREATED

datetime

Time the base document was created (if this audit event is of an instance object, otherwise it’s the same as the audit date time)

BASE_CUID

varchar

Base type of document (if this is an instance audit action).

BASE_KIND

varchar

Base parent CUID (if this is an instance audit action)

BASE_PARENTCUID

varchar

Base report name (if this is an instance audit action)

BASE_REPORT

nvarchar

Duration of the create action

CMSID

varchar

The actualy name of the CMS host machine without the port number, if used. В This is used in conjunction with OBJECTID or CUID to uniquely identify an object across environments

CREATE_MS

bigint

Count of create actions

CREATES

int

Day of the month

DAY_OF_MONTH

int

Day of the week

DAY_OF_WEEK

nvarchar

Days ago of the audit action from today

DAYS_AGO

int

Duration of the deleted action

DELETE_MS

bigint

Count of delete actions

DELETES

int

Count of delete actions

DELIVER_MS

bigint

Duration of delivery В actions

DELIVERIES

int

Count of delivery actions

EDIT_MS

bigint

Duration of edit action

EDITS

int

Count of edit actions

EVENT_ID

varchar

Unique EVENT ID of the Audit Event action

EVENT_TRIGGERS

int

NOT USED

EVENT_TYPE_NAME

nvarchar

Event Description

FOLDER_CUID

varchar

CUID of the folder of the audited object

HOUR_OF_DAY

int

Hour of the day the audit event occurred

ISINSTANCE

int

Indicates whether this object is an instance В (scheduled object) or not; Instances are usually only stored in the DOCUMENTS or V_DOCUMENTS table/view. Instances are NOT captured in base tables such as CRYSTAL_DOCUMENTS, WEBIxx_DOCUMENTS, DESKI_DOCUMENTS

LAST_USER_NAME

varchar

Last name of the audit user

MODIFIES

int

Count of modification actions

MODIFY_MS

bigint

Duration of modification actions

MONTH_DATE

datetime

The Month Date the action took place

MONTH_NUMBER

int

The month number the action took place

OBJECT_CUID

varchar

CUID of the audited object

OBJECT_NAME

nvarchar

NAME of the audited object

OBJECT_TYPE

varchar

TYPE of the audited object

PAGE_RETRIEVED_MS

bigint

Duration of page retrieved action

PAGE_RETRIEVES

int

Count of page retrieves

PARENT_CUID

varchar

Parent CUID of the audited object (NOTE: This could be a "Save as" parent template and not the TRUE Parent CUID; for the true Parent CUID lookup the CUID in the DOCUMENTS table)

PROMPT_MS

bigint

Duration of the prompt action

PROMPTS

int

Count of prompt actions

QUARTER

int

Quarter number of the audited event

QUARTER_YEAR

varchar

Quarter-Year of the audited event

REFRESH_MS

bigint

Duration of refresh action

REFRESHES

int

Count of refresh actions

RETRIEVE_MS

bigint

Duration of retrieve action

RETRIEVES

int

Count of retrieve actions

RUN_MS

bigint

Duration of run action

RUNS

int

Count of run actions

SAVE_MS

bigint

Duration of save action

SAVES

int

Count of save actions

SEARCH_MS

bigint

Duration of search action

SEARCHES

int

Count of search actions

SERVER_CUID

varchar

CUID of the server from where this event took place

SESSION_ID

varchar

ID of the session that was tied to this event (user or system)

STATUS_NAME

nvarchar

The status name of the audit action

USER_CUID

varchar

CUID of the user responsible for the audit action

USER_NAME

varchar

NAME of the user responsible for the audit action

VIEW_MS

bigint

Duration of view actions

VIEWINGS

int

Count of view actions

YEAR

int

Numeric Year of the action