Access type information for the Unicenter Service Desk applications
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Primary key of this table |
| del | integer | not null | Deleted flag (0=active 1=inactive/marked as deleted) |
| sym | nvarchar(30) | not null | The symbolic value for this Access_Type. |
| description | nvarchar(100) | with null | Textual description of this Access Type |
| view_internal | integer | with null | Controls access to internal logs |
| form_group | integer | with null | Unique (to the table) Numeric ID |
| initial_form | nvarchar(256) | with null | The initial form value for this Access_Type. |
| domain | integer | with null | Unique (to the table) Numeric ID |
| domain_flag | integer | not null | Override Contacts data partition for this Access Type |
| external_auth | integer | not null | Allow External Authorization for this Access Type |
| user_auth | integer | not null | The user authentication type for this Access Type |
| pin_field | nvarchar(50) | with null | The field that contains the users pin for pin type authentication. |
| interface_type | integer | with null | Primary interface type |
| sd_admin | integer | with null | Authorized for SD admin interface |
| sd_analyst | integer | with null | Authorized for SD analyst interface |
| sd_employee | integer | with null | Authorized for SD employee interface |
| sd_customer | integer | with null | Authorized for SD customer interface |
| kt_admin | integer | with null | Authorized for KT admin interface |
| kt_manager | integer | with null | Authorized for KT manager interface |
| kt_engineer | integer | with null | Authorized for KT engineer interface |
| kt_analyst | integer | with null | Authorized for KT analyst interface |
| kt_customer | integer | with null | Authorized for KT customer interface |
| ct_analyst | integer | with null | Authorized for CT analyst interface |
| ct_customer | integer | with null | Authorized for CT customer interface |
| config | integer | with null | Authorized for configuration interface |
| pref_doc | integer | with null | Preferred document: 1 = cr, 2 = iss |
| access_level | integer | not null | Enumerated value for this entry - specifies ordering in lists and relative values |
| grant_level | integer | not null | Enumerated value for this entry - specifies ordering in lists and relative values |
| ct_type | integer | with null | Internal use |
| kt_type | integer | with null | Internal use |
| call_mgr | integer | with null | Permit access to Request Management |
| change_mgr | integer | with null | Permit access to Change Order Management |
| issue_mgr | integer | with null | Permit access to Issue Management |
| inventory | integer | with null | Allow maintenance to inventory data |
| reference | integer | with null | Allow maintenance to reference data |
| notify | integer | with null | Allow maintenance to notification data |
| admin | integer | with null | Allow maintenance to administration data |
| security | integer | with null | The security value for this Access_Type. |
| kd | integer | with null | The kd value for this Access_Type. |
| kcat | integer | with null | The kcat value for this Access_Type. |
| default_flag | integer | with null | The default flag value for this Access_Type. |
| last_mod_dt | integer | with null | Timestamp of when this record was last modified |
| last_mod_by | byte(16) | with null | Specifies the UUID of the contact who last modified this record |
| ldap_access_group | nvarchar(512) | with null | The ldap access group value for this Access_Type. |
| wsp | integer | with null | Web Screen Painter authorization level |
Product Name: Unicenter Service Desk
Table Type: Table