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. x'49' = "I" = Integer x'53' = "S" = String x'62' = "b" = Database Internal Date
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. x'4D' = "M" = Mixed x'55' = "U" = UPPER x'4C' = "L" = lower
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.