Professional EDP

The Package is the EDD data that have been converted into the EQuIS data structure (tables and fields) before they are committed to the database. Once any errors have been resolved in the dataset, a package can be created. The Create package step must be done prior to the Commit package step.

During package creation, all of the data are checked against the business rules that are included in the selected format file, and then configured into the EQuIS data table format. The data are not placed into the database however, at this step the EBATCH is created and a record added to ST_EDD_BATCH. During the Create step, data are placed into the Database/Facility Preview Tab for review. This ensures that the data were placed into the EQuIS table structure as required. A review of the Database/Facility Preview Tab is recommended each time a package is created.

A Please Wait window appears while the package is being created. The processing screens for "Create" and "Commit" will display "Create" and "Commit" respectively. The package can be canceled at any time while EDP is still processing by clicking the Cancel button. Canceling the package will stop EDP from processing any more rows in the format tab

Processed data without errors are not placed into the database. They are placed into the Database/Facility Preview Tab for review. This ensures that the data were placed into the EQuIS table structure as required. Processed rows with errors will be left in the Format Tab. A review of the Database/Facility Preview Tab is recommended each time a package is created.

Notes/Tips:

•It is possible to set the option for EDDs to be "saved" (or not) during the Create step using the SaveOnCreate setting available in the EDP File Menu/Backstage Options. The options include: "Ask", "Don't Ask" or "Always Save".

•When saving a package in EDP Professional, the server, database and format name have been included to prevent the package from being loaded to a different server, database or format.

•Errors when Committing Data: In the event that an error occurs at the Create or Commit step in Enterprise EDP, only the Administrator for that workflow Agent (in EDP, also referred to as the FileProcess) is notified. The administrator is determined by looking in ST_SERVICE_RESERVATION.USER_ID for the FileProcess agent. That USER_ID value is then joined to the ST_USER table to find the user account (i.e. the administrator for that workflow agent).

The data submitter (and others subscribed) will only see the "accept" notice or "reject" notice if the data either passes or if there are errors with the data in the EDD itself. The data submitter (and others subscribed) are not notified of create or commit errors, because they are related to either the format or the database and technically not the submitters responsibility.

•EDP errors may be viewed in the create dialog. If the error is not completely visible, a horizontal scroll bar will appear, allowing the error to be read in its entirety.

•Evaluate Non-Primary Key Fields: A feature is available that compares the EDD row with the package row during the create step. If any of the values are different between the two rows, an error will show in the progress log. By default, this feature will show the error, but will continue processing the rest of the mappings for the row. By adding a record to ST_CONFIG, this feature can be turned off or changed to stop processing the rest of the row mappings when a difference is found. The structure of the ST_CONFIG record and additional information on the setting can be found on the EarthSoft.EDP.EddMapping.RowDifferenceError page.

EarthSoft_EDP.Forms.EddProcessor

Professional EDP – Create

Professional EDP – Create