/
RMS Field

RMS Field

Owned by Julie Doyle-Whitelock (Deactivated)
Last updated: Jan 31, 2019

CRITICAL

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

The RMS Field screen lists all the available fields by the table to which they have been allocated.

RMS Field Dialog

This dialog is used to add additional RMS fields to the Framework ECM database. Changes made to this area of the system will be overwritten when an upgrade is performed.


General Group

Field

Description

Table

RMS table to which the RMS field belongs. Click the Table popup button to select.

Data Type

Data type of the RMS field. Click the Data Type popup button to select. Standard selections include: 

  • Date
  • Decimal
  • Double
  • Integer (long)
  • Integer (small)/Boolean
  • Memo
  • Object
  • Real
  • String
  • Time

Physical Name

Physical name of the RMS field in the Framework ECM database.

Example: 
- l_suburb_id
- s_addr_full
- d_created
- t_created

Logical Name

Logical, or user friendly, name of the RMS field.

Example:  
- The logical name of the physical field name s_addr_full would be Full Address.
- The logical name of the physical table name t_created would be Time Created.

Constant Name

This field/function is currently disabled.

Default Value

Default value of the RMS field.

Size

Size of data the RMS field can hold. This number is restricted to the settings imposed by theFramework ECM SQL database.

Example: Let's say the Framework ECM database restricts the number of characters of the Street Number to 15 characters. The builder may decide that they only ever reach 5 characters so the default value can be modified to 5 characters only. 
Character lengths above the system setting revert to the Framework ECM database size.

Order

Order number of the RMS field. This number determines the order of the RMS Fields list on the RMS Field screen.

Has Permission?

Does the RMS field have any associated security permissions? 

  • No (default): The RMS field does not have any associated security permissions.
  • Yes: The RMS field has associated security permissions. Security permissions are set on the Security Permission screen in the Security module.

In Reporting?

Can the RMS field be used in reporting? 

  • No (default): The RMS field cannot be used in reporting.
  • Yes: The RMS field can be used in reporting.

Primary Key?

Is the RMS field the primary key in the RMS table? 

  • No (default): The RMS field is not the primary key in the RMS table.
  • Yes: The RMS field is the primary key in the RMS table.

Note: All primary keys must be in the format l_[field]_id and have the data type ofInteger (long).

Notes Group

Free text area for notes regarding the RMS field.

Related content