ST_CONFIG - System Table

<< Click to Display Table of Contents >>

EQuIS 7  >>  EDP > EDP Install, Configuration, Administration > Configuration >

ST_CONFIG - System Table

Note: For EQuIS EDP Version 6.0 and later, the ST_CONFIG table is viewable in the EDP Reference Value tab so that settings are available in EDP Standalone. Only values where config_section='EarthSoft.EDP.RVF' are added to the reference value tab.

 

EarthSoft.EDP.RVF.NonZeroSecondsAction

 

Ability to truncate non-zero seconds on a time or date/time field has been added to EDP. Seconds will be truncated when the value is loaded or entered. This option can be set to occur for all formats or a single format.

 

Version: 6.1+ [case 67547]

 

ST_CONFIG

VALUE

REMARK

EXAMPLE 1
Truncates non-zero seconds

for all formats

EXAMPLE 2

Preserves non-zero seconds

in the EQEDD format only

CONFIG_SECTION

EarthSoft.EDP.RVF


EarthSoft.EDP.RVF

EarthSoft.EDP.RVF

CONFIG_KEY

NonZeroSecondsAction


NonZeroSecondsAction

NonZeroSecondsAction

OBJECT_TYPE

Format

Leave null if object_value is also null


Format

OBJECT_VALUE

<format ID>

Name of format if applying setting to a specific format. Format ID does not include the file extension. Leave null to apply to all formats.


EQEDD

STRING_VALUE

Truncate|DoNotTruncate

Truncate = Non-zero seconds will

be truncated

DoNotTruncate =  Non-zero seconds will be preserved

Truncate

DoNotTruncate

 

EarthSoft.EDP.EddCustomHandler.ShowUpdateMode

 

Limits the commit type in EDP Professional for a given format (may be user-specific). For more information on commit type limits read here.

 

Version: 5.5.0+ [case 50526]

 

ST_CONFIG

VALUE

REMARK

EXAMPLE 1

Hides the "Insert & Update" commit mode when user "someuser" is using the EFWEDD format

EXAMPLE 2

Hides the "Insert & Merge" commit mode for all users using the EQEDD format

CONFIG_SECTION

[<User Name>\]EarthSoft.EDP.EddCustomHandler.ShowUpdateMode

Set [<User Name>\] to apply this setting to a specific user.

someuser\EarthSoft.EDP.EddCustomHandler.ShowUpdateMode

EarthSoft.EDP.EddCustomHandler.ShowUpdateMode

CONFIG_KEY

<format name>

The name of the EDP format to which this setting will be applied.

EFWEDD

EQEDD

OBJECT_TYPE

CommitMode


CommitMode

CommitMode

OBJECT_VALUE

None|Merge|Update|Replace|Format

Indicates the commit mode which will be shown or hidden:

None = Insert Only

Merge = Insert & Merge

Update = Insert & Update

Replace = Insert & Replace

Format = Format Specific (controlled by the custom handler)

Update

Merge

STRING_VALUE

False|True

False = hide this CommitMode

True = show this CommitMode

False

False

 

EarthSoft.EDP.EddMapping.RowDifferenceError

 

Determines if an error message is shown when the target row already exists when creating the package in EDP and if the rest of the row mappings will be processed (may be user-specific). Only applies to parent mappings. By default, EDP will not show the error.

 

Version: 5.6.0+ [case 67547]

 

ST_CONFIG

VALUE

REMARK

EXAMPLE 1

Prevents the error message for all users in EDP Enterprise

EXAMPLE 2

Shows the error message and stops processing the rest of the row mappings in EDP Professional for user "someuser"

CONFIG_SECTION

EarthSoft.EDP.EddMapping


EarthSoft.EDP.EddMapping

EarthSoft.EDP.EddMapping

CONFIG_KEY

RowDifferenceError


RowDifferenceError

RowDifferenceError

OBJECT_TYPE

Pro|Enterprise

The application which this setting will be applied to.  EDP Professional or EDP Enterprise

Enterprise

Pro

OBJECT_VALUE

<user name>

Name of user if applying setting to a specific user. Leave null to apply to all users.


someuser

STRING_VALUE

ShowAndContinue|ShowAndStop|DoNotShow

ShowAndContinue = shows the error and continues processing the rest of the row mappings

ShowAndStop = shows the error and stops processing the rest of the row mappings

DoNotShow = does not show an error and does not compare the target row with any existing package row

DoNotShow

ShowAndStop

 

EarthSoft.Reports.ActiveReports.HideDataSource

 

Hides the data source icon in Active Reports (may be user specific). Does not hide the data source by default. When using Application Level Security, the data source is always hidden.

 

Version: 5.6.0+ [case 65465]

 

