Payroll

• 123 CONVERGYS_TABLE in GENERAL_TABLE help informaiton.sql

123 CONVERGYS_TABLE TO GENERAL_TABLE.sql

123 CREATE CONVERGYS CROSSWALK TABLE FOR BNI123 FILE.sql

123 DEPENDANT_CARE Flag.sql

123 DISABILITY Flag.sql

123 EMPLOYEE AMOUNTS.sql

123 EMPLOYEES.sql

123 EMPLOYERS AMOUNTS 2.sql

123 EMPLOYERS AMOUNTS.sql

123 FLAG FIELDS.sql

123 Health flag.sql

123 HSA Flag.sql

123 INSERT STATEMENTS WITH DATA.sql

123 Life Flag.sql

123 LIMITED_MEDICAL_CARE Flag.sql

123 MEDICAL_CARE_SPENDING Flag.sql

123 Optional Life Flag.sql

123 OVERAGE_DEPENDANT flag.sql

123 Summary Report for Rick.sql

123 SUPPLEMENTAL Flag.sql

123 UWF_GENERAL_TABLE QUERIES FOR BNI123.sql

27 PAYS IN 2009.sql

9 month Faculty with Annual Leave balance.sql

9Month Benefit Codes and descriptions.sql

9month current deductions.sql

9month faculty active without a job record.sql

9month faculty CURRENT.sql

9month faculty deductions pay 19 2008.sql

9monthandBni001fileFix.sql

9monthFacultyHealthInsuranceDataPaynumber6of2007.sql

9monthFacultyPLBD.sql

9monthFacultywithCertainDeductionsFor any given payno pay year.sql

9monthWithoutJobs.sql

Action sheet data for Bdaley.sql

active employees with no active job record.sql

ACTIVE FACULTY WITHOUT JOB.sql

Active line item no active current job.sql

activeEmployees for kay and Linda 2-1-2008.sql

activeEmployees.sql

ActiveEmployeesNotPaidSince01012007.sql

activePEBEMPLnoJob V 2.sql

activePEBEMPLnoJob.sql

activePEBEMPLnoJobV0.sql

activePEBEMPLnoJobV1.sql

activePEBEMPLnoJobVforReport.sql

Activity in HR for a date.sql

ADDRESS ADVANCED.sql

ADDRESS BASIC ADVANCEMENT DIVISION.sql

ADDRESS BASIC.sql

ADDRESS FROM ODS WITH CERTAIN DEDUCTIONS.sql

ADDRESS FROM ODS WITHOUT CERTAIN DEDUCTIONS.sql

adjuncts and employees.sql

adjuncts.sql

adjunctswith.sql

adjunctswithDegree.sql

adjunctswithoutDegree.sql

Admin and Professiona for Catalogue.sql

AFSCME_PBA_BONUS09 pop selection for Billy.sql

afsme bargaining unit employees - paying dues.sql

afsme bargaining unit employees.sql

AGE REPORT FROM ODS.sql

All bargaining unit employees - paying dues.sql

AllTimeSheetsLeavereportsView.sql

APPROVERS LIST BY ORGN AND BY POSITION.sql

APPROVERSAMEASEMPLOYEE.sql

BargUnitCodesForAFSME.sql

BargUnitCodesForFaculty.sql

BargUnitCodesForFacultyWithIndex.sql

BargUnitCodesForFacultyWithIndex.VisitingFacultysql.sql

BNI001 CHANGES FOR RESEND.sql

BNI001 CHANGES.sql

bonus and other payments for 2006.sql

bonus and other payments for 2007.sql

bonus and other payments for 2008.sql

build xo_health table.sql

Campus Address for UWF employees.sql

CAMPUS ADDRESS.sql

cgentry data entry.sql

Chairs Admin codes.sql

Cindy-EmployeebyClass report with race and gender.sql

COUNTS FROM PHRHIST AND PERJOBS BY PAYNO AND PAY YEAR.sql

COUNTS FROM PHRHIST.sql

date entered or updated by a specific user.sql

DBS_REPORT for Fay July 2007.sql

debug phahour report pay no 15 2008.sql

