A TRIM 7.1 database code-table question (192 Views)
Reply
Regular Advisor
Matthew D Wilson
Posts: 200
Registered: ‎07-20-2009
Message 1 of 4 (192 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

 

Please use plain text.
Honored Contributor
EWillsey
Posts: 1,739
Registered: ‎04-20-2010
Message 2 of 4 (160 Views)

Re: A TRIM 7.1 database code-table question

54=document queue

Please use plain text.
Honored Contributor
EWillsey
Posts: 1,739
Registered: ‎04-20-2010
Message 3 of 4 (155 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

Please use plain text.
Regular Advisor
Matthew D Wilson
Posts: 200
Registered: ‎07-20-2009
Message 4 of 4 (152 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!

Please use plain text.
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