CHARGE_BRANCH_CHARGE_EMPL 
Default Table Name  CHARGE_BRANCH_CHARGE_EMPL 
Definition 
 Name: Charge Employees .     Description: This table contains the employees that are authorized to charge level charges within the charge tree. This table can be populated only for charges that are configured to restrict employees.
 

CHARGE_BRANCH_CHARGE_EMPL 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)(FK)    VARCHAR(100)  NO 
Name: Charge. Description: The identifier of the charge in the charge tree/branch.
 
EMPL_ID(PK)(FK)    VARCHAR(20)  NO 
Name: Employee ID. Description: Unique identifier for the employee.
 
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.
 

CHARGE_BRANCH_CHARGE_EMPL Keys 
Key Name  Key Type  Keys 
RI_F00071  Inversion Entry  EMPL_ID 
RI_F00070  Inversion Entry  CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD 
PI_0107  PrimaryKey  CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD, EMPL_ID 

CHARGE_BRANCH_CHARGE_EMPL Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
CHARGE_BRANCH_CHARGE  Identifying  One To Zero or More        CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD  NO 
EMPL  Identifying  One To Zero or More        EMPL_ID  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype