Docstoc

Data_Input_Exchange

Document Sample
Data_Input_Exchange Powered By Docstoc
					                 Data Input
                 &Exchange




Guido Szamocki                Workshop with ROSPATENT
                              20-22 May 2010
    EPO data Input

•   Paper filings
•   Online filings
•   Search files
•   Published patent data
•   Secondary data
    EPO data Input

•   Paper filings - applications, subseq. docs
•   Online filings - applications, subseq. docs
•   Search files - PCT (ISA, IPEA), national
•   Published patent data - 80 countries!
•   Secondary data - EP files & published patents
EPO data Input

                           OCR

                 IMAGE


 Paper

                 BIBLIO


 Online

                 TEXT
                             patent
                          information
                        Data Exchange




WOxy requests
WOxy results
translation requests
  translation results
PHOENIX Components


  Databases


  Interfaces



   Services




   Clients
PHOENIX Databases


 • Two Databases    DMS     PXI

 • DMS
   – Dossier Management System

 • PXI
   – Image Archive
   – TIFFS mainly but also BLOBs
     TPH083_DCSATTR                                  TPH017_DOCSET                                                                           TPH015_DOCLIST
PK,U1   DSAKEY                                      PK   DCSKEY                                                                           PK,U2,U1    DLSKEY

        DSAATTRIBUTE                                     DCSXX0                                                                                     DLSXX0
        DSAVALUE                                         DCSXX1                                                                                     DLSXX1
                                                                                                                                                                                                                                                                                                                                                                                                                                                                TPH054_STATSCR
        DSADESC                                     U1   DCSPHXNAME                                                                       FK1,I1,U2 DLSDCSKEY                                                                                            TPH082_VERSDOC                                        TPH081_SUBGROUP                                                                           TPH055_SSGROUP                                                                                                TPH056_SSCRITEM
                                                                                                                                                                                                      TPH014_DOCUMENT
        DSAMOD                                           DCSMOD                                                                           I2,U1     DLSMEMKEY                                                                                                                                                                                                                                                                                                PK,U1    SSCKEY
FK1     DCSKEY                                                                                                                                      DLSMOD                                    PK,FK1      DCTKEY                                 PK,U1     VDCKEY                                         PK,FK1      PRCKEY                                                                        PK,FK1    PRCKEY                                                                                                PK,U1     SSIKEY
                                                                                                                                          FK2       MEMKEY                                    PK,U1,U3,U2 DOCKEY                                                                                          PK,U1       PSGKEY                                                                        PK,U1     SSGKEY                                                   SSCXX0
                                                                                                                                                                                                                                                           VDCXX0                                                                                                                                                                                                      SSCXX1                                                 SSIXX0
                                                                                                                                                                                                          DOCXX0                                           VDCXX1                                                     PSGXX0                                                                                  SSGXX0                                         FK1,I1,U1 SSCSSGKEY                                              SSIXX1
                                                                                                                                                                                                          DOCXX1                                 FK1,U1,I1 VDCFOLKEY                                                  PSGXX1                                                                                  SSGXX1                                         U2        SSCPHXNAME                                   FK1,I1,U1 SSISSCKEY
                                                                                                                                                                                              I2,U3       DOCPARKEY                                        VDCPXI                                         U2          PSGNAME                                                                       U2        SSGPHXNAME                                               SSCINDTYPE                                             SSISEQNUM
                                                                                                                                                                                              U1,I3       DOCPCKKEY                                        VDCDATEFORMAL                                              PSGSEQNUMBER                                                                            SSGMOD                                                   SSCSEQNUM                                              SSIDATABLOCK
                                                                                                                                                                                                          DOCPAGES                                         VDCARCHIVE                                                 PSGMOD                                                                                                                                           SSCFILENAME                                            SSIMOD
                                                                                                                                                                                                          DOCINDPUBLIC                                     VDCALTARCHIVE                                                                                                                                                                                               SSCMOD
                                                                                                                                                                                                          DOCPCKSEQNUMBER                                  VDCCODE                                                                                                                                                                                           FK1       PRCKEY
                                                                                                                                                                                                          DOCUSER                                          VDCPAGES
 TPH032_OVLLAYOUT                                                                                                                                                                                         DOCINDSTATUS                                     VDCINDPUBLIC
                                                  TPH031_OVERLAY
                                                                                                                                                                                                          DOCFLAGDEL                                       VDCPCKSEQNUMBER
PK    OLLKEY                                                                                                                                             TPH016_DOCNOTE
                                          PK,FK1      OLLKEY                                  TPH018_DCSITEM                                                                                              DOCPCKOFFSET                                     VDCUSER
                                          PK,U2,U1    OVLKEY                                                                                                                                              DOCFLAGINDEX                                     VDCINDSTATUS
      OLLXX0                                                                                                                                           PK,U1    DNTKEY
                                                                                         PK,FK2     DCTKEY                                                                                                DOCINDPUBA                                       VDCFLAGDEL
      OLLXX1                                                                             PK,U2,U1   DSIKEY                                                                                                                                                                                                                                                                                                                                                                                                                          TPH008_CHKITEM
                                                      OVLXX0                                                                                                                                              DOCINDPUBB                                       VDCPCKOFFSET                                                                                                                                                                                     TPH011_CHKTYPE
