Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

EOL - RS - App H - System Interfaces 2010-03-15 by runout

VIEWS: 11 PAGES: 8

									                                           EOL Interfaces, Version 2.6
                                                Dated 3-15-2010
                                                                                                                                                                             Reference to
                                                                                                               (inbound,                                                       Separate
                                                                                                               outbound)                           e.g. flat file, XML       Specification
                                                                                                                                  Frequency /
                                                                                                              Direction of         Timing of          Method of                                       Validations and Error
    Name         ID                     Description                        FDB   RHB   DW   MW   LFS   L&C     Interface           Interface          Interface             Dataset Layout                  Checking                                     Comments

                               Accounting Interfaces

                        The new RPS will be a check scanner and server
                        to capture check information and make the
                        check data available for Accounting processes.

                        The EOL system must interface with RPS, the
                        Department’s Remittance Processing System in
                        order to receive data on payments submitted via                                                                                                                                                                  The new RPS will be hosted at OTech and
                        paper check.                                                                                                                                                                                                     include an application server and an SQL
                                                                                                                                                                                                                                         Server database. The new RPS will consist of: 2
NEW                     Inbound payments to CDPH Accounting include a                                                                                                                                                                    Check Scanners (Canon CR-180II or equal);
Remittance              remittance stub from the renewal letters with a                                                                                                                                                                  Checkmation SOAR Server – CMS 100-00;
                        scan line. The scan line is scanned into RPS to                                                                                                                                                                  Checkmation Remittance Processing – CMS
Processing
                        attach the identifying information to the                                                                                                                                                                        100-RP; Laserfiche Avante Server for MS SQL
System (RPS) -          payment. The information is then transmitted                                                                                                                                                                     with Workflow; Laserfiche Named Full User
Accounting       IR-1   back to EOL                                         Y     Y    Y    Y     Y     Y           TBD                 TBD                TBD                      TBD                            TBD                   with Snapshot and Email.



                        Receive credit card payments from the
                        Department's Credit Card provider(s) (MC, VISA,
                        AMEX, and/or Discover)
                                                                                                                                                                                                                                         CPDH will establish separate contract(s) with a
                        CDPH has not made a final decision on which                                                                                                                                                                      processor(s) for handling credit card payments.
                        vendor to use to process credit card payments,                                                                                                                                                                   It is anticipated that the CC processor will
                        but support for this interface is required.                                                                                                                                                                      accept payments through a co-brand web
                                                                                                                                                                                                                                         interface. Payments will go straight to CC
                        EOL must interface with the processor to receive                                                                                                                                                                 processor from the web.
                        information on successful payment transactions.
                        The payment information must be used to                                                                                                                                    Errors entering CC information will   The system must record the payment
                        update each license account, as well as                                                                   Daily M-F                                                        be handled interactively through      acknowledgement/failure, transaction number
Credit Card             transmitting the payment information to CDPH                                                              including bank                                                   the co-branded processor's            and date/time of credit card transaction
Processor(s)     IR-2   Accounting.                                         Y     Y    Y    Y     Y     Y           TBD           holidays                 TBD                      TBD            website.                              (received from credit card processor(s))..

                        CalSTARS is the State's Accounting System. The                                                                                                                                                                   The system must generate files for
                        EOL system must provide information on                                               OUT: FTP Upload to                    OUT: Fixed length flat   Example upload files                                         transmission to CalSTARS describing the
CalSTARS         IR-3   payments received and refunds to be generated.      Y     Y    Y    Y     Y     Y         CalStars              Daily               file                included            See Examples and Specifications      payments received and the payment coding.




                                                                                                                                                                                                                                                                           Page 1 of 8
                                            EOL Interfaces, Version 2.6
                                                 Dated 3-15-2010
                                                                                                                                                                                       Reference to
                                                                                                                 (inbound,                                                               Separate
                                                                                                                 outbound)                                e.g. flat file, XML          Specification
                                                                                                                                     Frequency /
                                                                                                                Direction of          Timing of               Method of                                Validations and Error
     Name          ID                     Description                      FDB   RHB   DW   MW   LFS   L&C       Interface            Interface               Interface               Dataset Layout         Checking                         Comments

                                 Accounting Interfaces
                                                                                                                                                                                                                               The State Treasurer's Office (STO) is working
                                                                                                                                                                                                                               on an eCheck program that may be available in
                                                                                                                                                                                                                               the future.

                                                                                                                                                                                                                               The system must interface with (pass through
                                                                                                                                                                                                                               to) the Department’s eCheck processor in
                                                                                                                                                                                                                               order to process ACH credits and debits when
                          EOL must interface with an eCheck processor in                                                                                                                                                       an external user chooses to pay by eCheck.
                          order to process ACH payments .
                                                                                                                                                                                                                               The system must record the payment
