SCC_GE_CM_INFVW

(SQL View)
 Index Back

Eval Management Eval Cmte View

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

SELECT A.SCC_GE_INSTANCE_ID , A.SCC_GE_COMM_SCHEME , A.SCC_GE_COMMITTEE , 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_COMM_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_COMM_ORDER , A.SCC_GE_COMMENTS FROM PS_SCC_GE_CM_INFO A , PS_SCC_GE_EVALUATN E , PS_SCC_GE_CMSC_CMT 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_COMM_SCHEME = A.SCC_GE_COMM_SCHEME AND B.SCC_GE_COMMITTEE = A.SCC_GE_COMMITTEE AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_SCC_GE_CMSC_CMT C WHERE C.SCC_GE_EVAL_CATGRY = B.SCC_GE_EVAL_CATGRY AND C.SCC_GE_COMM_SCHEME = B.SCC_GE_COMM_SCHEME AND C.SCC_GE_COMMITTEE = B.SCC_GE_COMMITTEE AND C.EFFDT <= E.SCC_GE_SETUP_DT)

  • Parent record: SCC_GE_CM_SCHEM

    • # 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_COMMITTEE Character(6) VARCHAR2(6) NOT NULL Committee Code

    Prompt Table: SCC_GE_COMM_DEF

    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_COMM_ADMIN Character(11) VARCHAR2(11) NOT NULL Committee 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_COMM_ORDER Number(3,0) SMALLINT NOT NULL Committee Routing Number
    18 SCC_GE_COMMENTS Long Character CLOB Comments