Table A1. Group Health Plans, Total Participants, Active Participants,
Assets, Contributions, and Benefits
by type of plan and type of insurance, 2008

The CONTENTS Procedure

Data Set Name GHPB.GHPB08 Observations 47066
Member Type DATA Variables 221
Engine V9 Indexes 0
Created Tuesday, October 25, 2011 04:35:02 PM Observation Length 1920
Last Modified Tuesday, October 25, 2011 04:35:02 PM Deleted Observations 0
Protection   Compressed NO
Data Set Type   Sorted NO
Label      
Data Representation WINDOWS_32    
Encoding wlatin1 Western (Windows)    

Engine/Host Dependent Information
Data Set Page Size 16384
Number of Data Set Pages 5886
First Data Page 2
Max Obs per Page 8
Obs in First Data Page 1
Number of Data Set Repairs 0
Filename D:\Brake.Ryan\My Documents\Self Insured Project\2008 Data\Tabulate\Statistical Year Output\10.5.2011\ghpb08.sas7bdat
Release Created 9.0202M0
Host Created W32_VSPRO

Alphabetic List of Variables and Attributes
# Variable Type Len Format Informat Label
30 ACQUIS_INDBT_EOY_AMT Num 8 COMMA12.   Acquisition indebtedness
32 AGGREGATE_COSTS_AMT Num 8 COMMA12.   Aggregate costs
31 AGGREGATE_PROCEEDS_AMT Num 8 COMMA12.   Aggregate proceeds
159 AST21 Num 8 AST21F.    
167 BENEFIT Char 1 $FUNDINGF.    
20 BENEFIT_CODE Char 4 $4. $4. BENEFIT_CODE
29 BENEF_RCVG_BNFT_CNT Num 8     Beneficiaries receiving benefits
163 BIZCODE Num 8 BIZCODEF.    
33 BLDGS_USED_BOY_AMT Num 8     BLDGS_USED_BOY_AMT
34 BLDGS_USED_EOY_AMT Num 8 COMMA12.   Buildings and other prop. used by plan
35 BNFTS_PAYABLE_EOY_AMT Num 8 COMMA12.   Benefit claims payable
140 BS_SOURCE Char 1 $1. $1. BS_SOURCE
208 CAST_AST Num 8      
142 COLLECTIVE_BARGAIN_IND Char 1 $CBSF. $1. COLLECTIVE_BARGAIN_IND
36 COMMON_STOCK_EOY_AMT Num 8 COMMA12.   Common stock
37 CONTRACT_ADMIN_FEES_AMT Num 8 COMMA12.   Contract administrator fees
28 CONTRACT_NUM_HEALTH Num 8 CONTRACT_NUMF.   Number of Schedule A Health Insurance Contracts
38 CORP_DEBT_OTHER_EOY_AMT Num 8 COMMA12.   Corporate debt instruments: All other
39 CORP_DEBT_PREFERRED_EOY_AMT Num 8 COMMA12.   Corporate debt instruments: preferred
211 DEBT_INST_AST Num 8      
216 DFE_AST Num 8      
40 DISTRIB_DRT_PARTCP_AMT Num 8 COMMA12.   Direct benefit payments
41 DIVND_COMMON_STOCK_AMT Num 8 COMMA12.   Dividends from common stock
42 DIVND_PREF_STOCK_AMT Num 8 COMMA12.   Dividends from preferred stock
221 EFFYR Num 8 EFFYRF.    
156 EFF_DATE Char 8      
147 EINPN Char 12      
43 EMPLR_CONTRIB_BOY_AMT Num 8     EMPLR_CONTRIB_BOY_AMT
44 EMPLR_CONTRIB_EOY_AMT Num 8 COMMA12.   Employer contrib. receivable
45 EMPLR_CONTRIB_INCOME_AMT Num 8 COMMA12.   Employer contributions
46 EMPLR_PROP_EOY_AMT Num 8 COMMA12.   Employer real property
47 EMPLR_SEC_EOY_AMT Num 8 COMMA12.   Employer securites
152 ENT2 Char 1 $ENT4F.    
165 FILINGSIZE Char 1 $FILINGSIZEF.    
220 FILINGSIZE2 Char 1 $FILINGSIZE2F.    
1 FILING_ID Num 8     FILING_ID
5 FORM_PLAN_YEAR_BEGIN_DATE Char 8 $8. $8. FORM_PLAN_YEAR_BEGIN_DATE
6 FORM_TAX_PRD Num 8 DATETIME20. DATETIME20. FORM_TAX_PRD
166 FUNDING_ARRANGE Char 1 $FUNDINGF.    
18 FUNDING_ARRANGEMENT_CODE Char 4 $4. $4. FUNDING_ARRANGEMENT_CODE
48 GAIN_LOSS_103_12_INVST_AMT Num 8 COMMA12.   Net inv. gain from 103-12 inv. entities
49 GAIN_LOSS_COM_TRUST_AMT Num 8 COMMA12.   Net inv. gain from common/col. trusts
50 GAIN_LOSS_MASTER_TR_AMT Num 8 COMMA12.   Net inv. gain from master trusts
51 GAIN_LOSS_POOL_SEP_AMT Num 8 COMMA12.   Net inv. gain from pooled sep. accounts
52 GAIN_LOSS_REG_INVST_AMT Num 8 COMMA12.   Net inv. gain from reg. inv companies
210 GOVT_SEC_AST Num 8      
53 GOVT_SEC_EOY_AMT Num 8 COMMA12.   U. S. Government securities.
144 HEALTH_ONLY Num 8 HEALTH_ONLYF.    
145 HEALTH_TYPE Num 8 HEALTH_TYPEF.    
21 H_CONTRACT Num 8     Notes Presence of a Health Contract on Schedule A
23 H_CONTRACT_CNT Num 8     Count of individuals covered under Schedule A health insurance contracts
25 H_CONTRACT_PREM Num 8     Premium paid for Schedule A Health Insurance Contracts
174 IB_NINC Num 8 COMMA12.   NET INCOME
164 INS3 Num 8 INS3F.    
146 INSURANCE_TYPE Num 8 INSURANCE_TYPEF.   Categorizes types of Schedule A insurance contracts
54 INS_CARRIER_BNFTS_AMT Num 8 COMMA12.   Payments to ins. carriers for benefits
55 INS_CO_GEN_ACCT_EOY_AMT Num 8 COMMA12.   Assets in ins. co. general account
218 INS_CO_GEN_AST Num 8      
56 INT_103_12_INVST_EOY_AMT Num 8 COMMA12.   Assets in 103-12 investment entities
57 INT_BEAR_CASH_AMT Num 8 COMMA12.   Interest on interest-bearing cash
58 INT_BEAR_CASH_EOY_AMT Num 8 COMMA12.   Interest-bearing cash
59 INT_COMMON_TR_EOY_AMT Num 8 COMMA12.   Assets in common/collective trusts
60 INT_MASTER_TR_EOY_AMT Num 8 COMMA12.   Assets in master trusts
61 INT_ON_CORP_DEBT_AMT Num 8 COMMA12.   Interest on corporate debt instruments
62 INT_ON_GOVT_SEC_AMT Num 8 COMMA12.   Interest on U. S. Government securities
63 INT_ON_OTH_INVST_AMT Num 8 COMMA12.   Other interest
64 INT_ON_OTH_LOANS_AMT Num 8 COMMA12.   Interest on non-participant loans
65 INT_ON_PARTCP_LOANS_AMT Num 8 COMMA12.   Interest on participant loans
66 INT_POOL_SEP_ACCT_EOY_AMT Num 8 COMMA12.   Assets in pooled separate accounts
67 INT_REG_INVST_CO_EOY_AMT Num 8 COMMA12.   Assets in registered investment comp.
69 INVST_MGMT_FEES_AMT Num 8 COMMA12.   Investment advisory and management fees
175 IOB_ASST Num 8 COMMA12.   Other investments
177 IOB_EXP Num 8 COMMA12.   Other or unpecified expenses
176 IOB_INC Num 8 COMMA12.   Other or unspecified income 2/
186 IOH_AEXP Num 8 COMMA12.   Other or unspecifed admin. expenses
183 IOH_APP Num 8 COMMA12.   Unspecified appreciation
178 IOH_ASST Num 8 COMMA12.   Other or unspecified assets
188 IOH_ASST_C7 Num 8 COMMA12.   Other or unspecified investments
185 IOH_BEN Num 8 COMMA12.   Other or unspecified benefits
180 IOH_CONT Num 8 COMMA12.   Unspecified contributions
189 IOH_CONT_C12 Num 8 COMMA12.   Other or unspecified contributions
182 IOH_DIV Num 8 COMMA12.   Unspecified dividends
187 IOH_EXP Num 8 COMMA12.   Unpecified expenses
184 IOH_INC Num 8 COMMA12.   Other or unspecified income
190 IOH_INC_C12 Num 8 COMMA12.   Other or unspecified income
181 IOH_INT Num 8 COMMA12.   Other or unspecified interest
179 IOH_LIAB Num 8 COMMA12.   Other liabilities
173 ITB_LIAB Num 8 COMMA12.   TOTAL LIABILITIES
70 JOINT_VENTURE_EOY_AMT Num 8 COMMA12.   Partnership/joint venture interests
158 LARGE Num 8      
215 LOANS_AST Num 8      
71 NET_ASSETS_BOY_AMT Num 8     NET_ASSETS_BOY_AMT
72 NET_ASSETS_EOY_AMT Num 8 COMMA12.   NET ASSETS
73 NET_INCOME_AMT Num 8 COMMA12.   NET INCOME
153 NET_TRANSFERS Num 8     Net transfers
74 NON_CASH_CONTRIB_BS_AMT Num 8 COMMA12.   Noncash contributions
75 NON_INT_BEAR_CASH_EOY_AMT Num 8 COMMA12.   Total noninterest-bearing cash
76 OPRTNG_PAYABLE_EOY_AMT Num 8 COMMA12.   Operating payables
2 OPR_EIN Char 9 $9. $9. OPR_EIN
3 OPR_PN Char 4 $4. $4. OPR_PN
80 OTHER_ADMIN_FEES_AMT Num 8 COMMA12.   Other administrative expenses
219 OTHER_AST Num 8      
151 OTHER_EXPENSES_AMT Num 8      
102 OTHER_INCOME_AMT Num 8 COMMA12.   Other or unspecified income
105 OTHER_LIAB_EOY_AMT Num 8 COMMA12.   Other liabilities
81 OTHER_LOANS_EOY_AMT Num 8 COMMA12.   Loans (other than to participants)
27 OTHER_PREM Num 8     Count of individuals covered under Schedule A non-health insurance contracts
82 OTHER_RECEIVABLES_BOY_AMT Num 8     OTHER_RECEIVABLES_BOY_AMT
83 OTHER_RECEIVABLES_EOY_AMT Num 8 COMMA12.   Other receivables
77 OTH_BNFT_PAYMENT_AMT Num 8 COMMA12.   Other benefit payments
78 OTH_CONTRIB_RCVD_AMT Num 8 COMMA12.   Contributions from others
79 OTH_INVST_EOY_AMT Num 8 COMMA12.   Other general investments
162 PART8 Num 8 PART8F.    
161 PART13 Num 8 PART13F.    
160 PART14 Num 8 PART14F.    
17 PARTCP_ACCOUNT_BAL_CNT Num 8 COMMA10.   Participants with account balances
84 PARTCP_CONTRIB_BOY_AMT Num 8     PARTCP_CONTRIB_BOY_AMT
85 PARTCP_CONTRIB_EOY_AMT Num 8 COMMA12.   Participant contrib. receivable
86 PARTCP_LOANS_EOY_AMT Num 8 COMMA12.   Participant loans
87 PARTICIPANT_CONTRIB_AMT Num 8 COMMA12.   Participant contributions
213 PART_JOINT_INT_AST Num 8      
4 PLAN_NAME Char 140 $140. $140. PLAN_NAME
88 PREF_STOCK_EOY_AMT Num 8 COMMA12.   Preferred stock
89 PROFESSIONAL_FEES_AMT Num 8 COMMA12.   Professional fees
155 PYB Char 8      
154 PYE Num 8      
214 REAL_ESTATE_AST Num 8      
90 REAL_ESTATE_EOY_AMT Num 8 COMMA12.   Real estate (exc employer real prop.)
209 RECEIVABLES_AST Num 8      
217 REG_INVST_CO_AST Num 8      
91 RES_TERM_PLAN_ADPT_IND Char 1 $1. $1. RES_TERM_PLAN_ADPT_IND
14 RTD_SEP_PARTCP_FUT_CNT Num 8 COMMA10.   Separated participants with vested right to benefits
13 RTD_SEP_PARTCP_RCVG_CNT Num 8 COMMA10.   Retired or separated vested participants receiving benefits
143 SEP_PARTCP_PARTL_VSTD_CNT Num 8     SEP_PARTCP_PARTL_VSTD_CNT
114 SMALL_CORRECTIVE_DISTRIB_AMT Num 8     SMALL_CORRECTIVE_DISTRIB_AMT
115 SMALL_DM_DSTRB_PTCP_LN_A Num 8     SMALL_DM_DSTRB_PTCP_LN_A
116 SMALL_EMPLR_CONTRIB_INCOME_AMT Num 8     SMALL_EMPLR_CONTRIB_INCOME_AMT
117 SMALL_EMPLR_PROP_EOY_AMT Num 8     SMALL_EMPLR_PROP_EOY_AMT
118 SMALL_EMPLR_SEC_EOY_AMT Num 8     SMALL_EMPLR_SEC_EOY_AMT
119 SMALL_INVST_REAL_EST_EOY_A Num 8     SMALL_INVST_REAL_EST_EOY_A
120 SMALL_JOINT_VENTURE_EOY_AMT Num 8     SMALL_JOINT_VENTURE_EOY_AMT
121 SMALL_MORTG_PARTCP_EOY_AMT Num 8     SMALL_MORTG_PARTCP_EOY_AMT
122 SMALL_NET_ASSETS_BOY_AMT Num 8     SMALL_NET_ASSETS_BOY_AMT
123 SMALL_NET_ASSETS_EOY_AMT Num 8     SMALL_NET_ASSETS_EOY_AMT
124 SMALL_NET_INCOME_AMT Num 8     SMALL_NET_INCOME_AMT
125 SMALL_NON_CASH_CONTRIB_BS_AMT Num 8     SMALL_NON_CASH_CONTRIB_BS_AMT
138 SMALL_OTHER_INCOME_AMT Num 8     SMALL_OTHER_INCOME_AMT
126 SMALL_OTH_CONTRIB_RCVD_AMT Num 8     SMALL_OTH_CONTRIB_RCVD_AMT
139 SMALL_OTH_EXPENSES_AMT Num 8     SMALL_OTH_EXPENSES_AMT
127 SMALL_OTH_LNS_PARTCP_EOY_AMT Num 8     SMALL_OTH_LNS_PARTCP_EOY_AMT
128 SMALL_PARTICIPANT_CONTRIB_AMT Num 8     SMALL_PARTICIPANT_CONTRIB_AMT
129 SMALL_PERSONAL_PROP_EOY_AMT Num 8     SMALL_PERSONAL_PROP_EOY_AMT
130 SMALL_TOT_ASSETS_BOY_AMT Num 8     SMALL_TOT_ASSETS_BOY_AMT
131 SMALL_TOT_ASSETS_EOY_AMT Num 8     SMALL_TOT_ASSETS_EOY_AMT
132 SMALL_TOT_DISTRIB_BNFT_AMT Num 8     SMALL_TOT_DISTRIB_BNFT_AMT
133 SMALL_TOT_EXPENSES_AMT Num 8     SMALL_TOT_EXPENSES_AMT
134 SMALL_TOT_INCOME_AMT Num 8     SMALL_TOT_INCOME_AMT
135 SMALL_TOT_LIABILITIES_BOY_AMT Num 8     SMALL_TOT_LIABILITIES_BOY_AMT
136 SMALL_TOT_LIABILITIES_EOY_AMT Num 8     SMALL_TOT_LIABILITIES_EOY_AMT
137 SMALL_TOT_PLAN_TRANSFERS_AMT Num 8     SMALL_TOT_PLAN_TRANSFERS_AMT
7 SPONSOR_DFE_NAME Char 71 $71. $71. SPONSOR_DFE_NAME
8 SPONS_DFE_CITY Char 22 $22. $22. SPONS_DFE_CITY
9 SPONS_DFE_STATE Char 2 $2. $2. SPONS_DFE_STATE
10 SPONS_DFE_ZIP_CODE Char 12 $12. $12. SPONS_DFE_ZIP_CODE
191 SRDB_ASST Num 8      
193 SRDB_EXP Num 8      
192 SRDB_INC Num 8      
202 SRDH_AEXP Num 8      
199 SRDH_APP Num 8      
194 SRDH_ASST Num 8      
204 SRDH_ASST_C7 Num 8      
201 SRDH_BEN Num 8      
169 SRDH_CASH Num 8 COMMA12.   Cash
196 SRDH_CONT Num 8      
205 SRDH_CONT_C12 Num 8      
198 SRDH_DIV Num 8      
203 SRDH_EXP Num 8      
200 SRDH_INC Num 8      
206 SRDH_INC_C12 Num 8      
197 SRDH_INT Num 8      
195 SRDH_LIAB Num 8      
172 SRDH_LOANS Num 8 COMMA12.   Loans
171 SRDH_REC Num 8 COMMA12.   Receivables
170 SRDH_STOCK Num 8 COMMA12.   Corporate stocks
212 STOCK_AST Num 8      
22 STOPLOSS Num 8     Notes Presence of a Stop-Loss Contract on Schedule A
24 STOPLOSS_CNT Num 8     Count of individuals covered under Schedule A stop-loss insurance contracts
26 STOPLOSS_PREM Num 8     Premium paid for Schedule A Stop-Loss Insurance Contracts
15 SUBTL_ACT_RTD_SEP_CNT Num 8 COMMA10.   Total Participants
109 TOTAL_DIVIDENDS_AMT Num 8 COMMA12.   Total dividends income
110 TOTAL_INTEREST_AMT Num 8 COMMA12.   Total interest earnings
111 TOTAL_RENTS_AMT Num 8 COMMA12.   Rents
12 TOT_ACTIVE_PARTCP_CNT Num 8 COMMA10.   Active participants
16 TOT_ACT_RTD_SEP_BENEF_CNT Num 8     Grand total participants
93 TOT_ADMIN_EXPENSES_AMT Num 8 COMMA12.   Total administrative expenses
68 TOT_ASSETS_BOY_AMT Num 8     TOT_ASSETS_BOY_AMT
94 TOT_ASSETS_EOY_AMT Num 8     TOTAL ASSETS
95 TOT_CONTRIB_AMT Num 8 COMMA12.   Total contributions
96 TOT_CORRECTIVE_DISTRIB_AMT Num 8 COMMA12.   Corrective distributions
97 TOT_DISTRIB_BNFT_AMT Num 8 COMMA12.   Total benefit payments
98 TOT_DM_DISTRIB_PTCP_LNS_A Num 8 COMMA12.   Deemed distrib. of partic. loans
99 TOT_EXPENSES_AMT Num 8 COMMA12.   TOTAL EXPENSES
100 TOT_GAIN_LOSS_SALE_AST_AMT Num 8 COMMA12.   Net gain (loss) on sale of assets
101 TOT_INCOME_AMT Num 8 COMMA12.   TOTAL INCOME
103 TOT_INT_EXPENSE_AMT Num 8 COMMA12.   Interest expense
207 TOT_INVESTMENT_INCOME_AMT Num 8      
148 TOT_LIABILITIES_BOY_AMT Num 8      
104 TOT_LIABILITIES_EOY_AMT Num 8 COMMA12.   TOT_LIABILITIES_EOY_AMT
11 TOT_PARTCP_BOY_CNT Num 8     TOT_PARTCP_BOY_CNT
168 TOT_PREM Num 8     Premium paid for All Schedule A Insurance Contracts
106 TOT_TRANSFERS_FROM_AMT Num 8 COMMA12.   Transfers from the plan
107 TOT_TRANSFERS_TO_AMT Num 8 COMMA12.   Transfers to the plan
108 TOT_UNREALZD_APPRCTN_AMT Num 8 COMMA12.   Total unrealized appreciation
157 TPART Num 8 COMMA12.    
19 TYPE_PLAN_ENTITY_IND Char 1 $1. $1. TYPE_PLAN_ENTITY_IND
92 TYPE_PLAN_FILING_IND Char 4 $4. $4. TYPE_PLAN_FILING_IND
141 TYPE_WELFARE_BNFT_CODE Char 20 $20. $20. TYPE_WELFARE_BNFT_CODE
112 UNREALZD_APPRCTN_OTH_AMT Num 8 COMMA12.   Other unrealized appreciation
113 UNREALZD_APPRCTN_RE_AMT Num 8 COMMA12.   Unrealized appreciation of real estate
150 UNSPEC_DIST_BNFT_AMT Num 8      
149 UNSPEC_INVEST_EOY_AMT Num 8 COMMA12.   Unspecified investments