PC_CRATE_VALS

(SQL Table)
Index Back

Project Custom Rate Values

Define Cost and Billing rates for a Project Costing Custom Rate definition.

  • Parent record: PC_CRATE_LN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 RATE_NAME Character(15) VARCHAR2(15) NOT NULL Unique Identifier for a Custom Rate Name

    Prompt Table: PC_CRATE_DEFN

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 FIELDVALUE1 Character(30) VARCHAR2(30) NOT NULL Field Value

    Prompt Table: %EDITTABLE

    5 FIELDVALUE2 Character(30) VARCHAR2(30) NOT NULL Field Value

    Prompt Table: %EDITTABLE2

    6 FIELDVALUE3 Character(30) VARCHAR2(30) NOT NULL Field Value

    Prompt Table: %EDITTABLE3

    7 FIELDVALUE4 Character(30) VARCHAR2(30) NOT NULL Field Value

    Prompt Table: %EDITTABLE4

    8 FIELDVALUE5 Character(30) VARCHAR2(30) NOT NULL Field Value

    Prompt Table: %EDITTABLE5

    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    10 COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate
    11 BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate
    12 COST_MUP Number(30,6) DECIMAL(29,6) NOT NULL Cost Markup Rate
    13 BILL_MUP Number(30,6) DECIMAL(29,6) NOT NULL Billing Markup Rate