Disposal Consolidation Settings

<< Click to Display Table of Contents >>

Navigation:  Modules > Asset Management > Disposals >

Disposal Consolidation Settings

Disposals Reconciliation is controlled by several settings which are maintained on the MIE.  Settings are available through the Home page of most options.  Disposals Reconciliation settings are available from the Home page of Asset Management.  Click Settings/Admin on the left menu.  The settings you see depend on your access level.  You may or may not see all of the settings documented below.

The following settings are available for Disposals:

DisposalWarningLevel

Ranges from 1 to 4.  Determines how verbose Disposals Reconciliation is in logging various warnings.  The warnings (and the entire run) are logged to the Job Log and can be viewed there.  1 is least verbose.

DisposalLogTime

Causes the Disposals Reconciliation routine to log how long it takes to perform certain functions.  Used as a debugging tool by developers to find bottlenecks in an effort to increase the speed of the Disposals Reconciliation function.  -1 = log time, 0 = do not log time.

DisposalBlankPhrases

This setting defines words, or phrases, separated by commas, that Disposals Reconciliation will take as the equivalent to being blank.  Common words might include "N/A" , "NONE", "NA", and "BLANK".  Any value that Disposals Reconciliation encounters that matches any one of the words or phrases contained in this comma-separated list will be considered the same as a blank value and will be ignored.  Disposals Reconciliation follows the business rules set up for the Disposal Itemsscreen.  Those items that have been marked as required will cause an exception if any of the blank phrases defined in this setting are encountered (as well as if the input value is blank).

DisposalItemColumnCheckDups

The column name, from the ATdataDisposalItems table, to be used to check for duplicate records.  If two or more records contain matching values in this column, and those matching values are not one of the blank phrases defined by DisposalBlankPhrases, then all matching records will be marked as duplicates of each other and recorded in the job log as such.

DisposalItemOnlyRecordSource

A comma separated list of names that are to be compared to the RecordSource field of the disposal staging data.  If a record source for a record matches an item in the list, the data is assumed to contain only Disposal Item data and no disposal information.  If a record source for is not in the list, the Disposals Reconciliation process will assume there is a disposal associated with the record and attempt to update that disposal record.  If no disposal record exists for those items whose RecordSource value is not contained in this setting, the staging record will be marked with a RECONCILEDSTATUS of 'Exception'.

DisposalToStagingWhereClause

Defines which disposal staging records will also be copied to the main asset staging table for normal Consolidation.

DisposalAutoCreateDisposals

Determines if the Reconciliation routine should run in Initial Data load mode.  -1 turns the mode on.  0 turns the mode off and runs reconciliation normally.

DisposalOrderItemAltJoinField

The name of the field to be used to join the Disposal Items table to the Disposals table in order to automatically assign items that come in during subsequent feeds to the correct order.  By default, the RMA number field is used.  Only change this setting if you plan to use a different number to identify disposal orders.  This setting is mainly used to allow the reconciliation engine to re-assign items to different orders than the ones they were originally assigned to, instead of marking those items as exceptions.  If this setting is left blank, and an item is reported in a feed that has not been assigned to an order, or assigned to a different order than the one presented in the feed, that item will be marked as an exception.