More information

Advanced Data Examiner

Tools World

Advanced Data Examiner Review Process for Employment

When Employment pending data is reviewed manually, a Data Review page will display for each Employment pending data row. If the pending Employment row is loaded into the ADE as a new data row to insert into Millennium, you will have the opportunity to either insert a new Employment row, update a constituent's existing Employment row, or Update/Archive a constituent's existing Employment row. If the pending Employment row is loaded into the ADE as an update to an existing Employment row instead, you can Update, or Update/Archive that same Employment record. Or, you will have the opportunity to Update or Update/Archive a different Employment record that exists for a constituent.

The Data Review Page for Employment

Each Employment Data Review page includes a Constituent Header, Page Header, Existing Employment display area, a series of action buttons, and the Grid Chart.

Constituent Header

The header that displays when viewing a constituent's data in the Profiles World will display here.

Page Header

The Page header displays Employment. If the row is loaded into the ADE as new pending Employment row, the word Insert will display. If the pending row is loaded into the ADE as a potential edit to an existing Millennium Employment row, the word Update will display instead. If the row is loaded as a deletion of an existing Millennium Employment row, the word Delete will display. The header will also display the pending data Source that you selected to load.

Existing Employment Display

The constituent's existing Employment rows will display in Short display mode. An Edit button is located to the left of each Employment row. This button accesses a menu with three items - Archive this Employment, Update this Employment, and Close menu.

Action Buttons

Action buttons will display above and below the Grid Chart.

Accept

The Accept button displays only if you have accessed the Data Review page by using the Manually Update hyperlink. It is used to tell to the system that you agree to update an existing Millennium data with the edits or that you agree to insert a new data row into Millennium or that you agree to permanently remove (delete) an existing row from Millennium. When you click Accept, you are accepting the database changes that have been 'proposed' by the pending data and you are accepting any changes that you make to this pending data during the review process.

Archive

The Archive button displays if you have accessed the Data Review page by using the Manually Update/Archive hyperlink and if the Employment pending row is loaded into the ADE as an update to an existing Employment row. It is used to tell the system to archive the Employment row that is displayed in the Current Data column, and then create a new Employment row, using the information as shown in the Pending Data column.

The Archive button will also display if you have accessed the Data Review page by using Manually Update and you then select, from the Edit Button located to the left of an existing Employment row, the Archive this Employment menu item.

Skip

The Skip button is used to tell the system to bypass the displayed set of pending data and keep it in the pending tables so that it can be reviewed later. When you click Skip, the data that you are reviewing now is returned to the pending table. The current data in both the pending table and Millennium data table remains unchanged. Changes that you may have made to the data as shown in the data review display before Skip is clicked will not be saved. The system will automatically display the next Employment pending data row.

Delete

The Delete button is used to remove the displayed pending data from the pending table.

Cancel

The Cancel button is used to cancel the data review process and return to the Data Summary page. The current data in both the pending table and Millennium data table will not change. Changes that you may have made to the data as shown in the data review display before Cancel is clicked will not be saved.

Grid Chart

If the displayed Employment pending data row is loaded into the ADE as a row to be inserted into the Millennium database, the Grid Chart will display two columns. If the Employment pending data row is loaded into the ADE as an update to an existing Millennium data row, the Grid Chart will display three columns instead.

Field Name

The first column lists the aliases (pulled from the field_alias field in the fieldlst system table) for each field in the data table. System-generated fields will not be listed, however (for example, namekey). If the pending row is loaded into the ADE as an update and the pending data for a field differs from the data as it now exists in Millennium, the field name will be shown in your highlight color. This will allow you to readily scan the list of field names and focus on the data that needs to be reviewed.

Current Data/Current Data to Delete/Pending Data to Insert

The label for the second column will vary depending on how the data row is loaded into the ADE.

It will be labeled Current Data if the pending row is loaded as an update to an existing Millennium data row. The column will display, for each data field, the data as it currently exists in Millennium. If the pending data row has information in that field, and the pending row data differs from the Millennium data, then the current data will be displayed in your highlight color.

