[xls]mission.sfgov.orgmission.sfgov.org/oca_bid_attachments/fa37174.xlsx · web viewapproval path...

Appendix B: Current EnvironmentRFP# CON2014-18Financial Management System and System Integrator Professional Services

document.xlsx Table of Contents 2 of 85 RFP# CON2014-18

Enterprise Resource Planning Solution (ERP) Current EnvironmentTable of Contents

Worksheet Title / Hyperlink DescriptionInbound Interfaces Listing of all of the interfaces inbound to FAMIS. These interfaces are created

from systems outside of FAMIS, or by processes internal to FAMIS.

Outbound Interfaces Listing of all of the interfaces outbound from FAMIS. These interfaces are sent to systems outside of FAMIS.

Departmental Systems Listing of all systems that are directly or indirectly tied to FAMIS based on a survey completed by City departments during 2014.

Data Warehouse (EIS) Listing of the current hardware and software enviroment for the Data Warehouse (EIS).

document.xlsx Inbound Interfaces 3 of 85 RFP# CON2014-18

FAMIS Inbound Interface Master ListFile # Input Frequency Doc Prefix Labor Data?

1 Controller Weekly CFO0040D CKSF N N

2 Controller Daily CFO0040P AHSF N N

3 Not Used N N4 Controller As Needed As Needed FAMJ1310 RVSF N N

5 Controller As Needed As Needed FAMJ1310 RPSF N N

6 Controller Monthly FAMJ1735 INTD N N

7 Controller Bi-weekly FAMJ2700 LDXX N Y

8 Controller As Needed As Needed BISF N N

9 Controller Year-end None FAMJ9820 RCSF N N

10 Controller CFO9850A GCSF N N

11 Public Works Monthly Monthly Y N

12 Daily Daily CFO0057 CCSL N N

13 Daily Daily N N

14 Daily Daily N N

15 Monthly Monthly IJHS N N

16 Not Used N17 Controller's Monthly OVTR Y N N

18 Monthly Monthly WITI N N

Source Department

Interface Description

Schedule Producing Job Name1

One Time Vendor

Special FAMIS Interfaces2

CheckWriter - Batch Checks

Wednesday evening

ACH Batch CheckWriter

Monday-Friday

Automated Transaction ReversalAutomated Transaction RepostInterest Distribution/ (Cash Receipts)

1st week of Month

LDS Payroll Earnings, Fringes and Deductions

Should be run on Payday, Tuesday

Interim and Final Budget Interfaces with full allotments

wf_b_BUD_IF_out_ToFAMIS_1 & 2

Reclass Year End DocumentsGeneral Ledger Closeout

Daily @ Year End until Close


Automated Workorder Billing

WBBB WBOO

Bank of America

B of A Cleared Checks and Deposits

Human Services Agency

Daily Warrants and Jes. - Social Services Warrants

OISS JESS


Daily Warrants and Jes. - Social Services Warrants

OISS JESS

Health Service System

HSS (Health Services System) LOA Medical/Dental & Misc Adjustment (effective April 2009)

Tax Collector Refunds - 4 interface files:1) STP (Secured Prior Year)2) STC (Secured Current Year)3) UPP (Unsecured Prior Year)4) UTC (Unsecured Current Year)

Before the 16th of the Month

Department of Technology

DTIS has 3 workorder billings: 1) Telephone2) Electricity


File # Input Frequency Doc Prefix Labor Data?Source Department



One Time Vendor


19 Retirement Monthly N N

20 PPSD Bi-Weekly OIPY N N

21 Not Used N22 Trial Courts IPTC N N

23 Airport Daily Daily N N

24 Weekly Tuesday IPHL N N

25 HIHG N N

26 N N

27 N N

28 Public Works Bi-Weekly As Needed JE_ _ N N

Retirement interface file contains Payments to retirees, survivors of retirees, and payout to employees who no longer participate in the pension plan

1) 20th payable 1st of the following month 2) 10th of each month

OIRS JERS

PPSD Net Check & Advice Interface

Interface is submitted every other Friday.

Payments for Indictment Grand Jury (Payments for Regular Jury Duty discontinued).

Semi-Monthly

Middle and End of the Month

Property Management & Billing System (PMBS) Interfaces (effective Nov 2008): 1) Receivables

RIAC RUAC IJAC

Laguna Honda Hospital

Pathways Materials Management System (PMM) Accounts Payable Interface (new interface effective 10/29/08)

San Francisco General Hospital

Contains financial summary of charges and adjustments for services performed during the month. Paymwents received are manually entered into FAMIS Accounting through document type "CR"

Monthly

7th to 10th of month

Public Utilities Commission

Inventory items issued and returned for Waste Water, Water and Hetch Hetchy.

Monthly

Monthly As

IIUH IIUW


1) Overhead Cost Allocation

Monthly Monthly

Monthly

IIUH IIUW CAUC

LDS Homebase corrections





One Time Vendor


29 Controller Daily CFO0009A YECO N N

30 Not Used Quarterly Quarterly XP_ _ N N

31 Controller Quarterly As Needed CFO0108A SCSF N N

32 Weekly Tuesday IPHG N N

33 Bi-weekly As Needed IPHM N N

34 Controller As Needed FAC1660A FASF N N


36 Controller Daily CFO0009E YECO N N

37 MTA Monthly N N


Fund Equity Recalculation - Year-end Adjustments


Ricoh Copier Billing - Process discontinued December 2011

Cancellations of Stale Dated Checks


Pathways Materials Management System (PMM) Accounts Payable Interface (new interface effective 10/29/08) - formerly the Matkon purchases system

Public Health - Community Mental Health

CCURA3 Provider Payments

FAACS to FAMIS Interface: Proprietary Fund Fixed Asset Adjustments, Capitalization, and Depreciation. GFAAG Adjustments.

Daily/ Monthly/ Weekly


RIAC RUAC IJAC

Year-End Adjustments to allocate appropriations of continuing funds to char 069


1) Overhead Cost Allocation - Div04 & A872) Inventory - MMS

Nonthly As Needed

CAPT IIPT


RIAC RUAC IJAC





One Time Vendor


39 MTA Daily CDPK N N

40 Not Used As Needed inactive RRAD Y N

41 Not Used Monthly Monthly IPOC N

42 annual annual OVSS Y N N

43 Weekly Friday OVPK Y N N




47 As Needed OVRG Y N N

48 As Needed OVRG Y N N

49 Airport Bi-weekly As Needed CAAC N N

50 Trial Courts As Needed As Needed IPSP N N

51 Monthly IIHL N N

Garage Cash/Credit Card Daily Deposit

Monday-Friday

County Clerk Same Sex Marriage Refund - inactive

OCA Direct Payment Interface - Office Depot Billings - inactive since 2009


Working Families Credit interface (1) Checks

Department of Parking and Traffic

Parking Citation Division Refunds: 1) Hearing Refunds







Department of Elections

Poll Workers Payment interface

During Election

Department of Elections

Polling Places Payment interface

During Election

Airport Project Allocation interfaceTrial Courts Direct Payment Interface - Payments to Court Appointed Attorneys, Investigators and Expert Witnesses for Indigent Defense

Laguna Honda Hospital

Pathways Materials Management System (PMM) General Ledger Interface - Inventory Issues

First week of the month





One Time Vendor


52 Monthly IIHG N N

53 EXUW N N

54 Controller Monthly FAMJ1736 INTD N N

55 Daily N N

56 PPSD - AP files EMPY N Y

57 Daily Daily N N

58 Daily N N

59 Daily N N

60 PPSD - AP files JEPY N Y

Not Assigned PPSD annual annual JECO Y N N

Not Assigned Controller JECO Y N


Pathways Materials Management System (PMM) General Ledger Interface - Inventory Issues

First week of the month


Bond Revenue and Expenditure Reclass

Monthly

Monthly As NeededInterest Distribution/

(Earnings)1st week of Month

Treasurer's Office

Journal entry posting generated by Treasury's Work Station to record certain bank daily transactions. Currently it includes wire transfer and investment payments and receipts (bank GL 1050), and zero balance transfers to and from the City's concentration accounts (bank GL 1149/ GL 1609 and other bank GLs)

Monday-Friday

BTIT WLIT JEIT CRIT

Emerge AP fileHuman Services Agency

Social Services Warrants - Same as #13

OISS JESS

MTA Overhead cost

Daily As needed

CAPT IIPT

MTA Overhead cost

Daily As needed

CAPT IIPT

Emerge AP file

PPSD 1099 Interfaces: 1) Deceased Employees Beneficiaries The COIT program creates an interface file to systematically post the calculated 1.9% fee to COIT using the Actual Expenditure Recovery approach.

