_dta: 1. mlr2011header data set up by Jean Roth , jroth@nber.org , 8 Sep 2014 id: 1. Unique Identifier for each MLR template file within the submission package 2. Unique ID created for each Template, used to map to child tables business_state: 1. Name of the State, District, or Territory group_affiliation: 1. Name of the holding company compid: 1. Unique ID for the Company established by HIOS Proper 2. Foreign key to Company table. issid: 1. Unique ID for the Issuer established by HIOS Proper 2. From Issuer table company_name: 1. Name of the Issuing Insurance Company company_address: 1. Address of Issuing Insurance Company domiciliary_state: 1. State that the Company is operating in/out of naicgc: 1. NAIC Code of the Holding Company 2. Unique code for a Holding Company assigned by the National Association of Insurance Commissioners (NAIC) naiccc: 1. NAIC Code of the Insurance Company 2. A unique code for a Company assigned by the National Association of Insurance Commissioners (NAIC) ein: 1. Federal EIN number of the company ambest: 1. AM Best number of the company 2. A unique code for a Company assigned by the A.M. Best dba_marketing_name: 1. Marketing name of the company nfp: 1. 1 indicates if company is not-for-profit, 0 indicates if it is not credatetime: 1. Date the record was created mergema: 1. Indicates if the state template uses merged markets obs: 4,182 vars: 18 8 Sep 2014 13:11 size: 1,660,254 (_dta has notes) ------------------------------------------------------------------------------- storage display value variable name type format label variable label ------------------------------------------------------------------------------- id int %8.0g * Unique Identifier for each MLR template file within the submission package business_state str28 %28s * Name of the State, District, or Territory group_affiliation str52 %52s * Name of the holding company compid int %8.0g * Unique ID for the Company established by HIOS Proper issid long %12.0g * Unique ID for the Issuer established by HIOS Proper company_name str67 %67s * Name of the Issuing Insurance Company company_address str81 %81s * Address of Issuing Insurance Company domiciliary_state str20 %20s * State that the Company is operating in/out of naicgc str5 %9s * NAIC Code of the Holding Company naiccc str5 %9s * NAIC Code of the Insurance Company ein str9 %9s * Federal EIN number of the company ambest str5 %9s * AM Best number of the company dba_marketing_name str92 %92s * Marketing name of the company nfp byte %8.0g * 1 indicates if company is not-for-profit, 0 indicates if it is not credatetime str19 %19s * Date the record was created credate int %td Created Date mergema byte %8.0g * Indicates if the state template uses merged markets year int %9.0g Reporting Year * indicated variables have notes ------------------------------------------------------------------------------- Sorted by: id