It will be labeled Current Data to Delete if the pending row is loaded into the ADE as a deletion of an existing Millennium data row. The column will show, in your highlight color, all of the information in the 'about to be deleted' row. A pending row is loaded into the ADE as a deletion when a constituent deletes an existing data row by using the Online Constituent Directory, or when a Soft Edit user deletes an existing data row.

It will be labeled Pending Data to Insert if the pending row is loaded into the ADE as an insert. The column will show all of the information that will be inserted into each field. Some of the information that is shown may have been created by the constituent via the Online Constituent Directory, the ADE Import Tool, or the Soft Edit user, and some of the information may be data from the Default Insert/Update form that is defined for this pending table.

Pending Data

The Pending Data column will be shown only if the pending table row is loaded into the ADE as an update to an existing Millennium data row. It shows the information that is present in the pending table row for each data field. If information already exists for a data field in the existing Millennium data row, and if there is no information*** for that data field in the pending table row, the existing information will also display in this third column. If the information in the pending row is blank (for string or date fields) or 0 (for money or number fields), then a blank or a 0 will display in this third column. Information will be shown in text boxes, check boxes, or drop-list boxes. You are free to edit any of this information before you accept it into the actual Millennium data table.

***No information, here, means that the data field is NULL. For pending rows that result from Online Constituent Directory changes, a field will be NULL if that field is not displayed on the Online Constituent Directory website. For pending rows that are imported from the Advanced Data Examiner Import Tool, a field will be NULL if that field is not mapped for import.

Processing Employment Pending Data

When the ADE Updates an existing Employment row, it will follow the same rules that Millennium does when it Updates an existing Employment row using standard data maintenance procedures, except for the way that it handles Addresses linked to the Employment row. The ADE will automatically change the Address Locator to Former, the Address Type to the Former version for that Type (for example, Business is changed to Former Business) and will set the Address Stop Date to the Employment row's Stop Date.

When the ADE Update/Archives an existing Employment row, it will follow the same rules that Millennium does when it Updates/Archives existing Employment rows through standard data maintenance procedures.

Manually Process Employment Pending Data

Manually Update

Common Steps

  1. Access the Data Summary page by using Millennium Explorer, Tools > Data Examiner > Examiner.
  2. If you want to load all pending data rows for processing, verify that the Import Source is set to All Source Values. If you want to load only the pending data rows from a particular source, then click the desired source name in the Import Source list.
  3. Locate the Employment row.
  4. Click the Manually Update hyperlink. The Employment Data Review page for the first pending row will display.

CASE 1 The Employment row is loaded as data to Insert.

To use the pending data to create a new Employment row in Millennium:

  1. Make changes, as you choose, to the data as shown in the Pending Data to Insert column.
  2. Click Accept. In addition to the information that is shown in the Pending Data to Insert column, the new data row will be created with all of the standard, system-generated information such as Create Date and User ID. Or click Delete to remove the row from the pending table, and move on to the next row. Or, click Skip to save the pending data row for review at a later time, and move on to the next row. Any changes that you may have made to the data in the Pending Data to Insert column will not be saved.

CASE 2 The Employment row is loaded as data to Insert.

To use the pending data to update one of the constituent's existing Employment rows:

  1. In the Existing Employment display area, point to or click the Edit Button edit button located to the left of the desired Employment row.
  2. Click Update this Employment.
  3. The Grid Chart now shows three columns. Make changes, as you choose, to the data as shown in the Pending Data column.

  4. Click Accept to update the chosen Employment row with the changes. Or click Delete to remove the row from the pending table, and move on to the next row. Or, click Skip to save the pending data row for review at a later time, and move on to the next row.

    Important! If you click Skip, or if you click Cancel to return to the Data Summary page, or if you leave the display of this data row before you click Accept, then the changes, if any, that you have made in the Pending Data column will not be saved. But, the pending data row will remain linked to the existing Employment row that you have chosen to update. The next time that this data row is reviewed, it will be loaded into the ADE as an update to this existing Employment row!