eCheck
                          CDPH has not made a final decision on which                                                                                                                                                          acknowledgement/failure, transaction
processor (ACH            vendor to use to process eCheck payments, but                                                                                                                                                        number, and date/time of eCheck transaction
Credit / Debits)   IR-4   support for this interface is required.           Y     Y    Y    Y     Y     Y             TBD                   TBD                     TBD                     TBD                 TBD            (received from eCheck processor).



             Interfaces Across Multiple Program Areas
                                                                                                                                     Inquiries to the
                                                                                                                                     SQL server are
                          Currently, some programs allow licensees to                                                                real time but the    OUT: Extract from HAL
                          download copies of their license from the CDPH                                     OUT: Certificate        replication to the   in to flat file FTP'ed to
                          Website. This feature will also be required in                                     download, replicating   SQL server is        CDPH server for upload
CDPH Website       IR-5   EOL.                                                    Y               Y     Y    data to SQL Server      daily                into SQL server                   TBD                 TBD            May be dependent on the proposed solution.




                                                                                                                                                                                                                                                                Page 2 of 8
                                       EOL Interfaces, Version 2.6
                                            Dated 3-15-2010
                                                                                                                                                                                Reference to
                                                                                                              (inbound,                                                           Separate
                                                                                                              outbound)                          e.g. flat file, XML            Specification
                                                                                                                              Frequency /
                                                                                                             Direction of      Timing of             Method of                                              Validations and Error
    Name    ID                      Description                         FDB   RHB   DW   MW   LFS   L&C       Interface        Interface             Interface                Dataset Layout                      Checking                                       Comments

                           Accounting Interfaces
                                                                                                                                                                                                       OUT:
                                                                                                                                                                                                       1) The JCL script writes to a log file
                                                                                                                                                                                                       on the mainframe capturing any
                                                                                                                                                                                                       errors from file generation or from
                                                                                                                                                                                                       transmitting the files. The log file is
                                                                                                                                                                                                       manually checked by ITSD-DGU.
                                                                                                                                                                                                       2) After processing the daily batch
                                                                                                                                                                                                       of files, EDD generates an email
                                                                                                                                                  OUT: Multiple fixed                                  that has the count of files
                                                                                                                              OUT: Variable       length, tilde delimited                              processed. DGU manually validates
                                                                                                                              numbers of files flat files sent passive                                 this against the file count from the
                                                                                                                              generated at        FTP with SSL encryption                              log.
                                                                                                                              different times ----------------------------                             ---------------------------------
                                                                                                                              depending upon IN: 2 PDF Files - 1                                       IN:                                       This is a new process. ITSD is converting most
                                                                                                                              the type of forms containing printed                                     1) Polling attempts for the PDF files     of the HAL forms over to the EDD format. Until
                                                                                                                              accumulated for images of print jobs                                     is written to a log file. DGU             that is complete the old print process is still
                   Currently, some programs use the Employment                                                                a single daily      (i.e., the licenses                                  manually validates the PDFs are           being used also. There are approximately 90
                   Development Department (EDD) as a print                                                                    transmission        generated), 1 file is a  OUT: Each form type has a retrieved.                                  forms to convert and the conversion process is
                   service. EDD receives license data from HAL,                                                               ------------------- work order for the job different layout and there    2) The work order PDF has a count         lengthy. ITSD believes the conversion of all the
                   prints the licenses, and mails the licenses to the                                                         IN: Polling is      (i.e., how many items are up to 90 forms             of print jobs processed that is           forms will be complete before EOL is released.
                   licensee.                                                                              OUT: Print Jobs     daily; 2 PDFs are were processed). Both --------------------------       manually checked by DGU against
                                                                                                          -------------       retrieved daily     files are retrieved via  IN: 1st PDF contains images the number in the email, and the          Note that EOL will interface with EDD, but it is