Monthly except month 12 which is run in late August (after the FINAL CLOSE

Monthly approx. 15th

COITINTF, COITINT2





One Time Vendor



Not Assigned Controller Annual WKXX Y N

Not Assigned Controller Annual JECO Y N

Not Assigned Controller As Needed As Needed JECO Y N

Not Assigned Controller Annual YECO Y N


Not Assigned Controller Annual YECO Y N

The Carbon Tax program creates an interface file to systematically post the calculated 13% fee to Carbon Tax using the Actual Expenditure Recovery approach to project funded expenditures.

Quarterly except last quarter runs right before close at end of August

Quarterly 3rd month of quarter

CTAXINTF, JCLCTAX

This program creates an interface file to set up work order encumbrances based on original budgetsestablished in character 081.

After Final Budget posted in August

CTLRFINT.CFO.CCHU.WKENCFIL, AUTOENC1, (JCLENCB1)

COWCAP overhead interface

CTLRFINT.CFO.CCHU.COWALLOC.INTRFILE, COWALLOC, (COWALLOC)

This job is used to close out inactive projects based on the 1090 screen. This is run when requested by the BAD group and various depts (PUC, DPW, PRT, etc.)

CTLRFINT.CFO.CCHU.PWCLOPJD.INTRFILE, PWCLOPJK, PWCLOPJM, PWCLOPJC, (PWCLOPJT)

Fund Equity Recalculation - adjust SOBJ 99999B based on the fund equity balance as of FM 00 of the new year

Annual after CAFR is complete

CTLRFINT.CFO.LEO.V5.FDBB001.INTRFILE,FDBB001K, (JC99999B)

Grant Closeout Program

Semi-Annual

December and June

GRNTCLSD, GRTCLSBF

Carry forward of Performing Department's Appropriation

September after month 12 Close

WORK100A, WORK100J





One Time Vendor


Daily Daily

Weekly Wednesday

Not Assigned - This is an interface to update the Vendor file

HRC Human Rights Commissioni

File contains Vendor's Equal Benefit status (HBN Complies, HBN PND/Pending) to update the Vendor file in FAMIS


HRC Human Rights Commissioni

File contains LBE status (HCL YES, HCL NO) and HRC Certification Renewal Date to update the Vendor Class/Status information in FAMIS.


Treasurer & Tax Collector - Business Tax

The interface file contains a list of the companies and their business tax information which are maintained by the Business Tax System. These are companies which do business in the City (eg The Fairmont Hotel) or with the City (eg City Vendor which has a contract to perform services) and pay business tax to the City and County of SF, include vendors who do business with the City and have paid business tax to the City and County of SF.

1 Name of the job which creates the interface file by the Controller Department2 On Request interfaces created from FAMIS by the Controller to support legislation and financial mandates

document.xlsx Outbound Interfaces 10 of 85 RFP# CON2014-18

ADM FAMIS Accounting FTP to CON server Monthly COITINTF

ADM FAMIS Accounting ERRHFRDF To provide status of Monthly COITERRF

ADM FAMIS Accounting FamisByPPD.xls Email Scheduled Biweekly

ADM LDS EmpDetail.xls Email Scheduled Biweekly

ADM LDS PaywithFringe.xls Email Scheduled Biweekly

ADM LDS Email Scheduled Biweekly

ADP FAMIS Accounting FamisForecastByPPD.xls Email Scheduled Biweekly

AIR MF FAMIS LDS CTLRFINP.CFO.PR.AIR.RPT60 DEPT PICKS UP FAMRS060 REPORT Scheduled BI-WEEKLY CFO0360D COBOL

AIR MF FAMIS Accounting CTLRFINP.CFO.DOWNLOAD DEPT PICKS UP Scheduled CFO0004B

AIR MF FAMIS LDS CTLRFINP.CFO.PR.AIRF.FAMLPD DEPT PICKS UP Labor Cost data Scheduled BI-WEEKLY CFO2700A COBOL

AIR MF FAMIS LDS CTLRFINP.CFO.PR.CFO0128A FTP Labor Cost data Scheduled BI-WEEKLY

Department

Extract System(MF, EIS, Access)

Source Data(FAMIS Accounting, FAMIS Purchasing, FAMIS LDS, FAMIS Budget, FAMIS FAACS, PeopleSoft (PS) HR, PS Benefits, PS Time&Labor, PS Payroll, PS Absence)

Output FILE NAME(with server/library/path)

Delivery Method (FTP, Email, Dept Picks Up, USPS, Interoffice Mail, Save to CON network, Send to Printer)

Data Content

Description/Purpose

Receiving Departmental System Name or Database Name(This is added by Margery to identify the target system of the extract data based on interviews with depts)

Scheduled or On Request(new column)

Run Frequency(Required)

Run Schedule(new column, Day of the Week, or a Specific Date. For example: Every Fri, 15th of every month)

Job Name(Required, JCL or Workflow name with Library/Path)

Software/ Development Tool (Required, EASYTRIEVE, SystemWide, Cobol, SQL, Visual Basic etc)

Interface file for COIT fee

The COIT program creates an interface file to systematically post the calculated 1.9% fee to COIT using the Actual Expenditure Recovery approach.

FTP to CON server then Emailed to Dept.

Listing of Error from the COIT fee Interface

By Friday 2 weeks after pay period end

See N:\Finance\Procedures\BAD_AccessDBs\BADAccessDBAdmin.doc





N:\BUDGET\AccessDB\Files\Depts\ADM_BVA_1010.11262010.pdf





Contains LDS data for active Airport projects. It is downloaded to an internal database to support the SFO Project Allocation System. The data is also used to create various labor reports for audit purposes.

Airport database which supports Project Allocation System

Tuesday of payweek

Airport Revenut, Receivable and Receipts data

This extract contains the Airport Property Management and Billing information which is recorded in FAMIS. The data is downloaded to an internal database for audit trail reporting

PMBS Airport Property Management & Billing System

TWICE A MONTH

2nd and 4th Friday of month

SYSTEMWIDE EXTRACT

Airport labor data associated with the Airpot Commission Index Code. It is used for audit purposes

Airport Payroll System

Tuesday of payweek

Airport labor data associated with the Airpot Police Index Code. It is used for audit purposes

Airport labor database

Tuesday of payweek

CFO0128A/CFOFTP28

EASYTRIEVE


Department





Data Content

Description/Purpose







AIR MF FAMIS Accounting DEPT PICKS UP Scheduled CFO0004A






AIR MF FAMIS Accounting CTLRFINP.CFO.AIR.TDF10 DEPT PICKS UP Scheduled WEEKLY CFO0541A

AIR MF FAMIS Accounting CTLRFINT.CFO.CCHU.TDF4XX On request Annual Sept TDF4XX

AIR EIS FAMIS Accounting famistosfo-yyyymmdd.csv FTP Scheduled 6 days / week

B OF A MF FAMIS Accounting CTLRFINP.CFO.PR.POSSOC FTP Scheduled M-F CFOFTPSC COBOL

B OF A MF PPSD/eMerge CTLRFINP.CFO.PR.PAYPOS.AM FTP Scheduled M-F CFOBPAYR COBOL

B OF A MF FAMIS Accounting CTLRFINP.CFO.PR.POSPAY FTP POSITIVE PAY FILE Scheduled DAILY CFOFTPBA COBOL

B OF A MF FAMIS Accounting CTLRFINP.CFO.PR.PAYMODE FTP Scheduled DAILY COBOL

BAD/ENV FAMIS Accounting CTAXINTF FTP to CON server Quarterly JCLCTAX

CTLRFINP.CFO.DOWNLOAD.ACFAMTBL

FAMIS Document Transaction Tables & Files

8 FAMIS extract files are downloaded for reporting and audit trail purposes

Airport internal reporting database

MONTHLY-15TH

15th of the month

SYSTEMWIDE EXTRACT

CTLRFINP.CFO.DOWNLOAD.ACFAMGLF




MONTHLY-15TH

15th of the month

SYSTEMWIDE EXTRACT

CTLRFINP.CFO.DOWNLOAD.ACFAMGL1




MONTHLY-15TH

15th of the month

SYSTEMWIDE EXTRACT

CTLRFINP.CFO.DOWNLOAD.ACFAMOPF




MONTHLY-15TH

15th of the month

SYSTEMWIDE EXTRACT

CTLRFINP.CFO.DOWNLOAD.ACFAMPJT




MONTHLY-15TH

15th of the month

SYSTEMWIDE EXTRACT

CTLRFINP.CFO.DOWNLOAD.ACFAMPJF




MONTHLY-15TH

15th of the month

SYSTEMWIDE EXTRACT

FAMIS Document Transaction Tables & Files - TDF EXTRACT FOR THE AIR PT.



Every Sunday

Sort and COBOL

final files email to AIR

FAMIS Document Transactions and Tables data - Extract of 5A transactions as source data to an Access database

This data is used by the external auditors at year-end for reporting and inquiry purposes (refer to interview notes)


Feeds Airport Capital Project SystemRun script for 60.95.27.002 AIR CIPACE TDF download - sel Pdate.imr

Airport Capital Project System database

Mon-Sat 4:00 AM

Informatica: wf_an_FAM_IF_out_AirCapital

SOCIAL SERVICE POS PAYAM MANUAL CHECKS

B of A cleared checks/deposits FAMIS interface;Create FMINP12 for FAMIS update;

Encrypted Paymode file

CFO0040P/CFO0040D

Interface file for Carbon Tax charges

The Carbon Tax program creates an interface file to systematically post the calculated 13% fee to Carbon Tax using the Actual Expenditure Recovery approach to project funded expenditures.


Department





Data Content

Description/Purpose







CFC MF FAMIS LDS MAILED Labor Data Scheduled BI-WEEKLY CFO0360C

CON MF FAMIS Purchasing CTLRFINP.CFO.PR.DAHSUMM FTP DAH EXTRACT Scheduled QUARTERLY CFO0318A COBOL

CON MF FAMIS Purchasing FTP DAH Report Scheduled QUARTERLY CFO0318A COBOL

CON MF FAMIS Purchasing CTLRFINP.CFO.PR.DAHEXTR2 FTP DAH EXTRACT Scheduled QUARTERLY CFO0318A COBOL

CON MF FAMIS LOG FILE REPORT Audit of FAMIS table updates Scheduled M-F CFO0020A COBOL

CON MF FAMIS CTLRFINP.CFO.PR.FTPFMINT FTP Scheduled M-F CFO0021F

CON MF FAMIS CTLRFINP.CFO.PR.REPT021 FTP REPORT 21 Scheduled M-F CFO0020A COBOL

CON MF FAMIS Accounting Scheduled MONTHLY CFOATBLS COBOL




CON MF FAMIS Purchasing Scheduled MONTHLY PCHATBLS COBOL







CON MF FAACS CTLRFINP.FAC.PR.FACBS510 FTP

LABOR DISTRIBUTION BY ORGANIZATION AND INDEX (NON-LDS)

LDS Report 60 Look-alike for non-LDS departments

EASYTRIEVE

Document Approval History Summary unformatted extract file

CTLRFINP.CFO.PR.DAHDEPT.RPT318

Document Approval History formatted report: 'DEPARTMENT FAMIS AND ADPICS DOCUMENT APPROVAL TIMELINE'Document Approval History unformated extract file

CTLRFINP.COF.PR.FAMR5700.REPT(0)

FTP;Dispatch

99 INTERFACES BACKUP

Unformatted combined FAMIS daily Interfaces

IBM UTILITY

Formatted report: DAILY LIST OF POSTED TRANSACTIONS BY OPERATOR-ID

CTLRFINP.CFO.PR.CFOATBLS.IDPXML

FTP to CON network FAMIDP EXTRACTINITIATING DEPT APPROVAL PATH

Approval Path Table Extract/ for troubleshooting,planning,and reports to departments

1st Monday of the Month

CTLRFINP.CFO.PR.CFOATBLS.DAPXML

FTP to CON network FAMDAP EXTRACTDOCUMENT APPROVAL PATH

Approval Path Table Extract/ for troubleshooting,planning,and reports to departments.


CTLRFINP.CFO.PR.CFOATBLS.DEPXML

FTP to CON network FAMDEP EXTRACTAFFECTED DEPARTMENT APPROVAL PATH



CTLRFINP.CFO.PR.CFOATBLS.SOPXML

FTP to CON network FAMSOP EXTRACTSUBOBJECT TYPE APPROVAL PATH



CTLRFINP.PCH.PR.PCHATBLS.IDPXML

FTP to CON network PCHIDP EXTRACTINITIATING DEPT APPROVAL PATH



CTLRFINP.PCH.PR.PCHATBLS.CAPXML

FTP to CON network PCHCAP EXTRACTCOMMODITY APPROVAL PATH



CTLRFINP.PCH.PR.PCHATBLS.ADTXML

FTP to CON network PCHADT EXTRACTAFFECTED ORGANIZATION APPROVAL



CTLRFINP.PCH.PR.PCHATBLS.IAPXML

FTP to CON network PCHIAP EXTRACTINDEX CODE APPROVAL PATH



CTLRFINP.PCH.PR.PCHATBLS.SATXML

FTP to CON network PCHSAT EXTRACTSUBOBJECT APPROVAL PATH



CTLRFINP.PCH.PR.PCHATBLS.DAPXML

FTP to CON network PCHDAP EXTRACTDOCUMENT APPROVAL PATH



CTLRFINP.PCH.PR.PCHATBLS.DEPXML

FTP to CON network PCHDEP EXTRACTDEPARTMENT APPROVAL PATH



ALL DEPTS FAACS EXTRACT

Extracts all the entries on the FAACS master file for every department

ON REQUEST

ON REQUEST

ON REQUEST

FACB510N/CFOFTP51

COBOLIBM Utility


Department





Data Content

Description/Purpose







CON MF LDS FTP LDS REPORT Timesheet error count Scheduled BI-WEEKLY CFO0121A

CON MF LDS CTLRFINP.CFO.PR.CFO0124A FTP LDS REPORT Scheduled BI-WEEKLY CFO0124A

CON MF LDS CTLRFINP.CFO.PR.RDFLDS FTP LDS EXTRACT Scheduled BI-WEEKLY CFO0124A

CON MF LDS CTLRFINP.CFO.PR.CFO0125A FTP LDS EXTRACT Scheduled BI-WEEKLY CFO0125A

CON MF LDS CTLRFINP.CFO.PR.CFO0125B FTP LDS EXTRACT report to display index#330035 Scheduled BI-WEEKLY

CON MF LDS CTLRFINP.CFO.PR.CFO0128B FTP LDS EXTRACT Scheduled BI-WEEKLY

CON MF LDS CTLRFINP.CFO.PR.CFO0129A FTP LDS EXTRACT Scheduled BI-WEEKLY

CON MF LDS CTLRFINP.CFO.PR.CFO0129B FTP LDS EXTRACT LDS report by employees for LHH Scheduled BI-WEEKLY

CON MF LDS CTLRFINP.CFO.PR.FAMR2700(+0) FTP LDS EXTRACT Scheduled BI-WEEKLY CFO2700A COBOL

CON MF LDS CTLRFINP.CFO.PR.FAMB287C(+0) FTP LDS EXTRACT LDS payroll control report Scheduled BI-WEEKLY CFO2700A COBOL

CON MF FAMIS Purchasing ctlrfinp.pch.pr.pchco5.format1 On Request COBOL

CON MF LDS CTLRFINP.CFO.PR.CFO0122A FTP LDS EXTRACT Scheduled BI-WEEKLY CFOFTP2A

CON MF LDS CTLRFINP.CFO.PR.CFO0122B FTP LDS EXTRACT Scheduled BI-WEEKLY CFOFTP2B

CON MF LDS CTLRFINP.CFO.PR.CFO0122C FTP LDS EXTRACT Scheduled BI-WEEKLY CFOFTP2C

CON MF FAMIS Accounting CTLRFINP.CFO.PR.ENCUMB FTP Scheduled WEEKLY Sunday

CON MF FAMIS Accounting ctlrfinp.cfo.pr.gl248ext FTP GL248 EXTRACT Scheduled M-F & SUN M-F & SUN

CON HSS server FAMIS Accounting FTP 1099 EXTRACT HSS Scheduled ANNUALLY CFOFTPH9

CON CTLRFINP.CFO.PR.IRS**** FTP Scheduled ANNUALLY RUN MANUALLY COBOL

CTLRFINP.CFO.PR.FAMLTT.COUNT

Tuesday of payweek

EASYTRIEVE

LISTING OF FAMIS LDS DOCUMENTS IN ERROR

Tuesday of payweek

EASYTRIEVE

Comma delimited file of CFO0124A report

Tuesday of payweek

EASYTRIEVE

Select data from LABORDET where DOE code = 'J31' 'M31' 'N31' 'O31' 'P31' 'T31' 'U31'

Tuesday of payweek

EASYTRIEVE

Tuesday of payweek

CFO0125B/CFOFTP25

EASYTRIEVE

Earnings and fringes report by department.

Tuesday of payweek

CFO0128B/CFOFTP28

EASYTRIEVE

LDS report by index codes/employees for LHH.

Tuesday of payweek

CFO0129A/CFOFTP29

EASYTRIEVE

Tuesday of payweek

CFO0129B/CFOFTP29

EASYTRIEVE

LDS transactions total count/amount report

Tuesday of payweek

Tuesday of payweek

FTP TO CON network

Change order RECORD TYPE 5 (cancellations)

Download of PO ADPICS Cancellations as of a certain date to validate the mass PO fye close-out process.

On Request

Two or three times in September of each year when the PO close-outs are done.

CFOFMCO5\FTPCHG

list DOEs that are in GEAC, but not in LDS

Tuesday of payweek

EASYTRIEVE


Tuesday of payweek

EASYTRIEVE


Tuesday of payweek

EASYTRIEVE

ENCUMBRANCE EXTRACT

CFO0116A/CFOFTPC4

EASYTRIEVE

CFOBG248/CFOFTP48

EASYTRIEVE

sf1099dp.txt hrs-ux01 , cd /psoft1/interfaces/CONTROLLER/

ANNUALLY

1099 EXTRACT CONTROLLERS

ANNUALLY


Department





Data Content

Description/Purpose







CON MF FTP Scheduled MONTHLY CFOFTPC6

CON MF FTP Scheduled MONTHLY CFOFTPC6

CON MF FAMIS Purchasing FTP TO CON LAN PCHPTB EXTRACT on request ONE TIME RUN MANUALLY

CON MF FAMIS FAACS CTLRFINP.FAC.PR.DUPEHLD FTP Scheduled WEEKLY Sunday CFOFTPF3 COBOL

CON MF FAMIS FAACS CTLRFINP.FAC.PR.DUPEHLR FTP Scheduled WEEKLY Sunday CFOFTPF3 COBOL

CON MF FAMIS FAACS CTLRFINP.FAC.PR.DUPEHLD2 FTP Scheduled WEEKLY Sunday CFOFTPF3 COBOL

CON MF FAMIS FAACS CTLRFINP.FAC.PR.DUPEHLR2 FTP Scheduled WEEKLY Sunday CFOFTP3 COBOL

CON MF FAMIS FAACS CTLRFINP.FAC.PR.FACR1220 FTP FAACS EXTRACT Scheduled WEEKLY Sunday CFOFTPF4 COBOLCON MF FAMIS FAACS CTLRFINP.FAC.PR.FACR1221 FTP FAACS EXTRACT Scheduled WEEKLY Sunday CFOFTPF1 COBOLCON MF FAMIS FAACS CTLRFINP.FAC.PR.FACB1223 FTP FAACS EXTRACT Scheduled WEEKLY Sunday CFOFTPF2 COBOLCON MF FAMIS Purchasing FTP PCHZO1 EXTRACT ONE TIME COBOL

CON MF FAMIS CTLRFINP.CFO.PR.REPT096 FTP 96 EXTRACT Scheduled WEEKLY Sunday CFOFTPC2

CON MF FAMIS CTLRFINP.CFO.PR.CFO0096X FTP 96 EXTRACT Scheduled M-F M-F CFOFTPCX

CON MF FAMIS FAACS CTLRFINP.CFO.PR.RPT1220G FTP FAACS EXTRACT Scheduled WEEKLY Sunday CFOFTPF6

CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTG FTP FAACS EXTRACT Scheduled WEEKLY Sunday CFOFTPC5

CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTH FTP FAACS EXTRACT Scheduled WEEKLY Sunday CFOFTPC5

CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTI FTP FAACS EXTRACT Scheduled WEEKLY Sunday CFOFTPC5

CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTJ FTP FAACS EXTRACT Scheduled WEEKLY Sunday CFOFTPC5

CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTK FTP FAACS EXTRACT Scheduled WEEKLY Sunday CFOFTPC5

CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTL FTP FAACS EXTRACT Scheduled WEEKLY Sunday CFOFTPC5

CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTM FTP FAACS EXTRACT Scheduled WEEKLY Sunday CFOFTPC5

CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTN FTP FAACS EXTRACT Scheduled WEEKLY Sunday CFOFTPC5

CON MF FAMIS LDS CTLRFINP.CFO.PR.RPT145LA FTP LDS EXTRACT Scheduled BI-WEEKLY COBOL

CON MF FAMIS LDS CTLRFINP.CFO.PR.RPT145OA FTP LDS EXTRACT Scheduled BI-WEEKLY COBOL

CON MF ctlrfinp.cfo.pr.famr1860.pcntl FTP Scheduled M-F M-F COBOL

CON MF FAMIS Accounting FTP 451 REPORT Scheduled QUARTERLY Quarterly CFOFTPC3

FAMIS Accounting Vendor File

CTLRFINP.CFO.PR.V1FEXTR.MATCH

VENDOR MATCH EXTRACT

NO LONGER USED THESE WERE FILES CREATED IN OLD PAYROLL SYSTEM ARE NOT CREATED IN PEOPLESOFT


CTLRFINP.CFO.PR.V1FEXTR.MATCH.DUPS

VENDOR DUP EXTRACT

NO LONGER USED THESE WERE FILES CREATED IN OLD PAYROLL SYSTEM ARE NOT CREATED IN PEOPLESOFT

CTLRFINP.PCH.PR.PCHPTB.FORMAT

Extract of Purchasing Miscellaneous Tables/ ease of reference/troubleshooting

On Request

DUPE FAACS EXTRACTDUPE FAACS EXTRACTDUPE FAACS EXTRACTDUPE FAACS EXTRACT

CTLRFINP.PCH.PR.PCHZO1.FORMAT

ON REQUEST

CFOFMZO1/CFOFMZO1

EASYTRIEVEEASYTRIEVEEASYTRIEVEEASYTRIEVEEASYTRIEVEEASYTRIEVEEASYTRIEVEEASYTRIEVEEASYTRIEVEEASYTRIEVEEASYTRIEVE

Tuesday of payweek

CFO0020D/CFOFTPC8

Tuesday of payweek

CFO0020D/CFOFTPC8

PROCESS CONTROL RPT

CFO0020P/CFOFTPC9

CTLRFINP.CFO.PR.GL451BAD.OUTPUT

EASYTRIEVE


Department





Data Content

Description/Purpose







CON MF FAMIS LDS CTLRFINP.CFO.PR.RPT995A FTP Scheduled BI-WEEKLY CFOFTPC7 COBOL

CON MF FAMIS LDS CTLRFINP.CFO.PR.RPT995B FTP Scheduled BI-WEEKLY CFOFTPC7 COBOL

CON MF FAMIS LDS CTLRFINP.CFO.PR.RPT995C FTP Scheduled BI-WEEKLY CFOFTPC7 COBOL

CON MF FAMIS LDS CTLRFINP.CFO.PR.RPT995D FTP Scheduled BI-WEEKLY CFOFTPC7 COBOL

CON MF FAMIS LDS CTLRFINP.CFO.PR.RPT995E FTP Scheduled BI-WEEKLY CFOFTPC7 COBOL

CON MF FAMIS LDS CTLRFINP.CFO.PR.EXT995A FTP Scheduled BI-WEEKLY CFOFTPC7 COBOL

CON MF FAMIS LDS CTLRFINP.CFO.PR.EXT995B FTP Scheduled BI-WEEKLY CFOFTPC7 COBOL

CON MF FAMIS LDS CTLRFINP.CFO.PR.EXT995C FTP Scheduled BI-WEEKLY CFOFTPC7 COBOL

CON MF FAMIS LDS CTLRFINP.CFO.PR.EXT995D FTP Scheduled BI-WEEKLY CFOFTPC7 COBOL

CON MF FAMIS LDS CTLRFINP.CFO.PR.EXT995E FTP Scheduled BI-WEEKLY CFOFTPC7 COBOL

CON MF FAMIS Purchasing Scheduled DAILY COBOL

CON MF FAMIS Purchasing FTP BPO RECORDS Scheduled DAILY COBOL

CON MF CTLRFINP.CFO.PR.NOPRORPT Scheduled MONTHLY PCH0219A COBOL

CON MF CTLRFINP.CFO.PR.PROFRPT Scheduled MONTHLY COBOL

CON MF FTP Scheduled MONTHLY

CON MF Scheduled MONTHLY PCH200AJ COBOL

LISTING OF LDS DOCUMENTS IN ERROR

Tuesday of payweek

LDS LABOR DETAIL FILE DATA

Tuesday of payweek

NO LDSUNDISTRIBUTED

Tuesday of payweek

POSTED TO INDEX CODE "UNAUNDISTRIB"

Tuesday of payweek

LDS DEPARTMENTS ERROR DETAIL DATA BY ORGANIZATION

Tuesday of payweek

EXTRACT OF LDS DOCUMENTS IN ERROR

Tuesday of payweek

LDS LABOR DETAIL EXTRACT

Tuesday of payweek

NO LDSUNDISTRIBUTED EXTRACT

Tuesday of payweek

POSTED TO INDEX CODE "UNAUNDISTRIB" EXTRACT

Tuesday of payweek

LDS DEPARTMENTS ERROR DETAIL DATA BY ORGANIZATION EXTRACT

Tuesday of payweek

CTLRFINP.PCH.PR.PCHPOC.BLBPOID

FTP TO CON LAN BLANK OR BAD BPO FIELD IN PO RELEASE RECORDS

If a new PO is improperly coded for blanket release, this catches and reports the PO releases that are bad.

Nightly Batch

PCH0300A/PCHFTP10

CTLRFINP.PCH.PR.PCHPOC.BPBPOID

PCH0300A/PCHFTP10


FTP TO CON LAN NOPROFIT VENDOR PAYMENTS

A monthly snapshot of non-profit vendors/ troubleshooting and to provide to users upon request.

First of the month.


FTP TO CON LAN FOR PROFIT VENDOR REPORT

A monthly snapshot of non-profit vendors/ troubleshooting and to provide to users upon request.

First of the month.

PCH0219A/PCHFTP03


CTLRFINP.CFO.PR.FAMVHT.VENDADD

VENDOR ADD REPORT

A monthly snapshot of added vendors/ troubleshooting

First of the month.

PCH0031D/PCHFTP03

EASYTRIEVE


CTLRFINP.PCH.PR.EXTRACT.VENDCHNG

FTP TO CON LAN VENDOR CHANGE REPORT

A monthly snapshot of changed vendors/ troubleshooting

First of the month.


Department





Data Content

Description/Purpose







CON MF LDS CTLRFINP.CFO.PR.RPT145LA Scheduled BI-WEEKLY COBOL

CON MF LDS CTLRFINP.CFO.PR.RPT145OA Scheduled BI-WEEKLY COBOL

CON MF LDS CTLRFINP.CFO.PR.CFO0128B Scheduled BI-WEEKLY

CON MF LDS CTLRFINP.CFO.PR.CFO0127C YTD LDS FILE Scheduled BI-WEEKLY

CON MF LDS CTLRFINP.CFO.PR.CFO0124A Scheduled BI-WEEKLY

CON MF LDS CTLRFINP.CFO.PR.RDFLDS Scheduled BI-WEEKLY

CON MF LDS Scheduled BI-WEEKLY

CON MF FAMIS Accounting FTP Scheduled Quarterly Quarterly

CON MF FAMIS Accounting CTLRFINP.CFO.PR.DAHSUMM FTP Scheduled Quarterly Quarterly COBOL

CON MF FAMIS Accounting FTP Scheduled Quarterly Quarterly COBOL

CON MF FAMIS Accounting CTLRFINP.CFO.PR.DAHEXTR2 FTP Scheduled Quarterly Quarterly COBOL

CON MF FAMIS Accounting CTLRFINP.CFO.PR.CFO0096 FTP COBOL

CON MF FAMIS Accounting FTP MATCH FILES Scheduled MONTHLY CFOFTPC6

CON MF FAMIS Accounting FTP Scheduled MONTHLY CFOFTPC6

CON MF FAMIS Accounting CTLRFINP.CFO.PR.FMINP31 n/a Scheduled CFO0108A COBOL

CON MF FAMIS Accounting Scheduled WEEKLY CFOU091V

CON MF FAMIS Accounting CTLRFINP.CFO.PR.GL248EXT FTP GL248 EXTRACT Scheduled WEEKLY

CON MF FAMIS Accounting FTP IDP EXTRACT Scheduled WEEKLY Sunday COBOL

CON MF FAMIS Accounting FTP DAP EXTRACT Scheduled WEEKLY Sunday COBOL

FTP SPECIAL LDS DOCUMENT ERROR REPORT

CFO0020D/CFOFTPC8

FTP PRIOR YEAR LDS DOCUMENT ERROR RPT

CFO0020D/CFOFTPC8

FTP SUMMARY TOTALS OF EARNINGS AND FRINGES BY ORG

CFO0128B/CFOFTP28

EASYTRIEVE

This file is not downloaded or copied to a report. Created in schedule CFO0127

CFO0127C/CFOFTP27

EASYTRIEVE

FTP DOCUMENT ERROR SUMMARY REPORT

CFO0124A/CFOFTP24

EASYTRIEVE

FTP LDS DOCUMENTS IN ERROR (CSV file)

CFO0124A/CFOFTP24

EASYTRIEVE

CTLRFINP.CFO.PR.FAMLTT.COUNT

FTP TIMESHEET ERROR REPORT

CFO0121A/CFOFTP21

EASYTRIEVE

CTLRFINP.CFO.PR.GL451BAD.OUTPUT

OUTSTANDING GL 451

CFO1030A/CFOFTPC3

EASYTRIEVE

TIMELINE APPROVAL EXTRACT

CFO0318A/CFOFTPDH

CTLRFINP.CFO.PR.DAHDEPT.RPT318


CFO0318A/CFOFTPDH


CFO0318A/CFOFTPDH

REPLACES 96 FAMIS REPORT

ON REQUEST

ON REQUEST

ON REQUEST

CFO0096A/CFOFTPC2

CTLRFINP.CFO.PR.V1FEXTR.MATCHCTLRFINP.CFO.PR.V1FEXTR.MATCH.DUPS

MATCH FILES DUPESCANCELATION OF STALE DATED Checks

ON REQUEST

ON REQUEST

CTLRFINP.CFO.PR.FAMV1F.CFOU091V.WORK

UPDATE THE DELETE-IND IN THE FAMVHT

CFOFTP48/CFOBG248

EASYTRIEVE

CTLRFINP.CFO.PR.CFOATBLS.IDPXML

CFOATBLS/CFOFTPAT

CTLRFINP.CFO.PR.CFOATBLS.DAPXML

CFOATBLS/CFOFTPAT


Department





Data Content

Description/Purpose







CON MF FAMIS Accounting FTP DEP EXTRACT Scheduled WEEKLY Sunday COBOL

CON MF FAMIS Accounting FTP SOP EXTRACT Scheduled WEEKLY Sunday COBOL

CON MF FAMIS Purchasing FTP IDP EXTRACT Scheduled WEEKLY Sunday COBOL

CON MF FAMIS Purchasing FTP CAP EXTRACT Scheduled WEEKLY Sunday COBOL

CON MF FAMIS Purchasing FTP ADT EXTRACT Scheduled WEEKLY Sunday COBOL

CON MF FAMIS Purchasing FTP IAP EXTRACT Scheduled WEEKLY Sunday COBOL

CON MF FAMIS Purchasing FTP SAT EXTRACT Scheduled WEEKLY Sunday COBOL

CON MF FAMIS Purchasing FTP DAP EXTRACT Scheduled WEEKLY Sunday COBOL

CON MF FAMIS Purchasing FTP DEP EXTRACT Scheduled WEEKLY Sunday COBOL

CON MF FAMIS FAACS CTLRFINP.FAC.PR.FACR1221 FTP Scheduled COBOL

CON MF FAMIS FAACS CTLRFINP.FAC.PR.FACB1223 FTP Scheduled COBOL

CON MF FAMIS FAACS CTLRFINP.FAC.PR.DUPEHLD FTP Scheduled COBOL

CON MF FAMIS FAACS CTLRFINP.FAC.PR.DUPEHLR FTP Scheduled COBOL

CON MF FAMIS FAACS CTLRFINP.FAC.PR.DUPEHLD2 FTP Scheduled COBOL

CON MF FAMIS FAACS CTLRFINP.FAC.PR.DUPEHLR2 FTP Scheduled COBOL

CON MF FAMIS FAACS CTLRFINP.FAC.PR.FACR1220 FTP Scheduled COBOL

CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTG FTP Scheduled

CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTH FTP Scheduled

CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTI FTP Scheduled

CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTJ FTP Scheduled

CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTK FTP Scheduled

CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTL FTP Scheduled

CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTM FTP Scheduled

CTLRFINP.CFO.PR.CFOATBLS.DEPXML

CFOATBLS/CFOFTPAT

CTLRFINP.CFO.PR.CFOATBLS.SOPXML

CFOATBLS/CFOFTPAT

CTLRFINP.PCH.PR.PCHATBLS.IDPXML

PCHATBLS/CFOFTPAT

CTLRFINP.PCH.PR.PCHATBLS.CAPXML

PCHATBLS/CFOFTPAT

CTLRFINP.PCH.PR.PCHATBLS.ADTXML

PCHATBLS/CFOFTPAT

CTLRFINP.PCH.PR.PCHATBLS.IAPXML

PCHATBLS/CFOFTPAT

CTLRFINP.PCH.PR.PCHATBLS.SATXML

PCHATBLS/CFOFTPAT

CTLRFINP.PCH.PR.PCHATBLS.DAPXML

PCHATBLS/CFOFTPAT

CTLRFINP.PCH.PR.PCHATBLS.DEPXML

PCHATBLS/CFOFTPAT

WEEKLY/MONTHLY

FAC1220A/CFOFTPF1

WEEKLY/MONTHLY

FAC1220A/CFOFTPF2

DUPLICATE REPORT

WEEKLY/MONTHLY

FAC1220A/CFOFTPF3

DUPLICATE REPORT

WEEKLY/MONTHLY

FAC1220A/CFOFTPF3

DUPLICATE REPORT

WEEKLY/MONTHLY

FAC1220A/CFOFTPF3

DUPLICATE REPORT

WEEKLY/MONTHLY

FAC1220A/CFOFTPF3

PROJECT SUMMARY EQPT RPT

WEEKLY/MONTHLY

FAC1220A/CFOFTPF4

WEEKLY/MONTHLY

FAC1220E/CFOFTPF5

EASYTRIEVE

WEEKLY/MONTHLY

FAC1220E/CFOFTPF5

EASYTRIEVE

WEEKLY/MONTHLY

FAC1220E/CFOFTPF5

EASYTRIEVE

WEEKLY/MONTHLY

FAC1220E/CFOFTPF5

EASYTRIEVE

WEEKLY/MONTHLY

FAC1220E/CFOFTPF5

EASYTRIEVE

WEEKLY/MONTHLY

FAC1220E/CFOFTPF5

EASYTRIEVE

WEEKLY/MONTHLY

FAC1220E/CFOFTPF5

EASYTRIEVE


Department





Data Content

Description/Purpose







CON MF FAMIS FAACS CTLRFINP.CFO.PR.REPORTN FTP Scheduled

CON MF FAMIS Accounting CTLRFINP.CFO.PR.ENCUMB FTP Scheduled WEEKLY

CON MF CTLRFINP.CFO.PR.CPD.V1FEXTR DEPT PICKS UP Scheduled MONTHLY CFO0113A COBOL

CON MF FAMIS Purchasing CTLRFINP.PCH.PR.PCH906I1 Scheduled M-F PCH0906A

CON MF CTLRFINP.PCH.PR.PCH200A.RPT Scheduled M-F PCH0200A COBOL

CON MF CTLRFINP.PCH.PR.VENDCHNG Scheduled M-F PCH0200A COBOL

CON MF Purchasing PCH9201 REPORT Scheduled M-F PCH0920A COBOL

CON HRC system Scheduled M-F PCH0974B

CON HRC system Scheduled WED PCH0973A COBOL

CON none Scheduled TUES PCH0011W

WEEKLY/MONTHLY

FAC1220E/CFOFTPF5

EASYTRIEVE

ENCUMBRENCE REPORT

CFO0116A/CFOFTPC4

EASYTRIEVE

SORTS THE FAMV1F FILE AND SUMS VENDOR NUMBERS AND ALL THEIR YEARLY BALANCES AND SUFFIX RECORDS INTO ONE ALL YEARS TOTAL

Last day of month

PICKED UP BY CON

Commodity code Table

For as-needed requests for list of all commodity codes.

M-F Nightly batch

EASYTRIEVE

Vendor File resides in Accounting System

VIEWED BY CON OR DEPARTMENT

CHANGE VENDOR REPORT

CON/TTX CAN VIEW AS NEEDED TO TROUBLE SHOOT

M-F Nightly batch

Vendor File resides in Accounting System

PICKED UP BY CON

CHANGE VENDOR EXTRACT

TROUBLE SHOOTING REFERENCE

M-F Nightly batch

none; RMT39 no longer used

ACTIVE DOCUMENTS BY ORIGINATING DEPARTMENTS

It is possible that we should discontinue this. No one uses it any more.

M-F Nightly batch after PCH920

CTLRFINP.PCH.HRC.DATAC94***FROM HRC

PICKED UP BY NIGHTLY BATCH

UPDATES STATUSES ON FAMVCS

HRC SENDS FAMIS THEIR VENDOR STATUSES FOR EQUAL BENEFITS TO NIGHTLY BATCH TO UPDATE INTO CLASS STATUSES

M-F Nightly batch - part of ADPICS weekday schedule - after PCH005 - before PCH0030A

EASYTRIEVE

CTLRFINP.PCH.HRC.DATA1***FROM HRC

PICKED UP BY NIGHTLY BATCH

UPDATES FAMVHT AND FAMVCS

HRC SENDS FAMIS THEIR VENDOR STATUSES FOR LOCAL BUSINESS STATUS TO NIGHTLY BATCH TO UPDATE INTO CLASS STATUSES

Wed Nightly batch - after PCH001 - before PCH0750A

Vendor File (Accounting System)

NEW YES/YES VEN PCH006R4D WEEKLY REPORT

vendor statuses report


Tues Nightly batch - after PCH0022W

EASYTRIEVE


Department





Data Content

Description/Purpose







CON NEW BUS TAX RPT none Scheduled TUES PCH0011W

CON FAMIS Purchasing CTLRFINP.PCH.PR.ITBEXTR Dept picks up. Scheduled M-F PCH0146A COBOL

CON CTLRFINP.CFO.PR.EIS.FAMODF FTP EIS ODF EXTRACT Scheduled M-F & SUN CFOT069ECON CTLRFINP.CFO.PR.EIS.STATSODF FTP Scheduled M-F & SUN CFOT069E

CON FAMIS Accounting CTLRFINP.PCH.PR.PCHVBUS4 On request TUES PCH0022W

CON MONTHLY PCH0011M

CON FAMIS Accounting email On request Annual JCLENCB1

CON FAMIS Accounting Reports saved to dataset email On request Annual JCLWKENC

CON FAMIS Accounting USPS On request Friday CFO1358Z

CON FAMIS Accounting CTLRFINT.CFO.CCHU.DOC161 email On request Monthly ENCUMB

CON FAMIS Accounting n/a pickup On request As Needed DAHCONJM

CON FAMIS Accounting n/a pickup On request As Needed DAHCONJM

Vendor File (Accounting System)

list of newly added business tax information


Tues Nightly batch - after PCH0022W

EASYTRIEVE

DAILY PURCHASING ITB WEB EXTRACT

File is uploaded into the Purchasing BID Database for their web site

M-F Nightly Batch - ADPICS Weekly Schedule - after PCH002 at 7 p.m.

EIS ODF STATS EXTRACTBUSINESS TAX REPORTS

VENDOR NAME, VENDOR NUMBER AND BUSINESS TAX STATUS REPORT

BUSINESS TAX REPORTS

Reports saved to dataset, CTLRFINT.CFO.CCHU.WKENCFIL (interface file)

Reports and Interface file to establish workorder encumbrances after the final budget is posted in FAMIS.

This program creates an interface file to set up work order encumbrances based on original budgetsestablished in character 081.

Sept after final budget interface is posted.

Listing of Posted Work Order Encumbrance by Requesting/Performing Dept.

These reports are run after the automated workorder interface is posted and distributed to the depts.

Sept after interface is posted and all errors are cleared

CTLRFINT.CFO.CCHU.VEND1358.NEWZ

EDD - Independent Contractor Reporting Requirement

This program creates a report and extract of independent contractors that the City has paid or encumbered funds for in excess of $600. This info is required by EDD.

Every 3 weeks

Extract of outstanding GL161 doucments

This program creates an extract of outstanding travel advance (GL 161) documents

1st working day of month

List of Approval Time for Selected Document Prefix (non-grant documents)

These reports are used for performance measures.

List of Approval Time for Selected Document Prefix (grant documents)

These reports are used for performance measures.


Department





Data Content

Description/Purpose







CON FAMIS Accounting CTLRFINT.CFO.LEO.V5.SAUDITEX save to network On request As Needed JCLSNGL

CON FAMIS Accounting save to network On request Annual JC99999B

CON FAMIS Accounting save to network On request As Needed ALANCIPJ

CON FAMIS Accounting save to network On request Annual July CHKREG

CON DAHALL20 ftp to network On request Monthly DAHALL20

CON FAMIS Accounting CTLRFINT.CFO.CCHU.COW0500Z email On request Quarterly COW0500Z

CON CTLRFINT.CFO.CCHU.DAHCOND1 On request As Needed DAHCONAP

CON FAMIS Accounting email On request Annual Sept ENCLOSER

CON FAMIS Accounting CTLRFINT.CFO.CCHU.GL248ALL email On request bi-annual on request JCLGL248

CON FAMIS Accounting CTLRFINT.CFO.CCHU.LDSERROR email On request Annual Aug LEOERROR

CON FAMIS Accounting CTLRFINT.CFO.CCHU.FACPJT email On request As Needed FACPJT

CON FAACS Report saved to dataset save to network FAACS reporting and monitoring On request As Needed FAG110BJ

This creates an extract for an ACCESS database for Single Audit reporting

This creates an extract for an ACCESS database for Single Audit reporting

CTLRFINT.CFO.LEO.V5.FDBB001.INTRFILE

Interface to record 99999B balances

Fund Equity Recalculation - adjust SOBJ 99999B based on the fund equity balance as of FM 00 of the new year

Dec after prior fiscal year end is closed.

CTLRFINT.CFO.LEO.V5.CYRDATAX.DOWNLOAD; CTLRFINT.CFO.LEO.V5.PYRDATAX.DOWNLOAD

Current Year New Project Extract and Prior Year Project Extract

Extract of all Capital Projects Starting with "C" or have a "C" Project Type that were created in a given fiscal year based on the create date

CTLRFINT.CFO.CCHU.CHKREG; CTLRFINT.CFO.CCHU.SUMCHK

This is an extract of checks issued for bank #1501, 1600,1601, ACHPAY

This is the check register given to our external auditors at year-end

FAMIS Accounting, FAMIS Purchasing

This creates an extract of the Document History file for FAMIS and ADPICS document approval levels that are 20 or more days old.

To check for documents that took 20 or more days to approve.

Extract of document count by dept

This info is used as documentation for Controller's workorder billings to depts.

when requsted by CON-ADM


email or save file to network depending on file size

Extract of documents approved at CON795 & 800 levels

This info is used for performance monitoring by the AOSD Operations group.

Reports saved to dataset, CTLRFINT.CFO.MIL.V5.ENCLOSER.INTRFILE (interface file)

Reports and Interface to close out encumbrances entered in a 1090 entity

Year-end process to closeout encumbrances no longer in use.

Extract of GL248 documents processed in fiscal year

Used for dept monitoring and in post audit

Extract of LDS documents in error

This file is given to Alan at year end to clear the outstanding errors for the fiscal year being closed.

5060 report: Extract of projects updated before a certain calendar date

to monitor if Project in 5060 screen have the correct setup for FAACS

FAGOV110A-ADM: LISTING OF FIXED ASSETS WITH DETAILED TRANSACTIONS


Department





Data Content

Description/Purpose










CON FAACS save to network FAACS reporting and monitoring On request As Needed FACG110D

CON FAACS Report saved to dataset save to network FAACS reporting and monitoring On request As Needed FAG110FJ



CON FAACS Report saved to dataset save to network FAACS reporting and monitoring On request As Needed FAG110SJ

CON FAMIS Accounting APPR3675, S3240ALL, S3240LST FTP to CON server

FAGOV110B: LISTING OF FIXED ASSETS WITH BEG BALANCE AND DEPRECIATION TRANSACTIONS

FAGOV110B-ADM: LISTING OF FIXED ASSETS WITH BEG BALANCE AND DEPRECIATION TRANSACTIONS

FAGOV110C: LISTING OF FIXED ASSETS WITH DETAILED TRANSACTIONS-SORTED BY DEPT AND PROPERTY-ID

CTLRFINT.CFO.MIL.FA-PJ.FACG110D.DWLD110D

FAGOV110D: Extract of Category C & D Property IDs

FAGOV110F: SCHEDULE OF FIXED ASSETS BY FUNCTION

FAGOV110G: SCHEDULE OF CHANGES BY FUNCTION

FAGOV110H: SCHEDULE OF TOTAL DEBIT ACTIVITIES BY FUNCTION

FAGOV110S: SCHEDULE OF FIXED ASSETS BY SOURCE

Risk Based Approval Path

Download of famis users affected by the risk base approval for screen 3675.

S3675JCL, S3240JCL, RIM3240J


Department





Data Content

Description/Purpose







CON FAMIS Accounting Annual

CON FAMIS Accounting GRNTCLSD Grant Closeout Program Semi-Annual GRTCLSBF

CON FAMIS Accounting WORK100A Annual WORK100J

CON FAMIS Accounting LEOERROR To clean up trans in error file Varies LEOERROR

CON FAMIS Accounting TDFINQ FTP to CON server a quick query on TDF fields

CON LDS Email Scheduled Biweekly

CON LDS ConPaywithFringe.xls Email Scheduled Biweekly

CON LDS Email Scheduled Biweekly

SARF100A – D, SARF200A – E, SARF200A, E, L, S


6 reports used for State Reporting; Reports needed:A. Summarized electronic version of SR-210E and SR-210F which only show LINE TOTAL.B. Electronic version of SR-221A, SR-221B, SR-222A, and SR-222B.C. One hard copy of the following reports: 1. SR-210 A, B, C, D1, D2, E, and F 2. SR-220 B 3. SR-221 A and B 4. SR-222 A and B 5. SR-100 A, B, and C 6. SR-110 C

To assist in the production of the Financial Transactions Report for the State Controller's Office

JCLS100A, JCLS200A, JCLS210E


Interface file to close out inactive grants


Produces interface for budget and recovery entries; and 7 outputs for Ops and Depts

Carry forward of Performing Department's Appropriation


Listing of trans in the error file

Adhoc Inquiry on TDF data

as needed basis

N:\BUDGET\AccessDB\Files\Depts\Controllers\ ConEmpDetail.xls





N:\ACCNTING\BVA-1110\FY 10-11\rpt_BVA_1110.11262010.pdf




Department





Data Content

Description/Purpose







CON Access FAMIS Accounting FTP Loaded to old Peoplesoft 7.5 system Scheduled weekly

CON Budget E-mail to Sang Tran Annual Salary Ordinance Scheduled 2x per year

CON CTLRFINP.CFO.PR.EIS.FAMODF FTP EIS ODF EXTRACT Scheduled M-F & SUN CFOT069ECON CTLRFINP.CFO.PR.EIS.STATSODF FTP Scheduled M-F & SUN CFOT069E

CON

CTLRFINP.PCH.PR.PCHVBUS3 EMAILED Scheduled TUES PCH0022W

CON, DPW FAACS Report saved to dataset FAACS reporting and monitoring On request As Needed FAG110BJ

FAMIS Accounting CTLRFINT.CFO.CCHU.DOC201B On request Annual ENCUMB

CON-BAD FAMIS Accounting email COWCAP overhead interface On request Annual COWALLOC

CON-BAD FAACS Report saved to dataset email On request As Needed FAG110BJ

hisf1t.txt (fund type)hisf2t.txt (fund)hisf3t.txt (subfund)hisfnt.txt (program)hisg1t.txt (grant)hisict.txt (index code)hiso1t.txt (character)hiso2t.txt (object)hisort.txt (organization)hispjt.txt (project)hisuct.txt (usercode)

Monday at 7:45 AM

AccessDB: mcr_OutputStructuresForHRD

aso_hr_interface.txt (interim)aso_hr_interface_final.txt

Late May for interimLate July for final

Informatica: wf_d_BUD_IF_out_ASO

EIS ODF STATS EXTRACT

It is a listing of the Positive Pay Issued and Cancelled Checks for Payroll

CON BUSINESS TAX REPORTSThe extract contains the new vendors, business tax numbers and expiration dates

Controller needs the report for trouble shooting

EASYTRIEVE

CON-save to network; DPW-Pickup

FAGOV110A: LISTING OF FIXED ASSETS WITH DETAILED TRANSACTIONS

CON, PUC, AIR, MTA

Saved to Network for CON and emailed to Depts

Extract of open voucher (GL 201, 205 & 243) documents. This is generally requested by enterprise depts during audit time.

This program creates an extract and hard copy reports of open voucher (GL 201) documents.

Aug/Sept after month 12 is closed

Reports saved to dataset, CTLRFINT.CFO.CCHU.COWALLOC.INTRFILE (interface file)

Reports and Interface to bill depts for overhead charges budgeted in the AAO.

Sept after the final budget interface is posted

FACG110S: version of FACG110A with Index code

Data used for COWCAP Cost Allocation Plan


Department





Data Content

Description/Purpose







FAMIS Accounting email On request As Needed PWCLOPJT

CPC FAMIS Accounting FamisByPPD.xls Email Scheduled Biweekly

CPC LDS CPCEmpDetail.xls Email Scheduled Biweekly

CPC LDS CPCPaywithFringe.xls Email Scheduled Biweekly

CSS FAMIS Accounting FamisByPPD.xls Email Scheduled Biweekly

CSS LDS EmpDetail.xls Email Scheduled Biweekly

CSS LDS CSSPaywithFringe.xls Email Scheduled Biweekly

CSS LDS CSS_BVA_1010.pdf Email Scheduled Biweekly

DAT LDS EmpDetail.xls Email Scheduled Biweekly

DAT LDS DAT_BVA_1010.pdf Email Scheduled Biweekly

CON-BAD; PUC, DPW

Reports saved to dataset, CTLRFINT.CFO.CCHU.PWCLOPJD.INTRFILE (interface file)

Transactions to close out inactive projects

This job creates an extract which is then processed by FAMIS as an interface file to close out inactive projects. This job is run when requested by the BAD group and various depts (PUC, DPW, PRT, etc.) based on the data entered by the department on the 1090 screen

n/a, extract is a Turnaround Special type of extract




















Department





Data Content

Description/Purpose







DAT LDS DAT_BVA_1110.pdf Email Scheduled Biweekly

DPH MF FAMIS LDS DPHPC Extract Scheduled BI-WEEKLY CFO0360D COBOL

DPH MF FAMIS LDS DPHLH Extract Scheduled BI-WEEKLY CFO0360D COBOL

DPH MF FAMIS LDS DPHGH Extract Scheduled BI-WEEKLY CFO0360D COBOL

DPH MF FAMIS LDS DPHJH Extract Scheduled BI-WEEKLY CFO0360D COBOL

DPH MF FAMIS LDS DPHHH Extract Scheduled BI-WEEKLY CFO0360D COBOL



CTLRFINP.CFO.PR.DPHPC.FAMEXT

n/a, intermediary file only, refer to Description

This extract is not sent to DPH. It is one of the eight 8 intermediary temporary extract files where the data is used to create FORMDPH1 and FORMDPH2. Extracts FORMDPH1 and FORMDPH2 files are sent to the DPH Server.

n/a, the file is not sent to DPH

Tuesday of payweek

CTLRFINP.CFO.PR.DPHLH.FAMEXT




Tuesday of payweek

CTLRFINP.CFO.PR.DPHGH.FAMEXT




Tuesday of payweek

CTLRFINP.CFO.PR.DPHJH.FAMEXT




Tuesday of payweek

CTLRFINP.CFO.PR.DPHHH.FAMEXT




Tuesday of payweek


Department





Data Content

Description/Purpose







DPH MF FAMIS LDS DPHPH Extract Scheduled BI-WEEKLY CFO0360D COBOL

DPH MF FAMIS LDS DPHSA Extract Scheduled BI-WEEKLY CFO0360D COBOL

DPH MF FAMIS LDS DPHMH Extract Scheduled BI-WEEKLY CFO0360D COBOL

DPH MF FAMIS Purchasing CTLRFINP.PCH.DPH.TAPE1 FTP Scheduled WEEKLY PCH0750A COBOL


CTLRFINP.CFO.PR.DPHPH.FAMEXT




Tuesday of payweek

CTLRFINP.CFO.PR.DPHSA.FAMEXT




Tuesday of payweek

CTLRFINP.CFO.PR.DPHMH.FAMEXT




tuesday of payweek

EXTRACT COMMODITY AND VENDOR DATA

The vendor and commodity data are used to update the tables in CMS (Professional Service / Construcvtion Contract Management System). DPH uses CMS and COOL (Contract Online System) to create and support construction contracts.

CMS Professional Service / Construcvtion Contract Management System

Wednesday




Wednesday


Department





Data Content

Description/Purpose










MF FAMIS LDS CTLRFINP.CFO.PR.FORMDPH1 FTP Scheduled BI-WEEKLY COBOL

MF FAMIS LDS CTLRFINP.CFO.PR.FORMDPH2 FTP Scheduled BI-WEEKLY COBOL

DPW FAMIS Accounting CTLRFINP.CFO.PR.DPW.FAMLPD DEPT PICKS UP LPD EXTRACT Scheduled BI-WEEKLY CFO2700A SORT

DPW FAMIS Accounting CTLRFINP.CFO.PR.DPWOPF DEPT PICKS UP Scheduled CFO0200A




Wednesday




Wednesday




Wednesday

DPHSFGH

DPH payroll information (refer to interview notes)

The extract provides labor payroll information for reporting

DPH Labor Reporting database

Tuesday of payweek

CFO0360D\CFOFTPS5

DPH DPH payroll information (refer to interview notes)

The extract provides labor payroll information for reporting

DPH Labor Reporting database

Tuesday of payweek

CFOD0360D\CFOFTPS6

11 extracts are downloaded to refresh the DPW CAT system database.

DPW CAT Contract Automation Tracking System

FAMIS Document Transaction Tables & Files - Operating file



TUE/THUR/SUN

EASYTRIEVE


Department





Data Content

Description/Purpose







DPW FAMIS Accounting CTLRFINP.CFO.PR.DPWICT DEPT PICKS UP Scheduled CFO0200A IDCAMS

DPW FAMIS Accounting CTLRFINP.CFO.PR.DPWTBL DEPT PICKS UP Scheduled CFO0200A

DPW FAMIS Accounting CTLRFINP.CFO.PR.DPWSBF DEPT PICKS UP Scheduled CFO0200A

DPW FAMIS Accounting CTLRFINP.CFO.PR.DPWPJT DEPT PICKS UP Scheduled M-F IDCAMS

DPW FAMIS Accounting CTLRFINP.CFO.PR.DPWSBT DEPT PICKS UP Scheduled CFO0200A IDCAMS

DPW FAMIS Accounting CTLRFINP.CFO.PR.DPWG1T DEPT PICKS UP Scheduled CFO0200A IDCAMS

DPW FAMIS Accounting CTLRFINP.CFO.PR.DPWPJF DEPT PICKS UP Scheduled CFO0200A IDCAMS

DPW FAMIS Accounting CTLRFINP.CFO.PR.DPWUCT DEPT PICKS UP Scheduled CFO0200A IDCAMS

DPW FAMIS Accounting CTLRFINP.COF.PR.DPWTDF DEPT PICKS UP Scheduled SUN CFO0202A

FAMIS Document Transaction Tables & Files - Index Code



TUE/THUR/SUN




TUE/THUR/SUN

EASYTRIEVE

FAMIS Document Transaction Tables & Files - SUBSIDIARY FILE



TUE/THUR/SUN

EASYTRIEVE

FAMIS Document Transaction Tables & Files - Project



CFO0200A/CFO0200B

FAMIS Document Transaction Tables & Files - SUBSIDIARY TABLE



TUE/THUR/SUN

FAMIS Document Transaction Tables & Files - GRANT TABLE



TUE/THUR/SUN

FAMIS Document Transaction Tables & Files - Project File



TUE/THUR/SUN

FAMIS Document Transaction Tables & Files - USER CODE TABLE



TUE/THUR/SUN

FAMIS Document Transaction Tables & Files - TDF FILE



EASYTRIEVE


Department





Data Content

Description/Purpose







DPW FAMIS Accounting

DPW FAMIS Accounting CTLRFINT.CFO.CCHU.WBERRORS email On request As Needed WIERRORS

DPW FAACS CTLRFINT.CFO.CCHU.FACS120X Email FAACS reporting and monitoring On request As Needed FACS120D

DT FAMIS Accounting CTLRFINT.CFO.CCHU.WIERRORS email On request As Needed WIERRORS

DTIS MF FTP Scheduled

DTIS MF FTP Scheduled

DTIS MF DEPT PICKS UP Scheduled

ECD LDS Email Scheduled Biweekly

FIR FAMIS Accounting FamisByPPD.xls Email Scheduled Biweekly

WorkOrder Billings transactions for services performed by DPW

Each month DPW initiates a standard FAMIS Job CFO0045A/FAMJ2910 to create an extract file of Work Order Transactions and the following 3 reports: • FAMB2912 Project Billing Interface Listing• FAMB2910 Inter-department billing Report, and• FAMB2910 Inter-depart Billing Error Report

The Workorder Billing Transaction extract file is submitted as a batch interface file #11 to record the revenue and expenditure transactions.

After the Work Order Billing interface file is run, DPW then requests the Controller Department to produce the Interface Error Report to clear the errors.

FAMJ2910/CFO0045A

Extract of WB documents in error

The extract contains the errors, if any, found during the processing of interface file #11. After interface file #11 is run, DPW will request the Controller to generate this extract, and the info is used by DPW to clear their interface errors.

DPW Reporting database

FACS120E: Extract of report FACS120A

DPW FAACS Reporting database

Extract of WITI documents in Error

This info is used to help dept clear their interface errors.

CTLRFINP.CFO.PR.DTISWO1.OVERRUN

ONCE A MONTH ON 15TH

CFO0114A/CFOFTPIS

EASYTRIEVE

CTLRFINP.CFO.PR.DTISWO1.CARRYFWD


CFO0114A/CFOFTPIS

EASYTRIEVE

CTLRFINP.CFO.PR.DTISWO1.CURRYEAR


CFO0114A/CFOFTPIS

EASYTRIEVE

N:\BUDGET\AccessDB\Files\Depts\ECD\ECDPayWithFringe.xls






Department





Data Content

Description/Purpose







HRC MF FAMIS PURCHASING SFCMN.OAA.HRC.FMEXT2 DEPT PICKS UP FAMIS EXTRACT Scheduled M-F PCH0100A

HRC MF FAMIS PURCHASING SFCMN.OAA.HRC.ADPEXT DEPT PICKS UP ADPICS EXTRACT Scheduled M-F PCH0100A

HRC MF FAMIS PURCHASING CTLRFINP.PCH.PR.HRCEXTPU DEPT PICKS UP PO/BP EXTRACT Scheduled FRIDAY PCH0100B

HRC MF FAMIS PURCHASING SFCMN.OAA.PR.HRC.ENC FTP Scheduled FRIDAY COBOL

HRC MF FAMIS PURCHASING SFCMN.OAA.PR.HRC.PAY FTP Scheduled FRIDAY COBOL

HRC MF FAMIS PURCHASING SFCMN.OAA.PR.HRC.DIR FTP Scheduled FRIDAY COBOL

HRC MF FAMIS PURCHASING SFCMN.OAA.PR.HRC.ADPCONT FTP Scheduled FRIDAY COBOL

HRC MF FAMIS PURCHASING SFCMN.OAA.PR.HRC.ADEXT FTP vendor.txt Scheduled FRIDAY COBOL

HRC MF FAMIS PURCHASING SFCMN.OAA.PR.HRC.CERVEND FTP cervendor.txt

HRC MF FAMIS PURCHASING SFCMN.OAA.SBCXTRAC DEPT PICKS UP Commodity Extract Scheduled M-F PCH0980A COBOL

HRC MF FAMIS PURCHASING SFCMN.OAA.VENXTRAC DEPT PICKS UP VENDOR EXTRACT Scheduled M-F PCH0980A COBOL

HRC MF FAMIS PURCHASING SFCMN.OAA.VXSXTRAC DEPT PICKS UP Scheduled M-F PCH0980A COBOL

purpose is to produce LBE utilization reports

Elation Diversity Monitoring & Vendor Certification System

EASYTRIEVE

Produce reports on the availability of LBE certified firms

LBE Certifidation Database

EASYTRIEVE



EASYTRIEVE

esfftp.sfgov.org encumbrance.txt



OAA0200A/OAA0100A

esfftp.sfgov.org payment.txt



OAA0200A/OAA0100A

esfftp.sfgov.org directpayment.txt



OAA0200A/OAA0100A

esfftp.sfgov.org contract.txt



OAA0200A/OAA0100A



OAA0200A/PCH0100A



The data is used by HRC to determine if equal benefits apply to certain groups of vendors based on the commodities they provide

Equal Benefit System



VEND/COMD EXTRACT




Department





Data Content

Description/Purpose







HRC MF FAMIS PURCHASING CTLRFINP.PCH.PR.HRCEXTPO ADPICS EXTRACT Scheduled M-F PCH0100B

HRC MF FAMIS PURCHASING CTLRFINP.PCH.PR.HRCEXTPU ADPICS EXTRACT Scheduled M-F PCH0100B

HRD LDS BVA 1110 Email Scheduled Biweekly

HRD FAMIS Accounting APS.txt Email Scheduled Biweekly

HRD Budget BGT.txt Email Bargaining Units Scheduled Biweekly

HRD FAMIS Accounting F3T.txt Email Sub-funds Scheduled Biweekly

HRD FAMIS Accounting ICX.txt Email Index Codes (Incremental Update) Scheduled Biweekly

HRD Budget JBP.txt Email Job Classes Scheduled Biweekly

HRD Budget O1X.txt Email Scheduled Biweekly

HRD FAMIS Accounting ORT.txt Email Organizations Scheduled Biweekly



EASYTRIEVE



EASYTRIEVE



Prime Service Area (Department Titles)











Organization Crosswalk (3 character to 2 numeric)






Department





Data Content

Description/Purpose







HRD FAMIS Accounting SpendPlan.txt Email Spending Plan Data Scheduled Biweekly

HSA DEPT PICKS UP Scheduled M-F CFO0005D

HSA LDS EmpDetail.xls Email Labor data Scheduled Biweekly

LHH LDS CTLRFINP.CFO.PR.CFO0126A FTP Scheduled BI-WEEKLY

LHH LDS CTLRFINP.CFO.PR.CFO0127A FTP Scheduled BI-WEEKLY



CTLRFINP.CFO.PR.FAMBAF.DHSFSBRT.BACKUP

A backup file of checks and warrants cleared by Bank of Amercia.

From Vaughn LaForce: The CTLRFINP.CFO.PR.FAMBAF.DHSFSBRT.BACKUP is used as input to perform two primary functions: 1 Pass daily HSA warrant status changes in FAMIS to CalWIN. 2 Match CalWIN warrant cancellations with FAMIS “cashed” records and initiate transactions to fix incorrectly canceled warrants in CalWIN if necessary.

HSA Cash Issuance System

IDCAMS Repro

The extract contains individual payroll data by pay period, for example regular work hours in the pay period, regular non-work hours in the pay period, premium pay in the pay period, total wage in the pay period, total fringe in the pay period, YTD figures as of that pay period for various fields, various identification data like index code, roster code, job class, etc.

HSA Labor Reporting Access database



Report labor charges by employees with DOE and subobject information

Extract contains employee salary information for a pay period.

Data is used by LHH Payroll department for analysis and reporting

LDS Reporting database

Tuesday of payweek

CFO0126A/CFOFTP26

EASYTRIEVE

display detail labor charges by jobclass and employees

This extract contains the YTD salary information for employees.



Tuesday of payweek

CFO0127A/CFOFTP27

EASYTRIEVE


Department





Data Content

Description/Purpose







LHH LDS CTLRFINP.CFO.PR.CFO0127B FTP Scheduled BI-WEEKLY

LHH FAACS Report saved to dataset for soft copy On request As Needed FACS120D

LHH FAACS Report saved to dataset for soft copy On request As Needed FACS120D

LHH FAACS Report saved to dataset for soft copy On request As Needed JCLF220A

Employee labor charges by index codes

This extract containas the summary salary information for the employees.



Tuesday of payweek

CFO0127B/CFOFTP27

EASYTRIEVE

interoffice mail or email (soft copy)

FAACS120B: LISTING OF FIXED ASSETS BY FUNDING SOURCE & SITE ORGANIZATION (WITH ACQUISITION ACTIVITY)

There are 7 extracts for LHH which contain fixed asset information for all divisions withint DPH, including LHH, SFGH, Jail Health, Home Health etc. After receiving the files, LHH Finance runs a macro to select and convert only the data associated with LHH to an Excel file format for users to generate reports for the auditors.

LHH loads data to an Excel FAAS Reporting database


FAACS120C: LISTING OF FIXED ASSETS BY LOCATION & SITE ORGANIZATION




FAACS220A: LISTING OF FIXED ASSETS WITH TOTAL COST AND BOOK VALUE BY FUNDING SOURCE




Department





Data Content

Description/Purpose







LHH FAACS Report saved to dataset for soft copy On request As Needed JCLF220A

CTLRFINP.CFO.PR.MYRS060 EMAILED FAMRS060 REPORT Scheduled BI-WEEKLY CFO0360D COBOL

MTA FAMIS Purchasing CTRFINP.CFO.PR.PCH0012D FTP Scheduled M-F COBOL

MTA LDS CTLRFINP.CFO.PR.MTAF.DAH Scheduled

MTA LDS mtaEmpDetail.xls Email For inquiry and reporting by users Scheduled Biweekly

MTA LDS BudvsAct.xls Email For inquiry and reporting by users Scheduled Biweekly


FAACS220C: LISTING OF FIXED ASSETS WITH TOTAL COST AND BOOK VALUE



MAYOR'S OFF HOUSING

Tuesday of payweek

ACTIVE VENDOR FILE

For adhoc reporting of vendor information

MTA Access Reporting database

PCH0012D/PCHFTP04

Dataset accessible to MTA: CTLRFINP.CFO.PR.MTAF.DAH

Document Processing Time data - Listing of Docs by MTA users in Approval Path with # of days takes to approve.

Data is used for performance monitoring and analysis. A mere copy of Connie's DAHPUCFI but extracts MTA data under org = dpt, mta, ptc and txc.

Performance Monitoring database

Monthly ( First Sunday of every month)

Actual charges by employee, FAMIS accounting codes for current period, year to date

MTA labor database



Compares LDS actuals to Budget

MTA labor database




Department





Data Content

Description/Purpose







PORT Budget CTLRFINP.CFO.PR.PORT FTP Scheduled M-F COBOL

PUC CTLRFINP.CFO.PR.PUC.FAMICT FTP Scheduled TUESDAY SORT

PUC CTLRFINP.CFO.PR.PUC.FAMG1T FTP GRANT EXTRACT Scheduled TUESDAY SORT

PUC CTLRFINP.CFO.PR.PUC.FAMPJT FTP PROJECT EXTRACT Scheduled TUESDAY SORT

PUC CTLRFINP.CFO.PR.PUC.FAMPMT FTP Scheduled TUESDAY IDCAMS

PUC CTLRFINP.CFO.PR.PUC.FAMTBL FTP Scheduled TUESDAY IDCAMS

PUC CTLRFINP.CFO.PR.PUC.FAMGLF FTP Scheduled TUESDAY ICEMAN

PUC CTLRFINP.CFO.PR.PUC.FAMOPF FTP Scheduled TUESDAY SORT

TDF EXTRACT; FAMIS document transaction tables and files

The extract file contains the previous day's transactions which include invoices paid, contracts, encumbrances and remaining balances etc from various FAMIS document transaction tables and files.PORT IT Group has developed a program to filter and populate the Oracle E-Business AP/GL database with the transaction detail data from the extract file. Reports are generated from the Oracle databases for the users, and one of the purposes of the reports is to compare and validate the data which are maintained in both FAMIS Accounting and Oracle E-Bus systems are in synch.

Port Oracle E-Business Suite database

CFOBPORT/ CFOFTPRT

INDEX CODE EXTRACT

Download to PUC Oracle database weekly, feeds several PUC systems and databases..

PUC Oracle Document Reporting database

CFO0102P/CFOFTPA



CFO0102P/CFOFTPA



CFO0102P/CFOFTPA

PARAMATER EXTRACT



CFO0102P/CFOFTPA




CFO0102P/CFOFTPA

GENERAL LEDGER EXTRACT,FAMIS Document Transaction Tables & Files



CFO0102P/CFOFTPA

OPERATING EXTRACTFAMIS Document Transaction Tables & Files



CFO0102P/CFOFTPA


Department





Data Content

Description/Purpose







PUC CTLRFINP.CFO.PUC.FAMLPD FTP Scheduled BI-WEEKLY CFOFTPPA

PUC CTLRFINP.CFO.PUC.FXFIN FTP Scheduled WEEKLY CFOFTPXA ICEMAN

PUC CTLRFINP.CFO.PUC.FXMST FTP Scheduled WEEKLY CFOFTPXA ICEMAN

PUC CTLRFINP.CFO.PUC.DCF FTP Scheduled WEEKLY

PUC CTLRFINP.CFO.PUC.DHF FTP Scheduled WEEKLY

PUC CTLRFINP.CFO.PR.PUCTDF FTP Scheduled M-F ICEMAN

PUC CTLRFINP.CFO.PR.DAHPUCFI FTP Scheduled WEEKLY

PUC DEPT PICKS UP Scheduled BI-WEEKLY CFO0103C COBOL

PUC DEPT PICKS UP Scheduled BI-WEEKLY CFO0103C COBOL

PUC DEPT PICKS UP On request BI-WEEKLY CFO0360D ICEMAN

LDS EXTRACTFAMIS Document Transaction Tables & Files



See comments

FAACS FIN FILE,FAMIS Document Transaction Tables & Files



FAACS MST FILE,FAMIS Document Transaction Tables & Files



DCF EXTRACTFAMIS Document Transaction Tables & Files



CFO0102Q/CFOFTPA

EASYTRIEVE

DHF EXTRACTFAMIS Document Transaction Tables & Files



CFO0102Q/CFOFTPA

EASYTRIEVE

TDF EXTRACT,FAMIS Document Transaction Tables & Files



CFO0101P/CFOFTPP3

DAH EXTRACT,Document Processing Time data


PUC Performance Monitoring Database

CFO0103A/CFOFTPUC

EASYTRIEVE

CTLRFINP.CFO.PR.CWPPUCF.FAMLEM

MASTER RECORDS LDS,Labor cost



Tuesday of payweek

CTLRFINP.CFO.PR.CWPPUCF.FAMLEH

HOME BASE LDS,Labor cost



Tuesday of payweek


CTLRFINP.CFO.PR.PUC.LABORDET

LABOREDET EXTRACT.Labor Cost



Tuesday of payweek


Department





Data Content

Description/Purpose







PUC CTRFINP.CFO.PR.PCH0012D FTP Scheduled M-F COBOL

PUC CTLRFINP.PCH.PR.EXTVENLB FTP Scheduled M-F

PUC Purchasing CTLRFINP.PCH.PR.EXTBP1XC FTP Scheduled M-F COBOL

PUC CTLRFINP.PCH.PR.PCH906I1 FTP Scheduled M-F

PUC FAMIS Accounting 1099 information On request CFO0950G

PUC FAACS n/a On request As Needed JCLFAMIS

PUC FAACS CTLRFINT.CFO.CCHU.DAHPUCFI email On request As Needed DAHPUCFI

FAMIS Accounting, Vendor

Vendor HRC data, refer to interview notes fo additional description

Four Vendor and Commodity data files are downloaded weekly to MAXIMO, and the data is used by the Purchasing module to create Direct Purchase Orders in FAMIS via Hostbridge

MAXIMO Asset Management Inventory System

PCH0012D/PCHFTP04

FAMIS Accounting, Vendor

Vendor header information and one address record



PCH0035W/PCHFTP05

EASYTRIEVE

An extract of the blanket PO Header information only. Note: from Connie Mar at PUC, this was originally called EXTBP!XC, but the name got swapped with the one above several years ago.



PCH0035W/PCHFTP05

FAMIS Purchasing - Commodity

An extract of Commodity Code



PCH0906A/PCHFTP05

EASYTRIEVE

1099 G FORMS AND FILE FOR GO-SOLAR

1099 tapes are sent to IRS electronically, and the printed forms are delivered to PUC

The extract contains the 1099 information The actual forms are sent to the vendors for tax reporting, and a softcopy is sent to the IRS. See additional notes in Comments.

Forms are sent to PUC for review and the 1099 tape is sent electronically to IRS

pickup, interoffice mail or email (soft copy)

OLF-800: LISTING OF ACTUAL EXPENDITURES - FT 5C BY PROJECT AND INDEX CODE

This is one of the 7 extracts of FAACS data used by PUC for reporting and monitoring

PUC FAACS database

Document Processing Time Data - Extract of documents approved by PUC staff

This info is used for performance monitoring at PUC.

Performance Monitoring database


Department





Data Content

Description/Purpose







PUC FAACS Report saved to dataset for soft copy On request As Needed PUCEQUIP

PUC FAACS Report saved to dataset for soft copy On request As Needed FACJ120R

PUC FAACS CTLRFINT.CFO.CCHU.FACS120X email On request As Needed FACS120D

PUC, LHH FAACS Report saved to dataset for soft copy On request As Needed JCLF220A

PUC, LHH Report saved to dataset for soft copy As Needed FAP110AJ


PUC Capital Outlay Report A

This is one of the 7 FAACS reports used by PUC for reconciliation and monitoring.

PUC FAACS Reporting database


FAACS 120R: LISTING OF NEW FIXED ASSTES DURING THE FISCAL YEAR BY FUND TYPE AND CATEGORY



FACS120D: Extract of FACS120A




FAACS220B: LISTING OF FIXED ASSETS WITH TOTAL COST AND BOOK VALUE BY CATEGORY INCLUDING DEPRECIATION

PUC - This is one of the 7 FAACS reports used by PUC for reconciliation and monitoring.

LHH - There are 7 extracts for LHH which contain fixed asset information for all divisions withint DPH, including LHH, SFGH, Jail Health, Home Health etc. After receiving the files, LHH Finance runs a macro to select and convert only the data associated with LHH to an Excel file format for users to generate reports for the auditors.

PUC FAACS Reporting databaseLHH loads data to an Excel FAACS Reporting database


FAENT110A: LISTING OF FIXED ASSETS WITH DETAILED TRANSACTIONS





Department





Data Content

Description/Purpose







PUC, LHH FAMIS Accounting Report saved to dataset for soft copy Scheduled As Needed FAP110AJ

REC LDS CTLRFINP.CFO.PR.RECF.FAMLPD DEPT PICKS UP LPD EXTRACT Scheduled BI-WEEKLY CFO2700A COBOL

REC FAMIS Accounting FTP Scheduled 3 days / week

REC LDS EmpDetail.xls Email Scheduled Biweekly

REC LDS BudVsAct.xls Email Scheduled Biweekly

Retirement

SFGH FAMIS TDF CTLRFINP.FNB.FAM25 FTP FAMRS025 REPORT Scheduled MONTHLY COBOL


FAENT110B: LISTING OF FIXED ASSETS WITH BEG BALANCE AND DEPRECIATION TRANSACTIONS




Tuesday of payweek

recpark_impromptu_356003007_extract.txtrecpark_impromptu_extract.txt (600203003 with filter)recpark_impromptu_600203003_extract_nofilter.txtrecpark_impromptu_609542001_extract.txt

Feeds Rec/Park Capital Project SystemRuns scripts for:35.60.03.007 Rec & Park - sel FM.imr60.02.03.003 TDF GLs - sel Sub-fund & GL.xls60.95.42.001 REC Projects - Vendor Related Payments Listing - sel FY & FM.imr

Mon, Wed, Fri at 3:00 AM

Informatica: wf_aw_FAM_IF_out_RecCapital





A copy of the BofA file which contains the pension checks which had been cleared.

Pick Up (Retirement runs a job to download extract file to the Retirement server)

Retirement Checks which have been cleared by Bank of America

Reitrement downloads he file to its Pension Administration System to record the pension checks which had been cleared. The data is used for reconciliation and for tracking the check status.

Extract of YTD expenditure information is combined with data from SFGH Payroll & Invision Systems to create the monthly reports for Medicare and Medicaid

GENISYS Hospital Budget & Reimbursement System

CFO0250H/CFOFTPG1


Department





Data Content

Description/Purpose







SFGH FAMIS TDF CTLRFINP.FNB.RPT25.YTD FTP FAMRS025 REPORT Scheduled CFOFTPG2 COBOL

SFGH FAMIS TDF CTLRFINP.FNB.RPT25.YTD2 FTP FAMRS025 REPORT Scheduled CFOFTPG2 COBOL

SFGH MF FAMIS LDS CTLRFINP.CFO.PR.FAM370 FTP FAMRS060 REPORT Scheduled BI-WEEKLY COBOL





SFGH CTLRFINP.CFO.PR.SFGH62

Year-end extract of SFGH annual expenditure information. It is run on month 13, and the data is used to create reports for the auditors


ON REQ-ANNUALLY

Year-end extract of SFGH annual expenditure information. It is run on month 13, and the data is used to create reports for the auditors. Note - SFGH cannot remember why there are 2 year end extracts, will require a developer to look at the code and identify the differences between the 2 extracts, FNB25MON.TXT and FNB25MON2.TXT.


ON REQ-ANNUALLY

The Payroll information of employee, classification, benefits and pay type, are used for analysis, reimbrusements and adhoc reporting.

Departmental LDS/Payroll database

CFO0360D/CFOFTPS1



CFO0360D/CFOFTPS2



CFO0360D/CFOFTPS3



CFO0360D/CFOFTPS4


Departmental Payroll database

CFO0360D/CFOFTPS0

sent as an email attachment.


Department





Data Content

Description/Purpose







TTX EMAILED Scheduled M-F M-F PCH0031D

TTX FAMIS Accounting FamisByPPD.xls Email Scheduled Biweekly

TTX LDS TTXPay.xls Email Scheduled Biweekly

CTLRFINP.CFO.PR.VENADD.RPT145

VENDORS ADDED REPTList of newly added vendor in the FAMIS vendor file.

List of vendors newly added to the vendor file for Bus Tax. According to the Business Tax group, this vendor report is only used occasionally. They generally use the P25 report to update the vendor account in the Business Tax System

Business Tax System

EASYTRIEVE

YTD total salary and fringe benefit amount for all employees within the Treasurer & Tax Collector department, and it includes part time employees, full time employees, and contractors.

7 report extracts for Treasury are used for budgeting and work order billings. These reports contain the employee pay by pay period, YTD pay amount, pay with fringe benefits, actual pay amount vs budgeted amount. The attrition . report is used for budgeting salary purposes.

The report is loaded into the Treasury Labor database in Excel format, which also contains budtet information. The report is loaded into the Treasury Labor database in Excel format, which also contains budtet information.



YTD salary amount for all employees within the Treasurer & Tax Collector department, and it includes part time employees, full time employees, and contractors.






Department





Data Content

Description/Purpose







TTX LDS TTXPaywithfringe.xls Email Scheduled Biweekly

TTX LDS TTX_BVA_1010_FTE.xls Email Budget vs Actual Pay Scheduled Biweekly

YTD total fringe benefit amount for all employees within the Treasurer & Tax Collector department, and it includes part time employees, full time employees, and contractors.










Department





Data Content

Description/Purpose







TTX LDS TTX_BVA_1010BY.xls Email Budget vs Actual Pay Scheduled Biweekly

TTX LDS TTX_BVA_1010.xls Email Budget vs Actual Pay Scheduled Biweekly










Department





Data Content

Description/Purpose







TTX LDS Attrition.xls Email Scheduled Biweekly

Various n/a pickup As Needed JCL0826A

Attrition salary data 7 report extracts for Treasury are used for budgeting and work order billings. These reports contain the employee pay by pay period, YTD pay amount, pay with fringe benefits, actual pay amount vs budgeted amount. The attrition . report is used for budgeting salary purposes.




OLF-826A: LISTING OF TRANSACTION CODES BY GL ACCOUNT

Report used to look up approriate transaction code to use for FAMIS entries.

document.xlsx Departmental Systems 45 of 85 RFP# CON2014-18

System Name Brief description of the system and purpose

Operating System

Equal Benefit database Operating System

Both

Air eJOA Financial

Air SFOtime Operational This is the time keeping system for SFO.

Dept Code

Financial or Operational System, or both?

System Technical Environment (platform, software, volume, proprietary or vendor developed)

What is the main functional purpose of the system (i.e. Reporting, Auditing, Analysis), and who are the primary users?

ADM (HRC)

LBE (Local Business Enterprise) Certification database

The purpose of the LBE Certification Database is to track, qualify, & process enrollment into CMD’s LBE, PUC-LBE, & NP-LBE Program.

The LBE database is a MS Access database developed in late 1990s by City staff.

Primary users are CMD staff to track, qualify, and process enrollment into CMD's LBE program.

ADM (HRC)

The Equal Benefit database is used by the three HRC Certification staff to maintain 12B Equal Benefit Compliance Ordinance information on all active vendors (approximately 1500 vendors), including the vendor number, vendor name and the Equal Benefit status (Yes or No). The vendor and compliance status information is manually maintained by the HRC staff, and it is used for reporting purposes.

Class/Status for Equal Benefits = HBN Compliance or HBN PND (pending status)

The Equal Benefit database is a MS Access database developed in late 1990s by the HRC staff in collaboration with DT.

Tracks 12B compliance and contacts with vendors. Updates vendor status in ADPICS. Provides reports on 12B compliance status and tracks compliance.

ADM (HRC)

Local Business Enterprise Tracking System (LBEUTS)

The LBEUTS enables the Contract Monitoring Division (CMD) to ensure that City departments are in compliance with the provisions of the Local Business Enterprise (LBE) Ordinance, whose purpose is not only to assist small local businesses to compete effectively for City contracts, but also to provide for an overall fair City-wide contracting process.

The LBEUTS is an off the shelf system with some customization made by the staff at Elation System & Software. It is a web-based system.

The LBEUTS is maintained by both Elation System & Software.

The LBEUTS tracks payments between the City, prime, and subcontractors to ensure compliance with the provisions of the Local Business Enterprise Ordinance.

Contains budget values used to validate labor changes in the Airport timekeeping system. Based on DPW eJOA.

Microsoft Windows Server, SharePoint, originally developed by DPW

This is the back-end system to SFOtime. The purpose of this system is to provide the information for SFOtime that validates the labor charges and the funding source. Currently data is manually entered into eJOA, but we are in development of integrating with our internal Capital Planning System (CPS) of automate the process.

Timekeeping system. Transmit data to City Emerge System via interface. System validates the time spent on projects to the budget data in eJOA.

Microsoft Windows Server, SharePoint, .NET, originally developed by DPW


System Name Brief description of the system and purposeDept Code




Air Financial

Air Financial Oracle RDBMS

Air Both

Air Operational In development

Air PMBS Financial

Air Airport Labor Database Financial Internally developed Access database

Air Taxi Revenue System Financial Manage taxi revenue and operation

Capital Planning System (CIP Planner)

System is used to track approved capital plan and facility maintenance project budgets, process funding requests for both types of projects, and view project budget to actual expenses.

CIPPlanner CIPAce running on Microsoft Windows Server and SQL Server

The Capital Planning System (CPS) is the system that tracks, monitors, and provide information to run analytical reports for all SFO capital projects. It also is the system that provides budget information and funding information for projects.

Passenger Facility Charge Revenue Reporting System

System is used to track information submitted by airlines on passenger facility charge revenue collected. System tracks cash receipt transaction numbers and interest earnings. FAA oversight on the PFC program requires the Airport to track and report on this data.

To facilitate data compilation, reporting, auditing and analysis. Primary users are the PFC Accounting group.

Ground Transportation Management System (in development)

System tracks ground transportation providers and deducts fees from provider accounts using vehicle transponders.

Vendor developed using Microsoft.NET 4.5 development platform. The integrated development environment (IDE) is Visual Studio 2013 and the programming language is C# 5.0. A customized software solution with integration to other systems including SFMTA's RideIntegrity, utilizes Microsoft SQL Server 2012 platform operating system. Will have a client server application as well as web portal.

Track financial information and other information of the Ground Transportation providers at SFO.

Contract Management and Compliance System (in development)

System will track compliance information for professional service and construction contracts. System may be used to report on contract payments

Tracking and monitoring of contracts at the Airport

Property Management and Billing System - manages revenue and accounts receivables from tenants, leaseholders

Vendor developed using Microsoft.dot.net platform, an off-the-shell package and supported by vendor on Oracle and SQL data based platform. Resides on a Windows server.

Lease management & billing system, including tenant and lease tracking, revenue and accounts receivable

Captures employee level labor data, such as time, cost, pay types, etc.

Used for analysis, reporting, reimbursements, and auditing. Capital Project and Grants team.

is a standalone system, and there is no automated interface with FAMIS. Revenue data is manually entered into FAMIS.

Vendor developed and customized software






Assessor Both

Assessor Both

CAT CityLaw Both

CPC Operational Vendor Developed

CPC Contracts Summary Financial Excel Spreadsheet

City's Property Tax Database System (EZ-Access system based on IBM's AS/400 system)

