CHARGE_BRANCH_CHARGE 
Default Table Name  CHARGE_BRANCH_CHARGE 
Definition 
 Name: Charge Branch Charge .     Description: This table contains charge information for a bottom level branch.
 

CHARGE_BRANCH_CHARGE Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
CHARGE_TREE_CD(PK)(FK)    VARCHAR(50)  NO 
Name: Charge Tree. Description: The top-level identifier of the charge tree.
 
CHARGE_BRANCH_CD(PK)(FK)    VARCHAR(50)  NO 
Name: Charge Branch. Description: The identifier of the branch in the charge tree.
 
CHARGE_CD(PK)    VARCHAR(100)  NO 
Name: Charge. Description: The identifier of the charge in the charge tree/branch.
 
DFLT_UDT01_ID    VARCHAR(50)  YES 
Name: Default UDT01. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT02_ID    VARCHAR(50)  YES 
Name: Default UDT02. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT03_ID    VARCHAR(20)  YES 
Name: Default UDT03. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT04_ID    VARCHAR(20)  YES 
Name: Default UDT04. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT05_ID    VARCHAR(20)  YES 
Name: Default UDT05. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT06_ID    VARCHAR(20)  YES 
Name: Default UDT06. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT07_ID    VARCHAR(20)  YES 
Name: Default UDT07. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT08_ID    VARCHAR(20)  YES 
Name: Default UDT08. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT09_ID    VARCHAR(20)  YES 
Name: Default UDT09. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT10_ID    VARCHAR(20)  YES 
Name: Default UDT10. Description: If present, this value provides overriding default for this UDT.
 
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.
 
ACTIVE_FL    VARCHAR(1)  NO 
Name: Active Flag. Description: Logical as to whether this charge is active.
 
RESTRICT_EMPL_FL    VARCHAR(1)  NO 
Name: Restrict Employees Flag. Description: Logical as to whether this charge should be restricted to certain employees.
 
UDT09_ABBRV_ID    VARCHAR(20)  YES 
Name: UDT09 Abbreviation. Description: Abbreviation for DFLT_UDT09_ID.
 
UDT06_CP_COMPANY_CD    VARCHAR(10)  YES 
Name: UDT06 Costpoint Company. Description: Costpoint Company Code for DFLT_UDT06_ID field.
 
UDT07_CP_COMPANY_CD    VARCHAR(10)  YES 
Name: UDT07 Costpoint Company. Description: Costpoint Company Code for DFLT_UDT07_ID field.
 
OVERRIDE_CHARGE_DESC    VARCHAR(120)  YES 
Name: Override Charge Description. Description: If a value exists in this column it will replace the charge description from UDT01/UDT02 on the timesheet line for the charge.
 
COMMENT_REQUIRED_FL    VARCHAR(1)  NO 
Name: Comment Required Flag. Description: Logical as to whether comment is required when this charge is used on timesheet.
 
DFLT_UDT11_ID    VARCHAR(20)  YES 
Name: Default UDT11. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT12_ID    VARCHAR(20)  YES 
Name: Default UDT12. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT13_ID    VARCHAR(20)  YES 
Name: Default UDT13. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT14_ID    VARCHAR(20)  YES 
Name: Default UDT14. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT15_ID    VARCHAR(20)  YES 
Name: Default UDT15. Description: If present, this value provides overriding default for this UDT.
 
AUTH_HRS    NUMERIC(8, 2)  NO 
Name: Authorized Hours. Description: The number of hours authorized for this charge. 
 

CHARGE_BRANCH_CHARGE Keys 
Key Name  Key Type  Keys 
SI_0074  Inversion Entry  RESTRICT_EMPL_FL, ACTIVE_FL, CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD, DFLT_UDT02_ID, DFLT_UDT01_ID 
SI_0071  Inversion Entry  DFLT_UDT01_ID, OVERRIDE_CHARGE_DESC, ACTIVE_FL 
SI_0068  Inversion Entry  DFLT_UDT02_ID, OVERRIDE_CHARGE_DESC, ACTIVE_FL 
RI_LF_0025  Inversion Entry  DFLT_UDT09_ID 
SI_0034  Inversion Entry  DFLT_UDT02_ID, ACTIVE_FL 
SI_0033  Inversion Entry  DFLT_UDT01_ID, ACTIVE_FL 
RI_F00006  Inversion Entry  CHARGE_TREE_CD, CHARGE_BRANCH_CD 
PI_0015  PrimaryKey  CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD 

CHARGE_BRANCH_CHARGE Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
CHARGE_BRANCH  Identifying  One To Zero or More        CHARGE_TREE_CD, CHARGE_BRANCH_CD  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
EMPL_CHARGE_FAVORITES  Identifying  One To Zero or More          NO 
CHARGE_BRANCH_CHARGE_EMPL  Identifying  One To Zero or More          NO 
EXP_AUTH_CHARGE_ALLOCATIONS  Non-Identifying  One To Zero or More          NO 
TS_LINE  Non-Identifying  Zero or One to Zero or More          NO