Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE
AldoH Regular Contributor.
Regular Contributor.
522 views

Where I can get a Event Type list. (Records Manager 8.3 - TSEVENTDAT)

Jump to solution

Hello,

Do any of you know where I can get the list of event codes and their meaning. I need to generate reports with the events generated by each user.

In the TSEVENTDAT table there is a field called edEventType, but I do not know how to interpret each of the codes.

Can someone help me?

Thank you,

0 Likes
1 Solution

Accepted Solutions
Highlighted
Harry-Koppanyi Outstanding Contributor.
Outstanding Contributor.

Re: Where I can get a Event Type list. (Records Manager 8.3 - TSEVENTDAT)

Jump to solution

Hi, If I remember correctly you may find them within the Help File, however I wrote a similar report (also used these events catches within our TRIMBocX Platform - SharePoint to RM bidirectional Integration solution). Below you can find the full list for RM83.

TSEVENTS -
 
 BASIC SUMMARY EVENTNAME = EVENT VALUE

 Assignee Changed   CurrentChanged = 0,
 Home Changed HomeChanged = 1,
        Owner Changed  OwnerChanged = 2,
        Contact Added ContactAdded = 3,
        Contact Removed ContactRemoved = 4,
        Document Viewed  ErecViewLocationType = 5,
        Document Checked Out  ErecBookoutLocationType = 6,
        Document Extracted  ErecExtractLocationType = 7,
        Document Checked In (Replace)   ErecReplaceLocationType = 8,
        Document Checked In (New Revision)  ErecNewVersionLocationType = 9,
        Document Checked In (Undo Checkout) ErecReturnOnlyLocationType = 10,
        Document Removed ErecRemoveLocationType = 11,
        Document Attached  ErecAttachLocationType = 12,
        Document Published  ErecPublishLocationType = 13,
        Disposition Changed  DispositionChanged = 14,
        Signature Created  SignatureCreated = 15,
        Signature Attached SignatureAttached = 16,
        Signature Verified SignatureVerified = 17,
        Signature Failed Verification  SignatureFailVerify = 18,
        Security Profile Changed SecurityChanged = 19,
        Retention Schedule Reviewed ScheduleReviewed = 20,
        Classified As Vital    MadeVital = 21,
        Declassified From Vital   MadeNotVital = 22,
        Added to Hold   HoldAdded = 23,
        Removed from Hold HoldRemoved = 24,
        Container Changed  ContainerChanged = 25,
        Title Changed  TitleChanged = 26,
        Notes Changed  NotesChanged = 27,
        Date Created Changed CreateDateChanged = 28,
        Schedule Changed ScheduleChanged = 29,
        Record Number Changed NumberChanged = 30,
        Access Control Changed   AccessControlChanged = 31,
        Document Printed   ErecPrintLocationType = 32,
        Document Exported(XML)  ErecExportXMLLocationType = 33,
        Document Rendition Extracted ErecRenditionExtracted = 34,
        Document Rendition Viewed   ErecRenditionViewed = 35,
        Document Rendition Printed ErecRenditionPrinted = 36,
        Document Revision Extracted   ErecRevisionExtracted = 37,
        Document Revision Viewed   ErecRevisionViewed = 38,
        Document Revision Printed  ErecRevisionPrinted = 39,
        Document Link Extracted   ErecLinkExtracted = 40,
        Document Link Viewed  ErecLinkViewed = 41,
        Document Link Printed  ErecLinkPrinted = 42,
        Document attached to email  ErecMailed = 43,
        External Event  ExternalEvent = 44,
        Classification Changed   ClassificationChanged = 45,
        Date Closed Changed CloseDateChanged = 46,
        Document Annotated  ErecAnnotated = 47,
        Document Annotation Cancelled  ErecNotAnnotated = 48,
        Document Redacted   ErecRedacted = 49,
        Document Revision Removed
        ErecRevisionRemoved = 50,
        Additional Field Changed  UdfChanged = 51,
        Document Rendition Added   ErecRenditionAdded = 52,
        Related Record Created  CreateRecordRelationship = 53,
        Related Record Removed  RemoveRecordRelationship = 54,
        Date Registered Changed RegDateChanged = 55,
        Date Due Changed  DueDateChanged = 56,
        Date Published Changed  DatePublishedChanged = 57,
        Date Inactive Changed  DateInactiveChanged = 58,
        Last Action Date Changed   DateLastActionChanged = 59,
        Manual Disposal Date Changed   DateDestructionChanged = 60,
        Retention Review Date Changed   DateRetentionChanged = 61,
        Finalized   Finalized = 62,
        Unfinalized  Unfinalized = 63,
        Content Added   ContentAdded = 64,
        Content Removed  ContentRemoved = 65,
        Security Declassification Schedule Changed  CsDeclassifyChanged = 66,
        Security Downgrade Schedule Changed   CsDowngradeChanged = 67,
        Action Completed  ActionCompleted = 68,
        Action Assigned  ActionAssigned = 69,
        Action Reassigned  ActionReassigned = 70,
        Action Undone  ActionUndone = 71,
        Action Made Current    ActionCurrent = 72,
        Record Created  RecordCreated = 73,
        Record Modified    RecordModified = 74,
        Record Deleted     RecordRemoved = 75,
        Document link attached to email   ErecMailedLink = 76,
        Document Rendition Removed    ErecRenditionRemoved = 77,
        Assignee Initialized     CurrentAssigned = 78,
        Home Initialized  HomeAssigned = 79,
        Owner Initialized   OwnerAssigned = 80,
        Access Exclusions Changed   AccessExclusionsChanged = 81,
        Record Copied    RecordCopied = 82,
        SharePoint Document Viewed  SpiViewed = 83,
        SharePoint Document Edited   SpiEdited = 84,
        SharePoint Item Managed  SpiManaged = 85,
        SharePoint Item Relocated   SpiRelocated = 86,
        Record Exposed to SharePoint    SpiExposed = 87,
        Document Ready For Drafting   DocumentReadyForDrafting = 88,
        Document Ready For Review   DocumentReadyForReview = 89,
        Document Ready For Authorization   DocumentReadyForAuthorization = 90,
        Document Review Comments Updated DocumentReviewCommentsUpdated = 91,
        Document Review Complete   DocumentReviewComplete = 92,
        Document Authorization Complete  DocumentAuthorizationComplete = 93,
        Signed Copy Rendition Promoted   SignedRenditionPromoted = 94,
        DocuSign Authorization Failed   DocusignFailed = 95

 