Citywide property tax database system to manage assessed value for all county taxable property, including real property, business personal property, marine and other vessels and possessory interest for use of government-owned property. San Francisco's assessed value roll is in excess of $1.7 billion and includes more than 200,000 parcels.

The system is based on an IBM pla6tform called AS/400 (Application System 400) with a proprietary vendor interface known as EZ-Access

The main function of the system is to report assessed value and manage changes in assessed value for real property. There is also a module for business personal property valuation. The primary users are the real property transaction clerks, appraisers, appraiser supervisors,mid-level managers and business personal property auditors. The system also provides data to respond to inquiries from members of the public.

Clerk-Recorder Imaging Information System or (CriiS)

This system is the county's vital records management system for marriage certificates and real property recorded documents. The system also records all transfer tax levied and collected by San Francisco.

Proprietary vendor developed software- At-Pac is the vendor.

To view and retrieve recorded documents and process transfer tax payments and recorded document fee collection.

Case, Claims and Work Assignment Management System

SQL Server based client/server system developed by Cycom Data Systems, Inc.

Case, claims and work assignment management including tracking all time and costs associated with said matters, as well as collecting data for use in billing our clients and tracking their use of our services.

Accela Automation (Permit & Project Tracking System, or PPTS)

Web-based permit and project tracking system for most of DBI's and Planning's project reviews.