U1    OLLPHXNAME                                                                                                                                                 DNTXX0
                                                      OVLXX1                                                                                                                                              DOCDATEPUBA                                      VDCFLAGINDEX                                                                                                                                                                                                                                                        PK,U1      CITKEY



                                                                                                                                                                                                                                                  Document
      OLLINDTYPE                                                                                                                                                 DNTXX1                                                                                                                                                                                                                                                                                PK,FK1   PRCKEY
                                          I2,U1       OVLFRMKEY                                     DSIXX0                                                                                                DOCDATEPUBB                                      VDCINDPUBA
      OLLFONTDATA                                                                                                                                      FK1,I1,U1 DNTDOCKEY                                                                                                                                                                                                                                                                             PK,U1    CTYKEY
                                                      OVLINDPAGE                                    DSIXX1                                                                                                DOCFLAGMODEL                                     VDCINDPUBB                                                                                                                                                                                                                                                                     CITXX0
      OLLSOURCENAME                                                                                                                                              DNTTEXT128
                                                      OVLXVALUE                          FK1,U2     DSIDCSKEY                                                                                             DOCMODELSEQNUM                                   VDCDATEPUBA                                                                                                                                                                                                                                                                    CITXX1
      OLLTEXT128                                                                                                                                                 DNTINDTYPE                                                                                                                                                                                                                                                                                     CTYXX0
                                                      OVLYVALUE                          U1         DSIDCTKEY                                                                                             DOCMODELROOM                                     VDCDATEPUBB                                                                                                                                                                                                                                                                    CITTEXTPM
      OLLMOD                                                                                                                                                     DNTMOD                                                                                                                                                                                                                                                                                         CTYXX1
                                                      OVLINDPAGETYPE                     U3         DSIDCSPHXNAME                                                                                         DOCMODELBOX                                      VDCFLAGMODEL                                                                                                                                                                                                                                                                   CITDESCSHORT
                                                                                                                                                       FK1       DCTKEY                                                                                                                                                                                                                                                                                U2       CTYPHXNAME
                                                      OVLMOD                             U3         DSIDCTCODE                                                                                            DOCCOUNTRYABBR                                   VDCMODELSEQNUM                                                                                                                                                                                                                                                                 CITPOSITION
                                          FK2         FRMKEY                                        DSIMOD                                                                                                                                                 VDCMODELROOM                                                                                                                                                                                         CTYDESCSHORT
                                                                                                                                                                                                          DOCFLAGEXTRA1                                                                                             TPH080_FOLDER                                                                                                                                                                                                         CITMOD
                                                                                                                                                                                                                                                           VDCMODELBOX                                                                                                                                                                                          CTYMOD
                                                                                                                                                                                                          DOCFLAGEXTRA2                                                                                                                                                                                                                                                                                                        FK1        PRCKEY
                                                                                                                                                                                                          DOCFLAGEXTRA3                                    VDCCOUNTRYABBR                                 PK,FK1        PRGKEY                                     TPH045_PROCEDURE                                                                                                                                            FK1        CTYKEY
                                                                                                                                                                                                          DOCFLAGEXTRA4                                    VDCFLAGEXTRA1                                  PK,U1,U2      FOLKEY
                                                                                                                                                                                                          DOCFLAGEXTRA5                                    VDCFLAGEXTRA2                                                                                      PK    PRCKEY
                                                                                                                                                                                                          DOCFLAGEXTRA6                                    VDCFLAGEXTRA3                                                FOLXX0
 TPH071_XREFDOC1                                                                                                                   TPH084_DSIATTR                                                                                                          VDCFLAGEXTRA4                                                FOLXX1                                      PRCXX0



                                                                                                                                                                                                                                                                                                                                                                                                           Procedure
                                                                                                                                                                                                          DOCFLAGEXTRA7
PK    XRDKEY                                                                                                                                                                                              DOCFLAGEXTRA8                                    VDCFLAGEXTRA5                                  U3,U2         FOLPSGKEY                                   PRCXX1
                                                                                                                               PK,U1      DIAKEY
                                                                                                                                                                                                          DOCFRMIDCODE                                     VDCFLAGEXTRA6                                                FOLFLAGCLOSED                         U1    PRCPHXNAME
      XRDXX0                                                                                                                                                                                              DOCFRMLANG                                       VDCFLAGEXTRA7                                                FOLSEQNUMBER                                PRCDATASERVER
                                                                                                                               FK1,I1,U1 DIADSIKEY                                                                                                                                                                                                                                                                                                                                                   TPH009_CHKCOMM
      XRDXX1                                    TPH021_FORM                                                                                                                                               DOCINDWIPO                                       VDCFLAGEXTRA8                                                FOLMOD                                      PRCDESCSHORT
                                                                                                                                         DIAATTRIBUTE
U1    XRDID                                                                                                                                                                                               DOCDATEWIPO                                      VDCFRMIDCODE                                   FK2           PRCKEY                                      PRCCOVERFLAGS
                                                                                                                                         DIAVALUE                                                                                                                                                                                                                                                                                                                                              PK,U1      CCMKEY
