Previous Topic: usp_functional_access_level TableNext Topic: usp_functional_access_type Table


usp_functional_access_role Table

Maps the many-to-many relationship between the usp_functional_access table and the usp_role table. This table also defines the access level such as None, View, and Modify.

Field

Data Type

Reference

Remarks

id

INTEGER

 

UNIQUE KEY

last_mod_dt

LOCAL_TIME

 

 

last_mod_by

UUID

ca_contact

 

access_level

INTEGER

usp_functional_ access_level

Reference to a usp_functional_access_level record that describes the access level for the relationship

func_access

STRING 30

usp_functional_ access

Reference to a usp_functional_access record.

role

INTEGER

usp_role

Reference to a usp_role record

description

STRING 1000