PPTS is scheduled to go live in late Summer of 2014. It will be the main project and building permit tracking system for Planning & DBI. It has a robust workflow engine that tracks a proejct through it's review process, and displays the project status through an online Citizen Access (ACA) portal. All staff in both departments will use the backend system. The front end ACA system is open to the public to access and search for any information, and it's open to registered users to submit an online applicaton or pay a fee.

Listing of closed, current and pending professional service contracts, including budget, encumbrances, expenses, remaining balance, contractor information, compliance, etc.

Manage the department's professional service contracts






CPC Grant Summary financial Excel Spreadsheet Manage the department's grants

CPC financial Excel Spreadsheet

CPC FAMIS by PPD Extract financial Excel Spreadsheet

CPC Project Summary financial Excel Spreadsheet Manage the department's projects

CRT FISCAL DATABASE Financial oracle, MS Access. Proprietary

CRT CABS DATABASE Financial Oracle, Magic, MS Access. Proprietary

CSC Track status on budget, salary, and benefits Financial Excel database

CSC Financial

CSC Financial

CSC Financial Email and Excel database

CSS To record parent payments Both Web-based Cash register

CSS Tracking Log-FY13-14.xlsx Excel Financial Microsoft TrackingCSS Excel Financial Microsoft Analysis & Reconciliation

