HPE Records Manager and HPE TRIM Forum
Showing results for 
Search instead for 
Do you mean 

A TRIM 7.1 database code-table question

Regular Advisor

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
Honored Contributor

Re: A TRIM 7.1 database code-table question

54=document queue

Honored 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

Highlighted
Regular Advisor

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!