RS_PE_RSFU_PRS

(SQL Table)
 Index Back

PE for Forecast vs. Actual

  • Parent Record Of RS_PE_RSAU_DEPT RS_PE_RSAU_LOC RS_PE_RSFU_DEPT RS_PE_RSFU_LOC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Default

    Y/N Table Edit

    Default Value: Y

    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: RS_AGG_DEF_VW

    4 RS_BU_SOURCE Character(1) VARCHAR2(1) NOT NULL Business Unit
    A=All HR Business Units
    S=Specify
    U=User Preferences

    Default Value: U

    5 NUMBER_PERIODS_EX Character(2) VARCHAR2(2) NOT NULL Number of Past Periods
    01=01
    02=02
    03=03
    04=04
    05=05
    06=06
    07=07
    08=08
    09=09
    10=10
    11=11
    12=12
    6 RS_DEPT_LOC_IND Character(1) VARCHAR2(1) NOT NULL By Department
    D=By Department
    L=By Location

    Default Value: D

    7 TARGET_PER Signed Number(7,2) DECIMAL(5,2) NOT NULL Added for CN#WV802-2.0
    8 WARNING_PERCENT Number(3,0) SMALLINT NOT NULL The percentage of the target threshold that would trigger a warning.

    Default Value: 0

    9 SHOW_ALERT_IND Character(1) VARCHAR2(1) NOT NULL Indicator to determine whether to always show threshold alert or only when in Alert condition.
    N=No
    Y=Only if Alert

    Default Value: N