CASE 3 The Employment row is loaded as data to Insert.

To use the pending data to Update/Archive one of the constituent's existing Employment rows:

  1. In the Existing Employment display area, point to or click the Edit Button edit button located to the left of the desired Employment row.
  2. Click Archive this Employment.
  3. The Grid Chart now shows three columns. Make changes, as you choose to the data as shown in the Pending Data column.

  4. Click Archive to archive the chosen Employment row and create a new Employment row with the information that displays in the Pending Data column. Or click Delete to remove the row from the pending table, and move on to the next row. Or, click Skip to save the pending data row for review at a later time, and move on to the next row.

    Important! If you click Skip, or if you click Cancel to return to the Data Summary page, or if you leave the display of this data row before you click Archive, then the changes, if any, that you have made in the Pending Data column will not be saved. But, the pending data row will remain linked to the existing Employment row that you have just chosen to update. The next time that this data row is reviewed, it will be loaded into the ADE as an update to this existing Employment row!

CASE 4 The pending Employment row is loaded as an Update to an existing Employment row.

To use the pending data to Update the same existing Employment row:

  1. If there is no difference between the existing row and the pending row, click Delete. This will remove the row from the pending table and move on to the next pending row.
  2. If there are differences between the two, they will display in your highlight color. Make changes, as you choose, to the data as shown in the Pending Data column.
  3. Click Accept to update the Employment row with the changes. Or click Delete to remove the row from the pending table, and move on to the next row. Or, click Skip to save the pending data row for review at a later time, and move on to the next row. Any changes that you may have made to the data in the Pending Data to Insert column will not be saved.

CASE 5 The pending Employment row is loaded as an Update to an existing Employment row.

To use the pending data to Update/Archive the same existing Employment row:

  1. The same Employment row will be listed in the Existing Employment display area. Point to or click the Edit Button edit button located to the left of this Employment row.
  2. Click Archive this Employment.
  3. Make changes, as you choose, to the data as shown in the Pending Data column.
  4. Click Archive to archive the Employment row and create a new Employment row with the information that displays in the Pending Data column. Or click Delete to remove the row from the pending table, and move on to the next row. Or, click Skip to save the pending data row for review at a later time, and move on to the next row. Any changes that you made to the data shown in the Pending Data column will not be saved.

CASE 6 The pending Employment row is loaded as an Update to an existing Employment row.

To use the pending data to Update a different existing Employment row for the constituent:

  1. In the Existing Employment display area, point to or click the Edit Button edit button located to the left of the desired Employment row.
  2. Click Update this Employment.
  3. Make changes, as you choose, to the data as shown in the Pending Data column.

  4. Click Accept to update the chosen Employment row with the changes. Or click Delete to remove the row from the pending table, and move on to the next row. Or, click Skip to save the pending data row for review at a later time, and move on to the next row.

    Important! If you click Skip, or if you click Cancel to return to the Data Summary page, or if you leave the display of this data row before you click Accept, then the changes, if any, that you have made in the Pending Data column will not be saved. But, the pending data row will remain linked to the existing Employment row that you just chose to update. The next time that this data row is reviewed, it will be loaded into the ADE as an update to this existing Employment row instead of the Employment row that it was originally intended to update!

CASE 7 The pending Employment row is loaded as an Update to an existing Employment row.

To use the pending data to Update/Archive a different existing Employment for the constituent:

  1. In the Existing Employment display area, point to or click the Edit Button edit button located to the left of the desired Employment row.
  2. Click Archive this Employment.
  3. Make changes, as you choose, to the data as shown in the Pending Data column.

  4. Click Archive to archive the chosen Employment row and create a new Employment row with the information that displays in the Pending Data column. Or click Delete to remove the row from the pending table, and move on to the next row. Or, click Skip to save the pending data row for review at a later time, and move on to the next row.

    Important! If you click Skip, or if you click Cancel to return to the Data Summary page, or if you leave the display of this data row before you click Archive, then the changes, if any, that you have made in the Pending Data column will not be saved. But, the pending data row will remain linked to the existing Employment row that you have just chosen to archive. The next time that this data row is reviewed, it will be loaded into the ADE as an update to this existing Employment row instead of the Employment row that it was originally intended to update!

