邢唷��>� R������Q������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������ T8�衫����\pDevore, 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% - Accent1ef苕��%�
20% - Accent2�M�"�
20% - Accent2ef蜍��%�
20% - Accent3�M�&�
20% - Accent3ef腭��%�
20% - Accent4�M�*�
20% - Accent4ef溥��%�
20% - Accent5�M�.�
20% - Accent5ef陬��%�
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% - Accent123暢�����%�
60% - Accent2�M�$�
60% - Accent223跂�����%�
60% - Accent3�M�(�
60% - Accent323淖�����%�
60% - Accent4�M�,�
60% - Accent423睜�����%�
60% - Accent5�M�0�
60% - Accent523捦�����%�!
60% - Accent6�M�4�
60% - Accent6 23�����%�"Accent1�A��Accent1O伣�����%�#Accent2�A�!�Accent2繮M�����%�$Accent3�A�%�Accent3浕Y�����%�%Accent4�A�)�Accent4€d�����%�&Accent5�A�-�Accent5K�����%�'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 1I}�%O伣��3 Heading 2�G�� Heading 2I}�%�?Э��4 Heading 3�G�� Heading 3I}�%23暢��5 Heading 4�9�� Heading 4I}�%�6€��(�� Hyperlink�
7Input�u��Input��虣��??v�%������ ���8Linked Cell�K��Linked Cell�鷠�%��€��9Neutral�A��Neutral��霚��渆�%�€��"��Normal� :Note�b�
�Note�����膊��膊��膊� �膊��;Output�w��Output�蝌��???�%�???��???��???� �???��<€��$��Percent�
=Title�1��TitleI}�%�
>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_CHARGEDST_CODE_TBLcharge 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 DescriptionRelates 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 departmentLast 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 IDU_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謈竪rKH�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� PXhpx€�
���USF-ITQueriesTablesWorksheets
!"#$%&'()*+,-./0123456789:;<�=>?@���BCDEFGH���JKLMNOP���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������Root Entry�������� �F���Workbook�������������SummaryInformation(����ADocumentSummaryInformation8������������I