DPS Upload Process Notes

Omitting Fields

If
Name Type
is omitted in the system, the first name on the list will automatically be entered as a “mn” (main name) and all other names will automatically be entered as an
AKA
(also known as).
To ensure the correct name type is always assigned:
  1. Use the
    Name Type
    field in either the
    Gray List Entities
    tab or the exported spreadsheet.

Editing Records

Any changes to an entity, no matter how small, will return the entity status to
Pending
.
When you submit the entity to
Content
, the entity will be treated like a new entity and not screened against until the changes have been committed to
Content
and updated within the
Content
database.

Adding an Empty Sheet with Only New Records

The export spreadsheet can also be used as a template for adding new entities. However, it is very important that you confirm that none of the Entity IDs used by the new entities belong to an entity (or entities) already within the
Gray List
.
If you accidentally upload an Entity ID that already exists in the DPS system, all of the existing entity’s data will be replaced with the new data from the spreadsheet.
As a result, you cannot add a second name or alias to an existing entity by uploading a new spreadsheet with only the changes. The full details for the entity must be uploaded.

Deleting Entities

Entities cannot be deleted. As stated above, the
Content
status will always be set to
Active
when uploading spreadsheets.
Expiring entities will need to be changed manually through the
Gray List Management
screen and not with the exported spreadsheet.

Related Content