Flowcharts of Data Management

							 Grants Reporting Flowchart

 Proposal completed                                                    Grant awarded by OVPR in
 in FIPRD                                                              FIPRD
    Proposal ID                          Proposal Approval               Chartfields assigned
    Project Numbers                      Summary Webform                  including ProjectID(s) and
     (not Project IDs)                                                     Speedtype
    No chartfields                                                       Contract Number (equals
     assigned yet                                                          Reference Award Number)




Grants transactions happen....


                   General Ledger                               Grants Management
                   tables updated                               tables updated in
                   in FIPRD                                     FIPRD




FIPRD tables copied to FIRPT Query tables/views overnight


 General Ledger data found in:                                Grants Management data found in:
 UOD_BALANCES                                                 UOD_PROJ_RES_VW #
 UOD_TRANS_DTL                                                UOD_PRJ_VW *
        EZQs and UDQs                                        UOD_PRP_ATRB_VW *
        Purpose is “king”                                    UOD_PRP_BUD_VW*
        Data is secured by Purpose                           UOD_AWD_ATRB_VW *
                                                              UOD_PROJ_FUND_VW *
                                                                   GMQs and PIQs
         BUDDY populated                                           Project ID is “king”
         from FIRPT tables                                         Data is secured by Dept ID* or
         every morning                                              Purpose #
         (best to use in the afternoon)                         

 0657b556-2e73-4e40-8e9a-a416208d2fe6.doc
 4/20/2011