SCD_EVTRFLAT_VW

(SQL View)
 Index Back

Builder Section Evaluators

Builder Section Evaluators

SELECT SCD_EVALUATION_ID , SCD_TEMPLATE_ID , SCD_VERSION_NBR , SCD_SECTION_ID , SELECT_FLAG , SCD_EVALUATOR_TYPE , SCD_EVALUATOR_ID , SCD_ALL_SECTN_FLG , SCD_EVALTOR_STATUS , SCD_MANDATORY_FLG FROM PS_SCD_BLDSCT_EVTR WHERE SCD_EVALUATOR_TYPE = 'IN' UNION SELECT DISTINCT SCD_EVALUATION_ID , SCD_TEMPLATE_ID , SCD_VERSION_NBR , SCD_SECTION_ID , SELECT_FLAG , 'IFR' , ROLEUSER , SCD_ALL_SECTN_FLG , SCD_EVALTOR_STATUS , SCD_MANDATORY_FLG FROM PS_SCD_BLDSCT_EVTR R , PSROLEUSER WHERE R.SCD_EVALUATOR_TYPE = 'RO' AND R.SCD_EVALUATOR_ID = PSROLEUSER.ROLENAME AND ROLEUSER NOT IN ( SELECT SCD_EVALUATOR_ID FROM PS_SCD_BLDSCT_EVTR ER WHERE ER.SCD_EVALUATION_ID = R.SCD_EVALUATION_ID AND ER.SCD_TEMPLATE_ID = R.SCD_TEMPLATE_ID AND ER.SCD_VERSION_NBR = R.SCD_VERSION_NBR AND ER.SCD_EVALUATOR_TYPE = 'IN')

  • Parent record: SCD_BLD_SECTS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCD_EVALUATION_ID Character(10) VARCHAR2(10) NOT NULL Evaluation ID
    2 SCD_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID
    3 SCD_VERSION_NBR Number(5,0) INTEGER NOT NULL Version Number
    4 SCD_SECTION_ID Character(10) VARCHAR2(10) NOT NULL Section ID
    5 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
    N=No
    Y=Yes
    6 SCD_EVALUATOR_TYPE Character(2) VARCHAR2(2) NOT NULL Evaluator Type
    IN=Individual
    RO=Role
    7 SCD_EVALUATOR_ID Character(30) VARCHAR2(30) NOT NULL Evaluator ID

    Prompt Table: %EDITTABLE

    8 SCD_ALL_SECTN_FLG Character(1) VARCHAR2(1) NOT NULL All Sections Flag - Mandatory

    Y/N Table Edit

    Default Value: Y

    9 SCD_EVALTOR_STATUS Character(2) VARCHAR2(2) NOT NULL Evaluator Status
    A=Active
    I=Inactive
    10 SCD_MANDATORY_FLG Character(1) VARCHAR2(1) NOT NULL Mandatory Flag

    Y/N Table Edit

    Default Value: Y