EMPLIDEVALUATION_IDA=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved
HR_CM_APPR_VW(SQL View) |
Index Back |
|---|---|
EE Evaluations to be approvedThis view lists the employee evaluations requiring approval by the manager. |
| SELECT A.EMPLID , A.EVALUATION_ID , MAX(B.ACTION_DT_SS) , MAX(A.WF_STATUS) , MAX(B.ROLEUSER) , COUNT(DISTINCT C.COMPETENCY) FROM PS_CM_EVALUATIONS A , PS_HR_CM_EVAL_STA B , PS_COMPETENCIES C WHERE A.EMPLID = B.EMPLID AND A.EVALUATION_ID = B.EVALUATION_ID AND B.EMPLID = C.EMPLID AND B.EVALUATION_ID = C.EVALUATION_ID AND B.HR_WF_ACTION = ' ' AND A.WF_STATUS = 'S' AND B.TRANS_DT IS NULL AND B.CURRENT_STEP > 0 GROUP BY A.EMPLID, A.EVALUATION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EVALUATION_ID |
Character(2) | VARCHAR2(2) NOT NULL | Evaluation ID |
| 3 | ACTION_DT_SS | Date(10) | DATE | Termination Date |
| 4 | WF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Workflow Status
A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Rework S=Submitted V=Data Saved |
| 5 | ROLEUSER | Character(30) | VARCHAR2(30) NOT NULL | Role User |
| 6 | EVAL_COMP_CNT | Number(3,0) | SMALLINT NOT NULL | Competencies Assessed |