U1    XRDCONTENT                          PK,U1      FRMKEY                                                                                                                                               DOCREFTYPE                                       VDCFRMLANG                                     FK2           PSGKEY                                      PRCFLAGDUPLICATE
                                                                                                                                         DIADESC
      XRDFLAGONLINE                                                                                                                                                                                       DOCREFID                                         VDCINDWIPO                                                                                               PRCFLAGMULTPARTY                                                    TPH010_CHKVALUE
                                                                                                                                         DIAMOD                                                                                                                                                                                                                                                                                                                                                          CCMXX0
      XRDCREATED                                     FRMXX0                                                                                                                                               DOCMOD                                           VDCDATEWIPO                                                                                              PRCMOD
                                                                                                                               FK1       DCTKEY                                                                                                                                                                                                                                                                                                                                                          CCMXX1
      XRDMODIFIED                                    FRMXX1                                                                                                                                   FK2         PARKEY                                           VDCREFTYPE                                                                                                                                                                 PK,U2,U1   CVAKEY
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               FK1,I1,U1 CCMCVAKEY
      XRDFLAGREAD                         FK1,U1     FRMDCTKEY                             TPH013_DOCCTL                                                                                                                                                   VDCREFID
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         CCMCOMMENT
      XRDFLAGCREATE                       U2         FRMIDCODE                                                                                                                                                                                             VDCMOD                                                                                                                                                                               CVAXX0
                                                                                 PK,U4,U3,U2 DCTKEY                                                                                                                                                                                                                                                                                                                                                                                                      CCMMOD
      XRDFLAGUPDATE                       U2         FRMLANG                                                                                                                                                                                     FK1       PRGKEY                                                                                                                                                                               CVAXX1
      XRDFLAGDELETE                                  FRMORIGIN                                                                                                                                                                                                                                                                                                                                                                        FK1,I1,U2 CVACITKEY
      XRDNUMBER                                      FRMMOD                                       DCTXX0                                                                                                                                                                                                                                                                                                                              U1,I2     CVADOSKEY
      XRDMOD                                                                                      DCTXX1                                                                                                                                                                                                                                                                                                                                        CVAUSER
                                                                                 FK1,U2           DCTALGKEY                                                                                                                                                                                                                                                                                                                                     CVADATE
                                                                                 U3               DCTPRCKEY                                                                                                                                                                                                                                                                                                                                     CVAFLAGSET
                                                                                 U4               DCTORGKEY                                                                                                                                                                                                                                                                                                                                     CVAMOD
                                                                                 U1               DCTCODE                                                                                                                                                                                                                                                                                                                             FK2       DOSKEY                             TPH040_PAPTYPE
                                                                                                  DCTDESCEN
                                                                                                  DCTDESCFR                                                                                                                                                                                                                                                                                                                                                                PK      PTYKEY
                                                                                                  DCTDESCDE                                                                                                                                                                                                                                                                                                                                                                                                                   TPH024_INFOSHEET                                     TPH025_INFOITEM
                                           TPH012_COMMENT                                         DCTINDPUB                                                                                                                                                                                                                                                                                                                                                                        PTYXX0
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   PTYXX1                                   PK,U1         INFKEY                             PK,U1         IITKEY
     TPH070_XREFCOMP1                                                                             DCTFLAGMSG
                                     PK,U1         COMKEY                                         DCTINDPUBLIC                                                                                                                                                                                                                                                                            TPH038_PAPITEM                                                                   U1      PTYPHXNAME
PK,U1    XRCKEY                                                                                                                                                                                                                                                                                                                                                                                                                                                                    PTYDESCSHORT                                       INFXX0                                           IITXX0
                                                                                                  DCTINDSOURCE                                                                                                                                                                                                                                                                     PK,FK3      DCTKEY
                                               COMXX0                                                                                                                                                                                                                                                                                                                                                                                                                              PTYDATE                                            INFXX1                                           IITXX1
                                                                                                  DCTFLAGCOVER                                                                                                                                                                                                                                                                     PK,U1,U3,U2 PITKEY
         XRCXX0                                COMXX1                                                                                                                                                                                                                                                                                                                                                                                                                              PTYPRINTER                               FK1,I1,U1 INFPTYKEY                              FK1,I1,U1 IITINFKEY
                                                                                                  DCTFLAGANNEX
         XRCXX1                      FK1,I1,U1 COMDCTKEY                                                                                                                                                                                                                                                                                                                                                                                                                           PTYFLAGDOUBLE                                      INFPHXNAME                                       IITSEQNUM
                                                                                                  DCTURGENCY                                                                                                                    TPH041_PARTY                                                                                                                                                    PITXX0
U1,I1    XRCXRDKEY                             COMPROCNAME                                                                                                                                                                                                                                                                                                                                                                                                                         PTYFLAGOVERLAY                                     INFMOD                                           IITHTMLDATA
                                                                                                  DCTFLAGFINALIDX                                                                                                                                                                               TPH002_ALGO                                                                                     PITXX1
U2       XRCID                                 COMUNITNAME                                        DCTINDREGISTER                                                                                                        PK,U1       PARKEY                                                                                                                                                                                                                                         PTYFLAGINFO                                                                                         IITMOD
         XRCPXI                                COMDATEFROM                                                                                                                                                                                                                                 PK   ALGKEY                                                                             U3           PITPRCKEY                                                                          PTYFLAGTOC
                                                                                                  DCTFLAGRETRIEVE                                                                                                                                                                                                                                                                  U1           PITPTYKEY
         XRCMIME                               COMCOMMENT                                         DCTPMUSE                                                                                                                        PARXX0                                                                                                                                                                                                                                           PTYFLAGDOCSHEET
         XRCLENGTH                             COMMOD                                                                                                                                                                                                                                           ALGXX0                                                                                          PITFLAGPRINT                                                                       PTYFLAGDOCUMENTS
                                                                                                  DCTFLAGSUPPRESS                                                                                                                 PARXX1
         XRCCREATED                                                                                                                                                                                                                                                                             ALGXX1                                                                                          PITPRINTORDER                                                                      PTYFLAGSTAPLE
                                                                                                  DCTINDSUBLOGIC                                                                                                        FK1,I1,U1 PARPRGKEY
         XRCMODIFIED                                                                                                                                                                                                                                                                       U1   ALGMODNAME                                                                                      PITINDFIRSTPAGE                                                                    PTYFLAGGUI
                                                                                                  DCTWASPID                                          TPH044_PROCGROUP                                                             PARSEQNUM
         XRCFLAGONLINE                                                                                                                                                                                                                                                                          ALGDESCSHORT                                                                                    PITMOD                                                                             PTYMOD
                                                                                                  DCTMOD                                                                                                                          PARFULLNAME
         XRCINDSTATUS                                                                                                                         PK,U2,U1   PRGKEY                                                                                                                                 ALGMOD                                                                             FK1          PTYKEY
                                                                                 FK2              ORGKEY                                                                                                                          PARMOD
         XRCMOD                                                                                                                                                                                                                                                                                                                                                                    FK2          PRCKEY
                                                                                 FK3              PRCKEY
