ࡱ> ?> ɀ\plshirk Ba==;8X@"1Arial1Arial1Arial1Arial1Arial1Arial"$"#,##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\);_(* "-"??_);_(@_) mm/dd/yy m/d/yyyy0+#,##0.000000000000_);\(#,##0.000000000000\)#,##0.0_);\(#,##0.0\),'#,##0.0000000000_);\(#,##0.0000000000\)50#,##0.000000000000_);[Red]\(#,##0.000000000000\)m/d0.0_);[Red]\(0.0\)                + ) , *  (  #  # (# ( "0  !8 ( #    # (# (#4 ( $a@   " ( # (#4a@ # (" " (" "0 #4  $ # p@  t@  (t@  p    @ ( $ ` 4021 *4022 E4023 H4031' ExternalData1= ' ExternalData2=' ExternalData3=8b  ;  ;. Query_1_from_Payroll=<hMRateBeginDateEndYTD ExpenseNameSurplus/DeficitHourly 6/16-6/30 7/1-7/ 15 7/16-7/31TOTAL paydate -> payroll # -> payperiod ->8/1-8/15 8/16-8/319/1-9/15 9/16-9/30 10/1-10/15 10/16-10/31 11/1-11/15 11/16-11/30 12/1-12/15 12/16-12/311/1-1/15 1/16-1/312/1-2/15 2/16-2/283/1-3/15 3/16-3/314/1-4/15 4/16-4/305/1-5/15 5/16-5/316/1-6/15Year to date expenseBanner budget amountORG #POS #SS# BEGIN DATEEND DATE ENCUMBRANCE<-enter budgeted amount here<--enter budgeted amount hereTOTAL ENCUMBRANCEBUDGETED AMOUNTSURPLUS/DEFICITRANAMETA6/25-7/9 7/10-7/247/25-8/9 8/10-8/248/25-9/9 9/10-9/24 9/25-10/9 10/10-10/24 10/25-11/9 11/10-11/24 11/25-12/9 12/10-12/24 12/25-1/9 1/10-1/241/25-2/9 2/10-2/242/25-3/9 3/10-3/243/25-4/9 4/10-4/244/25-5/9 5/10-5/245/25-6/9 6/10-6/24J I R e dm vl rc l (~== = = =S.Н0=S =  =.H=_I=DMA_ip0SEP_T0Pt00CM ,zm00 E000߿0t0Query_1_from_PayrollN[NZ4 $0y 0>CT00T0#)!*y`10)T0yy!00Lw`T0`T0{T0{{T0DwXw w`T0 `T0Æ0H5`T0 ڬp08ם0p00 4 XpC4 XS]04 by%000+ <0- M  ɀ  *  dMbP?_*+%WT&CPUBLIC SAFETY HOURLY PAYROLL INFORMATION AS OF THE PAY PERIOD ENDING APRIL 1, 2003&R&D&?'?)?M\\ODU_TREE\FORD.BO.AO.ODU?dX,Letter.HP Color LaserJet 4550 PCL 62xePKkQ3Zظ-K5ULB&-t!ҍEFe&$(#ڕ E|xp9\̜NbmLrx IzĖY.TFVxhv: ;-Ih+q}qup1qclmʰЛ_Dt Å|eb1?Rw@uS$L͑”TsW}j E:F7Yz R>HpB =!;kIc6xc ~9 lKX/]bX;ؓE9K٢h7_R]f5ڝ5D>V# VZ=OITk~$UX,a t("݅ 9>e"ZX,??U} } m} $} $} I *} }  } } }  }  }  }  } } } } } } }  } Column B, >>T0>@>.>~>>>>> > >S. >S >  >.H>_I>DMA_0SEG GG  & & &                  ! " # $F((((((((((((((((((((((((((((((((=$ % % % (/ps@/s@/t@/ t@/t@/t@/y@/y@/Pz@/`z@/z@/{@/[@/\@/@^@/^@/``@/`@/`j@/j@/k@/k@/l@/m@ /F/(((((((((((((((((((((((((((((((= , , , , - -I@-K@-M@-O@-`Q@-@S@- U@- W@-Y@-Z@-\@- 1@-3@-5@-6@-8@-`:@-`<@-@>@- @@-B@-D@-E@-G@ -F--------------------------------=B""""""""""""""""""""""""" ) # %@)""""""""""""""""""# %)  -) )   )   )   @ +!  @  +!#   %  )  )  )# %)  + @+!)) +# %)  * #' %# -M:## # #  #  #  # # ##### %M:## %M:########## %D & 5- " DD>048FIk\AA3AckAA;AAc33EH.>@A  ɀ x+-  dMbP?_*+%"??DU} } } $ } } 4}  4} m} Column DColumn E?T03~ 0' 0( 0) 03 1* 1+ 2, 46 4/# %/ 40 5- 41" DDwdb 5>@A @I" ExternalData3D SELECT NHRDIST.NHRDIST_POSN, NHRDIST.NHRDIST_ORGN_CODE, AP_EMPLOYEE_PROFILE.SSN, AP_EMPLOYEE_PROFILE.LAST_NAME, AP_EMPLOYEE_PROFILE.FIRST_NAME, NHRDIST.NHRDIST_PAYNO, NHRDIST.NHRDIST_AMT, NHRDIST.NHRDIST_DR_CR_IND, NHRDIST.NHRDIST_EARN_CODE, NHRDIST.NHRDIST_HRS, NHRDIST.NHRDIST_TRANS_DATE, NHRDIST.NHRDIST_DOC_CODE, NHRDIST.NHRDIST_ACCT_CODE, NHRDIST.NHRDIST_FUND_CODE, NHRDIST.NHRDIST_PROG_CODE FROM BANINST1.AP_EMPLOYEE_PROFILE AP_EMPLOYEE_PROFILE, POSNCTL.NHRDIST NHRDIST WHERE AP_EMPLOYEE_PROFILE.PIDM_KEY = NHRDIST.NHRDIST_PIDM AND ((NHRDIST.NHRDIST_FISC_CODE='2003') AND (NHRDIST.NHRDIST_ORG|yN_CODE='1SF00') AND (NHRDIST.NHRDIST_ACCT_CODE='4021') AND (NHRDIST.NHRDIST_PAYNO=131)) ORDER BY AP_EMPLOYEE_PROFILE.SSNDRIVER={Oracle in Oracle8};SERVER=AIR_DB;UID=lshirk;PWD=SPRING16;DBQ=AIR_DB;DBA=W;APA=T;EXC=F;XSM=Default;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=Lo;BAM=IfAllSuccessful;MTS=F;MDI=Me;CSR=F;FWC=F;PFC=10;TLO=O;NHRDIST_DR_CR_IND, NHRDIST.NHRDIST_EARN_CODE, NHRDIST.NHRDIST_HRS, NHRDIST.NHRDIST_TRANS_DATE, NHRDIST.NHRDIST_DOC_CODE, NHRDIST.NHRDIST_ACCT_CODE, NHRDIST.NHRDIST_F41UND_CODE, NHRDIST.NHRDIST_PROG_CODE FROM BANINSTI" ExternalData2ST SELECT AP_EMPLOYEE_PROFILE.SSN, AP_EMPLOYEE_PROFILE.LAST_NAME, AP_EMPLOYEE_PROFILE.FIRST_NAME, AP_EMPLOYEE_PROFILE.ORGN_CODE_HOME, AP_EMPLOYEE_PROFILE.EMPL_FT_PT_IND, AP_EMPLOYEE_PROFILE.JOB_BEGIN_DATE, AP_EMPLOYEE_PROFILE.CURRENT_HIRE_DATE, AP_EMPLOYEE_PROFILE.JOB_ASSIGN_POSN_NUMBER, AP_EMPLOYEE_PROFILE.JOB_CURR_STATUS, AP_EMPLOYEE_PROFILE.CURR_ENCUMB_AMT, NHRDIST.NHRDIST_YEAR, NHRDIST.NHRDIST_PICT_CODE, NHRDIST.NHRDIST_PAYNO, NHRDIST.NHRDIST_SOURCE, NHRDIST.NHRDIST_FISC_CODE, NHRDIST.NHRDIST_FUND_CODE, NHRDIST.NHRDIST_ORGN_CODE, NHRDIST.NHRDIST_ACCT_CODE, NHRDIST.NHRDIST_PROG_CODE, NHRDIST.NHRDIST_AMT, NHRDIST.NHRDIST_DR_CR_IND, NHRDIST.NHRDIST_TRANS_DATE, NHRDIST.NHRDIST_POSN, NHRDIST.NHRDIST_HRS, NHRDIST.NHRDIST_EARN_CODE, NHRDIST.NHRDIST_DOC_CODE FROM BANINST1.AP_EMPLOYEE_PROFILE AP_EMPLOYEE_PROFILE, POSNCTL.NHRDIST NHRDIST WHERE AP_EMPLOYEE_PROFILE.PIDM_KEY = NHRDIST.NHRDIST_PIDM AND ((NHRDIST.NHRDIST_FISC_CODE='2003') AND (NHRDIST.NHRDIST_ORGN_CODE='1SF00') AND (NHRDIST.NHRDIS96T_ACCT_CODE='4021')) ORDER BY AP_EMPLOYEE_PROFILE.SSNDRIVER={Oracle in Oracle8};SERVER=AIR_DB;UID=lshirk;PWD=FALL14;DBQ=AIR_DB;DBA=W;APA=T;EXC=F;XSM=Default;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=Lo;BAM=IfAllSuccessful;MTS=F;MDI=Me;CSR=F;FWC=F;PFC=10;TLO=O;IN_DATE, AP_EMPLOYEE_PROFILE.CURRENT_HIRE_DATE, AP_EMPLOYEE_PROFILE.JOB_ASSIGN_POSN_NUMBER, AP_EMPLOYEE_PROFILE.JOB_CURR_STATUS, AP_EMPLOYEE_PROFILE.CURR_ENCUMB_AMT, N0-HRDIST.NHRDIST_YEAR, NHRDIST.NHRDIST_PICT_COD#I"Query 1 from PayrollHR SELECT AP_EMPLOYEE_PROFILE.SSN, AP_EMPLOYEE_PROFILE.LAST_NAME, AP_EMPLOYEE_PROFILE.FIRST_NAME, AP_EMPLOYEE_PROFILE.ORGN_CODE_HOME, AP_EMPLOYEE_PROFILE.EMPL_FT_PT_IND, AP_EMPLOYEE_PROFILE.JOB_BEGIN_DATE, AP_EMPLOYEE_PROFILE.CURRENT_HIRE_DATE, AP_EMPLOYEE_PROFILE.JOB_ASSIGN_POSN_NUMBER, AP_EMPLOYEE_PROFILE.JOB_CURR_STATUS, AP_EMPLOYEE_PROFILE.CURR_ENCUMB_AMT, NHRDIST.NHRDIST_YEAR, NHRDIST.NHRDIST_PICT_CODE, NHRDIST.NHRDIST_PAYNO, NHRDIST.NHRDIST_SOURCE, NHRDIST.NHRDIST_FISC_CODE, NHRDIST.NHRDIST_FUND_CODE, NHRDIST.NHRDIST_ORGN_CODE, NHRDIST.NHRDIST_ACCT_CODE, NHRDIST.NHRDIST_PROG_CODE, NHRDIST.NHRDIST_AMT, NHRDIST.NHRDIST_TRANS_DATE, NHRDIST.NHRDIST_POSN, NHRDIST.NHRDIST_HRS, NHRDIST.NHRDIST_EARN_CODE, NHRDIST.NHRDIST_DOC_CODE FROM BANINST1.AP_EMPLOYEE_PROFILE AP_EMPLOYEE_PROFILE, POSNCTL.NHRDIST NHRDIST WHERE AP_EMPLOYEE_PROFILE.PIDM_KEY = NHRDIST.NHRDIST_PIDM AND AP_EMPLOYEE_PROFILE.ORGN_CODE_DIST = NHRDIST.NHRDIST_ORGN_CODE AND ((NHRDIST.NHRDIST_FISC_CODE='2003') AND (NHRDIST.NHRDIS?<T_ORGN_CODE='1SF00') AND (NHRDIST.NHRDIST_ACCT_CODE='4021'))DRIVER={Oracle in Oracle8};SERVER=AIR_DB;UID=lshirk;PWD=FALL14;DBQ=AIR_DB;DBA=W;APA=T;EXC=F;XSM=Default;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=Lo;BAM=IfAllSuccessful;MTS=F;MDI=Me;CSR=F;FWC=F;PFC=10;TLO=O;IN_DATE, AP_EMPLOYEE_PROFILE.JOB_ASSIGN_POSN_NUMBER, AP_EMPLOYEE_PROFILE.JOB_CURR_STATUS, AP_EMPLOYEE_PROFILE.CURR_ENCUMB_AMT, NHRDIST.NHRDIST_YEAR, NHRDIST.NHRDIST_PI0-CT_CODE, NHRDIST.NHRDIST_PAYNO, NHRDIST.NHRDII" ExternalData1T_ SELECT AP_EMPLOYEE_PROFILE.SSN, AP_EMPLOYEE_PROFILE.LAST_NAME, AP_EMPLOYEE_PROFILE.FIRST_NAME, AP_EMPLOYEE_PROFILE.ORGN_CODE_HOME, AP_EMPLOYEE_PROFILE.EMPL_FT_PT_IND, AP_EMPLOYEE_PROFILE.JOB_BEGIN_DATE, AP_EMPLOYEE_PROFILE.CURRENT_HIRE_DATE, AP_EMPLOYEE_PROFILE.JOB_ASSIGN_POSN_NUMBER, AP_EMPLOYEE_PROFILE.JOB_CURR_STATUS, AP_EMPLOYEE_PROFILE.CURR_ENCUMB_AMT, NHRDIST.NHRDIST_YEAR, NHRDIST.NHRDIST_PICT_CODE, NHRDIST.NHRDIST_PAYNO, NHRDIST.NHRDIST_SOURCE, NHRDIST.NHRDIST_FISC_CODE, NHRDIST.NHRDIST_FUND_CODE, NHRDIST.NHRDIST_ORGN_CODE, NHRDIST.NHRDIST_ACCT_CODE, NHRDIST.NHRDIST_PROG_CODE, NHRDIST.NHRDIST_AMT, NHRDIST.NHRDIST_DR_CR_IND, NHRDIST.NHRDIST_TRANS_DATE, NHRDIST.NHRDIST_POSN, NHRDIST.NHRDIST_HRS, NHRDIST.NHRDIST_EARN_CODE, NHRDIST.NHRDIST_DOC_CODE FROM BANINST1.AP_EMPLOYEE_PROFILE AP_EMPLOYEE_PROFILE, POSNCTL.NHRDIST NHRDIST WHERE AP_EMPLOYEE_PROFILE.PIDM_KEY = NHRDIST.NHRDIST_PIDM AND AP_EMPLOYEE_PROFILE.ORGN_CODE_DIST = NHRDIST.NHRDIST_ORGN_CODE AND ((NHRDIST.NHRDIST_FISC_CODE=ZW'2003') AND (NHRDIST.NHRDIST_ORGN_CODE='1SF00') AND (NHRDIST.NHRDIST_ACCT_CODE='4021'))DRIVER={Oracle in Oracle8};SERVER=AIR_DB;UID=lshirk;PWD=FALL14;DBQ=AIR_DB;DBA=W;APA=T;EXC=F;XSM=Default;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=Lo;BAM=IfAllSuccessful;MTS=F;MDI=Me;CSR=F;FWC=F;PFC=10;TLO=O;IN_DATE, AP_EMPLOYEE_PROFILE.CURRENT_HIRE_DATE, AP_EMPLOYEE_PROFILE.JOB_ASSIGN_POSN_NUMBER, AP_EMPLOYEE_PROFILE.JOB_CURR_STATUS, AP_EMPLOYEE_PROFILE.CURR_ENCUMB_AMT, N0-HRDIST.NHRDIST_YEAR, NHRDIST.NHRDIST_PICT_COD ɀ FH  dMbP?_*+%"FRDIS??NHU} F} F} $ F} F} 4F}  4F} mF} FT03 0' 0( 0) 03 1* 1+ 2, 26 4/# %/ 40 5- 41" DDwdb 5>@ ɀ  IZ  dMbP?_*+%"??DU} $}  } I *} } } } } } } } } }  }  } } } } } } } } } } $ } } }  }  ==T0=@=.====== = =S. =S =  =.H=_I=DMA_YE0SEP_RCM ,NGG  &5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K LF((((((((((((((((((((((((((((((((<$ % % (/ps@/s@/t@/ t@/t@/t@/y@/y@/Pz@/`z@/z@/{@/[@/\@/@^@/^@/``@/`@/`j@/j@/k@/k@/l@/m@ /F/(((((((((((((((((((((((((((((((< , , , - -I@-K@-M@-O@-`Q@-@S@- U@- W@-Y@-Z@-\@- 1@-3@-5@-6@-8@-`:@-`<@-@>@- @@-B@-D@-E@-G@ -F--------------------------------<@""""""""""""""""""""""""" ) # %>)""""""""""""""""""# %)  -) )   )   )   > +!  >  +!#   %  )  )  )# %)  + >+!)) +# %)  * #' %# -M:### # #  #  #  # # #### %M:## %M:########## %D & 5. " DD>e0&*DGiZ??1?ai??9??a11CH.>@ Oh+'0HP`p lshirklshirkMicrosoft Excel@~^@"T@՜.+,D՜.+,( PXl t|  a;lsijrdfsd1 4021402240234031  Worksheets 6> _PID_GUIDAN{47BEB974-28BF-11D7-AF85-0001022B3CCC}  !"#$%&'()*+,-/012345789:;<=Root Entry F@WorkbookN[SummaryInformation(.DocumentSummaryInformation86