Table of Contents

Table Prj_Project_Risks

Entity

Entity: Projects.Classic.ProjectRisks

Contains risks, associated to projects. Entity: Prj_Project_Risks

Owner Tables Hierarchy

Summary

Name Type Description
Create_Date date The creation date of the project risk.
Description nvarchar(max)
Impact_Percent decimal(3, 2) The impact of the risk to the project, expressed as percentage of the total project value.
Probability_Percent decimal(3, 2) The probability of the risk occurring.
Project_Id uniqueidentifier The project for which this risk applies.
Project_Risk_Id uniqueidentifier PK
Resolution_Strategy nvarchar(max) The strategy chosen to handle the risk
Resolve_Date date The date on which the risk is resolved
Resolved bit 1 if the risk is resolved
Responsible_Person_Id uniqueidentifier The person who is responsible for handling the risk
Risk_Name nvarchar(254) The short name of the risk.
Row_Version timestamp

Columns

Create_Date

The creation date of the project risk.

Property Value
Auto Complete no
Data Filter no
Default Value CurrentDateTime
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 date
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Create_Date - Supported Filters

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

Description

Property Value
Attributes IsLongString
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2147483647
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(max) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Description - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Like None no no

Impact_Percent

The impact of the risk to the project, expressed as percentage of the total project value.

Property Value
Attributes IsPercent
Auto Complete no
Data Filter no
Default Value 0
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 decimal(3, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Probability_Percent

The probability of the risk occurring.

Property Value
Attributes IsPercent
Auto Complete no
Data Filter no
Default Value 0
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 decimal(3, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Project_Id

The project for which this risk applies.

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_Projects
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_Id - Supported Filters

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

Project_Risk_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_Risk_Id - Supported Filters

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

Resolution_Strategy

The strategy chosen to handle the risk

Property Value
Attributes IsLongString
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2147483647
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(max) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Resolution_Strategy - Supported Filters

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

Resolve_Date

The date on which the risk is resolved

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 date (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Resolve_Date - Supported Filters

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

Resolved

1 if the risk is resolved

Property Value
Auto Complete no
Data Filter no
Default Value False
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 bit
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Resolved - Supported Filters

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

Responsible_Person_Id

The person who is responsible for handling the risk

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 Cm_Persons
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Responsible_Person_Id - Supported Filters

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

Risk_Name

The short name of the risk.

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 254
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type nvarchar(254)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Risk_Name - Supported Filters

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

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
Suggest improvement to this page