PES_ClassType

PES_ClassType stores classification of an object type, as defined in PES_ObjectType, as an investment, work item, or resource.

Columns

Name Type Length Description
clt_UID int 4 Object type ID.
clt_Name nvarchar 400 Object type name.
clt_Name sysname 400 Object type name.

SQL Examples

SELECT*
FROM PES_ClassType
clt_UID     clt_Name
----------- ----------------------
1           Investment
2           Dependency
3           Task
4           Resource
5           Resource Allocation
6           Assignment
10          Timesheet Detail
11          Timephase Attribute Detail
12          Configurable Log
13          Work Item Task
14          Work Item Assignment
15          Non Labor Assignment
16          Agile Work Item