CRITICAL

Changes made to the RMS can significantly alter the underlying Framework ECM database. Please consult with Insula Software before making changes.

All fields in Framework ECM are grouped together by a commonality. These groups are called tables. The RMS Table screen allows for the creation, modification, and deletion of these tables.

The data availability is stored using an SQL database and, thus, the data is stored in an SQL table. A single database can house hundreds of tables, each playing its own unique role in the database schema. SQL tables are comprised of table rows and columns. Table columns are responsible for storing many different types of data, like numbers, texts, dates, and even files. There are many different types of table columns and these data types vary, depending on how the SQL table has been created by the SQL developer. A table row is a horizontal record of values that fit into each different table column.

The RMS Table screen is the physical table in the Framework ECM database.

RMS Table Dialog

This dialog is used to create an RMS table. Changes made to this area of the system will be overwritten when an upgrade is performed.

General Group

Field	Description
Primary Field	Primary field (also known as the primary key) for the physical RMS table. Click thePrimary Field popup button to select. A primary key is a unique identifier for a database record. When a table is created, one of the fields must be assigned as the primary key.
Physical Name	Physical name given to the RMS table in the Framework ECM database. Example: addr, cfwd_activity, etc.
Logical Name	Logical, or user friendly, name given to the RMS table. Example: - The logical name of the physical addr table would be Address. - The logical name of the physical cfwd_activity table would be Call Forward Activity.
Constant Name	Constant, or shortened, name given to the RMS table. Example: - The constant name of the physical table cal_day table would be calDay. - The constant name of the physical table cfwd_tPgm table would be CfwdTPgm. - The constant name of the physical table addr table would be addr.
Order	Order number of the RMS table. This number determines the order of the Tables list on the RMS Table screen.

Notes Group

Free text area for notes regarding the RMS table.