|
NCCI and NJ Import Specifications
The user should prepare
three files in Microsoft Excel 97-2003 format for importing NCCI-type or
NJ data into
ModMaster:
Optionally, the user
can prepare loss and/or payroll files following the specifications below
and manually create the file and enter Setup Data in ModMaster, then
import payroll and/or loss information directly from the Import option
on the toolbars of the Payroll and Large Loss screens. This method is
most useful if you have obtained some data from an automated source but
also need to manually enter data, or if you have an existing file that
you want to append imported data to.
File
1, the setup file, will contain policy information (see
setup file specification).
It can optionally have a file name extension of ".set" for compatibility
with prior versions of ModMaster.
File 2, the payroll file,
will contain payroll information (see payroll file
specification). It can optionally
have a file name extension of ".pay" for compatibility with prior
versions of ModMaster.
File 3, the loss file,
will contain itemized loss information (see loss file
specification). It can
optionally have a file name extension of ".lss" for compatibility
with prior versions of ModMaster.
The setup
file has the following specifications. Note that this file should contain
only one row of data.
Sample setup
file for NCCI method
Sample
setup file for NJ method
|
Spreadsheet Column
|
Variable
|
Data Type
|
Data Length or
Format
|
Notes
|
|
A
|
SHORT ID
|
Alphanumeric (Excel
text format)
|
64
|
|
|
B
|
FIRM NAME
|
Alphanumeric
(Excel text format)
|
64
|
|
|
C
|
EFFECTIVE DATE
|
Date
|
M/D/YYYY (in any
valid Excel date format)
|
|
|
D
|
CONTROL #
|
Alphanumeric
(Excel text format)
|
12
|
|
|
E
|
STATE INDICATOR
|
Integer value: 1or
3
|
|
1 – NCCI
3 – NJ
(PA/DE requires a different import format)
|
|
F
|
4th POLICY #
|
Alphanumeric
|
20
|
|
|
G
|
3rd (OLDEST) POLICY
#
|
Alphanumeric
|
20
|
|
|
H
|
2nd (MIDDLE) POLICY
#
|
Alphanumeric
|
20
|
|
|
I
|
1st (MOST RECENT)
POLICY #
|
Alphanumeric
|
20
|
|
|
|
The policy # columns should be formatted
as text. If any of these values are entirely numeric and are keyed
directly into Excel, they should be preceded with the ' character.
|
|
J
|
4th POLICY PERIOD
START DATE
|
Date
|
M/D/YYYY (in any
valid Excel date format)
|
|
|
K
|
4th POLICY PERIOD
END DATE
|
Date
|
M/D/YYYY (in any
valid Excel date format)
|
|
|
L
|
3rd POLICY PERIOD
START DATE
|
Date
|
M/D/YYYY (in any
valid Excel date format)
|
|
|
M
|
3rd POLICY PERIOD
END DATE
|
Date
|
M/D/YYYY (in any
valid Excel date format)
|
|
|
N
|
2nd POLICY PERIOD
START DATE
|
Date
|
M/D/YYYY (in any
valid Excel date format)
|
|
|
O
|
2nd POLICY PERIOD
END DATE
|
Date
|
M/D/YYYY (in any
valid Excel date format)
|
|
|
P
|
1st POLICY PERIOD
START DATE
|
Date
|
M/D/YYYY (in any
valid Excel date format)
|
|
|
Q
|
1st POLICY PERIOD
END DATE
|
Date
|
M/D/YYYY (in any
valid Excel date format)
|
|
The payroll
file has the following specifications.
Sample payroll file
for NCCI method
Sample payroll file for NJ method
|
Spreadsheet Column
|
Variable
|
Data Type
|
Data Length or Format
|
Notes
|
|
A
|
STATE
|
Alphanumeric
|
2
|
Must be a valid
state abbreviation.
|
|
B
|
PAYROLL CODE
|
Alphanumeric
|
5
|
Should be 4 digits
followed by a ‘F’ as necessary.
|
|
|
The PAYROLL CODE column should be
formatted as text. If the PAYROLL CODE data is keyed directly into
Excel, it should be preceded with the ' character.
|
|
C
|
1st (MOST RECENT)
PAYROLL AMOUNT
|
Currency or Real
|
Up to 15 digits to
the left of the decimal point; 2 digits to the right.
|
|
|
D
|
2nd (MIDDLE)
PAYROLL AMOUNT
|
Currency or Real
|
Up to 15 digits to
the left of the decimal point; 2 digits to the right.
|
|
|
E
|
3rd (OLDEST)
PAYROLL AMOUNT
|
Currency or Real
|
Up to 15 digits to
the left of the decimal point; 2 digits to the right.
|
|
|
F
|
4th PAYROLL AMOUNT
|
Currency or Real
|
Up to 15 digits to
the left of the decimal point; 2 digits to the right.
|
|
The loss
data file has the following specifications. These specifications
also apply to the Import Losses option located on the Large Loss page.
Sample loss file for NCCI method
Sample loss file for NJ method
|
Spreadsheet Column
|
Variable
|
Data Type
|
Data Length or
Format
|
Notes
|
|
A
|
STATE
|
Alphanumeric
|
2
|
Must be a valid
state abbreviation.
|
|
B
|
LOSS DATE
|
Date
|
M/D/YYYY (in any
valid Excel date format)
|
|
|
C
|
LOSS AMOUNT
|
Currency or Real
|
Up to 15 digits to
the left of the decimal point; 2 digits to the right.
|
Can be 0 for NJ
calculations (total determined from fields K and L below)
|
|
D
|
CLAIM #
|
Alphanumeric
|
50
|
|
|
E
|
INJURY TYPE
|
Alphanumeric
|
50
|
|
|
F
|
SOCIAL SECURITY #
(or other loss identifier)
|
Alphanumeric
|
50
|
DO include hyphens,
if you want them to appear.
|
|
G
|
CAUSE OF LOSS
|
Alphanumeric
|
50
|
|
|
|
The CLAIM #, INJURY TYPE, SOCIAL
SECURITY # and CAUSE OF LOSS columns should be formatted as text. If
any of these values are entirely numeric and are keyed directly into
Excel, they should be preceded with the ' character.
|
|
H
|
OPEN/FINAL (NCCI
method) or
TYPE OF LOSS
(NJ)
|
Alphanumeric value
O or F
|
1
|
Indicate O for
Open, F for Final (NCCI method)
OR D for Death, P for Permanent
Disability, O for Other (NJ)
|
|
I
|
(NJ Only) Employers
Liability Claim
|
Boolean
(True/False) |
0 for FALSE/NO
-1 for TRUE/YES |
|
|
J
|
(NJ Only)
LONGSHORE &
HARBOR WORKERS LOSS?
|
Boolean
(True/False)
|
0 for FALSE/NO
-1for TRUE/YES
|
|
|
K
|
MEDICAL AMOUNT (NJ)
or
PAID LOSSES (NCCI, ERM-6 method)
|
Currency or Real
|
Up to 15 digits to
the left of the decimal point; 2 digits to the right.
|
Not required for
NCCI calculation - used when ERM-6 capability is turned on through
System Administration
|
|
L
|
INDEMNITY AMOUNT
(NJ)
or
RESERVES (NCCI, ERM-6 method)
|
Currency or Real
|
Up to 15 digits to
the left of the decimal point; 2 digits to the right.
|
Not required for
NCCI calculation - used when ERM-6 capability is turned on throughtSystem Administration
|
|
M
|
(NCCI method only)
IJ VALUE
|
Alphanumeric
|
5
|
Type 6 medical
losses must be specified; other indicators are optional.
|
|
|
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.
|
|
N
|
(NCCI method only)CLAIM METHOD
|
Alphanumeric
|
1
|
Values "a" - "e" as
indicated below
|
|
|
a = State Per Claim Accident Limitation
b = State Multiple Claim Accident Limitation
c = USL&HW Per Claim Accident Limitation
d = USL&HW Multiple Claim Accident Limitation
e = Employers Liability Accident Limitation
|
Once you have prepared
these files in the spreadsheet program of your choice, save them in
Microsoft Excel 97-2003 format. Then import them into ModMaster by using
the "Data for NCCI calculation from Excel workbook" or the
"Data for NJ calculation from Excel workbook" import
options of the Utilities/Import feature.
|
