ST_CONFIG - System Table

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Tables and Forms > System Tables (ST) >

ST_CONFIG - System Table

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. [case 67547]

 

ST_CONFIG

VALUE

REMARK

EXAMPLE 1
Truncates non-zero seconds for all formats

EXAMPLE 2

Preserves non-zero seconds in 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 specific format. Format ID does not include 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.

 

ST_CONFIG

VALUE

REMARK

EXAMPLE 1

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

EXAMPLE 2

Hides Insert & Merge commit mode for all users using 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>

Name of EDP format to which this setting will be applied.

EFWEDD

EQEDD

OBJECT_TYPE

CommitMode


CommitMode

CommitMode

OBJECT_VALUE

None|Merge|Update|Replace|Format

Indicates 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. [case 67547]

 

ST_CONFIG

VALUE

REMARK

EXAMPLE 1

Prevents error message for all users in EDP Enterprise

EXAMPLE 2

Shows error message and stops processing rest of 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

Professional|Enterprise

Application which this setting will be applied to (EDP Professional or EDP Enterprise).

Enterprise

Professional

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 error and continues processing rest of row mappings

ShowAndStop = shows error and stops processing rest of row mappings

DoNotShow = does not show an error and does not compare 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. [case 65465]

 

ST_CONFIG

VALUE

REMARK

EXAMPLE 1

Hides data source icon for all users

EXAMPLE 2

Show 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 data source icon

False = show 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. [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

Professional


Professional

Professional

OBJECT_TYPE

RegisterFile


RegisterFile

RegisterFile

OBJECT_VALUE

<format name>

Name of EDP format to which this setting will be applied.

EQEDD


STRING_VALUE

True|False

True = register EDD

False = do not register EDD

True

True

STRING_VALUE

{workflowstep_id}

EQuIS 6.0+

Value of st_workflowstep.workflowstep_id for a step in a workflow with service_name='FollowUpTask'.

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.[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: Standard mode of style application

Efficient: Much more memory efficient, and 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'.

 

The LabSample_v1 table will appear red, but if all other errors have been resolved, the data will commit to the database without issue.

 

To suppress the warnings, edit ST_CONFIG as indicated below.

 

ST_CONFIG

VALUE

REMARK

EXAMPLE 1

Suppress SYS_LOC_CODE

check warning in EQEDD format

EXAMPLE 2

Do not suppress SYS_LOC_CODE

check warning in 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