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

CHARGE_BRANCH_CHARGE Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0015  PrimaryKey  CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD 

CHARGE_BRANCH_CHARGE Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
CHARGE_BRANCH  Identifying  One To Zero or More  F00006      CHARGE_TREE_CD, CHARGE_BRANCH_CD  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
EMPL_CHARGE_FAVORITES  Identifying  One To Zero or More  F00063        NO  NO 
CHARGE_BRANCH_CHARGE_EMPL  Identifying  One To Zero or More  F00070        NO  NO 
EXP_AUTH_CHARGE_ALLOCATIONS  Non-Identifying  One To Zero or More  F00356        NO  NO 
TS_LINE  Non-Identifying  One To Zero or More  F00415        NO  NO