NEC Medical Center System Operations Manual

							NDA-30026   Revision 6Page 169
Medical Center System Operations Manual - JAVA Edition PLATFORM MANAGEMENT
Create Database Option
Use the Create Database option on the MCS Platform Management Menu to create 
new database fields according to MCS instructions.
Figure 12-3   Create Database
When to UseThis option should only be used in the event of system failure or after using the Drop 
Database option. Once the new database fields are created through this option, use the 
Make Database Indexes option to identify the order in which the records in the 
database are stored. Then, if desired, consult an Informix guide to retrieve data from 
the backup tape that was made before you used the Drop Database option.
Procedure
MCS Platform Management Menu
Options
Backup Database
Create Database
Drop Database
Make Database Indexes
Erase Database Indexes
Rebuild Database Indexes
Set Menu Colors
Table Record Count
View Tty File
FLF/RCF Download to PBX
UNIX
Logout
Enter Option: [ c  ]Create MCS Database
Creating MCS database . . .
Press Enter to continue.
Action Result
On the MCS Platform Management Menu, 
type c at the prompt and press Enter. (1)The Create MCS Database screen displays 
while the database is being created. After 
the database is created, the message “Press 
Enter to continue” displays. (2)
Press Enter. The MCS Platform Management Menu 
redisplays. 
						

							Page 170NDA-30026   Revision 6
PLATFORM MANAGEMENT Medical Center System Operations Manual - JAVA Edition
Drop Database Option
Use the Drop Database option on the MCS Platform Management Menu to remove 
the entire MCS database. WARNING: Do not use this option before backing up the 
database on tape through the Backup Database option.
Figure 12-4   Drop Database
SequenceThe Drop MCS Database screen removes all data now stored in MCS, including all 
extension user assignments for patients, physicians, employees, and internal locations. 
Use the Backup Database option first to store a copy of the database on tape. Then, 
drop the database with this option, create new database fields with the Create 
Database option, identify the order of record storage with the Make Database Indexes 
option, and retrieve the stored database copy from the tape.
Procedure
MCS Platform Management Menu
Options
Backup Database
Create Database
Drop Database
Make Database Indexes
Erase Database Indexes
Rebuild Database Indexes
Set Menu Colors
Table Record Count
View Tty File
FLF/RCF Download to PBX
UNIX
Logout
Enter Option: [ d  ]Drop MCS Database
Dropping the MCS database will cause all data currently 
Are you sure (y/n):  y  
Dropping MCS Database . . .
Press Enter to continue. stored to be destroyed.
Action Result
On the MCS Platform Management Menu, 
type d at the prompt and press Enter. (1)The Drop MCS Database screen displays 
with a warning and a confirmation prompt. 
(2)
At the confirmation prompt, type y to delete 
the database or n to cancel the deletion, and 
press Enter.If the deletion is confirmed, a message 
shows when the database is being dropped. 
The message “Press Enter to continue” 
displays when you can exit the screen.
Press Enter. The MCS Platform Management Menu 
redisplays. 
						

							NDA-30026   Revision 6Page 171
Medical Center System Operations Manual - JAVA Edition PLATFORM MANAGEMENT
Make Database Indexes Option
Use the Make Database Indexes option on the MCS Platform Management Menu to 
recreate the order in which the database records are stored.
Figure 12-5   Make Database Indexes
SequenceOnce the Create Database option defines the fields of the new database according to 
MCS instructions, the Make Database Indexes option marks the fields that are to be 
used as indexes, setting the order in which records are stored and sorted during lookups. 
After you use these two options, you can re-enter data to the database or retrieve data 
from a backup tape. 
Procedure
MCS Platform Management Menu
Options
Backup Database
Create Database
Drop Database
Make Database Indexes
Erase Database Indexes
Rebuild Database Indexes
Set Menu Colors
Table Record Count
View Tty File
FLF/RCF Download to PBX
UNIX
Logout
Enter Option: [ m  ]Make MCS Database Indexes
Making MCS database indexes . . .
Press Enter to continue.
Action Result
On the MCS Platform Management Menu, 
type m at the prompt and press Enter. (1)The Make MCS Database Indexes screen 
displays while the database indexes are 
being made. After the indexes are made, the 
message “Press Enter to continue” displays. 
(2)
Press Enter. The MCS Platform Management Menu 
redisplays. 
						

							Page 172NDA-30026   Revision 6
