6-Census.xlsx

This file is a medical reinsurance list for Salt Lake Community College containing employee enrollment data across medical insurance plans. The spreadsheet contains detailed information on 1,301 full-time and long-term disability employees, documenting each individual's unique employee ID, gender, date of hire, date of birth, residence zip code, employment status, medical coverage status, carrier selection, medical plan election, enrollment tier, and COBRA participation details. The data reflects employees enrolled in various plan types including PPO (Preferred Provider Organization) and HDHP (High Deductible Health Plan) options with different cost-sharing structures such as Value PVC, Participating, Focal PFP, and ICOB variants. Enrollment tiers range from single coverage to employee plus spouse/children configurations, with coverage statuses categorized as Active, Waived, Early Retiree, or President Emeritus.

The employee census data supports Salt Lake Community College's Stop Loss Insurance procurement, which seeks coverage to protect against catastrophic medical claims. This file serves as the actuarial basis for evaluating stop loss insurance proposals, as vendors require detailed employee demographic and enrollment information to calculate risk exposure, determine appropriate attachment points, and quote annual premiums. The comprehensive roster enables prospective insurers to assess the college's claim history patterns, enrollment trends by plan type and tier, and overall population health risk profile necessary for developing competitive stop loss insurance proposals under the College's RFP process.