| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table:
SP_BU_PC_NONVW
|
| 2 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: OPR_DEF_TBL_PC.PROJECT_ID
Prompt Table:
SP_PROJS_NONVW
|
| 3 |
RISK_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Risk ID
Default Value: NEXT
|
| 4 |
PC_CPY_UNIQUEID |
Character(15) |
VARCHAR2(15) NOT NULL |
Copy Unique ID
|
| 5 |
RISK_SUMMARY |
Character(30) |
VARCHAR2(30) NOT NULL |
Risk Summary
|
| 6 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 7 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
PROJ_ACT_VW
|
| 8 |
RISK_PRIORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Risk Priority
1=High
2=Medium
3=Low
Default Value: 2
|
| 9 |
PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority
Default Value: 1
|
| 10 |
RISK_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Risk Type
Prompt Table:
PGM_RSK_TYP_SRH
|
| 11 |
RISK_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Risk Status
A=Active
I=Inactive
P=Potential
Default Value: P
|
| 12 |
OWNER_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Risk Owner
Prompt Table:
PC_PERS_DATA_VW
|
| 13 |
ASSIGNED_TO_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Assigned to Employee ID
Prompt Table:
PC_PERS_DATA_VW
|
| 14 |
RISK_IMPACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Risk Impact
1=High
2=Medium
3=Low
|
| 15 |
RISK_PROBABILITY |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Risk Probability (%)
|
| 16 |
RISK_CONSEQUENCE |
Character(254) |
VARCHAR2(254) NOT NULL |
Risk Consequence
|
| 17 |
ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered by
|
| 18 |
DATE_ADDED |
Date(10) |
DATE |
Date Added
Default Value: %Date
|
| 19 |
RISK_USER1 |
Character(15) |
VARCHAR2(15) NOT NULL |
User Field 1
|
| 20 |
RISK_USER2 |
Character(15) |
VARCHAR2(15) NOT NULL |
User Field 2
|
| 21 |
RISK_USER3 |
Character(15) |
VARCHAR2(15) NOT NULL |
User Field 3
|
| 22 |
RISK_USER4 |
Character(15) |
VARCHAR2(15) NOT NULL |
User Field 4
|
| 23 |
RISK_USER5 |
Character(15) |
VARCHAR2(15) NOT NULL |
User Field 5
|
| 24 |
RISK_USER6 |
Character(15) |
VARCHAR2(15) NOT NULL |
User Field 6
|
| 25 |
RISK_USERAMT1 |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
User Amount 1
|
| 26 |
RISK_USERAMT2 |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
User Amount 2
|
| 27 |
PC_USER_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
User Currency
Default Value: PROJECT.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 28 |
RISK_USER_DT1 |
Date(10) |
DATE |
User Date 1
|
| 29 |
RISK_USER_DT2 |
Date(10) |
DATE |
User Date 2
|
| 30 |
FMS_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the original entry.
|
| 31 |
FMS_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the original entry.
|
| 32 |
FMS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 33 |
FMS_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|