|
Spreadsheet Column
|
Variable
|
Data Type
|
Data Length or
Format
|
Notes |
Required Field
|
|
A
|
STATE
|
Alphanumeric
|
2
|
Must be a valid
state abbreviation. |
Yes
|
|
B
|
1st POLICY PERIOD LOSS AMOUNT
|
Currency or Real
|
Up to 15 digits to
the left of the decimal point; 2 digits to the right.
|
|
No*
|
|
C
|
2nd POLICY PERIOD LOSS AMOUNT
|
Currency or Real
|
Up to 15 digits to
the left of the decimal point; 2 digits to the right.
|
|
No*
|
|
D
|
3rd POLICY PERIOD LOSS AMOUNT
|
Currency or Real
|
Up to 15 digits to
the left of the decimal point; 2 digits to the right.
|
|
No*
|
|
E
|
4th POLICY PERIOD LOSS AMOUNT
|
Currency or Real
|
Up to 15 digits to
the left of the decimal point; 2 digits to the right.
|
|
No*
|
|
*All Policy Period amounts are not required, however at least one Policy Period must have a valid amount in order for that row to be imported.
|
|
F
|
IJ VALUE
|
Alphanumeric
|
5
|
Type 6 medical
losses must be specified; other indicators are optional. |
No
|
|
The IJ VALUE column should be formatted
as text. If the values in this column are keyed into Excel,
they should be preceded with the ' character.
|
|
G
|
1st POLICY PERIOD LOSS NUMBER
|
Integer |
|
|
No |
|
H
|
2nd POLICY PERIOD LOSS NUMBER |
Integer
|
|
|
No |
|
I
|
3rd POLICY PERIOD LOSS NUMBER
|
Integer |
|
|
No |
|
J
|
4th POLICY PERIOD LOSS NUMBER |
Integer |
|
|
No |
