Skip to main content
Skip table of contents

MessageKeyMap (ver7.0.0)

Stores messages imported or localized by the specific deployment. Messages built into the system (e.g. default messages or locales delivered with the system) do not appear here. Instead, they are stored in properties files built into the system distribution. Messages in this table override built-in messages.

Column Name

Initial Version

Data Type

Description

CountryISOCode

7.0.0

Varchar2(3)

Required. Foreign Key to CountryISOCodeLU.CountryISOCode. The country code abbreviation identifying the country portion of this message's locale.

Identifier

7.0.0

Varchar2(512)

For text localizations, used to group messages by type; for data localizations, differentiates between localizations of a given type (e.g. different attendance codes or course names). Used together with the MessageKey column to form a unique (within a locale) internationalization key for the message.

LanguageISOCode

7.0.0

Varchar2(3)

Required. Foreign Key to LanguageISOCodeLU.LanguageISOCode. The language code abbreviation identifying the language portion of this message's locale.

MessageKey

7.0.0

Varchar2(256)

Required. For text localizations, the internationalized identifier for this message; for data localizations, used together with the Identifier column to form a unique (within a locale) key.

MessageKeyMapID

7.0.0

Number(10)

Required. Unique identifier for this MessageKeyMap record.

MessageText

7.0.0

CLOB

Required. The text to be displayed in the application given this records language and country code.

SchoolID

7.0.0

Number(10)

The School ID for this record. This is intended to allow for school-specific localizations, although it is not currently used.

WhenCreated

7.0.0

Timestamp

Required. Created timestamp. Defaults to system date.

WhenModified

7.0.0

Timestamp

Modified timestamp. Defaults to system date.

WhoCreated

7.0.0

Varchar2(100)

Required. User that created the record. Defaults to user.

WhoModified

7.0.0

Varchar2(100)

User that modified the record. Defaults to user.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.