PLATFORM MANAGEMENT Medical Center System Operations Manual - JAVA Edition
Erase Database Indexes Option
Use the Erase Database Indexes option on the MCS Platform Management Menu to 
erase the order in which the database records are stored and sorted.
Figure 12-6   Erase MCS Database Indexes
SequenceUse of this option should be rare. Any time the Indexes are erased, you need to use the 
Make Database Indexes option to re-make them.
Procedure
MCS Platform Management Menu
Options
Backup Database
Create Database
Drop Database
Make Database Indexes
Erase Database Indexes
Rebuild Database Indexes
Set Menu Colors
Table Record Count
View Tty File
FLF/RCF Download to PBX
UNIX
Logout
Enter Option: [ e  ]Erase MCS Database Indexes
Erasing MCS database indexes . . .
Press Enter to continue.
Action Result
On the MCS Platform Management Menu, 
type e at the prompt and press Enter. (1)The Erase MCS Database Indexes screen 
displays and shows that the database 
indexes are being erased. After the indexes 
are erased the message “Press Enter to 
continue” displays. (2)
Press Enter. The MCS Platform Management Menu 
redisplays. 
						

							NDA-30026   Revision 6Page 173
Medical Center System Operations Manual - JAVA Edition PLATFORM MANAGEMENT
Rebuild Database Indexes Option
Use the Rebuild Database Indexes option on the MCS Platform Management Menu 
to restructure the database indexes to improve efficiency in database access and 
searches.
Figure 12-7   Rebuild Database Indexes
When to UseThis option can be used anytime that operator lookups from the attendant screen seem 
to be taking too long, lowering operator efficiency. 
Procedure
MCS Platform Management Menu
Options
Backup Database
Create Database
Drop Database
Make Database Indexes
Erase Database Indexes
Rebuild Database Indexes
Set Menu Colors
Table Record Count
View Tty File
FLF/RCF Download to PBX
UNIX
Logout
Enter Option: [ r ]Rebuild MCS Database Indexes
Rebuilding MCS database indexes . . .
Press Enter to continue.
Action Result
On the MCS Platform Management Menu, 
type r at the prompt and press Enter. (1)The Rebuild MCS Database Indexes screen 
displays and shows that the database 
indexes are being rebuilt. After the indexes 
are rebuilt, the message “Press Enter to 
continue” displays. (2)
Press Enter. The MCS Platform Management Menu 
redisplays. 
						

							Page 174NDA-30026   Revision 6
PLATFORM MANAGEMENT Medical Center System Operations Manual - JAVA Edition
Set Menu Colors Option
Use the Set Menu Colors option on the MCS Platform Management Menu to 
reconfigure the color of all screens within the MCS.
Figure 12-8   Set Menu Colors
General 
ProcessThis option brings great versatility to the process of “coloring” the MCS screens. For 
the most part, every screen contains items, and the coloring of each item can be 
controlled according to its foreground and its background. The item foreground is 
typically the words that are displayed, such as a menu option, a prompt for data entry, 
or a column title. The background of each item is simply a space around those words 
that may or may not be visible, depending upon its color. If its color contrasts at all with 
other adjacent screen item backgrounds, it is visible; if not, it is not visible.
Samples of MCS screens are shown on the left of screen (2) in Figure 12-8 and a multi-
page list of all MCS screen items is shown to the right. Each item is listed twice: Once 
for its foreground color selection (fore) and again for its background color selection 
(back). To the right of each item, a colored square displays the currently selected and 
implemented color. When you move the cursor to an item, a row of colored squares 
displays to the right of that item with an X on the current selection. Make changes to 
the color of an item by using the arrow keys to move the X to a different color. As a 
change is made to this right-hand item list, the corresponding sample screen(s) to the 
left change(s).
MCS Platform Management Menu
Options
Backup Database
Create Database
Drop Database
Make Database Indexes
Erase Database Indexes
Rebuild Database Indexes
Set Menu Colors
Table Record Count
View Tty File
FLF/RCF Download to PBX
UNIX
Logout
Enter Option: [ s ]SCREEN SCREEN
SCREEN SAMPLE SAMPLE
#1
(Data Entry
Screen)#2
(Menu)
SAMPLE
#3
(Operator
Functions)SCREEN
SAMPLE
#4
(Pop-Up
Window)COLOR  SELECTION
Title–fore:
Title–back:
Prompt Title–fore:
Prompt Title–back:
Prompts–fore:
Prompts–back:
Inputs–fore:
Inputs–back:
Input selected–fore:
Input selected–back:
Input message–fore:
Input message–back:
Options Title–fore:
Options Title–back:
Options–fore:
Options–back:
Options message–fore:
Options message–back:
Change  Next_pg   Prev_pg   Quit(1)
(2) 
						

							NDA-30026   Revision 6Page 175
Medical Center System Operations Manual - JAVA Edition PLATFORM MANAGEMENT
Representative 
ScreensThe screens represented in Figure 12-8 are shown in more detail below with labels 
marking the items from the right-hand list for which they demonstrate color changes:
)
  
