PGM_ACT_RISK(SQL View) |
Index Back |
|---|---|
Project Risk ViewProject Risks View for Manager Workbench(Activity) for Program Management |
| SELECT ' ' ,' ' ,' ' ,' ' ,' ' , 1 ,%DateNull FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RISK_ID | Character(10) | VARCHAR2(10) NOT NULL | Risk ID |
| 2 | RISK_SUMMARY | Character(30) | VARCHAR2(30) NOT NULL | Risk Summary |
| 3 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 4 | RISK_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Risk Status
A=Active I=Inactive P=Potential |
| 5 | RISK_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Risk Priority
1=High 2=Medium 3=Low |
| 6 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | Priority |
| 7 | DATE_ADDED | Date(10) | DATE | Date Added |