pcat_loc

The following tables are added to support many-to-many relationships between Categories, Groups that can service the Categories, and Locations that groups are able to service. This is all used for the Auto-Assignment functionality. Used to build a list of Service Locations valid for the Category

Column Name Column Datatype Column Null Option Column Comment
id integer not null Unique (to the table) numeric identifier.
l_persid nvarchar(60) with null Left hand key
l_attr nvarchar(30) with null Left hand attribute name
l_sql integer with null Left hand sort order
r_persid nvarchar(60) with null Right hand key
r_attr nvarchar(30) with null Right hand attribute name
r_sql integer with null Right hand sort order

Product Name: Unicenter Service Desk

Table Type: Table


Copyright © 2006 CA. All rights reserved.