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. |