deduction report for jeff Special report with cross walk.sql

deduction report for jeff Special report.sql

Deductions OR2 Negative amounts for 2008.sql

DeductionsCurrent DA1 and DA2.sql

DeductionsCurrent DU1 DU2.sql

DeductionsCurrent for Jeff 4-22-2008.sql

DeductionsCurrent HS9.sql

DeductionsFor any given payno pay year for Jeff with LCAT BCAT CODES.sql

Degree information for employees.sql

delete 15-aug-20.sql

delete from bni001c current table for bni001 file.sql

Delete NBRJOBS record for one person.sql

Demographic Report for Michelle Doyle.sql

Drop Employees Annual Leave Payments.sql

Drop employees no DAP on comment form.sql

DROP-employees Report for Jeff.sql

DROP-employees.sql

eclass check.sql

eclass count as of certain date.sql

ECLASS COUNTS WITH SUMMER ALSO.sql

Employee counts by Divisions.sql

employee counts by year.sql

Employee counts by zip code.SQL

Employee email list for Karen Barth.sql

Employee Report sql.sql

Employee status and job status.sql

EmployeeEmergencyContacts.sql

Employees and supervisors for April no funding source.sql

Employees and supervisors for April.sql

Employees by Age for Kay Feb 13 2008.sql

EMPLOYEES BY BARG UNIT CODE.sql

employees by retirement code.sql

Employees for a Location Code.sql

Employees in an ORGN.sql

employees not paid in a while.sql

Employees on Sabbatical.sql

Employees with multiple jobs.sql

Employees without a Primary Job.sql

employees_in_A_ORGN as of.sql

EMPLOYEESAND SUPERVISORS FOR KAY.sql

EmployeesByORGNfromODS.sql

EmployeesInRecration-studens.sql

employeeSummaryQuery.sql

EPAF Tables.sql

ethnicity codes.sql

executive Service employees from ods.sql

F_GET_ADDRESS_LINE.fnc

f_get_JFTE.sql

F_SCD_01796_DEPT_ID backup.fnc

F_SCD_01796_DEPT_ID.fnc

Faculty data for Catalogue.sql

Faculty name and email for Greg Request number 80324.sql

FacultyBargUnitCodesForFacultyWithIndexandRankandTenure.sql

female employees.sql

ForeignNationalEmployees.sql

ForeignNationalEmployeesEmailNotification.sql

FRP FRI -employees Report for Jeff.sql

fsmfs9.sql

FUNCTION TO GET ADDRESSES.sql

FUNCTION TO SEE IF A USER HAS ACCESS TO ORGN.sql

GET ADDRESS FOR A PIDM.sql

get begin and end paynumbers for double deductions from gtvsdax.sql

get health insurance employer amount.sql

Get Job Appointment percent - need pidm pons suff and effective date.sql

GradAssistants with Salary data for Linda 4-24-2008.sql

GradAssistants.sql

GradAssistants1.sql

gradAssistantswithSupervisors.sql

group mail faculty and adjuncts.sql

gurethnicity from SUNGARD.sql

H1 VISAS.sql

Hayley Drop_Employees.sql

Hayley Employees Over 60.sql

health insurance function testing.sql

I9 report for carol terminated employees.sql

I9 report for carol.sql

INSERT Benefitss into uwf_general_table file.sql

INSERT Benefitss into uwf_general_table file.xls

insert xo_health table.sql

InUnitFacultyBargUnitCodesForFacultyWithIndexandRankandTenure Ft. Walton only.sql

InUnitFacultyBargUnitCodesForFacultyWithIndexandRankandTenure.sql

INVALID BUILDING NUMBERS.sql

Kay_report_September-2009 with Supervisors Name AND EMAIL.sql

KING LIST 1 AGE OVER 60 AND 6 YEARS OF SERVICE.sql

KING LIST 2 OVER 30 YEARS OF SERVICE.sql

labels.sql

labor distribution records for certain employee.sql

LauraHquery.sql

LauraHqueryPayforOneDay.sql

LauraHqueryPayforOnePayPeriodFromNHRDIST.sql

