Difference between revisions of "Content Manager OnDemand Database Tables"

Edited to include all known values and their purposes.
(Addition of arsagfld.mask table.)
(Edited to include all known values and their purposes.)
Line 41: Line 41:


=== arsagfld.mask ===
=== arsagfld.mask ===
These are the values for this field.  This field is a 'vectored' field. Checking the associated checkbox increases the value by the specified value below:
'''CAUTION:'''  Changing these values without knowledge of how they inter-operate or conflict with each other is dangerous and not supported.
 
Checking the associated checkbox increases the value by the specified value below:


{| class="wikitable"
{| class="wikitable"
Line 47: Line 49:
!Value!!Checkbox Name!!Description
!Value!!Checkbox Name!!Description
|-
|-
|1||
|1||Indexed||The Field Type is set to 'Indexed' when enabled, Filter when disabled.
|-
|-
|2||
|2||Updatable||The value for this field can be updated by users or administrators with sufficient privileges.
|-
|-
|4||
|4||Segment||Specifies that this field should be used to segment the database tables, for faster access.  All Application Groups should have a Segment Field for maximum performance.
|-
|-
|8||
|8||Application ID Field||This field is used to identify different Applications Defined in the Application Group.
|-
|-
|16||
|16||Expire Date||This field is used to calculate the expiration date of the document when the Expiration Type is set to 'Document'.
|-
|-
|32||Log||Inserts the value of this field into the System Log for DocGets (retrievals) - message number 66
|32||Log||Inserts the value of this field into the System Log for DocGets (retrievals) - message number 66
|-
|-
|64||
|64||User Exit||Sends the field name and value to a user exit.
|-
|128||Unknown||Unknown
|-
|256||Partition||Partitions the database based on this field. Only one field can be selected as the partition field.
|-
|-
|128||
|512||Cluster||Builds a cluster index if the database engine supports it.
|-
|-
|256||
|1024||Reference||Used by the OnDemand Distibution Facility to determine if the document should be distributed.
|-
|-
|512||
|2048||Unknown||Unknown
|-
|-
|1024||
|4096||Page Count||This field contains the number of pages in the document.
|-
|-
|2048||
|8192||Document Size||This field contains the size of the document in bytes.
|-
|-
|4096||
|16384||Unknown||Unknown
|-
|-
|8192||
|32768||Unknown||Unknown
|-
|-
|16384||
|65536||Lockdown||This field contains the number of holds that exist for a document when CMOD Enhanced Retention Management is enabled.
|-
|-
|327678||
|131072||CFS-CMOD||Required for interoperation with FileNet if your server is enabled with CFS:OD.
|-
|-
 
|262144||Full Text Index||Specifies that this field is indexed by the full-text indexing option for Content Manager OnDemand.
|}
|}