EDD Print          The EOL system will be required to interface to                                        IN: Images, Work    from the EDD        passive FTP with SSL     of print jobs, 2nd PDF is a number of files written by the JCL        not expected that EDD will perform all of the
Process     IR-6   EDD to continue this process.                               Y               Y     Y    Order               FTP server          encryption.              work order for the job      script.                                   printing for EOL.



                   ASPEN (Automated Survey Processing
                   Environment) is a suite of software products
                   used by the federal government.

                   EOL will interface to the ASPEN database for the
                   download of certified facilities’ profile                                                                                     IN: Nightly batch                                                                               The profile information is entered into ASPEN
                   information (as example, the federal assigned                                                                                 process performs ETL                                                                            by CDPH staff and currently ELMS references
                   provider number, the accreditation status, the                                         IN: Database to                        on data from ASPEN to                                                                           ASPEN data for any surveys/complaint related
ASPEN       IR-7   number of certified beds, etc.)                                             Y     Y    database transfer        Nightly       ELMS                                  TBD                               TBD                     data. EOL will replace the ELMS system.




                                                                                                                                                                                                                                                                                    Page 3 of 8
                                         EOL Interfaces, Version 2.6
                                              Dated 3-15-2010
                                                                                                                                                                                     Reference to
                                                                                                                 (inbound,                                                             Separate
                                                                                                                 outbound)                             e.g. flat file, XML           Specification
                                                                                                                                      Frequency /
                                                                                                                Direction of           Timing of           Method of                                           Validations and Error
    Name      ID                      Description                          FDB   RHB   DW   MW   LFS   L&C       Interface             Interface           Interface               Dataset Layout                    Checking                          Comments

                            Accounting Interfaces

                                                                                                                                                                                                                                       All facilities compliance inspection (survey)
                                                                                                                                                                                                                                       findings are captured in ACO. (Compliance
                                                                                                                                                                                                                                       inspections include surveys conducted by L&C
                                                                                                                                                                                                                                       on the federal government’s behalf as well as
                                                                                                                                                                                                                                       required by State laws).

                                                                                                                                                                                                                                       ELMS reference the survey events and
                     ACO is the ASPEN Central Office application.                                            IN: File download from                                                                                                    complaints/entity reported incidents
                                                                                                             ASPEN ACO into MS                                                                                                         information from ASPEN when a State
                     EOL will interface with ASPEN ACO for facility                                          Excel spreadsheet and                                                                                                     enforcement penalty is issued. EOL will replace
ASPEN ACO    IR-8    compliance inspection (survey) findings.                                     Y     Y    merged into ELMS              Nightly     IN: Manual Process                  TBD                              TBD        the ELMS system.

                                                                                                                                                                                                                                       All complaints (submitted by consumers or
                                                                                                                                                                                                                                       general public on a facility) or entity reported
                                                                                                                                                                                                                                       incidents (submitted by the facility’s
                                                                                                                                                                                                                                       personnel) are captured in ACTS.

                                                                                                                                                                                                                                       ELMS reference the survey events and
                     ACTS is the ASPEN Complaint Tracking System.                                            IN: File download from                                                                                                    complaints/entity reported incidents
                                                                                                             ASPEN ACTS into MS                                                                                                        information from ASPEN when a State
                     EOL will interface with ASPEN ACTS to obtain                                            Excel spreadsheet and                                                                                                     enforcement penalty is issued. EOL will replace
ASPEN ACTS   IR-9    complaint and incident information.                                          Y     Y    merged into ELMS              Nightly     IN: Manual Process                  TBD                              TBD        the ELMS system.

                     BARR print process. This is the older print
                     process for licenses and some correspondence.
                     The EDD print interface is replacing some of this
                     functionality. EOL will interface with this process                                                                                                                                                               BARR is a print queuing system that currently
BARR Print           for those forms and correspondence not handled                                                                   Real time        OUT: Flat file in UDK   UDK format varies for each                              interfaces to HAL. EOL will replace the HAL
Interface    IR-10   by EDD.                                                      Y               Y     Y    OUT: Print job           (internal)       format                  of the types of forms        See specifications         system.



                                                                                                                                      DOJ sends daily
                                                                                                                                      at 12:00 Noon.
                                                                                                                                      At 6:00 AM the
                                                                                                                                      next morning the
DOJ
                                                                                                                                      file is uploaded
