HPE Content Manager (HPE RM) Forum
cancel

A TRIM 7.1 database code-table question

Highlighted
Matthew D Wilso
Honored Contributor.

A TRIM 7.1 database code-table question

Hi everyone.   I'm doing some ferretting around to see which of our user groups/organisations are in use for ownership/access-control while record-keeping plans a restructure.   I became curious about some things.

 

Executing the following query gives the following results:

 

select axobject, count(*) from tsaccessco group by axobject order by axobject

 

AXOBJECT	COUNT(*)
6              25536357
9              24
10            142
21            6
23            40
38            173
46            4
54            18808
55            4
1010        216
1021        2706

 

I know what most of those codes are now, but can anyone explain 10, 21 and 54?   It might be useful to know so we can plan the restructure.   Thanks!

 

For records, the rest appear to be:

 

6 = record

9 = location

23 = retention schedule

38 = saved search

46 = report layout

55 = record statistics report (I _think_ 54 is related, but I'm not sure)

1010 = record type

2021 = classification

 

3 REPLIES
EWillsey
Acclaimed Contributor.

Re: A TRIM 7.1 database code-table question

54=document queue

---------
Erik
CMRamble.com
EWillsey
Acclaimed Contributor.

Re: A TRIM 7.1 database code-table question

Sorry, forgot to say... 

 

10=Record Type Referenced Access Control

21=Classification Referenced Access Contol

---------
Erik
CMRamble.com
Matthew D Wilso
Honored Contributor.

Re: A TRIM 7.1 database code-table question

Aaah, that makes sense.   I couldn't correlate any of the IDs because they get deleted (document queues are a bit of a mess in our database)

 

Thanks!