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

CHARGE_BRANCH_CHARGE_EMPL Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0107  PrimaryKey  CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD, EMPL_ID 

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