Identify active resource in SQL database

[LML]

Can anyone tell me what field and value to look at on the SQL (MSP_RESOURCES
?) table to identify a resource that is active?

I would like to write an access query to identify active resources that have
not submitted time for a given time period.
Thanks!

 

[Ray McCoppin]

The field is RES_RTYPE: Indicates whether a resource is normal or generic
and whether the normal or generic resource is deactivated: 0 Normal resource
1 Generic resource
100 Deactivated, normal resource
101 Deactivated, generic resource

Hope this helps...

 

[LML]

THANKS RAY!!

The field is RES_RTYPE: Indicates whether a resource is normal or generic
and whether the normal or generic resource is deactivated: 0 Normal resource
1 Generic resource
100 Deactivated, normal resource
101 Deactivated, generic resource

Hope this helps...
--
Ray McCoppin

http://www.randsmanagement.com
SRS gantt charts