System Parameters

Internal Parameter Name

Typical Parameter Title(s)

Parameter Description

ACCESSIBILITY_COMPLIANCE

Accessibility Compliance

When this check box is selected, the system provides specific rules that allow the ADA-compliance feature to pass the Texas CPA automated ADA test.

AD_AUTHENTICATION

Auth. by Active Directory?

When this check box is selected, the password stored in the Active Directory is used for authentication rather than the password stored in the AgileAssets application.
Note: A third field is also added to the log-on window for entry of the domain. The system administrator will need to provide this information to a user to allow her or him to log on.

AD_URL

Active Dir. LDAP URL

This field contains the server address where the Active Directory is stored.

ALLOW_MORE_THAN_24_HOURS

Allow More Than 24 Hours

When the check box for this parameter is selected, the hours assigned to a Labor Day Card may exceed 24.

ALLOW_SPATIAL_EDITING

Allow Spatial Editing

This parameter should be set to null.

ALLOW_WO_EXTEND

Allow WO Extension

When this check box is selected, the system will allow users to extend work order bars in the Scheduling pop-up window for approved Day Cards.

ANALYSIS_GLOBAL_TEMP_TABLES

Global Temp. Tables for Analysis

When the check box for this parameter is selected, optimization analyses use Global Temporary tables (that is, table names starting with GT...) rather than the usual USER_ANALYSIS… tables. The check box should be selected when the client's environment is configured at a high logging level because otherwise analyses will overflow the logging tables.

ANTIVIRUS_ID

Antivirus

This field provides a drop-down list of various anti-virus software programs, one of which may be selected as the tool for checking emails and attachments. The default value is None.

ATTACHMENT_ROOT

Attachment Root

This is the root folder to which a user has access to obtain a source file to import or attach an external file to a record. A drive may also be mounted and identified through this field for a user to access.

CHECK_ALERTS_INTERVAL

Alerts Checking Int. (in sec)

The value in this field determines how often (in seconds) the system checks for new alerts.
Note: If this parameter is set to zero, then not only will the system not generate alerts, it will also not generate any types of messages.

CURRENCY_FORMAT

Currency Format

This field sets how monetary values are formatted in column displays. To apply the format to a column, in the Columns window put [Currency] in the Format column for the column that is a monetary value.

CURRENCY_SYMBOL

Currency Symbol

This field determines the symbol that will appear before currency values. The default value is the Windows setting.

CUSTOM_LOGIN_HTML

Custom Login HTML

This field customizes the appearance of the log-in screen.

DATE_FORMAT

Date Format
Short Date Format

This field sets how dates are displayed. These functions use the same 'format' strings as the java.text.SimpleDateFormat class as shown in the following table:

For example, a typical coding for an American-style date (say, 10/22/2008) would be MM/dd/yyyy and for a sortable date (say, 2008-10-22) it would be yyyy-MM-dd.|

DB_ENCODING

Database Encoding

This parameter sets the encoding system, with UTF8 being the default. This is used in the re-compiling of Jasper reports.

DEFAULT_CRS_ID

Default CRS ID

If a CRS_ID is not provided in a record of the GIS_THEMES table, then the system uses this CRS value (found in the GIS_CRS table) for the theme. Also, this CRS is used to set what is the "full geographic scope" in all map windows.

DEFAULT_BASEMAP_ID

Default Base Map ID

This field sets the default map in the GIS (Geographic Info System) Explorer window.

DO_UNSUCCESSFUL_LOG

Log Unsuccessful Logins

When this check box is selected, the system tracks and stores information on unsuccessful attempts to log in. This information may be viewed by displaying the tabular report for unsuccessful log-in attempts.

DO_WINDOW_LEVEL_LOG

Do Window Level Log

When the check box for this parameter is selected, the system adds all window navigation descriptions to the SYSTEM_JOB_DET table.

FTP_ENCODING

FTP Server Encoding

This parameter sets the encoding standard used for the client's FTP site.

GRID_REPORT_IN_MEM_SIZE_THRS

Grid Report in Memory Size Threshold

This sets the maximum size (rows times columns) of a tabular report that is in the XLS or XLSX format.

GRID_REPORT_SIZE_THRS

Grid Report Size Threshold

This sets the maximum size (rows times columns) of a tabular report.

GROOVY_SCRIPT_LOG_LEVEL_ID

Groovy Script Logging