FK1      XRDKEY                                                                                                                                         PRGXX0
                                                                                                                                                        PRGXX1
                                                                                                                                              FK1,I1,U2 PRGPRCKEY                                                                                                                                                                                                                                                                                                                                                                   TPH042_PHXFUN                                 TPH047_PROITEM
                                                                                                                                              I2,U1     PRGDOSKEY
                                                TPH005_BOX                                                                                              PRGPHXNAME                                                                                                                                                                                                                                                                                                                                                             PK    PHFKEY                                  PK,FK1        PHFKEY
                                                                                                                                                        PRGSEQNUM                                                                                                                                                                                                                                                                                                                 TPH039_PAPERFILE                                                                           PK,U2,U1      PRIKEY
                                     PK      BOXKEY                                                                                                     PRGFLAGDEFAULT                                                                                                                                                                                                                                                  TPH057_TEAM                                                                                                  PHFXX0
                                                                                                                                                        PRGFLAGOPEN                                                                                                                                                                                                                                                                                                         PK,U2,U1        PAPKEY                                   PHFXX1                                                PRIXX0
 TPH022_GLOBAL1                                                                                                                                                                                                                                                                                                                                                                                                PK,U1     ORGKEY
                                             BOXXX0                                                                                                     PRGMOD                                                                                                                                                                                                                                                                                                                                                                 U1    PHFPHXFUNCTION                                        PRIXX1
PK    GLBKEY                                 BOXXX1                                                                                           FK2       DOSKEY                                                                                                                                                                                                                                                                                                                        PAPXX0                                         PHFDESCSHORT                            U1            PRIPROKEY
                                             BOXROOM                                                                                                                                                                                                                                                                                                                                                                     ORGXX0                                                       PAPXX1                                         PHFMOD                                                PRIFLAGUSE
                                     U1      BOXSEQNUM                                                                                                                                                                                                                                                                                                                                                                   ORGXX1                                             FK1,I1,U2 PAPPTYKEY
      GLBXX0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               PRIMOD
                                     U1      BOXDATE                                                                                                                                                                                                                                                                                                                                                           FK1,U1    ORGALGKEY                                          U1,I2     PAPORGKEY
      GLBXX1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 FK2           PROKEY
                                             BOXDATEEXTERNAL                                                                                                                                                                                                                                                                                                                                                             ORGUNITNAME                                                  PAPPHXNAME
U1    GLBIDXNAME
                                             BOXLOCATION                                                                                                                                                                                                                      TPH035_PACKAGE                                                                                                                             ORGLOCATION                                                  PAPMOD
U1    GLBIDXSUB
                                             BOXDATEDELETED                                                                                                                                                                                                                                                                      TPH037_PCKSTAT                                  TPH007_CDR                    U3        ORGUNITID                                          FK2       ORGKEY
      GLBPARVALUE                                                                                   TPH004_BATCH                                                                                                                                                PK,U2,U1,U8,U7,U6,U5,U4 PCKKEY
                                             BOXDATERECEIVED                                                                                                                                                                                                                                                                                                                                                   U2        ORGMBXID
      GLBMOD                                                                                                                                                                                                                                                    PK,FK5                  TRLKEY                                 PK   PSTKEY                                  PK   CDRKEY
                                             BOXBUILDING                                   PK,U2      BCHKEY                                                                                                                                                                                                                                                                                                             ORGERRMBXID
                                                                                                                                                                                                                                                                PK,FK5,FK6              DOSKEY                                                                                                                           ORGFLAGOWNER
                                             BOXMOD
                                                                                                                                                                                                                                                                                                                                    PSTXX0                                       CDRXX0                                  ORGSITE
                                                                                                     BCHXX0                                                                                                                                                                           PCKXX0                                        PSTXX1                                       CDRXX1                                  ORGUNITGROUP
                                                                                                     BCHXX1                                                                                                                                                                           PCKXX1                                   U1   PSTINDSTATUS                            U1   CDRSEQNUM                               ORGDATA
                                                                                           FK1,I1,U2 BCHBOXKEY                                                                                                                                                  U5,I2                 PCKCDRKEY                                     PSTPHXNAME                              U1   CDRDATE                                 ORGMOD
     TPH059_XSYSSEQ                                                                        U1        BCHSEQNUM                                                                                                                                                  U6,I3                 PCKLCPKEY                                     PSTLIMITDAY1                                 CDRSTORE                                                                                         TPH029_MSGDATA
                                                                                                     BCHUSERINDEX                                                                                                                                               U7,I4                 PCKMSGKEY
PK    XSTKEY                                                                                                                                                                                                                                                                                                                        PSTLIMITDAY2                                 CDRINDSTATUS                                                                                                                                                                                       TPH046_PROFILE
                                                                                           U1        BCHDATE                                                                TPH034_OWNTEAM                                                                      U2,I5                 PCKPSTKEY                                                                                                                                                                            PK,U1          MDTKEY                                          TPH048_RANGE
                                                                                                                                                                                                                                                                                                                                    PSTLIMITDAY3                                 CDRTIMERECEIPT
                                                                                                     BCHFLAGGREY                                                                                                                                                U8,I6                 PCKSFTKEY                                                                                                                                                                                                                                                                                    PK     PROKEY
      XSTXX0                                                                                                                                                             PK,FK1      DOSKEY                                                                                                                                         PSTLIMITDAY4                                 CDRTIMEREJECT
                                                                                                     BCHFLAGSINGLE                                                                                                                                              U1,I7                 PCKDOSKEY                                                                                                                                                                                      MDTXX0                                           PK    RANKEY
      XSTXX1                                TPH006_BOXHIS                                                                                                                PK,U1,U2    OWTKEY                                                                                                                                         PSTMBXID                                     CDRTEXTREJECT
                                                                                                     BCHINDSTATUS                                                                                                           TPH053_SOFTBATCH                    U3                    PCKPXI                                                                                                                                                                                         MDTXX1                                                                                               PROXX0
      XSTBCHDATE                                                                                                                                                                                                                                                                                                                    PSTDESCSHORT                            U1   CDRLOCATION
                                                                                           U1        BCHLOCATION                                                                                                                                                                      PCKORIAPPNUMBER                                                                                                                                                                      FK1,I1,U1 MDTMSGKEY                                              RANXX0                                        PROXX1
      XSTBCHSEQNUM                   PK,U1          BHSKEY                                                                                                                           OWTXX0                                                                                                                                         PSTMOD                                       CDRMOD
                                                                                                     BCHFLAGDEL                                                                                                            PK    SFTKEY                                               PCKDATEFORMAL                                                                                                                                                                                  MDTTAG                                                 RANXX1                                 U1     PROPHXNAME
      XSTBOXDATE                                                                                     BCHDATEARCHIVED                                                                 OWTXX1



                                                                                                                                                                                                                                                                                                                                     Package
                                               BHSXX0                                                                                                                                                                                                                                 PCKANNOTATION                                                                                                                                                                                  MDTTHEDATA                                             RANINDTYPE                                    PRODATE
      XSTBOXSEQNUM                                                                                   BCHPCKSEQNUM                                                        U1,I2       OWTORGKEY                                   SFTXX0                                                                                                                                                                                                                                                                                                     RANTEXT24
                                               BHSXX1                                                                                                                                                                                                                                 PCKMSGTEXT                                                                                                                                                                                     MDTMOD                                                                                               PROMOD
      XSTCDRWDATE                                                                                    BCHURGENCY                                                                      OWTKIND                                     SFTXX1                                                                                                                                                                                                                                                                                               U1    RANPHXNAME
                                     FK1,I1,U1 BHSBOXKEY                                                                                                                                                                                                                              PCKMSGDOCCODE
      XSTCDRWSEQNUM                                                                                  BCHTIMEACCEPTED                                                                 OWTMOD                                U1    SFTTIME                                                                                                                                                                                                                                                                                                    RANMOD
                                               BHSROOM                                                                                                                                                                                                                                PCKPAGES
      XSTSFTDATE                                                                                     BCHTIMERETURNED                                                     FK2         ORGKEY                                U1    SFTSOURCE
                                               BHSDATE                                                                                                                                                                                                                                PCKURGENCY
      XSTSFTSEQNUM                                                                                   BCHMOD                                                                                                                      SFTMOD
                                               BHSMOD                                                                                                                                                                                                                                 PCKFLAGTRANSL                                                                                       TPH067_LEGALCOPY
      XSTVERSIONTEXT
                                                                                                                                                                                                                                                                                      PCKFLAGMSG
      XSTDATEDIS
                                                                                                                                                                                                                                                                                      PCKFLAGDEL                                                                                          PK   LCPKEY
      XSTTIMEDIS
                                                                                                                                                                                                                                                                                      PCKFLAGERROR
U1    XSTIDX
                                                                                                                                                                                                                                                                                      PCKSEQNUMBER                                                                                             LCPXX0
      XSTMOD
                                                                                                                                                                                                                                                                                      PCKBCHSEQNUMBER                                                                                          LCPXX1                                                                             TPH028_MESSAGE
                                   TPH001_ACTIONLOG                                                                                                                                                                                                                                   PCKUSERTARGET                                                                                       U2   LCPTRANID                                                                                                                                                                                              TPH027_MEMBER
                                                                                                                                                                                                                                                                                      PCKSOURCE                                                                                                LCPARCHIVE                                                                PK,U1,U2        MSGKEY
                                 PK,FK1    DOSKEY                                                                                                                              TPH003_DOSNOTE1                             TPH036_PCKHIS                                                                                                                                                                                                                                                                                             TPH049_RANGEITEM
                                                                                                                                                                                                                                                                                      PCKLOGNUMBER                                                                                        U1   LCPARCHIVEID                                                                                                                                                                                 PK,U3,U2,U1 MEMKEY
                                 PK,U1     ACTKEY                                                                                                                                                                                                                                                                                                                                                                                                                                        MSGXX0
                                                                                            TPH020_DOSLOCK                                                                 PK,U1    ANNKEY                         PK,U1        PHSKEY                                                PCKMBXTARGET                                                                                             LCPDOSTYPE                                                                                                                           PK,U2,U1   RITKEY
                                                                                                                                                                                                                                                                                      PCKINDSUBLOGIC                                                                                           LCPDOSNUMBER                                                                              MSGXX1                                                                                                          MEMXX0