MCS               TimeTitle
Prompt Title
Inputs  (e.g., xxx)
Input selected (e.g. xxx ) Prompts   (e.g., Name, Ext.)
(Note:  Background
marked by        ***  Patient Input  ***
Name: xxx
Ext: xxx
Room: xxx
Dsch: xxx
        to accept
Input message
Screen #2 in Figure 10-8
Menu
MCS                 Time
Option selectedTitle
Option key letter
          (i.e., D, Q)
Att Status Title
              Att Status*  Main Menu  *
Operator
Database
Quit
        to selectOptions Title
Options  (Note:  Background
    marked by           .)
alr   bsy    D     OnOptions message
MCS Status Title
  MCS Status 
Trnfr  Status Title
    Trnfr Status  Call Status Title    
            Call Status
Screen #1 in Figure 10-8      Data Entry
Att   Call  Trnfr  MCS 
						

							Page 176NDA-30026   Revision 6
PLATFORM MANAGEMENT Medical Center System Operations Manual - JAVA Edition
MCS                 Time
Dest      Ext         Rm
John      3820        42
Mary      3821        27
Jeff      3822        18
Dir  Prk  Pge
Fred   3800            12
Att   Call  Trnfr  MCS
alr   bsy    D      On Src       Ext        Rm
Screen #3 in Figure 10-8
Operator Function Screen
Special Dest
Command selected
Source Title
    Source InfoDest Title
Destination
Selected Destination
Command line  (and)
Command key letter (in bold) MCS                 Time
Dest       Ext        Rm
John       3820       42
Mary       3821       27
Jeff      *3822       18
Dir    Prk   Pge
Src       Ext        Rm
Fred      3800       12
Att   Call  Trnfr   MCS
alr   bsy     D     On
(Note:  Changes made to Title, Att Status Title, Att Status, Call Status Title, Call Status, Xfer Status 
Title, Xfer Status, MCS Status Title, and MCS Status items in both foreground and background are also 
reflected on this screen.)
Screen #4 in Figure 10-8
Prompts pop up
(Message pop up =Not Shown)
Command chosenTitle pop up
Input pop up
Selected pop up
Commands pop up  (and)
Cmd key pop up  (in bold)
(Note:   Changes made to screen items on the Operator Function screen are reflected 
the pop-up window.)Msg Take
To: xxx
From: xxx
Nxt  PrvPop–Up Windows
in this screen, behind  
						

							NDA-30026   Revision 6Page 177
Medical Center System Operations Manual - JAVA Edition PLATFORM MANAGEMENT
Procedure
Action Result
On the MCS Platform Management Menu, 
type s at the prompt and press Enter. (1)The Set Menu Colors screen displays. (2)
Press Enter to select the Change 
command.Color choices display to the right of the first 
screen item under the Color Selection 
heading. The cursor and an X are positioned 
on the current color selection.
 
Use the arrow keys or space bar to move the 
cursor and the X to the color you want and 
press Enter.The screen(s) to the left on which the item 
displays shows the change in color, and the 
cursor is positioned on the next screen item 
in the Color Selection list.
Make all desired changes to the foreground 
and background of every MCS screen item, 
as described above. Use Esc to return to the 
first Color Selection page of items. Use the 
Next-pg and Prev-pg commands to move 
among the Color Selection pages of items.
When all changes are completed, type q and 
press Enter to exit the Set Menu Colors 
option.The MCS Platform Management Menu 
redisplays.
On the Administration Main Menu, type m 
at the prompt and press Enter. (1)The menu colors screen displays. (2) 
						

							Page 178NDA-30026   Revision 6
PLATFORM MANAGEMENT Medical Center System Operations Manual - JAVA Edition
Table Record Count Option
Use the Table Record Count option on the MCS Platform Management Menu to list 
the internal MCS tables and to display a count of the records each table contains.
Figure 12-9   Database Table Record Count
Procedure
MCS Platform Management Menu
Options
Backup Database
Create Database
Drop Database
Make Database Indexes
Erase Database Indexes
Rebuild Database Indexes
Set Menu Colors
Table Record Count
View Tty File
FLF/RCF Download to PBX
UNIX
Logout
Enter Option: [ t ]MCS Database Table Record Count
attendant ............  (6)
beeper ...............  (257)
.
.
did_group ..............(5)
did_number ............ (0)
.
.
employee .............. (1022)
extension ............. (1865)
.
.
patient (758)
physician ............. (246)
.
.
Total number of records (6678)(1)
(2)
Action Result
On the MCS Platform Management Menu, 
type t at the prompt and press Enter. (1)The MCS Database Table Record Count 
screen displays. (2) After the listing, a total 
number of records displays.
To exit the MCS Database Table Record 
Count screen, press Enter.The MCS Platform Management Menu 
redisplays.