1 / 18

GECU El Paso Texas Membership Records Management

Explore how GECU in El Paso, Texas manages customer/member records through CIF datasets and identifies duplicate suspect reports efficiently and accurately.

hagerman
Download Presentation

GECU El Paso Texas Membership Records Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. RCIF Consolidation GECU: El Paso, Texas (TX51) GECU (TX51) • Member-owned not-for-profit financial cooperative (aka: Credit Union) • Located in El Paso, Texas • Chartered on August 30, 1932 under the name of Federal Employees Credit Union of El Paso • Federal (Civil Service) employees • 1967: added family member of Civil Service employees • 1997: expanded to anyone living or working in El Paso County that is not eligible for membership at another credit union through occupation • 2005: expanded into the state of New Mexico –within 25 mile radius of a branch located close to the Texas/New Mexico border • May, 1933 became Government Employees Credit Union • January 1973 name change to Government Employees Credit Union of El Paso • October 2005 name change to GECU and adopted “Greater Employees Credit Union” as a marketing tagline • In hopes of better describing our field of membership • 303,728 Members (March 2013) • 679 employees (March 2013) • $2 Billion + in assets (February 2013: 2,000,421,000.00 Two Billion 421 Thousand)

  2. RCIF Consolidation GECU: El Paso, Texas (TX51) Customer Records @ Miser Datasets • Customer/Member information is stored in the following datasets: • CIF Key (CFK-) • CIF History (CFHIS-) • Customer Identification (CFMID-) • Customer Master (CFM-) • CFM Trailer (CFMTR-) • IRS Trailer (IRS-)

  3. RCIF Consolidation GECU: El Paso, Texas (TX51) Customer Records @ Miser Datasets • CIF Key (CFK) • The CIF Key is used as a two-way pointer record used to link customer/member information to account information, and account information to customer information. • It is also used to store customer/member to customer/member relationship records identified by application code 30 (RCIF). • Each field begins with prefix CFK-.

  4. RCIF Consolidation GECU: El Paso, Texas (TX51) Customer Records @ Miser Datasets • CIF History (CIFHS) • The CIF History dataset stores old information for those database fields in the: • Each field begins with a prefix CIFHS-. • CIF Key (CKF-). • Customer Master (CFM-). • CFM Trailer (CFMTR-) • Customer Identification (CFMID-).

  5. RCIF Consolidation GECU: El Paso, Texas (TX51) Customer Records @ Miser Datasets • Customer Identification (CFMID) • The Customer Identification dataset stores customer/member identification information, such as the customer’s driver’s license number. • Each field begins with the prefix CFMID0.

  6. RCIF Consolidation GECU: El Paso, Texas (TX51) Customer Records @ Miser Datasets • Customer Master (CFM) • The Customer Master dataset stores all information related to the customer/member • Each field begins with the prefix CFM-. • One record exists for each customer. • Also used to store seasonal and • Alternate address information

  7. RCIF Consolidation GECU: El Paso, Texas (TX51) Customer Records @ Miser Datasets • CFM Trailer (CFMTR) • The CFM Trailer is used to store information related to the customer/member, including email address, fax phone number, preferred language, driver’s license number • Each field begins with the prefix CFMTR-.

  8. RCIF Consolidation GECU: El Paso, Texas (TX51) Customer Records @ Miser Datasets • IRS Trailer (IRS) • The IRS Trailer is used to store an image of the customer information that was originally submitted to the IRS for the year • Each field begins with the prefix IRS-.

  9. RCIF Consolidation GECU: El Paso, Texas (TX51) Customer Records @ Miser Dupresolver Reports • CFM-TAX-ID-TYPE (29) • Field that identifies the value in CFM-TAX-ID-NBR • Values are: • 0 = Social Security Number (SSN) (certified) • 1 = Employer Identification Number (EIN) (certified) • 2 = Social Security Number (SSN) (noncertified) • 3 = Employer Identification Number (EIN) (noncertified) • 4 = Individual Tax Identification Number (ITIN) (certified) • 5 = Individual Tax Identification Number (ITIN) (noncertified) • 6 = No Tax Identification Number • 7 = Tax Identification Number applied for

  10. RCIF Consolidation GECU: El Paso, Texas (TX51) Customer Records @ Miser Stand-alone Customer • Stand-alone customer • A customer master (CFM-) record exists for a customer/member who has no accounts with your institution • Dependent on account PURGE frequency (varies per institution)

  11. RCIF Consolidation GECU: El Paso, Texas (TX51) CFD061: Duplicate Suspects Report • Report identifies duplicate suspects when: • Add New Customer To Account (NC1) is processed • Customer Maintenance (CM1) is processed • Printed in Customer Number sequence

  12. RCIF Consolidation GECU: El Paso, Texas (TX51) GECU Process for RCIF Consolidation Pull the CFD061 • Pull the Customer profile (CPR) • Compare the following: • Customer Type • Date of Birth • TIN Number • TIN Type • TIN Certification • Employee Code

  13. RCIF Consolidation GECU: El Paso, Texas (TX51) • Compare information between the two RCIF records • If duplicates don’t have a Tax ID Number, confirm they have foreign status- W8 on file • CFM-CERT-TYPE (If Foreign, procedures indicate should have a value = 1 (Form W-8BEN filed) • Take note of Date of Birth on both records • Tax Certification: • Must match between records • If one record reflects certified, this is indication proper documentation has been signed and can FM RCIF record (non-certified one) to reflect findings of certification • If do not have Tax ID and/or Certification • Date of Birth • Must match • If does not, pull Membership paperwork from Cold Storage to confirm if system input is accurate. Update accordingly and assure both records match

  14. RCIF Consolidation GECU: El Paso, Texas (TX51) • Perform the Customer Maintenance transaction to match records • The OLDEST RCIF record will be retained • Update to most current data • Match the following • Customer Type • TIN Number • TIN Type • TIN Certification • Employee Code • Perform the Consolidate Customers (CCR) transaction • Select the OLDEST as the survivor • Input RCIF number for both records

  15. RCIF Consolidation GECU: El Paso, Texas (TX51) • To assure the documents imaged under the deleted (merged) RCIF get re-imaged correctly, complete the Image Re-File form

  16. RCIF Consolidation GECU: El Paso, Texas (TX51) GECU’s Challenges • RCIF records created by large amount of employees • Geographical location – increase of Foreign RCIF records (No TAX ID) • Name duplication • Multiple members with same name • Maria Hernandez • Juan Gonzalez • Main reason we do not utilize the CFR001 Duplicate Resolver Program

  17. THANK YOU Shelly D. Clark Business Analyst | GECU Project Management Office O (915) 774-4721 C (915) 637-4894 Toll Free: 1-800-772-4328 ext. 4721

More Related