FP_CI_EMPL_RVW(SQL View) |
Index Back |
|---|---|
EE Performance Reviews VwEmployee Review / Career view for adjustment - CI |
| SELECT E.EMPLID , E.EMPL_RCD , E.EFFDT , E.REVIEW_FROM_DT , E.REVIEW_THRU_DT , E.REVIEW_TYPE , E.EMPL_REVW_STATUS , E.FP_REV_RATING , C.FP_CORPS_CD FROM PS_EMPLOYEE_REVIEW E , PS_FPAEECAREER C WHERE E.EMPLID = C.EMPLID AND E.EMPL_RCD = C.EMPL_RCD AND C.EFFDT = ( SELECT MAX(CC.EFFDT) FROM PS_FPAEECAREER CC WHERE CC.EMPLID = C.EMPLID AND CC.EMPL_RCD = C.EMPL_RCD AND CC.EFFDT <= E.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 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 | 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 |
| 8 | FP_REV_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Rating |
| 9 | FP_CORPS_CD | Character(6) | VARCHAR2(6) NOT NULL | Corps |