Rcif consolidation gecu el paso texas tx51
This presentation is the property of its rightful owner.
Sponsored Links
1 / 18

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


  • 70 Views
  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

RCIF Consolidation GECU: El Paso, Texas (TX51)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


Rcif consolidation gecu el paso texas tx51

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


  • Login