CSS Expenditure Spreadsheet Excel Financial Microsoft Analysis & Reconciliation

Listing of closed, current and pending grants, including budget, grantor, project, start and end date, project manager, other agencies, work orders, etc.

Work Order Recovery Summary

Listing of closed, current, and pending work order recoveries, budget, agency, start and end date, project manager, project description, encumberances, actual billed to date, remaining balance, projection for the rest of the fiscal year, account codes, etc.

Manage the department's work order recoveries

Biweekly report of payroll expenses by account code and employee used to prepare expenditure projections

Prepare payroll projections that feed into our expenditure projection.

Listing of closed, current, and pending projects, budget, agency, start and end date, project manager, project description, encumberances, actual billed to date, remaining balance, projection for the rest of the fiscal year, account codes, etc.

Translates payroll data from FAMIS to transmit to the State

To facilitate data compilation, reporting, auditing and analysis. Primary users are the Court Accounting group.

The system maintains payment information for the Court Appointed Attorneys, Investigators and Expert Witnesses for Indigent Defense.

To facilitate data compilation, reporting, auditing and analysis. Primary users are the Court Accounting group.

CSC Budget/Payroll database

Reporting and analysis. Primary user is CSC.

Invoice tracking document/database

Manage and Track status of vendor invoices and payments

Handwritten document and Excel database

Reporting, and status tracking. Primary user is CSC.

