Download
1 / 18

RCIF Consolidation GECU: El Paso, Texas (TX51) - PowerPoint PPT Presentation


  • 99 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' RCIF Consolidation GECU: El Paso, Texas (TX51)' - gema


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

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)


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-)


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-.


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-).


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.


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


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-.


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-.


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


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)


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


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


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


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


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


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


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


ad