Transcript Database Assembly Line - SIR Database Software

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