Supported Tables
ASSIGNMENT_INSURANCE_PLAN_ENROLLMENT
ASSIGNMENT_INSURANCE_PLAN_ENROLLMENT_CF
The above tables have unsupported fields. See Supported Fields and Special Rules for a list of unsupported fields.
Supported Fields and Special Rules
The following table contains details about every field/column in the tables available to the import file.
TABLE: ASSIGNMENT_INSURANCE_PLAN_ENROLLMENT
Supported Fields
Field Mapping
|
Format
|
Length
|
Req'd
|
Field Rule(s)
|
ENROLLMENT_DATE
|
Date
|
8
|
|
|
CURRENT_ENROLLMENT_END_DATE
|
Date
|
8
|
|
|
PREMIUMS_PAID_TO
|
Text
|
50
|
|
Supply the value in the DISPLAY_VALUE column of the CLASSIFICATION table for group code EQINPD
|
NAMES_OF_INSURED
|
Text
|
255
|
|
|
Fields that Will Be Populated but Not Imported
Field Mapping
|
ID
|
ASSIGNMENT_ID
|
COMPANY_INSURANCE_PROVIDER_GROUP_PLAN_ID
|
CREATE_DATE
|
CREATE_BY
|
LAST_UPDATE_DATE
|
LAST_UPDATE_BY
|
Fields that Will Not Be Imported
Field Mapping
|
LOCKED
|
LOCKED_SOURCE
|
LOCKED_DATE
|
LOCKED_BY
|