Confirmation Report DB Export

Confirmation Report - presented in a database export delimited format. The file naming convention is as follows: excel_conf.insurer name.MMDDYYYY.#### (take the FR file name, strip off the FR and add “excel_conf.insurer name”). Field alignment listed below.

Column                          Name                                   Description
A                                   WCBN                                WC claim key
B                                    UIAN                                  State of Maine, Employer Id
C                                    Employee First Name
D                                    Employee Middle Init
E                                    Employee Last Name
F                                    SSN                                    Social Security #
G                                   Injury Date
H                                   Action taken                        Created / Updated
I                                    Insurer File #                        Item # 21 on the WCB-1 form

1. Columns are delimited by “^”.
2. SSN doesn’t contain “-“ i.e. has a format of “999999999”
3. Injury date contains “/”
4. Insurer File # : is field # 21 on the WCB-1 Claim form.