SCD_USR_EVAL_HD

(SQL Table)
Index Back

Evaluation Header

Evaluation Header

  • Related Language Record: SCD_EVAL_HD_LNG
  • Parent record: SCD_BLD_EVAL_HD
  • # 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_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: SU

    4 SCD_STATUS_DTTM DateTime(26) TIMESTAMP Status Date Time
    5 SCD_SENT_DATE Date(10) DATE Sent Date
    6 SCD_SUBMITTED_DATE Date(10) DATE Submitted Date
    7 SCD_DECLINED_DATE Date(10) DATE Declined Date
    8 SCD_OMITTED_DATE Date(10) DATE Omitted Date
    9 SCD_LAST_REMIND_DT Date(10) DATE Last Reminded Date
    10 SCD_ACCEPT_FLG Character(1) VARCHAR2(1) NOT NULL Accept Flag

    Y/N Table Edit

    Default Value: Y

    11 SCD_SCORE Signed Number(11,6) DECIMAL(9,6) NOT NULL Scorecarding Score
    12 SCD_COMMENTS_LONG Long Character CLOB Long Description