This table maintains a catalog of folder fields for users
that have specific field information for a folder.
Table 1. Folder user fields table (ARSFOLFLDUSR)
| Column Name |
Data Type |
Description |
| id |
INTEGER |
User identifier |
| fid |
INTEGER |
Folder identifier |
| field |
SMALLINT |
Folder field identifier |
| query_order |
SMALLINT |
Order of fields in search criteria |
| dspl_order |
SMALLINT |
Order of fields in document list |
| sort_order |
SMALLINT |
Default sort order |
| sort_type |
CHAR(1) FOR BIT DATA (Db2®), BINARY(1) (SQL Server), RAW(1)
(Oracle) |
Type of sort |
| usr_mask |
SMALLINT |
Field setup |
| ops |
SMALLINT |
Search operators |
| def_op |
SMALLINT |
Default search operator |
| def_value1 |
VARCHAR(254) |
Default search value |
| def_value2 |
VARCHAR(254) |
Default search value for Between, Not Between |
| min_int |
BIGINT
(Db2, SQL Server),
INT (Oracle) |
Smallest integer allowed |
| max_int |
BIGINT
(Db2, SQL Server),
INT (Oracle) |
Largest integer allowed |
| datefmt |
VARCHAR(60) |
Format of date strings in search criteria |
| datedef_type |
CHAR(1) FOR BIT DATA (Db2), BINARY(1) (SQL Server), RAW(1)
(Oracle) |
Default date units for interval |
| datedef_arg |
INTEGER |
Default date value for interval |
| min_float |
FLOAT |
Smallest decimal allowed |
| max_float |
FLOAT |
Largest decimal allowed |
| decimal_pt_pos |
SMALLINT |
Precision (right of decimal point) |
| string_wild |
CHAR(1) FOR BIT DATA (Db2), BINARY(1) (SQL Server), RAW(1)
(Oracle) |
Wildcard |
| dspl_datefmt |
VARCHAR(60) |
Format of date strings in document list |
| min_dt |
TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) |
Minimum date allowed |
| max_dt |
TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) |
Maximum date allowed |
| min_str |
VARCHAR(254) |
Minimum decimal float allowed |
| max_str |
VARCHAR(254) |
Maximum decimal float allowed |
Table 2. Indexes for folder user fields
table (ARSFOLFLDUSR)
| Index name |
Columns in index |
Type of index |
| arsfolfldusr_idx |
fid, id, field |
Unique cluster index for Db2; Unique index for Oracle and SQL Server |