Work Order document/database

Maintain information on services performed for other departments

Handwritten document, Word, and Excel database


Real Estate document/database

Maintain real estate and lease agreement, and rental payments


California Child Support Automation System - Child Support Enforcement (CCSAS-CSE)

GL Accts & Revenue Analysis.xlsx






CSS Excel Financial Microsoft Reconciliation

CSS Bank Reconciliation Excel Financial Microsoft ReconciliationCSS To input data for budget Financial Web-based Budget entry

DAT CALWRAP DATABASE Both Microsoft Access

DBI Operational Vendor Developed

DBI Both

DEM Operational

DEM Financial

Reconciliation: Revenue vs. Expenditure

State of California - Health & Human Services Agency (Department of Child Support Services - CS921)

CALWRAP DATABASE - This is an Access Database used to manage the District Attorney's Relocation program

Daily operations in managing the Witness Relocation Program to include, invoicing, setting up accounts, closing accounts, reporting as needed, and tracking witnesses.

Accela Automation (Permit & Project Tracking System, or PPTS)

Web-based permit and project tracking system for most of DBI's and Planning's project reviews.

PPTS is scheduled to go live in late Summer of 2014. It will be the main project and building permit tracking system for Planning & DBI. It has a robust workflow engine that tracks a proejct through it's review process, and displays the project status through an online Citizen Access (ACA) portal. All staff in both departments will use the backend system. The front end ACA system is open to the public to access and search for any information, and it's open to registered users to submit an online applicaton or pay a fee.

Pont of Sale - iPayment/Wausau Remittance and Cashiering System

Remittance and cashiering system with an enterprise content management solution for all the transactions including defined workflows.

Integrated Windows based system for remittance, cashiering, archival and workflow.

Processing payments received by DBI for various fees owed to the City and County of San Francisco.

Service Now transitioning from BMC Remedy

Tracks IT asset inventory, and IT requests for service (primary function).

web-based system with some customizations

Main function is keeping track of all requests for service that goes through the DEM helpdesk.

Financial Management Workbook

Database of grant expenditures classified according to the grant requirements, the pupose of which is to track and report grant spending and to serve as a drawdown mechanism.

Excel file with macros developed by grantor.

Reporting and auditing. Grantor is the primary user






DPH DPH LDS Database E10 Financial

DPH Financial Reporting of contract data.

DPH COOL (Contract Online) Financial Contract Document Repository.

DPH

The DPH LDS database maintains Payroll data extracted from FAMIS

FORMDPH1 and FORMDPH2 files are created using data from 8 separate extracts (refer to Extract File #3 through 10 in this document) of various LDS transaction data.

The data is stored in an Oracle Database while the front-end is made in Oracle Application Express (APEX).

Reporting of labor distribution data for Human Resource staff, non finance managers, analysts, and support staff that do no have access to FAMIS /EIS. The database does have value for a subset of non finance users who do not require as much detail in their data and as a result the query is simpler to use and faster than EIS for non finance staff.

CMS Contract Management System

DPH Contract office uses CMS (Contract Management System) and COOL (Contract Online) to create and maintain contracts.

COOL is made up of 2 systems. CMS in the database part of the system it is an Oracle Database. The second part is the document management system that is provided by EMC / Documentum. Web based system on the DPH internal Network.

COOL is used for document storage, review, development and routing. also document repository for sole source requests, all contract documents for all DPH programs. COOL uses some of the info entered into CMS to create the contract folders.

Oracle database that captures structured contract data; and a document repository based on an EMC Documentum product which stores unstructured data such as forms, PDFs, etc. The Oracle database feeds information into Documentum and end users then upload documents into Documentum. This is an internal and external web based application.

Avatar MSO PPN Provider Claims

The MSO module of the Netsmart Avatar system is the claims payment module of the Avatar electroic health records and billing system. MSO processes adjudicates and processes claims paid to PPN providers of behaviorial health services for CBHS (Community Behvioral Health Services)

Avatar is an electronic health record and patient billing system. Generates claims payments to PPN providers.

Developed by Netsmart. Proprietary software for behavioral health. This is a national company with a California version of the application.

To pay claims to PPN providers. An FTP file interfaces with FAMIS to cut checks to PPN providers






DPW Financial

DPW Financial

DPW Financial and Operational

DPW Financial

eJOA

Allows for electronic creation and approval of job orders, which allow Public Works to track individual scopes of work with detailed budgets by activity and location.

SQL Server, .Net, SharePoint, K2 Developed in house.

Electronic creation and approval of job orders systemDPW uses eJOA to create job orders online. Data is manually entered into eJOA, and the completed document is then submitted for approval. After it is approved, transaction is entered manually into FAMIS where a JE is processed to update (increase or decrease) the budget.

RAS (Requisitions for Materials and Supplies)

Requisition Tracking and Approval System. It automates requisition process. DPW and Vendors request, approve, fund, and complete requisitions for materials and supplies online.

SQL Server, .NetDeveloped in house.

DPW uses RAS to create requisitions for materials and supplies. Data is entered into RAS manually, and the completed requisition is submitted via Hostbridge into FAMIS Purchasing for approval and encumbrance.

After funds are encumbered and PO is created, the PO information is sent to DPW to update RAS via Hostbridge

OFFMA 81 (Construction and Professional Services Contracts)

DPW System Description - OFFMA 81 is an Automated, dual approval path contract system used for advertisements, bidding, and awards.


Data related to bids and awards are entered manually into OFFMA 81. This includes bid information, bidder data, bid responses etc. Some of the information is used for advertising.

Data to encumber funds for the contract is entered manually into FAMIS. After the funds are encumbered, the Document # is entered manually into the OFFMA 81 system and the award is issued.

CAT (Construction and Professional Services Contracts Database)

DPW System Description - CAT, the Contract Automated Tracking System is the central database for the contract systems. CAT takes information from the Contracts eSystems and in turn those eSystems populate information in CAT. Used for look up and reporting purposes.


Provides one central place to view contract information pulled from multiple systems.






DPW FinancialeCO (Change Orders for Construction Contracts)

eCO is an application that electronically processes change orders for construction contract. Change orders are associated to the original construction contract.


Processes and maintain change order information for Construction contracts. The system captures two types of contract changes:

1. The changes do not impact the contract amount or funding source - This scenario does not require a FAMIS update, and it only requires a change order record to be created in eCO.

2. The changes either impact the contract cost or there is a change to the funding source - This scenario requires a change order to be created in FAMIS to adjust the contract amount and/or the funding source.

Change Order records are created manually in FAMIS and in eCO. After the record is processed by FAMIS, the fund accountant then updates the record in eCO with the FAMIS Change Order document number.






DPW Financial

DPW Financial

DPW eCSO Financial

eMod(Change Orders for Professional Contracts)

DPW System Description - eMod is the Contract system used to modify existing professional service contracts.


Process and maintain change order information for Professional Service contracts. Two scenarios of Professional Service contract changes:1. The changes do not impact the contract amount and there is no change to the funding source - This scenario does not require FAMIS updates, and it only requires a change order record to be created in eMod.

2. The contract changes either impact the contract cost or there is a change to the funding source - This scenario requires a change order to be created in FAMIS to adjust the contravt amount and/or the funding source. Change Order records are created manually in FAMIS and in eMod. After the record is processed by FAMIS, the fund accountant then updates the record in eMod with the FAMIS Change Order document number.

ePayment (Construction and Professional Services Contracts)

Payment processing system whereby contractors invoice and also enter the information that is required by CMD (old forms 7,8, & 9) . Payment is processed using a workflow.


Online vendor invoicing systemThis is the DPW Vendor Invoicing System - Vendor submits invoice via ePayment online function. After it is approved, DPW enters the invoice into FAMIS manually to request payment.

Online contract system that external and internal users operate to issue and approve Contract Service Orders and Task Orders under a master agreement between DPW and a contractor. Used for Master Agreements and As-Needed Contracts.


Online system which creates Construction and Professional Services orders/releasesData is entered into FAMIS manually to encumber funds for the contract. After the encumbrance is processed, a contract record is created in eCSO and populated with the FAMIS encumbrance number. As-Needed Construction and Professional Services contracts function like BPOs and releases.






DPW PMDB Financial

DPW EPM Financial

DPW PMAD Financial and Operational

DPW CMMS Operational INFOR EAM version 10.1.2

Interface used to query labor and non-labor cost/budget information by lower level detail. Used for reporting purposes

SQL Server, .NetDeveloped in house.

Database shows estimated and actual labor expenditures, non labor cost and other cost information for reporting purposes

DPW enterprise project management system provideds a central platform for project managers, leads, and staff set up and track project scope and schedule and share information among different divisions. It also enables the high level project financial planning.

MS Project Server and Project Pro;Sharepoint;SQL Server;

The primary users are project managers, leads, engineers, architects in IDC, BDC, and BPM. It provideds a central platform for project managers, leads, and staff set up and track project scope and schedule and share information among different divisions. It also enables the high level project financial planning.

Project Management and Accounting Database used only by Construction Management to issue CSO's, process invoices, track expenditures on labor and invoice payments, and track reports. Used for reporting purposes only.

SQL Server, MS AccessDeveloped in house

PMAD is used by Engineers and Architects to track the milestone for the Construction and Cost Management phases of a construction project. To Track as needed contracts, issues cso's, and track costs. Generate status reports.

CMMS is a Commercial Off the Shelf software solution (INFOR EAM) utilized by RED and DPW Operations Bureaus for the following:1. Tracking of city assets (e.g. facilities, streets, trees, bridges, tunnels, etc)2. Management of the workforce that provides maintenance on these City assets. Units of work are tracked via "Service Orders".

Purpose:1. Tracking of city assets (e.g. facilities, streets, trees, bridges, tunnels, etc)2. Management of the workforce that provides maintenance on these City assets. Units of work are tracked via "Service Orders".Note: Other features in Software Solution are not utilized.

Primary Users:1. RED Stationary Engineers and Managers2. DPW Operations Managers, Supervisors, Administrative Staff4. City Dept Requestors






DPW Permit Accounting Financial

DPW Progen Financial

DPW DPW Order Financial

DPW DPW FAACS database Financial

DPW Financial

DPW MyTIME (used to be DETS) Financial DPW Employee timekeeping system

Internally developed system used to record details of all financial transactions related to Bureau of Street Use and Mapping's activities, including permit processing. Used for reporting purposes only.

Web Application, ASP.net/VB.net, SQL Server DB Backend, In house development

Tracks Permit Issuance and its Payment statusDPW issues permits for various reasons, such as street closing for events, Right of Way, Excavations etc. Permit request data is manually entered into the Permit Acctg system. This system also maintains the status of the Permit (issued or in process) and its Payment (paid or outstanding).

Database software for JOC contracts, acting as the link between contractors & DPW to create Task Orders and to determine pricing. Used for reporting purposes only.

It maintains Job Order for As Needed Construction contracts. As-Needed Cntracts are like BPOs and JOC is the blanket release

Approval system to electronically create and sign documents such as hearings, contract advertisements, and other official records.


Approval system to electronically create and sign documents such as hearings, contract advertisements, and other official records. DPW does not have a Commission to approve awards like other depts. DPW provides services to other depts which have Commissioners and General Manager to approve and sign awards. DPW is under a directive to award contacts The award info is entered manually into the DPW Order System and signed by the Director of DPW. This system does not interface with FAMIS

database for reporting DPW fixed assets information

For reporting purposes. Controller sends DPW a report of its assets to confirm. DPW reviews the report, confirms or makes corrections, if any, before returning the report to the Controller's department

eGrant (under development)

Grant database & Electronic Grant Billing & Reconciliation System

SQL Server, .Net, SharePoint Developed in house.

MyTIME - Timekeeping system for entering and approving employee time records

SQL Server, .Net, SharePoint Developed in house.






DT CIMS Financial

Fire SFFD HRMS Mostly Operational Oracle Database

Fire BFP Database System for tracking permits and inspections. Both Oracle Database

HSA Panoramic System Both, operational and financial

HSA DAAS CDA Grants Database Operational

HSA Operational

HSA FC Rep Payee Database Operational

The CIMS system is used to collect blling information from DT's various sytems and provide a interface into FAMIS for our workorder billing to client departments. Client departments can also view their monthly billings by logging on to CIMS.

CIMS is runs on an XP server box. Cutrrently it is an unsupported verdor product

The main purpose of is CIMS is to collect billing data from DT various sources and generate a workorder billing interface file into FAMIS for DT's monthly workorder billing for client departments

Internal HRMS system for tracking of inventory, vehicles, personnel, facilities.

Reporting and tracking. All members have access to system to input data, but most reporting is done by support staff.

Report and track all Bureau of Fire Prevention (BFP) inspections and permits, and their corresponding fees.

The application used primarily in DAAS- Public Administor/Public Guardian-Public Conservator/Representative Payee Programs to set up and manage clients/decedent estates, document and track clients inventory, and produce periodic Court Accounting documents. It is a fully integrated financial and Accounting system used by DAAS Accounting team.

Panoramic is a web-based vendor application solely developed for County Public Guardian-Public Conservator and Public Administrator. It is currently in use in 30 California counties , Texas Department of Aging and Disability Services, the Kentucky Cabinet of Health and Family Services, Office of the Public Guardian in Cook County (Chicago), and Clark County PA/PG (Las Vegas, NV).

The application is used for collecting client/decedent demographic information, tracking of clients, assets, heirs, and case notes, producing Court Accounting Documents, case management, sharing information and transferring cases between programs, processing payments and ACH and manual deposits, cash management, auto distribution of interests, producing misc. Jasper and adhoc reports.

Database tracking grant information from funder commitments to encumbrances, grant expenditures, and match expenditures by required cost categories for reporting and claiming purposes.

Access database developed and maintained by HSA Staff

Reporting and analysis by Ping Chen, Jian Feng He, and Heather Davis

HUD Grants Database (in early development)

Database tracking grant information from funder commitments to encumbrances, grant expenditures, and match expenditures by required cost categories for reporting and claiming purposes and to support audit files. Also tracks actual claims and receipts.


Reporting and analysis by Jens Hansen, Gregorio Montemayor, and Heather Davis

Foster Care SSI/SSA Representative Payee client database, tracking client-level credits and debits to GL 219 and Subsidiaries SSO012, SSO017, and SSO018 in lieu of separate bank accounts for every client.


Reporting and analysis by Caren Wan and Heather Davis






HSA Claimsdata Financial Reporting and analysis

HSA CARBON Operational

HSA Cost Summary Financial/Operational Reporting and Analysis

HSA SimClaim Financial/Operational

HSA Jobs Now Operational

HSA Operational Data repository

HSA FCS Calwin Issuances Track CalWIN warrants for Foster Care Program Financial Data repository

HSA VACS Operational

HSA CalWIN Both, operational and financial

HSA Working Family Credit Financial

Database tracking claim information and revenue from State/Federal Agencies

Access database developed and maintained by HS Staff

Human Services Contracts Division system for recording various contracts and accepting vendor billing/invoice documents

Access database developed and maintained by outside vendor with a Web Interface for users

Sharing budget and performance parameters and outcomes, uniform electronic online invoicing against budget, and maintaining and tracking invoice payment business processes.

Database that categorize expenditure data included in the Quarterly Administrative Expense Claims (from Foxpro files).


Revenue Simulation Model that is used for budgeting purposes.

A system of Excel spreadsheets developed and maintained by HS Staff

Reporting and analysis, by HSA budget and fiscal staff

Client tracking system for clients active in the job search/work programs


Reporting and analysis, by HSA fiscal and program staff

RWS-Returned Warrant System

Track warrants returned by workers to fiscal for cancellation



Ventura Automated Collection System is used for collection of client overpayements to the various Human Services programs.

It is a client server system hosted in Ventura County

System used to track client accounts receivable, payments, and generates monthly statements

Eligibility determination and benefits issuance system maintained by a 19 county consortium at the State level

The CalWIN system is a vendor developed system for 18 user counties

The system is used to determine client benefit eligibility and issue client benefit payments

The WFTC System maintains information on recipients who are eligible to receive Working Family Credit checks. The WFTC system produces a file that is used by FAMIS to generate checks. Once checks are generated out of FAMIS, a file with the check number, recipient and check amount is emailed to the WFTC manager who imports that information into WFTC.

Technical Environment:• The WFC application went online on 2/5/07 and it was built in house by the HSA IT development team. • The system is also being maintained by the HSA IT team. • It is a web based application, built using Coldfusion and a SQL back end database. • There are currently 22 active users who process roughly 12,000 applicants each year.

Proccessing applications for the Working Families Tax Credit






HSA Cash Issuance System Financial

HSA Financial

The HSA Cash Issuance System performs many functions, for example• Creates the HSA Warrant interface file • Interfaces with the CALWIN system (California Welfare Information Network) to obtain the recipient and benefit information. The information is then used to create the Daily Warrant interface file to post to FAMIS • Matches CalWIN warrant cancellations with FAMIS “cashed” records and initiates transactions to fix incorrectly canceled warrants in CalWIN if necessary • Maintains and assigns warrant numbers• Maintains the HSA Banking information, including the bank numbers associated with the warrants issued • Creates a print file that is sent to Reprographics for printing and mailing • Provides adhoc and reconciliation reports for HSA, and other agencies, such as the Housing Authority• Interfaces with BofA for funds transfer

HSA Cash Issuance System is written in COBOL. It was developed locally by DTIS (SF Department of Telecommunications & Information Services) staff in 2005. It was turned over to HSA IT staff for maintenance and enhancement in 2008.

Daily file size is 50 to 100 records. On a day when monthly Fiscal warrants are issued (4 work days before the last calendar day of the month) the number of records could reach 3200.

Interface of fiscal issuance data to FAMIS

HSA LDS Reporting database

The database maintains individual payroll data by pay period, for example regular work hours in the pay period, regular non-work hours in the pay period, premium pay in the pay period, total wage in the pay period, total fringe in the pay period, YTD figures as of that pay period for various fields, various identification data like index code, roster code, job class, etc.

The HSA Labor database is an Access database, developed and maintained by HSA staff

The data is used by HSA for reporting, claims processing, and reconciliations






HSS Both

JUV Financial reporting and tracking account status

JUV Financial Excel reporting and tracking

JUV Financial Excel Inventory

JUV Financial Excel Reporting and tracking

JUV Financial Excel

eMerge Benefits Administration module

eMerge functions as the transactional system utilized by HSS to administer benefits for employees and retirees, and their dependents.• Employer Groups (City College district, SF Unified Schools, Superior Court, and City and County of San Francisco) • Benefit information includes medical, dental, RX (when carved out), FSA/HSA selections, and other fringe benefits such as LTD, Life Insurance, etc.

Approximately 62,000 members and 48,000 dependants, a total of approximately 110,000 individuals being maintained by the system.

Processing health and other employee benefits, Reporting, Auditing, Analysis. Primary users are Benefit Analysts and Finance.

JJIS Juvenile Justice Information System

There are several components of this system. The Restitution Module records and tracks restitution payments made by the juveniles on probation, including the amount ordered by the court, the total payments made, and the remaining balance.

Youth Confiscated and Contraband Funds database/spreadsheet

Tracks the funds confiscated from the juveniles. After the juveniles are released, they can request the funds to be returned to them.

Inventory database/spredsheet

Tracks POs and receipt. JUV uses FAMIS Purchasing to purchase materials and supplies, primarily use Prop Q as the authority. JUV also has its own blankets.

Foster Care Administration Account database/spreadsheet

The database maintains the funds reimbursed by the Fed Govt to manage juveniles who are not in foster care

Work Order Billing Approval Database (for services received / performed by other departments)

It maintains payment requests from other departments for services performed on behalf of JUV. JUV reviews and approves the billing via email.






LHH LHH FAACS database Financial Excel

LHH Financial

LHH LHH LDS database Financial

MTA Operational Only by MTA

MTA Financial Only by MTA

The database contaisn fixed asset information for all the divisions within DPH, including SFGH, LHH, Jail Health, Home Health etc. The data is downloaded to LHH via FAMIS extracts. After receiving the extract files, LHH Finance runs a macro to extract only the data associated with LHH, and convert it to a database in the Excel format. for users to generate reports for the auditors.

ADL (Patient Trust Account System)

At LHH, an account is set up in ADL (Patient Trust Account System) when the patient is admitted to maintain the patient’s income/deposits (for example Social Security checks) and expenses (for example share cost/co-pay for medical services). ADL is like the banker for the patients. .

This LDS database contains employee salary information (hours & $ by each employee.) for a pay period and YTD. It also maintains employee salary summary information by subobjects and payment codes. This file is used by the LHH Payroll department for analysis and reporting.

The data is stored in an Oracle Database while the front-end is made in Oracle Application Express (APEX).

Reporting of labor distribution data for Human Resource staff, non finance managers, analysts, and support staff that do no have access to FAMIS /EIS. The database does have value for a subset of non finance users who do not require as much detail in their data and as a result the query is simpler to use and faster than EIS for non finance staff.

Revenue sales accounting and inventory tracking of fare media

Kenneth Edmonson [email protected]

Primary User: MTA Revenue Operations Unit. For Customer service, detail sales, invoices and collections (example, by fare media type and individual vendors)

Finance accounts receivable and accounts payables

Paul Kao [email protected]

Primary User: Revenue Accounting Unit. Accounting & Reporting on Retail sales, invoices and collections (example, by fare media type and individual vendors)






MTA Operational

MTA Operational

MTA Grants Management Operational No

MTA Financial

MTA Operational

Detailed schedules, resource loading, labor usage analysis, standardized WBS, timesheet submission and approval, forecast labor.

Lucien Burgert [email protected]

Timesheet submission; scheduling; resource loading and analysis; Work Breakdown Structure control; forecast and actual labor reports.

Primary users: Project-based staff.

Yes, for the purposes of scheduling and resource loading, Primavera P6 is used by other entities.

System of Record for Transit Operator payroll

Rosa Esquivel [email protected]

TRANSIT OPERATOR SCHEDULE, WORK, TIMEKEEPING TRACKING

TRANSIT OPERTIONS, SCHEDULES, DISPATCH, PAYROLL, TRAINING, LICENSE AND MEDICAL, TRANSIT SUPERVISION

Matt Brill [email protected]

The main functional purpose of the system is capital fund management. It is used to coordinate funds between Capital Procurement and Management, Accounting and Capital Financial Planning and Analysis on grants. The primary users are the Capital Procurement and Management team.

System of Record for SFMTA's Capital Program Controls System

Lucien Burgert [email protected]

Project financials reporting and analysis. System of record for SFMTA's Capital Program Controls System.

Primary users: Agency-wide.

Not aware of any other entities using EcoSys.

Tracking vehicle assets and inventory

Bus: Jim De Metris [email protected]: Carol Wolther [email protected] Management: Angela [email protected]

For Materials Management: SHOPS is a complete inventory management and control system utilized to handle the entire inventory life cycle, tracks all inventory transactions, monitors stock levels to automatically create replenishment requests when necessary, and provides reporting functionality to management and interested parties. Primary users are the inventory mgmt staff (storekeepers, materials coordinators, managers) and procurement staff (purchasers, assistant purchasers)

SHOPS is also used by Muni Rail and Rubber Tires Maintenance departments to track work orders, vehicle assets, material costs, labor hours and to plan preventive maintenance.SHOPS data is also extracted and used by SFMTA Accouting/Finance to reconcile transactions at end-of-month processing.






MTA Operational n/a

MTA Operational Unknown

MTA Financial NO

MTA Financial No.

New Enterprise Asset Management System in planning phase

Infor EAM will be the agencies primary asset management system. It is expected that it will replace SHOPS and the other assets systems currently in use within the MTA.

The system is not currently deployed but DPW does use an on presmise version of the software.

Vendor Reporting Database for Adhoc Queries

Carolyn Lew [email protected]

Extract current Vendor Number & Name, etc.

Captures project and overhead costs for cost allocation calculations and distribution across projects and cost centers

Paula Florence/ Deo Laudencia [email protected] [email protected]

Reporting, Billing - using Overhead Rate to calculate & allocate to various index codes. Grant Section Staff, Paula Florence Deo Laudencia

MS Access database which maintains the garage deposit data downloaded from the BofA accounts. The purpose is to post daily revenue collected from the garages to the respective garage revenue index codes/subobjects in FAMIS.

Keith Chan & Paulette Benson [email protected] [email protected]

The interface saves our time to enter manually the amounts of different index codes and sub-objects to FAMIS.






MTA Both

MYR Total Grant Solution Financial vendor developed

MYR iEmployee Financial platform Reporting - Finance Team

MYR Audit Log Financial proprietary Auditing - Finance Team

MYR Monitoring Log Financial proprietary Auditing - Finance Team

eTIMS (Electronic Ticket Image Management System) is a fully integrated ticket information management system that handles the processing of parking violation and residential permit parking. There are various subsystems - the core being General Processing which is used to inquire about parking tickets, record payments, make adjustments to ticket payments, respond to and generate correspondence, suspend ticket processing and record ticket dispositions. In addition, it automatically assesses financial penalties and mail notices. The Residential Parking Permit system is an on-line interactive system for entering and maintaining RPP information.It maintains parking Permit and Citation Payment information, including Process Date and Payment Date, Amount, Method or How Paid (check, cash, credit cards) and Account or where the payment was made (customer service center, lockbox, DMV, by phone, by web.

eTime creates four interface files to record the Parking & Traffic refunds transactions in FAMIS

Paul Kao [email protected]

Fully integrated ticket information management system that handles the processing of parking violation and residential permit parking form ciations issue to ciatations settllement (either payment or dismissal)

SFMTA's is soley used by the department, as per contract with PRWT, the system adminisrator and payment processor (through lockbox).

TGS is the grant administration tool for the Workforce Development Division.

Reporting - Finance and Contract Administration staff

iEmployee is our timesheet management system.

Track receipt of audited financial statements as required by grant contracts.

Track progress of subgrantee financial monitoring.






MYR Track employee expense preapprovals Financial platform Auditing - Finance Team

MYR Film Permit Database Both proprietary Analysis - Film Commission

MYR Financial proprietary

MYR EMSI Operational software

MYR Monster Operational software

MYR Salesforce Operational software

MYR Base Camp Operational platform Analysis - Film Commission

MYR Elations Operational platform Reporting

MYR Vertical Response Operational platform

MYR Cash Receipt Log Track cash received by the department. Financial proprietary Auditing - Finance and Admin staff

SmartPDF (Employee Preapprovals)

This database tracks film permits, filming locations, and payments

Contract and Invoice Tracker

Track contracts and invoices as they are processed.

Auditing - Finance, Contracts, and Admin staff.

Provides labor market data, workforce intelligence, and regional economic analysis - combining expert research and consulting with professional software.

Analysis - Workforce Development Division

Real-time data and analytical tools for labor market information (job listings, job requirements)

Analysis - Workforce Development Division

Track interactions with all businesses and cases for individual businesses we are assisting. We are also working to make the system develop reports that show changes in the commercial corridors over time.

Analysis - Office of Small Business, Economic Development, Workforce Development Divisions

This is a searchable database of film industry reports. This tool is used to target productions in development by sending them information about Scene in SF Rebate Program.

Web based labor compliance system for the submittal, tracking and review of electronic certified payroll reports in order to track compliance with prevailing wage requirements; monitor local workforce hiring goals for Citybuild; and cloud based CRM (Customer Relations Management) database system for CityBuild to track clients, contractors, and project status.

Vertical Response is a web-based contact management and communication system that we use to distribute public meeting notices, event invitations, funding notifications and our e-newsflash to our various stakeholders.

Reporting - Used by Admin staff for mass mailings.






PORT Both

PORT Financial

Oracle E-Business Suite (EBS)Subsystem Inventory

Module of Oracle E-Business Suite for automated inventory control and management

Platform: Red Hat Enterprise Linux 4.8 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: Oracle E-Business Suite 11i (11.5.10.2) - Inventory (INV) core standard module.

Data stored in Oracle RDBMS 10gR2 backend-tier database.---------------Developed by vendor (Oracle Corp.) & configured by Port IS Business Apps staff and external consultants to meet Port of SF business process and data rqmts.

Manage quantities and average cost pricing of materials and supplies Portwide.

Primary users are Accounting, Maintenance, and Storeroom staff.

Oracle E-Business Suite (EBS)Subsystem Accounts Payable

Module of Oracle E-Business Suite for managing cash flow and processing of payments

Platform: Red Hat Enterprise Linux 4.8 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: Oracle E-Business Suite 11i (11.5.10.2) - Payables (AP) core standard module.


Vendor payments and financial reporting.

Primary users are Accounting staff.






PORT Both

PORT Operational

Oracle E-Business Suite (EBS)Subsystem Purchasing

Module of Oracle E-Business Suite for supplier management

Platform: Red Hat Enterprise Linux 4.8 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: Oracle E-Business Suite 11i (11.5.10.2) - Purchasing core standard module.


Automated procure-to-pay cycle integrated with resource planning, particularly for Oracle eAM.

Primary users are Business Services/Purchasing staff.

Oracle E-Business Suite (EBS)Subsystem Human Resources

Module of Oracle E-Business Suite for maintaining employee, assignment, position, job class, grade, hourly rate information to support Oracle E-Business Suite, custom Oracle Payroll, and custom Work Management. Manually sychronized with PeopleSoft HR.

Platform: Red Hat Enterprise Linux 4.8 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: Oracle E-Business Suite 11i (11.5.10.2) - Human Resources (HR) core standard module.


Employee validation, compensation

Primary users are HR and Payroll staff.






PORT Both

PORT Both

Oracle E-Business Suite (EBS)Subsystem Accounts Receivable

Module of Oracle E-Business Suite for maintaining invoice, receipt, and customer information

Platform: Red Hat Enterprise Linux 4.8 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: Oracle E-Business Suite 11i (11.5.10.2) - Receivables (AR) core standard module.


- Customers, by interface- Invoices, by interface- Customer remittance payment, by interface- Service/late charges- Std and custom reports

Primary users are Accounting, Real Estate, and Maritime staff.

Oracle E-Business Suite (EBS)Subsystem Fixed Assets

Module of Oracle E-Business Suite for capital asset accounting and depreciation accounting

Platform: Red Hat Enterprise Linux 4.8 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: Oracle E-Business Suite 11i (11.5.10.2) - Fixed Assets (FA) core standard module.


Reporting of capital assets and calculation of depreciation.

Primary users are Accounting and IT staff.






PORT BothOracle E-Business Suite (EBS)Subsystem Enterprise Asset Management (eAM)

Module of Oracle E-Business Suite for asset and work order management

Platform: Red Hat Enterprise Linux 4.8 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: Oracle E-Business Suite 11i (11.5.10.2) - Enterprise Asset Management (eAM) related core standard modules (e.g. WIP, BOM, Work Requests, Work Orders, Preventive Maint Work Orders, DBI, Workflow, etc.).


Supports automated, condition-based maintenance strategies for Port facilities, properties, and public access infrastructure. Integrates physical and financial aspects of capital assets; work order and asset management.

Primary users are enterprise wide (not just the Maintenance division).






PORT Operational

PORT Operational

Custom Oracle PayrollSubsystem Time Entry

Tracks employee time (e.g. time off, time worked on a work task) by pay period

Platform: Red Hat Enterprise Linux 4.8 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: Oracle E-Business Suite 11i (11.5.10.2) - Payroll, Time Entry, and Labor Distribution related custom module and associated custom code.

Data stored in Oracle RDBMS 10gR2 backend-tier database.

Oracle iAS 10g / Portal front-tier application (with Oracle Forms & Reports 10g, SSO, OID, etc).---------------Proprietary custom module and associated custom code designed, developed, implemented, and configured by external consultants and Port IS Business Apps staff to meet Port of SF business process and data rqmts.

Positive time entry for all work hours by pay period, employee, work date, work task, and paycode.

Primary users are Payroll staff.

Custom Oracle eAM Time-Entry

Tracks Maintenance employee time (e.g. time off, time worked on a work task) by week

Platform: Red Hat Enterprise Linux 4.8 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: Oracle E-Business Suite 11i (11.5.10.2) - Time Entry and Work Order management related custom java, jDeveloper OAF, PL/SQL, UNIX shell scripts, etc. code.

Data stored in Oracle RDBMS 10gR2 backend-tier database.---------------Proprietary custom code designed, developed, implemented, and configured by external consultants and Port IS Business Apps staff to meet Port of SF business process and data rqmts.

Positive time entry for all work hours by week, employee, work date, eAM work task, and paycode. The data is summarized at the WMS work task level and keyed into Oracle Custom Payroll (Time Entry)

Primary users are Maintenance shop supervisors.






PORT PROPworks (AirIT) Both

PORT Operational

Manages and tracks Port properties, customers, agreements, leases, vessel activities, sales, billing, and invoicing.

Platform: Red Hat Enterprise Linux 6.4 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: AirIT / PROPworks 7.4.3 enterprise application.

Red Hat JBoss 4.2.1 middle-tier application server.

Jaspersoft JasperReport Server 5.5.

Data stored in Oracle RDBMS 11gR2 database.---------------Developed by vendor (AirIT Inc.) & configured by external consultants and Port IS Business Apps staff to meet Port of SF business process and data rqmts.

Manages and tracks Port properties, customers, agreements, leases, vessel activities, sales, billing, invoicing, and associated revenue information.

Primary users are Real Estate, Maritime, and Accounting staff.

Accela Land Management (Accela--externally hosted)Subsystem/Module 1) Land Mgmt 2) Citizen Access 3)Electronic Document Review (EDR is in process)

