ࡱ> RQ T8\p Devore, Mark Ba==p08X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1$Arial1 Arial1Arial1Arial1Arial1Tahoma1Calibri1Calibri1 Calibri1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1Calibri1 Calibri1?Calibri1Calibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                                                                      ff + ) , *      P  P         `            a> !    @    " !    "  "X  "   "  #  " H $  % H    H !X ( ||S&p}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef [$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L [$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A}  00_)23[$ -}A}! 00_)23 [$ -}A}" 00_)[$ -}A}# 00_)[$ -}A}$ 00_)[$ -}A}% 00_)[$ -}A}& 00_)[$ -}A}' 00_) [$ -}A}( 00_)[$ -}}) }00_)[$ -##0.  }}* 00_)[$ -???##0.??? ??? ???}-}/ 00_)}A}1 a00_)[$ -}A}2 00_)[$ -}A}3 00_)?[$ -}A}4 00_)23[$ -}-}5 00_)}}7 ??v00_)̙[$ -##0.  }A}8 }00_)[$ -}A}9 e00_)[$ -}x}:00_)[$##  }}; ???00_)[$???## ???  ??? ???}-}= 00_)}U}> 00_)[$## }-}? 00_)}}J}-}K 00_)}}L}-}M <<<00_)}}N 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 : Followed Hyperlink 1Good;Good  a%2 Heading 1G Heading 1 I}%O3 Heading 2G Heading 2 I}%?4 Heading 3G Heading 3 I}%235 Heading 49 Heading 4 I}%6( Hyperlink 7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%"Normal :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title I}% >TotalMTotal %OO? Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16`vFQueries!tTablesS<What it delivers U_FIND_MY_REQ_INFOU_FIND_MY_PO_INFOU_FIND_MY_VOUCHER_INFOU_CASH_BALANCE_FUNDFind cash balance by fund IDU_CASH_BALANCE_PROJECTFind cash balance for a project(Shows all charges posted by department. U_FIND_NEXT_APPROVER3Identifies next action to be taken for requisitionsU_GL_JRNL_DETAIL_PPLANT %View detail of Physical Plant charges Query NameReturns Payments rec'd on projU_GM_PAYMENTS_RECEIVED BI_ACCT_ENTRY BI_CHARGE DST_CODE_TBL charge codesdistribution codesBI_ACCT_LN_STGBI_ACCT_HDR_STGBI_LOADGL_PROC=this Load GL process table facilitates restarting the process4provides accounting data for the BI_ACCT_ENTRY tabledbilling accounting entries (debit and credit); acquires data from BI_ACCT_LN_STG and BI_ACCT_HDR_STGTableTable Description Relates to U_PAYMENTS_BY_AMOUNTU_PAYMENTS_BY_DATEU_PAYMENTS_BY_DEPOSITU_YE_OPEN_REQS_BY_DEPT(Shows open requisitions by Department IDFIND_OPEN_ITEMSFind open AR items by amountU_LIST_INITIATIVE_CF7List of all initiatives (initiative chart field values) U_CF_PRODUCT&List of all product chart field valuesU_LIST_DEPTID_CF U_CF_FUND)List of all fund ID's (fund chart field)5List of all department ID's (department chart field)3List of all GL account codes (account chart field) U_CF_ACCOUNTU_TE_TRANS_BY_PCARD_DEPT 2Locate Pcard charges residing in a traveler walletU_PCARD_CHGS_POSTED_DEPTPhysical PlantCash, Payments, and ARChart Field InformationReqs, PO's, Pcard and TravelU_PCARD_PROXY_BY_DEPT_ID9Shows department cardholders, charge limits & reconcilersU_PCARD_CRDHLDR_FOR_PROXY.Shows all cardholders assigned to a reconcilerU_PCARD_PROXY_FOR_CRDHLDR6Shows all reconcilers (proxy) assigned to a cardholderU_PCARD_UNAPPD_DEPT_CHGS-Shows all unapproved charges for a department Last UpdateU_TRAVEL_PYMT_V3U_PAYROLL_POSTING_ABRIDGEDPayrollU_GM_FIND_MY_GFA ,To identify a grants financial administratorU_PCARD_TRAVELFor PCARD reconcilerstSearch by PO; find Req, voucher, and check number; query assumes a voucher has been issued and distributed to the GLtSearch by Req; find PO, voucher, and check number; query assumes a voucher has been issued and distributed to the GLtSearch by Voucher; find PO, Req, and check number; query assumes a voucher has been issued and distributed to the GLU_FIND_MY_VOUCHER_NO_POU_DEPOSIT_ENTRIES_BY_DEPTU_YE_ROLLED_PO_ERROR_DEPTU_YE_ROLLED_PO_ERROR_PROJECT/Shows a list of Pos in error during PO rolleverU_YE_OPEN_POS_BY_DEPT*Shows open purchase orders by Deparment ID U_KK_ROSETTA2A GEMS query for payroll detail for reconciliationU_KK_ROSETTA_ITEMXCorrelates the budget account codes with GL expense codes and purchasing item categoriesQRelate GL codes to budget codes or budget codes to GL codes for research activityU_YE_OPEN_POS_BY_PROJ(Shows open purchase orders by Project ID'Shows open purchase orders by RequestorU_YE_OPEN_REQS_BY_PROJ%Shows open requisitions by Project ID$Shows open requisitions by RequestorU_YE_PART_MATCH_RECEIVERU_YE_PART_MATCH_RECV_POU_YE_PART_MATCH_DEPTU_YE_PART_MATCH_PROJ/Find partially matched receipts by Fast User ID,Find partially matched receipts by PO numberCFind partially matched receipts by Operating Unit and Department ID-Find partially matched receipts by Project IDU_CF_PROJECT_GRANTSSList of all sponsored research projects (add search criteria of college/department)*Find customer payments searching by amount3Find customer payments searching by date of deposit=Find customer payments searching by the deposit ticket number[Returns a list of all travelpayments on a chart field/ best to add a date range in criteriawSearch by department and time frame; view journal lines with chart fields; also includes interdepartmental transactionsU_YE_OPEN_REQS_BY_REQUESTERU_YE_OPEN_POS_BY_REQUESTERU_FIND_MY_REQ_INFO_BY_DEPTuSearch by DEPT; find PO, voucher, and check number; query assumes a voucher has been issued and distributed to the GLU_FIND_MY_PO_INFO_GRANTU_FIND_MY_PO_INFO_REVResearchU_GM_ACT_DIRECT_INDIRECT_COSTSThis query returns the PI, Sponsor, Award Begin Date, Award End Date, Direct and Indirect Costs. The user is prompted for a FAST DeptID.AWARDS_BY_ENDDATE4hThis query lists all awards that will reach the end date (from contract line) within a given date range.U_AM_PROPERTY_LIST)Produce a list of assets for a departmentU_AM_PROPERTY_LIST_BY_PROJTrack project assets and assist Asset Management with annual inventories. Returns associated FAST chartfield information, Tag #, Manu (Manufacturer), Descr (Description), Serial #, Location,U_GM_AWARD_PI_CPIThis query can be used to lookup all sponsored projects, where an employee has been assigned the Project Role of PI or CPI (CoPI).U_GM_LIST_UNDERWRITES;This query lists initial and bridge underwrite information.>This query is used to identify payments received on a project.U_GM_RSCH_RIA_FUND_RSA#RSA- New research initiative awardsFixex Assets - PropertyU_ASSETS_BY_MY_DEPARTMENTU_ASSET_PRR_STAT_BY_AO_AODU_ASSET_PRR_STAT_BY_SUBMITTERU_ASSET_PURCH_REFU_ASSET_TRF_STAT_BY_AO_AODU_ASSET_TRF_STAT_BY_SUBMITTER'In process relief requests by AO or AOD'In process relief requests by submitter!In process transfers by AO or AOD!In process transfers by submitterGeneral LedgerU_GL_LEDGER_ACTUALSkView activity in the Actuals ledger for selected fiscal years; enter prompt for chart field and fiscal yearR/ 011W23x456d8 9} A; >< =?aACKD9ccB T8 Qdjps  dMbP?_*+%&?'?(?)?M:\\usfps2003.forest.usf.edu\ADM\C odXXLetter DINU"8t[kR78SMTJ(HP LaserJet 9000 PCL 6InputBinFORMSOURCERESDLLUniresDLLHPDocUISUITrueEdgeToEdgeFalseResolution600dpiFastResTrueHPStaplingOpposedFalseOrientationPORTRAITHPOrientRotate180FalsePaperSizeLETTERMediaTypeAutoESPRITSupportedTrueDuplexNONEAlternateLetterHeadFalseHPPaperSizeALMConstraintsENV_10HPJobByJobOverrideJBJOHPDuplicateJobNameOverrideSWFWHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPNUseDiffFirstPageChoiceTRUEHPPageExceptionsFileHPCPE5r1HPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsLowEndHPPageExceptionsLowEndVerHPPageExceptionsCoverInsertionOutputBinAutoStaplingNoneStaplingCmdCallbackStaplingCmdCbCollateONHPConsumerCustomPaperTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDPartialJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffTTAsBitmapsSettingTTModeOutlineRETChoiceTrueJRCmdCallbackJRHPColorModeMONOCHROME_MODEHPXMLFileUsedhpc90006.xmlHPPDLTypePDL_PCL6PrintQualityGroupPQGroup_1HPDocPropResourceDatahpchl5r1.cabPSAlignmentFileHPCLS5r1HPSmartHub_OnlinediagnostictoolsTRUEHPSmartHub_SupportandtroubleshootingTRUEHPSmartHub_ProductmanualsTRUEHPSmartHub_CheckfordriverupdatesTRUEPSServices_DeviceandSuppliesStatusTRUEHPSmartHubInet_SID_263_BID_276_HID_265PSServicesOptionPrnStat_SID_242_BID_270_HID_15521EconomodeFalseHPJobAccWoPinTrueTextAsBlackFalseHPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPFontInstallerTRUEIUPHxn@?*ErKA1DF4`!4.DjIIB%G+Z 7۸u\r0Uىwg-]A҉A0*[ 5N|>: >+?8"y6&#W9YorOuT"J*8ޠ~(c bHŸC;O . x(3WƏ۴O|jb6CK;i+cm wbdqc,v@. A _{DE 8u2uC(ؑ(2:[oλ̹M򵩽W[ej#S8xJj9aS&5cӶ$k Y-q>hFyQ 2 2CG3dZeJ87ϑZj\%3϶asDs@$qs aKXcwrKH3_( 5emv睌Et>3=oacޣE-klS֨K[@ghzGrŔM};VazآSry]YU9x1{gۏ3 ‡ٽzݥ\(((('H5"dXX??&U} #} wQ,,,, , , , , ,,,,,,,E,E,E,E,E,E,E,E,E,E,E,,A @ @D @AJ@ D>@ D@ F5 KK JM KL JM L LG Ll Lm L LF Ln LF Lo LF L LH MI LH J1 L L6 L7 L8 L9 L: L; L< L= J/ L0 N! L" NX LY Nj LZ JN LO JU LV Jk LW J[ L_ J\ L` J] La J^ Lb L L L? LhDl+ ,!"#,$%&,E'E(),E*,+,,,-,.,/,0,23,4,5,6,7,8,9,:,;,<,=,>,?, LD LE !AA "G"A #I #L $AA %G2%A &I &I (H3 )O )O *P *P +P +P ,QJ ,Ii -P -Ie .P .If /P /Ig 0I# 0I$ 2F4 3P. 3I- 4P* 4I+ 5P) 5I, 6P' 6I( 7P% 7I& 8Pc 8Id 9PI :F:I ;P;I <P <I =P =I >P>I ?P ?IBZX@,BC,EF,G,HI,J,KLMNOP @P @I BFA CP@ CIQ EFp FPB FIC Gu GIv Hw HRx IPP IIT JPR JIS Kq Kr Ls Lt My Mz N{ N| O O} P~ P">@IJ$$$7ggD T8 ~  dMbP?_*+%&?'?(?)?M \\clusterprinter\LANIERLD015-A odXXLetter (8.5" x 11")LANIER LD015 PCL 6LPT1:   q ''''ddo Default"dXX??&U} m$} [} I@ C C C           B ^x*>@  7ggD Oh+'0@HTl ucoDevore, MarkMicrosoft Excel@ @i՜.+,0 PXh px USF-IT QueriesTables  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@BCDEFGHJKLMNOPRoot Entry FWorkbookSummaryInformation(ADocumentSummaryInformation8I