CP_COMPANY 
Default Table Name  CP_COMPANY 
Definition 
 Name: Costpoint Company Table .     Description: This table contains the valid Costpoint company codes.
 

CP_COMPANY Columns 
ColumnName  Domain  Datatype  NULL  Definition 
CP_COMPANY_CD(PK)    VARCHAR2(10)  NO 
Name: Costpoint Company. Description: Costpoint Company Code.
 
CP_COMPANY_NAME    VARCHAR2(30)  NO 
Name: Costpoint Company Name. Description: Description of Company Code.
 
ACTIVE_FL    VARCHAR2(1)  NO 
Name: Active Flag. Description: Logical as to whether this Company Code is active.
 
MODIFIED_BY    VARCHAR2(20)  NO 
Name: Modified By. Description: The User ID that 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.
 
CP_COMPANY_LOGO_NAME_DIR_S    VARCHAR2(254)  YES 
Name: Company Logo. Description: The location of the Costpoint Company logo.
 

CP_COMPANY Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0134  PrimaryKey  CP_COMPANY_CD 

CP_COMPANY 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 
LEAVE_TYPE  Non-Identifying  One To Zero or More  F00133        NO  NO 
UDT02  Non-Identifying  One To Zero or More  F00134        NO  NO 
UDT04  Non-Identifying  One To Zero or More  F00135        NO  NO 
UDT05  Non-Identifying  One To Zero or More  F00136        NO  NO 
UDT06  Identifying  One To Zero or More  F00137        NO  NO 
UDT07  Identifying  One To Zero or More  F00138        NO  NO 
UDT09  Non-Identifying  One To Zero or More  F00139        NO  NO 
EMPL_HISTORY  Non-Identifying  One To Zero or More  F00140        NO  NO 
TS  Non-Identifying  One To Zero or More  F00141        NO  NO 
EXP_RPT  Non-Identifying  One To Zero or More  F00203        NO  NO 
EXP_AUTH  Non-Identifying  One To Zero or More  F00347        NO  NO