Content Manager OnDemand Database Tables
arsagfld - Application Group Fields Table
This table contains a list of all of the fields defined in CMOD Application Groups.
| Field | Sample Values | Type | Description |
|---|---|---|---|
| AGID | 5001, 5357, 3525 | Integer | Specifies the Application Group that the fields are related to. Relates to ARSAG.AGID. |
| Field | 0,1,2,3,4,5 | Integer | Sequential number representing the field number, starting at 0. |
| Name | RPT_ID,CUST_NUM | String | The text name of the field. |
| Type | x'49', x'53', x'62' | HexChar | The hex values represent single-byte characters which describe a field type.
|
| Qual | x'42', x'44' | HexChar | x'42 = "B", x'44' = "D" |
| Mask | 1, 2, 32770 | Integer | This is a vectored field that stores the information in the field checkboxes in the Application Group Field Information Tab. |
| String_Type | x'00', x'46', x'56' | HexChar | The hex values represent single-byte characters which describe a string type. |
| String_Len | 0, 1, 2, 5, 10, 60 | Integer | The length of the string field. '0' if the field is a date or numeric field like Integer or Float. |
| String_Case | x'4D', x'55' | HexChar | Represents a string field's case.
|
| Leading | $, #, <space>, - | String | A list of characters to remove from the FRONT of the string before inserting them into the database. |
| Strip | $, #, <space>, - | String | A list of characters to remove from ANYWHERE in the string before inserting them into the database. |
| Trailing | $, #, <space, -> | String | A list of characters to remove from the END of the string before inserting them into the database. |
| Map_Field | NULL, -1, 0, 1, 25 | NULL or Integer |
arsagfld.mask
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:
| Value | Checkbox Name | Description |
|---|---|---|
| 1 | Indexed | The Field Type is set to 'Indexed' when enabled, Filter when disabled. |
| 2 | Updatable | The value for this field can be updated by users or administrators with sufficient privileges. |
| 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 | Application ID Field | This field is used to identify different Applications Defined in the Application Group. |
| 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 |
| 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. |
| 512 | Cluster | Builds a cluster index if the database engine supports it. |
| 1024 | Reference | Used by the OnDemand Distibution Facility to determine if the document should be distributed. |
| 2048 | Unknown | Unknown |
| 4096 | Page Count | This field contains the number of pages in the document. |
| 8192 | Document Size | This field contains the size of the document in bytes. |
| 16384 | Unknown | Unknown |
| 32768 | Unknown | Unknown |
| 65536 | Lockdown | This field contains the number of holds that exist for a document when CMOD Enhanced Retention Management is enabled. |
| 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. |