Retrieve and modify project types.

Table Specific Information

When inserting into the EnterpriseProjectTypes table, at least one project details page is required to be specified.

Three of the GetDeepInsertableColumns stored procedure's resultset columns (IsCreate, Position, and Id) can be specified in a temporary table and referenced via the LinkedProjectDetailPages column when inserting into the EnterpriseProjectTypes table.

For example:

INSERT INTO ProjectDetailPages#Temp (Id, IsCreate) VALUES  ('98d9dc7f-b563-4276-8a60-df8fc4775301', true);

INSERT INTO EnterpriseProjectTypes (Name, Description, WorkspaceTemplateName, LinkedProjectDetailPages) VALUES ('Test EnterpriseProjectType', 'Test Description', 'ProjectSite#0', 'ProjectDetailPages#Temp');

Columns

Name	Type	ReadOnly	References	Required	Description
Id [KEY]	String	False		False
Departments	String	False		False
Description	String	False		False
ImageUrl	String	False		False
IsDefault	Bool	False		False
IsManaged	Bool	False		False
Name	String	False		False
Order	Int	False		False
PermissionSyncEnable	Bool	False		False
ProjectPlanTemplateId	String	False		False
SiteCreationOption	Int	False		False
SiteCreationURL	String	False		False
TaskListSyncEnable	Bool	False		False
WorkflowAssociationId	String	False		False
WorkflowAssociationName	String	False		False
WorkspaceTemplateLCID	Int	False		False
WorkspaceTemplateName	String	False		False
LinkedProjectDetailPages	String	False		False

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
InsertMode	String	Determines the Insert Mode. Set to 'ADD' to use standard MSProject Add function. This is the default and is recommended. Set to 'ODATA' to use standard ODATA insert functionality. This input is only applicable during inserts. The value set in this input overrides the value set in the InsertMode connection property (see the documentation page for the InsertMode connection property for more information).