Insurance Table

Field Name

Description

Length

Data Type

Parent Table and Field

Import Types

Number

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

InsuredName

Insured person's name.

50

VarChar

None

NB, M

InsuredStreet1

Insured person's street address line 1.

128

VarChar

None

NB, M

InsuredStreet2

Insured person's street address line 2.

128

VarChar

None

NB, M

InsuredCity

Insured person's city.

50

VarChar

None

NB, M

InsuredState

Insured person's state.

3

Char

None

NB, M

InsuredZIP

Insured person's ZIP Code.

10

Char

None

NB, M

InsuredPhone

Insured person's phone number.

20

Char

None

NB, M

InsuredBirthday

Insured person's date of birth.

8

DateTime

None

NB, M

InsuredSex

Insured person's gender.

1

Char

None

NB, M

InsuredEmployer

Name of the insured person's employer.

50

VarChar

None

NB, M

AuthPmtToProvider

Flag that indicates whether the insurance provider authorized payments to the healthcare provider.
1 = Yes
0 = No

1

Bit

None

NB, M

AcceptAssignment

Flag that indicates whether the healthcare provider accepted assignment from the insurance provider.

1 = Yes
0 = No

1

Bit

None

NB, M

EmployerHealthPlan

Name of the employer's health plan.

50

VarChar

None

NB, M

PolicyNumber

Insurance policy number.

50

VarChar

None

NB, M

PatientRelationToInsured

Patient's relationship to the insured.

50

VarChar

None

NB, M

Program

Insurance program name.

50

VarChar

None

NB, M

GroupNumber

Insurance group number.

50

VarChar

None

NB, M

GroupName

Insurance group name.

50

VarChar

None

NB, M

CarrierName

Name of the person's insurance carrier.

100

VarChar

None

NB, M

CarrierStreet1

Insurance carrier's street address line 1.

128

VarChar

None

NB, M

CarrierStreet2

Insurance carrier's street address line 2.

128

VarChar

None

NB, M

CarrierCity

Insurance carrier's city.

50

VarChar

None

NB, M

CarrierState

Insurance carrier's state.

3

Char

None

NB, M

CarrierZIP

Insurance carrier's ZIP Code.

10

Char

None

NB, M

CarrierDocProviderNumber

Number the insurance carrier assigned to identify a provider.

30

VarChar

None

NB, M

CarrierRefDocProviderNumber

Number the insurance carrier assigned to identify the referring provider.

30

VarChar

None

NB, M

AdditionalInfo

More information about the case.

5000

VarChar

None

NB, M

DateCreated

Date the user added the insurance information.

8

DateTime

None

NB, M

DateUpdated

Date the user updated the insurance information.

8

DateTime

None

NB, M

UpdatedCheckSum

Update control.

50

VarChar

None

NB, M

UpdatedBy

Code that identifies the user who updated the insurance record in Latitude.

4

Integer

None

NB, M

CoordinationNumber

Number that identifies the health insurance plan when a patient has more than one (for example, a primary and secondary healthcare plan).

50

VarChar

None

NB, M

InsuredWorkPhone

Insured person's work phone number.

20

VarChar

None

NB, M

InsuredSSN

Insured person's social security number.

15

VarChar

None

NB, M

Category

Type of insurance (for example, primary or secondary).

15

VarChar

None

NB, M