Database Assembly Line SIRxs

Database Assembly Line SIRxs

Connect to Columbia Server Citrix Web based application Runs SIRxs on Server

SIR or SIRXS SIRXS icon takes me to SIRXS ATC and DBs SIR icon takes me to SIR2002 ATC and DBs

ATC (Air Traffic Controller) Central Location for Connecting to a DB User and Password Authentification from Citrix See only the appropriate databases

Counting Database Central Location for DCC Database Info New Databases Registered

Export SIR2002 DB Rename Export file: JCP to JCPXS

DCC Import DB Tool Use DCC drop down from SIR session Standard DCC Tools Available to all DBs ‘Import database’ Handles Conversion to SIRXS

New SIRXS Database Extract new DB name from Export file Rename database in new Export file Remove password for SIRXS in new Export file Make database folder on the Columbia server Import file, creating SIRXS database If SYSTEM.ALLCALL exists, run it Otherwise, create new default PQL screens Call DIALOG.MAINMENU to see what you got Register database with COUNTING

New Database Fully Integrated Registered in COUNTING Connectable through Citrix and the ATC Part of the DCC backup routine Codebook created SPSS files automatically created nightly Searchable Modifiable (using DCC Restructure tool)

Other DCC Tools Codebook SPSS Files Main Menu Modify Schemas Search Functionality

Codebook All schema definitions HTML: linkable browser friendly pages

SPSS Files SPSS Files for every record type ONEJCPXS.sav for key-less records

Main Menu Generic Default Navigational Screen

Modify Schemas Automatic Restructuring

Search Functionality Seach values Search schema

The End Data Coordinating Center www.dccny.org