HRS_APP_CMEVL_I(SQL View) |
Index Back |
---|---|
Applicant EvaluationAPP_CM_EVALS identifies each competency evaluation of your applicants. The evaluation is identified by an assigned EVALUATION_ID. Also, each evaluation has an EVALUATION_TYPE, an optional REVIEWER_ID, and a flag to identify whether or not the evaluation is active. |
SELECT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , A.EVALUATION_ID , A.EVALUATION_TYPE , A.REVIEWER_ID , A.DESCR50 , A.REVIEWER_APPRVD , A.REVIEW_DT , A.REVIEW_STATUS , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_APP_CM_EVAL A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | HRS_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
2 | HRS_PROFILE_SEQ | Number(3,0) | SMALLINT NOT NULL | Profile sequece |
3 | EVALUATION_ID | Character(2) | VARCHAR2(2) NOT NULL |
Evaluation ID
Default Value: 01 |
4 | EVALUATION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Evaluation Type
A=Approved/Official B=Subordinate C=Customer E=Executive Committee L=Learning M=Mentor P=Peer R=Supervisor/Manager S=Self |
5 | REVIEWER_ID | Character(11) | VARCHAR2(11) NOT NULL |
Reviewer ID
Prompt Table: PERSON_NAME |
6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
7 | REVIEWER_APPRVD | Character(1) | VARCHAR2(1) NOT NULL |
Reviewer is Approved
Y/N Table Edit Default Value: N |
8 | REVIEW_DT | Date(10) | DATE | Review Date |
9 | REVIEW_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Review Status
Y/N Table Edit Default Value: Y |
10 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
11 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
12 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
13 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |