Blue Cross and Blue Shield of Texas Smart Census Import Tool 14 User Guide

Introduces the version compatibility, usage method of Smart Census Import Tool, including enabling macros, using copy and paste functions, using frozen windows, using filter and sorting functions, etc.


Blue Cross and Blue Shield of Texas Smart Census Import Tool 14 User Guide - cover page
Brand
Blue Cross and Blue Shield of Texas
Category
Health Care
Document type
User Manual
Language
English
Pages
55
File format
PDF
File size
3 MB
Published
20 October, 2023
Updated
20 October, 2023
MD5 checksum
AEE6BE3A80D73AF0D2672D74DDCE60B8

About this manual

This document provides step-by-step instructions for using the Smart Census Import Tool (SCIT) Version 14 to enter and validate group census data for small group and middle market enrollment. It includes setup procedures, data entry guidelines, compatibility notes, and reference tables for state-specific configurations.

The tool requires Excel 2013 or newer and macros to be enabled. Users must save the tool locally, avoid opening multiple instances, and use the AutoFill feature to populate select columns. The guide also explains how to map census data from external spreadsheets and handle specific data formats, such as phone numbers and zip codes with leading zeros.

What's inside

  • Version 14 Release Notes
  • Steps for Entering a Group’s Census
  • Compatibility
  • Using SCIT
  • AutoFill Feature
  • Reference Tables: Small Group Enrollment Census Template
  • State-specific Column Dropdown Varies
  • Auto Fill Select Columns Reference Table

Frequently asked questions

What Excel versions are compatible with SCIT Version 14?

Version 14 is compatible with Excel 2013 and newer versions.

How do I enable macros in SCIT?

Use the instructions provided in the Reference section to enable macros.

What should I do if I need to use Find & Replace in SCIT?

Update the source document and paste copied data as VALUES into the tool to avoid overwriting Excel formatting.

Download PDF (3 MB)