SCD_BLD_SECTS

(SQL Table)
Index Back

Builder Sections

Builder Sections

  • Related Language Record: SCD_BLDSCT_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_SECTION_ID Character(10) VARCHAR2(10) NOT NULL Section ID
    3 SCD_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID
    4 SCD_VERSION_NBR Number(5,0) INTEGER NOT NULL Version Number
    5 SCD_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Weight
    6 SCD_SCORE Signed Number(11,6) DECIMAL(9,6) NOT NULL Scorecarding Score
    7 SCD_WGT_OVER_SCORE Signed Number(11,6) DECIMAL(9,6) NOT NULL Weighted Overall Score
    8 SCD_SECT_TYPE Character(1) VARCHAR2(1) NOT NULL SCD Section Type
    C=Combo
    K=KPI
    S=Subjective

    Default Value: S

    9 SCD_SECTION_NAME Character(30) VARCHAR2(30) NOT NULL Section Name
    10 SCD_SEQ_NBR Number(5,0) INTEGER NOT NULL Sequence Number
    11 SCD_INSTRUCTIONS Long Character CLOB Instructions
    12 SCD_IDEAL_SCORE Number(10,6) DECIMAL(9,6) NOT NULL Ideal Score
    13 SCD_BENCHMRK_SCORE Number(10,6) DECIMAL(9,6) NOT NULL Benchmark Score
    14 SCD_RATIN_MODEL_ID Character(10) VARCHAR2(10) NOT NULL Rating Model ID
    15 SCD_INCLUDE_NA Character(1) VARCHAR2(1) NOT NULL Include Not Applicable Flag

    Y/N Table Edit

    Default Value: N

    16 SCD_SECTION_DESC Character(254) VARCHAR2(254) NOT NULL Section Description