EP_OLD_REVW_VW(SQL View) |
Index Back |
|---|---|
Old "Salary Planning" ReviewsThis view is used in the ePerformance Management GetAllReviews() function to return information about "obsolete Salary Planning" reviews in the newer ePerformance format. |
| SELECT A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.REVIEW_FROM_DT ,A.REVIEW_THRU_DT ,A.REVIEW_TYPE ,A.RATING_SCALE ,A.REVIEW_RATING ,A.TOTAL_EE_POINTS ,A.EMPL_REVW_STATUS ,A.RES_RVW_BAND_CD ,A.FINAL_RVW_BAND_CD ,A.GB_GROUP_ID ,A.GVT_OPM_RATING ,A.FP_REV_RATING ,B.REVW_SCALE_TYPE ,B.RATING_MODEL ,C.SETID_SALARY ,C.REG_REGION FROM PS_EMPLOYEE_REVIEW A , PS_REVW_SCALE_TBL B , PS_JOB C WHERE C.EMPLID = A.EMPLID AND C.EMPL_RCD = A.EMPL_RCD AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_JOB C1 WHERE C1.EMPLID = C.EMPLID AND C1.EMPL_RCD = C.EMPL_RCD AND C1.EFFDT <= A.EFFDT) AND C.EFFSEQ = ( SELECT MAX(C2.EFFSEQ) FROM PS_JOB C2 WHERE C2.EMPLID = C.EMPLID AND C2.EMPL_RCD = C.EMPL_RCD AND C2.EFFDT = C.EFFDT) AND B.RATING_SCALE = A.RATING_SCALE AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_REVW_SCALE_TBL B1 WHERE B1.RATING_SCALE = B.RATING_SCALE AND B1.EFFDT <= A.EFFDT) AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_EMPLOYEE_REVIEW A1 WHERE A1.EMPLID = A.EMPLID AND A1.EMPL_RCD = A.EMPL_RCD AND A1.REVIEW_FROM_DT = A.REVIEW_FROM_DT AND A1.REVIEW_THRU_DT = A.REVIEW_THRU_DT AND A1.REVIEW_TYPE = A.REVIEW_TYPE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | REVIEW_FROM_DT | Date(10) | DATE | Review Period From |
| 5 | REVIEW_THRU_DT | Date(10) | DATE | Review Period To |
| 6 | REVIEW_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Review Type
A=Self Assesssment B=Both E=Employee Feedback I=Initial Rating M=Interim Rating O=Official Rating P=Performance R=Adjustment Result S=Salary Default Value: S |
| 7 | RATING_SCALE | Character(4) | VARCHAR2(4) NOT NULL | Rating Scale |
| 8 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | Review Rating |
| 9 | TOTAL_EE_POINTS | Number(3,0) | SMALLINT NOT NULL | Total Review Points |
| 10 | EMPL_REVW_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Employee Review Status
A=Approved I=Ineligible N=No Increase P=Proposed R=Processed Default Value: P |
| 11 | RES_RVW_BAND_CD | Character(1) | VARCHAR2(1) NOT NULL | Resulting Review Band |
| 12 | FINAL_RVW_BAND_CD | Character(1) | VARCHAR2(1) NOT NULL | Final Review Band |
| 13 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 14 | GVT_OPM_RATING | Character(1) | VARCHAR2(1) NOT NULL |
Review Rating
1=Level I 2=Level II 3=Level III 4=Level IV 5=Level V X=Not Rated Z=Exclusion |
| 15 | FP_REV_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Rating |
| 16 | REVW_SCALE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Review Scale Type
A=Average R=Review Band S=Summation |
| 17 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL | Rating Model |
| 18 | SETID_1 | Character(5) | VARCHAR2(5) NOT NULL | Setid used to build the Template for entering Bulk Positive Input |
| 19 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |