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