GFT Data Flow and Feeds

GFT Data Flow: 

• Utility data flow:

  • Non PDF flow: Run GFT App -> RawEmail -> TransformedEmail

  • PDF flow: Run GFT App -> PDFEmail -> RawEmail -> follows the rest of Non PDF Flow

  • Trigger set up to run this process automatically

• Rent Payment flow:

  • Run GFT App -> Select individual email instead GPL email (Default)

  • RawEmail -> TransformedEmail -> BankSheet

• Export Phase

  • Review/Copy/Paste results in TransformedEmail and BankSheet to Export sheet

  • Export sheet -> SortExport sheet -> ImportUtilityCosts::UtilsDS

GFT Staging and Publishing: 

• Export Phase

  • Review/Copy/Paste results in TransformedEmail and BankSheet to Export sheet

  • Export sheet -> SortExport sheet -> GFT Data 

• GFT Staging

  • GBTData and GFTData => SortDS1 => Publish1 

• Reporting:

  • PublishSelect1 => Query based

  • Category based PVT reports: Rent1, HOA1, Tax1(Property Taxes), Insurance1(Home Warranty), Expense1(Invoices,  Home Depot, contracts, etc)