If desired, this parameter may be set to a value other than OFF to log Groovy scripts. The following types of logging may be configured by selecting the appropriate type from the drop-down list:
Error — Only log errors during the execution of the Groovy script.
Info — This type adds the log script ID, Type ID, Name, and Parameters to the Error level. The output is in the form RUN/COMPILE/UPDATE][ScriptId][TypeId][Name]{arguments}.

INSTANCE_NAME

Instance Name

This is the literal description of the environment that is displayed at log-in and in the top right corner of the main screen.

LANE_ID_ORDER

Lane ID Order

This parameter determines how divided multi-lane roadways are numbered. The selection "Inside Lane First" indicates that the number 1 lane is nearest the median; the selection "Outside Lane First" indicates that the number 1 lane is furthest from the median.

LOC_X_CHECK_ID

No longer in use.

MAIL_ATTACH_MAX_SIZE

Attachment Max. Size

This parameter sets the size limit of system-generated email attachments in megabytes (MB) (for example, the size limit of reports that may be emailed). If the attachment exceeds the limit, the system will automatically assemble the attachment into a .ZIP file. If the .ZIP file still exceeds the limit, the system will generate an error and send the user an email saying the email and attachment were not sent. The default value is 2.0 MB.

MAIL_DEFAULT_FROM

Mail Default From

This field configures the email address that will be the "From" e-mail address for all mail sent by the system.

MAIL_HOST

Mail Host

This field configures the server name through which email is routed.

MAIL_HOST_PORT

Mail Host Port

This parameter sets the port number for the mail host. The default is 25.

MAIL_PASSWORD

Mail Password
SMTP Password

This is the password used to access the e-mail server, if needed.

MAIL_REPORT_LOG

Mail Report Log

When this check box is selected, the system stores a description of every sent email in a system table.

MAIL_USERNAME

Mail Username
SMTP User

This is the user name used to access the e-mail server, if needed.

MAINTENANCE_FLAG

Maintenance Flag
System Maintenance Mode

When this check box is selected, only security profiles that have the System Lock Administrator check box selected may access the system. (The System Lock Administrator check box is found in the Access Level Settings window.)

MAKE_DAYCARDS_WITHIN_WO

Make Day Cards within WO

When this check box is selected, users may only create or edit Day Cards that are within the start and end dates (inclusive) of the work order.

MAX_UNSUCCESS_NUM

Max. Unsuccess Num.

The value in this field specifies the number of attempts a user may make to log on before they are locked out of the system. When the value in this field is exceeded, the user will need to contact the System Administrator to unlock their account.

MONTH_DATE_FORMAT

Gantt Chart Date Format

This specifies the format for the dates shown at the top of the Schedule and Road View windows. It follows the same conventions as Date Format given above.

NET_SYSTEM_ID

Network Manager System ID

This parameter sets the system ID used for Network Manager. At present, it should always be set to 1 (because there is only one network).

OFFSET_THRESHOLD

Offset Threshold

The value in this field sets the distance (in feet) from an entered GPS location in which the system will search for a route

ONLY_POST_HTTP_LOGIN

Only Post HTTP Login

When this check box is selected, the User ID is included as part of the application's URL and so the User ID field is not displayed at login.

ONLY_SSO_LOGIN

Only SSO Login?

When this check box is selected, the system will only allow users to log-in via a SSO connection.

PASSWORD_FORGOT_LINK_ENABLE

Enable "Forget Password?" Link

If this field is checked, then the Forgotten Password feature is enabled and the "Forget Password?" prompt appears in the log-on screen.

PASSWORD_LIFE

Life of Password (in days)

The number of days that a password can be active. Once expired, on the next user logon, the user will be required to change their password.

PASSWORD_MIN

Min. Password Length

The minimum number of characters for a password and user name.

PASSWORD_MIN_LOWERCASE_CHARS

Min. Number of Lowercase Characters in Password

The value in this field indicates the minimum number of lowercase characters that must be in a password.

PASSWORD_MIN_NONALFANUM_CHARS

Min. Number of Non-alphanumeric Characters in Password

The value in this field indicates the minimum number of non-alphanumeric characters that must be in a password.

PASSWORD_MIN_NUMERIC_CHARS

Min. Number of Numeric Characters in Password

The value in this field indicates the minimum number of numeric characters that must be in a password.

PASSWORD_MIN_UPPERCASE_CHARS

Min. Number of Uppercase Characters in Password

The value in this field indicates the minimum number of uppercase characters that must be in a password.

PASSWORD_REP

Max. Number of Repeating Characters

The maximum number of characters that may repeat consecutively in a password. For example, if this parameter was set to three, a password like AAAA01 would not be allowed (although AAA001 and AA01AA would be allowed).

PASSWORD_REP_TIME

Password Rep Time

The value in this field is the amount of time (in days) in which a password cannot be repeated. (If the value is zero, there is no constraint on the re-use of passwords.)

PASSWORDS_ENCRYPTION

Encrypt Passwords

When this check box is selected, the system encrypts passwords before storing them in the database.

PREFIX_SCHEMA_NAME

Prefix Schema Name

When this check box is selected, the system includes the schema name in statements generated by the Apply Changes command.

PRETIMEOUT_WARNING_TIME

Pretimeout Warning Time

This is the time (in minutes) prior to session timeout when a user gets a warning message that their session is about to expire. (The warning appears in a pop-up window.) If this parameter is set to zero, then a warning message is not generated.

RIGHT_TO_LEFT

Right to Left

When this check box is selected, text in name fields will be positioned so as to read from right to left. When it is clear, text will read from left to right.

SECURITY_ANSWER_MIN_LENGTH

Security Answer Minimum Length

This is the minimum number of characters required for the answer(s) to the security question(s) used for the "Forgot Password" feature.

SECURITY_QUESTIONS_NUM

Number of Security Questions

When the Forgotten Password feature is enabled, this field sets the number of security questions that the user must configure.

SEND_MESSAGES

Send Messages

When this field is set to Y, material transaction messages are allowed to be sent.

SEQUENTIAL

No Sequential Passwords
Prevent Sequential Passwords

If this check box is selected, sequential passwords are not allowed. For example, if a user's current password is USER01, with this check box selected the system would not allow the user to change the password to USER02.

SESSION_TIMEOUT

Max. Idle Session
Session Timeout

When no activity occurs for the time (in minutes) specified by this parameter, the system will automatically log-out the user. If this parameter is set to zero or null, a user's session will never time-out.

SQL_TRACER_LOG_LEVEL_ID

SQL Tracer Logging

If desired, this parameter may be set to a value other than OFF to log SQL queries. The following types of logging may be configured by selecting the appropriate type from the drop-down list:
Error — Only log errors during the execution of the SQL query.
Info — This type adds the log script ID, Type ID, Name, and Parameters to the Error level. The output is in the form RUN/COMPILE/UPDATE][ScriptId][TypeId][Name]{arguments}.

SYSTEM_LOG_LEVEL_ID

Logging Level

You may configure logs to be kept each day to monitor system activity. These logs are stored in the location specified by the Logging Root Folder parameter and are accessed via the System Logs window. The following types of logging may be configured by selecting the appropriate type from the drop-down list:
Error — This type logs only that an error occurred.
Debug — This type logs that an error occurred as well as where (in the Java code) that the error occurred.
Performance — This type is the same as Debug but with additional timing statistics. It shows User ID, Window ID, action, and time to execute.
None — Logs are not generated.
Note: Setting this parameter to a value other than None also writes log-in and log-out activity by user to the SYSTEM_LOG table.

SYSTEM_LOG_ROOT

Logging Root Folder

All logging files are stored in a folder called Logs. This field specifies where that folder is stored relative to the application root directory. (If the field is blank, the logs are stored in the application root directory under the Logs folder.)

TABLE_IMPORT_ROOT

Table Import Root

This field is for importing and shows the root of the network share.

TIME_FORMAT

Time Format

This field sets how time is displayed. These functions use the same 'format' strings as the java.text.SimpleDateFormat class as shown in the following table:

TYPE_AHEAD_DELAY

Type Ahead Delay

This is the time threshold (in milliseconds) for the type-ahead feature to disengage.

USE_HTTP_COOKIES

Use Cookies?

When this check box is selected, a User_ID cookie is saved on the browser.

USE_MASTER_CODE_COST

Status
Use Master Code Cost
Use Master Code Material Cost?

This parameter is usually hidden, but may be accessed directly through the database. If this parameter is set to 1, then all material unit costs come from the MATERIAL_MASTER table. Generally, this parameter is set to 1 for agencies that use a third-party material management system having statewide unit costs. (When this parameter is set to 0, material unit costs are calculated internally by stock bin within each warehouse as total cost of the stock bin divided by the total quantity in the stock bin.)

USE_SECURITY_QUESTIONS

Use Security Questions

This check box is displayed in some applications. When selected, the Forgotten Password feature is enabled.

VIDEOLOG_ROOT

Videolog Root

This is the root folder in which video logs are stored.