_dta: 1. mlr2013part1_2 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 row_lookup_code: 1. Lookup code used in template to identify the row the data is for cmmiy: 1. CMM Individual Market - As of 12/31 of Reporting Year cmmiq1: 1. CMM Individual Market - As of 03/31 Subsequent Year cmmidpy: 1. CMM Individual Market - New Business Deferred from Prior Year cmmidcy: 1. CMM Individual Market - Deferred Reporting of New Business cmmitot: 1. Comprehensive Major Medical Individual Total cmmsy: 1. CMM Small Group Market - As of 12/31 of Reporting Year cmmsq1: 1. CMM Small Group Market - As of 03/31 Subsequent Year cmmsdpy: 1. CMM Small Group Market - New Business Deferred from Prior Year cmmsdcy: 1. CMM Small Group Market - Deferred Reporting of New Business cmmstot: 1. Comprehensive Major Medical Small Group Total cmmly: 1. CMM Large Group Market - As of 12/31 of Reporting Year cmmlq1: 1. CMM Large Group Market - As of 03/31 Subsequent Year cmmldpy: 1. CMM Large Group Market - New Business Deferred from Prior Year cmmldcy: 1. CMM Large Group Market - Deferred Reporting of New Business cmmltot: 1. Comprehensive Major Medical Large Group Total minimiy: 1. Mini-Med Plans Individual - As of 12/31 of Reporting Year minimiq1: 1. Mini-Med Plans - Individual - As of 03/31 Subsequent Year minimsy: 1. Mini-Med Plans Small Group - As of 12/31 of Reporting Year minimsq1: 1. Mini-Med Plans - Small Group - As of 03/31 Subsequent Year minimly: 1. Mini-Med Plans Large Group - As of 12/31 of Reporting Year minimlq1: 1. Mini-Med Plans - Large Group - As of 03/31 Subsequent Year expsy: 1. Expatriate Small Group Market - As of 12/31 of Reporting Year expsq1: 1. Expatriate Small Group Market - As of 03/31 Subsequent Year expsdpy: 1. Expatriate Small Group Market - New Business Deferred from Prior Year expsdcy: 1. Expatriate Plans - Small Group - Deferred Reporting of New Business expstot: 1. Expatriate Plans - Small Group - Total for the Reporting Year exply: 1. Expatriate Large Group Market - As of 12/31 of Reporting Year explq1: 1. Expatriate Large Group Market - As of 03/31 Subsequent Year expldpy: 1. Expatriate Large Group Market - New Business Deferred from Prior Year expldcy: 1. Expatriate Plans - Large Group - Deferred Reporting of New Business expltot: 1. Expatriate Plans - Large Group - Total for the Reporting Year govy: 1. Government Program Plans - As of 12/31 of Reporting Year othy: 1. Other Health Business - As of 12/31 of Reporting Year agg2pcty: 1. Government Program and Other Health Business Combined if Less Than 2% of Total Health Earned Premium - As of 12/31 of Reporting Year uninsuy: 1. Self-Funded or Uninsured Plans - As of 12/31 of Reporting Year grandtot: 1. Grand Total credatetime: 1. Date the record was created cmmid: 1. CMM Individual Market - Dual Contract (Included in 3/31 of Subsequent Year) cmmsd: 1. CMM Small Group Market - Dual Contract (Included in 3/31 of Subsequent Year) cmmld: 1. CMM Large Group Market - Dual Contract (Included in 3/31 of Subsequent Year) minimid: 1. Mini-Med Plans - Individual Market - Dual Contract (Included in 3/31 of Subsequent Year) minimsd: 1. Mini-Med Plans - Small Group Market - Dual Contract (Included in 3/31 of Subsequent Year) minimld: 1. Mini-Med Plans - Large Group Market - Dual Contract (Included in 3/31 of Subsequent Year) expsd: 1. Expatriate Plans - Small Group Market - Dual Contract (Included in 3/31 of Subsequent Year) expld: 1. Expatriate Plans - Large Group Market - Dual Contract (Included in 3/31 of Subsequent Year) shpiy: 1. Student Health Plans - Individual Market - As of 12/31 of Reporting Year shpiq1: 1. Student Health Plans - Individual Market - As of 03/31 Subsequent Year shpid: 1. Student Health Plans - Individual Market - Dual Contract (Included in 3/31 of Subsequent Year) shpidpy: 1. Student Health Plans - Individual Market - New Business Deferred from Prior Year shpidcy: 1. Student Healh Plans - Individual Market - Deferred Reporting of New Business obs: 370,402 vars: 54 8 Sep 2014 12:38 size: 84,451,656 (_dta has notes) ------------------------------------------------------------------------------- storage display value variable name type format label variable label ------------------------------------------------------------------------------- id long %12.0g * Unique Identifier for each MLR template file within the submission package row_lookup_code str32 %32s * Lookup value for rows in MLR template cmmiy double %10.0g * CMM Individual Market - As of 12/31 of Reporting Year cmmiq1 double %10.0g * CMM Individual Market - As of 03/31 Subsequent Year cmmidpy float %9.0g * CMM Individual Market - New Business Deferred from Prior Year cmmidcy float %9.0g * CMM Individual Market - Deferred Reporting of New Business cmmitot byte %8.0g * Comprehensive Major Medical Individual Total cmmsy double %10.0g * CMM Small Group Market - As of 12/31 of Reporting Year cmmsq1 double %10.0g * CMM Small Group Market - As of 03/31 Subsequent Year cmmsdpy byte %8.0g * CMM Small Group Market - New Business Deferred from Prior Year cmmsdcy float %9.0g * CMM Small Group Market - Deferred Reporting of New Business cmmstot byte %8.0g * Comprehensive Major Medical Small Group Total cmmly double %10.0g * CMM Large Group Market - As of 12/31 of Reporting Year cmmlq1 double %10.0g * CMM Large Group Market - As of 03/31 Subsequent Year cmmldpy byte %8.0g * CMM Large Group Market - New Business Deferred from Prior Year cmmldcy byte %8.0g * CMM Large Group Market - Deferred Reporting of New Business cmmltot byte %8.0g * Comprehensive Major Medical Large Group Total minimiy float %9.0g * Mini-Med Plans Individual - As of 12/31 of Reporting Year minimiq1 float %9.0g * Mini-Med Plans - Individual - As of 03/31 Subsequent Year minimsy float %9.0g * Mini-Med Plans Small Group - As of 12/31 of Reporting Year minimsq1 float %9.0g * Mini-Med Plans - Small Group - As of 03/31 Subsequent Year minimly float %9.0g * Mini-Med Plans Large Group - As of 12/31 of Reporting Year minimlq1 float %9.0g * Mini-Med Plans - Large Group - As of 03/31 Subsequent Year expsy float %9.0g * Expatriate Small Group Market - As of 12/31 of Reporting Year expsq1 byte %8.0g * Expatriate Small Group Market - As of 03/31 Subsequent Year expsdpy byte %8.0g * Expatriate Small Group Market - New Business Deferred from Prior Year expsdcy byte %8.0g * Expatriate Plans - Small Group - Deferred Reporting of New Business expstot byte %8.0g * Expatriate Plans - Small Group - Total for the Reporting Year exply float %9.0g * Expatriate Large Group Market - As of 12/31 of Reporting Year explq1 byte %8.0g * Expatriate Large Group Market - As of 03/31 Subsequent Year expldpy byte %8.0g * Expatriate Large Group Market - New Business Deferred from Prior Year expldcy byte %8.0g * Expatriate Plans - Large Group - Deferred Reporting of New Business expltot byte %8.0g * Expatriate Plans - Large Group - Total for the Reporting Year govy double %10.0g * Government Program Plans - As of 12/31 of Reporting Year othy double %10.0g * Other Health Business - As of 12/31 of Reporting Year agg2pcty float %9.0g * Government Program and Other Health Business Combined if Less Than 2% of Total H uninsuy double %10.0g * Self-Funded or Uninsured Plans - As of 12/31 of Reporting Year grandtot float %9.0g * Grand Total credatetime str19 %19s * Date the record was created credate int %td Created Date cmmid float %9.0g * CMM Individual Market - Dual Contract (Included in 3/31 of Subsequent Year) cmmsd float %9.0g * CMM Small Group Market - Dual Contract (Included in 3/31 of Subsequent Year) cmmld float %9.0g * CMM Large Group Market - Dual Contract (Included in 3/31 of Subsequent Year) minimid byte %8.0g * Mini-Med Plans - Individual Market - Dual Contract (Included in 3/31 of Subseque minimsd byte %8.0g * Mini-Med Plans - Small Group Market - Dual Contract (Included in 3/31 of Subsequ minimld byte %8.0g * Mini-Med Plans - Large Group Market - Dual Contract (Included in 3/31 of Subsequ expsd byte %8.0g * Expatriate Plans - Small Group Market - Dual Contract (Included in 3/31 of Subse expld byte %8.0g * Expatriate Plans - Large Group Market - Dual Contract (Included in 3/31 of Subse shpiy float %9.0g * Student Health Plans - Individual Market - As of 12/31 of Reporting Year shpiq1 float %9.0g * Student Health Plans - Individual Market - As of 03/31 Subsequent Year shpid float %9.0g * Student Health Plans - Individual Market - Dual Contract (Included in 3/31 of Su shpidpy byte %8.0g * Student Health Plans - Individual Market - New Business Deferred from Prior Year shpidcy byte %8.0g * Student Healh Plans - Individual Market - Deferred Reporting of New Business year int %9.0g Reporting Year * indicated variables have notes ------------------------------------------------------------------------------- Sorted by: id row_lookup_code