SCC_GE_CM_SCHVW

(SQL View)
 Index Back

Eval Management Cmte Schm View

Evaluation Management System: Evaluation Committee Scheme View Retrieves Committee Scheme (SCC_GE_CM_SCHEM) and the Order for an Evaluation Instance.

SELECT A.SCC_GE_INSTANCE_ID , 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 , B.SCC_GE_SCHEME_CALC , B.SCC_GE_PROC_ORDER ,A.SCC_GE_COMMENTS FROM PS_SCC_GE_CM_SCHEM A , PS_SCC_GE_EVALUATN E , PS_SCC_GE_EC_SCHEM B WHERE E.SCC_GE_INSTANCE_ID = A.SCC_GE_INSTANCE_ID AND B.SCC_GE_EVAL_CATGRY = E.SCC_GE_EVAL_CATGRY AND B.SCC_GE_EVALUATN_CD = E.SCC_GE_EVALUATN_CD AND B.SCC_GE_SCHEME_TYPE = '2' AND B.SCC_GE_SCHEME_NAME = A.SCC_GE_COMM_SCHEME AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_SCC_GE_EC_SCHEM C WHERE C.SCC_GE_EVAL_CATGRY = B.SCC_GE_EVAL_CATGRY AND C.SCC_GE_EVALUATN_CD = B.SCC_GE_EVALUATN_CD AND C.SCC_GE_SCHEME_TYPE = B.SCC_GE_SCHEME_TYPE AND C.SCC_GE_SCHEME_NAME = B.SCC_GE_SCHEME_NAME AND C.EFFDT <= E.SCC_GE_SETUP_DT)

  • 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_COMM_SCHEME Character(10) VARCHAR2(10) NOT NULL Committee Scheme

    Prompt Table: SCC_GE_EC_CM_SC

    3 SCC_GE_RTNG_SCHEME Character(10) VARCHAR2(10) NOT NULL Rating Scheme

    Prompt Table: SCC_GE_RTNG_VW2

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

    Prompt Table: SCC_GE_EC_STAT

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

    Prompt Table: SCC_GE_CMSC_RCM

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

    Prompt Table: PEOPLE_SRCH

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