EP_APPR_SS_VW2

(SQL View)
 Index Back

Appraisal SS Approval Details

This view includes the approval chain for all appraisals that have been submitted through the 8.4 framework.

SELECT A.EP_APPRAISAL_ID , C.EMPLID , C.EMPL_RCD , A.TRANSACTION_NAME , B.SS_GRP_ID , B.SS_TRANS_ID , B.SS_PROCESS_CYCLE , B.PROCESS_PATH , B.PROCESS_STEP , B.ROLEUSER , B.ROLEUSER_EMPLID , B.ROLENAME , B.PROCESS_ACTION , B.PROCESS_ACTION_DT , B.COMMENTS FROM PS_SS_DTL_EPM A , PS_SS_PROCESS_DTL B , PS_SS_KEYS C , PS_EP_APPR D WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND B.TRANSACTION_NAME = C.TRANSACTION_NAME AND A.SS_GRP_ID = B.SS_GRP_ID AND B.SS_GRP_ID = C.SS_GRP_ID AND A.SS_TRANS_ID = B.SS_TRANS_ID AND B.SS_TRANS_ID = C.SS_TRANS_ID AND A.SS_PROCESS_CYCLE = B.SS_PROCESS_CYCLE AND A.EP_APPRAISAL_ID = D.EP_APPRAISAL_ID AND D.EOAWDEFN_ID = ' ' AND (D.EP_APPROVAL_STATUS IN ('APRV', 'DENY') OR (D.EP_APPROVAL_STATUS = 'SUBM' AND D.EP_REVIEW_STATUS = 'CA')) AND B.PROCESS_ACTION <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
5 SS_GRP_ID Number(15,0) DECIMAL(15) NOT NULL Key Used in SS Framework
6 SS_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Key Used in SS Framework
7 SS_PROCESS_CYCLE Number(3,0) SMALLINT NOT NULL Used in SS Framework
8 PROCESS_PATH Character(3) VARCHAR2(3) NOT NULL Used in SS Framework
9 PROCESS_STEP Number(3,0) SMALLINT NOT NULL Used in SS Framework
10 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
11 ROLEUSER_EMPLID Character(11) VARCHAR2(11) NOT NULL Used in SS Framework
12 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
13 PROCESS_ACTION Character(1) VARCHAR2(1) NOT NULL Used in SS Framework
A=Approve
D=Deny
R=Recycle
S=Submit
14 PROCESS_ACTION_DT Date(10) DATE Process Action Date
15 COMMENTS Long Character CLOB Comment