A TRIM 7.1 database code-table question (288 Views)
Reply
Regular Advisor
Matthew D Wilson
Posts: 200
Registered: ‎07-20-2009
Message 1 of 4 (288 Views)

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

 

Honored Contributor
EWillsey
Posts: 1,867
Registered: ‎04-20-2010
Message 2 of 4 (256 Views)

Re: A TRIM 7.1 database code-table question

54=document queue

Honored Contributor
EWillsey
Posts: 1,867
Registered: ‎04-20-2010
Message 3 of 4 (251 Views)

Re: A TRIM 7.1 database code-table question

Sorry, forgot to say... 

 

10=Record Type Referenced Access Control

21=Classification Referenced Access Contol

Regular Advisor
Matthew D Wilson
Posts: 200
Registered: ‎07-20-2009
Message 4 of 4 (248 Views)

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!

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.