邢唷��>� R������Q������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������ T8�衫����\p Devore, Mark B�a�=���=€p�08X@�"��1���Arial1���Arial1���Arial1���Arial1���Arial1���Arial1���Arial1�$�Arial1� �Arial1��Arial1���Arial1���Arial1���Tahoma1���Calibri1��Calibri1� �Calibri1��Calibri1� �Calibri1��Calibri1�4�Calibri1� �Calibri1��Calibri1��Calibri1,8�Calibri18�Calibri1�8�Calibri1�>�颁补濒颈产谤颈1�4�颁补濒颈产谤颈1�<��Calibri1�?�Calibri1h8�Cambria1��Calibri1� �Calibri1���Calibri1� �Calibri1�?�Calibri1��Calibri"$"#,##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\)�� � �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� � � �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �� � � �� 攆f��� �+� �� �)� �� �,� �� �*� �� �� �� ���� �� �� �� �P� �� �P � �� � � �� �� � ��� �� �� � � �� �`� �� �� � � �  � �� ���� � � �� �� �� � � �a>� �!� �� � � � @� �  � �"� �!� � � � "� � "X� � "� � � �" � �# � �" H� �$ � �% H� � � � H� �!X� �(� ||S&鈖飣A} 00_)ef[$� -}A} 00_)ef[$� -}A} 00_)ef[$� -}A} 00_)ef[$� -}A} 00_)ef[$� -}A} 00_)ef [$� -}A} 00_)蘈[$� -}A} 00_)蘈[$� -}A} 00_)蘈[$� -}A} 00_)蘈[$� -}A} 00_)蘈[$� -}A} 00_)蘈 [$� -}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 a�00_)骑�[$� -}A}2 00_)[$� -}A}3 00_)�?[$� -}A}4 00_)23[$� -}-}5 00_)}�}7 ??v�00_)�虣�[$� -�##0.� � �}A}8 鷠�00_)�€�[$� -}A}9 渆�00_)�霚�[$� -}x}:���00_)膊��霚�[$膊��## 膊�� 膊��}�}; ???�00_)蝌�[$???�## ???�  ???� ???�}-}= 00_)}U}> 00_)[$## }-}? ��00_)}}J}-}K ��00_)}}L}-}M <<<�00_)}}N� 20% - Accent1�M�� 20% - Accent1 ef苕� �%� 20% - Accent2�M�"� 20% - Accent2 ef蜍� �%� 20% - Accent3�M�&� 20% - Accent3 ef腭� �%� 20% - Accent4�M�*� 20% - Accent4 ef溥� �%� 20% - Accent5�M�.� 20% - Accent5 ef陬� �%� 20% - Accent6�M�2� 20% - Accent6  ef� �%� 40% - Accent1�M�� 40% - Accent1 蘈柑� �%� 40% - Accent2�M�#� 40% - Accent2 蘈娓� �%� 40% - Accent3�M�'� 40% - Accent3 蘈劁� �%� 40% - Accent4�M�+� 40% - Accent4 蘈汤� �%� 40% - Accent5�M�/� 40% - Accent5 蘈忿� �%� 40% - Accent6�M�3� 40% - Accent6  蘈� �%� 60% - Accent1�M� � 60% - Accent1 23暢� ����%� 60% - Accent2�M�$� 60% - Accent2 23跂� ����%� 60% - Accent3�M�(� 60% - Accent3 23淖� ����%� 60% - Accent4�M�,� 60% - Accent4 23睜� ����%� 60% - Accent5�M�0� 60% - Accent5 23捦� ����%�! 60% - Accent6�M�4� 60% - Accent6  23� ����%� "Accent1�A��Accent1 O伣� ����%� #Accent2�A�!�Accent2 繮M� ����%� $Accent3�A�%�Accent3 浕Y� ����%� %Accent4�A�)�Accent4 €d� ����%� &Accent5�A�-�Accent5 K� ����%� 'Accent6�A�1�Accent6  鳀F� ����%�(Bad�9��Bad ��俏� ���%�) Calculation���� Calculation �蝌� �鷠�%������ ���* Check Cell��� Check Cell �ゥ� ����%�???��???��???� �???��+€�� ��Comma�,€��(�� Comma [0]�-€��&��Currency�.€��.�� Currency [0]�/Explanatory Text�G�5�Explanatory Text ��%�0€ ��:� �Followed Hyperlink� 1Good�;��Good �骑� �a�%�2 Heading 1�G�� Heading 1 I}�%O伣��3 Heading 2�G�� Heading 2 I}�%�?Э��4 Heading 3�G�� Heading 3 I}�%23暢��5 Heading 4�9�� Heading 4 I}�%�6€��(�� Hyperlink� 7Input�u��Input ��虣� �??v�%������ ���8 Linked Cell�K�� Linked Cell �鷠�%��€�� 9Neutral�A��Neutral ��霚� �渆�%�€��"��Normal� :Note�b� �Note �����膊��膊��膊� �膊�� ;Output�w��Output �蝌� �???�%�???��???��???� �???��<€��$��Percent� =Title�1��Title I}�%� >Total�M��Total �%O伣�O伣��? Warning Text�?� � Warning Text ���%�X��TableStyleMedium9PivotStyleLight16`�vFQueries�!tTables�������縎�<��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_COSTS�This 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_PROJ�Track 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_CPI�This 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 year��R/ 0�1��1W�2��3x�4��5��6�d8 �9} A;� ><�� �=��?�aA慍KD9cc���B����� T8�衫 Q襠鵭沺晄  d褚MbP?_*+�€%�����&�?'�?(�?)�?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_600DPIHPPJLEncodingUTF8HPFontInstallerTRUE�IUPHx滍櫹n覢�?�*E汊K�A1D庑F4`��!4.Dj摠II笗B��徖%G€+鈀� 噶7鄹u\況�0U娣�郴賶綖醅wg粪-]€A覊A0*[ 5揘魮|>: >稅剠介��+剬?�8怙�"y6灐�&�#榃9Y椠or碠uT睉�"J*8屴��齸(c b鞨宋聼鎵頒�; . x倗(3W茝鄞O踻媕b�6狢K祮;i+c瑒m嫀 梬bdqc�,v樘@.� 銩� 蔩温醷紻E 8蛈2u淐�(守懘�(�2:�[刼位短箛M唑旦健W[ej�#朣憜�8x櫠襃j�9嚞櫭aS&妪5c�接稇$択樏 �Y-嗶q>袋彥県逨yQ� 2� �白2C喌G�3d賈羍J󪀱蠎蚙踵j\��%3隙asD漵@$qs ⑶aKX謈竪rKH�3圍_戥(� �5�e坏裮v鐫屵驟瀟>3�=o夋a蓿E斍-klS嵵↘守鈁@自琦黦h﹝餑r艛�慚迃�;V屿a姠�z丌霺魊y伏註Y蘒�9痻1辿g佛鲔�3彶鲝 �钜下囐經熚骶z掭§劈储(姠(姠(姠('€�H�5�"dXX�?�?�&�U} �#} 踳Q�����,,,, , , , , ,,,,,,,€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?� Lh�D�l+ ,!�"�#,$�%�&,€E'�€E(�),€E*,+,,,-,.,/,0,2�3,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�� ?I��BZX@,B�C,E�F,G,H�I,J,K�L�M�N�O�P�� @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�"�>�@I��J$$$�7gg����D T8�衫 鮺泙  d褚MbP?_*+�€%�����&�?'�?(�?)�?M� \\clusterprinter\LANIERLD015-A���� odXXLetter (8.5" x 11")LANIER LD015 PCL 6LPT1:� �� � q ��''''dd���o� Default�"dXX�?�?�&�U} m$} 抂} I�������@� C� C� C� � � � � � � � � � � B� �^x*>�@��  �7gg����D �鄥燆鵒h珣+'迟0�@HTl � ���ucoDevore, MarkMicrosoft Excel@€ づ埱@€蒺賗庇�胀諟.摋+,0� PXh px€� � ��USF-IT QueriesTables  Worksheets  !"#$%&'()*+,-./0123456789:;<�=>?@���BCDEFGH���JKLMNOP���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������Root Entry�������� �F���Workbook�������������SummaryInformation(����ADocumentSummaryInformation8������������I