Background           EOL will interface with DOJ to obtain background                                                                 into HAL via JCL
Checks       IR-11   check information on applicants and licensees.                               Y     Y    IN: File upload          script           IN: FTP                 Flat File                    See specifications

                                                                                                                                                                                                                                                                           Page 4 of 8
                                             EOL Interfaces, Version 2.6
                                                  Dated 3-15-2010
                                                                                                                                                                                                      Reference to
                                                                                                                           (inbound,                                                                    Separate
                                                                                                                           outbound)                                  e.g. flat file, XML             Specification
                                                                                                                                                   Frequency /
                                                                                                                         Direction of               Timing of             Method of                                      Validations and Error
     Name         ID                      Description                         FDB   RHB    DW    MW       LFS   L&C       Interface                 Interface             Interface                 Dataset Layout             Checking                                   Comments

                                 Accounting Interfaces
                                                                                                                                                   Daily file comes
                                                                                                                      IN: Poll Tumbleweed          from EMSA at       IN: FTP flat file (pull in
                                                                                                                      server for file, (FTP pull   7:00 AM, file      by a JCL script)
                                                                                                                      process)                     polled from        OUT: FTP modified flat
                         EOL will interface with EMSA to process requests                                             OUT: FTP result file to      Tumbleweed         file out (pushed by JCL
EMSA queries     IR-12   for volunteer certificate information.                      Y                     Y     Y    Tumbleweed server            after 7:00 daily   script)                    See specifications   See specifications



                                Food and Drug Branch


                         There is currently a project underway to
                         transform Access Data into a format that can be                                                                     Manually
                         downloaded to FDA (using eSAF SSI). Java Code                                                                       initiated or
                         was provided by FDA for the interface so FDA can                                             OUT: SSI manually or scheduled (not in
                         download information                                                                         through scheduler gets used yet).                                                                                                     1) eSAF=Electronic Access to State Field
                                                                                                                      data from the target   Anticipated to be OUT: Pulled from SSI                                   Log files are generated by SSI (see   Accomplishments and Compliance Tracking
Export to FDA            EOL will interface to the FDA system to share                                                state database (ODBC a monthly           through ODBC directly                                  specification), and errors are        System
system           IR-13   compliance information.                                          FDB Interface               for Access)            download.         from tables                      See specification     manually corrected.                   2) SSI=State Interface System to eSAF

                         For STAKE, Listing of convenience stores and
                         other locations selling cigarettes including their
Inventory data           addresses, used to setup sting operations, levy                                                                                              Manual download of
from BOE         IR-14   fines and send names to County                                   FDB Interface               IN: Manual                   Every 6 months     Excel File                         See Sample                    NA                   NA




                                                                                                                                                                      OUT: Data fields
                                                                                                                                                                      defined by the forms
                                                                                                                                                                      provided from FDB
                         FDB has their own internal printing capability. If                                                                                           need to be pulled from
Printing of
                         EOL does not replace printing functionality they                                             OUT: Generate forms                             EOL, merged into the
forms and                will need support for the interface to continue to                                           from data fields pulled As needed (real         forms and unloaded
certificates     IR-15   provide print functionality                                      FDB Interface               from EOL                time)                   onto FDB print queues. Defined by Forms         Manually correct any errors.




                                                                                                                                                                                                                                                                                           Page 5 of 8
                                             EOL Interfaces, Version 2.6
                                                  Dated 3-15-2010
                                                                                                                                                                                           Reference to
                                                                                                                           (inbound,                                                         Separate
                                                                                                                           outbound)                         e.g. flat file, XML           Specification
                                                                                                                                               Frequency /
                                                                                                                          Direction of          Timing of        Method of                                    Validations and Error
    Name          ID                      Description                          FDB   RHB    DW    MW       LFS   L&C       Interface            Interface        Interface               Dataset Layout             Checking                                   Comments

                             Accounting Interfaces
                          Licensing and Certification
                                                                                                                                                             1) Query comes from
                                                                                                                                                             IVR containing
                                                                                                                                                             licensee's SSN
                                                                                                                                                             2) Licensing
                                                                                                                                                             information and
                                                                                                                                                             automated registry
                                                                                                                                                             verification is returned
                                                                                                                                                             real-time from the
                                                                                                                                                             process on the HAL
                                                                                                                                                             mainframe that
                                                                                                                       IN: CICS process is                   performed the SSN
                                                                                                                       triggered on the                      NATURAL query against
                                                                                                                       mainframe when an                     the HAL database.
                                                                                                                       SSN is received from                  AT&T has a screen
                                                                                                                       the IVR                               scraper program
                                                                                                                       OUT: Results of the                   picking up the
                         EOL must interface in real-time to the L&C AT&T                                               query are returned to                 NATURAL program
                         Interactive Voice Response (IVR) to support caller                                            the IVR system by the                 output (dumb terminal
                         inquiries on background check status, update                                                  same process on                       output) to return to the                      Failed SSN lookup returns a "record The AT&T IVR currently interfaces with HAL.
