FO_MC_ART_REQ

(SQL Table)
 Index Back

Mass Assignment Rate Changes

Mass Assignment Rate Changes Request.

  • Parent Record Of FO_MC_ART_RT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FO_MC_USR_TYPE Character(10) VARCHAR2(10) NOT NULL User Mass Change Type

    Prompt Table: FO_MC_TYPE_TBL

    2 FO_MC_REQ_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Request ID.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 FO_MC_STATUS Character(1) VARCHAR2(1) NOT NULL Mass Change Request Status: N: New O: Open S: Submitted
    N=New
    O=Open
    S=Submitted
    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    6 RATE_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Rate Profile ID

    Prompt Table: FO_RATE_PROF_VW

    7 FO_RATE_EFFDT Date(10) DATE Assignment Rate Effective Date
    8 COMMENTS_2000 Long Character CLOB Comment Text
    9 FO_RATE_TYPE_FLG Character(1) VARCHAR2(1) NOT NULL Rate Type Indicator
    B=Bill Rate
    P=Pay Rate

    Default Value: P

    10 FO_RATE_MULT Signed Number(8,3) DECIMAL(6,3) NOT NULL Indicates a Multiplier Factor in terms of % by which a Pay or Bill Rate will be Increased or Decreased. Used in Mass Assignment Rate Changes.
    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    12 FO_DEFAULT_RATE Number(16,3) DECIMAL(15,3) NOT NULL Default Pay Rate
    13 FO_TARGET_MARGIN Number(7,3) DECIMAL(6,3) NOT NULL Target Margin
    14 PB_MARKUP Signed Number(11,6) DECIMAL(9,6) NOT NULL Mark Up %
    15 FO_MC_SUBMIT_FLAG Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether to submit or not the Mass Change for Updates. Used in Staffing Mass Assignment Rates Changes.

    Y/N Table Edit

    Default Value: N

    16 FO_MC_AUDIT_FLAG Character(1) VARCHAR2(1) NOT NULL Flag to determine whether to create or not an Audit Report. Used in Mass Assignment Rate Changes.

    Y/N Table Edit

    Default Value: Y

    17 UPDATE_FLAG Character(1) VARCHAR2(1) NOT NULL Update Prior Operations

    Y/N Table Edit

    Default Value: Y

    18 WARNING_FLAG Character(1) VARCHAR2(1) NOT NULL Warning Flag

    Y/N Table Edit

    Default Value: Y

    19 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    20 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    21 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    22 FO_MCR_REASON Character(5) VARCHAR2(5) NOT NULL Master Contract Rates Non-Compliance Reason

    Prompt Table: FO_MCR_REAS_VW