CHARGE_BRANCH_EMPL_GROUP 
Default Table Name  CHARGE_BRANCH_EMPL_GROUP 
Definition 
 Name: Charge Branch Employee Groups .     Description: This table contains the employee groups that are authorized to charges within this branch. This table can be populated only for charge branches that are configured to restrict employee groups.
 

CHARGE_BRANCH_EMPL_GROUP 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.
 
EMPL_GROUP_CD(PK)(FK)    VARCHAR(25)  NO 
Name: Employee Group. Description: Unique identifier for the employee group.
 
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_EMPL_GROUP Keys 
Key Name  Key Type  Keys 
PI_0106  PrimaryKey  CHARGE_TREE_CD, CHARGE_BRANCH_CD, EMPL_GROUP_CD 
SI_0008  Inversion Entry  CHARGE_TREE_CD, EMPL_GROUP_CD 
RI_F00073  Inversion Entry  EMPL_GROUP_CD 
RI_F00072  Inversion Entry  CHARGE_TREE_CD, CHARGE_BRANCH_CD 

CHARGE_BRANCH_EMPL_GROUP 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 
EMPL_GROUP  Identifying  One To Zero or More        EMPL_GROUP_CD  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype