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 |