CASE 8 The pending Employment row is loaded as data to delete from Millennium.

To use the pending data to delete a data row from Millennium:

  1. Review the data to be certain that you want to permanently delete it.
  2. Click Accept to delete the row from the Millennium data table. Or, click Delete to remove the row from the pending table and move on to the next row. Clicking Delete will not remove the row from the Jobs data table, just from the Jobs pending table. Or, click Skip to save the pending data row for review at a later time, and move on to the next row.

Manually Update/Archive

Common Steps

  1. Access the Data Summary page by using Millennium Explorer, Tools > Data Examiner > Examiner.
  2. If you want to load all pending data rows for processing, verify that the Import Source is set to All Source Values. If you want to load only the pending data rows from a particular source, then click the desired source name in the Import Source list.
  3. Locate the Employment row.
  4. Click the Manually Update/Archive hyperlink. The Employment Data Review page for the first pending row will display.

CASE 1 The Employment row is loaded as data to Insert.

To use the pending data to create a new Employment row in Millennium:

  1. Make changes, as you choose, to the data as shown in the Pending Data to Insert column.
  2. Click Accept. In addition to the information that is shown in the Pending Data to Insert column, the new data row will be created with all of the standard, system-generated information such as Create Date and User ID. Or click Delete to remove the row from the pending table, and move on to the next row. Or, click Skip to save the pending data row for review at a later time, and move on to the next row. Any changes that you may have made to the data in the Pending Data to Insert column will not be saved.

CASE 2 The Employment row is loaded as data to Insert.

To use the pending data to Update/Archive one of the constituent's existing Employment rows:

  1. In the Existing Employment display area, point to or click the Edit Button edit button located to the left of the desired Employment row.
  2. Click Archive this Employment.
  3. The Grid Chart now shows three columns. Make changes, as you choose to the data as shown in the Pending Data column.

  4. Click Archive to archive the chosen Employment row and create a new Employment row with the information that displays in the Pending Data column. Or click Delete to remove the row from the pending table, and move on to the next row. Or, click Skip to save the pending data row for review at a later time, and move on to the next row.

    Important! If you click Skip, or if you click Cancel to return to the Data Summary page, or if you leave the display of this data row before you click Archive, then the changes, if any, that you have made in the Pending Data column will not be saved. But, the pending data row will remain linked to the existing Employment row that you have just chosen to update. The next time that this data row is reviewed, it will be loaded into the ADE as an update to this existing Employment row!

CASE 3 The Employment row is loaded as data to Insert.

To use the pending data to Update one of the constituent's existing Employment rows:

  1. In the Existing Employment display area, point to or click the Edit Button edit button located to the left of the desired Employment row.
  2. Click Update this Employment.
  3. The Grid Chart now shows three columns. Make changes, as you choose, to the data as shown in the Pending Data column.

  4. Click Accept to update the chosen Employment row with the changes. Or click Delete to remove the row from the pending table, and move on to the next row. Or, click Skip to save the pending data row for review at a later time, and move on to the next row.

    Important! If you click Skip, or if you click Cancel to return to the Data Summary page, or if you leave the display of this data row before you click Accept, then the changes, if any, that you have made in the Pending Data column will not be saved. But, the pending data row will remain linked to the existing Employment row that you have just chosen to update. The next time that this data row is reviewed, it will be loaded into the ADE as an update to this existing Employment row!

CASE 4 The pending Employment row is loaded as an Update to an existing Employment row.

To use the pending data to Update/Archive the same existing Employment row:

  1. If there is no difference between the existing row and the pending row, click Delete. This will remove the row from the pending table and move on to the next pending row.
  2. If there are differences between the two, they will display in your highlight color. Make changes, as you choose, to the data as shown in the Pending Data column.
  3. Click Archive to archive the Employment row and create a new Employment row with the information that displays in the Pending Data column. Or click Delete to remove the row from the pending table, and move on to the next row. Or, click Skip to save the pending data row for review at a later time, and move on to the next row. Any changes that you may have made to the data in the Pending Data to Insert column will not be saved.

