COMPANY 
Default Table Name  COMPANY 
Definition 
 Name: Company .     Description: This table keeps overall company information including licensing.
 

COMPANY Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
COMPANY_ID(PK)    VARCHAR(10)  NO 
Name: Company ID. Description: The Company ID (i.e., client ID).
 
DFLT_COUNTRY_CD(FK)    VARCHAR(2)  NO 
Name: Default Country. Description: The default country for this company.
 
DFLT_LANGUAGE_CD(FK)    VARCHAR(2)  NO 
Name: Default Language. Description: The default language code for this company.
 
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.
 
COMPANY_NAME_S    VARCHAR(4000)  NO 
Name: Company Name. Description: The name of the site. This is an encrypted field.
 

COMPANY Keys 
Key Name  Key Type  Keys 
RI_F00009  Inversion Entry  DFLT_LANGUAGE_CD, DFLT_COUNTRY_CD 
PI_0019  PrimaryKey  COMPANY_ID 

COMPANY Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
LANGUAGE  Non-Identifying  One To Zero or More        DFLT_COUNTRY_CD, DFLT_LANGUAGE_CD  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
COMPANY_ACCESS  Identifying  One To Zero or More          NO 
GENERAL_CONFIG  Identifying  One To Zero or More          NO 
GENERAL_CONFIG_LABELS  Identifying  One To Zero or More          NO 
TIME_CONFIG  Identifying  One To Zero or More          NO 
TIME_CONFIG_LABELS  Identifying  One To Zero or More          NO 
TIME_CONFIG_UDT  Identifying  One To Zero or More          NO 
EXP_CONFIG  Identifying  One To Zero or More          NO 
ESS_CONFIG  Identifying  One To Zero or More          NO 
GENERAL_CONFIG_ATTACHMENT  Identifying  One To Zero or More          NO 
GENERAL_CONFIG_ATTACHMENT_LBLS  Identifying  One To Zero or More          NO