New Time and Labor Query – M_TL_EXCEPTIONS_CHARTSTRING

posted Mar 6, 2019, 7:21 AM by Barbara Thiss
New

The new M_TL_EXCEPTIONS_CHARTSTRING query is based off of the existing M_TL_EXCEPTIONS query with several additional fields added to provide greater detail. The Position #, Position Description and chart string fields (Fund, Resource, Goal, Function, Object, Site and Operating Unit) are now present. When the exception is for an “Invalid Combo Code” it will display the appropriate chart string values for the combo code selected, if it exists on the Account Code table. Please note that the run time for this query has increased as a result of the additional fields.

M_TL_EXCEPTIONS_CHARTSTRING query results