ROLE 
Default Table Name  ROLE 
Definition 
 Name: Roles.     Description: This table contains specified security roles.
 

ROLE Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
ROLE_CD(PK)    VARCHAR(10)  NO 
Name: Security Role. Description: Unique identifier for this role.
 
ROLE_NAME    VARCHAR(30)  NO 
Name: Security Role Description. Description: Unique description of role.
 
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.
 
APPLY_EMPL_SECURITY_FL    VARCHAR(1)  NO 
Name: Apply Employee Level Security Flag. Description: Logical as to whether employee level security applies to this security role.
 
APPLY_CHARGE_SECURITY_FL    VARCHAR(1)  NO 
Name: Apply Charge Level Security Flag. Description: Logical as to whether charge level security applies to this security role.
 
MODIFY_TIME_ZONE_FL    VARCHAR(1)  NO 
Name: Modify Time Zone Flag. Description: Logical as to whether employees of this role code can modify their time zone.
 
MODIFY_SECURITY_ROLE_FL    VARCHAR(1)  NO 
Name: Modify Security Role Flag. Description: Logical as to whether employees of this role code can modify employee security roles.
 
ALLOW_DELEGATION_FL    VARCHAR(1)  NO 
Name: Allow Delegatoin Flag. Description: Logical as to whether security role allows delegation.
 

ROLE Keys 
Key Name  Key Type  Keys 
PI_0024  PrimaryKey  ROLE_CD 
SI_0005  Alternate Key  ROLE_NAME 

ROLE Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
ROLE_SCREEN  Identifying  One To Zero or More          NO 
EMPL  Non-Identifying  One To Zero or More          NO 
GENERAL_CONFIG  Non-Identifying  One To Zero or More          NO