Site Navigation

WCB Home Page
Change Font Size
Glossary of WCB Terms

Proof of Coverage Disability Benefits
DB 820/829 Flat File Transmission


Frequently Asked Questions

  1. What is a flat file and how does my company send it to the Board?
  2. Will a username and password be required for the FTP?
  3. How do I make sure my data is in the correct columns?
  4. Can we continue to send paper DB 820/829 forms and/or use the DB 820/829 Web Submission?
  5. What is an acknowledgment file and how does my company receive it from the Board?

  1. What is a flat file and how does my company send it to the Board? A flat file is a data processing format that contains form data without any presentation format. To prepare to directly upload a flat file to the Board's Web Server, the company's computer staff writes the computer programs to produce the files in the specified format and then the programs are periodically run to prepare the files containing the POC (Proof of Coverage) data, for transmission to the Board. The files are manually uploaded to the Board's Web Server using an Internet browser.
  2. Will a username and password be required for the FTP? Yes, after a file has been submitted, tested, and approved, you will be issued a username and password to FTP files in our production environment.
  3. How do I make sure my data is in the correct columns? It is imperative that your data be prepared accordingly to the specifications in the record file layout. We highly recommend the use of a software tool (editor) that allows one to examine the content of data files that contain large record sizes.
  4. Can we continue to send paper DB 820/829 forms and/or use the DB 820/829 Web Submission? Effective October 1, 2005, the Board will no longer accept paper DB-820/829 forms for statutory coverage. All transactions effecting or affecting a statutory Disability Benefits policy must be submitted to the Board via either Flat File Transmission or the web. However, any given POC transaction should only be submitted via one method. In other words, do not send us duplicate transactions across methods.
  5. What is an acknowledgment file and how does my company receive it from the Board? The DB 820/829 Acknowledgement File is generated by the Board for each DB 820/829 Flat File you send to the Board. The acknowledgement file name is identifical to the DB 820/829 flat file sent to the Board with the exception of the file extension. The acknowledgement file extension is ".ack". The acknowledgement file contains a record for every transaction included in the DB 820/829 flat file. Each record contains a transaction status indicating the acceptance or rejection of the transaction. If rejected, there is a comment field that contains the reason for the rejection.

    The acknowledgement file may be obtained from the Board by connecting to the Board's FTP server and picking up the file. The file must then be DELETED.