LDR_POSITION_DATA_QUERY.sql

leave liability report for list 1 for Shelly Blake.sql

leave liability report for list 2 for Shelly Blake.sql

leave liability report with drop hours counted for.sql

LeaveBalanceFromODS.sql

leaveBalances from Base tables.sql

LeaveBalances from ODS personal leave.sql

LeaveLiabilityNew.sql

LeaveReportsforSharonJones.sql

List of checks for a payroll for an ORGN.sql

List of employees as of for an ORGN.sql

List of employees by PFID for BNI001 V2.sql

List of employees by PFID for BNI001.sql

List of employees for Gabor.sql

NBAPOSN Report for christine 8 20 2009.sql

NBAPOSN Report for christine.sql

NBAPOSN_POSNO_112489_FIX.sql

NBBPOSN NTRRQUE REPORT FOR Christine.sql

NBRJOBS_EFFECTIVE_DATE THING.sql

NBRRJQE REPORT FOR Christine.sql

New report for Carol.sql

NewHireReportforStateFromODS.sql

newhiresByMonthfromWFODS.sql

newhiresByMonthfromWFODSAprilsargent_supervisor.sql

NoAdminCodes.sql

NON UNIT FACULTY.sql

Non-Supervisors with campus address and email.sql

nonCashEarnCodes GCT gift certificates.sql

noPERREVWdatain2004or2005or2006.sql

NoSupervisorListed.sql

Notices for Bonuses for June 2009.sql

NotStartedTimeSheets.sql

NTRTPRX and GOBEACC ON GOAEACC.sql

OHR000071 QUERY.sql

ohr47.sql

OVER 62 with min 6 years of service.sql

overtheLimitLeaveFromODS DEC 2008.sql

overtheLimitLeaveFromODS.sql

parkingDeductionsForAday.sql

PartTimeEmployeesWFODS.sql

PartTimeEmployeesWFPR for health.sql

PartTimeEmployeesWFPR.sql

PartTimeEmployeesWFPRv2.sql

PayFactoryNE26p1.sql

PaysEqual215.sql

pba and fasme barg unit with email address.sql

PBA BARG UNIT EMPLOYEES.sql

PCLASS_ECLASS counts for July 2005.sql

PCLASS_ECLASS counts for July 2006.sql

PCLASS_ECLASS counts for July 2007.sql

pending Leave Reports.sql

pendingLeave1.sql

pendingLeave2.sql

PeopleAdminData.sql

PeopleAdminDataWithSupvName.sql

PeopleAdminDataWithSupvName12032007.sql

PeopleAdminDataWithSupvNameEmployeesOnly12052007.sql

PeopleAdminUserLoadQuery V4 frm ODS.sql

PeopleAdminUserLoadQuery.sql

PeopleAdminUserLoadQueryV2.sql

PeopleAdminUserLoadQueryV3 as of 2-15-2008.sql

PeopleAdminUserLoadQueryV4 as of 10-22-2008.sql

PERREVWdataAllEmployeesAllyears.sql

PERREVWdataForLinda2006.sql

PERREVWdataForLinda2006AfterMeritRaises.sql

PERREVWdataForLinda2006ECLASS40_43.sql

PEVVER1 EASY REPORTING.sql

PfP_EligibleEmployeesIn2006.sql

PHASED RETIREES FROM BANNER.sql

PHASED RETIREES FROM WFODS.sql

pobulation selection list WITH DATA 2 AND GOOD with overload.sql

pobulation selection list WITH DATA 2 AND GOOD.sql

pobulation selection list WITH DATA 2.sql

pobulation selection list WITH DATA.sql

pobulation selection list.sql

pobulation selection QUERY FROM BANNER WITH DATA GOOD.sql

pobulation selection QUERY FROM BANNER.sql

pooled positions.sql

Position History for President Position number 100010.sql

Positions by location code from NBAPOSN and pevjobs.sql

Positions by location code from PEVJOBS.sql

PositionswithNoSupervisorsonNBBPOSN.sql

PRETAX DEDUCTIONS CALCULATIONS.sql

