View source for 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.

{| class="wikitable"
|-
!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'53' = "I" = Integer
|-
|Qual||x'42', x'44'||HexChar||
|-
|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.
|-
|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||
|}