EP_SRCH_RTG_VW

(SQL View)
 Index Back

Appraisal Ratings


SELECT DOC.EP_APPRAISAL_ID , 'P' , DOC.RATING_MODEL , DOC.EP_CALC_METHOD , DOC.EP_PRE_REVW_RATING , DOC.EP_PRE_RATING , DOC.EP_PRE_POINTS , TYP.EP_REVW_DESCR %Concat ' - ' %Concat %Cast(DOC.PERIOD_BEGIN_DT, Date, Character) %Concat ' - ' %Concat %Cast(DOC.PERIOD_END_DT, Date, Character) FROM PS_EP_APPR DOC , PS_EP_REVW_TYP_TBL TYP WHERE DOC.EP_REVIEW_STATUS NOT IN ('CA','NS') AND TYP.EP_REVIEW_TYPE = DOC.EP_REVIEW_TYPE AND %EffdtCheck(EP_REVW_TYP_TBL TYP1,TYP,%CurrentDateIn) UNION SELECT DOC.EP_APPRAISAL_ID , 'R' , %Coalesce(SEC.RATING_MODEL ,' ') , %Coalesce(SEC.EP_CALC_METHOD ,' ') , %Coalesce(SEC.REVIEW_RATING ,' ') , %Coalesce(SEC.EP_RATING ,0) , %Coalesce(SEC.REVIEW_POINTS ,0) , TYP.EP_REVW_DESCR %Concat ' - ' %Concat %Cast(DOC.PERIOD_BEGIN_DT, Date, Character) %Concat ' - ' %Concat %Cast(DOC.PERIOD_END_DT, Date, Character) FROM (PS_EP_APPR DOC LEFT OUTER JOIN PS_EP_APPR_SECTION SEC ON DOC.EP_APPRAISAL_ID = SEC.EP_APPRAISAL_ID AND DOC.EP_MANAGER_ID = SEC.EP_REVIEWER_ID AND SEC.EP_ROLE = 'M' AND SEC.EP_SECTION_TYPE = 'SUMMARY') ,PS_EP_REVW_TYP_TBL TYP WHERE DOC.EP_REVIEW_STATUS NOT IN ('CA','NS') AND TYP.EP_REVIEW_TYPE = DOC.EP_REVIEW_TYPE AND %EffdtCheck(EP_REVW_TYP_TBL TYP1,TYP,%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID
2 EP_RATING_TYPE Character(1) VARCHAR2(1) NOT NULL Rating Type
P=Preliminary Rating
R=Review Rating
3 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model
4 EP_CALC_METHOD Character(1) VARCHAR2(1) NOT NULL Calculation method used - Summary, Average, Review Band
A=Average
R=Review Band
S=Summation
5 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating
6 EP_RATING Number(6,2) DECIMAL(5,2) NOT NULL Rating
7 REVIEW_POINTS Number(3,0) SMALLINT NOT NULL Review Points
8 EP_DOC_PERIOD Character(50) VARCHAR2(50) NOT NULL Document Period