Manages and tracks Port-issued building permits.

Platform: Accela web-based application (with multi-tenant middle-tier application server and associated backed-tier Oracle RDBMS being remotely hosted in Salt Lake City, UT by Accela).---------------Software: Accela 7.3.---------------Developed by vendor (Accela Inc.) & configured by external consultants and Port IS Business Apps staff to meet Port of SF business process and data rqmts.

Manages and tracks issuance of Port building permits, including support of associated regulatory and administrative functions..

Primary users are Engineering, Real Estate, and Accounting staff.






PORT Capital planning Financial

PORT Financial

Facilities Renewal Resource Model (FRRM)/Capital planning/Pacific Partners Consulting Group (GSA)

Platform: Facilities Renewal Resource Model (FRRM) web-based application (with multi-tenant middle-tier application server and associated backed-tier database server being remotely hosted by Pacific Partners Consulting Group / Sightlines, LLC with oversight by CCSF GSA).---------------Software: FRRM & CIPAce version 6.---------------Developed by vendor (Pacific Partners Condulting Group / Sightlines, LLC) & configured by external consultants and Port IS Business Apps staff to meet Port of SF business process and data rqmts.

Tool to predict the annual funding required to keep facilities in a state of good repair; intended to be the basis for determining how much funding will be allocated for facility renewal.

Oracle E-Business Suite (EBS)Subsystem Project Costing and Project Management (awaiting future configuration/deployment)

Modules of Oracle E-Business Suite for project and portfolio management

Platform: Red Hat Enterprise Linux 4.8 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: Oracle E-Business Suite 11i (11.5.10.2) - Project Costing & Project Management core standard modules.

Data stored in Oracle RDBMS 10gR2 backend-tier database.---------------Developed by vendor (Oracle Corp.) & soon to be configured by Port IS Business Apps staff and external consultants to meet Port of SF business process and data rqmts.

Will allow project managers to plan the work, assign resources, forecast to completion, and communicate to stakeholders

Primary users - TBD






PORT OperationalCustom Oracle Work Management System (WMS)

Custom-built Oracle application to record job costs for each work order/work task that relates to a project

Platform: Red Hat Enterprise Linux 4.8 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: Oracle E-Business Suite 11i (11.5.10.2) - Work Order Management System (WMS) custom module and associated custom code.


Oracle iAS 10g / Portal front-tier application (with Oracle Forms & Reports 10g, SSO, OID, etc).---------------Proprietary custom module and associated custom code designed, developed, implemented, and configured by external consultants and Port IS Business Apps staff to meet Port of SF business process and data rqmts.

Accounting and reporting for direct cost of jobs and projects at facilities and by funding source. Also used for accumulation of indirect costs.

Primary users are Accounting staff.






PORT Distributes payroll costs BothCustom Oracle PayrollSubsystem Pay Labor

Platform: Red Hat Enterprise Linux 4.8 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: Oracle E-Business Suite 11i (11.5.10.2) - Payroll Labor and Work Order management related custom java, PL/SQL, UNIX shell scripts, etc. code.


Oracle iAS 10g / Portal front-tier application (with Oracle Forms & Reports 10g, SSO, OID, etc).---------------Proprietary custom code designed, developed, implemented, and configured by Port IS Business Apps staff to meet Port of SF business process and data rqmts.

Stores pay labor costs tied to each time entry record; creates General Ledger journal entries at work order level; provides labor cost information for reporting.

Primary users are IT, Accounting, Finance, and Budget staff.






PORT Both

PORT Both

Oracle E-Business Suite (EBS)Subsystem General Ledger

Module of Oracle E-Business Suite for automated financial processing, maintaining internal controls, and financial statements/reporting

Platform: Red Hat Enterprise Linux 4.8 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: Oracle E-Business Suite 11i (11.5.10.2) - General Ledger (GL) core standard module.


General Ledger ("GL") is the core of enterprise financial accounting and reporting system. Major financial accounts (like Accounts Receivable and Accounts Payable) are supported by details in subsidiary systems.

The GL code ("accounting flexfield") is comprised of multiple segments, embedding organization cost center, work order, and place code that capture direct and indirect costs, necessary attributes to support financial and management reporting and details required for internal cost accounting (i.e. by work and by facility).

Cross validation for financial coding used by any supported financial module/subsystem.

Primary users are Accounting staff, Budget analysts, and Financial analysts.

Oracle E-Business Suite (EBS)Subsystem iProcurement

Module of Oracle E-Business Suite for self-service purchase requisition processing

Platform: Red Hat Enterprise Linux 4.8 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: Oracle E-Business Suite 11i (11.5.10.2) - iProcurement core standard module.


Purchase requisition processing/management.

Primary users are Business Services/Purchasing staff.






PORT Operational

PUC Goldmine Contact Management Operational Being retiredPUC Active Risk Manager Active Risk Manager Both

PUC ACES Both

PUC Creditron National Cash Register Check Image Financial Check payment processing

PUC EXIGIS rmCompliance-Vendor Insurance System Operational Hosted, vendor system, browser based.

PUC Capital Projects Management Dashboard Financial

Oracle E-Business Suite (EBS)Subsystem Supply Chain & Order Mgmt. Intelligence

Module of Oracle E-Business Suite for assessment of inventory levels, product fulfillment, order backlogs, etc.

Platform: Red Hat Enterprise Linux 4.8 VM hosts running on VMware, Cisco UCS, and NetApp appliances (multi-tier env).---------------Software: Oracle E-Business Suite 11i (11.5.10.2) - Supply Chain & Order Management Intelligence / Daily Business Intelligence (DBI) core standard module.


Provides Oracle E-Business Suite daily business intelligence (DBI) reports.

Primary users are Maintenance Planner, Shop Supervisor, and Management staff.

SharePoint 3.0 based desktop, SQL Server DB, 10 users.

Risk Reporting and risk cost analysis. This is mainly used by the risk analyst and risk manager to determine the amount of money a project may need if any of the given risks occur in a project. The cost impacts are created with the CM teams and inserted into the software to determine cost outcomes.

Power Scheduling Software

Being retired. We do not know what the new system is yet.

Power scheduling and intraday water scheduling. Primary users are preschedulers and powerhouse operators

Windows server based, vendor system, 10 users

Primary users: INF - Contract Administration / Real Estate ServicesPurpose: Automated workflow of vendor/broker compliance with contractual insurance requirements

Oracle Primavera Portfolio Manager (OPPM)

Vendor system, Oracle, Windows server based, 60 users.