TPH075_RXTABLE                             ACTXX0                                          PK,FK1    DOSKEY                                                                                                                                                                                                                                                                                                                                                              U1,I2           MSGORGKEY
                                                                                                                                                                                    ANNXX0                                   PHSXX0                                                   PCKARCHIVE                                                                                               LCPSIGNER                                                                                                                                      RITXX0                                                     MEMXX1



                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Message
                                           ACTXX1                                          PK,U1     DLKKEY                                                                                                                                                                                                                                                                                                                                                                              MSGCODE
PK    RXTKEY                                                                                                                                                                        ANNXX1                                   PHSXX1                                                   PCKALTARCHIVE                                                                                            LCPMOD                                                                                                                                         RITXX1                                        U1           MEMORGKEY
                                           ACTPHXNAME                                                                                                                                                                                                                                                                                                                                                                                                                                    MSGTEXT80
                                                                                                                                                                                    ANNUSER                        FK1,I1,U1 PHSPCKKEY                                                PCKMOD                                                                                                                                                                                                                                        FK1,I1,U2 RITRANKEY                                     U3           MEMUSRKEY
                                           ACTDATE                                                   DLKXX0                                                                                                                                                                                                                             TPH069_TRANLOG                                                                                                                                   MSGDATE
      RXTXX0                                                                                                                                                                        ANNTEXT128                               PHSTIME                            FK1                   CDRKEY                                                                                                                                                                                                                                        I2,U1     RITMEMKEY                                                  MEMTASK
                                           ACTUSER                                                   DLKXX1                                                                                                                                                                                                                                                                                                                                                                              MSGUSERCREATOR
      RXTXX1                                                                                                                                                                        ANNDATE                                  PHSORISTATUS                       FK2                   PSTKEY                                        PK,FK2      DOSKEY                                                                                                                                                                                        RITMOD                                                     MEMDATESTARTPART
                                           ACTACTION                                                 DLKUSER                                                                                                                                                                                                                                                                                                                                                                             MSGUSERTARGET
U1    RXTMNEMO                                                                                                                                                                      ANNFLAGDEL                               PHSNEWSTATUS                       FK3                   LCPKEY                                        PK,U1       TRLKEY                                                                                                                                                                              FK2       MEMKEY                                                     MEMDATEENDPART
                                           ACTMOD                                                    DLKTIME                                                                                                                                                                                                                                                                                                                                                                             MSGURGENCY
      RXTVALUE                                                                                                                                                                      ANNMOD                                   PHSUSER                            FK4                   SFTKEY                                                                                                                                                                                                                                                                                                             MEMDATESTARTABS
                                                                                                     DLKMOD                                                                                                                                                                                                                                                                                                                                                                              MSGINDSTATUS                                                                                                    MEMDATEENDABS
      RXTDESC                                                                                                                                                              FK1      DOSKEY                                   PHSMOD                                                                                                             TRLXX0
                                                                                                                                                                                                                   FK1       DOSKEY                                                                                                                                                                                                                                                      MSGMBXTARGET                                                                                                    MEMUSERDEPUTY
      RXTMOD                                                                                                                                                                                                                                                                                                                                    TRLXX1
                                                                                                                                                                                                                   FK1       TRLKEY                                                                                                                                                                                                                                                      MSGAPPTYPE                                                                                                      MEMPRESMON
                                                                                                                                                                                                                                                                                                                                    FK1,I1,U1   TRLLCPKEY                                                                                                                                                                                 TPH058_USER
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         MSGAPPNUMBER                                                                                                    MEMPRESTUE
                                                                                                                                      TPH019_DOSSIER                                                                                                                                                                                            TRLACTIONID
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         MSGPCKDATE                                  PK     USRKEY                                                       MEMPRESWED
                                                                                                                                                                                                                                                                                                                                                TRLUSER
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         MSGTEAMCREATOR                                                                                                  MEMPRESTHU
                                                                                                                                PK     DOSKEY                                                                                                                                                                                                   TRLTIME



                                                                                                                                                                                    Dossier
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         MSGMOD                                             USRXX0                                                       MEMPRESFRI
                                                                                                                                                                                                                                                                                                                                                TRLCLIENT
                                                                                                                                                                                                                                                                                                                                                                                                                                                                         FK1             ORGKEY                                             USRXX1                                                       MEMPRESSAT
                                                                                                                                       DOSXX0                                                                                                                                                                                                   TRLTEXT
TPH068_OFFICE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        U1     USRUSERID                                                    MEMMESSAGES
                                                                                                                                       DOSXX1                                                                                                                                                                                                   TRLMOD
                                                                                                                                       DOSCOVERFLAGS                                                                                                                                                                                                                                                                                                                                                                                        USRFULLNAME                                                  MEMDATEDIS
