• mcmu4256 - Friday, February 9, 2018 2:38 PM

    Does this help?  Just a small sample of the tables.

    Loan Table:
    ProcessDate-------------ParentAccount-----------CloseDate-------------ChargeOffDate----------------OriginalBalance---------------Type
    20180208-------------------0000012430-------------NULL--------------------NULL------------------------------NULL---------------------------77
    20180208-------------------0000017770-------------NULL--------------------NULL------------------------------NULL---------------------------77
    20180208-------------------0000017770-------------NULL--------------------NULL------------------------------500-----------------------------77

    Savings Table:
    ProcessDate------------ParentAccount-------------ShareCode-------------CloseDate
    20180208-----------------0000012430---------------------1------------------------NULL
    20180208-----------------0000017770---------------------1------------------------NULL
    20180208-----------------0000017770---------------------1------------------------NULL

    Account Table:
    ProcessDate--------------AccountNumber------------CloseDate
    20180208--------------------0000012430------------------NULL
    20180208--------------------0000017770------------------NULL

    No, that's a document, not data.  J. Livingston posted a link on how to post data and I also have a link in my signature.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA