ColumnName |
Domain |
Datatype |
NULL |
Definition |
ROLE_CD |
|
VARCHAR2(10) |
NO |
Name: Security Role. Description: Unique identifier for this role. |
ROLE_NAME |
|
VARCHAR2(30) |
NO |
Name: Security Role Description. Description: Unique description of role. |
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. |
APPLY_EMPL_SECURITY_FL |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(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 |
|
VARCHAR2(1) |
NO |
Name: Allow Delegatoin Flag. Description: Logical as to whether security role allows delegation. |