This table maintains a catalog of application group field
aliases (Database values and Displayed values).
Table 1. Application group field alias table (ARSAGFLDALIAS)
| Column Name |
Data Type |
Description |
| agid |
INTEGER |
Application group identifier |
| field |
SMALLINT |
Application group field identifier |
| internal |
VARCHAR(254) |
Internal (Database) value |
| external |
VARCHAR(254) |
External (Displayed) value |
Table 2. Indexes for application group
field alias table (ARSAGFLDALIAS)
| Index name |
Columns in index |
Type of index |
| arsagfldalias_idx |
agid, field |
Cluster index for Db2; Index for Oracle and SQL Server |