Table Prj_Project_Task_Dependancies

Entity

Entity: Projects.Classic.ProjectTaskDependancies

Represents dependancy between project tasks. Entity: Prj_Project_Task_Dependancies

Owner Tables Hierarchy

• Prj_Project_Tasks

Summary

Name	Type	Description
Dependancy_Type	nvarchar(2) Allowed: FS, SS, FF, SF, SY	FS=Finish-to-Start;SS=Start-to-Start;FF=Finish-to-Finish;SF=Start-to-Finish;SY=Sync (all types in the same time)
Depends_On_Task_Id	uniqueidentifier	The task on which Project_Task depends
Project_Task_Dependancy_Id	uniqueidentifier PK
Project_Task_Id	uniqueidentifier	The task which depends on another task
Row_Version	timestamp

Columns

Dependancy_Type

FS=Finish-to-Start;SS=Start-to-Start;FF=Finish-to-Finish;SF=Start-to-Finish;SY=Sync (all types in the same time)

Property	Value
Allowed Values	FS, SS, FF, SF, SY
Auto Complete	no
Data Filter	no
Default Value	FS
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	2
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(2)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Depends_On_Task_Id

The task on which Project_Task depends

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Prj_Project_Tasks
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Depends_On_Task_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	no	no

Project_Task_Dependancy_Id

Property	Value
Auto Complete	no
Data Filter	no
Default Value	NewGuid
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	yes (order: 1)
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Project_Task_Dependancy_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	no	yes

Project_Task_Id

The task which depends on another task

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	yes
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Prj_Project_Tasks
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Project_Task_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	no	no

Row_Version

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	timestamp
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no