Deceased Table

Field Name

Description

Length

Data Type

Parent Table and Field

Import Types

AccountID

Code that Latitude assigned to identify the account. For new business imports, don't map this field. For maintenance imports, you must map this field to ensure that Exchange Manager locates the correct account.

4

Integer

Master/Number

NB, M

DebtorID

Code that Latitude assigned to identify the deceased customer. If you selected "Debtor ID" as the unique customer criteria.

4

Integer

Debtors/DebtorID

NB, M

Seq

Code that indicates whether the customer is the primary or secondary customer on the account. If you selected "Seq" as the unique customer criteria, you must map this field.

0 = Primary customer
1 or greater = Secondary customer

4

Integer

Debtors/Seq

NB, M

Relationship

Customer's relationship to the account. If you selected "Relationship" as the unique customer criteria, you must map this field.

30

VarChar

Debtors/Relationship

NB, M

Name

Customer name. If you selected "Name" as the unique customer criteria, you must map this field.

300

VarChar

Debtors/Name

NB, M

FirstName

Deceased person’s first name.

30

VarChar

Debtors/Firstname

NB, M

LastName

Deceased person’s last name.

30

VarChar

Debtors/Lastname

NB, M

State

Deceased person’s state of residence.

3

VarChar

Debtors/State

NB, M

PostalCode

Deceased person’s ZIP Code.

10

VarChar

Debtors/Zipcode

NB, M

SSN

Deceased person’s social security number. If you selected "SSN" as the unique customer criteria, you must map this field.

15

VarChar

Debtors/SSN

NB, M

DOB

Deceased person’s date of birth.

8

DateTime

Debtors/DOB

NB, M

DOD

Deceased person’s date of death.

8

DateTime

None

NB, M

MatchCode

Code returned from the vendor that indicates what the system matched on the Deceased scrub. For example, "NAS" means the vendor matched to the deceased customer's name, address, and SSN.

5

VarChar

None

NB, M

TransmittedDate

Date AIM or another interface transmitted the data. If you map to this field, the system doesn't populate it in the table unless you also map AIM information in Exchange.

4

SmallDate

None

NB, M

CaseNumber

Claim case number.

20

VarChar

None

NB, M

ClaimDeadline

Deadline for filing a claim against the customer's estate.

8

DateTime

None

NB, M

CourtCity

Court's city.

50

VarChar

None

NB, M

CourtDistrict

Court district.

200

VarChar

None

NB, M

CourtDivision

Court division.

100

VarChar

None

NB, M

CourtPhone

Court's phone number.

50

VarChar

None

NB, M

CourtState

Court's state.

3

VarChar

None

NB, M

CourtStreet1

Court's street address line 1.

128

VarChar

None

NB, M

CourtStreet2

Court's street address line 2.

128

VarChar

None

NB, M

CourtZIPCode

Court's ZIP Code.

15

VarChar

None

NB, M

CTL

Not used.

3

VarChar

None

NB, M

DateFiled

Date the client filed a claim against the customer's estate.

8

DateTime

None

NB, M

Executor

Name of the executor of the estate.

50

VarChar

None

NB, M

ExecutorCity

Executor of the estate's city.

100

VarChar

None

NB, M

ExecutorFax

Executor of the estate's fax number.

50

VarChar

None

NB, M

ExecutorPhone

Executor of the estate's phone number.

50

VarChar

None

NB, M

ExecutorState

Executor of the estate's state of residence.

3

VarChar

None

NB, M

ExecutorStreet1

Executor of the estate's street address line 1.

128

VarChar

None

NB, M

ExecutorStreet2

Executor of the estate's street address line 2.

128

VarChar

None

NB, M

ExecutorZIPCode

Executor of the estate's ZIP Code.

10

VarChar

None

NB, M