Loading...
Loading...
Available on 1 platform
Sign in to view source links and access this dataset
The Texas Department of Insurance, Division of Workers' Compensation maintains this database of professional medical billing services. It contains header information for bills submitted on CMS-1500 forms over the last five years, grouping charges, payments, and treatments for injured employees. The data includes identifiers for insurance carriers, employers, healthcare providers, and diagnostic codes.
The `bill selection date` and `bill ID` (likely represented by fields like `Transaction Tracking Number`) must be used to group header records with their corresponding detail line items. License terms are unspecified.
| # | Column Name |
|---|---|
| 1 | Employer FEIN |
| 2 | Facility National Provider ID |
| 3 | Release of Information Code |
| 4 | Rendering Bill Provider Middle Name Initial |
| 5 | Billing Provider Primary Address |
| 6 | Date Insurer Received Bill |
| 7 | Place of Service Bill Code |
| 8 |
| Insurer Postal Code |
| 9 | Fifth ICD-9CM or ICD-10CM Diagnosis Code |
| 10 | Employee Mailing Country Code |
| 11 | Claim Administrator Name |
| 12 | Billing Provider Secondary Address |
| 13 | Facility Medicare Number |
| 14 | Facility Name |
| 15 | Claim Administrator FEIN |
| 16 | Insurer FEIN |
| 17 | Facility State License Number |
| 18 | Billing Provider Primary Specialty Code |
| 19 | Facility Postal Code |
| 20 | Rendering Bill Provider First Name |
| 21 | Reporting Period End Date |
| 22 | Billing Provider Postal Code |
| 23 | Billing Provider National Provider ID |
| 24 | Facility City |
| 25 | Facility Primary Address |
| 26 | Employee Gender Code |
| 27 | Facility Secondary Address |
| 28 | Rendering Bill Provider Last Name or Group |
| 29 | Transaction Tracking Number |
| 30 | Employee Date of Injury |
| 31 | Service Bill From Date |
| 32 | Billing Provider FEIN |
| 33 | Service Bill To Date |
| 34 | Date of Bill |
| 35 | Date Insurer Paid Bill |
| 36 | First ICD-9CM or ICD-10CM Diagnosis Code |
| 37 | Billing Provider First Name |
| 38 | Second ICD-9CM or ICD-10CM Diagnosis Code |
| 39 | Facility Country Code |
| 40 | Total Charge Per Bill |
| 41 | Bill Type |
| 42 | Referring Provider Gate Keeper Indicator |
| 43 | Transaction Set Purpose Code |
| 44 | Billing Provider Last Name or Group |
| 45 | Treatment Authorization Number |
| 46 | Patient Account Number |
| 47 | Fourth ICD-9CM or ICD-10CM Diagnosis Code |
| 48 | Provider Agreement Code |
| 49 | Rendering Bill Provider State License Number |
| 50 | Reporting Period Start Date |
| 51 | Facility FEIN |
| 52 | Claim Administrator Postal Code |
| 53 | Rendering Bill Provider Primary Specialty Code |
| 54 | Billing Provider Gate Keeper Indicator |
| 55 | Total Amount Paid Per Bill |
| 56 | Unique Bill ID Number |
| 57 | Billing Provider Unique Bill Identification Number |
| 58 | Employee Mailing State Code |
| 59 | Employee Mailing Postal Code |
| 60 | Billing Provider Middle Name Initial |
| 61 | Managed Care Organization Identification |
| 62 | Referring Provider Specialty License Number |
| 63 | Employee Date of Birth |
| 64 | Billing Provider Suffix |
| 65 | Rendering Bill Provider FEIN |
| 66 | Rendering Bill Provider Primary Address |
| 67 | Billing Format Code |
| 68 | Rendering Bill Provider Secondary Address |
| 69 | Rendering Bill Provider Suffix |
| 70 | Rendering Bill Provider City |
| 71 | Rendering Bill Provider State Code |
| 72 | Referring Provider Medicare Number |
| 73 | Rendering Bill Provider Postal Code |
| 74 | Referring Provider Suffix |
| 75 | Rendering Bill Provider Country Code |
| 76 | Employer Physical Country Code |
| 77 | Rendering Bill Provider Gate Keeper Indicator |
| 78 | Billing Provider State Code |
| 79 | Rendering Bill Provider National Provider ID |
| 80 | Employee Marital Status Code |
| 81 | Bill ID |
| 82 | Referring Provider Last Name or Group |
| 83 | Referring Provider First Name |
| 84 | Referring Provider FEIN |
| 85 | Referring Provider State License Number |
| 86 | Referring Provider National Provider ID |
| 87 | Provider Signature On File Indicator |
| 88 | Bill Submission Reason Code |
| 89 | Billing Provider State License Number |
| 90 | Employer Physical State Code |
| 91 | Third ICD-9CM or ICD-10CM Diagnosis Code |
| 92 | Facility State Code |
| 93 | Employer Physical City |
| 94 | Employee Mailing City |
| 95 | Employer Physical Postal Code |
| 96 | Billing Type Code |
| 97 | Bill Selection Date |
| 98 | Referring Provider Middle Name Initial |
| 99 | Billing Provider City |
| 100 | Claim Administrator Claim Number |
| 101 | Contract Type Code |
| 102 | Billing Provider Country Code |
| 103 | Billing Provider Medicare Number |