SCD_USR_EVAL_VW

(SQL View)
Index Back

Evaluation Header

Evaluation Header

SELECT A.SCD_EVALUATION_ID , A.SCD_EVALUATOR_ID , A.SCD_EVALTEE_SETID , A.SCD_EVALUATEE_ID , A.SCD_EVAL_NAME , CASE WHEN A.SCD_RESP_STATUS = 'OM' THEN 'SU' ELSE A.SCD_RESP_STATUS END , A.SCD_OWNER_ID , A.SCD_CAL_SETID , A.CALENDAR_ID , A.SCD_EVAL_YEAR , A.SCD_EVAL_PERIOD , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.SCD_FROM_DATE , A.SCD_TO_DATE , A.SCD_TEMPLATE_ID , A.SCD_VERSION_NBR , A.SCD_TEMPLATE_NAME , A.SCD_TEMPLATE_TYPE , A.SCD_EVAL_STATUS , A.SCD_DUE_DATE , CASE WHEN A.SCD_DUE_DATE < %CurrentDateIn THEN 'Y' ELSE 'N' END , A.SCD_ALLOW_DECLINES , A.SCD_TARGET_PCT , A.SCD_TARGET_QTY , A.SCD_ACCEPT_FLG , B.VENDOR_NAME_SHORT , B.NAME1 , ' ' , C.DESCR , D2.XLATLONGNAME , A.SCD_EVALUATOR_ID FROM PS_SCD_USREV_HD_VW A LEFT OUTER JOIN PS_CAL_DEFN_TBL C ON (C.SETID = A.SCD_CAL_SETID AND C.CALENDAR_ID = A.CALENDAR_ID) , PS_VENDOR B , PSXLATITEM D2 WHERE B.SETID = A.SCD_EVALTEE_SETID AND B.VENDOR_ID = A.SCD_EVALUATEE_ID AND D2.FIELDNAME = 'SCD_RESP_STATUS' AND D2.FIELDVALUE = (CASE WHEN A.SCD_RESP_STATUS = 'OM' THEN 'SU' ELSE A.SCD_RESP_STATUS END) AND D2.EFF_STATUS = 'A' AND D2.EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEM XL WHERE XL.FIELDNAME = D2.FIELDNAME AND XL.FIELDVALUE = (CASE WHEN A.SCD_RESP_STATUS = 'OM' THEN 'SU' ELSE A.SCD_RESP_STATUS END))

  • Related Language Record: SCD_USREVLNG_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCD_EVALUATION_ID Character(10) VARCHAR2(10) NOT NULL Evaluation ID
    2 SCD_EVALUATOR_ID Character(30) VARCHAR2(30) NOT NULL Evaluator ID

    Prompt Table: %EDITTABLE2

    3 SCD_EVALTEE_SETID Character(5) VARCHAR2(5) NOT NULL Evaluatee Set ID
    4 SCD_EVALUATEE_ID Character(30) VARCHAR2(30) NOT NULL Evaluatee ID
    5 SCD_EVAL_NAME Character(30) VARCHAR2(30) NOT NULL Evaluation Name
    6 SCD_RESP_STATUS Character(2) VARCHAR2(2) NOT NULL Evaluation Build Status
    AL=All
    DE=Declined
    IP=In Process
    NE=New
    OM=Omitted
    PE=Pending
    SU=Submitted

    Default Value: NE

    7 SCD_OWNER_ID Character(30) VARCHAR2(30) NOT NULL Owner ID

    Prompt Table: PSOPRDEFN_SRCH

    8 SCD_CAL_SETID Character(5) VARCHAR2(5) NOT NULL Calendar Set ID

    Prompt Table: SP_SETID_NONVW

    9 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

    Prompt Table: CAL_DEFN_TBL

    10 SCD_EVAL_YEAR Number(4,0) SMALLINT NOT NULL Evaluation Year
    11 SCD_EVAL_PERIOD Number(3,0) SMALLINT NOT NULL Evaluation Period.
    12 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    13 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
    14 SCD_FROM_DATE Date(10) DATE From Date
    15 SCD_TO_DATE Date(10) DATE To Date
    16 SCD_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID

    Prompt Table: SCD_TEMPLATE_HD

    17 SCD_VERSION_NBR Number(5,0) INTEGER NOT NULL Version Number
    18 SCD_TEMPLATE_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
    19 SCD_TEMPLATE_TYPE Character(15) VARCHAR2(15) NOT NULL Template Type

    Prompt Table: SCD_TMPL_TYPES

    20 SCD_EVAL_STATUS Character(2) VARCHAR2(2) NOT NULL Evaluation Build Status
    OP=Pending and Released
    PE=Pending
    PO=Posted
    RE=Released
    WD=Withdrawn
    21 SCD_DUE_DATE Date(10) DATE Due Date
    22 PAST_DUE_FLG Character(1) VARCHAR2(1) NOT NULL Past Due Flag
    23 SCD_ALLOW_DECLINES Character(1) VARCHAR2(1) NOT NULL Allow Declines Flag

    Y/N Table Edit

    Default Value: Y

    24 SCD_TARGET_PCT Number(10,6) DECIMAL(9,6) NOT NULL Target Percent
    25 SCD_TARGET_QTY Number(3,0) SMALLINT NOT NULL Target Quantity
    26 SCD_ACCEPT_FLG Character(1) VARCHAR2(1) NOT NULL Accept Flag

    Y/N Table Edit

    Default Value: Y

    27 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    28 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    29 SCD_VIEW_TYPE Character(1) VARCHAR2(1) NOT NULL View Evaluation Type
    R=Read Only
    30 CALENDAR_ID_DESCR Character(30) VARCHAR2(30) NOT NULL Description
    31 STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL Status Description
    32 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).