Locale (ver7.0.0)
Defines the locales that can be used by the system. This table is mostly populated and maintained by the installation; though two locales (English/US and the special PowerSchool Support locale) are pre-seeded.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CountryISOCode | 7.0.0 | Varchar2(3) | Required. Country code abbreviation for this locale. Foreign Key to CountyISOCodeLU.CountryISOCode. |
DisplayLabel | 7.0.0 | Varchar2(50) | Required. Label displayed in the application when referencing a specific Locale. The installation can choose what to call these locales, though it is recommended that the name of the language in its own script be used: e.g. "English" for English, "Español" for Spanish, 日本語 for Japanese, etc. |
LanguageISOCode | 7.0.0 | Varchar2(3) | Required. Language code abbreviation for this locale. Foreign Key to LanguageISOCodeLU.LanguageISOCode. |
LocaleCurrencyFormatID | 7.0.0 | Number(10) | Foreign Key to LocaleNumCurrFormatLU.LocaleNumCurrID to identify the currency format for this locale. |
LocaleDateFormatID | 7.0.0 | Number(10) | Required. Foreign Key to LocaleDateFormat.LocaleDateFormatID to identify the date format for this locale. |
LocaleID | 7.0.0 | Number(10) | Required. Unique identifier for this locale. |
LocaleNumericFormatID | 7.0.0 | Number(10) | Foreign Key to LocaleNumCurrFormatLU.LocaleNumCurrID to identify the numeric format for this locale. |
LocaleTimeFormatID | 7.0.0 | Number(10) | Required. Foreign Key to LocaleTimeFormat.LocaleTimeFormatID to identify the time format for this locale. |
| OtherDateFormatOption | 11.0.1 | Number(10) | Required. Foreign Key to LocaleTimeFormat.LocalTimeFormatID to identify the optional long time format for this locale. Defaults to 0. |
| RightToLeft | 23.1.0 | Number(1) | Required. Indicates the related language direction and site layout of the locale. Default value is 0 (Left to Right), or 1 (Right to Left). |
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. |