por_translog

This table is transaction table used to record user activity in the portal. Events that can be tracked are mostly Portal Library based such as: Publishing, Deleting, Viewing, etc. Portal events are managed in the Portal Administration area and are turned off by default .

Column Name Column Datatype Column Null Option Column Comment
createdatetime integer not null The seconds since the epoch when this action occurred.
action integer with null Integer value of a specific action to log such as: 1 - create channel 2 - document published 4 - document moved 8 - messenger created 16 - content served 32 - content deleted 64 - messenger deleted 128 - channel deleted
errata nvarchar(255) with null Details about the transaction. (e.g. May be a file name for logging a library document that was rendered on a workplace.)
userkey integer with null Objectkey of the user who performed this transaction.
objectkey integer with null Represents the UID of the Portal Object this action occured on.
objectdesc nvarchar(255) with null The description of an object as entered by the user.

Product Name: Portal

Table Type: Table


Copyright © 2006 CA. All rights reserved.