PK    OFFKEY
                                                                                                                                U1     DOSORITYPE                                                                                                                                                                                                                                                                                                                                                                                           USRMOD                                                       MEMFLAGEN
                                                                                                                                U1     DOSORINUMBER                                                                                                                                                                                                                                                                                                                                                                                                                                                      MEMFLAGDE
      OFFXX0
                                                                                                                                       DOSMOD                                                                                                                                                                                                                                                                                                                                                                                                                                                            MEMFLAGFR
      OFFXX1                   TPH060_DOSCOUNT
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         MEMFLAGBESTDG1
U1    OFFIDENT
                         PK,U1   DCNKEY                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  MEMFLAGBESTDG2
      OFFSEC1
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         MEMFLAGDEFAULT
      OFFSEC2
                                 DCNXX0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  MEMMOD
      OFFFILTER
                                 DCNXX1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     FK1          USRKEY
      OFFDESC                                                             TPH023_HISTORY
                                 DCNTYPE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    FK2          ORGKEY
      OFFMOD
                                 DCNPCKSTEM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 FK3          PROKEY
                                                                       PK,FK1   DOSKEY
                                 DCNPCKCOUNTER                         PK,U1    HISKEY                                                                                                                                                                                  TPH064_LEGATTRIB                                                                 TPH073_RXREQUEST1
                                                                                                                                                                                     TPH061_DOSKEY                      TPH065_LEGRECORD                                                                      TPH072_RXLIST1                                                                                                                                                        TPH033_OWNMEM
                                 DCNLEGALPREFIX                                                                                                                                                                                                                                                                                                                                                     TPH074_RSTATUS1
                                 DCNLEGALCOUNTER                                                                                                                                                                                                                    PK,FK1   LSVKEY                                                                  PK,FK2        RXLKEY
                                                                                HISXX0                                                                                           PK,FK2     LSVKEY                  PK,FK1      LSVKEY                                                                    PK        RXLKEY                                                                                                                                                       PK,FK2      MEMKEY
                                 DCNMODE                                                                                                                                                                                                                            PK,FK1   LRDKEY                                                                  PK,FK1        RXSKEY                           PK    RXSKEY
                                                                                HISXX1                                                                                           PK,FK2     DTYKEY                  PK,U1       LRDKEY                                                                                                                                                                                                                                           PK,FK1      DOSKEY
                                 DCNCOUNTRY                                                                              TPH063_DOSTYPE                                                                                                                             PK,U1    LATKEY                                                                  PK,U2,U1      RXRKEY
                                                                                HISTEXT64                                                                                        PK,FK1     DOSKEY                                                                                                                  RXLXX0                                                                                                                                                       PK,U2,U1    OWMKEY
                                 DCNMOD                                                                                                                                                                                         LRDXX0                                                                              RXLXX1                                                                                RXSXX0
                                                                                HISTIMESTAMP                                                                                     PK,U1,U2   DKEKEY                                                                           LATXX0                                                                                RXRXX0
                         FK1     DOSKEY                                                                             PK,FK1   LSVKEY                                                                                             LRDXX1                                                                                                                                                                    RXSXX1                                                                             OWMXX0
                                                                                HISUSER                                                                                                                                                                                                                   U1        RXLINDEX
                                                                                                                    PK,U1    DTYKEY                                                                                                                                          LATXX1                                                                                RXRXX1                           U1    RXSSTATUS
                                                                                HISCODE                                                                                                     DKEXX0                              LRDNAME                                                                             RXLMOD                                                                                                                                                                   OWMXX1
                                                                                                                                                                                                                                                                             LATNAME                                                                 I1,U2         RXRRXSKEY                              RXSDESCR                     TPH076_RXVALUE1                                                                                                  TPH043_PMSETTING
                                                                                HISMOD                                                                                                      DKEXX1                              LRDKEY1                                                                                                                                                                                                                                          I2,U1       OWMMEMKEY
JDIST_SEQ_NUMBER                                                                                                             DTYXX0                                                                                                                                          LATKEY1                                                                 I2,U1         RXRRXLKEY                              RXSTIMEOUT
                                                                                                                                                                                 U1,I2      DKEDOSKEY                           LRDKEY2                                                                                                                                                                                                                                                      OWMKIND                                                 PK,U1    PMSKEY
                                                                                                                             DTYXX1                                                                                                                                          LATKEY2                                                                               RXRDOSSIER                             RXSMOD                      PK,U1   RXVKEY
                                                                                                                                                                                 U3         DKENUMBER                           LRDREQUESTDATA                                                                                                                                                                                                                                               OWMMOD
                                                                                                                    U2       DTYTYPE                                                                                                                                         LATREQUESTDATA                                                                        RXRREF
                                                                                                                                                                                            DKEMOD                              LRDMOD                                                                                                                                                                                                                                                                                                                         PMSXX0
                                                                                                                             DTYTEXT                                                                                                                                         LATPTEXT                                                                              RXRRPI                                                                     RXVXX0
 PRIMARY_KEY                                                                                                                                                                                                                                                                 LATPTYPE                                                                              RXROUTPUT                                                                  RXVXX1                                                                                                           PMSXX1
                                                                                                                             DTYMODE
 CURRENT_VALUE                                                                                                                                                                                                                                                               LATMOD                                                                                RXRRULE                                                            I1,U1   RXVRXRKEY                                                                                              FK1,I1,U1 PMSMEMKEY
                                                                                                                             DTYCOUNTRYMASK
                                                                                                                             DTYSTEMMASK                                                                                                                                                                                                                           RXRFORMAT                                                                  RXVMNEMO                                                                                                         PMSPHXIDENT
                                                                                TPH062_DOSMASK                               DTYCOUNTER                                                                                                                                                                                                                            RXRMOD                                                                     RXVVALUE                                                                                                         PMSTEXT128
                                                                                                                             DTYLEVEL                                                                                                                                                                                                                                                                                                         RXVMOD                                              TPH051_REQDATA                                               PMSMOD
                                                                           PK,FK1   LSVKEY                                                                                                                                                                                                                                                                                                                                            FK1     RXSKEY
                                                                                                                             DTYMOD
                         JDIST_IN_PROCESS_MSGS                             PK,FK1   DTYKEY                                                                                          TPH066_LEGSERVER                                                                                                                                                                                                                                  FK1     RXRKEY                                           PK,U1   RQDKEY
                                                                           PK,U1    DMKKEY                                                                                                                                                                                                                                                                                                                                            FK1     RXLKEY
                                                                                                                                                                                    PK   LSVKEY