PRETAXAMOUNT LBR L9R.sql

PRETAXAMOUNT1.sql

PRETAXAMOUNT2.sql

primary and secondary jobs.sql

ProfessorsBecame adjuncts.sql

PROMOTIONS AND RECLASSIFICATONS.sql

PTRUSER DATA.sql

PTRUSERS WITH MASTER EMPLOYER.sql

publicRecordRequestLinda.sql

PZRFRS NEW SQL v2.sql

PZRFRS NEW SQL.sql

PZRFRS OLD SQL.sql

RACE AND ETHNICITY CONVERSION FROM UNF.sql

race before running the script.sql

reclassificaton sql.sql

record clean up.sql

Report for Kay 6 24 2009.sql

Report of new race and thnicity codes.sql

resident assistants posn is 973000.sql

Retention Reports.sql

RetiredEmployeesFromODS.sql

RetiredEmployeesFromWFPR.sql

Retiree notification SQL.sql

Retirement_code and options search.sql

RetirementData.sql

RetirementData9MonthSummer.sql

rosemary hays-thomas 970000622.sql

SalaryReportforKim.sql

SalaryReportforKimCalculation.sql

SalaryReportforKimCalculationBYeCLASS.sql

scd report 9 old version.sql

scd report 9.sql

Scott Marzillie.sql

ServiceAwards10Years.sql

ServiceAwards40Years.sql

Sharon_report Feb 13-2008 with Supervisors Name and Eval data and Supervisors email no review data.sql

Sharon_report Feb 13-2008 with Supervisors Name and Eval data and Supervisors email.sql

Sharon_report Feb 13-2008 with Supervisors Name and Eval data.sql

Sharon_reportJuly2007CUPA.sql

Sharon_reportJune2007.sql

Sharon_reportJune2007v2.sql

Sharon_reportOctober1-2007 with Supervisors Name AND EMAIL.sql

Sharon_reportOctober1-2007 with Supervisors Name.sql

Sharon_reportOctober1-2007.sql

sick leave counter from WFODS.sql

spriden_Activity.sql

sql for ohr000053.sql

sqlnet.log

SSN changes and history.sql

SSN is in SPBPERS.sql

SSN USED BY MULTIPLE ENTITIES.sql

SSN_CHANGE_HISTORY_GURHLOG.sql

Supervisors AND non-Supervisor.sql

Supervisors with campus address and email.sql

Supervisors.sql

SupervisorsFromwfods.sql

SUPSCDRT v1.sql

SUPSCDRT DEBUGER.sql

SUPSCDRT.sql

TERMINATED EMPLOYEES AND PFID.sql

TerminatedEmployeesWithLeaveBalances.sql

Termination counts by year from ODS.sql

teured Faculty.sql

Time and Leave Errors for 2008.sql

TIME AND LEAVE REPORTS FOR A PAY PERIOD.sql

TIME LEAVE COMMENTS FOR 2006 TILL NOW.sql

timeEntryTables 2 .sql

timeEntryTables.sql

timesheetsApproved on one pay number.sql

timeSheetsForADay.sql

timesheetsforyPaynobyStatus.sql

timeSheetsStatusbyPaynoPayYear.sql

uff bargaining unit employees - paying dues.sql

uff bargaining unit employees who are tenured.sql

uff bargaining unit employees.sql

UFF Faculty and campus address.sql

UNIT_FACULTY_BONUS09 pop selection for Billy.sql

Use function to get fields.sql

usefulTool.sql

USPS_Employees_NoLawEnforment.sql

USPSemployees for Linda.sql

UWF employees making less than 40k.sql

UWF_FACULTY_VIEW2.sql

UWFemployeReportForBilly.sql

uwfidmismatch.sql

Valic Contributions.sql

vendors with possible ssn as ids.sql

vendorsWithAltenateIDs.sql

Visiting and temporary positions.sql

W2 Consent trigger coding.sql

w2 conset status for ALL employees.sql

W2_Consented COUNTS AND PERCENT BY DEPT.sql

W2_Consented.sql

williamOkeefebadjob.sql

WORKERS COMP REPORT.sql