slide1
Download
Skip this Video
Download Presentation
RCIF Consolidation GECU: El Paso, Texas (TX51)

Loading in 2 Seconds...

play fullscreen
1 / 18

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


  • 100 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
slide2
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)
slide3
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-)
slide4
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-.
slide5
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-).
slide6
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.
slide7
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
slide8
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-.
slide9
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-.
slide10
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
slide11
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)
slide12
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
slide13
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
slide14
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
slide15
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
slide16
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
slide17
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
slide18
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