JDIST_IN_ERROR_MSGS                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    RQDXX0
                                                                                    DMKXX0                                                                                                                                                                                                                          TPH026_LABEL1                                    USERS                                   PROFILES                                                                                  RQDXX1                                                                                   TPH050_REQUEST
                          SEQNUMBER                                                 DMKXX1                                                                                               LSVXX0
                                                                                                                                                                                                                                          TPH030_MVSCONFIG                                                                                                                                                                                                                                             RQDSEQNUM
                          PXIDOCID                                                  DMKINPUTMASK                                                                                         LSVXX1                                                                                                                PK    LABKEY                                                                                                                                                                                                                                                             PK,U1       REQKEY
                                                                                                                                                                                    U1   LSVNAME                                                                                                                                                                                                                                                                                                       RQDTHEDATA
 SEQNUMBER                APPNUM                                                    DMKSTOREMASK                                                                                                                                          PK   CFGKEY
                                                                                                                                                                                         LSVADDRESS                                                                                                                                                                                                                                                                                                    RQDMOD
 PXIDOCID                 APPTYPE                                                   DMKMOD                                                                                                                                                                                                                           LABXX0                                        USERID                                  PROFILENAME                                                                                                                                                                            REQXX0
                                                                                                                                                                                         LSVPAR1                                                                                                                                                                                                                                                                                               FK1     REQKEY
 APPNUM                   DOCCODE                                                                                                                                                                                                              CFGXX0                                                                LABXX1                                        PASSWD                                  ITEMGROUP                                                                                                                                                                              REQXX1
 APPTYPE                  MSGTXT                                                                                                                                                         LSVPAR2                                               CFGXX1                                                          U1    LABINDSEQUENCE                                PROFILENAME                             ITEMCODE                                                                                                                                                                     FK1,I2,U1 REQRQQKEY
 DOCCODE                  MBXTARGET                                                                                                                                                      LSVMOD                                           U1   CFGTRANNAME                                                           LABTEXT32                                                                             ITEMVALUE                                                                                                                                                                              REQPHXNAME
 MSGTXT                   USERTARGET                                                                                                                                                                                                      U1   CFGPARNAME                                                            LABMOD                                                                                                                                                                                                                                                                       REQUSER
 ERRORMSG                 STATUS                                                                                                                                                                                                               CFGPARVALUE                                                                                                                                                                                                                                                                                                                                        REQMBXID
 UPDATETS                 UPDATETS                                                                                                                                                                                                             CFGMOD                                                                                                                                                                                                                                                                                                                                             REQTIME
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    TPH052_REQQUE                                                                                 REQPRIMARYDATA
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  REQREQNUM
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               PK    RQQKEY                                                                             I1        REQDOSNUM
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  REQMOD
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     RQQXX0
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     RQQXX1

                                                                                                                                                                                                                   PHOENIX DMS v8.6 Logical Database Schema                                                                                                                                                                                                                                    U1
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               U1
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     RQQQUETYPE
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     RQQQUESTATUS
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     RQQMOD
       PHOENIX Components



Databases


Interfaces



Services




 Clients
PHOENIX Services


 • A set of Java services

 • A service for each task
PHOENIX Services
                                                                                         CUPS

                                 Phoenix DBs                                            Printers                   Legacy /
                 DMS                                    PHX
                                                                                                                   Soprano




                                                                                                     JPXI

                                                                    Print



                                         Dossier                                                    Dossier
                                                                                      Dossier
                                         Content                                                   ImagePXI


             Distribution


                                                      Business
                                                      LogicDB
                                                                                                                   Legacy
                                                                                     Application
                                   Loader
                                                                                      Number

     Scriptman



                                                   Online        Online
                            Repository
                                                   Export        Import




                                                                                      Phoenix




                  Export                 Import                                                               Batch Data

                     External Applications                                  Madras                            EpoScan
       PHOENIX Components



Databases


Interfaces



Services




 Clients
PHOENIX Clients


 • MADRAS

 • Full Java
       PHOENIX Components



Databases


Interfaces



Services




 Clients
PHOENIX Interfaces


 • Legacy interface
Legacy Interface


  • Access to all Dossier information
     – Read only

  • Only way to access Procedural data

  • The Legacy Service delivers data elements
     – Date of Filing
     – Applicant details
     – Fees
     – etc.
Legacy Interface


       Legacy System                    MADRAS

                                               Status Screen




                       Legacy Service
      Text                              DREC   17.09.2001



                                        EXAM   17.09.2001 / 17.09.2001


                                        AREF   EP22195-013/kj
PHOENIX Interfaces


 • Legacy interface
 • Import interface
 Import Interface


• Load Documents only

• Document Contents
   – TIFF
   – PDF
   – PostScript         converted to TIFF via Ghostscript
   – BLOB

• Document Data
   – Dossier
   – Date                minimum but can be more
   – Code
   – Pages
PHOENIX Interfaces


 • Legacy interface
 • Import interface
 • Export interface
Export Interface

• Export documents and BLOBs only

• IPX Format

• Limited content
  – Dossier
  – Date
  – Document codes
Export Interface

• Export documents and BLOBs only

• IPX Format

• Limited content

• Export by fixed subsets

• Export by configurable "rules"

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:12/30/2011
language:
pages:23