L&C IVR system   IR-16   addresses, license status, etc.                                   L&C Interface               mainframe               Real time     IVR.                     See Specification    not found" message within the IVR. EOL will replace the HAL system.

                         The HCFIS (Health Facilities Consumer
                         Information System) is an Internet application
                         that allows the general public and health services
                         consumers to search for licensed nursing homes
                         and hospital information. There is currently an
                         export of facility information (profile, ownership,
                         complaints, inspection findings and deficiencies)
                         from ELMS.

                         EOL will export the nursing home and hospital                                                                                                                                                                         Currently, the data is provided to HCFIS from
HFCIS            IR-17   information for use by HCFIS.                                     L&C Interface               OUT: Export to file.        Weekly      FTP Pull from ELMS                 TBD                     TBD                  ELMS. EOL will replace the ELMS system.



                            Laboratory Field Services


                                                                                                                                                                                                                                                                                 Page 6 of 8
                                      EOL Interfaces, Version 2.6
                                           Dated 3-15-2010
                                                                                                                                                                           Reference to
                                                                                                                   (inbound,                                                 Separate
                                                                                                                   outbound)                        e.g. flat file, XML    Specification
                                                                                                                                      Frequency /
                                                                                                                  Direction of         Timing of        Method of                          Validations and Error
    Name    ID                     Description                         FDB   RHB   DW     MW       LFS   L&C       Interface           Interface        Interface         Dataset Layout         Checking                         Comments

                          Accounting Interfaces
                                                                                                                                                                                                                   The existing RPS scanners are manufactured by
                                                                                                                                                                                                                   ‘American Microsystems’ and use a laser pen.

                                                                                                                                                                                                                   UPC is used to code the scan line. The barcode
                                                                                                                                                                                                                   is used to retrieve a record and then update
                                                                                                                                                                                                                   that record with payment amounts that are
                   LFS use bar code scanners to scan in remittance                                                                                                                                                 on the record. Fees charged are used to
                   letter scan lines when the Remittance Processing                                                                                                                                                update fees received. There is a program run
Barcode            System (RPS) in accounting fails to properly read                                           IN: File output from                 1) Program run to                                              to update HAL when a file is received from
Scanners   IR-18   the scan line on the letter.                                    LFS Interface               bar code scanners      Daily         upload into HAL             TBD                 TBD            Accounting.



                      Radiologic Health Branch
                             No interfaces specific to RHB.



           Environmental Management Branch
                            No interfaces specific to EMB.




                                                                                                                                                                                                                                                     Page 7 of 8
                                     EOL Interfaces, Version 2.6
                                          Dated 3-15-2010
                                                                                                                                                                            Reference to
                                                                                                                (inbound,                                                     Separate
                                                                                                                outbound)                           e.g. flat file, XML     Specification
                                                                                                                                      Frequency /
                                                                                                               Direction of            Timing of        Method of                           Validations and Error
   Name    ID                      Description                        FDB   RHB   DW   MW       LFS   L&C       Interface              Interface        Interface          Dataset Layout         Checking                        Comments

                         Accounting Interfaces
                            Drinking Water
                                                                                                                                                    OUT: Prefer XML
                                                                                                                                                    containing contact
                  DDWEM Enterprise level information,                                                       OUT: EOL will generate                  updates written to
                  reconciliation and reporting structure is running                                         a flat file or XML file                 common storage space
                  in SharePoint/SQL. It attempts to collate data                                            containing contact                      or FTP
                  elements held in                                                                          updates
                  various applications for an enterprise wide view                                                                                  IN: Prefer XML
                  of reporting.                                                                             IN: MARS will send                      containing licensing
                                                                                                            inventory updates                       inventory updates
                  EOL will interface with MARS to update contact                                            from MARS by flat file                  written to common                                               MARS stands for Management and Accounting
MARS      IR-19   information, and to receive inventory updates.              DDWEM Interface               or XML                       Daily      storage space or FTP         TBD                 TBD            Reporting System.




                                                                                                                                                                                                                                                  Page 8 of 8

								
To top