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

LANGUAGE Columns 
ColumnName  Domain  Datatype  NULL  Definition 
COUNTRY_CD(PK)    VARCHAR2(2)  NO 
Name: Country. Description: The country code.
 
LANGUAGE_CD(PK)    VARCHAR2(2)  NO 
Name: Language. Description: The language code.
 
COUNTRY_LANGUAGE_DESC    VARCHAR2(30)  NO 
Name: Country/Language Description. Description: The description of the language and country combination.
 
MODIFIED_BY    VARCHAR2(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMBER(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 Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0018  PrimaryKey  LANGUAGE_CD, COUNTRY_CD 

LANGUAGE Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
COMPANY  Non-Identifying  One To Zero or More  F00009        NO  NO 
EMPL_PREFERENCE  Non-Identifying  One To Zero or More  F00037        NO  NO 
GENERAL_CONFIG_LABELS  Identifying  One To Zero or More  F00121        NO  NO 
GENERAL_CONFIG_UDT_LABELS  Identifying  One To Zero or More  F00124        NO  NO 
TIME_CONFIG_LABELS  Identifying  One To Zero or More  F00130        NO  NO 
EXP_CONFIG_LABELS  Identifying  One To Zero or More  F00172        NO  NO 
EXP_TYPE_LABELS  Identifying  One To Zero or More  F00188        NO  NO 
TAX_SCHEDULE_LABELS  Identifying  One To Zero or More  F00269        NO  NO 
EXP_RPT_TYPE_CATEGORY_LABELS  Identifying  One To Zero or More  F00282        NO  NO 
CUSTOM_TEXT  Identifying  One To Zero or More  F00375        NO  NO 
EXP_RPT_TYPE_LABELS  Identifying  One To Zero or More  F00393        NO  NO