PSA_SCENARIO

(SQL Table)
Index Back

PSA Opportunity Scenarios

  • Parent record: PSA_OPPTY_HDR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID

    Prompt Table: PSA_OPPTY_HDR

    2 SCENARIO_ID Character(4) VARCHAR2(4) NOT NULL A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca

    Default Value: NEXT

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 LAST_ACTIVITY_ID Number(8,0) INTEGER NOT NULL Last Actvity ID

    Default Value: 1

    5 PROPOSED Character(1) VARCHAR2(1) NOT NULL Indicates with a "Y" that "this" version was chosen for Contract/Project creation.

    Y/N Table Edit

    6 PROPOSED_AMOUNT Number(27,3) DECIMAL(26,3) NOT NULL Proposed Amount
    7 PROPOSED_AMT_TIME Number(27,3) DECIMAL(26,3) NOT NULL Proposed Amount Time
    8 PROPOSED_AMT_EXP Number(27,3) DECIMAL(26,3) NOT NULL Proposed Amount Expense
    9 ESTIMATED_AMOUNT Number(27,3) DECIMAL(26,3) NOT NULL Estimated Amount SCP - Added new label - Estimated Cost
    10 ESTIMATED_AMT_TIME Number(27,3) DECIMAL(26,3) NOT NULL Estimated Amount Time
    11 ESTIMATED_AMT_EXP Number(27,3) DECIMAL(26,3) NOT NULL Estimated Amount Expense
    12 COST_AMT Number(27,3) DECIMAL(26,3) NOT NULL Cost Amount
    13 COST_AMT_TIME Number(27,3) DECIMAL(26,3) NOT NULL Cost Amount Time
    14 COST_AMT_EXP Number(27,3) DECIMAL(26,3) NOT NULL Cost Amount Expense
    15 MARGIN_PCT Number(6,2) DECIMAL(5,2) NOT NULL Margin Percent
    16 MARGIN_PCT_TIME Signed Number(7,2) DECIMAL(5,2) NOT NULL Margin Percent
    17 MARGIN_PCT_EXP Signed Number(7,2) DECIMAL(5,2) NOT NULL Margin Percent
    18 RESOURCE_TOTAL Number(3,0) SMALLINT NOT NULL Resource Total
    19 START_DATE Date(10) DATE Start Date for Gen Standing PO
    20 END_DATE Date(10) DATE End Date
    21 NBR_OF_HOURS Number(5,0) INTEGER NOT NULL Number of Hours
    22 WEEKLY_WEEKS Number(3,0) SMALLINT NOT NULL Weeks
    23 PRICING_METHOD Character(3) VARCHAR2(3) NOT NULL Pricing Method
    FIX=Fixed
    INC=As Incurred
    24 SCEN_ADJUST_OPT_TM Character(1) VARCHAR2(1) NOT NULL Overall Scenario adjustment option for Time.
    A=Flat Amount
    N=No Adjustment
    P=Percentage
    R=Replacement Amount

    Default Value: N

    25 SCEN_ADJUST_AMT_TM Signed Number(28,3) DECIMAL(26,3) NOT NULL Scenario Adjustment Amount for Time
    26 SCEN_ADJUST_PCT_TM Signed Number(7,2) DECIMAL(5,2) NOT NULL Scenario Adjustment % for Time 06/09/2004 PR_FS_B005 Added Label - LABOR_ADJUST
    27 OVERRIDE_AMT_TM Signed Number(28,3) DECIMAL(26,3) NOT NULL Replacement Amount for Time
    28 SCEN_ADJUST_OPT_EX Character(1) VARCHAR2(1) NOT NULL Overall Scenario adjustment option for Expense.
    A=Flat Amount
    N=No Adjustment
    P=Percentage
    R=Replacement Amount

    Default Value: N

    29 SCEN_ADJUST_AMT_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Scenario Adjustment Amount for Expense
    30 SCEN_ADJUST_PCT_EX Signed Number(7,2) DECIMAL(5,2) NOT NULL Scenario Adjustment % for Expense 06/09/2004 PR_FS_B005 Added Label NON_LABOR_ADJUST
    31 OVERRIDE_AMT_EX Signed Number(28,3) DECIMAL(26,3) NOT NULL Replacement Amount for Expense