SCC_GE_SCHORDVW

(SQL View)
 Index Back

Eval Management Scheme Order

Evaluation Management System Scheme Order View. Used to return a list of Committee and Individual Schemes for an Evaluation in Processing Order.

SELECT A.SCC_GE_INSTANCE_ID , '2' , A.SCC_GE_COMM_SCHEME , A.SCC_GE_RTNG_SCHEME , A.SCC_GE_EVAL_STATUS , A.SCC_GE_EVAL_DT , A.SCC_GE_RECOMMENDTN , A.OVERALL_RATING , A.SCC_GE_OVERALL_RTG , A.SCC_GE_CMPLTD_DTTM , A.SCC_GE_CMPLT_OPRID , A.SCC_GE_SCHEM_ADMIN , A.SCC_NTFREQ_ID , A.SCC_ROW_ADD_OPRID , A.SCC_ROW_ADD_DTTM , A.SCC_ROW_UPD_OPRID , A.SCC_ROW_UPD_DTTM , A.SCC_GE_SCHEME_CALC , A.SCC_GE_PROC_ORDER ,A.SCC_GE_COMMENTS FROM PS_SCC_GE_CM_SCHVW A UNION ALL SELECT B.SCC_GE_INSTANCE_ID , '3' , B.SCC_GE_IE_SCHEME , B.SCC_GE_RTNG_SCHEME , B.SCC_GE_EVAL_STATUS , B.SCC_GE_EVAL_DT , B.SCC_GE_RECOMMENDTN , B.OVERALL_RATING , B.SCC_GE_OVERALL_RTG , B.SCC_GE_CMPLTD_DTTM , B.SCC_GE_CMPLT_OPRID , B.SCC_GE_SCHEM_ADMIN , B.SCC_NTFREQ_ID , B.SCC_ROW_ADD_OPRID , B.SCC_ROW_ADD_DTTM , B.SCC_ROW_UPD_OPRID , B.SCC_ROW_UPD_DTTM , B.SCC_GE_SCHEME_CALC , B.SCC_GE_PROC_ORDER , B.SCC_GE_COMMENTS FROM PS_SCC_GE_IE_SCHVW B

  • Parent record: SCC_GE_EVALUATN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_GE_INSTANCE_ID Number(16,0) DECIMAL(16) NOT NULL Evaluation Instance
    2 SCC_GE_SCHEME_TYPE Character(1) VARCHAR2(1) NOT NULL Scheme Type
    1=Auto-Calculated
    2=Committee
    3=Individual Evaluator
    3 SCC_GE_SCHEME_NAME Character(10) VARCHAR2(10) NOT NULL Scheme Name
    4 SCC_GE_RTNG_SCHEME Character(10) VARCHAR2(10) NOT NULL Rating Scheme

    Prompt Table: SCC_GE_RTNG_VW3

    5 SCC_GE_EVAL_STATUS Character(6) VARCHAR2(6) NOT NULL Evaluation Status

    Prompt Table: SCC_GE_EC_STAT

    6 SCC_GE_EVAL_DT Date(10) DATE Status Date
    7 SCC_GE_RECOMMENDTN Character(10) VARCHAR2(10) NOT NULL Recommendation Value

    Prompt Table: SCC_GE_IESC_RCM

    8 OVERALL_RATING Number(6,2) DECIMAL(5,2) NOT NULL Overall Rating
    9 SCC_GE_OVERALL_RTG Number(12,3) DECIMAL(11,3) NOT NULL Overall Rating
    10 SCC_GE_CMPLTD_DTTM DateTime(26) TIMESTAMP Completed Date
    11 SCC_GE_CMPLT_OPRID Character(30) VARCHAR2(30) NOT NULL Completed By
    12 SCC_GE_SCHEM_ADMIN Character(11) VARCHAR2(11) NOT NULL Scheme Administrator

    Prompt Table: PEOPLE_SRCH

    13 SCC_NTFREQ_ID Number(16,0) DECIMAL(16) NOT NULL Notification ID
    14 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    15 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    16 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    17 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    18 SCC_GE_SCHEME_CALC Character(1) VARCHAR2(1) NOT NULL Calculate Option
    1=On-going
    2=When Complete
    19 SCC_GE_PROC_ORDER Number(3,0) SMALLINT NOT NULL Processing Order
    20 SCC_GE_COMMENTS Long Character CLOB Comments