Reference table that defines the various types of resource that can exist. In CA DataMinder r12.5 there will be only one value which will be to represent the Resourcetype to ‘Review’, it is envisaged that this list will expand over time to encompass more resource types.
|
Column |
Primary Key |
Datatype |
Length |
Notes |
|---|---|---|---|---|
|
ResourceTypeUID Unique ID of the resourcetype |
Yes |
INTEGER |
4 |
|
|
ResourceTypeClass The class of the resource type |
|
INTEGER |
4 |
In CA DataMinder r12.5 there will only be one value ‘Review’ |
|
ResourceTypeValue The value of the resource type |
|
INTEGER |
4 |
In CA DataMinder r12.5 there will only be one value ‘View’ |
The columns ResourceTypeClass and ResourceTypeValue are numeric Id’s, in order to obtain the corresponding description they need to be joined to WgnWellKnownString with values of 21 and 22 respectively for WKType. A view wgn_v_resource_type is available for this purpose.
|
Copyright © 2014 CA.
All rights reserved.
|
|