PGM_PRJ_RISK_LG

(SQL Table)
Index Back

Project Risk LG

Language table for PGM_PROJ_RISK

  • Related Language Record for PGM_PROJ_RISK
  • # 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
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 RISK_SUMMARY Character(30) VARCHAR2(30) NOT NULL Risk Summary
    6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    7 RISK_CONSEQUENCE Character(254) VARCHAR2(254) NOT NULL Risk Consequence
    8 RISK_USER1 Character(15) VARCHAR2(15) NOT NULL User Field 1
    9 RISK_USER2 Character(15) VARCHAR2(15) NOT NULL User Field 2
    10 RISK_USER3 Character(15) VARCHAR2(15) NOT NULL User Field 3
    11 RISK_USER4 Character(15) VARCHAR2(15) NOT NULL User Field 4
    12 RISK_USER5 Character(15) VARCHAR2(15) NOT NULL User Field 5
    13 RISK_USER6 Character(15) VARCHAR2(15) NOT NULL User Field 6
    14 RISK_USERAMT1 Number(27,3) DECIMAL(26,3) NOT NULL User Amount 1
    15 RISK_USERAMT2 Number(27,3) DECIMAL(26,3) NOT NULL User Amount 2
    16 PC_USER_CURRENCY Character(3) VARCHAR2(3) NOT NULL User Currency

    Default Value: PROJECT.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    17 RISK_USER_DT1 Date(10) DATE User Date 1
    18 RISK_USER_DT2 Date(10) DATE User Date 2