HR_CM_EVAL_STA

(SQL Table)
Index Back

CM Evaluation Approvals

Competency Evaluation Approvals

# 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 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 APPR_STEP Character(3) VARCHAR2(3) NOT NULL Approval Step
1=Approval Step 1
2=Approval Step 2
3=Approval Step 3
4=Approval Step 4
5=Approval Step 5
6=Approval Step 6
7=Approval Step 7
8=Approval Step 8
9=Approval Step 9
6 APPR_PATH Character(3) VARCHAR2(3) NOT NULL Approval Path
A=Approval Path A
B=Approval Path B
C=Approval Path C
D=Approval Path D
E=Approval Path E
7 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
8 EMPLID_TO Character(11) VARCHAR2(11) NOT NULL EmplID To
9 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
10 HR_WF_ACTION Character(3) VARCHAR2(3) NOT NULL Workflow Action
APV=Approved
CAN=Cancelled by Originator
DNY=Denied
PND=Pending
PSH=Push back for rework
RAS=Reassign
SAV=Saved For Later-Not Submitted
SUB=Submitted
11 TRANS_DT Date(10) DATE Transaction Date
12 CURRENT_STEP Number(3,0) SMALLINT NOT NULL Current Step Number
13 COMMENTS Long Character CLOB Comment