Capital Requests and High-level Capital Planning






PUC CCAMS Cross Connection Backflow Device Tracking Operational

PUC TimeLive Infrastructure time system Financial

PUC Financial

PUC Distributed Control System Operational Not financial.

PUC Agile Fleet Commander Fleet Management Operational Not financial.PUC EJWard Gasoline Consumption Tracking Operational Not financial.PUC Form 11 HHWP Operations Summary Operational Not financial.PUC GoSolarSF Special Projects - Power (in house developed) Operational Not financial.PUC Itron MV90 Large Electric Meter Monitoring Operational Not financial.PUC Iform iPad RIM Fire assessments/photo software Operational Not financial.PUC Conserve Track Water Conservation Software Operational Not financial.PUC InfoRAD Paging System Dispatch/Pager Notification System Operational Not financial.PUC Energy Accounting Energy Use Monitoring Operational Not financial.PUC Energy/CAP Enterprise Energy Efficiency Tracking Tool Operational Not financial.PUC Operational Not financial.

PUC Operational Not financial.

PUC Knowledge Management Wiki Operational Not financial.

PUC Currents (Intranet) Operational Not financial.

PUC eDNA/IPP by InStep Operational Not financial.

Web based system hosted offsite. 700 users.

Web based application will allow certifided backflow assembly testers to submit their test reports online. This will elliminate the need for WQD staff to scan, enter data, file and archive 23K backflow test reports annually.

Windows based, vendor system, 50 users.

Timelive is an electronic timekeeping system being used to capture consultants' billable hours for SFPUC Professional Service Contracts. The primary users are consultant staff who enters their own time.

eTime (In-house developed)

PUC on-line time entry system. Per Ken data is maintained in an Oracle database, and there is an Approval process within the system. The data is extracted and feeds eMerge. It carries Index Code, and Dept info. The interface file is used by eMerge Payroll subsystem to calculate pay checks.

Cold Fusion, In house developed, 2300 users.

Time reporting with the goal of feeding payroll

Foxboro Infusion by Invensys

311 Dashboard - Cognos based

SLA Metrics for Customer Resolution of 311 calls

Aclara Star Automated Water Meter System

Collection of Water Consumption, It is transmitted to PUC 4 times a day to track water usage. The data feeds the Customer Card and Billing System

Confluence Wiki/mIToolbox

SFPUC Intranet (in house developed). Per Ken it is a reporting system

SCADA Historian (Per Ken, it is a data warehouse system)






PUC Enterprise Process Center Enterprise Process Center (Interfacing) Operational Not financial.PUC Interloc Ipad Mobile online/offline software for Maximo Operational Not financial.PUC Record's Management / Work Flow Operational Not financial.

PUC GIS (ESRI - ArcGIS) Geographic Information System Operational Not financial.PUC Operational Not financial.

PUC Maintenance Management System Both

PUC Customer Information and Billing Both

PUC Yardi Real Estate Billing Billing for Land Leases Financial Billing, Analysis, Reporting

PUC Construction Project Management (CMIS) Financial Being retired.

PUC Online Invoice System (custom developed) Financial

PUC Financial

PUC Utility Star Utilities Billing system Both

PUC Laboratory Information Management System Both

Hummingbird (eDocs) & Integic ePower

Interactive Voice Response / Call Manager

CSB Interactive Voice Response and Call Manager System

Maximo 7 (IBM) Linux based Oracle DB and app servers, 900 users. Vendor system.

MAXIMO is the PUC’s asset management system. MAXIMO is used by PUC’s Water, Wastewater and Hetch Hetchy divisions to manage and maintain its assets, through its work order, preventative maintenance, purchasing and inventory modules.

Customer Care & Billing (Oracle)

App and Oracle DB run on Linux, vendor system, highly customized, 120 users.

Billing and collection of water and sewer services

Web based system hosted by the vendor SAAS.

Primavera (Contract Management)

Log all documentation between the construction contractor and the City

Solis-Construction In house developed, web based front end, Windows server, several hunderd users.

SOLIS stands for San Francisco Online Invoicing System, and it is an invoicing system for Construction, and Professional Services contracts. Version 2 will incorporate Contract Certification and Task Orders

Primavera P6 Integration with eTime

So people in the PUC can work on a project using eTime to enter hours and the hours are sent to P6.

Oracle DB running on Linux, Windows servr based application, vendor system.

Used for project controls and in reporting. Primary users are Project Managers and Project Control Engineers

Windows server based, SQL Svr DB, vendor system, 20 users.

Currently, billing and collection of power services. Future upgrade, billing and collection of water, sewer, power, gas, steam, and gas services.

StarLIMS Laboratory Information System

App and Oracle DB run on Windows servers, vendor system, browser based, 60 users.

Database program used to track samples, upload analytical data, prepare final reports and EDDs, invoice clients, provide management reports on lab production, etc. Primarily used by WQD laboratory and field services staff.






PUC Budget System Financial

REG EIMS (DFM) Operational

REG EIMS (DFM) Operational

PUC's Budgeting Tool (in house developed). Dept enters their budget info into the PUC Web based Budget/Cognos System. The data is then downloaded into an Access DB which feeds Controller's Cognos System. Once the Budget is approved, an extract of the approved budget is generated and sent to PUC to refresh the PUC Budget database, and the budget cycle starts. PUC runs extracts from Controller Cognos to verify data in PUC and Controller Systems are in synch 1. Once the budget is finally approved by the Board of Supervisors (early August), we interface the budget for all departments from the central budget system into FAMIS.2. At the same time, we send PUC a file that they load into their Access database which they use to publish a final budget book used by their managers.3. Next (Sept/Oct) PUC rolls-over its Web and Access based budget system, and its managers begin using the web based portion to submit budget requests for review by PUC budget staff.4. We roll-over the central budget system (Sept-Nov) and create the base budget for the whole city.5. We send PUC a file which contains the base budget for PUC (Dec/Jan) that they load into their Access database 6. PUC uses Access to compare the requests from their departmental budget process with the base budget they loaded from the central system and create a file of the changes. This file of changes is loaded as an interface into the central budget system to be their department request. Most departments enter their request on-line in the central budget system.7. PUC makes corrections through the on-line central budget system until their request is complete (by March 1).8. From after the interface of their changes until the budget is finalized by the Board of Supervisors PUC runs central budget system reports to know how to adjust the data in their system and keep it in synch with the central

Browser based, custom/in-house developed, Windows servers, 140 users.

It maintains the budget requests entered by the PUC Depts

The system maintains Poll Workers Payment information and status.

Developed and suported by a vendor (DFM Associates). Windows based with MS SQL backend.

Elections management, database of voters, districts, poll workers, polling places. Elections staff are primary users.

The system maintains payment information fo rPolling Places

Developed and suported by a vendor (DFM Associates). Windows based with MS SQL backend.

Elections management, database of voters, districts, poll workers, polling places. Elections staff are primary users.






REG Both Excel

REG Both Excel

REG Track expeditures of the department. Both Excel

Salary & Benefits Spending Plan

The system tracks the departments spending in Ch. 1 & Ch. 13.

The system projects staffing costs based on staffing plans. It then tracks the actual spend by pay period for several different sub-objects.

Non-Personnel Spending Plan

The system tracks the scheduled expeditures of the department and provides a year end surplus or deficit amount based on the budget.

The system tracks the scheduled expeditures of the department and provides a year end surplus or deficit amount based on the budget.

Materials & Supplies Spreadsheet

The system tracks the departments expeditures item by item. It also allows the department to add level's of detail to each expediture such as: Election or Office use, assigning costs to specific elections, cost factors if expeditures are only partially attributed to Election use.






RET FinancialPension Administration System

Pension Administration System is a PeopleSoft system and it consists of 3 modules; Payroll, Pension and HR.

The primary purpose of the Pension Admin System is to • maintain Retirement Payroll data for all City employees (active employees, retirees, survivors of retirees, and employees who no longer works for the City but has made pension contributions)• calculate monthly Retirement payments due to the City’s retirees• generate retirement payment checks and ACH transfers of direct deposit payments

The Pension Administration System also generates data extracts and reports for the auditors, State and Federal agencies, including the IRS, and the State Controller.

Payments will not be issued for any amount which exceeds the annual pension payment limit imposed by IRS Code 415(b). The “Excess Benefit” payments exceeding the 415(b) limit are paid by the Employer from the General Fund. not SFERS. This net amount is interfaced to FAMIS shown in GL1518. Payments are processed as EFT. Excess Limits are reported as taxable income form W2,941,DE9 and DE9C. Taxes are filed by SFERS. Tax deposits are processed by the Controller’s PPSD Tax Unit.

Daily, Bank of America sends an interface file (File #12 BofA Cleared Checks and Deposits) to the City and County of San Francisco to post to FAMIS. This file contains a list of the deposits received and the SF City & County checks, including the pension checks, which had been cleared by the bank since the last business day. The Controller's Office sends a copy of the interface file #12 to Retirement to record the pension checks which had been cleared in their Pension Administration System. The

The Pension Administration System is a PeopleSoft client-server system which was implemented in 2000.

The Retirement inhouse IT staff supports and maintains the system

Users of the system have the capability to generate adhoc queries and reports

There are approximately 90 users of Pension Admin System, and approximately 4500 pension checks are issued per month.

Capture EE/ER payroll contribution to Retirement system and to pay promised benefits to eligible members.






RET Provides same services for SFUSD, SFCCD,. Financial and Operational System,

SFGH both FoxPro database

SFGH proprietary vendor Reporting and Analysis

Pension Administration System

The Pension Administration System is a PeopleSoft client-server system which was implemented in 2000.

The Retirement in-house IT staff supports and maintains the system

Users of the system has the capability to generate adhoc queries and reports

There are approximately 90 users of Pension Admin System, and approximately 4500 pension checks are issued per month.

SFGH Payroll/Labor database

The SFGH Labor database maintains employee information, pay classification, pay type, and benefit information. It is a FoxPro database, created and maintained by SFGH staff

used for Labor Reporting for Management, analysis, reimbursements and adhoc reporting.

Genisys - a hospital budget and re-imbursement system is being replaced with Organiziation Intelligence System for Financial and Operational Reporting and Cost Accounting

Genisys maintains year-to-date expenditure information (downloaded from FAMIS). and is being replaced with a new system called Organizational Intelligence. Orgainization Intelligence will maintain a web-based Management Financial and Operating (units of service) Reporting System and cost accounting system that can be conigured based on Management Structure and reporting relationships. Will include Labor and non labor financial budgets and actualsas well as dept units of service and cost accounting. Actuals will come from FAMIS EIS reports,

both - this system is being replaced with a new system called Organizational Intelligence Finance Reporting and Cost Accounting System






Financial Vendor developed

Financial Vendor developed

SHF SIRON Both Web-based

TTX Both

SFGH, LHH

Invision, a patient management system

Invision is the Patient Management System and is used by LHH and SFGH to maintain charges and payments collected for services performed for the patients. Invision consists of a front-end system and a back-end system. Invision Patient Management system is the front-end system, and Invision Patient Accounting (PA) is the back-end system.

The front-end system, Invision Patient Management system, captures the patient demographic information which are entered during patient registration.

The back-end system, Patients Accounting (PA), maintains the financial data, including the charges for the services performed, payments received, adjustments, and when billing occurs. In the back-end system there is a Revenue Master (RM) file which interfaces with the PA system and maintains payments by in-patients, and out-patients type.

Invision system maintains all patient charges information, billings and payments.

SFGH, LHH

PMM - Purchasing and Inventory Control System

PMM (Purchasing and Inventory Control System) is the material and supply system for SFGH and LHH. It maintains requisitions, purchase orders, charges and payments for medical supplies, while FAMIS Purchasing is the purchasing system for non-medical items.

PMM maintains requisitions, purchase orders, charges and payments for medical supplies to support LHH and SFGH

Records and tracks Civil actions and associated financial transactions.

Maintain finacial records and documents related to Civil actions.

Wausau Remittance and Cashiering System

Remittance and cashiering system with an enterprise content management solution for all the transactions including defined workflows.

Integrated Windows based system for remittance, cashiering, archival and workflow.

Processing payments received by the Treasurer and Tax Collector's Office for various fees, taxes and licenses owed to the City and County of San Francisco.






TTX Both

TTX Business Tax Both

Treasurer WorkStation System

The Treasury Work Station System maintains bank and investment related activities, including:• Wire and ACH Deposits; • Wire Payments, • Zero Balance Account transfers; and• Investment (buy and sell) transactions.

Input from Carmen: The purpose of posting the Journal entries generated by Treasury's Work Station is to record certain bank daily transactions, including the wire transfer and investment payments and receipts (bank GL1050), and zero balance transfers to and from the City's concentration accounts (bank GL 1149/ GL 1609 and other bank GLs)

The Treasurer WorkStation was developed by SunGard and customized for the Treasury Office. It is maintained jointly by the vendor, Sungard and the Treasury Office staff. It is a server based system with a SQL database. There are approximately 10 users and the system processes 100-150 transactions daily.

Analysis of Cash Balances and transactions, Automated Posting to FAMIS thru an interface, and Reporting. Primary users are: 1654 Bing Situ, 1634 Andrew Ong, and 1657 Arnold Mallari and 1824s Oksana Kuzmina and Eric Gatchalian for the bank account maintenance module.

The Business Tax System maintains the Business Tax Cert Number and Expiration Date information of companies who do business in SF. The companies include both City vendors and businesses like hotels which pay business tax but are not City vendors (do not do business with the City).

The purpose of this interface file is to update the new Business Tax Expiration Date in FAMIS after an existing vendor has renewed. For new vendors, after they are certified the Business Tax staff manually enters the Business Tax Cert # and the Expiration Date in the Vendor Class Status file in FAMIS.

The Business Tax System was originally developed by the City IT staff, and it was converted to a HP Unix Oracle based system 9-10 years ago. There are approximately 50+ users of the system from various City departments. These departments, including the Department of Inspection, DPW, etc access the system to query on the business tax status of their vendors.

The Tax Collector’s Business Tax System is used to access and collect business taxes, business registration fees, paaking taxes, hotel taxes and utility taxes.

document.xlsx Data Warehouse (EIS) 84 of 85 RFP# CON2014-18

Data Warehouse Software Environment

Vendor Product Description VersionVMWare ESXI All servers are now running under VMWare 4.1

Microsoft Windows Server Primary Server OS (64 bit); some servers have 32 bit version: we use IIS 7.5 2008 R2Oracle Database with partitioning option 11GInformatica Power Center Extract, Transform & Load (ETL) 9.1.0IBM Cognos Enterprise Planning Budget Entry 10.1.1

Microsoft On public web server for public facing applications

Microsoft Active Directory AuthenticationIBM Cognos Access Manager Authentication (to be retired by December, 2014) 7v3

IBM Cognos Business Intelligence 10.2.1

Data Warehouse Hardware Environment

Prod Non-Prod Type Function Applications Server Name CPUs CPU Type OS Special Requirements / Notes

Outside FirewallProd Web/App OpenBook CON-PUBLIC 2 40 200

Prod Database OpenBook Public DB Server CON-PUBLIC-DB 1 40 200

Inside FirewallProd Non-Prod Type Function Applications Server Name CPUs CPU Type OS Special Requirements / Notes

Prod Web/App FAMIS FAMIS Web CTL-FAMISWEB 1 40 200

Prod Test App Access Manager EIS-CTL-04SVR 1 Reg/32bit 100

Prod Test Web CON-EIS-VM001 1 70 Need IIS enabled (completed 12/12)

SQL Server, Visual Studio

Metric Studio used for Performance Measurement (PM) EntryReport & Query studio used for PM, Budget, Accounting & Purchasing reportingWorkspace Advanced used for OLAP reporting

ServerC Drive

SAN

Drives

Public Web Server Xeon3.07 GHz

W2K8 R2SP1 / 64bit

SFOpenBook and other public facing applications; was Xeon 2.67 GHz

Xeon3.07 GHz

W2K8 R2SP1 / 64bit

ServerC Drive

SAN

DrivesXeon

2.67 GHzW2K8 R2SP1 / 64bit

EISBudget

Perf Meas

Xeon2.67 GHz

Temporay "P2V" VM server until Access Manager migration to Active Directory (retirement planned by Dec 2014); old physical server in process of retirement as of 7/2014

EISBudget

Perf Meas

BI / Planning Gateway (10.1.1 32bit version)BI Gateway: Prod (10.2.1 64bit version)BI Gateway: Dev (10.2.1 64bit version)

Xeon2.67 GHz

W2K8 R2SP1 / 64bit

document.xlsx Data Warehouse (EIS) 85 of 85 RFP# CON2014-18

Prod App EIS CON-EIS-VM002 2 70 200

Prod Test/Dev App/FTP CON-EIS-VM003 2 70 300 D: 200 E: 100

Prod App CON-EIS-VM004 2 70 200

Prod App Budget Planning Job Server (v10.1.1 32bit) CON-EIS-VM005 4 70

Prod App Budget Planning Job Server (v10.1.1 32bit) CON-EIS-VM006 4 70

Prod Dev App CON-EIS-VM007 1 70

Dev App/Web EIS CON-EIS-VM008 1 70

Prod App BI App: Prod (10.2.1 64bit) CON-EIS-VM009 1 70 50 Content Store, Primary Dispatcher

Test/Dev/Train App Budget CON-EIS-VM010 1 70 100 Manually reconfigured for env

Prod Dev App Budget CON-EIS-VM011 2 70 200

Prod Database Database CON-EIS-VM012 4 90 1950

Test/Dev/Train Database Database CON-EIS-VM013 4 90 1450

App EIS 4 70 To be retired by 12/2014 or earlier.

BI App: Prod (v10.1.1 64bit)BI Mobile (v10.1.1 64bit)E-mail client (ex. Sendmail)BI App: Prod (v10.2.1 64bit) - 2nd Dispatcher

Xeon2.67 GHz

W2K8 R2SP1 / 64bit

High Priorty, use current SMTP Servers;Secondary BI Dispatcher

EISBudget

Perf Meas

ETL (Informatica v9 64bit)FTP server (FTPS, SFTP)E-mail client (ex. Sendmail)

Xeon2.67 GHz

W2K8 R2SP1 / 64bit

BudgetPerf Meas

Metric App Server (v10.1.1 32bit)Planning App Server (v10.1.1 32 bit)Remote Desktop Licensing Server

Xeon2.67 GHz

W2K8 R2SP1 / 64bit

Xeon2.67 GHz

W2K8 R2SP1 / 64bit

Xeon2.67 GHz

W2K8 R2SP1 / 64bit

EISPerf Meas

Framework Manager client (32bit)Metric Designer client (32bit)

Xeon2.67 GHz

Win ServerStd SP2 / 32bit

BI App: Dev (v10.1.1 64bit)BI App: Dev (v10.2.1 64bit)

Xeon2.67 GHz

W2K8 R2SP1 / 64bit

Need IIS enabledRequires separate install directories, ports and dispatchers

BudgetPerf Meas

Xeon2.67 GHz

W2K8 R2SP1 / 64bit

Planning Job Server (v10.1.0 32bit);DEV TM1

Xeon2.67 GHz

W2K8 R2SP1 / 64bit

Transformer: Prod (10.2.1) x2Transformer: Dev (10.2.1)

Xeon2.67 GHz

W2K8 R2SP1 / 64bit Manually reconfigured for env

EISBudget

Perf Meas

Xeon2.67 GHz

W2K8 R2SP1 / 64bit

EISBudget

Perf Meas

Xeon2.67 GHz

W2K8 R2SP1 / 64bit

To be retired by 12/2014

PowerPlay Enterprise Server (Prod)Planning App Server (v10.1.1 32 bit) (Train)To Be Retired

CON-EIS-VM014 aka eis.app.bi.sfgov.org

Xeon2.67 GHz

W2K8 R2SP1 / 64bit

VM ESXI 4.1 environment uses CISCO UCS B200M1 blades with 2 socket of Nehalem Xeon 5550 2.666 GHZ Quard Core CPU 8 member of threads