ProjectTypeStatusLink table - SuperOffice

ProjectTypeStatusLink Table (213)

Many-many link table between project type and status, similar to sale type-stage link; and an anchor point for guide items

Fields

Name	Description	Type	Nullable
ProjectTypeStatusLink_id	Primary key	PK	No
projType_id	Link to project type	FK ProjType	No
projStatus_id	Link to project status	FK ProjStatus	No
rank	Rank order	UShort	Yes
deleted	0 -> record is active 1 -> record is ‘deleted’ and should not be shown in lists	UShort	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

ProjectTypeStatusLink table relationship diagram

Indexes

Fields	Types	Description
projType_id, projStatus_id	FK, FK	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
ProjStatus	ProjStatus list table. Project status
ProjType	ProjType list table. List of valid Project types.
SuggestedAppointment	Defines a suggested appointment for use in a Sale Guide or Project Guide
SuggestedDocument	Unique owner of a set of licensed modules

Replication Flags

Replicate changes DOWN from central to satellites and travellers.
Replicate changes UP from satellites and travellers back to central.
Copy to satellite and travel prototypes.

Security Flags

No access control via user’s Role.

Related topics

Projects Project guides NSSuggestedAppointment NSProjectTypeStatusLink ProjStatus table Save Suggested Appointment Entity

⌘I