LANGUAGE 
Default Table Name  LANGUAGE 
Definition 
 Name: Language Options.     Description: This table contains the valid language options for the system.
 

LANGUAGE Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
COUNTRY_CD(PK)    VARCHAR(2)  NO 
Name: Country. Description: The country code.
 
LANGUAGE_CD(PK)    VARCHAR(2)  NO 
Name: Language. Description: The language code.
 
COUNTRY_LANGUAGE_DESC    VARCHAR(30)  NO 
Name: Country/Language Description. Description: The description of the language and country combination.
 
MODIFIED_BY    VARCHAR(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMERIC(10, 0)  NO 
Name: Row Version. Description: The number of times this record has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 

LANGUAGE Keys 
Key Name  Key Type  Keys 
PI_0018  PrimaryKey  COUNTRY_CD, LANGUAGE_CD 

LANGUAGE Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
COMPANY  Non-Identifying  One To Zero or More          NO 
EMPL_PREFERENCE  Non-Identifying  One To Zero or More          NO 
GENERAL_CONFIG_LABELS  Identifying  One To Zero or More          NO 
GENERAL_CONFIG_UDT_LABELS  Identifying  One To Zero or More          NO 
TIME_CONFIG_LABELS  Identifying  One To Zero or More          NO 
EXP_CONFIG_LABELS  Identifying  One To Zero or More          NO 
EXP_TYPE_LABELS  Identifying  One To Zero or More          NO 
TAX_SCHEDULE_LABELS  Identifying  One To Zero or More          NO 
EXP_RPT_TYPE_CATEGORY_LABELS  Identifying  One To Zero or More          NO 
CUSTOM_TEXT  Identifying  One To Zero or More          NO 
EXP_RPT_TYPE_LABELS  Identifying  One To Zero or More          NO