ST_CONFIG

VALUE

REMARK

EXAMPLE 1

Hides the data source icon for all users

EXAMPLE 2

Show the data source icon for user "someuser"

CONFIG_SECTION

EarthSoft.Reports.ActiveReports


EarthSoft.Reports.ActiveReports

EarthSoft.Reports.ActiveReports

CONFIG_KEY

HideDataSource


HideDataSource

HideDataSource

OBJECT_TYPE

<user name>

Name of user if applying setting to a specific user. Leave null to apply to all users.


someuser

OBJECT_VALUE





STRING_VALUE

True|False

True = hide the data source icon

False = show the data source icon

True

False

 

EarthSoft.EDP.Pro.RegisterFile

 

Registers the EDD file to ST_FILE_REGISTRATION after committing the EDD to the database in EDP Professional (may be format specific). By default EDP Professional will not register the EDD.

 

Version: 5.6.0+ [case 62148]

 

ST_CONFIG

VALUE

REMARK

EXAMPLE 1

Registers all EDDs for

format EQEDD

EXAMPLE 2

Registers all EDDs

for all formats

CONFIG_SECTION

EarthSoft.EDP


EarthSoft.EDP

EarthSoft.EDP

CONFIG_KEY

Pro


Pro

Pro

OBJECT_TYPE

RegisterFile


RegisterFile

RegisterFile

OBJECT_VALUE

<format name>

The name of the EDP format to which this setting will be applied.

EQEDD


STRING_VALUE

True|False

EQuIS Version 5.6.2 and Earlier

True = register the EDD.

False = do not register the EDD.

True

True

STRING_VALUE

{workflowstep_id}

EQuIS 6.0 and later

This is the valule of st_workflowstep.workflowstep_id for a step in a workflow with service_name='FollowUpTask'.

The workflow may be an existing EDD workflow or a new custom workflow.

65185

65185

 

EarthSoft.Reports.ReportGrid.TurnOffDropDowns

 

Turns off all drop-downs in an EQuIS data grid.

 

Version: 5.6.0+ [case 56755]

 

ST_CONFIG

VALUE

REMARK

EXAMPLE 1

Turns off drop-downs

for user "someuser"

EXAMPLE 2

Turns off drop-downs for

all users

CONFIG_SECTION

EarthSoft.Reports.Report.Grid


EarthSoft.Reports.ReportGrid

EarthSoft.Reports.ReportGrid

CONFIG_KEY

DataTables


DataTables

DataTables

OBJECT_TYPE

TurnOffDropDowns


TurnOffDropDowns

TurnOffDropDowns

OBJECT_VALUE

<user name>

Name of user if applying setting to a specific user. Leave null to apply to all users.

someuser


STRING_VALUE

True|False

True = turn off drop-downs

False = do not turn off drop-downs

True

True

 

XlsForceStyle

 

The mode of style application when exporting to Excel.

 

None: No styles will be applied

Normal: The standard mode of style application

Efficient: This mode of applying styles is much more memory efficient and is recommended for large exports that are causing out of memory issues.

 

ST_CONFIG

VALUE

REMARK

EXAMPLE 1

CONFIG_SECTION

XlsForceStyle



CONFIG_KEY

StyleSetting



OBJECT_TYPE




OBJECT_VALUE




STRING_VALUE

<setting>

Should be None, Normal, or Efficient

Efficient

 

EQEDD.EQEDDHandler.Suppress.sys_loc_code.check

 

In the EQEDD format, a check has been added for the following:

 

1.Warning: sys_sample_code should exist in the database if rt_sample_type.sample_class is not 'LQ' based on sample_type_code.

2.Warning: Sample_date and sys_loc_code must be the same in the database if rt_sample_type.sample_class is not 'LQ'.

 

These warnings appear as in the screen shot below. The LabSample_v1 table will appear red, but if all other errors have been resolved, the data will commit to the database without issue.

 

hmfile_hash_0c61b06e

 

To suppress these warnings, edit ST_CONFIG as indicated below.

 

Version: 1.02.104+

 

ST_CONFIG

VALUE

REMARK

EXAMPLE 1

Suppress the sys_loc_code

check warning in the

EQEDD format

EXAMPLE 2

Do not suppress the sys_loc_code

check warning in the

EQEDD format

CONFIG_SECTION

EQEDD.EQEDDHandler


EQEDD.EQEDDHandler

EQEDD.EQEDDHandler

CONFIG_KEY

suppress.sys_loc_code.check


suppress.sys_loc_code.check

suppress.sys_loc_code.check

OBJECT_TYPE





OBJECT_VALUE





STRING_VALUE

True|False

True = sys_loc_code check suppressed

False = sys_loc_code check

not suppressed

True

False