The URL can be used to link to this page

Home My WebLink AboutExhibit17Eligibility File layout Transmission Specifications Specification Detail Frequency Weekly / Daily Date and Time Day of Week, Time, Time Zone File Name <GroupNo>ELIG_CCYYMMDD.txt Transmission Method FTP: Waiting Period Days to Enroll Format Specifications Specification Detail Format fired File Type Complete Full Eligibility File • All active eligible employees for. CIGNA/ CIGNA Voluntary benefits. • Eligible employees to include new hire,' eligible due to OE period and already enrolled employees. Field Name Group Required Y Data Type text Start 1 End 4 Length 4 Description Group Policy Assigned by CIGNA Data Rules SSN Y text 5 13 9 Emplo N text 14 22 9 Division N text 23 29 7 Location Last Y text 30 59 30 First Y text 60 74 15 Address Y text 75 114 . 40 City Y text 115 129 15 State Y text 130 131 2 Zip Y text 132 141 10 00000-0000 Phone Y text 142 153 12 000-000-0000 Filled" Y blanks 154 203 50 Gender Y text 204 204 1 M = male, F = female DOBirth Y date 205 212 8 ccyymmdd DOHire Y date 213 220 8 ccyymmdd DOEligibility N date 221 228 8 Date of Eligibility for QLE, Rehire ccyymmdd DOEIigTerm S date 229 236 8 Date of Voluntary Termination ccyymmdd DOEmpTerm S date 237 244 8 Date of Employment Termination Ccyymmdd DOCovEff S Date 245 252 8 Date of Coverage Effective cyymmdd Filler2" Y blanks 253 281 21 Send blanks Paycode Y text 282 286 5 Paycode or other type code Required Column Definition — Y = Data is Required, N = Data is Optional, S = Situational **Fields that are not required and not being sent `MUST' be send with BLANKS. Records sent with O's may error out and not load. FTP Instructions; 1 You wilt need FTP client software that supports SSL. SSL encrypts the data making the use of PGP encryption unnecessaryAFTP with SSL uses ports 20, 21, 989, 990. If you are behind a firewall your Network Administrator may need to allow you to use these ports. Our site supports FTP with SSL explicit encryption which will use port 20 and 21 only, but will not work if you are using NAT. Our site also supports FTP with SSL implicit encryption which will use ports 989 and 990 only and will work if you are using NAT. Upon completion of your FTP software setup, you would access our FTP site with a UserlO and Password provided by CIGNA. To purchase a licensed copy of Cute FTP pro please visit their site: http://www.olobalscaoe.com/store/ourchase.asp?product=cuteftooro In some cases technical problems prevent the use of SSL. Your account can be set to not use SSL if technical issues prevent SSL from working or if you are going to be using a UNIX system. It would then be necessary to exchange PGP keys to encrypt the data prior to the data being placed in your FTP directory. You would then be able to use any FTP client software to send and receive data, including Internet Explorer. We can provide a Zink to obtain a 30 day Trial version of Cute FTP Pro, which supports SSL. EMAIL Instructions; Eligiblity files can be emailed to data@cignavoluntary.com. Files must be win zipped and password protected or PGP encryption. PGP encryption is preferred if a file will be sent via e-mail. 2 CIGNA Voluntary Eligibility File Requirements Objective + CIGNA Voluntary is committed to improving the health of your employees and your business. We will partner with you to develop and execute on participation growth strategies, as well as to confirm membership additions and payroll deductions. To increase participation and confirm membership and payroll deductions, we must know who your eligible employees are prior to open enrollment as well as throughout the year, so that we can outreach, educate, and enroll! We also will invest in existing members, by communicating important health and lifestyle improvement topics The following grid illustrates the weekly files required by CIGNA Voluntary based on the client's chosen enrollment method. Detailed explanations for files and enrollment methods are listed on page 2. CARE Layout Enrollment Full Eligibility Initiation of Confirmation Method* File (submitted by Enrollment/Deduction of Client to CIGNA) File (submitted by CIGNA to Enrollment Client) (submitted by Client to CIGNA) CARE X Deduction Request File Deduction Actual File Non Care layouts Enrollment Method* Full Eligibility File (submitted by Client to CIGNA) Initiation of Enrollment/Deduction File (submitted by CIGNA to Client) Confirmation of Enrollment (submitted by Client to CIGNA) Web Administration Only. X IVR/Web Administration X X X Manual Administration X X File Transfer Methods Preferred: FTP Acceptable: Email (size limits) File Type Preferred: Text File Acceptable: Excel File (cells must be text formatted and leading zeros must be inserted) Frequency One time Initial file (for CIGNA testing) CIGNA Voluntary Eligibility File Requirements One time full eligible population file (for Open Enrollment) Weekly ongoing full eligibility files (for New Hires) Implementation Process A conference call between broker, Client, and payroll vendor (when applicable) will be established with CIGNA IT analysts to review data transfer process, automation, and to review file format. CARE • Client Administration Reduction Engine (CARE) is the premium management engine, known as the Ledger Engine which tracks the required and deducted premium amounts at the employee level. This enhanced system will allow CIGNA to provide more detailed information to the client and their employees concerning premium deductions. Additionally, it includes features to expedite the enrollment process and streamline the transfer of data. • Deduction Request File Sent from CIGNA to the client. CIGNA calculates the correct deduction amount for the member and sends a deduction request to the client. The deduction request data is sent to the client using client -specified format to facilitate easy integration with the client's payroll system. • Deduction Action File Sent from Client to CIGNA. Includes the member's actual deduction amount to CIGNA. Deduction data will be sent to CIGNA using a client -specified format to facilitate easy integration between the client's payroll system and CIGNA's deduction processing engine. Enrollment Method describes how the employees will enroll for CIGNA Voluntary membership. Web • Encompasses all online websites where only the Group Administer makes ads, changes, terms to enrollees. IVR/Web • Used by Clients that allow member self enrollment either through the IVR system or one of the online websites. Manual • Describes Clients that will collect the enrollment information at the site level and provide CIGNA Voluntary with an electronic file in an agreed upon format. Files describes the file transmission requirements between CIGNA and the Client Full eligibility file • Sent from the client to CIGNA, listing all current employees who are eligible for the limited -medical benefit plan. (File layout included.) Initiation file • Sent from CIGNA to the client, listing members from whom the client should begin collecting payroll deductions. Confirmation file • Sent from the client to CIGNA, confirming members from whom the client is collecting payroll deductions.