!!!Alias: MLV
(P2K_AM_LEXICON_VALUESS)

Unique Keys: Lexicon Name ([MLN_ID]) + [LANGUAGE_CODE] + [LOW_VALUE]

ERD: [ERD-AM30]

Lexicon values

!!Table Columns

||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[MLN_ID]|Number(10)|[ID]|Y|link to [P2K_AM_LEXICON_NAMES]
|[LANGUAGE_CODE]|Varchar2(3)|[X_LANGUAGE_CODE]|Y|
|[LOW_VALUE]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[LEX_ABBREVIATION]|Varchar2(30)|[ABBREVIATION]|Y|
|[LEXICON_USAGE]|Varchar2(2)|[X_LEXICON_USAGE]|Y|
|[HIGH_VALUE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[MEANING]|Varchar2(50)|[VARCHAR50|VARCHARnn]| |
|[LEGISLATION]|Varchar2(2)|[X_LEGISLATION]| |
|[SORT_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| |

User Fields: Not Allowed\\
Audit Logging: Not Allowed\\