CASE 5 The pending Employment row is loaded as an Update to an existing Employment row.

To use the pending data to Update the same existing Employment row:

  1. The same Employment row will be listed in the Existing Employment display area. Point to or click the Edit Button edit button located to the left of this Employment row.
  2. Click Update this Employment.
  3. Make changes, as you choose, to the data as shown in the Pending Data column.
  4. Click Update to update the Employment row with the changes. Or click Delete to remove the row from the pending table, and move on to the next row. Or, click Skip to save the pending data row for review at a later time, and move on to the next row. Any changes that you made to the data shown in the Pending Data column will not be saved.

CASE 6 The pending Employment row is loaded as an Update to an existing Employment row.

To use the pending data to Update/Archive a different existing Employment row for the constituent:

  1. In the Existing Employment display area, point to or click the Edit Button edit button located to the left of the desired Employment row.
  2. Click Archive this Employment.
  3. Make changes, as you choose, to the data as shown in the Pending Data column.

  4. Click Archive to archive the chosen Employment row and create a new Employment row with the information that displays in the Pending Data column. Or click Delete to remove the row from the pending table, and move on to the next row. Or, click Skip to save the pending data row for review at a later time, and move on to the next row.

    Important! If you click Skip, or if you click Cancel to return to the Data Summary page, or if you leave the display of this data row before you click Archive, then the changes, if any, that you have made in the Pending Data column will not be saved. But, the pending data row will remain linked to the existing Employment row that you have just chosen to archive. The next time that this data row is reviewed, it will be loaded into the ADE as an update to this existing Employment row instead of the Employment row that it was originally intended to update!

CASE 7 The pending Employment row is loaded as an Update to an existing Employment row.

To use the pending data to Update a different existing Employment row for the constituent:

  1. In the Existing Employment display area, point to or click the Edit Button edit button located to the left of the desired Employment row.
  2. Click Update this Employment.
  3. Make changes, as you choose, to the data as shown in the Pending Data column.

  4. Click Accept to update the chosen Employment row with the changes. Or click Delete to remove the row from the pending table, and move on to the next row. Or, click Skip to save the pending data row for review at a later time, and move on to the next row.

    Important! If you click Skip, or if you click Cancel to return to the Data Summary page, or if you leave the display of this data row before you click Accept, then the changes, if any, that you have made in the Pending Data column will not be saved. But, the pending data row will remain linked to the existing Employment row that you just chose to update. The next time that this data row is reviewed, it will be loaded into the ADE as an update to this existing Employment row instead of the Employment row that it was originally intended to update!

CASE 8 The pending Employment row is loaded as data to delete from Millennium:

To use the pending data to delete a data row from Millennium:

  1. Review the data to be certain that you want to permanently delete it.
  2. Click Accept to delete the row from the Millennium data table. Or, click Delete to remove the row from the pending table and move on to the next row. Clicking Delete will not remove the row from the Jobs data table, just from the Jobs pending table. Or, click Skip to save the pending data row for review at a later time, and move on to the next row.

Automatically Process Employment Pending Data

Automatic Update

The Automatic Update procedures for reviewing Employment pending rows are identical to the general Automatic Update procedures.

Automatic Update/Archive

The Automatic Update/Archive procedures for reviewing Employment pending rows will follow the general Automatic Update procedures, with one exception. If a pending row is loaded into the ADE as an Update to an existing Employment row, the existing Employment will be archived, and the pending information will be used to create a new Employment row in Millennium.

Automatic Update All

If either the Automatically Update All Data or the Automatically Update All Bio Data hyperlink is clicked, then pending Employment rows will be included. You will have the opportunity to choose whether you want to process pending Employment rows as Update, or Update/Archive.

Top of Page