PGM_RISK_VW

(SQL View)
 Index Back

Risk Search View


SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.RISK_ID , A.RISK_SUMMARY , B.DESCR , A.ACTIVITY_ID , A.RISK_PRIORITY , A.RISK_TYPE , A.RISK_STATUS , A.ASSIGNED_TO_EMPLID FROM PS_PGM_PROJ_RISK A , PS_PROJECT B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID

  • Related Language Record: PGM_RISK_VW_LG

    • # 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 RISK_SUMMARY Character(30) VARCHAR2(30) NOT NULL Risk Summary
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: PROJ_ACT_VW

    7 RISK_PRIORITY Character(1) VARCHAR2(1) NOT NULL Risk Priority
    1=High
    2=Medium
    3=Low

    Default Value: 2

    8 RISK_TYPE Character(10) VARCHAR2(10) NOT NULL Risk Type

    Prompt Table: PGM_RSK_TYP_SRH

    9 RISK_STATUS Character(1) VARCHAR2(1) NOT NULL Risk Status
    A=Active
    I=Inactive
    P=Potential

    Default Value: P

    10 ASSIGNED_TO_EMPLID Character(11) VARCHAR2(11) NOT NULL Assigned to Employee ID

    Prompt Table: PC_PERS_DATA_VW