Object Types for the Events
BaseObjectTypes
    {
        Unknown = 0,
        RecordLocation = 1,
        RecordRendition = 2,
        RecordKeyword = 3,
        RecordRelationship = 5,
        Record = 6,
        LocationAddress = 7,
        LocationEAddress = 8,
        Location = 9,
        RecordType = 10,
        StopWord = 11,
        Word = 12,
        ZipCode = 13,
        SecurityLevel = 15,
        SecurityCaveat = 16,
        LookupSet = 18,
        Space = 19,
        Classification = 21,
        ScheduleTrigger = 22,
        Schedule = 23,
        ElectronicStore = 24,
        ActionDef = 26,
        ActionDefStep = 27,
        RecordAction = 29,
        Keyword = 30,
        Request = 33,
        HtmlLayout = 37,
        SavedSearch = 38,
        History = 40,
        FieldDefinition = 42,
        RecordHold = 43,
        Hold = 44,
        Census = 45,
        Report = 46,
        RecordRevision = 48,
        RecordLinkedDocument = 49,
        Database = 50,
        ReportBitmap = 53,
        DocumentQueue = 54,
        SecurityGuide = 56,
        ScheduledTask = 58,
        ScheduledTaskHistory = 61,
        Meeting = 63,
        MeetingInvitation = 64,
        MeetingDocument = 65,
        AutoPartRule = 67,
        Alert = 68,
        UserLabel = 69,
        MailTemplate = 72,
        Communication = 73,
        CommunicationDetail = 74,
        OfflineRecord = 75,
        MeetingType = 76,
        MeetingTypeUsualParticipant = 77,
        AgendaItem = 78,
        AgendaItemAttachment = 79,
        MinuteItem = 80,
        MinuteItemActionArising = 81,
        TodoItem = 82,
        TodoItemItemReference = 83,
        AgendaItemType = 84,
        Workflow = 85,
        WorkflowDocument = 86,
        WorkflowTemplate = 87,
        WorkflowTemplateDocument = 88,
        Activity = 89,
        ActivityDocument = 90,
        ActivityResult = 91,
        ActivityStartCondition = 92,
        ActivityEscalation = 93,
        ActivityAuthorization = 94,
        MinuteItemType = 95,
        AgendaItemTypeAttachment = 96,
        Origin = 97,
        Jurisdiction = 98,
        JurisdictionMember = 100,
        RecordJurisdiction = 101,
        OriginHistory = 102,
        Notification = 105,
        SearchForm = 106,
        AlertSubscriber = 108,
        SharePointItem = 110,
        RecordClientMatterRole = 111,
        RecordClientMatterParty = 112,
        Consignment = 113,
        ConsignmentApprover = 114,
        ConsignmentIssue = 115,
        RecordTypeAutoSubFolder = 117,
        ClassificationSapBusinessObject = 118,
        RecordSapComponent = 119,
        LookupItem = 120,
        ActivityEmailRecipient = 121,
        CheckinStyle = 122,
        CheckinPlace = 123

 (I got the initial list from a very helpful fellow group member Rich_Kid, I  acknowledge and credit to the Rich_Kid for his co-operation).


Cheers,
Harry
5 Replies
Highlighted
Harry-Koppanyi Outstanding Contributor.
Outstanding Contributor.

Re: Where I can get a Event Type list. (Records Manager 8.3 - TSEVENTDAT)

Jump to solution

Hi, If I remember correctly you may find them within the Help File, however I wrote a similar report (also used these events catches within our TRIMBocX Platform - SharePoint to RM bidirectional Integration solution). Below you can find the full list for RM83.

TSEVENTS -
 
 BASIC SUMMARY EVENTNAME = EVENT VALUE

 Assignee Changed   CurrentChanged = 0,
 Home Changed HomeChanged = 1,
        Owner Changed  OwnerChanged = 2,
        Contact Added ContactAdded = 3,
        Contact Removed ContactRemoved = 4,
        Document Viewed  ErecViewLocationType = 5,
        Document Checked Out  ErecBookoutLocationType = 6,
        Document Extracted  ErecExtractLocationType = 7,
        Document Checked In (Replace)   ErecReplaceLocationType = 8,
        Document Checked In (New Revision)  ErecNewVersionLocationType = 9,
        Document Checked In (Undo Checkout) ErecReturnOnlyLocationType = 10,
        Document Removed ErecRemoveLocationType = 11,
        Document Attached  ErecAttachLocationType = 12,
        Document Published  ErecPublishLocationType = 13,
        Disposition Changed  DispositionChanged = 14,
        Signature Created  SignatureCreated = 15,
        Signature Attached SignatureAttached = 16,
        Signature Verified SignatureVerified = 17,
        Signature Failed Verification  SignatureFailVerify = 18,
        Security Profile Changed SecurityChanged = 19,
        Retention Schedule Reviewed ScheduleReviewed = 20,
        Classified As Vital    MadeVital = 21,
        Declassified From Vital   MadeNotVital = 22,
        Added to Hold   HoldAdded = 23,
        Removed from Hold HoldRemoved = 24,
        Container Changed  ContainerChanged = 25,
        Title Changed  TitleChanged = 26,
        Notes Changed  NotesChanged = 27,
        Date Created Changed CreateDateChanged = 28,
        Schedule Changed ScheduleChanged = 29,
        Record Number Changed NumberChanged = 30,
        Access Control Changed   AccessControlChanged = 31,
        Document Printed   ErecPrintLocationType = 32,
        Document Exported(XML)  ErecExportXMLLocationType = 33,
        Document Rendition Extracted ErecRenditionExtracted = 34,
        Document Rendition Viewed   ErecRenditionViewed = 35,
        Document Rendition Printed ErecRenditionPrinted = 36,
        Document Revision Extracted   ErecRevisionExtracted = 37,
        Document Revision Viewed   ErecRevisionViewed = 38,
        Document Revision Printed  ErecRevisionPrinted = 39,
        Document Link Extracted   ErecLinkExtracted = 40,
        Document Link Viewed  ErecLinkViewed = 41,
        Document Link Printed  ErecLinkPrinted = 42,
        Document attached to email  ErecMailed = 43,
        External Event  ExternalEvent = 44,
        Classification Changed   ClassificationChanged = 45,
        Date Closed Changed CloseDateChanged = 46,
        Document Annotated  ErecAnnotated = 47,
        Document Annotation Cancelled  ErecNotAnnotated = 48,
        Document Redacted   ErecRedacted = 49,
        Document Revision Removed
        ErecRevisionRemoved = 50,
        Additional Field Changed  UdfChanged = 51,
        Document Rendition Added   ErecRenditionAdded = 52,
        Related Record Created  CreateRecordRelationship = 53,
        Related Record Removed  RemoveRecordRelationship = 54,
        Date Registered Changed RegDateChanged = 55,
        Date Due Changed  DueDateChanged = 56,
        Date Published Changed  DatePublishedChanged = 57,
        Date Inactive Changed  DateInactiveChanged = 58,
        Last Action Date Changed   DateLastActionChanged = 59,
        Manual Disposal Date Changed   DateDestructionChanged = 60,
        Retention Review Date Changed   DateRetentionChanged = 61,
        Finalized   Finalized = 62,
        Unfinalized  Unfinalized = 63,
        Content Added   ContentAdded = 64,
        Content Removed  ContentRemoved = 65,
        Security Declassification Schedule Changed  CsDeclassifyChanged = 66,
        Security Downgrade Schedule Changed   CsDowngradeChanged = 67,
        Action Completed  ActionCompleted = 68,
        Action Assigned  ActionAssigned = 69,
        Action Reassigned  ActionReassigned = 70,
        Action Undone  ActionUndone = 71,
        Action Made Current    ActionCurrent = 72,
        Record Created  RecordCreated = 73,
        Record Modified    RecordModified = 74,
        Record Deleted     RecordRemoved = 75,
        Document link attached to email   ErecMailedLink = 76,
        Document Rendition Removed    ErecRenditionRemoved = 77,
        Assignee Initialized     CurrentAssigned = 78,
        Home Initialized  HomeAssigned = 79,
        Owner Initialized   OwnerAssigned = 80,
        Access Exclusions Changed   AccessExclusionsChanged = 81,
        Record Copied    RecordCopied = 82,
        SharePoint Document Viewed  SpiViewed = 83,
        SharePoint Document Edited   SpiEdited = 84,
        SharePoint Item Managed  SpiManaged = 85,
        SharePoint Item Relocated   SpiRelocated = 86,
        Record Exposed to SharePoint    SpiExposed = 87,
        Document Ready For Drafting   DocumentReadyForDrafting = 88,
        Document Ready For Review   DocumentReadyForReview = 89,
        Document Ready For Authorization   DocumentReadyForAuthorization = 90,
        Document Review Comments Updated DocumentReviewCommentsUpdated = 91,
        Document Review Complete   DocumentReviewComplete = 92,
        Document Authorization Complete  DocumentAuthorizationComplete = 93,
        Signed Copy Rendition Promoted   SignedRenditionPromoted = 94,
        DocuSign Authorization Failed   DocusignFailed = 95

 

Object Types for the Events
BaseObjectTypes
    {
        Unknown = 0,
        RecordLocation = 1,
        RecordRendition = 2,
        RecordKeyword = 3,
        RecordRelationship = 5,
        Record = 6,
        LocationAddress = 7,
        LocationEAddress = 8,
        Location = 9,
        RecordType = 10,
        StopWord = 11,
        Word = 12,
        ZipCode = 13,
        SecurityLevel = 15,
        SecurityCaveat = 16,
        LookupSet = 18,
        Space = 19,
        Classification = 21,
        ScheduleTrigger = 22,
        Schedule = 23,
        ElectronicStore = 24,
        ActionDef = 26,
        ActionDefStep = 27,
        RecordAction = 29,
        Keyword = 30,
        Request = 33,
        HtmlLayout = 37,
        SavedSearch = 38,
        History = 40,
        FieldDefinition = 42,
        RecordHold = 43,
        Hold = 44,
        Census = 45,
        Report = 46,
        RecordRevision = 48,
        RecordLinkedDocument = 49,
        Database = 50,
        ReportBitmap = 53,
        DocumentQueue = 54,
        SecurityGuide = 56,
        ScheduledTask = 58,
        ScheduledTaskHistory = 61,
        Meeting = 63,
        MeetingInvitation = 64,
        MeetingDocument = 65,
        AutoPartRule = 67,
        Alert = 68,
        UserLabel = 69,
        MailTemplate = 72,
        Communication = 73,
        CommunicationDetail = 74,
        OfflineRecord = 75,
        MeetingType = 76,
        MeetingTypeUsualParticipant = 77,
        AgendaItem = 78,
        AgendaItemAttachment = 79,
        MinuteItem = 80,
        MinuteItemActionArising = 81,
        TodoItem = 82,
        TodoItemItemReference = 83,
        AgendaItemType = 84,
        Workflow = 85,
        WorkflowDocument = 86,
        WorkflowTemplate = 87,
        WorkflowTemplateDocument = 88,
        Activity = 89,
        ActivityDocument = 90,
        ActivityResult = 91,
        ActivityStartCondition = 92,
        ActivityEscalation = 93,
        ActivityAuthorization = 94,
        MinuteItemType = 95,
        AgendaItemTypeAttachment = 96,
        Origin = 97,
        Jurisdiction = 98,
        JurisdictionMember = 100,
        RecordJurisdiction = 101,
        OriginHistory = 102,
        Notification = 105,
        SearchForm = 106,
        AlertSubscriber = 108,
        SharePointItem = 110,
        RecordClientMatterRole = 111,
        RecordClientMatterParty = 112,
        Consignment = 113,
        ConsignmentApprover = 114,
        ConsignmentIssue = 115,
        RecordTypeAutoSubFolder = 117,
        ClassificationSapBusinessObject = 118,
        RecordSapComponent = 119,
        LookupItem = 120,
        ActivityEmailRecipient = 121,
        CheckinStyle = 122,
        CheckinPlace = 123

 (I got the initial list from a very helpful fellow group member Rich_Kid, I  acknowledge and credit to the Rich_Kid for his co-operation).


Cheers,
Harry
Outstanding Contributor.. AG_LTBit Outstanding Contributor..
Outstanding Contributor..

Re: Where I can get a Event Type list. (Records Manager 8.3 - TSEVENTDAT)

Jump to solution

Hi AldoH,

You can get the enumerated lists from this website http://sdk.mfcm.xyz/90/enum_metadata.html 
Please note that this is 9.0, the 8.3 version of this site doesn't seem to provide the enumerated lists.

For TSEVENTDAT you need to use the Event Types: http://sdk.mfcm.xyz/90/enum_metadata.html#enum_help_events. This table is transitory and is used for processing events, if you are wanting to read them as they happen and output something to another system this is an option, however, it would be pretty easy to miss if events are processed before you pick it up. This is were events are stored until they are processed by an event processor.

I would recommend targetting the Audit Log Table, you can do this from the client directly or the TSONLINEAU table. 

For TSONLINEAU you need to use History types http://sdk.mfcm.xyz/90/enum_metadata.html#enum_help_historyTypes. This table is where all audit log items are stored after being processed by the event processor (through TSEVENTDAT). This is the list that Harry provided.

The object types are contained in: http://sdk.mfcm.xyz/90/enum_metadata.html#enum_help_baseObjectTypes

Hope that helps.

AG,

-----------------------------------------------------------------------
www.ltbit.com.au
Harry-Koppanyi Outstanding Contributor.
Outstanding Contributor.

Re: Where I can get a Event Type list. (Records Manager 8.3 - TSEVENTDAT)

Jump to solution

Thanks AG, this is an excellent resource mate.


Cheers,
Harry
0 Likes
AldoH Regular Contributor.
Regular Contributor.

Re: Where I can get a Event Type list. (Records Manager 8.3 - TSEVENTDAT)

Jump to solution

Hello, Harry,

Sorry for the delay in my response, but I have been out of my office and I did not have access to my mail or to the community forum.

Thank you very much for the information, it is very helpful. I recently started working with Records Manager and I am developing an application that should communicate with Records Manager so that HPERM manages the documents that the application will generate.

I have many things to do and many requests to resolve and among them is to generate reports on the activities of users, the most accurate possible.

Again, thank you very much for this valuable information.

0 Likes
AldoH Regular Contributor.
Regular Contributor.

Re: Where I can get a Event Type list. (Records Manager 8.3 - TSEVENTDAT)

Jump to solution

Thank you AG for this valuable information. This is very helpful for me and allows me to have a better basis for many of the work I must do.

Thank you.

P.S. Do you know where I can get the RM 8.3 database schema?

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.